Cases of Gonorrhoea Infection per 100,000 Inhabitants in Finland

The 'cases_of_gonorrhoea_infection_per_100_000_inhabitants' dataset collection consists of one dataset table. The table is named 'Number of Gonorrhea Cases per 100,000 Inhabitants in Finland'. The dataset tables are sourced from the web site of 'Sotkanet' in Finland.

Tables

Cases Of Gonorrhoea Infection Per 100 000 InhabitantsTSV
Population proportions are calculated at THL based on the Population Statistics of Statistics Finland.
Number of Gonorrhea Cases per 100,000 Inhabitants in FinlandTSV
The table contains data on the number of cases of gonorrhoea infection per 100,000 inhabitants in various regions of Finland. The data is sourced from 'Sotkanet', a website that provides health and welfare statistics in Finland. Each row in the table represents a specific combination of a year, region, and gender. The values in the 'value_per100000' column represent the number of cases per 100,000 inhabitants, while the 'absolute_value' column contains the absolute number of cases. There are two special columns in the table: '_extract_date', which specifies the date when the data was extracted from the source, and '_row_number', which indicates the row number in the extracted data. The combination of '_extract_date' and '_row_number' uniquely identifies each row in the table. The data...
Version History of Cases of Gonorrhoea Infection per 100,000 Inhabitants in FinlandTSV
This table contains the version history of the cases of gonorrhoea infection per 100,000 inhabitants. It is sourced from the 'Sotkanet' website in Finland. The table includes the following columns: '_start_date' which represents the extraction date of the row, '_end_date' which represents the date when a new version of the row was extracted, '_row_number' which uniquely identifies each row, 'year' which indicates the year of the data, 'region' which represents the specific region, 'gender' which identifies the gender, 'value_per100000' which gives the infection rate per 100,000 inhabitants, and 'absolute_value' which provides the absolute number of cases. This table can be utilized in data analytics to perform various analyses like trend analysis, regional comparison, gender-based...

Column Descriptions

Cases Of Gonorrhoea Infection Per 100 000 Inhabitants

Column	Type	Comment
year	int	Observation year. Column year has 4095 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 (Hospital district, university hospital special responsibility area, whole country). Column region has 4095 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 4095 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 4095 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 31.40.
absolute_value	int	Absolute value. Column absolute_value has 4095 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 330.
orig_extractdate	string	The date when the data was originally fetched from the source.

Number of Gonorrhea Cases 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
region	int
gender	string
value_per100000	float
absolute_value	int

Version History of Cases of Gonorrhoea Infection 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.
year	int	The year value of the record.
region	int	The region associated with the record.
gender	string	The gender associated with the record.
value_per100000	float	The value per 100,000 associated with the record.
absolute_value	int	The absolute value associated with the record.

Additional Info

Last Updated	May 22, 2024
Created	March 8, 2019