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

This dataset collection, sourced from the website of Sotkanet in Finland, includes comprehensive information about care and services provided for older people in part-time care purchased from the state in Finland from 1994 to 2014. The collection consists of one table titled 'Care and Services for Older People in Part-Time Care Purchased from the State in Finland (1994-2014)'. The dataset contains valuable insights into the various care and services offered to older individuals in Finland during the specified time period.

Tables

Care And Services For Older People Clients In Part Time Care In Services Purchased From The State On 31 Dec 1994 2014TSV
Care and Services for Older People in Part-Time Care Purchased from the State in Finland (1994-2014)TSV
This table contains information about care and services for older people clients who are in part-time care and have purchased services from the state. The data is sourced from the website of 'Sotkanet', which originates from Finland. The table includes columns such as '_extract_date', '_row_number', 'year', 'region', 'gender', 'value_abs', and 'absolute_value'. The column '_extract_date' represents the date when the data on each row was extracted from the data source. The column '_row_number' represents the row number in the extracted data on the extract date. The combination of '_extract_date' and '_row_number' uniquely identifies each row. This data can be utilized in various data analytics scenarios, such as analyzing trends in usage of part-time care services over the years,...
Version History of Care and Services for Older People Clients in Part-Time Care in Services Purchased from the State (1994-2014)TSV
This table contains the version history of the care and services for older people clients in part-time care in services purchased from the state in Finland from the year 1994 to 2014. The data is sourced from the website 'Sotkanet' which is a national indicator bank in Finland. The table includes information on the start date and end date of each row, along with the row number, year, region, gender, absolute value, and the absolute numeric value. The table can be utilized in data analytics to analyze trends and patterns in the utilization of part-time care services for older people in different regions and over time, to identify gender-specific care needs, and to study the impact of policy changes or funding allocations on the provision of these services.

Column Descriptions

Care And Services For Older People Clients In Part Time Care In Services Purchased From The State 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 73.
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 in Part-Time Care Purchased from the State 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 associated with the data entry.
value_abs	int	The absolute value of the data entry.
absolute_value	string	Same as 'value_abs', this column also represents the absolute value of the data entry.

Version History of Care and Services for Older People Clients in Part-Time Care in Services Purchased from the State (1994-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 indicates 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. Forms a combination with '_start_date' to uniquely identify each row in this version history table.
year	int	The year associated with 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	An alternative column name for 'value_abs'.

Additional Info

Last Updated	May 22, 2024
Created	March 7, 2019