Child Guidance and Family Counselling Clinics - Adult Clients in Services Funded by Municipality in Year - Finland

This dataset collection, provided by 'Sotkanet' (Finnish National Indicator Bank), contains information related to Child Guidance and Family Counselling Clinics - Adult Clients in Services Funded by Municipality in Year in Finland. The collection consists of one table named 'Child Guidance and Family Counselling Clinics - Adult Clients in Services Funded by Municipality in Year - Finland'. The tables in this collection are sourced from the website of 'Sotkanet', which is the Finnish National Indicator Bank.

Tables

Child Guidance and Family Counselling Clinics - Adult Clients in Services Funded by Municipality in Year - FinlandTSV
The indicator gives the number of the adult 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 purchased from the private...
Child Guidance And Family Counselling Clinics Adult Clients In Services Funded By The Municipality During YearTSV
The indicator gives the number of the adult 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 purchased from the private...
Version History of Child Guidance and Family Counselling Clinics Adult Clients in Services Funded by the Municipality During Year - FinlandTSV
The child_guidance_and_family_counselling_clinics_adult_clients_in_services_funded_by_the_municipality_during_yeartablehistory table contains the version history of adult clients in child guidance and family counselling clinics funded by the municipality during a specific year. The table includes the following columns: '_start_date' which indicates the date the row was extracted from the data source, '_end_date' which represents the date when a new version of the row was extracted (null if the row is the most recent version), '_row_number' which identifies each row uniquely, 'year' which refers to the year the data corresponds to, 'region' which signifies the geographic region, 'gender' which indicates the gender of the clients, 'value_abs' which represents the absolute value of the...

Column Descriptions

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

Column	Type	Comment
year	int	Observation year. Column year has 9510 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1997 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 9510 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 9510 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 9510 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 42859.
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 Clinics - Adult Clients in Services Funded by Municipality in Year - Finland

Column	Type	Comment
_extract_date	date	The date when the data on the row 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 row.
region	int	The region associated with the data.
gender	string	The gender associated with the data.
value_abs	int	The absolute value associated with the data.
absolute_value	string	The absolute value associated with the data.

Version History of Child Guidance and Family Counselling Clinics Adult Clients in Services Funded by the Municipality During 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 of the row.
_row_number	long	The number of the row in the raw data extracted from the data source.
year	int	The year related 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 associated with the data entry.
absolute_value	string	The absolute value associated with the data entry.

Additional Info

Last Updated	May 22, 2024
Created	March 7, 2019