Children in Part-Time Early Childhood Education in Day Care Centres (Services Funded by Municipality) as of 31st December

This dataset collection provides a comprehensive aggregation of data pertaining to children aged at least 7 years, who are partaking in part-time early childhood education and care in day care centres, as of 31st December, with services financed by the municipality. The data tables in the collection are sourced from the Sotkanet website in Finland. They offer an in-depth view into the subject matter, presenting a wealth of information organized in a tabular format for easy analysis and interpretation.

Tables

Historical Data on Part-time Early Childhood Education and Care in Day Care Centres for Children Aged 7+ (Paid by Municipality)TSV
The 'table__history' is a comprehensive collection of data, specifically serving as a history table, which encapsulates the version history of its base table rows. It belongs to a larger dataset focused on children at least 7 years old participating in part-time early childhood education and care in day care centres on 31st December, with services paid for by the municipality. This rich data is sourced from the website 'Sotkanet', based in Finland. The table is organized into various columns that provide detailed insight into the subject matter. For instance, one column stores the row number from the raw data, which in conjunction with the date of data extraction, provides a unique identifier for each row in this version history table. The table also includes columns for the start and...
Part-Time Early Childhood Education and Care Participation of Children Aged 7 or Older in Finnish Municipal Day Care Centres as of December 31TSV
The table is a component of a dataset collection that provides insights into children at least 7 years old who are participating in part-time early childhood education and care in day care centres as of 31st December, with the services being paid for by the municipality. The data originates from Sotkanet, a source based in Finland. It does not include children using service vouchers for early childhood education and care, or those receiving private day care allowance from Kela. The table offers both full-time and part-time data, with full-time defined as over 5 hours per day or over 107.5 hours per month, and part-time defined as up to 5 hours per day or up to 107.5 hours per month. The data in the table is categorized according to year, region, and gender, giving us a comprehensive...

Column Descriptions

Part-Time Early Childhood Education and Care Participation of Children Aged 7 or Older in Finnish Municipal Day Care Centres as of December 31

Column	Type	Comment
_extract_date	date	This column represents the date when the data on a particular row was extracted from the Sotkanet website, based in Finland. The extraction date helps track when the data was last updated.
_row_number	long	This column contains a unique identifier for each row in the table. It represents the row number in the data extracted from the source on the extraction date specified by the '_extract_date' column. This ensures that each row can be uniquely identified.
year	int	This column specifies the year to which the data pertains. It provides a temporal context for the other information contained within the row.
region	int	The 'region' column refers to specific geographical areas in Finland. Each region is represented by a unique numerical code.
gender	string	The 'gender' column indicates the gender category for the data in the row. In this case, it refers to the total of all gender categories.
value_abs	int	The 'value_abs' column contains the count of children at least 7 years old participating in part-time early childhood education and care in day care centres on 31st December, with services paid for by the municipality.
absolute_value	string	The 'absolute_value' column would typically contain absolute measurements or counts; however, in this table, it does not contain any values.

Historical Data on Part-time Early Childhood Education and Care in Day Care Centres for Children Aged 7+ (Paid by Municipality)

Column	Type	Comment
_start_date	date	This column contains the date when the row was extracted from Sotkanet's website. It forms a unique combination with the '_row_number' to identify each row in this version history table. This is a special column that is part of the version history of the base table.
_end_date	date	This column contains the date when a new version of the row was extracted from Sotkanet's website. If the value is null, it indicates that the row is the most recent version. This is another special column added for tracking the version history of the base table.
_row_number	long	This column contains the row number as it appears in the raw data from the Sotkanet's website. It uniquely identifies the row in combination with the '_start_date'.
year	int	This column indicates the year associated with each row of data.
region	int	The 'region' column represents numerical codes for different regions.
gender	string	This column records the gender category the data pertains to. In this table, it is consistently set to 'total'.
value_abs	int	The 'value_abs' column records numerical values related to part-time early childhood education and care in day care centres.
absolute_value	string	The 'absolute_value' column is expected to contain numerical data, however, no sample values are provided.

Additional Info

Last Updated	November 8, 2024
Created	November 8, 2024