Version History of Child Welfare Institutions - Children and Young People in Services Funded by the Municipality on 31st December up to 2014
Click here for a data sample
This table contains the version history of rows in the child welfare institutions for children and young people in services funded by the municipality on 31 December up to 2014. The data is sourced from the 'Sotkanet' website, originating from Finland. Each row in the table is uniquely identified by the combination of '_start_date' and '_row_number'. The '_start_date' column represents the extraction date of the row from the data source, while the '_end_date' column indicates the date when a newer version of the row was extracted. If the '_end_date' value is null, it means that the row represents the most recent version. The table includes additional columns such as 'year', 'region', 'gender', 'value_abs', and 'absolute_value'. The data in this table can be utilized for various data analytics purposes, such as examining trends in the number of children and young people in different regions over time, analyzing gender distributions in different age groups, or comparing absolute values of children and young people in services funded by the municipality across years and regions.
Field Descriptions
Name |
Data type |
Description |
_start_date | date | The date when the row was extracted from the data source |
_end_date | date | The date when a new version of the row was extracted from the data source. If null, it means that the row is the most recent version of the row |
_row_number | long | The number of the row in the raw data extracted from the data source |
year | int | The year corresponding to the data entry |
region | int | The region associated with the data entry |
gender | string | The gender associated with the data entry |
value_abs | int | The absolute value of the data entry |
absolute_value | string | An alternate representation of the absolute value of the data entry |