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

This dataset collection contains information about child welfare institutions and children and young people in services funded by the municipality as of 31 December up to 2014. The dataset table titled 'Child Welfare Institutions - Children and Young People in Services Funded by the Municipality on 31 December up to 2014' provides detailed data on this topic. The dataset tables are sourced from the website 'Sotkanet' in Finland.

Tables

Child Welfare Institutions - Children and Young People in Services Funded by the Municipality on 31 December 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 (including those on holiday or temporarily absent), that is, clients with a reserved client place. Municipally funded child welfare institutions (children's homes, reform schools, youth homes etc.) 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...
Child Welfare Institutions Children And Young People In Services Funded By The Municipality 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 (including those on holiday or temporarily absent), that is, clients with a reserved client place. Municipally funded child welfare institutions (children's homes, reform schools, youth homes etc.) 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...
Version History of Child Welfare Institutions - Children and Young People in Services Funded by the Municipality on 31st December up to 2014TSV
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...

Column Descriptions

Child Welfare Institutions Children And Young People In Services Funded By The Municipality On 31 Dec Up To 2014

Column	Type	Comment
year	int	Observation year. Column year has 4854 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2001 and maximum value is 2013.
region	int	Sotkanet region code (Municipality, sub-region, region, area for the regional state administrative agency, major region, Mainland Finland/Åland, hospital district, university hospital special responsibility area, whole country). Column region has 4854 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2 and maximum value is 955.
gender	string	gender total. Column gender has 4854 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: total.
value_abs	int	Absolute number. Column value_abs has 4854 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 4361.
absolute_value	string	Absolute value. Column is empty.
orig_extractdate	string	The date when the data was originally fetched from the source.

Child Welfare Institutions - Children and Young People in Services Funded by the Municipality on 31 December 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 of the data entry.
absolute_value	string	The absolute value of the data entry.

Version History of Child Welfare Institutions - Children and Young People in Services Funded by the Municipality on 31st December 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 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

Additional Info

Last Updated	May 22, 2024
Created	March 7, 2019