dataset_tags
Data license: CC-BY
4 rows where tagId = 244
This data as json, CSV (advanced)
Suggested facets: createdAt, createdAt (date)
Link | datasetId | tagId | createdAt | updatedAt |
---|---|---|---|---|
134,244 | RAND Database of Worldwide Terrorism Incidents 134 | Terrorism 244 | 2023-02-09 10:09:04 | |
4166,244 | Reaction to Terrorism - Gallup (2019) 4166 | Terrorism 244 | 2023-02-09 10:09:04 | |
4167,244 | Worries about Terrorism - World Values Survey (2019) 4167 | Terrorism 244 | 2023-02-09 10:09:04 | |
5647,244 | Global Terrorism Database 5647 | Terrorism 244 | 2023-03-14 10:19:27 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "dataset_tags" ( "datasetId" INTEGER NOT NULL , "tagId" INTEGER NOT NULL , "createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP , "updatedAt" DATETIME NULL , PRIMARY KEY ("datasetId", "tagId"), FOREIGN KEY("tagId") REFERENCES "tags" ("id") ON UPDATE RESTRICT ON DELETE CASCADE, FOREIGN KEY("datasetId") REFERENCES "datasets" ("id") ON UPDATE RESTRICT ON DELETE CASCADE ); CREATE INDEX "FK_2e330c9e1074b457d1d238b2dac" ON "dataset_tags" ("tagId");