Version History of Agricultural Area Cultivated with the Same Crop by Region Fact (Luke - Finland)
Click here for a data sample
This table contains the version history of the rows in the 'agricultural_area_cultivated_with_the_same_crop_by_region__fact' table. The rows in this table represent the agricultural area cultivated with the same crop by region and its historical changes over time. Each row has two additional columns compared to the base table: '_start_date' and '_end_date', which indicate the period when the row was extracted from the source. If the '_end_date' column has a null value, it signifies that the row is the most recent version. The table's data is sourced from Luke, which is an agricultural research organization in Finland (ISO country code: FI). The data in this table can be utilized for various data analytics purposes, such as analyzing trends in agricultural area cultivated with the same crop over time, comparing cultivation patterns between different regions, identifying changes in crop cultivation practices, and performing regional agricultural performance assessments.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | This column indicates the start date of the validity period of a row version in the table. It is used to track when the row version became active. |
|---|
| _end_date | date | This column indicates the end date of the validity period of a row version in the table. It is used to track when the row version expires. |
|---|
| _row_number | long | This column represents the unique identifier assigned to each row version in the table. |
|---|
| year | string | This column stores the year information related to the data represented by a row version. |
|---|
| ely_centre | int | This column contains information about the ELY centre associated with the row version. |
|---|
| info | string | This column stores additional information or details related to the row version. |
|---|
| agricultural_area_cultivated_with_the_same_crop | int | This column stores the size or area of agricultural land cultivated with the same crop for the row version. |
|---|
