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 = 2803 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
15540 HYDE 3.1 
{
    "link": "http://journals.sagepub.com/doi/pdf/10.1177/0959683609356587",
    "retrievedDate": "07/06/2018",
    "additionalInfo": "Authors' note on the data sources used: \"Urban/rural fractions for all countries were derived from the UN after ad 1950 (UN, 2008b). Earlier historical urbanization estimates for Europe were derived from De Vries (1984), Bairoch et al. (1988), Chandler (1987), for Canada after ad 1890 from Urquhart and Buckley (1965), for China from Rozman (1973) and Maddison (1995), for Colombia from Etter et al. (2006), USA from Dodd (1993), all other countries were estimated similar to De Vries (1984), which data yielded roughly a factor 10 lower in ad 1700 compared with the 1950 value of the UN.\"\n\nFull citation: \nKlein Goldewijk, K. , A. Beusen, M. de Vos and G. van Drecht (2011). The HYDE 3.1 spatially explicit database of human induced land use change over the past 12,000 years, Global Ecology and Biogeography20(1): 73-86. DOI: 10.1111/j.1466-8238.2010.00587.x.\n\nKlein Goldewijk, K. , A. Beusen, and P. Janssen (2010). Long term dynamic modeling of global population and built-up area in a spatially explicit way, HYDE 3 .1. The Holocene20(4):565-573. http://dx.doi.org/10.1177/0959683609356587",
    "dataPublishedBy": "Klein Goldewijk, K. , A. Beusen, and P. Janssen (2010). Long term dynamic modeling of global population and built-up area in a spatially explicit way, HYDE 3 .1. The Holocene20(4):565-573. http://dx.doi.org/10.1177/0959683609356587",
    "dataPublisherSource": "Historical population and land use data"
}
 2018-06-07 17:50:22 2018-08-16 09:15:36 Historical urban fraction estimates and total computed urban areas - HYDE 3.1 (2010) 2803 Authors' note on the data sources used: "Urban/rural fractions for all countries were derived from the UN after ad 1950 (UN, 2008b). Earlier historical urbanization estimates for Europe were derived from De Vries (1984), Bairoch et al. (1988), Chandler (1987), for Canada after ad 1890 from Urquhart and Buckley (1965), for China from Rozman (1973) and Maddison (1995), for Colombia from Etter et al. (2006), USA from Dodd (1993), all other countries were estimated similar to De Vries (1984), which data yielded roughly a factor 10 lower in ad 1700 compared with the 1950 value of the UN." Full citation: Klein Goldewijk, K. , A. Beusen, M. de Vos and G. van Drecht (2011). The HYDE 3.1 spatially explicit database of human induced land use change over the past 12,000 years, Global Ecology and Biogeography20(1): 73-86. DOI: 10.1111/j.1466-8238.2010.00587.x. Klein Goldewijk, K. , A. Beusen, and P. Janssen (2010). Long term dynamic modeling of global population and built-up area in a spatially explicit way, HYDE 3 .1. The Holocene20(4):565-573. http://dx.doi.org/10.1177/0959683609356587 http://journals.sagepub.com/doi/pdf/10.1177/0959683609356587 Klein Goldewijk, K. , A. Beusen, and P. Janssen (2010). Long term dynamic modeling of global population and built-up area in a spatially explicit way, HYDE 3 .1. The Holocene20(4):565-573. http://dx.doi.org/10.1177/0959683609356587

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