To download the data set, please sign up or log in

Number of Threatened Species Dataset Collection

This dataset collection contains information about the number of threatened species in a country. The dataset tables are sourced from the website of Luke in Finland.

Tables

  • History of Number of Threatened Species by Main Habitat Type (Luke, Finland)TSV

    This table contains the version history of the rows in the 'number_of_threatened_species_numberdim_main_habitat_typehistory' table. It represents data sourced from the 'Luke' website, which originates from the country with the ISO country code 'fi'. The table has additional columns compared to its base table, including '_start_date' indicating the extraction date of the row, and '_end_date' indicating the date when a new version of the row was extracted. If the value of '_end_date' is null, it means that the row is the most recent version. The data in this table can be utilized in various data analytics scenarios, such as analyzing the changes in the number of threatened species over time, understanding the distribution of threatened species across different main habitat types, and...

  • Number of Threatened Species by Main Habitat Type - Luke (Finland)TSV

    This table contains data on the number of threatened species. It includes information such as the extraction date of the data, the row number, the year of the observation, the main habitat type for the species, the species name, and the number of threatened species. The data in this table can be used for various data analytics purposes. For example, it can be used to analyze the trends and changes in the number of threatened species over time. It can also be used to study the distribution of threatened species by habitat type or to identify the most threatened species. The data in this table is sourced from the web site of Luke, which originates from Finland (ISO country code 'FI').

  • Number of Threatened Species by Main Habitat Type from Luke (Finland)TSV

    This table contains data on the number of threatened species categorized by the main habitat type. The data is sourced from the website of Luke, which originates from Finland (ISO country code: fi). The table includes columns such as 'extract_date', 'row_number', 'code', and 'label'. The table can be utilized in data analytics to analyze trends in the number of threatened species in different main habitat types. For example, it can be used to determine which habitat types have the highest number of threatened species and to identify any changes in the distribution of threatened species over time.

  • Version History of Number of Threatened Species FactTSV

    This table contains the version history of rows from the 'number_of_threatened_species_number__fact' table, sourced from the web site of 'Luke' from Finland. It includes information about the start and end dates of each row version, as well as additional columns such as 'year', 'main_habitat_type', 'species', and 'number_of_threatened_species_number'. The data in this table can be utilized in data analytics to track changes and trends in the number of threatened species over time, identify the main habitat types where species are most at risk, analyze specific species affected, and measure the magnitude of the threat through the 'number_of_threatened_species_number' column.

Column Descriptions

Number of Threatened Species by Main Habitat Type - Luke (Finland)

Column Type Comment
_extract_date date The date when the data was extracted from the source.
_row_number long The unique identifier for each row in the table.
year int The year for which the data pertains.
main_habitat_type string The main habitat type where the species are found.
species string The name of the species.
number_of_threatened_species_number int The number of species that are threatened in the specified habitat type and year.

Version History of Number of Threatened Species Fact

Column Type Comment
_start_date date The start date of the validity period of the row version.
_end_date date The end date of the validity period of the row version.
_row_number long A unique identifier for each row version.
year int The year associated with the data in the row version.
main_habitat_type string The main type of habitat where the species is found in the row version.
species string The name of the species in the row version.
number_of_threatened_species_number int The number of threatened species in the row version.

Number of Threatened Species by Main Habitat Type from Luke (Finland)

Column Type Comment
_extract_date date The date when the data was extracted.
_row_number long The unique identifier for each row in the table.
code string The code associated with a particular item.
label string The label or name of a particular item.

History of Number of Threatened Species by Main Habitat Type (Luke, Finland)

Column Type Comment
_start_date date The start date of the validity period of the row version.
_end_date date The end date of the validity period of the row version.
_row_number long The number assigned to the row version.
code string The code associated with the row version.
label string The label or description of the row version.

Additional Info

Last Updated May 20, 2024
Created September 29, 2023