charts_x_entities
Data license: CC-BY
10 rows where chartId = 739
This data as json, CSV (advanced)
Link | chartId | entityId |
---|---|---|
739,34688 | News coverage of disasters 739 | Drought 34688 |
739,34689 | News coverage of disasters 739 | Epidemic 34689 |
739,34692 | News coverage of disasters 739 | Earthquake 34692 |
739,34695 | News coverage of disasters 739 | Flood 34695 |
739,34696 | News coverage of disasters 739 | Landslide 34696 |
739,34699 | News coverage of disasters 739 | Volcano 34699 |
739,34700 | News coverage of disasters 739 | Fire 34700 |
739,34701 | News coverage of disasters 739 | Storm 34701 |
739,34702 | News coverage of disasters 739 | Cold wave 34702 |
739,34703 | News coverage of disasters 739 | Food shortage 34703 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "charts_x_entities" ( "chartId" INTEGER NOT NULL , "entityId" INTEGER NOT NULL , PRIMARY KEY ("chartId", "entityId"), FOREIGN KEY("chartId") REFERENCES "charts" ("id") ON UPDATE CASCADE ON DELETE CASCADE, FOREIGN KEY("entityId") REFERENCES "entities" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT ); CREATE INDEX "entityId" ON "charts_x_entities" ("entityId");