Grain Quality - Version History (Luke - Finland)
Click here for a data sample
This table contains the version history of the rows in the 'grain_quality__fact' table. Each row represents a specific version of a grain quality observation. 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 table is sourced from the website of 'Luke', which is a data source from Finland (ISO country code: FI). The data in this table can be utilized in various data analytics tasks such as analyzing trends in grain quality over time, identifying changes in grain quality for different species, and examining grain quality variations at different locations represented by 'ely_centre' column values.
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 | The unique identifier for each row version. |
|---|
| year | int | The year associated with the row version. |
|---|
| ely_centre | int | The geographical centre of the ELY region associated with the row version. |
|---|
| variable | string | The variable associated with the row version. |
|---|
| species | string | The species associated with the row version. |
|---|
| grain_quality | int | The quality of the grain associated with the row version. |
|---|
