sources
Data license: CC-BY
1 row where datasetId = 4864 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 |
---|---|---|---|---|---|---|---|---|
17595 | OWID based on UN and other sources | { "link": "See below", "retrievedDate": "15/11/2019", "additionalInfo": "This is an OWID constructed dataset on the share of one-person households. \n\nEstimates rely on data from multiple sources:\n- For European countries, the data comes from the <a href=\"https://ec.europa.eu/eurostat/statistics-explained/index.php/People_in_the_EU_-_statistics_on_household_and_family_structures#Single-person_households\">Eurostat dataset</a> using the ilc_lvph02 series.\n- Data for <a href=\"http://nzdotstat.stats.govt.nz/wbos/Index.aspx\">New Zealand</a>, <a href=\"https://www.e-stat.go.jp/en/stat-search/files?page=1&query=household&layout=dataset&toukei=00200521&tstat=000001080615&metadata=1&data=1\">Japan</a>, <a href=\"https://www.census.gov/data/tables/time-series/demo/families/households.html\">the US</a>, and <a href=\"https://quickstats.censusdata.abs.gov.au/census_services/getproduct/census/2001/quickstat/0?opendocument\">Australia</a> were taken from the countries' national statistical agencies\n- For all other countries the data comes 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\n- Data from the <a href=\"http://www.oecd.org/els/family/database.htm#structure\">OECD</a> was used to supplement the dataset for 2011, for countries where data from other sources were unavailable. \n- The time series for Germany was supplemented using the <a href=\"https://figshare.com/articles/German_Time_Series_Dataset_1834_2012/1450809/1\">Deutschland in Daten</a> dataset where West Germany refers to the German Federal Republic series and East Germany to the German Democratic Republic. \nSee Rahlf, Thomas; Erker, Paul; Fertig, Georg; Rothenbacher, Franz; Oltmer, Jochen; M\u00fcller-Benedict, Volker; et al. (2015): German Time Series Dataset, 1834-2012. figshare. Dataset. https://doi.org/10.6084/m9.figshare.1450809.v1\n\n(<em>NB. The source for each observation can be found in the metadata spreadsheet <a href=\"https://owid.cloud/app/uploads/2019/12/living-alone-metadata-final_country_stan.csv\">here</a></em>) \n\nNotes:\nThe UN data included two observations for Tanzania in 2004 and two for Senegal in 2013. We favoured the observation produced later in the year to avoid under- or over-estimating the share of one-person households. The figures produced later in the year are a more sensible fit for their respective country series.\n\nNew Zealand in 1991 and 1996 uses the total number of households as the denominator. All other years use the total number of stated households. Stated households exclude cases where the household composition is unidentifiable and is used where possible.\n\nJapan in 1960, 1970, and 1975 includes \"group of six or more one-person live-in employees for business\". \n\nUnited States estimates in 1993 and 2011 are revised based on population from the most recent decennial census. \n\nThe OECD-32 average excludes Israel.", "dataPublishedBy": "UN, national statistical agencies, OECD, Deutschland in Daten", "dataPublisherSource": "Census data, survey data, historical records" } |
2019-11-15 22:37:00 | 2019-11-15 22:37:00 | Share of one person households - OWID based on UN and other sources 4864 | This is an OWID constructed dataset on the share of one-person households. Estimates rely on data from multiple sources: - For European countries, the data comes from the <a href="https://ec.europa.eu/eurostat/statistics-explained/index.php/People_in_the_EU_-_statistics_on_household_and_family_structures#Single-person_households">Eurostat dataset</a> using the ilc_lvph02 series. - Data for <a href="http://nzdotstat.stats.govt.nz/wbos/Index.aspx">New Zealand</a>, <a href="https://www.e-stat.go.jp/en/stat-search/files?page=1&query=household&layout=dataset&toukei=00200521&tstat=000001080615&metadata=1&data=1">Japan</a>, <a href="https://www.census.gov/data/tables/time-series/demo/families/households.html">the US</a>, and <a href="https://quickstats.censusdata.abs.gov.au/census_services/getproduct/census/2001/quickstat/0?opendocument">Australia</a> were taken from the countries' national statistical agencies - For all other countries the data comes 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. - Data from the <a href="http://www.oecd.org/els/family/database.htm#structure">OECD</a> was used to supplement the dataset for 2011, for countries where data from other sources were unavailable. - The time series for Germany was supplemented using the <a href="https://figshare.com/articles/German_Time_Series_Dataset_1834_2012/1450809/1">Deutschland in Daten</a> dataset where West Germany refers to … | See below | UN, national statistical agencies, OECD, Deutschland in Daten |
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");