datasets
Data license: CC-BY
8 rows where createdByUserId = 47 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: description, namespace, isPrivate, metadataEditedByUserId, dataEditedByUserId, nonRedistributable, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5397 | Global Carbon Budget - Global Carbon Project (2021) | This is a dataset imported by the automated fetcher | 2021-11-03 21:06:06 | 2021-11-05 02:58:38 | gcp_gcb@2021 | 0 | Bobbie Macdonald 47 | 2021-11-05 02:58:38 | Bobbie Macdonald 47 | 2021-11-05 02:58:38 | Bobbie Macdonald 47 | 0 | 1 | ||||
5395 | United Nations Sustainable Development Goals - United Nations (2021-10) | This is a dataset imported by the automated fetcher | 2021-11-03 12:50:20 | 2021-11-03 12:50:20 | un_sdg@2021-10 | 1 | Bobbie Macdonald 47 | 2021-11-03 12:50:20 | Bobbie Macdonald 47 | 2021-11-03 12:50:20 | Bobbie Macdonald 47 | 0 | 1 | ||||
5370 | Global Carbon Budget - Global Carbon Project (2020) | This is a dataset imported by the automated fetcher | 2021-09-14 18:45:35 | 2021-09-16 01:50:39 | gcp_gcb@2020 | 0 | Bobbie Macdonald 47 | 2021-09-16 01:50:39 | Bobbie Macdonald 47 | 2021-09-16 01:50:39 | Bobbie Macdonald 47 | 0 | 1 | ||||
5357 | World Development Indicators - World Bank (2021.07.30) | This is a dataset imported by the automated fetcher | 2021-08-09 06:23:31 | 2021-08-10 01:58:59 | [email protected] | 1 | Bobbie Macdonald 47 | 2021-08-10 01:58:59 | Bobbie Macdonald 47 | 2021-08-10 01:58:59 | Bobbie Macdonald 47 | 0 | 1 | ||||
5347 | Statistical Review of World Energy - BP (2021) | This is a dataset imported by the automated fetcher | 2021-07-16 02:44:48 | 2023-07-20 14:39:06 | bp_statreview@2021 | 1 | Bobbie Macdonald 47 | 2022-01-17 03:47:27 | Bobbie Macdonald 47 | 2022-01-17 03:47:27 | Bobbie Macdonald 47 | 0 | 1 | ||||
5305 | YouGov-Imperial COVID-19 Behavior Tracker, composite variables | 2021-05-10 02:21:27 | 2023-08-14 14:42:31 | owid | 1 | Bobbie Macdonald 47 | 2021-09-09 06:57:48 | Edouard Mathieu 46 | 2022-11-23 10:38:26 | Edouard Mathieu 46 | 0 | 1 | |||||
5279 | Global Health Observatory - World Health Organization (2021.03) | This is a temporary dataset until the automated bulk import script is run. | 2021-03-22 04:09:00 | 2024-03-11 14:05:28 | owid | 1 | Bobbie Macdonald 47 | 2021-03-22 15:14:01 | Bobbie Macdonald 47 | 2021-03-22 15:14:01 | Bobbie Macdonald 47 | 0 | 1 | ||||
5208 | United States Voter Turnout Demographics in Presidential Elections - United States Elections Project | 2020-10-29 02:58:51 | 2023-02-15 10:49:10 | owid | 1 | Bobbie Macdonald 47 | 2023-02-15 10:49:11 | Fiona Spooner 54 | 2020-11-01 14:05:56 | Hannah Ritchie 14 | 1 | 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");