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 = 2892 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
15620 Urbanization share (European Commission, Atlas of the Human Planet) 
{
    "link": "https://ec.europa.eu/jrc/en/publication/eur-scientific-and-technical-research-reports/atlas-human-planet-mapping-human-presence-earth-global-human-settlement-layer",
    "retrievedDate": "24th August 2018",
    "additionalInfo": "Data reports the share of people living in urban areas, as reported by the European Commission project. These results differ significantly from UN and nationally-defined figures based on differences in methodology.\n\nThe European Commission combines high-resolution satellite imagery with national census data to derive its estimates of urban and rural settlements.\n\nThe European Commission applied a universal definition of settlements across all countries:\n\n- Urban centre: must have a minimum of 50,000 inhabitants plus a population density of at least 1500 people per square kilometre (km2) or density of build-up area greater than 50 percent.\n- Urban cluster:\u00a0must have a minimum of 5,000 inhabitants plus a population density of at least 300 people per square kilometre (km2).\n- Rural: fewer than 5,000 inhabitants.\n\nThe urban share is thereafter defined as the sum of urban centres and urban clusters.",
    "dataPublishedBy": "Pesaresi, M., Melchiorri, M., Siragusa, A., & Kemper, T. (2016). Atlas of the human planet\u2013Mapping human presence on earth with the global human settlement layer.\u00a0JRC103150. Publications Office of the European Union. Luxembourg (Luxembourg): European Commission, DG JRC",
    "dataPublisherSource": null
}
 2018-08-24 13:52:10 2018-08-24 13:52:10 Urbanization share (European Commission, Atlas of the Human Planet) 2892 Data reports the share of people living in urban areas, as reported by the European Commission project. These results differ significantly from UN and nationally-defined figures based on differences in methodology. The European Commission combines high-resolution satellite imagery with national census data to derive its estimates of urban and rural settlements. The European Commission applied a universal definition of settlements across all countries: - Urban centre: must have a minimum of 50,000 inhabitants plus a population density of at least 1500 people per square kilometre (km2) or density of build-up area greater than 50 percent. - Urban cluster: must have a minimum of 5,000 inhabitants plus a population density of at least 300 people per square kilometre (km2). - Rural: fewer than 5,000 inhabitants. The urban share is thereafter defined as the sum of urban centres and urban clusters. https://ec.europa.eu/jrc/en/publication/eur-scientific-and-technical-research-reports/atlas-human-planet-mapping-human-presence-earth-global-human-settlement-layer Pesaresi, M., Melchiorri, M., Siragusa, A., & Kemper, T. (2016). Atlas of the human planet–Mapping human presence on earth with the global human settlement layer. JRC103150. Publications Office of the European Union. Luxembourg (Luxembourg): European Commission, DG JRC

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