Care and Services for Older People Clients in Part-Time Care Services Purchased from Municipalities in Finland (1994-2014)

The dataset 'Care and Services for Older People Clients in Part-Time Care Services Purchased from Municipalities in Finland (1994-2014)' is a collection of tables sourced from the web site of Sotkanet in Finland. It contains information about the care and services provided to older people clients in part-time care, as purchased from municipalities in Finland between the years 1994 and 2014.

Tables

Care And Services For Older People Clients In Part Time Care In Services Purchased From Municipalities On 31 Dec 1994 2014TSV
Care and Services for Older People Clients in Part-Time Care Services Purchased from Municipalities in Finland (1994-2014)TSV
This table contains data on care and services for older people clients in part-time care purchased from municipalities in Finland. The data is sourced from the web site of 'Sotkanet', which originates from Finland (ISO country code: 'fi'). The table consists of various columns including '_extract_date', '_row_number', 'year', 'region', 'gender', 'value_abs', and 'absolute_value'. The '_extract_date' column represents the date when the data on the row was extracted from the data source, while the '_row_number' column indicates the corresponding row number in the extracted data. The combination of '_extract_date' and '_row_number' uniquely identifies each row in the table. The data in this table can be utilized for various data analytics purposes, such as studying the trends in part-time...
Version History of Care and Services for Older People Clients in Part-Time Care in Services Purchased from Municipalities (1994-2014) in FinlandTSV
This table contains the version history of the base table rows for care and services provided to older people clients in part-time care. The data is sourced from Sotkanet, a web site originating from Finland. The table provides information on the years, regions, gender, absolute values, and other relevant details. The '_start_date' column contains the extraction date of each row, while the '_end_date' column indicates the date of the most recent version. The '_row_number' column is a unique identifier for each row. Data analysts can utilize this table to perform various analytics, such as trend analysis, regional comparison, and gender-based analysis, to gain insights into the care and services received by older people clients in part-time care in different regions of Finland over the...

Column Descriptions

Care And Services For Older People Clients In Part Time Care In Services Purchased From Municipalities 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 89.
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 Services Purchased from Municipalities in Finland (1994-2014)

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 entry.
region	int	The region associated with the data entry.
gender	string	The gender of the data entry.
value_abs	int	The absolute value of the data entry.
absolute_value	string	An alternative column name for 'value_abs'.

Version History of Care and Services for Older People Clients in Part-Time Care in Services Purchased from Municipalities (1994-2014) in 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 the value is 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 associated with the data.
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.

Additional Info

Last Updated	May 22, 2024
Created	March 7, 2019