datasets

This table contains information on all the datasets we publish. Variables are linked to a dataset in a n:1 relationship

Data license: CC-BY

1 row where metadataEditedByUserId = 72 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▲ name description createdAt updatedAt namespace isPrivate createdByUserId metadataEditedAt metadataEditedByUserId dataEditedAt dataEditedByUserId nonRedistributable isArchived sourceChecksum shortName version updatePeriodDays
5619 Oil Spills (ITOPF, 2021)   2022-05-04 14:34:51 2023-05-26 14:52:09 owid 0 Hannah Ritchie 14 2023-05-26 09:22:29 Veronika Samborska 72 2022-05-04 15:15:27 Hannah Ritchie 14 0 1        

Advanced export

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

CSV options: 

CREATE TABLE "datasets" (
	"id" INTEGER PRIMARY KEY AUTOINCREMENT,
	"name" VARCHAR(512) NOT NULL  ,
	"description" TEXT NOT NULL  ,
	"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ,
	"updatedAt" DATETIME NULL  ,
	"namespace" VARCHAR(255) NOT NULL  ,
	"isPrivate" TINYINT NOT NULL DEFAULT '0' ,
	"createdByUserId" INTEGER NOT NULL  ,
	"metadataEditedAt" DATETIME NOT NULL  ,
	"metadataEditedByUserId" INTEGER NOT NULL  ,
	"dataEditedAt" DATETIME NOT NULL  ,
	"dataEditedByUserId" INTEGER NOT NULL  ,
	"nonRedistributable" TINYINT NOT NULL DEFAULT '0' ,
	"isArchived" TINYINT NOT NULL DEFAULT '0' ,
	"sourceChecksum" VARCHAR(64) NULL  ,
	"shortName" VARCHAR(255) NULL  ,
	"version" VARCHAR(255) NULL  ,
	"updatePeriodDays" INTEGER NULL,
	FOREIGN KEY("createdByUserId") REFERENCES "users" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT,
	FOREIGN KEY("dataEditedByUserId") REFERENCES "users" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT,
	FOREIGN KEY("metadataEditedByUserId") REFERENCES "users" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT
);
CREATE INDEX "datasets_createdByUserId" ON "datasets" ("createdByUserId");
CREATE INDEX "datasets_dataEditedByUserId" ON "datasets" ("dataEditedByUserId");
CREATE INDEX "datasets_metadataEditedByUserId" ON "datasets" ("metadataEditedByUserId");
CREATE UNIQUE INDEX "unique_short_name_version_namespace" ON "datasets" ("shortName", "version", "namespace");