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 = 573 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
2212 Natural disasters - EMDAT (2020) 
{
    "link": "http://www.emdat.be/",
    "retrievedDate": "3rd February 2020",
    "additionalInfo": "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.\n\nemdat defines the following variables as:\n\nAffected: \"People requiring immediate assistance during a period of emergency, i.e. requiring basic survival needs such as food, water, shelter, sanitation and immediate medical assistance.\"\n\nInjured: \"People suffering from physical injuries, trauma or an illness requiring immediate medical assistance as a direct result of a disaster.\"\n\nHomeless: \"Number of people whose house is destroyed or heavily damaged and therefore need shelter after an event.\"\n\nTotal affected: \"In EM-DAT, it is the sum of the injured, affected and left homeless after a disaster.\"\n\nEstimated economic damage: \"The amount of damage to property, crops, and livestock. In EM-DAT estimated damage are given in US$ (\u2018000). For each disaster, the registered figure corresponds to the damage value at the moment of the event, i.e. the figures are shown true to the year of the event.\"\n\nTotal deaths: \"In EM-DAT, it is the sum of deaths and missing.\"",
    "dataPublishedBy": "EMDAT (2020): OFDA/CRED International Disaster Database, Universit\u00e9 catholique de Louvain \u2013 Brussels \u2013 Belgium"
}
 2017-07-13 17:21:40 2018-01-04 09:51:17 Natural disasters from 1900 to 2019 - EMDAT (2020) 573 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. emdat defines the following variables as: Affected: "People requiring immediate assistance during a period of emergency, i.e. requiring basic survival needs such as food, water, shelter, sanitation and immediate medical assistance." Injured: "People suffering from physical injuries, trauma or an illness requiring immediate medical assistance as a direct result of a disaster." Homeless: "Number of people whose house is destroyed or heavily damaged and therefore need shelter after an event." Total affected: "In EM-DAT, it is the sum of the injured, affected and left homeless after a disaster." Estimated economic damage: "The amount of damage to property, crops, and livestock. In EM-DAT estimated damage are given in US$ (‘000). For each disaster, the registered figure corresponds to the damage value at the moment of the event, i.e. the figures are shown true to the year of the event." Total deaths: "In EM-DAT, it is the sum of deaths and missing." 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");