sources
Data license: CC-BY
1 row where datasetId = 4896 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: createdAt (date), updatedAt (date)
| id ▲ | name | description | createdAt | updatedAt | datasetId | additionalInfo | link | dataPublishedBy |
|---|---|---|---|---|---|---|---|---|
| 17627 | UN Population Division (2018) | {
"link": "https://population.un.org/Household/index.html#/countries/840",
"retrievedDate": "13/01/2020",
"additionalInfo": "The variable for the share of single parent families is taken from the <a href=\"https://population.un.org/Household/index.html#/countries/840\">United Nations Database on Household Size and Composition (2018)</a>. \n\nThe UN database pulls from 4 different sources: \n1) Demographic and Health Surveys (DHS); \n2) the Demographic Yearbook (DYB) of the United Nations; \n3) IPUMS-International;\n4) Labor Force Surveys (LFS) of the European Union, Eurostat. \n\nWhere a country time series was composed of multiple sources, we favoured the source covering the most years. In cases where there was a tie between sources, we favoured the DYB, then IPUMS, DHS, and lastly LFS estimates. The DYB covered the largest number of countries and the LFS the least. \n\nWhere multiple country-year observations came from the same source, we favoured the observation with the reference date occurring later in the year. This is true for Senegal in 2013 and Tanzania in 2004.\n\nThe source for each observation can be found in the metadata spreadsheet <a href=\"https://owid.cloud/app/uploads/2020/01/un-single-parent-final-metadata-stan.csv\">here</a>. \n",
"dataPublishedBy": "United Nations, Department of Economic and Social Affairs, Population Division (2018). Household Size and Composition 2018. (POP/DB/PD/HSCD/2018).",
"dataPublisherSource": "Census data, survey data"
} |
2020-01-13 12:00:12 | 2020-01-13 12:00:12 | Share of single parent families (UN Population Division 2018) 4896 | The variable for the share of single parent families is taken from the <a href="https://population.un.org/Household/index.html#/countries/840">United Nations Database on Household Size and Composition (2018)</a>. The UN database pulls from 4 different sources: 1) Demographic and Health Surveys (DHS); 2) the Demographic Yearbook (DYB) of the United Nations; 3) IPUMS-International; 4) Labor Force Surveys (LFS) of the European Union, Eurostat. Where a country time series was composed of multiple sources, we favoured the source covering the most years. In cases where there was a tie between sources, we favoured the DYB, then IPUMS, DHS, and lastly LFS estimates. The DYB covered the largest number of countries and the LFS the least. Where multiple country-year observations came from the same source, we favoured the observation with the reference date occurring later in the year. This is true for Senegal in 2013 and Tanzania in 2004. The source for each observation can be found in the metadata spreadsheet <a href="https://owid.cloud/app/uploads/2020/01/un-single-parent-final-metadata-stan.csv">here</a>. | https://population.un.org/Household/index.html#/countries/840 | United Nations, Department of Economic and Social Affairs, Population Division (2018). Household Size and Composition 2018. (POP/DB/PD/HSCD/2018). |
Advanced export
JSON shape: default, array, newline-delimited, object
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");