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 = 1883 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
13892 Death rates from natural disasters (EMDAT & UN/HYDE) 
{
    "link": "http://www.emdat.be/",
    "retrievedDate": "3rd February 2020",
    "additionalInfo": "Disaster-related deaths from EMDAT (OFDA/CRED International Disaster Database) have been normalised by OurWorldinData to global population size based on HYDE (1900-1949) & UN (1950 onwards) population estimates. This provides data in terms of deaths per 100,000 people.\n\nThe data presented here includes all categories classified as \"natural disasters\" (distinguished from technological disasters, such as oil spills and industrial accidents). This includes those from drought, floods, extreme weather, extreme temperature, landslides, dry mass movements, wildfires, volcanic activity and earthquakes.\n\nThe combined set of \"all natural disasters\" also includes disasters defined as \"insect infestations\", however this has not been included as a discrete dataset due to low impact numbers.\n\nUN Population figures can found at: https://esa.un.org/unpd/wpp/Download/Standard/Population/\nHYDE Population figures can be found at: https://themasites.pbl.nl/tridion/en/themasites/hyde/basicdrivingfactors/population/index-2.html",
    "dataPublishedBy": "EMDAT (2020): OFDA/CRED International Disaster Database, Universit\u00e9 catholique de Louvain \u2013 Brussels \u2013 Belgium"
}
 2017-12-11 10:21:56 2017-12-11 10:21:56 Global death rates from disasters (EMDAT; UN & HYDE) 1883 Disaster-related deaths from EMDAT (OFDA/CRED International Disaster Database) have been normalised by OurWorldinData to global population size based on HYDE (1900-1949) & UN (1950 onwards) population estimates. This provides data in terms of deaths per 100,000 people. The data presented here includes all categories classified as "natural disasters" (distinguished from technological disasters, such as oil spills and industrial accidents). This includes those from drought, floods, extreme weather, extreme temperature, landslides, dry mass movements, wildfires, volcanic activity and earthquakes. The combined set of "all natural disasters" also includes disasters defined as "insect infestations", however this has not been included as a discrete dataset due to low impact numbers. UN Population figures can found at: https://esa.un.org/unpd/wpp/Download/Standard/Population/ HYDE Population figures can be found at: https://themasites.pbl.nl/tridion/en/themasites/hyde/basicdrivingfactors/population/index-2.html http://www.emdat.be/ EMDAT (2020): OFDA/CRED International Disaster Database, Université catholique de Louvain – Brussels – Belgium

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