Farmland Bird Index by Region

This dataset collection contains tables sourced from the 'Luke' website in Finland. It provides data on the Farmland Bird Index by region in Finland. The tables within this dataset collection offer comprehensive information about the bird populations in different regions across the country. The dataset collection offers valuable insights into the abundance and distribution of bird species in Finland's farmland areas. Researchers, conservationists, and individuals interested in avian ecology can utilize this dataset collection for various studies and analyses related to bird populations and their habitats in Finland.

Tables

Farmland Bird Index by Region - FactTSV
This table contains data from 'Luke' website, which originates from Finland (ISO country code 'fi'). The table 'farmland_bird_index_by_region__fact' provides information on the farmland bird index by region. It includes columns such as '_extract_date', '_row_number', 'year', 'area', and 'farmland_bird_index'. The data in this table can be utilized in various data analytics tasks, such as analyzing the trends of farmland bird populations over time, studying the correlation between the bird index and different regions, identifying areas with high or low bird diversity, and assessing the impact of agricultural practices on bird populations.
Farmland Bird Index by Region and YearTSV
This table provides the farmland bird index by region and year. It contains data sourced from the website of Luke, which originates from Finland. The table includes information about the extraction date, row number, code, and label. The data in this table can be utilized in various data analytics scenarios, such as analyzing the trends in farmland bird populations across different regions and years, identifying regions with the highest and lowest bird index values, and examining the changes in bird populations over time.
Farmland Bird Index by Region: AreaTSV
This table contains data from the 'farmland_bird_index_by_region__dim_area' table sourced from the website of Luke, which originates from the country Finland (ISO country code: fi). The table provides information on the farmland bird index by region, including the extract date, row number, code, and label columns. The data in this table can be utilized in various data analytics scenarios, such as analyzing trends in farmland bird populations across different regions over time, identifying regions with high or low bird index scores, and assessing the impact of environmental factors on the bird index.
Version History of Farmland Bird Index by RegionTSV
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...
Version History of Farmland Bird Index by Region by Year in Finland from LukeTSV
This table contains the version history of rows from the 'farmland_bird_index_by_region__dim_year' table. Each row in this table represents a specific version of a row from the base table, along with the dates indicating when the version became effective and when it was replaced by a new version. The data in this table is sourced from the web site of 'Luke', which originates from Finland. The table can be utilized in various data analytics scenarios, such as tracking changes in the farmland bird index by region over time, analyzing trends in bird populations, identifying patterns in bird conservation efforts, or comparing bird index values across different years and regions.
Version History of Farmland Bird Index by Region in FinlandTSV
The table contains the version history of the base table rows from the 'farmland_bird_index_by_region__dim_area' table. It has additional columns '_start_date' and '_end_date', indicating the extraction dates of each row. The data is sourced from the web site of Luke, which originates from Finland (ISO country code: FI). The table can be used for data analytics to track changes and trends in the farmland bird index by region and area over time.

Column Descriptions

Farmland Bird Index by Region and Year

Column	Type	Comment
_extract_date	date	The date when the data was extracted from the source.
_row_number	long	The sequential number assigned to each row.
code	int	A unique code assigned to each item.
label	int	The label or name associated with each item.

Version History of Farmland Bird Index by Region by Year in Finland from Luke

Column	Type	Comment
_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 sequential number assigned to each row.
code	int	The code associated with the row version.
label	int	The label associated with the row version.

Farmland Bird Index by Region - Fact

Column	Type	Comment
_extract_date	date	The date when the row was extracted from the source.
_row_number	long	The unique identifier of each row in the table.
year	int	The year of the recorded data.
area	string	The geographical area the data pertains to.
farmland_bird_index	string	The index representing the count or abundance of birds in farmland habitats.

Version History of Farmland Bird Index by Region

Column	Type	Comment
_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.

Farmland Bird Index by Region: Area

Column	Type	Comment
_extract_date	date	The date on which the data was extracted from the source.
_row_number	long	The row number of the data entry.
code	string	A unique code assigned to each entry in the table.
label	string	A descriptive label for each entry in the table.

Version History of Farmland Bird Index by Region in Finland

Column	Type	Comment
_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	A number assigned to each row version in the table.
code	string	The code value associated with the row version.
label	string	The label or name assigned to the row version.

Additional Info

Last Updated	May 20, 2024
Created	October 2, 2023