datasets
Data license: CC-BY
9 rows where dataEditedByUserId = 16 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: description, createdAt, updatedAt, isPrivate, metadataEditedAt, metadataEditedByUserId, dataEditedAt, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3014 | Cases of tetanus per million population (WHO and UNPD 2017) (split) | WHO dataset on the number of cases for different diseases, and the coverage of different vaccines against these disease. For TB, instead of the number of cases, we have number of deaths. | 2017-07-26 12:58:44 | 2017-11-16 11:35:31 | owid | 1 | Ruby Mittal 16 | 2017-11-16 11:35:31 | Ruby Mittal 16 | 2017-11-16 11:35:31 | Ruby Mittal 16 | 0 | 0 | ||||
| 927 | Milestones of Women's Political Representation - Paxton et al (2006) | Status of sovereign countries in each year on five variables - universal suffrage to women, first woman elected to parliament, 10%, 20% and 30% share of women in parliament. | 2017-09-14 12:36:31 | 2017-10-13 13:43:40 | owid | 0 | Ruby Mittal 16 | 2017-10-13 13:43:40 | Ruby Mittal 16 | 2017-10-13 13:43:40 | Ruby Mittal 16 | 0 | 1 | ||||
| 707 | Output of key services sectors in England - using Bank of England (2017) | This data consists the measures of output in key services sectors in England (1270-1870). | 2017-08-26 19:45:12 | 2023-07-07 15:41:59 | owid | 0 | Ruby Mittal 16 | 2023-07-07 15:41:59 | Pablo Arriagada 62 | 2017-11-27 12:46:47 | Ruby Mittal 16 | 0 | 0 | ||||
| 706 | Output of key industrial sectors in England - Bank of England (2017) | This data consists the measures of output in key industrial sectors in England (1270-1870). | 2017-08-26 19:35:45 | 2017-11-27 12:41:00 | owid | 0 | Ruby Mittal 16 | 2017-11-27 12:41:00 | Ruby Mittal 16 | 2017-11-27 12:41:00 | Ruby Mittal 16 | 0 | 0 | ||||
| 705 | Output of key industries in England - using Bank of England (2017) | This data produces output figures of key industries in England (1270-1870). | 2017-08-26 19:25:45 | 2023-07-07 15:38:07 | owid | 0 | Ruby Mittal 16 | 2023-07-07 15:38:08 | Pablo Arriagada 62 | 2017-11-27 12:44:18 | Ruby Mittal 16 | 0 | 0 | ||||
| 700 | GDP in England (using BoE, 2017) | This data uses A1. Headline Series sheet of BoE dataset to get Real GDP and Population figures for England. | 2017-08-25 12:02:37 | 2017-08-28 07:22:08 | owid | 0 | Ruby Mittal 16 | 2017-08-28 07:22:08 | Ruby Mittal 16 | 2017-08-28 07:22:08 | Ruby Mittal 16 | 0 | 0 | ||||
| 678 | PolcalNet Global Poverty (2017) | Mean and Median monthly per capita consumption/income expenditures from country level household surveys in 2011 PPP international dollars. | 2017-08-22 15:47:18 | 2024-04-11 08:48:26 | owid | 0 | Ruby Mittal 16 | 2017-08-22 15:50:46 | Ruby Mittal 16 | 2017-08-22 15:50:46 | Ruby Mittal 16 | 0 | 1 | ||||
| 669 | Women’s Political Representation using Paxton et al (2006), IPU (2017) & WDI (2017) | Share of sovereign countries between 1893 and 2017 on five variables namely, universal suffrage to women, first woman elected to parliament, 10%, 20% and 30% share of women in parliament. | 2017-08-16 14:40:32 | 2017-08-16 14:40:32 | owid | 0 | Ruby Mittal 16 | 2017-08-16 14:40:32 | Ruby Mittal 16 | 2017-08-16 14:40:32 | Ruby Mittal 16 | 0 | 1 | ||||
| 645 | Vaccine Coverage and Disease Burden - WHO (2017) | WHO dataset on the number of cases for different diseases, and the coverage of different vaccines against these disease. For TB, instead of the number of cases, we have number of deaths. | 2017-07-26 12:58:44 | 2017-11-16 11:35:31 | owid | 0 | Ruby Mittal 16 | 2017-11-16 11:35:31 | Ruby Mittal 16 | 2017-11-16 11:35:31 | Ruby Mittal 16 | 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");