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

6 rows where createdByUserId = 35 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: isArchived, 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
4882 GAVI country eligibility - 2019   2019-12-04 15:36:48 2019-12-04 16:06:02 owid 1 Bernadeta 35 2019-12-04 16:06:02 Bernadeta 35 2019-12-04 16:06:02 Bernadeta 35 0 0        
4251 Streptococcus-caused deaths in children under-5, Wahl (2018)   2019-11-11 11:01:24 2019-11-11 11:04:55 owid 1 Bernadeta 35 2019-11-11 11:04:55 Bernadeta 35 2019-11-11 11:04:55 Bernadeta 35 0 0        
4249 Neonatal causes of death, IHME (2017)   2019-11-07 11:11:40 2019-11-07 11:14:20 owid 1 Bernadeta 35 2019-11-07 11:14:20 Bernadeta 35 2019-11-07 11:14:20 Bernadeta 35 0 1        
4228 Female mean age of childbearing (years)   2019-10-11 14:11:52 2019-10-11 14:19:54 owid 1 Bernadeta 35 2019-10-11 14:19:54 Bernadeta 35 2019-10-11 14:19:54 Bernadeta 35 0 0        
4209 Annual deaths averted by PCV13- Chen et al., The Lancet Global Health (2019)   2019-09-18 12:24:05 2019-09-18 12:24:05 owid 1 Bernadeta 35 2019-09-18 12:26:58 Bernadeta 35 2019-09-18 12:24:05 Bernadeta 35 0 0        
4203 Percentage of children under 5 with symptoms of pneumonia taken for care to a health provider   2019-09-05 06:10:19 2024-04-11 08:48:26 owid 1 Bernadeta 35 2019-09-05 06:14:48 Bernadeta 35 2019-09-05 06:14:48 Bernadeta 35 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");