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

Producer Prices for Fish in Finland (LUKE)

This dataset collection consists of producer prices for fish in European countries. The data is sourced from the website of Luke, the Natural Resources Institute Finland. The tables in this collection provide information on the prices of different fish species in Finland and other European countries. The dataset collection includes data on the prices per kilogram of various fish species, allowing users to analyze trends and patterns in fish prices over time. The dataset collection is a valuable resource for researchers, policymakers, and anyone interested in the fish industry and market dynamics in Europe.

Tables

  • History of Fish Producer Prices in Euro per Kilogram by Area in Finland from LUKETSV

    This table contains the version history of rows from the 'producer_prices_for_fish_eurokgdim_area' table. Each row represents a specific version of data extracted from the web site of 'Luke' in Finland. The 'producer_prices_for_fish_eurokgdim_area__history' table includes additional columns compared to its base table, such as '_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 of the '_end_date' column is null, it means that the row is the most recent version. The data in this table can be utilized in various data analytics scenarios, such as monitoring the price fluctuations of fish producer prices over time,...

  • Producer Prices for Fish (Euro/kg) - FinlandTSV

    This table contains data from the website of Luke, which is an agricultural research center in Finland. The table 'producer_prices_for_fish_eurokg__fact' provides information about the prices of various fish species in euros per kilogram. The data includes the extraction date and row number of each entry, the area where the fish was produced, the processing method used, the name of the fish species, the month and year of the price data, and the producer price for the fish. This table can be utilized in data analytics to analyze the variations in fish prices over time and across different areas, to identify trends in consumer demand for different fish species, and to compare the prices of fish produced using different processing methods. It can also be used to calculate average prices,...

  • Producer Prices for Fish (Euro/kg) Fact HistoryTSV

    This table contains the version history of the rows from the base table 'producer_prices_for_fish_eurokg__fact'. The rows in this table include 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 of the '_end_date' column is null, it means that the row represents the most recent version of the row. The data in this table is sourced from the web site of 'Luke', which originates from Finland (ISO country code 'fi'). The table can be utilized in data analytics to analyze the historical changes in producer prices for fish in different areas and processing methods. It can also be used to analyze...

  • Producer Prices for Fish (in euros per kilogram) by AreaTSV

    This table contains producer prices for fish in euros per kilogram. The data is sourced from the website of Luke (Natural Resources Institute Finland), which originates from Finland (ISO country code: FI). The table includes information such as the extraction date, row number, code, and label. The data in this table can be utilized for various data analytics purposes, such as analyzing the fluctuation of fish prices over time, comparing prices across different fish species, identifying trends in fish prices, and studying the impact of external factors on fish prices.

  • Producer Prices for Fish in Euro per Kilogram - ProcessingTSV

    This table contains producer prices for fish in Euro per kilogram. The data is sourced from Luke, which is the Natural Resources Institute Finland. The data originates from Finland, which has the ISO country code 'fi'. The table consists of information related to different fish processed for consumption. The information includes the extract date and row number for each record, as well as the code and label for the fish. The data in this table can be utilized for various data analytics purposes, such as analyzing trends in fish prices over time, identifying the most commonly processed fish, or comparing prices of different fish species.

  • Version History of Producer Prices for Fish in Euro/Kg - Processing Dimension - From Luke (Finland)TSV

    This table contains the version history of the rows extracted from the data source 'Luke' in Finland. It is a historical snapshot of the base table 'producer_prices_for_fish_eurokg__dim_processing', representing data related to the prices of fish in Euros per kilogram. Each row in this table corresponds to a specific version of a row in the base table, indicating the time period during which the row was valid. The '_start_date' column specifies the date when the row was extracted, while the '_end_date' column specifies 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. The table can be used in various data analytics scenarios, such as analyzing price trends over time, identifying changes in fish...

Column Descriptions

Producer Prices for Fish (Euro/kg) - Finland

Column Type Comment
_extract_date date The date and time when the data was extracted.
_row_number long A unique identifier for each row in the table.
area string The geographical area where the data was collected.
processing string The type of processing applied to the data.
species string The species of the fish being analyzed.
month int The month when the data was collected.
year int The year when the data was collected.
producer_prices_for_fish int The average producer prices for the fish in a given area, month, and year.

Producer Prices for Fish (Euro/kg) Fact History

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 assigned to each row version.
area string The geographic area associated with the row version.
processing string The processing status of the row version.
species string The species associated with the row version.
month int The month for which the row version is valid.
year int The year for which the row version is valid.
producer_prices_for_fish int The producer prices for fish associated with the row version.

Producer Prices for Fish in Euro per Kilogram - Processing

Column Type Comment
_extract_date date The date when the data was extracted.
_row_number long The sequential number of each row in the table.
code string The unique code assigned to each record.
label string The label or name used to identify the record.

Version History of Producer Prices for Fish in Euro/Kg - Processing Dimension - 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 ordinal number of the row version in the history.
code string The code associated with the row version.
label string The label or name of the row version.

Producer Prices for Fish (in euros per kilogram) by Area

Column Type Comment
_extract_date date The date when the data was extracted.
_row_number long The row number in the database table.
code string The code associated with a particular entry in the table.
label string The label or description of the entry in the table.

History of Fish Producer Prices in Euro per Kilogram by Area in Finland from LUKE

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 sequential number assigned to each row version.
code string The code associated with the row version.
label string The label associated with the row version.

Additional Info

Last Updated May 15, 2024
Created May 15, 2024