Child Welfare Institutions Care Days for Children and Young People in Municipality's Own Services (Up to 2014)

The dataset collection contains the table 'Child Welfare Institutions Care Days for Children and Young People in Municipality's Own Services (Up to 2014)'. This dataset collection is sourced from the web site of 'Sotkanet' in Finland.

Tables

Child Welfare Institutions Care Days for Children and Young People in Municipality's Own Services (Up to 2014)TSV
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...
Child Welfare Institutions Care Days for Children and Young People in the Municipality's Own Services - Version HistoryTSV
This table contains the version history of the child welfare institutions care days for children and young people in the municipality's own services during the year up to 2014. The data is sourced from the 'Sotkanet' website, which originates from Finland. The table has columns '_start_date', '_end_date', '_row_number', 'year', 'region', 'gender', 'value_abs', and '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 the version history table. The 'year' column represents the year the data pertains to, the 'region' column represents the geographic region, the 'gender' column...

Column Descriptions

Child Welfare Institutions Care Days for Children and Young People in Municipality's Own Services (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 of the data.'
region	int	'The region associated with the data.'
gender	string	'The gender associated with the data.'
value_abs	int	'The absolute value of the data.'
absolute_value	string	'An alternative column name for the absolute value of the data.'

Child Welfare Institutions Care Days for Children and Young People in the Municipality's Own Services - Version History

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 value is null, it means 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 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	Alternative column name for the absolute value of the data entry.

Additional Info

Last Updated	May 22, 2024
Created	May 22, 2024