datasets
Data license: CC-BY
9 rows where metadataEditedByUserId = 47 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: description, updatedAt, namespace, isPrivate, createdByUserId, dataEditedByUserId, 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 | ||||
| 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 | ||||
| 3080 | Share of services in total exports - WDI (2017) | 2018-10-21 20:34:25 | 2023-10-11 07:09:59 | owid | 1 | Diana Beltekian 19 | 2022-09-02 00:20:52 | Bobbie Macdonald 47 | 2022-09-02 00:20:52 | Diana Beltekian 19 | 0 | 1 | |||||
| 2809 | Urban population living in slums (WB WDI) | 2018-06-13 16:07:48 | 2023-10-11 07:09:59 | owid | 1 | Hannah Ritchie 14 | 2022-09-01 23:40:11 | Bobbie Macdonald 47 | 2018-06-13 16:19:31 | Hannah Ritchie 14 | 0 | 1 | |||||
| 352 | China share of World Poverty - World Bank (WDI) (2017) | 2017-02-16 06:15:08 | 2017-11-14 14:44:56 | owid | 1 | Marco Molteni 11 | 2022-09-02 01:03:42 | Bobbie Macdonald 47 | 2017-11-14 14:44:56 | Marco Molteni 11 | 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");