datasets
Data license: CC-BY
4 rows where dataEditedByUserId = 9 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: description, namespace, isPrivate, metadataEditedByUserId, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||||
| 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 | ||||
| 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 | |||||
| 115 | Countries Continents | Continents each country belongs to. Good one. | 2015-08-19 00:09:40 | 2021-10-24 11:53:02 | owid | 0 | Jaiden Mispy 9 | 2021-10-24 11:53:02 | Edouard Mathieu 46 | 2021-10-24 11:53:02 | Jaiden Mispy 9 | 0 | 0 |
Advanced export
JSON shape: default, array, newline-delimited, object
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");