Child Welfare Institutions: Children and Young People in Services Purchased from the State on 31 Dec up to 2014

The dataset collection contains information on child welfare institutions and the number of children and young people in services purchased from the state as of December 31st up to the year 2014. The collection includes a table titled 'Child Welfare Institutions: Children and Young People in Services Purchased from the State on 31 Dec up to 2014'. The data is sourced from the website 'Sotkanet' in Finland.

Tables

Child Welfare Institutions: Children and Young People in Services Purchased from the State on 31 Dec up to 2014TSV
The indicator gives the number of children and young people in municipally funded child welfare institutions (children´s homes, reform schools, youth homes etc.) on 31 December. The number of clients includes all persons registered as clients in such child welfare institutions (incl. those on holiday or temporarily absent), that is, clients with a reserved client place.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 other municipalities, for instance. 3. "Services purchased from the state" refers to services purchased from state-owned units. 4. "Services purchased from...
Version History of Child Welfare Institutions Children and Young People in Services Purchased from the State on 31 Dec up to 2014TSV
This table contains the version history of the child welfare institutions data for children and young people in services purchased from the state on 31 Dec up to 2014. The data is sourced from the website of 'Sotkanet' from Finland. The table has the following columns: '_start_date', '_end_date', '_row_number', 'year', 'region', 'gender', 'value_abs', 'absolute_value'. The '_start_date' column represents the date when the row was extracted from the data source, while the '_end_date' column represents the date when a new version of the row was extracted. The '_row_number' column uniquely identifies each row in this version history table. The data in this table can be utilized in data analytics to analyze trends in child welfare institutions, such as changes over time in the number of...

Column Descriptions

Child Welfare Institutions: Children and Young People in Services Purchased from the State on 31 Dec 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	The year associated with 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 associated with the data entry.
absolute_value	string	An alternative representation of the absolute value associated with the data entry.

Version History of Child Welfare Institutions Children and Young People in Services Purchased from the State on 31 Dec 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 the value is null, it means that the row is the most recent version.
_row_number	long	The number of the row in the raw data extracted from the data source.
year	int	The year of 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 entry.
absolute_value	string	An alternative name for the absolute value of the entry.

Additional Info

Last Updated	May 22, 2024
Created	May 22, 2024