Child Welfare Institutions care days for Children and Young People in Services Purchased from Joint Municipal Boards during Year up to 2014

The dataset collection contains information about the care days for children and young people in child welfare institutions, which were provided through services purchased from joint municipal boards during the year up to 2014. The dataset table, named 'Child Welfare Institutions care days for Children and Young People in Services Purchased from Joint Municipal Boards during Year up to 2014', is part of this collection. The dataset tables in this collection are sourced from the web site of 'Sotkanet' in Finland.

Tables

Child Welfare Institutions care days for Children and Young People in Services Purchased from Joint Municipal Boards during Year up to 2014TSV
The indicator gives the total number of care days in municipally funded child welfare institutions (children's homes, reform schools, youth homes etc.) during the year. Care days consist of client arrival days and attendance days, excluding departure days.Municipally funded institutional care in child welfare refers to the volume of services that the municipality has financed for its inhabitants. In calculating municipally funded services, any sales have been deducted from and purchases added to the municipality´s own production. The data are available according to the following classification: 1. "Municipality´s own services" refers to services produced in the municipality´s own units. 2. "Services sold by the municipality" refers to the sale of the services mentioned under item 1 to...
Version History of Child Welfare Institutions Care Days for Children and Young People in Services Purchased from Joint Municipal Boards during Year up to 2014TSV
This table contains the version history of rows for child welfare institutions' care days for children and young people in services purchased from joint municipal boards during the year up to 2014. The table has multiple columns including '_start_date', '_end_date', '_row_number', 'year', 'region', 'gender', 'value_abs', and 'absolute_value'. The '_start_date' column indicates the date when the row was extracted from the Sotkanet website, while the '_end_date' column contains the date when a new version of the row was extracted. If the '_end_date' is null, it means that the row represents the most recent version. The data in this table can be used for various data analytics and insights such as analyzing trends by year, region, and gender, understanding the absolute values of care days...

Column Descriptions

Child Welfare Institutions care days for Children and Young People in Services Purchased from Joint Municipal Boards during Year up to 2014

Column	Type	Comment
_extract_date	date	The date when the data on the row of the table was extracted from the data source.
_row_number	long	The row number in the data extracted from the source on the extract date specified by the column '_extract_date'.
year	int
region	int
gender	string
value_abs	int
absolute_value	string

Version History of Child Welfare Institutions Care Days for Children and Young People in Services Purchased from Joint Municipal Boards during Year up to 2014

Column	Type	Comment
_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 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
region	int
gender	string
value_abs	int
absolute_value	string

Additional Info

Last Updated	May 22, 2024
Created	May 22, 2024