Children Aged 7+ in Full-Time Early Childhood Education & Care in Family Day Care, Funded by Municipality, as of Dec 31

This dataset collection contains information pertaining to children who are at least 7 years old and are enrolled in full-time early childhood education and care in family day care as of 31st December, with the services being paid for by the municipality. The data is organized in tables, each of which contains related information presented in rows and columns. The data for these tables has been sourced from the website of Sotkanet (Sotkanet Data Service) located in Finland.

Tables

Children Aged 7+ in Full-Time Early Childhood Education and Family Day Care Paid by Municipality as of 31st DecemberTSV
The table, sourced from 'Sotkanet' of Finland, provides in-depth insights into full-time early childhood education and care services paid for by the municipality. It specifically focuses on children at least 7 years old and is part of a comprehensive dataset collection on family day care as of 31st December, each year. The data ranges across various years and regions, with 'total' representing the gender of children involved. The content of the table does not include children using service vouchers or those who have received a private day care allowance. Full-time care is defined as education that lasts over 5 hours per day or over 107.5 hours per month. The data cover services that the municipality provides itself or purchases from other entities, like other municipalities, joint...
History of Children Aged 7 or More Participating in Full-Time Early Childhood Education & Care in Family Day Care, Paid by MunicipalityTSV
The 'table__history' is a comprehensive collection of historical data related to early childhood education and care for children at least 7 years old, specifically focusing on full-time family day care services paid for by the municipality. This table contains crucial information about the number of services the municipality has paid for its residents, accounting for sales reductions and purchase additions. The table doesn't include children using service vouchers or those receiving private day care allowance. Full-time services are those exceeding 5 hours per day or 107.5 hours per month. The table's columns offer a wealth of information pertinent to the study. Unique identifiers for each row in the table are a combination of the '_start_date' and the '_row_number', which represent the...

Column Descriptions

Children Aged 7+ in Full-Time Early Childhood Education and Family Day Care Paid by Municipality as of 31st December

Column	Type	Comment
_extract_date	date	This column provides information on the date when the data on the row was extracted from the source. It forms a part of the unique identifier for each row when combined with the '_row_number' column.
_row_number	long	This column signifies the row number in the data extracted from the source on the extract date specified by the '_extract_date' column. It forms a part of the unique identifier for each row when combined with the '_extract_date' column.
year	int	This column represents the year in which the data was collected.
region	int	This column indicates the region code associated with the data collected. Each unique code stands for a specific region.
gender	string	This column indicates the gender category for which the data was collected. In this dataset, the category is 'total', implying that the data applies to all genders.
value_abs	int	This column records a binary value, either 0 or 1, representing certain characteristics or conditions related to the data.
absolute_value	string	This column is intended to contain the absolute value associated with the data. In this particular table, however, it appears to be empty or contains 'None' values.

History of Children Aged 7 or More Participating in Full-Time Early Childhood Education & Care in Family Day Care, Paid by Municipality

Column	Type	Comment
_start_date	date	Contains the date when the row was extracted from the data source. Together with '_row_number', it forms a unique identifier for each row in the history table.
_end_date	date	Contains the date when a new version of the row was extracted from the data source. A null value indicates that the row is the most recent version.
_row_number	long	Represents the position of the row in the raw data extracted from the data source. Together with '_start_date', it forms a unique identifier for each row in the history table.
year	int	Denotes the year associated with the data in the row. It could vary from years in the late 1990s to mid 2010s.
region	int	Represents the geographical region associated with the data in the row. The regions are denoted by unique numeric codes.
gender	string	Indicates the gender group that the data in the row is associated with. In this case, all data is associated with the total of all gender groups.
value_abs	int	Contains a value presumably representing certain data, possibly a count or measure, associated with the row. In the sample, all values were zero.
absolute_value	string	Seemingly intended to contain absolute values corresponding to the 'value_abs' column, but in the sample, all values were null.

Additional Info

Last Updated	November 8, 2024
Created	November 8, 2024