sources
Data license: CC-BY
2 rows where datasetId = 6078 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 |
|---|---|---|---|---|---|---|---|---|
| 30129 | Multiple sources compiled by Our World in Data (2019) | {
"link": null,
"retrievedDate": null,
"additionalInfo": "\nAmong others these are the original source:\n\nMcEvedy, Colin and Richard Jones, 1978, \u201cAtlas of World Population History,\u201d Facts on File, New York, pp. 342-351.\n\nBiraben, Jean-Noel, 1980, An Essay Concerning Mankind\u2019s Evolution, Population, Selected Papers, December, table 2.\n\nDurand, John D., 1974, \u201cHistorical Estimates of World Population: An Evaluation,\u201d University of Pennsylvania, Population Center, Analytical and Technical Reports, Number 10, table 2.\n\nHaub, Carl, 1995, \u201cHow Many People Have Ever Lived on Earth?\u201d Population Today, February, p. 5.\n\nThomlinson, Ralph, 1975, \u201cDemographic Problems, Controversy Over Population Control,\u201d Second Edition, Table 1.\n\nUnited Nations, 1999, The World at Six Billion, Table 1, \u201cWorld Population From\u201d Year 0 to Stabilization, p. 5,\nU.S. Census Bureau (USCB), 2012, Total Midyear Population for the World: 1950-2050.\n\nMichael Kremer (1993) \u201cPopulation Growth and Technological Change: One Million B.C. to 1990\u201d, Quarterly Journal of Economics., August 1993, pp.681-716.",
"dataPublishedBy": "Multiple sources compiled by Our World in Data (2019)"
} |
2024-02-26 22:52:45 | 2024-07-08 17:24:01 | Historical world population comparison (various sources) 6078 | Among others these are the original source: McEvedy, Colin and Richard Jones, 1978, “Atlas of World Population History,” Facts on File, New York, pp. 342-351. Biraben, Jean-Noel, 1980, An Essay Concerning Mankind’s Evolution, Population, Selected Papers, December, table 2. Durand, John D., 1974, “Historical Estimates of World Population: An Evaluation,” University of Pennsylvania, Population Center, Analytical and Technical Reports, Number 10, table 2. Haub, Carl, 1995, “How Many People Have Ever Lived on Earth?” Population Today, February, p. 5. Thomlinson, Ralph, 1975, “Demographic Problems, Controversy Over Population Control,” Second Edition, Table 1. United Nations, 1999, The World at Six Billion, Table 1, “World Population From” Year 0 to Stabilization, p. 5, U.S. Census Bureau (USCB), 2012, Total Midyear Population for the World: 1950-2050. Michael Kremer (1993) “Population Growth and Technological Change: One Million B.C. to 1990”, Quarterly Journal of Economics., August 1993, pp.681-716. | Multiple sources compiled by Our World in Data (2019) | |
| 27725 | Multiple sources compiled by Our World in Data (2019) | {
"link": null,
"retrievedDate": null,
"additionalInfo": "Among others these are the original source:\n\nMcEvedy, Colin and Richard Jones, 1978, \u201cAtlas of World Population History,\u201d Facts on File, New York, pp. 342-351.\n\nBiraben, Jean-Noel, 1980, An Essay Concerning Mankind\u2019s Evolution, Population, Selected Papers, December, table 2.\n\nDurand, John D., 1974, \u201cHistorical Estimates of World Population: An Evaluation,\u201d University of Pennsylvania, Population Center, Analytical and Technical Reports, Number 10, table 2.\n\nHaub, Carl, 1995, \u201cHow Many People Have Ever Lived on Earth?\u201d Population Today, February, p. 5.\n\nThomlinson, Ralph, 1975, \u201cDemographic Problems, Controversy Over Population Control,\u201d Second Edition, Table 1.\n\nUnited Nations, 1999, The World at Six Billion, Table 1, \u201cWorld Population From\u201d Year 0 to Stabilization, p. 5,\nU.S. Census Bureau (USCB), 2012, Total Midyear Population for the World: 1950-2050.\n\nMichael Kremer (1993) \u201cPopulation Growth and Technological Change: One Million B.C. to 1990\u201d, Quarterly Journal of Economics., August 1993, pp.681-716.",
"dataPublishedBy": "Multiple sources compiled by Our World in Data (2019)"
} |
2023-06-19 19:35:37 | 2024-07-08 17:24:01 | Historical world population comparison (various sources) 6078 | Among others these are the original source: McEvedy, Colin and Richard Jones, 1978, “Atlas of World Population History,” Facts on File, New York, pp. 342-351. Biraben, Jean-Noel, 1980, An Essay Concerning Mankind’s Evolution, Population, Selected Papers, December, table 2. Durand, John D., 1974, “Historical Estimates of World Population: An Evaluation,” University of Pennsylvania, Population Center, Analytical and Technical Reports, Number 10, table 2. Haub, Carl, 1995, “How Many People Have Ever Lived on Earth?” Population Today, February, p. 5. Thomlinson, Ralph, 1975, “Demographic Problems, Controversy Over Population Control,” Second Edition, Table 1. United Nations, 1999, The World at Six Billion, Table 1, “World Population From” Year 0 to Stabilization, p. 5, U.S. Census Bureau (USCB), 2012, Total Midyear Population for the World: 1950-2050. Michael Kremer (1993) “Population Growth and Technological Change: One Million B.C. to 1990”, Quarterly Journal of Economics., August 1993, pp.681-716. | Multiple sources compiled by Our World in Data (2019) |
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");