variables
Data license: CC-BY
7 rows where datasetId = 573 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: unit, coverage, createdAt (date), updatedAt (date)
| id ▲ | name | unit | description | createdAt | updatedAt | code | coverage | timespan | datasetId | sourceId | shortUnit | display | columnOrder | originalMetadata | grapherConfigAdmin | shortName | catalogPath | dimensions | schemaVersion | processingLevel | processingLog | titlePublic | titleVariant | attributionShort | attribution | descriptionShort | descriptionFromProducer | descriptionKey | descriptionProcessing | licenses | license | grapherConfigETL | type | sort | dataChecksum | metadataChecksum |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3573 | Total economic damage (EMDAT (2020)) | thousand US$ | The amount of damage to property, crops, and livestock. In EM-DAT estimated damage are given in US$. 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. | 2017-07-13 17:21:52 | 2023-06-15 05:05:42 | Global | 1900-2017 | Natural disasters from 1900 to 2019 - EMDAT (2020) 573 | Natural disasters - EMDAT (2020) 2212 | {
"name": "Total economic damage from natural disasters",
"unit": "US$",
"shortUnit": "$",
"tolerance": 5
} |
0 | 1 | ||||||||||||||||||||||||
| 3572 | Total affected (EMDAT (2020)) | affected | Total number of people affected by natural disasters. "In EM-DAT, it is the sum of the injured, affected and left homeless after a disaster." | 2017-07-13 17:21:50 | 2023-06-15 05:05:42 | Global | 1900-2017 | Natural disasters from 1900 to 2019 - EMDAT (2020) 573 | Natural disasters - EMDAT (2020) 2212 | {
"name": "Total number of people affected by natural disasters"
} |
0 | 1 | ||||||||||||||||||||||||
| 3571 | Homeless (EMDAT (2020)) | homeless | Number of people whose house is destroyed or heavily damaged and therefore need shelter after an event. | 2017-07-13 17:21:49 | 2023-06-15 05:05:42 | Global | 1900-2017 | Natural disasters from 1900 to 2019 - EMDAT (2020) 573 | Natural disasters - EMDAT (2020) 2212 | {
"name": "Number left homeless from natural disasters"
} |
0 | 1 | ||||||||||||||||||||||||
| 3570 | Affected (EMDAT (2020)) | 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. | 2017-07-13 17:21:47 | 2023-06-15 05:05:42 | Global | 1900-2017 | Natural disasters from 1900 to 2019 - EMDAT (2020) 573 | Natural disasters - EMDAT (2020) 2212 | {
"name": "Global numbers affected by natural disasters"
} |
0 | 1 | ||||||||||||||||||||||||
| 3569 | Injured (EMDAT (2020)) | injured | People suffering from physical injuries, trauma or an illness requiring immediate medical assistance as a direct result of a disaster. | 2017-07-13 17:21:46 | 2023-06-15 05:05:42 | global | 1900-2017 | Natural disasters from 1900 to 2019 - EMDAT (2020) 573 | Natural disasters - EMDAT (2020) 2212 | {
"name": "Global injuries from natural disasters"
} |
0 | 1 | ||||||||||||||||||||||||
| 3568 | Total deaths (EMDAT (2020)) | deaths | Total number of deaths as a result of natural disasters. "In EM-DAT, it is the sum of deaths and missing." | 2017-07-13 17:21:43 | 2023-06-15 05:05:42 | Global | 1900-2017 | Natural disasters from 1900 to 2019 - EMDAT (2020) 573 | Natural disasters - EMDAT (2020) 2212 | {
"name": "Global deaths from natural disasters"
} |
0 | 1 | ||||||||||||||||||||||||
| 3567 | Number of disasters (EMDAT (2020)) | reported disasters | Number of reported natural disasters. | 2017-07-13 17:21:40 | 2023-06-15 05:05:42 | Global | 1900-2017 | Natural disasters from 1900 to 2019 - EMDAT (2020) 573 | Natural disasters - EMDAT (2020) 2212 | {
"name": "Number of reported natural disasters"
} |
0 | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "variables" (
"id" INTEGER PRIMARY KEY AUTOINCREMENT,
"name" VARCHAR(750) NULL ,
"unit" VARCHAR(255) NOT NULL ,
"description" TEXT NULL ,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ,
"updatedAt" DATETIME NULL ,
"code" VARCHAR(255) NULL ,
"coverage" VARCHAR(255) NOT NULL ,
"timespan" VARCHAR(255) NOT NULL ,
"datasetId" INTEGER NOT NULL ,
"sourceId" INTEGER NULL ,
"shortUnit" VARCHAR(255) NULL ,
"display" TEXT NOT NULL ,
"columnOrder" INTEGER NOT NULL DEFAULT '0' ,
"originalMetadata" TEXT NULL ,
"grapherConfigAdmin" TEXT NULL ,
"shortName" VARCHAR(255) NULL ,
"catalogPath" VARCHAR(767) NULL ,
"dimensions" TEXT NULL ,
"schemaVersion" INTEGER NOT NULL DEFAULT '1' ,
"processingLevel" VARCHAR(30) NULL ,
"processingLog" TEXT NULL ,
"titlePublic" VARCHAR(512) NULL ,
"titleVariant" VARCHAR(255) NULL ,
"attributionShort" VARCHAR(512) NULL ,
"attribution" TEXT NULL ,
"descriptionShort" TEXT NULL ,
"descriptionFromProducer" TEXT NULL ,
"descriptionKey" TEXT NULL ,
"descriptionProcessing" TEXT NULL ,
"licenses" TEXT NULL ,
"license" TEXT NULL ,
"grapherConfigETL" TEXT NULL ,
"type" TEXT NULL ,
"sort" TEXT NULL ,
"dataChecksum" VARCHAR(64) NULL ,
"metadataChecksum" VARCHAR(64) NULL,
FOREIGN KEY("datasetId") REFERENCES "datasets" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT,
FOREIGN KEY("sourceId") REFERENCES "sources" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT
);
CREATE UNIQUE INDEX "idx_catalogPath" ON "variables" ("catalogPath");
CREATE UNIQUE INDEX "unique_short_name_per_dataset" ON "variables" ("shortName", "datasetId");
CREATE UNIQUE INDEX "variables_code_fk_dst_id_7bde8c2a_uniq" ON "variables" ("code", "datasetId");
CREATE INDEX "variables_datasetId_50a98bfd_fk_datasets_id" ON "variables" ("datasetId");
CREATE UNIQUE INDEX "variables_name_fk_dst_id_f7453c33_uniq" ON "variables" ("name", "datasetId");
CREATE INDEX "variables_sourceId_31fce80a_fk_sources_id" ON "variables" ("sourceId");