Catches of 1,000 kg by fishing season in commercial inland fishery
Tables
-
Catches (1,000 kg) by Fishing Season in Commercial Inland FisheryTSV
This table contains data on the catches in commercial inland fishery in Finland by fishing season. It provides information on different species and their yearly catches in kilograms. The data includes extraction date, row number, fishing season, species, year, and catches in commercial inland fishery. The table can be utilized in data analytics to analyze trends and patterns in catches by fishing season, examine the impact of fishing seasons on different species, compare yearly catches for different species, and assess the overall performance of commercial inland fishery in Finland. The data for this table is sourced from the web site of Luke, which originates from Finland (ISO country code 'fi').
-
Catches (1,000 kg) by Fishing Season in Commercial Inland Fishery, by Species - Finland Fisheries DataTSV
This table contains data on the catches of fish in commercial inland fishery, measured in kilograms, categorized by fishing season. The data is sourced from the website of Luke, which is the Natural Resources Institute Finland. The data is specific to Finland, which is identified by the ISO country code 'fi'. The table includes columns such as 'extract date', 'row number', 'code', and 'label'. The table can be utilized in various data analytics scenarios, such as analyzing trends in fish catches over different fishing seasons, comparing catch volumes for different fish species, identifying patterns in the extraction dates of the data, and performing statistical analyses on the commercial inland fishery data in Finland.
-
Catches 1,000 kg by Fishing Season in Commercial Inland FisheryTSV
This table contains information about the amount of fish caught in kilograms by fishing season in the commercial inland fishery. The data is sourced from the website of Luke, which is the Natural Resources Institute Finland. The data is specific to the country Finland (ISO country code: FI). The table includes columns such as '_extract_date', '_row_number', 'code', and 'label'. These columns can be used for various data analytics purposes such as analyzing the trends in fish catch over different fishing seasons, identifying the most productive fishing seasons, or comparing the catch volumes across different regions or fish species.
-
Version History of Catches (1,000 kg) by Fishing Season in Commercial Inland Fishery - Fishing Season Dimension - HistoryTSV
This table represents the version history of the rows extracted from the catches_1_000_kg_by_fishing_season_in_commercial_inland_fishery__dim_fishing_season table. The rows in this table contain information about the fishing season, including a unique code and a label. Each row has a start date, which is the date when the row was extracted from the data source, and an end date, which is the date when a new version of the row was extracted. If the end date is null, it means that the row is the most recent version. The data in this table can be used for data analytics purposes, such as analyzing trends in fish catches by fishing season or comparing historical fishing season data. This table is sourced from the 'Luke' website, which is hosted in Finland (ISO country code: fi).
-
Version History of Catches (1,000 kg) in Commercial Inland Fishery by Fishing Season and Species - FinlandTSV
This table contains the version history of the rows in the 'catches_1_000_kg_by_fishing_season_in_commercial_inland_fishery__dim_species' table. Each row represents a specific version of a record in the base table, with additional columns '_start_date' and '_end_date' indicating the start and end dates of the version. The data is sourced from the website of Luke, which originates from Finland (ISO country code 'fi'). The table can be used for data analytics to track changes in catches of 1,000 kg by fishing season in commercial inland fishery, segmented by the species. Analyzing the changes over time can provide insights into trends, patterns, and variations in catch quantities for different species in the commercial inland fishery sector.
-
Version History of Catches in Commercial Inland Fishery by Fishing Season - Luke (Finland)TSV
This table stores the version history of the rows in the 'catches_1_000_kg_by_fishing_season_in_commercial_inland_fishery__fact' table. The rows in this version history table have additional columns '_start_date' and '_end_date'. The '_start_date' column contains the date when a specific version of the row was extracted from the data source, while the '_end_date' column contains the date when a new version of the row was extracted. If the '_end_date' value is null, it means that the row is the most recent version. The data in this table can be utilized in data analytics to track changes in catches of 1,000 kilograms by fishing season in commercial inland fishery. The fishing season, species, year, and catches in commercial inland fishery columns provide valuable information for...
Column Descriptions
Catches 1,000 kg by Fishing Season in Commercial Inland Fishery
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 the item. |
label | string | The label or name of the item. |
Version History of Catches (1,000 kg) by Fishing Season in Commercial Inland Fishery - Fishing Season Dimension - History
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 unique identifier of the row version. |
code | string | The code associated with the row version. |
label | string | The label associated with the row version. |
Catches (1,000 kg) by Fishing Season in Commercial Inland Fishery, by Species - Finland Fisheries Data
Column | Type | Comment |
---|---|---|
_extract_date | date | Date when the data was extracted. |
_row_number | long | A unique identifier for each row in the table. |
code | string | A code representing a specific value or category. |
label | string | A descriptive label associated with a specific code. |
Version History of Catches (1,000 kg) in Commercial Inland Fishery by Fishing Season and Species - Finland
Column | Type | Comment |
---|---|---|
_start_date | date | The start date of the validity period of the row version in the table |
_end_date | date | The end date of the validity period of the row version in the table |
_row_number | long | The sequential number assigned to each row in the table |
code | string | A code associated with the row version in the table |
label | string | A label describing the row version in the table |
Catches (1,000 kg) by Fishing Season in Commercial Inland Fishery
Column | Type | Comment |
---|---|---|
_extract_date | date | The date the data was extracted from the source system. |
_row_number | long | The unique identifier for each row in the table. |
fishing_season | string | The time period during which fishing activities take place. |
species | string | The specific type of fish species being caught. |
year | int | The year in which the fishing activities occurred. |
catches_in_commercial_inland_fishery | int | The total number or weight of fish catches in the commercial inland fishery for a specific time period. |
Version History of Catches in Commercial Inland Fishery by Fishing Season - 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 number assigned to the row version |
fishing_season | string | The season of fishing for the data in the row version |
species | string | The species of fish in the row version |
year | int | The year associated with the data in the row version |
catches_in_commercial_inland_fishery | int | The number of catches in the commercial inland fishery for the row version |
Additional Info
Last Updated | May 20, 2024 |
---|---|
Created | October 2, 2023 |