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

16 rows where metadataEditedByUserId = 9 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: description, namespace, isPrivate, createdByUserId, dataEditedByUserId, 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
3087 Humanitarian and food aid received (OECD, 2018) For OECD Report - do not delete. 2018-10-29 15:15:52 2018-10-30 11:48:09 owid 1 Hannah Ritchie 14 2018-10-30 11:48:09 Jaiden Mispy 9 2018-10-30 11:48:09 Hannah Ritchie 14 0 1        
3073 V-Dem Dataset Version 8 - V-Dem Institute   2018-10-03 13:26:02 2018-10-03 13:26:02 vdem 1 Jaiden Mispy 9 2018-10-03 13:26:02 Jaiden Mispy 9 2018-10-03 13:26:02 Jaiden Mispy 9 0 1        
3039 Volcanic eruption deaths (NGDC/NOAA)   2018-09-21 12:49:52 2024-05-14 08:48:18 owid 0 Hannah Ritchie 14 2018-09-21 13:44:19 Jaiden Mispy 9 2018-09-21 12:49:52 Hannah Ritchie 14 0 1        
3037 Earthquake deaths (NGDC-NOAA)   2018-09-21 12:17:25 2024-05-14 08:47:52 owid 0 Hannah Ritchie 14 2018-09-21 12:35:16 Jaiden Mispy 9 2018-09-21 12:17:25 Hannah Ritchie 14 0 1        
2973 Figure 3.21 2nd version core-econ.org 2018-09-21 09:49:41 2018-09-21 09:49:41 owid 1 Gyorgy Attila Ruzicska 26 2018-09-21 10:55:12 Jaiden Mispy 9 2018-09-21 09:49:41 Gyorgy Attila Ruzicska 26 0 0        
2970 Percentage of persons without health insurance - Council of Economic Advisers and National Center for Health Statistics Split from https://owid.cloud/admin/datasets/204 - Jaiden 2018-09-21 06:20:03 2018-09-21 06:20:03 owid 0 Jaiden Mispy 9 2018-09-21 06:20:03 Jaiden Mispy 9 2018-09-21 06:20:03 Jaiden Mispy 9 0 0        
2967 Figure 4.9b core-econ.org 2018-09-20 19:36:18 2018-09-20 19:36:18 owid 1 Gyorgy Attila Ruzicska 26 2018-09-21 10:55:39 Jaiden Mispy 9 2018-09-20 19:36:18 Gyorgy Attila Ruzicska 26 0 0        
2966 Figure 4.9a core-econ.org 2018-09-20 19:14:23 2018-09-20 19:17:04 owid 1 Gyorgy Attila Ruzicska 26 2018-09-21 10:55:45 Jaiden Mispy 9 2018-09-20 19:17:04 Gyorgy Attila Ruzicska 26 0 0        
2950 Figure 3.21 core-econ.org 2018-09-17 09:37:45 2018-09-17 09:37:45 owid 1 Gyorgy Attila Ruzicska 26 2018-09-21 10:56:07 Jaiden Mispy 9 2018-09-17 09:37:45 Gyorgy Attila Ruzicska 26 0 0        
2945 Figure 2.20 core-econ.org 2018-09-15 20:31:37 2018-09-15 20:31:37 owid 1 Gyorgy Attila Ruzicska 26 2018-09-21 10:57:00 Jaiden Mispy 9 2021-05-06 08:41:32 Gyorgy Attila Ruzicska 26 0 0        
2944 Figure 2.18-a core-econ.org 2018-09-15 20:12:04 2018-09-15 20:15:18 owid 1 Gyorgy Attila Ruzicska 26 2018-09-21 10:57:04 Jaiden Mispy 9 2021-10-31 13:58:10 Tina Rozsos 56 0 0        
2940 Figure 2.11 core-econ.org 2018-09-15 15:21:19 2018-09-15 15:21:19 owid 1 Gyorgy Attila Ruzicska 26 2018-09-21 11:12:02 Jaiden Mispy 9 2019-02-28 20:35:56 Gyorgy Attila Ruzicska 26 0 0        
2939 Figure 2.10 core-econ.org 2018-09-15 13:32:44 2018-09-15 13:32:44 owid 1 Gyorgy Attila Ruzicska 26 2018-09-21 11:11:53 Jaiden Mispy 9 2018-09-15 13:32:44 Gyorgy Attila Ruzicska 26 0 0        
2903 FIgure1.7 core-econ.org 2018-08-29 10:56:57 2018-08-29 11:00:47 owid 1 Gyorgy Attila Ruzicska 26 2018-09-21 10:39:21 Jaiden Mispy 9 2018-08-29 11:00:47 Gyorgy Attila Ruzicska 26 0 0        
2760 Terrain Ruggedness Index - Nunn and Puga (2012)   2018-04-15 14:11:25 2018-04-15 14:11:25 owid 0 Jaiden Mispy 9 2018-04-15 14:11:25 Jaiden Mispy 9 2018-04-15 14:11:25 Jaiden Mispy 9 0 0        
27 Human Height - University of Tuebingen (2015)   2015-07-02 06:55:54 2017-10-28 17:34:03 owid 0 Max Roser 2 2019-02-08 19:12:36 Jaiden Mispy 9 2017-10-28 17:34:03 Max Roser 2 0 0        

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