dataset_tags

Relationship table to link datasets and tags

Data license: CC-BY

8 rows where tagId = 1578

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: createdAt, createdAt (date)

Link datasetId tagId createdAt updatedAt
2497,1578 German road deaths and accidents - destatis 2497 Transport 1578 2023-10-12 10:05:32  
3177,1578 Aviation accidents and fatalities by flight phase (ASN, 2019) 3177 Transport 1578 2023-10-12 10:05:27  
5163,1578 Aviation passenger kilometres and CO2 emissions (ICCT) 5163 Transport 1578 2023-02-09 10:09:04  
5164,1578 Global airline traffic and capacity (ICAO) 5164 Transport 1578 2023-04-03 09:25:46  
5167,1578 Energy efficiency by passenger mode in USA (BTS) 5167 Transport 1578 2023-02-09 10:09:04  
5169,1578 CO2 intensity of transport by mode (UK BEIS) 5169 Transport 1578 2023-02-09 10:09:04  
5193,1578 Air travel trips per capita (Airbus, 2019) 5193 Transport 1578 2023-02-09 10:09:04  
5382,1578 European vehicle passenger sales (ICCT, 2021) 5382 Transport 1578 2023-02-09 10:09:04  

Advanced export

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

CSV options: 

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