sources

This table contains all the sources for our datasets. The description column contains JSON encoded as text that contains useful additional fields like a longer descriptive text "additionalInfo".

Data license: CC-BY

1 row where datasetId = 5275 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: createdAt (date), updatedAt (date)

id ▲ name description createdAt updatedAt datasetId additionalInfo link dataPublishedBy
18004 European Bird Census Council; National BirdLife organisations; RSPB; Czech Society for Ornithology (CSO)) via Eurostat 
{
    "link": "https://ec.europa.eu/eurostat/web/environment/biodiversity",
    "retrievedDate": "7th December 2022",
    "additionalInfo": "Bird monitoring in the EU is conducted under the umbrella of the PanEuropean Common Bird Monitoring Scheme. The scheme helps standardize data collection and data analysis practices across countries and produces three indices of the populations of common birds \u2013 index for all common birds (including 168 species), index for common farmland birds (39 species) and index for common forest birds (34 species).\n\nThe bird population index is measured relative to population size in the year 2000 (i.e. the value in 2000 = 100).\n\nMore information on this statistic is found here: https://web.archive.org/web/20221102140322/https://ec.europa.eu/eurostat/cache/metadata/EN/env_biodiv_esms.htm\n\nThis dataset was last updated on the 30th November 2022 and is typically updated annually. It will therefore next be updated on Our World in Data from December 2023.",
    "dataPublishedBy": "European Bird Census Council; National BirdLife organisations; RSPB; Czech Society for Ornithology (CSO)) via Eurostat"
}
 2021-03-15 11:17:17 2021-03-15 11:17:17 EU Wild Bird Populations (Eurostat, 2022) 5275 Bird monitoring in the EU is conducted under the umbrella of the PanEuropean Common Bird Monitoring Scheme. The scheme helps standardize data collection and data analysis practices across countries and produces three indices of the populations of common birds – index for all common birds (including 168 species), index for common farmland birds (39 species) and index for common forest birds (34 species). The bird population index is measured relative to population size in the year 2000 (i.e. the value in 2000 = 100). More information on this statistic is found here: https://web.archive.org/web/20221102140322/https://ec.europa.eu/eurostat/cache/metadata/EN/env_biodiv_esms.htm This dataset was last updated on the 30th November 2022 and is typically updated annually. It will therefore next be updated on Our World in Data from December 2023. https://ec.europa.eu/eurostat/web/environment/biodiversity European Bird Census Council; National BirdLife organisations; RSPB; Czech Society for Ornithology (CSO)) via Eurostat

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "sources" (
	"id" INTEGER PRIMARY KEY AUTOINCREMENT,
	"name" VARCHAR(512) NULL  ,
	"description" TEXT NOT NULL  ,
	"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ,
	"updatedAt" DATETIME NULL  ,
	"datasetId" INTEGER NULL, additionalInfo TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.additionalInfo')) VIRTUAL, link TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.link')) VIRTUAL, dataPublishedBy TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.dataPublishedBy')) VIRTUAL,
	FOREIGN KEY("datasetId") REFERENCES "datasets" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT
);
CREATE INDEX "sources_datasetId" ON "sources" ("datasetId");