datasets
Data license: CC-BY
12 rows where createdByUserId = 51 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: isPrivate, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5679 | Biological and chemical weapons proliferation – OWID based on Arms Control Association (2022), Nuclear Threat Initiative (2022), Center for Nonproliferation Studies (2008) and the UN (2022) | 2022-08-05 16:27:56 | 2022-08-05 16:27:56 | owid | 0 | Bastian Herre 51 | 2022-10-11 10:32:45 | Bastian Herre 51 | 2022-10-07 12:09:47 | Bastian Herre 51 | 0 | 0 | |||||
5664 | Democracy - OWID based on Episodes of Regime Transformation (v13) | 2022-07-25 16:51:12 | 2024-05-02 12:26:52 | owid | 0 | Bastian Herre 51 | 2023-03-03 13:33:54 | Bastian Herre 51 | 2023-03-03 13:33:54 | Bastian Herre 51 | 0 | 1 | |||||
5663 | Historical conflict deaths and casualties - OWID | 2022-07-22 11:39:00 | 2023-10-11 07:09:59 | owid | 1 | Bastian Herre 51 | 2022-07-22 11:39:00 | Bastian Herre 51 | 2022-07-22 11:39:00 | Bastian Herre 51 | 0 | 1 | |||||
5659 | Democratic satisfaction - Claassen | 2022-07-18 16:14:21 | 2024-05-22 09:38:00 | owid | 0 | Bastian Herre 51 | 2022-07-25 17:48:22 | Bastian Herre 51 | 2022-07-20 15:32:29 | Bastian Herre 51 | 0 | 1 | |||||
5658 | Democratic support - Claassen | 2022-07-18 16:13:40 | 2024-05-22 09:37:57 | owid | 0 | Bastian Herre 51 | 2022-07-25 12:39:02 | Bastian Herre 51 | 2022-07-20 15:31:59 | Bastian Herre 51 | 0 | 1 | |||||
5635 | Democracy - Economist Intelligence Unit (2023) | 2022-05-27 19:50:57 | 2024-05-22 23:55:48 | owid | 0 | Bastian Herre 51 | 2023-05-26 16:31:22 | Bastian Herre 51 | 2023-05-26 16:31:22 | Bastian Herre 51 | 0 | 1 | |||||
5634 | Democracy - Bertelsmann Transformation Index (2022) | 2022-05-26 17:13:04 | 2024-05-21 22:27:29 | owid | 0 | Bastian Herre 51 | 2023-05-26 16:30:32 | Bastian Herre 51 | 2023-05-26 16:30:32 | Bastian Herre 51 | 0 | 1 | |||||
5633 | Democracy - Polity 5 | 2022-05-25 20:16:07 | 2024-05-23 00:06:04 | owid | 0 | Bastian Herre 51 | 2023-05-26 16:30:39 | Bastian Herre 51 | 2023-05-26 16:30:39 | Bastian Herre 51 | 0 | 1 | |||||
5618 | Democracy - OWID based on Boix-Miller-Rosato | 2022-05-04 08:19:59 | 2024-03-19 13:51:04 | owid | 0 | Bastian Herre 51 | 2023-05-26 16:31:07 | Bastian Herre 51 | 2023-05-26 16:31:07 | Bastian Herre 51 | 0 | 1 | |||||
5542 | Nuclear weapons proliferation total – OWID based on Bleek (2017), Nuclear Threat Initiative (2022) | 2022-02-28 08:42:46 | 2024-01-26 08:18:53 | owid | 1 | Bastian Herre 51 | 2022-06-22 17:17:42 | Bastian Herre 51 | 2022-03-04 08:21:23 | Bastian Herre 51 | 0 | 1 | |||||
5538 | Nuclear weapons proliferation – OWID based on Bleek (2017), Nuclear Threat Initiative (2022) | 2022-02-25 18:16:53 | 2024-01-26 08:18:31 | owid | 1 | Bastian Herre 51 | 2022-09-06 08:38:45 | Bastian Herre 51 | 2022-09-06 08:38:45 | Bastian Herre 51 | 0 | 1 | |||||
5534 | Nuclear weapons tests – Arms Control Association (2020) | 2022-02-24 14:49:07 | 2024-01-26 08:17:20 | owid | 1 | Bastian Herre 51 | 2022-09-06 08:10:28 | Bastian Herre 51 | 2022-02-24 14:49:07 | Bastian Herre 51 | 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");