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 = 5407 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
21242 Phillips, De Palma, Gonzalez, Contu et al. (2021) 
{
    "link": "https://data.nhm.ac.uk/dataset/bii-bte",
    "retrievedDate": "2021-11-13",
    "additionalInfo": "\nThe BII is derived from combining two models. The first model represents how human activity has influenced the total abundance of species in any one area. The second model analyses how similar each site's ecological community is to the near-undisturbed sites (this is known as the 'compositional similarity' and includes what original species are present and what species are dominant; the BII values we make available on the Biodiversity Trends Explorer use a much more sensitive measure of compositional similarity than the one we used before 2021). \n\nNext, we combine each of these models with maps of human pressures, including land use change and intensification, human population growth and landscape simplification. This produces new maps of how abundance and compositional similarity have been affected by human pressures. \n\nBringing these two maps together then gives us the BII: the percentage of the original ecological community that remains across an area.\n\nHelen Phillips, Adriana De Palma, Ricardo E Gonzalez, Samantha L L Hill, Luca B\u00f6rger & Andy Purvis (2021): The Biodiversity Intactness Index - country, region and global-level summaries for the year 2000 to 2050 under various scenarios. data.nhm.ac.uk. https://doi.org/10.5519/he1eqmg1\n",
    "dataPublishedBy": "Natural History Museum Data Portal (data.nhm.ac.uk)."
}
 2021-11-13 18:00:28 2021-11-13 18:00:28 Biodiversity Intactness Index - Historical - NHM (2021) 5407 The BII is derived from combining two models. The first model represents how human activity has influenced the total abundance of species in any one area. The second model analyses how similar each site's ecological community is to the near-undisturbed sites (this is known as the 'compositional similarity' and includes what original species are present and what species are dominant; the BII values we make available on the Biodiversity Trends Explorer use a much more sensitive measure of compositional similarity than the one we used before 2021). Next, we combine each of these models with maps of human pressures, including land use change and intensification, human population growth and landscape simplification. This produces new maps of how abundance and compositional similarity have been affected by human pressures. Bringing these two maps together then gives us the BII: the percentage of the original ecological community that remains across an area. Helen Phillips, Adriana De Palma, Ricardo E Gonzalez, Samantha L L Hill, Luca Börger & Andy Purvis (2021): The Biodiversity Intactness Index - country, region and global-level summaries for the year 2000 to 2050 under various scenarios. data.nhm.ac.uk. https://doi.org/10.5519/he1eqmg1 https://data.nhm.ac.uk/dataset/bii-bte Natural History Museum Data Portal (data.nhm.ac.uk).

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");