Version History of Farmland Bird Index by Region
Click here for a data sample
This table contains the version history of the rows from the base table 'farmland_bird_index_by_region__fact'. The rows in this table represent different versions of the data extracted from the data source. Each row in the table has a unique identifier column '_row_number' and contains information about the 'year', 'area', and 'farmland_bird_index'. The column '_start_date' indicates the date when the row was extracted, while the column '_end_date' indicates the date when a new version of the row was extracted. If the value in the column '_end_date' is null, it represents the most recent version of the row. The data in this table can be used for various data analytics tasks, such as analyzing the trends and changes in farmland bird index over time in different regions. The table is sourced from the web site of 'Luke', which is an agricultural research organization based in Finland (ISO country code: 'fi').
Field Descriptions
Name |
Data type |
Description |
_start_date | date | The start date of the validity period of the row version. |
_end_date | date | The end date of the validity period of the row version. |
_row_number | long | The row number of the version history. |
year | int | The year of the recorded data. |
area | string | The area associated with the recorded data. |
farmland_bird_index | string | The index representing the population of farmland birds recorded. |