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 = 5327 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
18047 UK Office for National Statistics; Department for Environment, Food & Rural Affairs 
{
    "link": "https://www.gov.uk/government/statistics/butterflies-in-the-wider-countryside-uk",
    "retrievedDate": "12th December 2022",
    "additionalInfo": "Butterfly population indices are compiled by Butterfly Conservation (BC) and the UK Centre for Ecology & Hydrology (UKCEH) from data collated through the UK Butterfly Monitoring Scheme (UKBMS) including from the Wider Countryside Butterfly Survey (WCBS).\n\nData is collected for 26 habitat specialist butterflies (low mobility species restricted to semi-natural habitats) and 25 more widespread butterflies (which use both semi-natural and general countryside habitats) using data collected at 5,737 sample locations.\n\nThe year-to-year fluctuations in butterfly numbers are often linked to natural environmental variation, especially weather conditions. Therefore, in order to identify underlying patterns in population trends, the assessment of change is based on smoothed indices.",
    "dataPublishedBy": "UK Office for National Statistics; Department for Environment, Food & Rural Affairs"
}
 2021-06-19 10:16:33 2021-06-19 10:16:33 UK Butterfly Populations (UK ONS) 5327 Butterfly population indices are compiled by Butterfly Conservation (BC) and the UK Centre for Ecology & Hydrology (UKCEH) from data collated through the UK Butterfly Monitoring Scheme (UKBMS) including from the Wider Countryside Butterfly Survey (WCBS). Data is collected for 26 habitat specialist butterflies (low mobility species restricted to semi-natural habitats) and 25 more widespread butterflies (which use both semi-natural and general countryside habitats) using data collected at 5,737 sample locations. The year-to-year fluctuations in butterfly numbers are often linked to natural environmental variation, especially weather conditions. Therefore, in order to identify underlying patterns in population trends, the assessment of change is based on smoothed indices. https://www.gov.uk/government/statistics/butterflies-in-the-wider-countryside-uk UK Office for National Statistics; Department for Environment, Food & Rural Affairs

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