Care and Services for Older People Clients in Part-Time Care in Services Produced by the Municipality from 31 Dec 1994 to 2014 in Finland

The dataset collection contains information about the care and services provided to older people clients in part-time care in Finland. The data covers the period from 31st December 1994 to 2014. The dataset table, 'Care and Services for Older People Clients in Part-Time Care in Services Produced by the Municipality from 31 Dec 1994 to 2014 in Finland', is sourced from the website of Sotkanet, which is owned by the National Institute for Health and Welfare (THL).

Tables

Care And Services For Older People Clients In Part Time Care In Services Produced By The Municipality On 31 Dec 1994 2014TSV
Care and Services for Older People Clients in Part-Time Care in Services Produced by the Municipality from 31 Dec 1994 to 2014 in FinlandTSV
This table provides information on the care and services for older people clients in part-time care produced by the municipality from 31st December 1994 to 2014. The data source for this table is 'Sotkanet' which originates from Finland. The table contains information on different attributes such as year, region, gender, value absolute, and absolute value. The combination of the extract date and row number uniquely identifies each row in the table. The '_extract_date' column represents the date when the data on the row was extracted from the source, while the '_row_number' column stores the row number in the extracted data on the specified extract date. This table can be utilized in data analytics to analyze trends and patterns in the care and services for older people clients in...
Version History of Care and Services for Older People Clients in Part-Time Care in Services Produced by the Municipality (1994-2014) - Sotkanet, FinlandTSV
This table contains the version history for the base table of care and services provided by the municipality for older people clients in part-time care. The data in this table is sourced from the 'Sotkanet' website, which originates from Finland. The table includes the '_start_date' column which represents the extraction date, and the '_end_date' column which indicates the date when a new version of a row was extracted. The '_row_number' column uniquely identifies each row in this version history table. Additionally, the table includes columns such as 'year', 'region', 'gender', 'value_abs', and 'absolute_value'. The data in this table can be utilized for various data analytics purposes such as analyzing trends in the number of older people clients receiving part-time care services over...

Column Descriptions

Care And Services For Older People Clients In Part Time Care In Services Produced 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 3469.
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 Produced by the Municipality from 31 Dec 1994 to 2014 in Finland

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'. The combination of the columns '_extract_date' and '_row_number' uniquely identifies each row.
year	int	The year of the data entry.
region	int	The region where the data entry belongs to.
gender	string	The gender of the individual related to the data entry.
value_abs	int	The absolute value of the data entry.
absolute_value	string	An alternative representation of the absolute value of the data entry.

Version History of Care and Services for Older People Clients in Part-Time Care in Services Produced by the Municipality (1994-2014) - 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 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 associated with the data.
region	int	The region related to the data.
gender	string	The gender associated with the data.
value_abs	int	The absolute value.
absolute_value	string	The absolute value.

Additional Info

Last Updated	May 22, 2024
Created	March 7, 2019