Game Bag Dataset Collection from Luke in Finland
Tables
-
Game Bag - Species DimensionTSV
This table contains data related to species in Luke's game bag. The data is sourced from the web site of Luke, which originates from Finland (ISO country code: fi). The table provides information about each species, including the extraction date, row number, species code, and species label. The data in this table can be utilized in various data analytics scenarios, such as analyzing the number of species hunted over time, identifying the most common species, tracking the distribution of different species, or studying the changes in species populations.
-
Game Bag Dimension AreaTSV
This table contains data from the 'Luke' website, which originates from Finland (ISO country code 'fi'). The table provides information about game bag areas. The '_extract_date' column represents the date when the data was extracted. The '_row_number' column stores the unique identifier for each row. The 'code' column contains the code associated with each area. The 'label' column contains the name or label of each area. This table can be used in data analytics to analyze and understand the distribution and abundance of game in different areas, track changes in game bag numbers over time, and compare game bag sizes and species composition between different areas.
-
Game Bag Statistics by Area, Species, and Year from Luke (Finland)TSV
This table contains data from the game bag statistics provided by Luke, the Natural Resources Institute Finland. The data is sourced from the website of Luke and originates from Finland (ISO country code 'fi'). The table consists of several columns including '_extract_date', '_row_number', 'area', 'species', 'year', and 'game_bag'. These columns hold information related to the game bag statistics, such as the date of extraction, row numbers, the specific area, species of game, the year the data corresponds to, and the game bag count. This table can be used in various data analytics scenarios, such as analyzing trends in game bag counts over different years, studying the distribution of game species across different areas, or identifying areas with high game bag counts.
-
Version History of Game Bag Data from Luke (Finland)TSV
This table contains the version history of rows from the 'game_bagfact' table. Each row in this 'game_bagfact__history' table represents a specific version of a row from the base table. The '_start_date' column indicates the date when the extraction of a row version was started, while the '_end_date' column shows the date when the next version of the row was extracted. If the value in the '_end_date' column is null, it means that the row is the most recent version available. The data in this table can be utilized for various data analytics purposes. For example, it can be used to analyze the changes in the number of game bags recorded over time, the distribution of game bags by different areas, species, and years, or any other trends related to game bags. By examining the version...
-
Version History of Game Bag Dimension Area from Luke (Finland)TSV
This table contains the version history of the rows from the 'game_bagdim_area' table. Each row in this 'game_bagdim_areahistory' table represents a specific version of the corresponding row in the base table. The columns '_start_date' and '_end_date' indicate the extraction dates for each version of the row. If the value in the '_end_date' column is null, it means that the row is the most recent version. The data in this table can be utilized for data analytics purposes. For example, it can be used to track changes and updates made to the 'game_bagdim_area' table over time. By analyzing the start and end dates, it is possible to identify when and how the data in the base table has been modified. This can provide valuable insights into the evolution of the data source. The data in this...
-
Version History of Game Bag Species from Luke (Finland)TSV
This table contains the version history of the rows in the 'game_bag__dim_species' table. It is sourced from the web site of 'Luke' which originates from the country Finland. The '_start_date' column stores the extraction date of each row, while the '_end_date' column stores the date when a new version of the row was extracted. If the value in the '_end_date' column is null, it means that the row is the most recent version of the data. The table can be used for various data analytic purposes such as analyzing changes over time, tracking updates, and identifying trends and patterns in the game bag species codes and labels.
Column Descriptions
Game Bag - Species Dimension
| Column | Type | Comment |
|---|---|---|
| _extract_date | date | The date on which the data was extracted. |
| _row_number | long | The numerical row number of the data. |
| code | string | A unique code associated with the data. |
| label | string | A descriptive label for the data. |
Version History of Game Bag Species from Luke (Finland)
| Column | Type | Comment |
|---|---|---|
| _start_date | date | This column represents the start date of the validity period for the row version. |
| _end_date | date | This column represents the end date of the validity period for the row version. |
| _row_number | long | The row number assigned to each record in the table for identification purposes. |
| code | string | This column stores the code associated with the row version. |
| label | string | This column contains the label or description of the row version. |
Game Bag Dimension Area
| Column | Type | Comment |
|---|---|---|
| _extract_date | date | The date when the data was extracted |
| _row_number | long | The row number of the record |
| code | string | The code associated with the item |
| label | string | The label or name of the item |
Version History of Game Bag Dimension Area from Luke (Finland)
| Column | Type | Comment |
|---|---|---|
| _start_date | date | The start date of the validity period for the row version. |
| _end_date | date | The end date of the validity period for the row version. |
| _row_number | long | The unique identifier of the row version. |
| code | string | The code associated with the row version. |
| label | string | The label or description of the row version. |
Game Bag Statistics by Area, Species, and Year from Luke (Finland)
| Column | Type | Comment |
|---|---|---|
| _extract_date | date | This column represents the date when the data was extracted from the source. |
| _row_number | long | This column represents the row number of each entry in the table. |
| area | string | This column represents the area where the data was recorded. |
| species | string | This column represents the species of the game captured. |
| year | int | This column represents the year when the data was recorded. |
| game_bag | int | This column represents the number of game captured in the bag during the hunting season. |
Version History of Game Bag Data from Luke (Finland)
| Column | Type | Comment |
|---|---|---|
| _start_date | date | The start date of the validity period of this row version. |
| _end_date | date | The end date of the validity period of this row version. |
| _row_number | long | The unique identifier of the row version. |
| area | string | The geographical area where the game was hunted. |
| species | string | The type of species that was hunted. |
| year | int | The year when the game was hunted. |
| game_bag | int | The number of game bags collected during the hunt. |
Additional Info
| Last Updated | March 1, 2025 |
|---|---|
| Created | October 2, 2023 |