variables
Data license: CC-BY
4 rows where sourceId = 29120 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: unit, createdAt, updatedAt, timespan, display, descriptionKey, licenses, createdAt (date), updatedAt (date), descriptionKey (array)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 812570 | Under-five mortality rate | deaths per 100 live births | 2023-09-21 14:50:47 | 2024-07-08 17:29:26 | 1751-2021 | Long-run child mortality (Gapminder; UN IGME) 6220 | United Nations Inter-agency Group for Child Mortality Estimation (2023) 29120 | % | {
"unit": "deaths per 100 live births",
"shortUnit": "%",
"numDecimalPlaces": 1
} |
0 | under_five_mortality_selected | grapher/un/2023-09-19/long_run_child_mortality/long_run_child_mortality_selected#under_five_mortality_selected | 2 | major | Under-five mortality rate | Long-run data | UN IGME; Gapminder | The long-run estimated share of [newborns](#dod:newborn) who die before reaching the age of five. | [
"This long-run indicator is a combination of two data sources, Gapminder and the UN Inter-agency Group for Child Mortality Estimation (UN IGME).",
"The historical data is compiled by Gapminder, the full range of sources used can be found in the [Gapminder documentation](https://www.gapminder.org/data/documentation/gd005/)."
] |
This indicator is a combination of data from two sources: - The UN Inter-agency Group for Child Mortality Estimation (UN IGME) provides estimates of child mortality rates, which is available for some countries from 1932. - Gapminder provides estimates of child mortality rates for the years 1800 to 2015. We combine the two datasets, for years where both are available, we have a preference for the UN IGME data. | [
{
"url": "https://www.unicef.org/legal#copyright",
"name": ""
},
{
"name": "CC BY 4.0"
}
] |
{
"map": {
"time": "latest",
"colorScale": {
"baseColorScheme": "YlOrRd",
"binningStrategy": "manual",
"customNumericValues": [
0.3,
0.5,
1,
3,
5,
10,
30,
50
],
"customNumericMinValue": 0
},
"timeTolerance": 0
},
"title": "Child mortality rate",
"yAxis": {
"max": 0,
"min": 0
},
"$schema": "https://files.ourworldindata.org/schemas/grapher-schema.003.json",
"minTime": 1800,
"subtitle": "The estimated share of [newborns](#dod:newborn) who die before reaching the age of five.",
"hasMapTab": true,
"originUrl": "https://ourworldindata.org/child-mortality",
"sourceDesc": "UN IGME (2023); Gapminder (2015)",
"variantName": "Long-run data; Gapminder & UN IGME",
"selectedEntityNames": [
"United States",
"United Kingdom",
"Sweden",
"France",
"Brazil",
"India"
]
} |
float | [] |
7333e9a4341eedfdd3c1ea9cd9a5cb07 | a481292e84c06c33bd171fa333b30ed9 | ||||||||||
| 812569 | Under-five mortality rate (full) | deaths per 100 live births | 2023-09-21 14:50:47 | 2024-07-08 17:29:26 | 1800-2021 | Long-run child mortality (Gapminder; UN IGME) 6220 | United Nations Inter-agency Group for Child Mortality Estimation (2023) 29120 | % | {
"unit": "deaths per 100 live births",
"shortUnit": "%",
"numDecimalPlaces": 1
} |
0 | under_five_mortality | grapher/un/2023-09-19/long_run_child_mortality/long_run_child_mortality#under_five_mortality | 2 | [] |
[
{
"url": "https://www.unicef.org/legal#copyright",
"name": ""
},
{
"url": "https://docs.google.com/document/d/1-RmthhS2EPMK_HIpnPctcXpB0n7ADSWnXa5Hb3PxNq4/edit",
"name": "CC BY 4.0"
}
] |
float | [] |
909b26011aca370e870ba59f0adda793 | 24ee4b379ab6f54cebd619558b15ef30 | |||||||||||||||||
| 812568 | Share surviving first five years | % | 2023-09-21 14:50:46 | 2024-07-08 17:29:25 | 1800-2021 | Long-run child mortality (Gapminder; UN IGME) 6220 | United Nations Inter-agency Group for Child Mortality Estimation (2023) 29120 | % | {
"name": "",
"unit": "%",
"shortUnit": "%",
"numDecimalPlaces": "0"
} |
0 | share_surviving_first_five_years | grapher/un/2023-09-19/long_run_child_mortality/long_run_child_mortality#share_surviving_first_five_years | 2 | [] |
[
{
"url": "https://www.unicef.org/legal#copyright",
"name": ""
},
{
"url": "https://docs.google.com/document/d/1-RmthhS2EPMK_HIpnPctcXpB0n7ADSWnXa5Hb3PxNq4/edit",
"name": "CC BY 4.0"
}
] |
float | [] |
08cf180f52192590cd8404c6e91a815f | 67c81336c814b214285ef33813b8e4a4 | |||||||||||||||||
| 812567 | Share dying in first five years | % | 2023-09-21 14:50:46 | 2024-07-08 17:29:25 | 1800-2021 | Long-run child mortality (Gapminder; UN IGME) 6220 | United Nations Inter-agency Group for Child Mortality Estimation (2023) 29120 | % | {
"name": "",
"unit": "%",
"shortUnit": "%",
"numDecimalPlaces": "0"
} |
0 | share_dying_first_five_years | grapher/un/2023-09-19/long_run_child_mortality/long_run_child_mortality#share_dying_first_five_years | 2 | [] |
[
{
"url": "https://www.unicef.org/legal#copyright",
"name": ""
},
{
"url": "https://docs.google.com/document/d/1-RmthhS2EPMK_HIpnPctcXpB0n7ADSWnXa5Hb3PxNq4/edit",
"name": "CC BY 4.0"
}
] |
float | [] |
c7a72aa20fbe8e24ce3829872912802a | af63d5df8ddcf70097472e3fd6a25e79 |
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");