tags
Data license: CC-BY
10 rows where parentId = 1510 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: createdAt, updatedAt, createdAt (date), updatedAt (date)
| id ▲ | name | createdAt | updatedAt | parentId | specialType | slug |
|---|---|---|---|---|---|---|
| 1826 | Military Personnel & Spending | 2023-08-29 15:48:15 | 2023-12-04 19:58:20 | Violence and War 1510 | military-personnel-spending | |
| 1798 | Biological & Chemical Weapons | 2022-09-06 14:48:46 | 2023-12-04 19:58:23 | Violence and War 1510 | biological-and-chemical-weapons | |
| 289 | Violence Against Children & Children's Rights | 2016-01-01 00:00:00 | 2023-12-04 19:58:20 | Violence and War 1510 | violence-against-rights-for-children | |
| 279 | Homicides | 2016-01-01 00:00:00 | 2023-12-04 19:58:22 | Violence and War 1510 | homicides | |
| 246 | War & Peace | 2016-01-01 00:00:00 | 2023-12-04 19:58:22 | Violence and War 1510 | war-and-peace | |
| 244 | Terrorism | 2016-01-01 00:00:00 | 2023-12-04 19:58:22 | Violence and War 1510 | terrorism | |
| 243 | Peacekeeping | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | Violence and War 1510 | ||
| 242 | Nuclear Weapons | 2016-01-01 00:00:00 | 2023-12-04 19:58:22 | Violence and War 1510 | nuclear-weapons | |
| 240 | Genocides | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | Violence and War 1510 | ||
| 239 | Civil Wars | 2016-01-01 00:00:00 | 2016-01-01 00:00:00 | Violence and War 1510 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "tags" (
"id" INTEGER PRIMARY KEY AUTOINCREMENT,
"name" VARCHAR(255) NOT NULL ,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ,
"updatedAt" DATETIME NULL ,
"parentId" INTEGER NULL ,
"specialType" VARCHAR(255) NULL ,
"slug" VARCHAR(512) NULL,
FOREIGN KEY("parentId") REFERENCES "tags" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT
);
CREATE UNIQUE INDEX "dataset_subcategories_name_fk_dst_cat_id_6ce1cc36_uniq" ON "tags" ("name", "parentId");
CREATE INDEX "parentId" ON "tags" ("parentId");