Version History of Producer Prices for Fish in Euro/Kg - Processing Dimension - From Luke (Finland)
Click here for a data sample
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 prices based on specific codes and labels, and detecting anomalies or outliers in the price data.
Field Descriptions
| Názov |
Data type |
Popis |
| _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. |
|---|
