Care and Services for Older People Clients in Part-Time Care in Services Funded by the Municipality on 31 Dec 1994-2014

This dataset collection includes information on care and services provided to older people in part-time care, funded by the municipality in Finland. The collection contains a single table titled 'Care and Services for Older People Clients in Part-Time Care in Services Funded by the Municipality on 31 Dec 1994-2014 Table'. The data for this collection is sourced from the Sotkanet website, which is a web portal for social and health information in Finland. Sotkanet provides comprehensive data on various aspects of well-being in the country.

Tables

Care And Services For Older People Clients In Part Time Care In Services Funded By The Municipality On 31 Dec 1994 2014TSV
Care and Services for Older People Clients in Part-Time Care in Services Funded by the Municipality on 31 Dec 1994-2014 TableTSV
This table contains data on care and services provided to older people in part-time care, funded by the municipality from 31 Dec 1994 to 2014 in Finland. The table includes information such as the year, region, gender, absolute value, and the combination of columns '_extract_date' and '_row_number' which uniquely identifies each row. The data in this table can be utilized in various data analytics scenarios, such as analyzing trends in care and services provided over time, comparing the distribution of services among different regions, examining gender differences in the utilization of services, and calculating statistical measures based on the absolute values of care and services.
Version History of Care and Services for Older People Clients in Part-Time Care in Services Funded by the Municipality from 31 Dec 1994 to 2014TSV
This table contains the version history of the 'care_and_services_for_older_people_clients_in_part_time_care_in_services_funded_by_the_municipality_on_31_dec_1994_2014__table'. It is sourced from the 'Sotkanet' website, which originates from Finland. The table includes information such as the start date, end date, row number, year, region, gender, absolute value, and value in absolute terms. The data in this table can be utilized for various data analytics purposes, such as studying the changes in the number of older people receiving part-time care services funded by the municipality over different years and regions, analyzing the gender distribution among these clients, and examining the absolute values and trends related to these services.

Column Descriptions

Care And Services For Older People Clients In Part Time Care In Services Funded By The Municipality On 31 Dec 1994 2014

Column	Type	Comment
year	int	Observation year. Column year has 9525 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1994 and maximum value is 2013.
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 9525 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 9525 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 9525 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 4135.
absolute_value	string	Absolute value. Column is empty.
orig_extractdate	string	The date when the data was originally fetched from the source.

Care and Services for Older People Clients in Part-Time Care in Services Funded by the Municipality on 31 Dec 1994-2014 Table

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	The absolute value of the data.

Version History of Care and Services for Older People Clients in Part-Time Care in Services Funded by the Municipality from 31 Dec 1994 to 2014

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 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 for the row
region	int	The region value for the row
gender	string	The gender value for the row
value_abs	int	The absolute value for the row
absolute_value	string	An alternate representation of the absolute value for the row

Additional Info

Last Updated	May 22, 2024
Created	March 7, 2019