Number of Threatened Species Dataset Collection
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 |