Version History of Child Welfare Institutions - Children and Young People in Services Funded by the Municipality on 31st December up to 2014

To download the data set, please sign up or log in

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_datedateThe date when the row was extracted from the data source
_end_datedateThe 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_numberlongThe number of the row in the raw data extracted from the data source
yearintThe year corresponding to the data entry
regionintThe region associated with the data entry
genderstringThe gender associated with the data entry
value_absintThe absolute value of the data entry
absolute_valuestringAn alternate representation of the absolute value of the data entry

No sample for this dataset

Additional Information

Last updated May 22, 2024
Created May 22, 2024
License No License Provided
Geographic coverage
Geographic granularity
Temporal coverage from
Temporal coverage to
Temporal coverage to
Adapterdelta
Countryfi
Databasefi_sotkanet
Extract date2019-03-05
Ide6e78ada-1d33-43e7-bfd3-d72ea25ad457
Package idc75ad222-19dc-4536-b2a2-9af731c8d92a
Position2
Revision id1b9d2a90-425b-44aa-b6a9-c3ddfbdc59ec
Stateactive
Tablechild_welfare_institutions_children_and_young_people_in_services_funded_by_the_municipality_on_31_dec_up_to_2014__table__history