Care and Services for Older People Clients in Part-Time Care Sold by the Municipality in Finland (1994-2014)

This dataset collection named 'care_and_services_for_older_people_clients_in_part_time_care_in_services_sold_by_the_municipality_on_31_dec_1994_2014' consists of one table. The table is titled 'Care and Services for Older People Clients in Part-Time Care Sold by the Municipality in Finland (1994-2014)'. The table is sourced from the web site of 'Sotkanet' in Finland.

Tables

Care And Services For Older People Clients In Part Time Care In Services Sold By The Municipality On 31 Dec 1994 2014TSV
Care and Services for Older People Clients in Part-Time Care Sold by the Municipality in Finland (1994-2014)TSV
This table contains data on care and services for older people clients in part-time care services sold by the municipality from the years 1994 to 2014. The data is extracted from the web site 'Sotkanet' which originates from Finland. The table consists of several 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 row number in the extracted data on the specified extraction date. The combination of '_extract_date' and '_row_number' uniquely identifies each row in the table. This table can be utilized for various data analytics purposes, such as analyzing the trends in...
Version History of Care and Services for Older People Clients in Part-Time Care in Services Sold by the Municipality (1994-2014) - Sotkanet - FinlandTSV
This table represents the version history of the base table containing data on care and services for older people clients in part-time care sold by the municipality from 31 December 1994 to 2014 in Finland. The data is sourced from the 'Sotkanet' website, which is a comprehensive Finnish social and health care statistical database. The table includes columns such as '_start_date' and '_end_date' indicating the extraction dates of each row, '_row_number' representing the unique identifier of each row, 'year' indicating the year of the data, 'region' specifying the geographical region, 'gender' representing the gender of the clients, 'value_abs' indicating the absolute value of the data, and 'absolute_value' providing additional details about the value. The version history captured in...

Column Descriptions

Care And Services For Older People Clients In Part Time Care In Services Sold 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 87.
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 Sold by the Municipality 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 value for the data.
region	int	The region associated with the data.
gender	string	The gender associated with the data.
value_abs	int	The absolute value for the data.
absolute_value	string	An alternate representation of the absolute value for the data.

Version History of Care and Services for Older People Clients in Part-Time Care in Services Sold 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 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 in the row.
region	int	The region associated with the data in the row.
gender	string	The gender associated with the data in the row.
value_abs	int	The absolute value associated with the data in the row.
absolute_value	string	The absolute value associated with the data in the row.

Additional Info

Last Updated	May 22, 2024
Created	March 7, 2019