Version History of Producer Prices for Salmon (EKG) - Extracted from Luke Website - Finland
Click here for a data sample
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 prices, and conducting comparative analysis between different time periods.
Field Descriptions
| Name |
Data type |
Description |
| _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. |
|---|
