datasets
Data license: CC-BY
11 rows where dataEditedByUserId = 52 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: description, isPrivate, createdByUserId, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6007 | Global Health Observatory: Age-standardized suicide rates (WHO, Invented) | 2023-05-14 21:52:59 | 2023-05-14 21:52:59 | owid | 1 | Lucas Rodés-Guirao 52 | 2023-05-14 21:52:59 | Lucas Rodés-Guirao 52 | 2023-05-14 21:52:59 | Lucas Rodés-Guirao 52 | 0 | 0 | |||||
| 5964 | Internet (various sources, DEBUG) | 2023-04-05 21:29:30 | 2024-04-11 08:48:26 | owid | 1 | Lucas Rodés-Guirao 52 | 2023-04-05 21:29:30 | Lucas Rodés-Guirao 52 | 2023-04-05 21:29:30 | Lucas Rodés-Guirao 52 | 0 | 1 | |||||
| 5879 | [TESTING] COVID-19 - Cases and deaths (WHO) | 2023-02-14 15:05:16 | 2023-02-14 15:05:16 | owid | 1 | Lucas Rodés-Guirao 52 | 2023-02-14 15:05:16 | Lucas Rodés-Guirao 52 | 2023-02-14 15:05:16 | Lucas Rodés-Guirao 52 | 0 | 1 | |||||
| 5817 | World Income Distribution - van Zanden et al. (eds.) (2-14), OECD | Backported | 2022-10-24 16:21:28 | 2022-10-24 16:21:28 | owid | 1 | Lucas Rodés-Guirao 52 | 2022-10-24 16:22:23 | Lucas Rodés-Guirao 52 | 2022-10-24 16:21:28 | Lucas Rodés-Guirao 52 | 0 | 0 | ||||
| 5816 | Income inequality (Gini coefficient) in the US - Luxembourg Income Study | Backported | 2022-10-24 15:53:38 | 2023-06-12 10:38:20 | owid | 1 | Lucas Rodés-Guirao 52 | 2022-10-24 15:59:51 | Lucas Rodés-Guirao 52 | 2022-10-24 15:53:38 | Lucas Rodés-Guirao 52 | 0 | 1 | ||||
| 5815 | Basic education by region - Zanden et al. (2014) | Backported | 2022-10-24 15:29:49 | 2023-08-23 19:54:20 | owid | 1 | Lucas Rodés-Guirao 52 | 2022-10-24 15:59:43 | Lucas Rodés-Guirao 52 | 2022-10-24 15:29:49 | Lucas Rodés-Guirao 52 | 0 | 1 | ||||
| 5814 | Inequality Among World Citizens - Bourguignon and Morrisson (2002) | Backported | 2022-10-24 15:00:33 | 2022-10-24 15:00:33 | owid | 1 | Lucas Rodés-Guirao 52 | 2022-10-24 15:59:36 | Lucas Rodés-Guirao 52 | 2022-10-24 15:00:33 | Lucas Rodés-Guirao 52 | 0 | 0 | ||||
| 5649 | data-wpp22-tmp(3) | 2022-07-08 10:21:35 | 2022-07-08 10:21:35 | owid | 1 | Lucas Rodés-Guirao 52 | 2022-07-08 10:21:59 | Lucas Rodés-Guirao 52 | 2022-07-08 10:21:35 | Lucas Rodés-Guirao 52 | 0 | 1 | |||||
| 5626 | COVID-19 - Vaccinations (debug) | 2022-05-13 11:38:26 | 2022-05-13 11:38:26 | owid | 1 | Lucas Rodés-Guirao 52 | 2022-05-13 11:38:26 | Lucas Rodés-Guirao 52 | 2022-05-13 11:38:26 | Lucas Rodés-Guirao 52 | 0 | 1 | |||||
| 2731 | Parties to Montreal Protocol (UNEP, 2023) | 2018-04-05 20:53:44 | 2023-03-23 16:15:57 | owid | 0 | Hannah Ritchie 14 | 2023-03-23 16:15:57 | Lucas Rodés-Guirao 52 | 2023-03-23 16:15:57 | Lucas Rodés-Guirao 52 | 0 | 0 | |||||
| 702 | Historical World Population Prospects (UN, various years) | 2017-08-26 16:48:38 | 2024-07-12 18:21:52 | owid | 0 | Hannah Ritchie 14 | 2023-04-14 14:09:57 | Lucas Rodés-Guirao 52 | 2022-09-21 10:52:05 | Lucas Rodés-Guirao 52 | 0 | 1 |
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");