Child Guidance and Family Counselling Clients per 1000 Persons under 18 in Services Funded by the Municipality during Year

This dataset collection contains information about the number of child guidance and family counselling clients per 1000 persons under 18 in services funded by the municipality during the year. The dataset includes a table titled 'Child Guidance and Family Counselling Clients per 1000 Persons under 18 in Services Funded by the Municipality during Year'. The table is sourced from the website of Sotkanet in Finland.

Tables

Child Guidance And Family Counselling Clients Per 1000 Persons Under 18 In Services Funded By The Municipality During YearTSV
The indicator gives the number of the recipients (adults and children) of child guidance and family counselling services pursuant to the Social Welfare Act during the year per population aged under 18. The population data refer to year-end data. The calculation is performed in relation to population under 18 as the service is intended for families with children. If the calculation were performed in relation to the total population, municipalities with different age structures would be treated unequally. Using the number of children in relation to population under 18, in turn, would not give the right picture, as more than half of the clients of child guidance and family counselling centres are adults. The data cover services that the municipality provides itself or purchases from other...
Child Guidance and Family Counselling Clients per 1000 Persons under 18 in Services Funded by the Municipality during YearTSV
The indicator gives the number of the recipients (adults and children) of child guidance and family counselling services pursuant to the Social Welfare Act during the year per population aged under 18. The population data refer to year-end data. The calculation is performed in relation to population under 18 as the service is intended for families with children. If the calculation were performed in relation to the total population, municipalities with different age structures would be treated unequally. Using the number of children in relation to population under 18, in turn, would not give the right picture, as more than half of the clients of child guidance and family counselling centres are adults. The data cover services that the municipality provides itself or purchases from other...
Version History of Child Guidance and Family Counselling Clients per 1000 Persons Under 18 in Services Funded by the Municipality during the Year - FinlandTSV
This table represents the version history of the 'child_guidance_and_family_counselling_clients_per_1000_persons_under_18_in_services_funded_by_the_municipality_during_year__table'. It contains the historical data sourced from 'Sotkanet', a data source from Finland. The table consists of rows that have been extracted from the data source, each uniquely identified by the combination of '_start_date' and '_row_number'. In addition to the columns included in the base table, this version history table has two additional columns: '_start_date' and '_end_date'. The '_start_date' represents the date when a row was extracted, and the '_end_date' represents the date when a new version of the row was extracted. If a row has a null value in the '_end_date' column, it indicates that the row...

Column Descriptions

Child Guidance And Family Counselling Clients Per 1000 Persons Under 18 In Services Funded By The Municipality During Year

Column	Type	Comment
year	int	Observation year. Column year has 12834 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1990 and maximum value is 2016.
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 12834 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 12834 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_per1000	int	Per 1 000 inhabitants. Column value_per1000 has 12834 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 1113.
absolute_value	int	Absolute value. Column absolute_value has 12834 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 79245.
orig_extractdate	string	The date when the data was originally fetched from the source.

Child Guidance and Family Counselling Clients per 1000 Persons under 18 in Services Funded by the Municipality during Year

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_per1000	int
absolute_value	int

Version History of Child Guidance and Family Counselling Clients per 1000 Persons Under 18 in Services Funded by the Municipality during the Year - Finland

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.
_row_number	long	The number of the row in the raw data extracted from the data source.
year	int	The year of the data recorded.
region	int	The region where the data was recorded.
gender	string	The gender of the individual recorded.
value_per1000	int	The value per 1000 for the specific metric recorded.
absolute_value	int	The absolute value for the specific metric recorded.

Additional Info

Last Updated	May 22, 2024
Created	March 6, 2019