Version History of Farmland Bird Index by Region

To download the data set, please sign up or log in

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_datedateThe start date of the validity period of the row version.
_end_datedateThe end date of the validity period of the row version.
_row_numberlongThe row number of the version history.
yearintThe year of the recorded data.
areastringThe area associated with the recorded data.
farmland_bird_indexstringThe index representing the population of farmland birds recorded.

No sample for this dataset

Additional Information

Last updated May 11, 2024
Created May 11, 2024
License No License Provided
Geographic coverage
Geographic granularity
Temporal coverage from
Temporal coverage to
Temporal coverage to
Adapterdelta
Countryfi
Databasefi_luke
Extract date2018-09-28
Idbf31319f-ef05-4465-be3d-d7feb0ff94eb
Package idc508a93c-4217-4fcd-8041-0bb66b21df20
Position3
Revision idf00d35d9-07d6-4f8a-a6a0-919563f858cd
Stateactive
Tablefarmland_bird_index_by_region__fact__history