datasets
Data license: CC-BY
4 rows where metadataEditedByUserId = 33 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4135 | Number of direct national elections — NELDA (2015) | 2019-06-05 03:26:32 | 2019-06-05 04:44:13 | owid | 0 | Choo Yan Min 33 | 2019-06-05 04:44:13 | Choo Yan Min 33 | 2019-06-05 04:44:13 | Choo Yan Min 33 | 0 | 1 | |||||
3221 | Alcohol consumption by type since 1890 (Alexander & Holmes, 2017) | 2019-02-14 15:31:11 | 2019-02-14 15:31:11 | owid | 0 | Hannah Ritchie 14 | 2019-06-04 06:14:17 | Choo Yan Min 33 | 2019-02-14 15:42:52 | Hannah Ritchie 14 | 0 | 0 | |||||
3220 | Alcohol consumption since 1890 (Alexander & Holmes, 2017) | 2019-02-14 15:18:55 | 2019-02-14 15:18:55 | owid | 0 | Hannah Ritchie 14 | 2019-06-04 06:13:23 | Choo Yan Min 33 | 2019-02-14 15:18:55 | Hannah Ritchie 14 | 0 | 0 | |||||
2761 | Alcohol consumption in USA since 1850 — NIAAA | 2018-04-17 15:18:07 | 2018-04-17 15:18:07 | owid | 0 | Hannah Ritchie 14 | 2019-06-04 06:11:12 | Choo Yan Min 33 | 2022-11-24 11:54:01 | Edouard Mathieu 46 | 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");