owid: sources: 1 row where datasetId = 2887 sorted by id descending

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 = 2887 sorted by id descending

descending

✎ View and edit SQL

This data as json, CSV (advanced)

id ▲	name	description	createdAt	updatedAt	datasetId	additionalInfo	link	dataPublishedBy
15615	OWID based on UN World Urbanization Prospects 2018 and others	{ "link": "UN: https://esa.un.org/unpd/wup/Download/ (Files 19,20,21); US Census Bureau: https://www.census.gov/population/censusdata/table-4.pdf and https://www.census.gov/prod/cen2010/cph-2-1.pdf (Table 4, page 6); HYDE 3.1: http://journals.sagepub.com/doi/pdf/10.1177/0959683609356587; Bairoch (1988): http://press.uchicago.edu/ucp/books/book/chicago/C/bo5971175.html; De Vries (1984): https://books.google.co.uk/books/about/European_Urbanization_1500_1800.html?id=11yHAAAAIAAJ; Kuroda (1984): http://www.apda.jp/pdf/p04_jinkou_series/popdev_series_3_en.pdf", "retrievedDate": "21/08/2018", "additionalInfo": "To construct the long run urbanization series we began with the UN World Urbanization Prospects database covering the period from 1950 to 2050. \n\nThen we extended the series backwards using additional data sources including the US Census Bureau, Bairoch (1988), Kuroda (1984), HYDE 3.1 (2010), and De Vries (1984) to arrive at the longest single series possible for each country and region included. For further information on the source used for particular observations by country-year, see the following <a href=\"https://docs.google.com/spreadsheets/d/1tl3FmKTD_FaQ-i4VUlusS-OcZHOl30zkK7oIsuQPtJ4/edit?usp=sharing\" rel=\"noopener\" target=\"_blank\">documentation</a>. \n\nTo calculate the absolute rural and urban populations, we have multiplied the rural and urban percentages by the historic population series published by Gapminder until 1949 and extended using the UN Population Division data from 1950 to 2016. The long run 'Gapminder + UN Population' population series is available <a href=\"https://ourworldindata.org/grapher/population-by-country-gapminder+un\" rel=\"noopener\" target=\"_blank\">here</a>. For absolute population estimates before 1950 for the 'World', we used the <a href=\"https://ourworldindata.org/grapher/world-population-1750-2015-and-un-projection-until-2100\" rel=\"noopener\" target=\"_blank\">'World Population over 12,000 years' series</a>.\n\nNote: Urbanization data for Japan in 1900 has been excluded as the estimate (HYDE 3.1) was inconsistent with figures for neighbouring years (Kuroda (1986)).", "dataPublishedBy": "UN World Urbanization Prospects 2018 and others", "dataPublisherSource": "National and historical sources" }	2018-08-22 10:02:27	2018-08-22 14:45:25	Urbanization in the long run - OWID based on the UN World Urbanization Prospects 2018 and others 2887	To construct the long run urbanization series we began with the UN World Urbanization Prospects database covering the period from 1950 to 2050. Then we extended the series backwards using additional data sources including the US Census Bureau, Bairoch (1988), Kuroda (1984), HYDE 3.1 (2010), and De Vries (1984) to arrive at the longest single series possible for each country and region included. For further information on the source used for particular observations by country-year, see the following <a href="https://docs.google.com/spreadsheets/d/1tl3FmKTD_FaQ-i4VUlusS-OcZHOl30zkK7oIsuQPtJ4/edit?usp=sharing" rel="noopener" target="_blank">documentation</a>. To calculate the absolute rural and urban populations, we have multiplied the rural and urban percentages by the historic population series published by Gapminder until 1949 and extended using the UN Population Division data from 1950 to 2016. The long run 'Gapminder + UN Population' population series is available <a href="https://ourworldindata.org/grapher/population-by-country-gapminder+un" rel="noopener" target="_blank">here</a>. For absolute population estimates before 1950 for the 'World', we used the <a href="https://ourworldindata.org/grapher/world-population-1750-2015-and-un-projection-until-2100" rel="noopener" target="_blank">'World Population over 12,000 years' series</a>. Note: Urbanization data for Japan in 1900 has been excluded as the estimate (HYDE 3.1) was inconsistent with figures for neighbouring years (Kuroda (1986)).	UN: https://esa.un.org/unpd/wup/Download/ (Files 19,20,21); US Census Bureau: https://www.census.gov/population/censusdata/table-4.pdf and https://www.census.gov/prod/cen2010/cph-2-1.pdf (Table 4, page 6); HYDE 3.1: http://journals.sagepub.com/doi/pdf/10.1177/0959683609356587; Bairoch (1988): http://press.uchicago.edu/ucp/books/book/chicago/C/bo5971175.html; De Vries (1984): https://books.google.co.uk/books/about/European_Urbanization_1500_1800.html?id=11yHAAAAIAAJ; Kuroda (1984): http://www.apda.jp/pdf/p04_jinkou_series/popdev_series_3_en.pdf	UN World Urbanization Prospects 2018 and others

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