Version History of Farms Engaged in Direct Sales in Finland
Click here for a data sample
This table provides the version history of the rows in the 'Number of Farms Engaged in Direct Sales' fact table. The data in this table is sourced from the 'Luke' website, which originates from Finland. It contains information about the number of farms engaged in direct sales, categorized by different years, ely_centre, and variable. The 'start_date' column indicates the date when each 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 'end_date' value is null, it means that the row represents the most recent version. This table can be used for various data analytics purposes such as trend analysis, identifying changes in the number of farms engaged in direct sales over time, and comparing the distribution of farms across different variables and ely_centres.
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 row number of the version in the history table. |
|---|
| year | int | The year the data represents. |
|---|
| ely_centre | int | The geographical center of the Economic Local Area (ELY). |
|---|
| variable | string | The specific variable or metric measured. |
|---|
| number_of_farms_engaged_in_direct_sales | int | The count of farms engaged in direct sales for the given metric and ELY. |
|---|
