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 = 5128 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
17858 Our World in Data based on national statistics 
{
    "additionalInfo": "This dataset combines national published estimates of marriage length: some countries present this data as the median length of marriage; others the mean length of marriage.\n\nDue to skew in the distribution of marriage lengths, the median and mean are often notably different.\n\nWe note for each time-series whether the median or mean is used. All countries are given as a median value with the exception of Ecuador, Germany, and Sweden where this is given as the mean.\n\nEstimates rely on multiple sources:\n- For the United States, the data comes from Table 2-12 in the <a href=\"https://www.cdc.gov/nchs/data/vsus/mgdv88_3.pdf\">Vital Statistics of the United States, 1988 report</a> (1978-1988); Table 1 in <a href=\"https://www.cdc.gov/nchs/data/series/sr_21/sr21_038.pdf\">The Duration of Marriage Before Divorce report</a> (1867 - 1977); Table 6 of the <a href=\"https://www.census.gov/prod/2005pubs/p70-97.pdf\">Current Population Reports, Issued 2005</a> (2001); Table 8 of the <a href=\"https://www.census.gov/prod/2011pubs/p70-125.pdf\">Current Population Reports, Issued 2011</a> (2009).\n- For the UK, data is taken from Figure 5 of the <a href=\"https://www.ons.gov.uk/peoplepopulationandcommunity/birthsdeathsandmarriages/divorce/bulletins/divorcesinenglandandwales/2018\">ONS Statistical Bulletin</a>.\n- For Canada, the data is from <a href=\"https://www150.statcan.gc.ca/t1/tbl1/en/cv.action?pid=3910003801#timeframe\">Statistics Canada</a>, under Table 39-10-0038-01, Divorces by mean and median duration of marriage.\n- For Australia, the <a href=\"https://www.abs.gov.au/AUSSTATS/[email protected]/Previousproducts/3310.0Main%20Features42017?opendocument&tabname=Summary&prodno=3310.0&issue=2017&num=&view=\">Australian Bureau of Statistics</a> under 'Length of Marriage of Divorcing Couples' sub-heading for 1997-2017. See the <a href=\"https://www.abs.gov.au/AUSSTATS/[email protected]/allprimarymainfeatures/893C1288678FD232CA2568A90013939C?opendocument\">Australian Bureau of Statistics 2018 Release</a> under the 'Divorces' heading for 2018.\n- For New Zealand, <a href=\"http://archive.stats.govt.nz/infoshare/\">NZ.Stat Infoshare</a> under the 'Population->Marriages Civil Unions and Divorces->Divorces by duration' subject category.\n- For Singapore, <a href=\"https://www.singstat.gov.sg/find-data/search-by-theme/population/marital-status-marriages-and-divorces/latest-data\">Statistics Singapore</a>. The data can be found under the Divorces and Annulments sub-heading within the 'Key Indicators On Divorces, Annual' link.\n- For Ecuador, the data is available from slide 11 of the <a href=\"https://www.ecuadorencifras.gob.ec/documentos/web-inec/Poblacion_y_Demografia/Matrimonios_Divorcios/2018/Principales_resultados_MYD_2018.pdf\">Instituto Nacional de Estadisticas y Censos, Registro Estad\u00edstico de Divorcios, 2018</a>.\n- For Germany, the <a href=\"https://www.destatis.de/EN/Themes/Society-Environment/Population/Marriages-Divorces-Life-Partnerships/Tables/statistical-parameters.html\">Statistisches Bundesamt</a>.\n- For Sweden, <a href=\"http://www.statistikdatabasen.scb.se/pxweb/en/ssd/START__BE__BE0101__BE0101L/AktenskapVaraktighet/\">Statistics Sweden</a>.",
    "dataPublishedBy": "National Statistical Agencies",
    "dataPublisherSource": "Survey data"
}
 2020-07-25 08:22:49 2020-07-25 08:22:49 Duration of marriages ending in divorce (OWID based on national statistics) 5128 This dataset combines national published estimates of marriage length: some countries present this data as the median length of marriage; others the mean length of marriage. Due to skew in the distribution of marriage lengths, the median and mean are often notably different. We note for each time-series whether the median or mean is used. All countries are given as a median value with the exception of Ecuador, Germany, and Sweden where this is given as the mean. Estimates rely on multiple sources: - For the United States, the data comes from Table 2-12 in the <a href="https://www.cdc.gov/nchs/data/vsus/mgdv88_3.pdf">Vital Statistics of the United States, 1988 report</a> (1978-1988); Table 1 in <a href="https://www.cdc.gov/nchs/data/series/sr_21/sr21_038.pdf">The Duration of Marriage Before Divorce report</a> (1867 - 1977); Table 6 of the <a href="https://www.census.gov/prod/2005pubs/p70-97.pdf">Current Population Reports, Issued 2005</a> (2001); Table 8 of the <a href="https://www.census.gov/prod/2011pubs/p70-125.pdf">Current Population Reports, Issued 2011</a> (2009). - For the UK, data is taken from Figure 5 of the <a href="https://www.ons.gov.uk/peoplepopulationandcommunity/birthsdeathsandmarriages/divorce/bulletins/divorcesinenglandandwales/2018">ONS Statistical Bulletin</a>. - For Canada, the data is from <a href="https://www150.statcan.gc.ca/t1/tbl1/en/cv.action?pid=3910003801#timeframe">Statistics Canada</a>, under Table 39-10-0038-01, Divorces by mean and median duration of marriage. - For Australia, the <a href="https://www.abs.gov.au/AUSSTATS/[email protected]/Previousproducts/3310.0Main%20Features42017?opendocument&tabname=Summary&prodno=3310.0&issue=2017&num=&view=">Australian Bureau of Statistics</a> under 'Length of Marriage of Divorcing Couples' sub-heading for 1997-2017. See the <a href="https://www.abs.gov.au/AUSSTATS/[email protected]/allprimarymainfeatures/893C1288678FD232CA2568A90013939C?opendocument">Australian Bureau of Statistics 2018 Release</a> under the 'Divorces' heading for 2018. - For New Zealand, <…   National Statistical Agencies

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