tags

Tags used in the database for various entities

Data license: CC-BY

11 rows where parentId = 1505 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: createdAt, updatedAt, createdAt (date), updatedAt (date)

id ▲ name createdAt updatedAt parentId specialType slug
1800 Artificial Intelligence 2022-11-27 19:35:09 2023-12-04 19:58:23 Innovation and Technological Change 1505   artificial-intelligence
1579 Medical & Biotechnologies 2018-11-15 09:57:25 2018-11-15 09:57:25 Innovation and Technological Change 1505    
1578 Transport 2018-11-15 09:52:54 2023-12-04 19:58:22 Innovation and Technological Change 1505   transport
321 Communication Technology 2016-01-01 00:00:00 2023-06-29 14:07:42 Innovation and Technological Change 1505    
315 Social Media 2016-01-01 00:00:00 2023-10-12 17:08:22 Innovation and Technological Change 1505    
314 Internet 2016-01-01 00:00:00 2023-12-04 19:58:22 Innovation and Technological Change 1505   internet
123 Infrastructure Projects 2016-01-01 00:00:00 2018-11-15 09:54:48 Innovation and Technological Change 1505    
115 Patents 2016-01-01 00:00:00 2018-11-15 09:56:24 Innovation and Technological Change 1505    
114 Space Exploration & Satellites 2016-01-01 00:00:00 2023-12-04 19:58:20 Innovation and Technological Change 1505   space-exploration-satellites
111 Technological Change 2016-01-01 00:00:00 2023-12-04 19:58:21 Innovation and Technological Change 1505   technological-change
110 Research & Development 2016-01-01 00:00:00 2023-12-04 19:58:21 Innovation and Technological Change 1505   research-and-development

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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");