Cases of Tuberculosis per 100,000 Inhabitants - Finland

The dataset collection contains information about the cases of tuberculosis per 100,000 inhabitants in Finland. The collection consists of one table titled 'Cases of Tuberculosis per 100,000 Inhabitants - Finland'. The table is sourced from the website 'Sotkanet' in Finland.

Tables

Cases Of Tuberculosis Per 100 000 InhabitantsTSV
The indicator gives the number of tuberculosis cases during the year per 100 000 inhabitants by sex. The population data refer to year-end data. Population proportions are calculated at THL based on the Population Statistics of Statistics Finland.
Cases of Tuberculosis per 100,000 Inhabitants - FinlandTSV
This table contains data on cases of tuberculosis per 100,000 inhabitants in various regions. It includes information such as the year, region, gender, value per 100,000 inhabitants, and absolute value. The data in this table has been extracted from the web site 'Sotkanet' which originates from Finland (ISO country code 'fi'). The table also includes two special columns: '_extract_date', which indicates the date when the data was extracted from the source, and '_row_number', which represents the row number in the extracted data. The combination of '_extract_date' and '_row_number' uniquely identifies each row in the table. This table provides valuable data for conducting data analytics, such as analyzing the trends and patterns of tuberculosis cases across different regions and years,...
Version History of Cases of Tuberculosis per 100,000 Inhabitants in FinlandTSV
The 'cases_of_tuberculosis_per_100_000_inhabitantstablehistory' table contains the version history of the cases of tuberculosis per 100,000 inhabitants. The data in this table is sourced from the 'Sotkanet' website originating from Finland. The table includes information such as the start date, end date, row number, year, region, gender, value per 100,000 inhabitants, and absolute value. The data in this table can be utilized in data analytics to analyze the trend of tuberculosis cases over time, compare the tuberculosis rates across different regions, examine gender-specific patterns, calculate the average value per 100,000 inhabitants, and analyze the absolute number of cases.

Column Descriptions

Cases Of Tuberculosis Per 100 000 Inhabitants

Column	Type	Comment
year	int	Observation year. Column year has 3780 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 2015.
region	int	Sotkanet region code (Municipality, region, hospital district, whole country). Column region has 3780 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 3780 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 3780 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 39.30.
absolute_value	int	Absolute value. Column absolute_value has 3780 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 631.
orig_extractdate	string	The date when the data was originally fetched from the source.

Cases of Tuberculosis per 100,000 Inhabitants - 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'. The combination of the columns '_extract_date' and '_row_number' uniquely identifies each row.
year	int
region	int
gender	string
value_per100000	float
absolute_value	int

Version History of Cases of Tuberculosis per 100,000 Inhabitants in 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. Together with the '_start_date' column, it uniquely identifies each row in this version history table.
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_per100000	float	The value per 100,000 associated with the data.
absolute_value	int	The absolute value associated with the data.

Additional Info

Last Updated	May 22, 2024
Created	March 8, 2019