variables
Data license: CC-BY
19 rows where datasetId = 5192 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: description, createdAt, display, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 145148 | Number without access to basic handwashing (urban) | Access to basic handwashing facilities refers to a device to facilitate handwashing with soap and water available on the premises. Handwashing facilities may be fixed or mobile and include a sink with tap water, buckets with taps, tippy-taps, and jugs or basins designated for handwashing. | 2020-10-03 10:07:45 | 2023-06-15 05:05:42 | Global Health Indicators – Number of People (2020) 5192 | Calculated by Our World in Data based on WHO/UNICEF or IHME and UN Population Division (2019) 17922 | {
"name": "Number of people in urban areas without basic handwashing facilities",
"unit": "people",
"includeInTable": true,
"numDecimalPlaces": 0
} |
0 | 1 | |||||||||||||||||||||||||||
| 145147 | Number without access to basic handwashing (rural) | Access to basic handwashing facilities refers to a device to facilitate handwashing with soap and water available on the premises. Handwashing facilities may be fixed or mobile and include a sink with tap water, buckets with taps, tippy-taps, and jugs or basins designated for handwashing. | 2020-10-03 10:07:45 | 2023-06-15 05:05:42 | Global Health Indicators – Number of People (2020) 5192 | Calculated by Our World in Data based on WHO/UNICEF or IHME and UN Population Division (2019) 17922 | {
"name": "Number of people in rural areas without basic handwashing facilities",
"unit": "people",
"includeInTable": true,
"numDecimalPlaces": 0
} |
0 | 1 | |||||||||||||||||||||||||||
| 145146 | Number without access to basic handwashing | Access to basic handwashing facilities refers to a device to facilitate handwashing with soap and water available on the premises. Handwashing facilities may be fixed or mobile and include a sink with tap water, buckets with taps, tippy-taps, and jugs or basins designated for handwashing. | 2020-10-03 10:07:45 | 2023-06-15 05:05:42 | Global Health Indicators – Number of People (2020) 5192 | Calculated by Our World in Data based on WHO/UNICEF or IHME and UN Population Division (2019) 17922 | {
"name": "Number of people without basic handwashing facilities",
"unit": "people",
"includeInTable": true,
"numDecimalPlaces": 0
} |
0 | 1 | |||||||||||||||||||||||||||
| 145145 | Number of maternal deaths (IHME) | The number of women who die from pregnancy-related causes. A maternal death refers to the death of a woman while pregnant or within 42 days of termination of pregnancy. Included are deaths from any cause related to or aggravated by the pregnancy but not from accidental or incidental causes. | 2020-10-03 08:37:54 | 2023-06-15 05:05:42 | Global Health Indicators – Number of People (2020) 5192 | Calculated by Our World in Data based on WHO/UNICEF or IHME and UN Population Division (2019) 17922 | {
"name": "Number of maternal deaths",
"unit": "deaths",
"includeInTable": true,
"numDecimalPlaces": 0
} |
0 | 1 | |||||||||||||||||||||||||||
| 145144 | Number of children who are underweight (WHO/UNICEF) | 2020-10-03 08:37:54 | 2023-06-15 05:05:42 | Global Health Indicators – Number of People (2020) 5192 | Calculated by Our World in Data based on WHO/UNICEF or IHME and UN Population Division (2019) 17922 | {
"name": "Number of children who are underweight",
"unit": "children",
"includeInTable": true,
"numDecimalPlaces": 0
} |
0 | 1 | ||||||||||||||||||||||||||||
| 145143 | Number of children who are wasted (IHME) | The number of children younger than five who are 'wasted' – whose weight is significantly lower than the average for their height, as a a consequence of acute food shortage or disease. Wasting in children is defined as having a weight less than two standard deviations below the median for their height. | 2020-10-03 08:37:54 | 2023-06-15 05:05:42 | Global Health Indicators – Number of People (2020) 5192 | Calculated by Our World in Data based on WHO/UNICEF or IHME and UN Population Division (2019) 17922 | {
"name": "Number of children who are wasted",
"unit": "children",
"includeInTable": true,
"numDecimalPlaces": 0
} |
0 | 1 | |||||||||||||||||||||||||||
| 145142 | Number of children who are wasted (WHO/UNICEF) | The number of children younger than five who are 'wasted' – whose weight is significantly lower than the average for their height, as a a consequence of acute food shortage or disease. Wasting in children is defined as having a weight less than two standard deviations below the median for their height. | 2020-10-03 08:37:54 | 2023-06-15 05:05:42 | Global Health Indicators – Number of People (2020) 5192 | Calculated by Our World in Data based on WHO/UNICEF or IHME and UN Population Division (2019) 17922 | {
"name": "Number of children who are wasted",
"unit": "children",
"includeInTable": true,
"numDecimalPlaces": 0
} |
0 | 1 | |||||||||||||||||||||||||||
| 145141 | Number of children who are stunted (IHME) | The number of children younger than five who are stunted – significantly shorter than the average for their age, as a consequence of poor nutrition or repeated infection. Stunting in children is defined as being less than two standard deviations below the median height for their age. | 2020-10-03 08:37:54 | 2023-06-15 05:05:42 | Global Health Indicators – Number of People (2020) 5192 | Calculated by Our World in Data based on WHO/UNICEF or IHME and UN Population Division (2019) 17922 | {
"name": "Number of children who are stunted",
"unit": "children",
"includeInTable": true,
"numDecimalPlaces": 0
} |
0 | 1 | |||||||||||||||||||||||||||
| 145140 | Number of children who are stunted (WHO/UNICEF) | The number of children younger than five who are stunted – significantly shorter than the average for their age, as a consequence of poor nutrition or repeated infection. Stunting in children is defined as being less than two standard deviations below the median height for their age. | 2020-10-03 08:37:54 | 2023-06-15 05:05:42 | Global Health Indicators – Number of People (2020) 5192 | Calculated by Our World in Data based on WHO/UNICEF or IHME and UN Population Division (2019) 17922 | {
"name": "Number of children who are stunted",
"unit": "children",
"includeInTable": true,
"numDecimalPlaces": 0
} |
0 | 1 | |||||||||||||||||||||||||||
| 145139 | Number without access to improved water sources (urban) | An 'improved drinking water source' includes piped water on premises and other improved drinking water sources: public taps or standpipes, tube wells or boreholes, protected dug wells, protected springs, and rainwater collection. | 2020-10-03 08:37:54 | 2023-06-15 05:05:42 | Global Health Indicators – Number of People (2020) 5192 | Calculated by Our World in Data based on WHO/UNICEF or IHME and UN Population Division (2019) 17922 | {
"name": "Number of people in urban areas without access to an improved water source",
"unit": "people",
"includeInTable": true,
"numDecimalPlaces": 0
} |
0 | 1 | |||||||||||||||||||||||||||
| 145138 | Number without access to improved water sources (rural) | An 'improved drinking water source' includes piped water on premises and other improved drinking water sources: public taps or standpipes, tube wells or boreholes, protected dug wells, protected springs, and rainwater collection. | 2020-10-03 08:37:54 | 2023-06-15 05:05:42 | Global Health Indicators – Number of People (2020) 5192 | Calculated by Our World in Data based on WHO/UNICEF or IHME and UN Population Division (2019) 17922 | {
"name": "Number of people in rural areas without access to an improved water source",
"unit": "people",
"includeInTable": true,
"numDecimalPlaces": 0
} |
0 | 1 | |||||||||||||||||||||||||||
| 145137 | Number without access to improved water sources | An 'improved drinking water source' includes piped water on premises and other improved drinking water sources: public taps or standpipes, tube wells or boreholes, protected dug wells, protected springs, and rainwater collection. | 2020-10-03 08:37:54 | 2023-06-15 05:05:42 | Global Health Indicators – Number of People (2020) 5192 | Calculated by Our World in Data based on WHO/UNICEF or IHME and UN Population Division (2019) 17922 | {
"name": "Number of people without access to an improved water source",
"unit": "people",
"includeInTable": true,
"numDecimalPlaces": 0
} |
0 | 1 | |||||||||||||||||||||||||||
| 145136 | Number without access to improved sanitation (urban) | An 'improved sanitation facility' includes flush/pour flush (to piped sewer system, septic tank, pit latrine), ventilated improved pit latrine, pit latrine with slab, and composting toilet. | 2020-10-03 08:37:54 | 2023-06-15 05:05:42 | Global Health Indicators – Number of People (2020) 5192 | Calculated by Our World in Data based on WHO/UNICEF or IHME and UN Population Division (2019) 17922 | {
"name": "Number of people in urban areas without access to improved sanitation facilities",
"unit": "people",
"includeInTable": true,
"numDecimalPlaces": 0
} |
0 | 1 | |||||||||||||||||||||||||||
| 145135 | Number without access to improved sanitation (rural) | An 'improved sanitation facility' includes flush/pour flush (to piped sewer system, septic tank, pit latrine), ventilated improved pit latrine, pit latrine with slab, and composting toilet. | 2020-10-03 08:37:54 | 2023-06-15 05:05:42 | Global Health Indicators – Number of People (2020) 5192 | Calculated by Our World in Data based on WHO/UNICEF or IHME and UN Population Division (2019) 17922 | {
"name": "Number of people in rural areas without access to improved sanitation facilities",
"unit": "people",
"includeInTable": true,
"numDecimalPlaces": 0
} |
0 | 1 | |||||||||||||||||||||||||||
| 145134 | Number without access to improved sanitation | An 'improved sanitation facility' includes flush/pour flush (to piped sewer system, septic tank, pit latrine), ventilated improved pit latrine, pit latrine with slab, and composting toilet. | 2020-10-03 08:37:54 | 2023-06-15 05:05:42 | Global Health Indicators – Number of People (2020) 5192 | Calculated by Our World in Data based on WHO/UNICEF or IHME and UN Population Division (2019) 17922 | {
"name": "Number of people without access to improved sanitation facilities",
"unit": "people",
"includeInTable": true,
"numDecimalPlaces": 0
} |
0 | 1 | |||||||||||||||||||||||||||
| 145133 | Number without access to electricity (urban) | 2020-10-03 08:37:54 | 2023-06-15 05:05:42 | Global Health Indicators – Number of People (2020) 5192 | Calculated by Our World in Data based on WHO/UNICEF or IHME and UN Population Division (2019) 17922 | {
"name": "Number of people in urban areas without access to electricity",
"unit": "people",
"includeInTable": true,
"numDecimalPlaces": 0
} |
0 | 1 | ||||||||||||||||||||||||||||
| 145132 | Number without access to electricity (rural) | 2020-10-03 08:37:54 | 2023-06-15 05:05:42 | Global Health Indicators – Number of People (2020) 5192 | Calculated by Our World in Data based on WHO/UNICEF or IHME and UN Population Division (2019) 17922 | {
"name": "Number of people in rural areas without access to electricity",
"unit": "people",
"includeInTable": true,
"numDecimalPlaces": 0
} |
0 | 1 | ||||||||||||||||||||||||||||
| 145131 | Number without access to electricity | 2020-10-03 08:37:54 | 2023-06-15 05:05:42 | Global Health Indicators – Number of People (2020) 5192 | Calculated by Our World in Data based on WHO/UNICEF or IHME and UN Population Division (2019) 17922 | {
"name": "Number of people without access to electricity",
"unit": "people",
"includeInTable": true,
"numDecimalPlaces": 0
} |
0 | 1 | ||||||||||||||||||||||||||||
| 145130 | Number without access to clean cooking fuels | Access to clean fuels and technologies for cooking is the proportion of total population primarily using clean cooking fuels and technologies for cooking. Under WHO guidelines, kerosene is excluded from clean cooking fuels. | 2020-10-03 08:37:54 | 2023-06-15 05:05:42 | Global Health Indicators – Number of People (2020) 5192 | Calculated by Our World in Data based on WHO/UNICEF or IHME and UN Population Division (2019) 17922 | {
"name": "Number of people without access to clean fuels for cooking",
"unit": "people",
"includeInTable": true,
"numDecimalPlaces": 0
} |
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");