datasets
Data license: CC-BY
7 rows where createdByUserId = 50 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: description, dataEditedByUserId, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5781 | Seasonal influenza mortality – GLaMOR (2019) | This dataset has higher estimates for seasonal influenza mortality for Eastern European countries than the CDC dataset. | 2022-09-26 08:49:29 | 2023-05-04 09:28:53 | owid | 1 | Saloni Dattani 50 | 2023-05-04 09:28:53 | Saloni Dattani 50 | 2023-05-04 09:28:53 | Fiona Spooner 54 | 0 | 0 | ||||
| 5572 | Polio vaccine costs in low-income countries | 2022-04-05 14:18:02 | 2022-04-05 14:18:02 | owid | 1 | Saloni Dattani 50 | 2022-04-05 14:44:42 | Saloni Dattani 50 | 2022-04-05 14:18:02 | Saloni Dattani 50 | 0 | 0 | |||||
| 5477 | Dropouts in antidepressant trials by cause – Schalkwijk (2014) | Note that there were also other concurrent temporal trends including sample size, number of sites, subject age, trial duration, and drug dosage. | 2022-01-24 13:27:46 | 2022-01-24 13:27:46 | owid | 1 | Saloni Dattani 50 | 2022-01-24 13:28:25 | Saloni Dattani 50 | 2022-01-24 13:27:46 | Saloni Dattani 50 | 0 | 0 | ||||
| 5451 | Current depression by age and gender – APMS (2014) | 2022-01-12 15:54:16 | 2023-05-04 15:00:32 | owid | 1 | Saloni Dattani 50 | 2022-01-12 16:12:24 | Saloni Dattani 50 | 2022-01-12 15:54:16 | Saloni Dattani 50 | 0 | 1 | |||||
| 5423 | Randomized controlled trials published in high-impact medical journals | 2021-11-29 22:11:31 | 2021-11-29 22:11:31 | owid | 1 | Saloni Dattani 50 | 2022-02-02 14:39:28 | Saloni Dattani 50 | 2022-02-02 14:51:01 | Saloni Dattani 50 | 0 | 0 | |||||
| 5421 | Clinical trials results reporting – EU-CTR (Dal-Ré, 2021) | 2021-11-29 18:21:13 | 2021-11-29 18:21:13 | owid | 1 | Saloni Dattani 50 | 2022-02-03 19:17:21 | Saloni Dattani 50 | 2021-11-29 18:21:13 | Saloni Dattani 50 | 0 | 0 | |||||
| 5419 | Clinical trial results reporting by country – EU-CTR (Dal-Ré et al., 2021) | 2021-11-29 17:15:51 | 2021-11-29 17:15:51 | owid | 1 | Saloni Dattani 50 | 2022-02-03 19:16:58 | Saloni Dattani 50 | 2021-11-29 17:15:51 | Saloni Dattani 50 | 0 | 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");