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

Producer Prices for Salmon in Finland (Luke)

This dataset collection contains producer prices for salmon in EKG units. The tables in this collection are sourced from the website of Luke in Finland.

Tables

  • Producer Prices for Salmon (KG) by YearTSV

    This table contains the producer prices for salmon (per kilogram) dataset, organized by year. The data is sourced from Luke, which is the Natural Resources Institute Finland, and originates from the country Finland (ISO country code: FI). The table includes information on the extraction date of the data and row numbers. Additionally, it includes codes and labels related to the salmon prices. This dataset can be utilized in data analytics to analyze the historical trends and fluctuations in the producer prices for salmon in Finland over the years.

  • Producer Prices for Salmon in FinlandTSV

    This table contains data on producer prices for salmon in kilograms (kg). The data is sourced from 'Luke', which is a website from Finland (ISO country code 'fi'). The table includes information such as the extraction date, row number, area, size class, month, year, and producer prices for salmon. The data in this table can be utilized in various data analytics scenarios, such as analyzing price trends over time, identifying areas with higher producer prices, examining the impact of size class on prices, and exploring monthly and yearly variations in producer prices for salmon.

  • Version History of Producer Prices for Salmon (EKG) - Extracted from Luke Website - FinlandTSV

    This table contains the version history of the rows from the 'producer_prices_for_salmon_ekg__fact' base table. The rows in this history table have additional columns '_start_date' and '_end_date', representing the date when the row was extracted from the data source, and the date when a new version of the row was extracted, respectively. If the value of the column '_end_date' is null, it means that the row is the most recent version. The table sources its data from the 'Luke' website, which originates from Finland (ISO country code: 'fi'). The data in this table can be utilized for various data analytics purposes, such as analyzing the historical changes in producer prices for salmon throughout different areas and size classes, examining the monthly and yearly trends in producer...

  • Version History of Producer Prices for Salmon (EKG) per Year - Luke FinlandTSV

    This table contains the version history of the rows in the 'producer_prices_for_salmon_ekg__dim_year' table. It provides information about the start and end dates of each version, as well as the unique row number, code, and label associated with each row. The data in this table can be utilized for various data analytics purposes. For example, it can be used to track the changes in producer prices for salmon over time, analyze the trends in pricing, identify patterns or anomalies, and perform historical comparisons. The data for this table is sourced from the web site of 'Luke', which originates from Finland (ISO country code: FI).

Column Descriptions

Producer Prices for Salmon in Finland

Column Type Comment
_extract_date date The date on which the data was extracted.
_row_number long The unique identifier for each row in the table.
area string The geographical area of the data.
sizeclass string The size classification of the data.
month int The month of the data.
year int The year of the data.
producer_prices_for_salmon int The producer prices for salmon.

Version History of Producer Prices for Salmon (EKG) - Extracted from Luke Website - 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 identifier for each row version in the table.
area string The geographical area associated with the row version.
sizeclass string The size class of the row version.
month int The month associated with the row version.
year int The year associated with the row version.
producer_prices_for_salmon int The producer prices for salmon associated with the row version.

Producer Prices for Salmon (KG) by Year

Column Type Comment
_extract_date date The date when the data was extracted from the source system.
_row_number long The unique identifier of each row in the table.
code int The code associated with a particular item or entity.
label int The descriptive label or name for a particular item or entity.

Version History of Producer Prices for Salmon (EKG) per Year - 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 A unique identifier for each row version in the table.
code int A unique code associated with each row version.
label int The label or name associated with each row version.

Additional Info

Last Updated May 16, 2024
Created May 15, 2024