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 = 5125 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
17855 UK Office for National Statistics – Marriages and Divorces in England and Wales (2020) 
{
    "link": "https://www.ons.gov.uk/peoplepopulationandcommunity/birthsdeathsandmarriages/divorce/bulletins/divorcesinenglandandwales/2018",
    "retrievedDate": "24th July 2020",
    "additionalInfo": "Data represents the cumulative share of marriages in England and Wales that had ended in divorce a given number of years following the year of marriage.\n\nEach line represents a given cohort, marked by the year in which they were married e.g. the line \"1980\" represents couples married in the year 1980.\n\nThe UK Office for National Statistics notes the following points:\n\u2013 Cumulative percentages add a percentage from one period to the percentage of another period to show the total percentage over a given time period.\n\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 (ONS)"
}
 2020-07-24 12:28:24 2020-07-24 12:28:24 Cumulative share of marriages ending in divorce (England and Wales, UK ONS) 5125 Data represents the cumulative share of marriages in England and Wales that had ended in divorce a given number of years following the year of marriage. Each line represents a given cohort, marked by the year in which they were married e.g. the line "1980" represents couples married in the year 1980. The UK Office for National Statistics notes the following points: – Cumulative percentages add a percentage from one period to the percentage of another period to show the total percentage over a given time period. – 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 (ONS)

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