Alcohol Mortality per 100,000 Inhabitants in Finland

This dataset collection contains information about alcohol mortality per 100,000 inhabitants in Finland. The collection includes one table named 'Alcohol Mortality per 100,000 Inhabitants in Finland'. The tables are sourced from the website 'Sotkanet' in Finland.

Tables

Alcohol Mortality Per 100 000 InhabitantsTSV
The indicator gives alcohol mortality per 100 000 inhabitants. Population figures refer to mean population.The indicator measures alcohol mortality according to the narrow definition of cause of death (category 41 in the 54-category national classification). The figure includes the number of deaths where the primary cause of death is alcohol-related (alcohol diseases and accidental alcohol poisonings).
Alcohol Mortality per 100,000 Inhabitants in FinlandTSV
This table contains data on alcohol mortality per 100,000 inhabitants. It provides information on the year, region, gender, value per 100,000 inhabitants, and absolute value of alcohol-related deaths. The data is sourced from the 'Sotkanet' website, which originates from Finland (ISO country code 'FI'). The table includes two special columns: '_extract_date' and '_row_number'. The '_extract_date' column indicates the date when the data was extracted from the source, while the '_row_number' column represents the row number in the extracted data on the specified extract date. 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 analyzing trends in alcohol-related...
Version History of Alcohol Mortality per 100,000 Inhabitants in Finland from SotkanetTSV
This table represents the version history of the 'alcohol_mortality_per_100_000_inhabitantstable' table. It contains information about the mortality rates per 100,000 inhabitants due to alcohol consumption. The data is sourced from the 'Sotkanet' website, which originates from Finland (ISO country code 'fi'). Each row in this table corresponds to a specific version of a row in the base table. The columns in this table include '_start_date', which indicates the date when the row was extracted from the data source, '_end_date', which indicates the date when a new version of the row was extracted, '_row_number', which uniquely identifies each row in this version history table, 'year', which represents the year of the data, 'region', which specifies the geographical region, 'gender', which...

Column Descriptions

Alcohol Mortality Per 100 000 Inhabitants

Column	Type	Comment
year	int	Observation year. Column year has 2382 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1990 and maximum value is 2016.
region	int	Sotkanet region code (Region, major region, whole country). Column region has 2382 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 488 and maximum value is 955.
gender	string	male, female, combined. Column gender has 2382 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 male.
value_per100000	float	Per 100 000 inhabitants. Column value_per100000 has 2382 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0.00 and maximum value is 118.60.
absolute_value	int	Absolute value. Column absolute_value has 2382 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 2167.
orig_extractdate	string	The date when the data was originally fetched from the source.

Alcohol Mortality per 100,000 Inhabitants in Finland

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
region	int	The region associated with the data
gender	string	The gender associated with the data
value_per100000	float	The value per 100,000 people
absolute_value	int	The absolute value

Version History of Alcohol Mortality per 100,000 Inhabitants in Finland from Sotkanet

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 of the data.
region	int	The specific region or location the data represents.
gender	string	The gender of the data.
value_per100000	float	The value per 100,000 related to the data.
absolute_value	int	The absolute value of the data.

Additional Info

Last Updated	May 22, 2024
Created	March 8, 2019