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

Fish Used for Human Consumption (kg/person/year)

The dataset collection contains information about fish used for human consumption in kilograms per person per year. The tables in the collection are sourced from the web site of Luke (Natural Resources Institute Finland) in Finland.

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 May 12, 2024
Created May 11, 2024