datasets
Data license: CC-BY
1 row where dataEditedByUserId = 65 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5741 | Income Classification - World Bank (2021) | Updated version of the 2017 classification dataset | 2022-08-30 04:02:29 | 2024-03-12 13:57:17 | owid | 0 | Mallika Snyder 65 | 2023-04-21 11:01:25 | Edouard Mathieu 46 | 2023-04-21 11:01:25 | Mallika Snyder 65 | 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");