variables
Data license: CC-BY
6 rows where datasetId = 4122 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: createdAt (date), updatedAt (date)
| id ▲ | name | unit | description | createdAt | updatedAt | code | coverage | timespan | datasetId | sourceId | shortUnit | display | columnOrder | originalMetadata | grapherConfigAdmin | shortName | catalogPath | dimensions | schemaVersion | processingLevel | processingLog | titlePublic | titleVariant | attributionShort | attribution | descriptionShort | descriptionFromProducer | descriptionKey | descriptionProcessing | licenses | license | grapherConfigETL | type | sort | dataChecksum | metadataChecksum |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 104398 | Avertable deaths if rotavirus vaccine coverage was 100% (Troegers, 2018) | Estimated number of avertable deaths from rotavirus in 2016 if full coverage of the rotavirus vaccine was achieved. Estimates of potentially avertable deaths from the rotavirus vaccine take into consideration its efficacy in different regions: whilst efficacy in children in high-income countries is typically greater than 90%, in lower-income countries, particularly in Sub-Saharan Africa, this efficacy rate is closer to 50%. | 2019-05-19 19:55:23 | 2023-06-15 05:05:42 | Rotavirus deaths and cases in under-5s (IHME, 2018) 4122 | Rotavirus deaths and cases in under-5s (IHME, 2018) 16951 | {
"name": "Avertable deaths from rotavirus",
"unit": "avertable deaths"
} |
0 | 1 | |||||||||||||||||||||||||||
| 104397 | Deaths averted from rotavirus vaccine (Troeger, 2018) | Estimated number of averted deaths from the rotavirus vaccine. | 2019-05-19 19:55:23 | 2023-06-15 05:05:42 | Rotavirus deaths and cases in under-5s (IHME, 2018) 4122 | Rotavirus deaths and cases in under-5s (IHME, 2018) 16951 | {
"name": "Averted deaths from rotavirus vaccine",
"unit": "averted deaths"
} |
0 | 1 | |||||||||||||||||||||||||||
| 104396 | Rotavirus cases in children (IHME, 2018) | Estimated number of cases of rotavirus (one of the leading forms of diarrheal disease) in children under five years old. | 2019-05-19 19:55:23 | 2023-06-15 05:05:42 | Rotavirus deaths and cases in under-5s (IHME, 2018) 4122 | Rotavirus deaths and cases in under-5s (IHME, 2018) 16951 | {
"name": "Rotavirus cases in children",
"unit": "cases",
"shortUnit": "cases"
} |
0 | 1 | |||||||||||||||||||||||||||
| 104395 | Rotavirus incidence per 1,000 children (IHME, 2018) | Estimated incidence (new cases) rate from rotavirus (one of the leading forms of diarrheal disease). This is measured as the number of new cases in children under 5 years old per 1,000 in this demographic. | 2019-05-19 19:55:23 | 2023-06-15 05:05:42 | Rotavirus deaths and cases in under-5s (IHME, 2018) 4122 | Rotavirus deaths and cases in under-5s (IHME, 2018) 16951 | {
"name": "Rotavirus incidence per 1,000 children",
"unit": "cases per 1,000"
} |
0 | 1 | |||||||||||||||||||||||||||
| 104394 | Child mortality from rotavirus per 100,000 (IHME, 2018) | Estimated child mortality rate from rotavirus (one of the leading forms of diarrheal disease). This is measured as the number of deaths in children under 5 years old per 100,000 in this demographic. | 2019-05-19 19:55:23 | 2023-06-15 05:05:42 | Rotavirus deaths and cases in under-5s (IHME, 2018) 4122 | Rotavirus deaths and cases in under-5s (IHME, 2018) 16951 | {
"name": "Child mortality rate from rotavirus",
"unit": "deaths per 100,000"
} |
0 | 1 | |||||||||||||||||||||||||||
| 104393 | Child deaths from rotavirus (IHME, 2018) | Estimated number of deaths of children under five years old from rotavirus (one of the leading forms of diarrheal disease). | 2019-05-19 19:55:23 | 2023-06-15 05:05:42 | Rotavirus deaths and cases in under-5s (IHME, 2018) 4122 | Rotavirus deaths and cases in under-5s (IHME, 2018) 16951 | {
"name": "Child deaths from rotavirus",
"unit": "deaths of under-5s",
"shortUnit": "deaths"
} |
0 | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "variables" (
"id" INTEGER PRIMARY KEY AUTOINCREMENT,
"name" VARCHAR(750) NULL ,
"unit" VARCHAR(255) NOT NULL ,
"description" TEXT NULL ,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ,
"updatedAt" DATETIME NULL ,
"code" VARCHAR(255) NULL ,
"coverage" VARCHAR(255) NOT NULL ,
"timespan" VARCHAR(255) NOT NULL ,
"datasetId" INTEGER NOT NULL ,
"sourceId" INTEGER NULL ,
"shortUnit" VARCHAR(255) NULL ,
"display" TEXT NOT NULL ,
"columnOrder" INTEGER NOT NULL DEFAULT '0' ,
"originalMetadata" TEXT NULL ,
"grapherConfigAdmin" TEXT NULL ,
"shortName" VARCHAR(255) NULL ,
"catalogPath" VARCHAR(767) NULL ,
"dimensions" TEXT NULL ,
"schemaVersion" INTEGER NOT NULL DEFAULT '1' ,
"processingLevel" VARCHAR(30) NULL ,
"processingLog" TEXT NULL ,
"titlePublic" VARCHAR(512) NULL ,
"titleVariant" VARCHAR(255) NULL ,
"attributionShort" VARCHAR(512) NULL ,
"attribution" TEXT NULL ,
"descriptionShort" TEXT NULL ,
"descriptionFromProducer" TEXT NULL ,
"descriptionKey" TEXT NULL ,
"descriptionProcessing" TEXT NULL ,
"licenses" TEXT NULL ,
"license" TEXT NULL ,
"grapherConfigETL" TEXT NULL ,
"type" TEXT NULL ,
"sort" TEXT NULL ,
"dataChecksum" VARCHAR(64) NULL ,
"metadataChecksum" VARCHAR(64) NULL,
FOREIGN KEY("datasetId") REFERENCES "datasets" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT,
FOREIGN KEY("sourceId") REFERENCES "sources" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT
);
CREATE UNIQUE INDEX "idx_catalogPath" ON "variables" ("catalogPath");
CREATE UNIQUE INDEX "unique_short_name_per_dataset" ON "variables" ("shortName", "datasetId");
CREATE UNIQUE INDEX "variables_code_fk_dst_id_7bde8c2a_uniq" ON "variables" ("code", "datasetId");
CREATE INDEX "variables_datasetId_50a98bfd_fk_datasets_id" ON "variables" ("datasetId");
CREATE UNIQUE INDEX "variables_name_fk_dst_id_f7453c33_uniq" ON "variables" ("name", "datasetId");
CREATE INDEX "variables_sourceId_31fce80a_fk_sources_id" ON "variables" ("sourceId");