Care Days in Social Care Units Providing 24-Hour Care for Those Aged 75 and Over per 1000 Persons of Same Age

This dataset collection consists of one table named 'Care Days in Social Care Units Providing 24-Hour Care for Those Aged 75 and Over per 1000 Persons of Same Age'. The table is sourced from the website of Sotkanet in Finland.

Tables

Care Days In Social Care Units Providing 24 Hour Care For Those Aged 75 And Over Per 1000 Persons Of Same AgeTSV
The indicator gives the number of care days for all those aged 75 and over who have received care in social care units providing 24-hour care per thousand persons of the same age during the year. Population figures refer to mean population. The indicator covers all units providing 2-hour care: residential homes and sheltered housing for older people, units for substance abusers, and institutions and housing with 24-hour assistance for people with intellectual disabilities in both the private and the public sector (municipality/joint municipal board and the state). Care days during the year refers to all care days falling within the calendar year. The number of care days is calculated as the difference between the date of discharge (or 31 Dec) and the date of admission (or 1 Jan), that...
Care Days in Social Care Units Providing 24-Hour Care for Those Aged 75 and Over per 1000 Persons of Same AgeTSV
This table contains data on the number of care days in social care units providing 24-hour care for individuals aged 75 and over per 1000 persons of the same age. The data is sourced from the web site 'Sotkanet' which originates from Finland. The table has columns '_extract_date' and '_row_number' which respectively indicate the date when the data was extracted and the row number in the extracted data. The other columns in the table include 'year', 'region', 'gender', 'value_per1000', and 'absolute_value'. These columns can be utilized in various data analytics scenarios such as analyzing the trend of care days over the years, comparing the care days by region and gender, and examining the relationship between the value per 1000 persons and the absolute value of care days.
Version History of Care Days in Social Care Units Providing 24-hour Care for those Aged 75 and Over per 1000 Persons of Same Age (Sotkanet, Finland)TSV
This table contains the version history of the care days in social care units providing 24-hour care for those aged 75 and over per 1000 persons of the same age. It is sourced from the 'Sotkanet' website of Finland. The table includes the columns '_start_date', '_end_date', '_row_number', 'year', 'region', 'gender', 'value_per1000', and 'absolute_value'. The '_start_date' column represents the date when the row was extracted from the data source, while the '_end_date' column represents the date when a new version of the row was extracted. The '_row_number' column provides a unique identifier for each row in combination with the '_start_date'. Utilizing this data table, various data analytics can be performed, such as analyzing the trend of care days per 1000 persons over time, comparing...

Column Descriptions

Care Days In Social Care Units Providing 24 Hour Care For Those Aged 75 And Over Per 1000 Persons Of Same Age

Column	Type	Comment
year	int	Observation year. Column year has 30781 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1995 and maximum value is 2016.
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 30781 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	male, female, combined. Column gender has 30781 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is female and maximum string is total.
value_per1000	int	Per 1 000 inhabitants. Column value_per1000 has 30781 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 4 and maximum value is 163200.
absolute_value	int	Absolute value. Column absolute_value has 30781 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 16039835.
orig_extractdate	string	The date when the data was originally fetched from the source.

Care Days in Social Care Units Providing 24-Hour Care for Those Aged 75 and Over per 1000 Persons of Same Age

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 when the data was recorded.
region	int	The region where the data was captured.
gender	string	The gender to which the data corresponds.
value_per1000	int	The value per 1000 pertaining to the data.
absolute_value	int	The absolute value of the data.

Version History of Care Days in Social Care Units Providing 24-hour Care for those Aged 75 and Over per 1000 Persons of Same Age (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 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 entry.
region	int	The region or geographical area associated with the data entry.
gender	string	The gender associated with the data entry.
value_per1000	int	The value per 1000 units associated with the data entry.
absolute_value	int	The absolute value associated with the data entry.

Additional Info

Last Updated	May 22, 2024
Created	March 8, 2019