Version History of Producer Prices for Bream (Luke, Finland)
Click here for a data sample
This table contains the version history of the base table 'producer_prices_for_bream_ekg__fact'. It tracks changes in the producer prices for bream in different areas, size classes, months, and years. Each row in this table represents a specific version of a row in the base table and includes additional columns '_start_date' and '_end_date'. The '_start_date' column indicates the date when the row was extracted from the data source, whereas the '_end_date' column specifies the date when a new version of the row was extracted. If the '_end_date' is null, it means that the row represents the most recent version. The data in this table could be utilized in data analytics to analyze the temporal patterns of producer prices for bream, identify pricing trends, compare prices across various areas and size classes, and investigate the effect of seasonal or yearly variations on the prices. The table is sourced from the web site of Luke, which is an organization from Finland (ISO country code 'fi').
Field Descriptions
Name |
Data type |
Description |
_start_date | date | The start date indicating the validity period of the row version. |
_end_date | date | The end date indicating the validity period of the row version. |
_row_number | long | The number assigned to the row version. |
area | string | The area associated with the data. |
sizeclass | string | The size class of the data. |
month | int | The month of the data. |
year | int | The year of the data. |
producer_prices_for_bream | string | The producer prices for bream. |