Full-time Early Childhood Education Participation of Children Aged 7 and Above in Day Care Centers Funded by Municipalities as of December 31

This dataset collection includes a group of related data tables that provides detailed information about children who are at least 7 years old and are participating in full-time early childhood education and care in day care centres as of 31st December. Notably, these services are paid for by the municipality. The data in these tables has been gathered from the 'Sotkanet' website, based in Finland. Each table in this collection is organized in a manner that allows for comprehensive analysis and understanding of the data, presenting related data in rows and columns.

Tables

Full-time Early Childhood Education Participation of Children at Least 7 Years Old in Day Care Centres, Financed by MunicipalityTSV
The table, sourced from the Finnish website 'Sotkanet', provides an in-depth insight into the participation of children who are at least 7 years old in full-time early childhood education and care in day care centers as of December 31. The data for this information is paid for by the municipality. It's important to note that the recorded data does not include children using early childhood education and care service vouchers or those who have received private day care allowance from Kela. The table also distinguishes between full-time and part-time early childhood education and care, with full-time regarded as education and care that lasts over 5 hours per day or over 107.5 hours per month, and part-time being that which lasts at most 5 hours per day or 107.5 hours per month. The data...
Historical Data on Full-Time Early Childhood Education Participation for Children Over 7 in Municipality-Funded Day Care CentresTSV
The 'table__history' is part of the dataset collection that focuses on children at least 7 years old participating in full-time early childhood education and care in day care centres on 31 December, with services paid for by the municipality. This history table provides a comprehensive version history of its base table rows, allowing for a detailed understanding of changes over time. The data is sourced from the Sotkanet website in Finland. The table includes a unique identification for each row, generated by combining the date of extraction and the row number from the raw data. This ensures each version of a row is distinct and traceable. The extraction date signifies when the data was collected, while the end date indicates when a new version of the data was sourced. In cases where...

Column Descriptions

Full-time Early Childhood Education Participation of Children at Least 7 Years Old in Day Care Centres, Financed by Municipality

Column	Type	Comment
_extract_date	date	This column records the date when the data on the row was extracted from the source. It helps in understanding when the specific data was pulled for analysis.
_row_number	long	This column represents the row number of the data extracted from the source on the specific extract date. Together with the extract date, these two columns uniquely identify each row of data.
year	int	This column indicates the year in which the data was recorded. It provides a temporal context to the data, allowing for analysis across different years.
region	int	This column denotes the region code where the data was collected. It allows for geographical analysis of the data.
gender	string	This column specifies the gender category to which the data corresponds. In this dataset, it refers to total, implying data is aggregated for all genders.
value_abs	int	This column contains numerical values related to the dataset. The actual meaning of these values is not specified in the background information.
absolute_value	string	This column is expected to contain absolute values related to the dataset, however, no sample values are provided in the context.

Historical Data on Full-Time Early Childhood Education Participation for Children Over 7 in Municipality-Funded Day Care Centres

Column	Type	Comment
_start_date	date	This column indicates the date when the row was extracted from the data source. It is one of the unique identifiers for each row in this version history table, the other being '_row_number'.
_end_date	date	This refers to the date when a new version of the row was extracted from the data source. If a row has a null value in this column, it signifies that it is the most recent version of the row.
_row_number	long	The '_row_number' column contains the number of the row as it appears in the raw data extracted from the data source. This number, in combination with '_start_date', uniquely identifies each row in this version history table.
year	int	The 'year' column houses the year to which the data in the row pertains.
region	int	This column signifies the region code to which the data in the row is applicable.
gender	string	The 'gender' column indicates the gender classification for which the data in the row is relevant. In this case, all data is relevant to all genders (total).
value_abs	int	This column contains a numerical value that is part of the data extracted. The meaning of this value is dependent on the context of the data set.
absolute_value	string	The 'absolute_value' column has a numerical value or a null value. The interpretation of this value is dependent on the context of the data set.

Additional Info

Last Updated	November 8, 2024
Created	November 8, 2024