1. Home
  2. Datasets
  3. Number of Syphilis Infections ...
To download the data set, please sign up or log in

Number of Syphilis Infections per 100,000 Inhabitants in Finland

The dataset collection includes information on the number of syphilis infections per 100,000 inhabitants in Finland. It consists of one table named 'Number of Syphilis Infections per 100,000 Inhabitants in Finland'. The tables in this collection are sourced from the web site of 'Sotkanet' in Finland.

Tables

  • Cases Of Syphilis Infection Per 100 000 InhabitantsTSV

    Population proportions are calculated at THL based on the Population Statistics of Statistics Finland.

  • Number of Syphilis Infections per 100,000 Inhabitants in FinlandTSV

    This table contains data on cases of syphilis infection per 100,000 inhabitants. The data is sourced from the website 'Sotkanet' which originates from Finland. The table consists of several columns including '_extract_date', '_row_number', 'year', 'region', 'gender', 'value_per100000', and 'absolute_value'. The column '_extract_date' 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. The combination of '_extract_date' and '_row_number' uniquely identifies each row in the table. This table provides valuable information for data analytics, such as analyzing the trend of syphilis infection over the years, comparing the infection rates between different regions, examining...

  • Version History of Cases of Syphilis Infection per 100,000 Inhabitants in FinlandTSV

    This table contains the version history of the base table 'cases_of_syphilis_infection_per_100_000_inhabitants__table'. It provides information about cases of syphilis infection per 100,000 inhabitants in different regions and years. The data is sourced from the 'Sotkanet' website, which originates from Finland (ISO country code: 'fi'). The table includes columns such as '_start_date' (the date when the row was extracted from the data source), '_end_date' (the date when a new version of the row was extracted), '_row_number' (a unique identifier for each row), 'year' (the year of the recorded data), 'region' (the geographic region), 'gender' (the gender of the population), 'value_per100000' (the reported value of syphilis cases per 100,000 inhabitants), and 'absolute_value' (the absolute...

Column Descriptions

Cases Of Syphilis 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 35.20.
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 249.
orig_extractdate string The date when the data was originally fetched from the source.

Number of Syphilis Infections 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 entry.
region int The region associated with the data entry.
gender string The gender associated with the data entry.
value_per100000 float The value per 100,000 population for the data entry.
absolute_value int The absolute value of the data entry.

Version History of Cases of Syphilis 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 of the row.
_row_number long The number of the row in the raw data extracted from the data source.
year int The year corresponding to 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 of the data.

Additional Info

Last Updated May 22, 2024
Created March 8, 2019