1. Home
  2. Datasets
  3. Cases of HIV Infection - ...
To download the data set, please sign up or log in

Cases of HIV Infection - Sexual Transmission per 100000 Inhabitants

The dataset collection contains information about the cases of HIV infection caused by sexual transmission per 100,000 inhabitants. The data is sourced from the 'Cases of HIV Infection - Sexual Transmission per 100000 Inhabitants Table' which is part of the dataset collection. The tables are sourced from the website of Sotkanet in Finland.

Tables

  • Cases of HIV Infection - Sexual Transmission per 100000 Inhabitants TableTSV

    This table contains data on cases of HIV infection through sexual transmission per 100,000 inhabitants. It provides information on the year, region, gender, value per 100,000 inhabitants, and absolute value of HIV infection cases. The data in this table is sourced from the 'Sotkanet' website, which originates from Finland (ISO country code: FI). The table contains two special columns: '_extract_date', which indicates the date 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 can be utilized in data analytics to study the trends and prevalence of HIV infection cases over the years, analyze the distribution of cases...

  • Cases Of Hiv Infection Sexual Transmission Per 100 000 InhabitantsTSV

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

  • Version History of Cases of HIV Infection - Sexual Transmission per 100,000 Inhabitants - Sotkanet (Finland)TSV

    The version history table 'cases_of_hiv_infection_sexual_transmission_per_100_000_inhabitantstablehistory' tracks the changes made to the rows in the base table. It provides information on the start and end dates of each row version. The table contains data pertaining to HIV infection cases caused by sexual transmission per 100,000 inhabitants. The data is categorized by year, region, gender, value per 100,000 inhabitants, and absolute value. The table is sourced from the 'Sotkanet' website, which originates from Finland (ISO country code 'fi').

Column Descriptions

Cases Of Hiv Infection Sexual Transmission 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 16.10.
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 155.
orig_extractdate string The date when the data was originally fetched from the source.

Cases of HIV Infection - Sexual Transmission per 100000 Inhabitants Table

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'. This column uniquely identifies each row.
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_per100000 float The value associated with the data entry per 100,000 individuals.
absolute_value int The absolute value associated with the data entry.

Version History of Cases of HIV Infection - Sexual Transmission per 100,000 Inhabitants - Sotkanet (Finland)

Column Type Comment
_start_date date The date when the row was extracted from the data source. This column is one of the additional columns compared to the base table, as it represents the starting date of a row's version history.
_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 column '_start_date', it forms a combination that uniquely identifies each row in this version history table.
year int The year associated with the data in the row.
region int The region associated with the data in the row.
gender string The gender associated with the data in the row.
value_per100000 float The value per 100,000 associated with the data in the row.
absolute_value int The absolute value associated with the data in the row.

Additional Info

Last Updated May 22, 2024
Created March 8, 2019