Child Guidance and Family Counselling Clinic Clients in Services Funded by the Municipality during the Year

The dataset collection includes a table titled 'Child Guidance and Family Counselling Clinic Clients in Services Funded by the Municipality during the Year'. This dataset collection contains data sourced from the web site of Sotkanet in Finland.

Tables

Child Guidance and Family Counselling Clinic Clients in Services Funded by the Municipality during the YearTSV
The indicator gives the number of clients (both children and adults) recipients of child guidance and family counselling services pursuant to the Social Welfare Act during the year. The data cover services that the municipality provides itself or purchases from other municipalities, joint municipal boards, the state or private service providers. The data are gathered according to the following classification:1. "Municipal services" are services produced in units owned by the municipality.2. "Services sold" are services (cf. previous section) sold to other municipalities, for example.3. "Services purchased from public bodies" are services purchased from municipalities, joint municipal authorities, or the central government.4. "Services purchased from other instances" are services...
Child Guidance And Family Counselling Clinics Clients In Services Funded By The Municipality During YearTSV
The indicator gives the number of clients (both children and adults) recipients of child guidance and family counselling services pursuant to the Social Welfare Act during the year. The data cover services that the municipality provides itself or purchases from other municipalities, joint municipal boards, the state or private service providers. The data are gathered according to the following classification:1. "Municipal services" are services produced in units owned by the municipality.2. "Services sold" are services (cf. previous section) sold to other municipalities, for example.3. "Services purchased from public bodies" are services purchased from municipalities, joint municipal authorities, or the central government.4. "Services purchased from other instances" are services...
Version History of Child Guidance and Family Counselling Clinics Clients in Services Funded by the Municipality During Year (Sotkanet - Finland)TSV
This table, 'child_guidance_and_family_counselling_clinics_clients_in_services_funded_by_the_municipality_during_yeartablehistory', represents the version history of the base table rows. It contains information about the clients in child guidance and family counselling clinics who received services funded by the municipality during a specific year. The data in the table includes the year of the service, the region where the service was provided, the gender of the client, and the absolute value of a certain metric related to the service. The column '_start_date' indicates the date when the specific row was extracted from the data source, while '_end_date' indicates the date when a newer version of the row was extracted. If the '_end_date' is null, it means the row represents the most...

Column Descriptions

Child Guidance And Family Counselling Clinics Clients In Services Funded By The Municipality During Year

Column	Type	Comment
year	int	Observation year. Column year has 12842 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 12842 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 12842 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 12842 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.
absolute_value	string	Absolute value. Column is empty.
orig_extractdate	string	The date when the data was originally fetched from the source.

Child Guidance and Family Counselling Clinic Clients in Services Funded by the Municipality during the 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	The year related to the data entry.
region	int	The region associated with the data entry.
gender	string	The gender related to 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 Guidance and Family Counselling Clinics Clients in Services Funded by the Municipality During Year (Sotkanet - 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 value of the data.
region	int	The region where the data belongs to.
gender	string	The gender of the subject of the data.
value_abs	int	The absolute value of the data.
absolute_value	string	An alternative representation of the absolute value of the data.

Additional Info

Last Updated	May 22, 2024
Created	March 7, 2019