Fish Used for Human Consumption (kg/person/year)
Tables
-
Fish Consumed per Person per Year for Human Consumption (origin country: Finland)TSV
The 'fish_used_for_human_consumption_kgpersonyear__dim_origin' table contains data on the amount of fish used for human consumption per person per year, categorized by the origin of the fish. The data is sourced from the web site of 'Luke', which originates from Finland (ISO country code 'FI'). This table can be used for various data analytics purposes, such as studying the trends in fish consumption over time, analyzing the impact of different fish origins on consumption patterns, and identifying the countries with the highest and lowest fish consumption per person.
-
Fish Used for Human Consumption (kg/person/year) - Year History from Luke (Finland)TSV
This table contains the version history of the rows from the 'fish_used_for_human_consumption_kgpersonyear__dim_year' table. It includes two additional columns compared to its base table: '_start_date' and '_end_date'. The '_start_date' column stores the date when the row was extracted from the Luke data source, while the '_end_date' column stores 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, sourced from the Luke website, provides information about the consumption of fish used for human consumption in kilograms per person per year in various years. This data can be utilized in data analytics to analyze trends in fish consumption over time, identify patterns in consumption...
-
Fish Used for Human Consumption (kg/person/year) by SpeciesTSV
This table contains information about the usage of fish for human consumption in kilograms per person per year. The data is sourced from the web site of Luke, which originates from Finland.
-
Fish Used for Human Consumption (kg/person/year) by YearTSV
This table contains data on the amount of fish used for human consumption in kilograms per person per year. 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'. The data in this table can be utilized in data analytics to analyze trends in fish consumption over time, compare fish consumption across different regions or demographic groups, understand the impact of fish consumption on nutrition and health, and assess the sustainability of fish consumption practices.
-
Fish Used for Human Consumption per Person per Year - Data from Luke (Finland)TSV
This table contains data on fish consumption for human consumption in kilograms per person per year. The data is sourced from the web site of Luke, which originates from Finland (ISO country code 'fi'). The table includes information such as the extraction date of the data, the row number, the origin of the fish, the species of the fish, the year of observation, and the amount of fish consumption. This data can be utilized in data analytics to analyze trends in fish consumption over time, compare consumption patterns between different origins and species, identify changes in consumption habits, and assess the impact of fish consumption on human health and nutrition.
-
Historical Version of Fish Consumption for Human Consumption (Kg/Person/Year) from Luke - FinlandTSV
This table contains the version history of the rows from the 'fish_used_for_human_consumption_kgpersonyear__fact' table. Each row represents a specific version of data extracted from the web site of 'Luke' which originates from Finland (ISO country code 'fi'). The '_start_date' column indicates the date when the row was extracted, while the '_end_date' column represents 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 of the data. This table can be utilized in data analytics projects to analyze the historical changes in the consumption of fish for human consumption (measured in kilograms per person per year) in different years, origins, and species. With the help of this table, trends, patterns,...
-
Version History of Fish Used for Human Consumption in FinlandTSV
This table is the version history of the rows in the 'fish_used_for_human_consumption_kgpersonyear__dim_species' table. It contains the start and end dates for each version of the rows, along with other columns such as 'code' and 'label'. The data in this table can be utilized in various data analytics scenarios. For example, it can be used to track the changes in fish consumption patterns over time, analyze the impact of different species on human consumption, or identify trends in fish consumption in specific regions. The table is sourced from the website of 'Luke', which originates from Finland (ISO country code 'fi').
-
Version History of Fish Used for Human Consumption per Person per Year by Origin (Sourced from Luke, Finland)TSV
This table contains the version history of the rows from the 'fish_used_for_human_consumption_kgpersonyear__dim_origin' table, with additional columns '_start_date' and '_end_date'. The '_start_date' column indicates the date when the row was extracted from the data source, while the '_end_date' column indicates 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. The data in this table is sourced from the web site of the Luke organization, which originates from Finland (ISO country code 'fi'). The table can be used for data analytics to analyze the historical changes and trends in fish consumption for human consumption in different origins, allowing for insights and comparisons to be made...
Column Descriptions
Fish Used for Human Consumption (kg/person/year) by Year
Column | Type | Comment |
---|---|---|
_extract_date | date | The date when the row was extracted from the source system. |
_row_number | long | The unique identifier assigned to each row in the table. |
code | int | The code associated with a specific label. |
label | int | The human-readable label or name associated with a specific code. |
Fish Used for Human Consumption (kg/person/year) - Year History from Luke (Finland)
Column | Type | Comment |
---|---|---|
_start_date | date | '_start_date' is a column indicating the start date of the validity period of the row version. |
_end_date | date | '_end_date' is a column indicating the end date of the validity period of the row version. |
_row_number | long | '_row_number' is a column representing the unique number assigned to each row version in the table. |
code | int | 'code' is a column representing a code associated with the row version in the table. |
label | int | 'label' is a column representing a label associated with the row version in the table. |
Fish Consumed per Person per Year for Human Consumption (origin country: Finland)
Column | Type | Comment |
---|---|---|
_extract_date | date | The date when the data was extracted from the source system. |
_row_number | long | The sequential number assigned to each row in the table. |
code | string | A unique identifier for each entry in the table. |
label | string | A descriptive label for each entry in the table. |
Version History of Fish Used for Human Consumption per Person per Year by Origin (Sourced 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 | A unique number assigned to each row version. |
code | string | The code associated with the row version. |
label | string | The label/identifier associated with the row version. |
Fish Used for Human Consumption per Person per Year - Data from Luke (Finland)
Column | Type | Comment |
---|---|---|
_extract_date | date | The date when the data was extracted from the source |
_row_number | long | The row number of the data entry in the source |
origin | string | The country or region of origin of the data |
species | string | The name of the fish species |
year | int | The year of the fish consumption data |
fish_consumption | int | The amount of fish consumed in kilograms |
Historical Version of Fish Consumption for Human Consumption (Kg/Person/Year) from Luke - Finland
Column | Type | Comment |
---|---|---|
_start_date | date | The start date indicating the beginning of the validity period of the row version. |
_end_date | date | The end date indicating the ending of the validity period of the row version. |
_row_number | long | The unique identifier of each row version. |
origin | string | The origin or source of the data. |
species | string | The species of the data. |
year | int | The year associated with the data. |
fish_consumption | int | The amount of fish consumption recorded for a specific row version. |
Fish Used for Human Consumption (kg/person/year) by Species
Column | Type | Comment |
---|---|---|
_extract_date | date | The date when the row was extracted from the data source. |
_row_number | long | The sequential number assigned to each row in the table. |
code | string | The unique code associated with a particular item in the table. |
label | string | The descriptive label or name assigned to a particular item in the table. |
Version History of Fish Used for Human Consumption in Finland
Column | Type | Comment |
---|---|---|
_start_date | date | The date and time when the row version becomes valid. |
_end_date | date | The date and time when the row version expires or becomes invalid. |
_row_number | long | The unique identifier of the row version. |
code | string | The code associated with the row version. |
label | string | The label or name assigned to the row version. |
Additional Info
Last Updated | August 3, 2024 |
---|---|
Created | May 11, 2024 |