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 = 5124 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
17854 Office for National Statistics – Divorces in England and Wales 
{
    "link": "https://www.ons.gov.uk/peoplepopulationandcommunity/birthsdeathsandmarriages/divorce/bulletins/divorcesinenglandandwales/2018",
    "retrievedDate": "24th July 2020",
    "additionalInfo": "Data measures the percentage of marriages in England and Wales ending in divorce by anniversary and year of marriage.\n\nThe UK Office for National Statistics notes the following points:\n\u2013 When calculating these percentages, it has been assumed that the couples who married each year have not moved out of England and Wales, couples who divorced each year have not moved into England and Wales since getting married, and couples marry in the country where they usually live.\n\n\u2013 The Divorce Reform Act 1969, which came into effect on 1 January 1971, made it easier for couples to divorce upon separation.",
    "dataPublishedBy": "UK Office for National Statistics"
}
 2020-07-24 12:05:38 2020-07-24 12:05:38 Share of marriages in England and Wales that ended in divorce (UK ONS, 2020) 5124 Data measures the percentage of marriages in England and Wales ending in divorce by anniversary and year of marriage. The UK Office for National Statistics notes the following points: – When calculating these percentages, it has been assumed that the couples who married each year have not moved out of England and Wales, couples who divorced each year have not moved into England and Wales since getting married, and couples marry in the country where they usually live. – The Divorce Reform Act 1969, which came into effect on 1 January 1971, made it easier for couples to divorce upon separation. https://www.ons.gov.uk/peoplepopulationandcommunity/birthsdeathsandmarriages/divorce/bulletins/divorcesinenglandandwales/2018 UK Office for National Statistics

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