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

The dataset collection contains information about care and services provided to older people clients in part-time care, which were purchased from others during the period of 1994-2014. The collection includes the table named 'Care and Services for Older People Clients in Part-Time Care in Services Purchased from Others (1994-2014)', sourced from the website of Sotkanet in Finland.

Tables

Care And Services For Older People Clients In Part Time Care In Services Purchased From Others On 31 Dec 1994 2014TSV
Care and Services for Older People Clients in Part-Time Care in Services Purchased from Others (1994-2014)TSV
This table contains information about the care and services for older people clients in part-time care purchased from others in the years 1994 to 2014. The data is sourced from the 'Sotkanet' website, originating from the country Finland (ISO country code 'fi'). The table consists of columns such as '_extract_date' which represents the date when the data was extracted, and '_row_number' which indicates the row number in the extracted data. The combination of these two columns uniquely identifies each row. Other columns include 'year', 'region', 'gender', 'value_abs', and 'absolute_value'. These columns provide various data points that can be utilized for data analytics such as analyzing trends in part-time care utilization over the years, comparing the usage between different regions,...
Version History of Care and Services for Older People Clients in Part-Time Care Services Purchased from OthersTSV
This version history table contains the version history of the data from the care and services for older people clients in part-time care in services purchased from others on 31 Dec 1994-2014. The table provides a historical record of changes made to the rows in the base table over time. Each row in this table is uniquely identified by a combination of the '_start_date' and '_row_number' columns. The '_start_date' column indicates the date when the row was extracted from the Sotkanet data source, which originates from Finland. The '_end_date' column indicates the date when a new version of the row was extracted, or it is null if the row is the most recent version. The table includes additional columns such as 'year', 'region', 'gender', 'value_abs', and 'absolute_value', which contain...

Column Descriptions

Care And Services For Older People Clients In Part Time Care In Services Purchased From Others 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 898.
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 Purchased from Others (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 value.
region	int	The region value.
gender	string	The gender value.
value_abs	int	The absolute value.
absolute_value	string	The absolute value.

Version History of Care and Services for Older People Clients in Part-Time Care Services Purchased from Others

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	Another representation of the absolute value associated with the data.

Additional Info

Last Updated	May 22, 2024
Created	March 7, 2019