Child Welfare Notifications for Children Aged 0-17 as a Percentage of Total Population of Same Age

This dataset collection encompasses information related to the proportion of children aged 0-17 years who were subject to a child welfare notification, compared to the total population of the same age group. The data is organized into tables, which provide a detailed layout of the statistical information. The data for this collection has been sourced from the 'Sotkanet' website, located in Finland. Additional licensing information: N/A).

Tables

Children Aged 0-17 Subject to a Child Welfare Notification as a Percentage of Total Population of Same AgeTSV
The table under consideration contains the data related to child welfare notifications, specifically focusing on children aged 0 to 17. The data is sourced from the Finnish website 'Sotkanet'. This table shows the frequency of these notifications for each child, counting each child only once even if multiple notifications were made. The data is organized by various factors such as the year in which the notifications were made, the region where the notifications were filed, and the gender of the child involved. The table also includes calculated population proportions based on the Population Statistics of Finland. Special columns in the table provide information about when the data was extracted from the source and the row number of the data, which together help to uniquely identify each...
Historical Data on Child Welfare Notifications for Children Aged 0-17 as a Percentage of Total PopulationTSV
The 'History' table is a part of a larger dataset collection that focuses on the welfare of children aged 0 to 17. This table is unique in that it contains the version history of its base table rows. This means that it retains records of past versions of data rows, allowing for a comprehensive view of how the data has evolved over time. Each row in the table is associated with a unique start date and an end date, which indicates when a new version of the row was extracted. If the end date is null, it signifies that the row is the most recent version. The data stored in the table provides insights into child welfare notifications filed each year. It's important to note that each child is counted only once, even if multiple notifications were filed. The table includes information about...

Column Descriptions

Children Aged 0-17 Subject to a Child Welfare Notification as a Percentage of Total Population of Same Age

Column	Type	Comment
_extract_date	date	This column contains the date when the data on the row was extracted from the source. This, in combination with '_row_number', uniquely identifies each row.
_row_number	long	This column contains the row number in the data extracted from the source on the extract date specified by the column '_extract_date'. This, in combination with '_extract_date', uniquely identifies each row.
year	int	The 'year' column represents the specific year during which the data was collected.
region	int	The 'region' column refers to the specific geographic region, represented by a unique number, where the data was collected.
gender	string	The 'gender' column indicates the gender group that the particular row of data pertains to. In this case, all data pertains to the 'total' gender group, encompassing all genders.
value_pros	float	The 'value_pros' column represents the percentage value of children aged 0-17 subject to a child welfare notification as a proportion of the total population of the same age.
absolute_value	int	The 'absolute_value' column indicates the absolute number of children aged 0-17 subject to a child welfare notification in the specified region and year.

Historical Data on Child Welfare Notifications for Children Aged 0-17 as a Percentage of Total Population

Column	Type	Comment
_start_date	date	This column indicates the date when the row was extracted from the data source, marking the beginning of the version history for the particular row.
_end_date	date	This column represents the date when a new version of the row was extracted from the data source, marking the end of the version history for the previous row. If this column contains a null value, it suggests that the row is the most recent version.
_row_number	long	This column contains the number of the row as it appears in the raw data extracted from the data source. This, in combination with the '_start_date' column, serves to uniquely identify each row in this version history table.
year	int	This column indicates the year the data was recorded.
region	int	This column specifies the code of the region for which the data was recorded.
gender	string	This column refers to the gender demographic to which the data applies. In this dataset, the gender demographic is 'total', indicating the data applies to all genders.
value_pros	float	This column represents the percentage value of children aged 0-17 subject to a child welfare notification as part of the total population of the same age in a specific region.
absolute_value	int	This column contains the absolute number of children aged 0-17 who were subject to a child welfare notification in a specific region.

Additional Info

Last Updated	November 5, 2024
Created	November 5, 2024