variables

This table contains all the variables of all the datasets we have at Our World In Data. Note that this includes only the information about the variables like name and default display settings, not the data itself.

Data license: CC-BY

27 rows where datasetId = 5191 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: description, 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
145129 YFV (unvaccinated children)   Yellow Fever (YF) is a mosquito-borne viral disease of humans and other primates, and is currently endemic in over 43 countries in the tropical regions of Africa and The Americas. Infection with the YF virus can be asymptomatic or cause a wide spectrum of disease, from mild symptoms to severe illness with bleeding, jaundice and, death. 2020-10-02 07:54:05 2023-06-15 05:05:42       WHO-UNICEF Vaccination Coverage (2020) 5191 World Health Organization (WHO); UNICEF 17921   
{
    "name": "Number of one-year-olds who did not receive the vaccine against yellow fever",
    "unit": "unvaccinated children",
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
145128 RotaC (unvaccinated children)   Rotaviruses are the most common cause of diarrhoeal disease in young children. 2020-10-02 07:54:05 2023-06-15 05:05:42       WHO-UNICEF Vaccination Coverage (2020) 5191 World Health Organization (WHO); UNICEF 17921   
{
    "name": "Number of one-year-olds who did not receive the vaccine against rotavirus",
    "unit": "unvaccinated children",
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
145127 RCV1 (unvaccinated children)     2020-10-02 07:54:05 2023-06-15 05:05:42       WHO-UNICEF Vaccination Coverage (2020) 5191 World Health Organization (WHO); UNICEF 17921   
{
    "name": "Number of one-year-olds who did not receive the vaccine against rubella (RCV1)",
    "unit": "unvaccinated children",
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
145126 Pol3 (unvaccinated children)   Polio is a highly infectious viral disease. The polio virus invades the nervous system and can cause irreversible paralysis. 2020-10-02 07:54:05 2023-06-15 05:05:42       WHO-UNICEF Vaccination Coverage (2020) 5191 World Health Organization (WHO); UNICEF 17921   
{
    "name": "Number of one-year-olds who did not receive the polio vaccine (Pol3)",
    "unit": "unvaccinated children",
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
145125 PCV3 (unvaccinated children)   Streptococcus pneumoniae is a bacterium that causes a number of common diseases including meningitis, septicaemia and pneumonia. It is most common in young children and the elderly. 2020-10-02 07:54:05 2023-06-15 05:05:42       WHO-UNICEF Vaccination Coverage (2020) 5191 World Health Organization (WHO); UNICEF 17921   
{
    "name": "Number of one-year-olds who did not receive the vaccine against pneumococcal conjugate (PCV3)",
    "unit": "unvaccinated children",
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
145123 MCV1 (unvaccinated children)   Measles is a highly contagious viral disease, most common in young children. Its effects include blindness, inflammation of the brain, severe diarrhoea, and severe respiratory infections such as pneumonia. 2020-10-02 07:54:05 2023-06-15 05:05:42       WHO-UNICEF Vaccination Coverage (2020) 5191 World Health Organization (WHO); UNICEF 17921   
{
    "name": "Number of one-year-olds who did not receive the first measles vaccine (MCV1)",
    "unit": "unvaccinated children",
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
145122 IPV1 (unvaccinated children)   Polio is a highly infectious viral disease. The polio virus invades the nervous system and can cause irreversible paralysis. IPV protects children against polioviruses types 1, 2 and 3. IPV does not replace the Oral Polio Vaccine (Pol3), but is used with OPV to strengthen a child’s immune system and protect them from polio. 2020-10-02 07:54:05 2023-06-15 05:05:42       WHO-UNICEF Vaccination Coverage (2020) 5191 World Health Organization (WHO); UNICEF 17921   
{
    "name": "Number of one-year-olds who did not receive the inactivate polio vaccine (IPV1)",
    "unit": "unvaccinated children",
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
145121 Hib3 (unvaccinated children)   Haemophilus influenza type B is a bacteria responsible for severe pneumonia, meningitis and other invasive diseases almost exclusively in children younger than 5 years. 2020-10-02 07:54:05 2023-06-15 05:05:42       WHO-UNICEF Vaccination Coverage (2020) 5191 World Health Organization (WHO); UNICEF 17921   
{
    "name": "Number of one-year-olds who did not receive the vaccine against Haemophilus influenzae type B (Hib3)",
    "unit": "unvaccinated children",
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
145120 HepB_BD (unvaccinated children)     2020-10-02 07:54:05 2023-06-15 05:05:42       WHO-UNICEF Vaccination Coverage (2020) 5191 World Health Organization (WHO); UNICEF 17921   
{}
 0           1                                  
145119 HepB3 (unvaccinated children)   Hepatitis B is a viral infection that attacks the liver and can cause both acute and chronic disease. 2020-10-02 07:54:05 2023-06-15 05:05:42       WHO-UNICEF Vaccination Coverage (2020) 5191 World Health Organization (WHO); UNICEF 17921   
{
    "name": "Number of one-year-olds who did not receive the vaccine against hepatitis (HepB3)",
    "unit": "unvaccinated children",
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
145118 DTP1 (unvaccinated children)   Diphtheria and pertussis are infectious respiratory diseases caused by bacteria in the throat and airways. Tetanus is a bacterial infection that leads to severe muscle spasms, fever, headache, and can be fatal. 2020-10-02 07:54:05 2023-06-15 05:05:42       WHO-UNICEF Vaccination Coverage (2020) 5191 World Health Organization (WHO); UNICEF 17921   
{
    "name": "Number of one-year-olds who did not receive the first dose of diphtheria, tetanus and pertussis vaccine (DTP1)",
    "unit": "unvaccinated children",
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
145117 DTP3 (unvaccinated children)   Diphtheria and pertussis are infectious respiratory diseases caused by bacteria in the throat and airways. Tetanus is a bacterial infection that leads to severe muscle spasms, fever, headache, and can be fatal. 2020-10-02 07:54:05 2023-06-15 05:05:42       WHO-UNICEF Vaccination Coverage (2020) 5191 World Health Organization (WHO); UNICEF 17921   
{
    "name": "Number of one-year-olds who did not receive the vaccine against diphtheria, pertussis, and tetanus (DTP3)",
    "unit": "unvaccinated children",
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
145116 BCG (unvaccinated children)   Bacillus Calmette-Guérin (BCG) vaccine protects against tuberculosis, which is a chronic lung infection caused by a bacterium that leads to chronic cough with blood-containing mucus, fever, weight loss, and fatigue. 2020-10-02 07:54:05 2023-06-15 05:05:42       WHO-UNICEF Vaccination Coverage (2020) 5191 World Health Organization (WHO); UNICEF 17921   
{
    "name": "Number of one-year-olds who did not receive the vaccine against tuberculosis (BCG)",
    "unit": "unvaccinated children",
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
145115 YFV (% of one-year-olds immunized)   Yellow Fever (YF) is a mosquito-borne viral disease of humans and other primates, and is currently endemic in over 43 countries in the tropical regions of Africa and The Americas. Infection with the YF virus can be asymptomatic or cause a wide spectrum of disease, from mild symptoms to severe illness with bleeding, jaundice and, death. 2020-10-02 07:54:05 2023-06-15 05:05:42       WHO-UNICEF Vaccination Coverage (2020) 5191 World Health Organization (WHO); UNICEF 17921   
{
    "name": "Share of one-year-olds vaccinated against yellow fever",
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
145114 RotaC (% of one-year-olds immunized)   Rotaviruses are the most common cause of diarrhoeal disease in young children. 2020-10-02 07:54:05 2023-06-15 05:05:42       WHO-UNICEF Vaccination Coverage (2020) 5191 World Health Organization (WHO); UNICEF 17921   
{
    "name": "Share of one-year-olds vaccinated against rotavirus",
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
145113 RCV1 (% of one-year-olds immunized)     2020-10-02 07:54:05 2023-06-15 05:05:42       WHO-UNICEF Vaccination Coverage (2020) 5191 World Health Organization (WHO); UNICEF 17921   
{
    "name": "Share of one-year-olds vaccinated against rubella (RCV1)",
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
145112 Pol3 (% of one-year-olds immunized)   Polio is a highly infectious viral disease. The polio virus invades the nervous system and can cause irreversible paralysis. 2020-10-02 07:54:05 2023-06-15 05:05:42       WHO-UNICEF Vaccination Coverage (2020) 5191 World Health Organization (WHO); UNICEF 17921   
{
    "name": "Share of one-year-olds vaccinated against polio (Pol3)",
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
145111 PCV3 (% of one-year-olds immunized)   Streptococcus pneumoniae is a bacterium that causes a number of common diseases including meningitis, septicaemia and pneumonia. It is most common in young children and the elderly. 2020-10-02 07:54:05 2023-06-15 05:05:42       WHO-UNICEF Vaccination Coverage (2020) 5191 World Health Organization (WHO); UNICEF 17921   
{
    "name": "Share of one-year-olds vaccinated against pneumococcal conjugate (PCV3)",
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
145110 MCV2 (% of children immunized)   Measles is a highly contagious viral disease, most common in young children. Its effects include blindness, inflammation of the brain, severe diarrhoea, and severe respiratory infections such as pneumonia.Recommended child's age for MCV2 vaccination varies by country. 2020-10-02 07:54:05 2023-06-15 05:05:42       WHO-UNICEF Vaccination Coverage (2020) 5191 World Health Organization (WHO); UNICEF 17921   
{
    "name": "Share of children vaccinated with the second dose of measles vaccine (MCV2)",
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
145109 MCV1 (% of one-year-olds immunized)   Measles is a highly contagious viral disease, most common in young children. Its effects include blindness, inflammation of the brain, severe diarrhoea, and severe respiratory infections such as pneumonia. 2020-10-02 07:54:05 2023-06-15 05:05:42       WHO-UNICEF Vaccination Coverage (2020) 5191 World Health Organization (WHO); UNICEF 17921   
{
    "name": "Share of one-year olds vaccinated against measles (MCV1)",
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
145108 IPV1 (% of one-year-olds immunized)   Polio is a highly infectious viral disease. The polio virus invades the nervous system and can cause irreversible paralysis. IPV protects children against polioviruses types 1, 2 and 3. IPV does not replace the Oral Polio Vaccine (Pol3), but is used with OPV to strengthen a child’s immune system and protect them from polio. 2020-10-02 07:54:05 2023-06-15 05:05:42       WHO-UNICEF Vaccination Coverage (2020) 5191 World Health Organization (WHO); UNICEF 17921   
{
    "name": "Share of one-year-olds who receive the inactivated polio vaccine (IPV)",
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
145107 Hib3 (% of one-year-olds immunized)   Haemophilus influenza type B is a bacteria responsible for severe pneumonia, meningitis and other invasive diseases almost exclusively in children younger than 5 years. 2020-10-02 07:54:05 2023-06-15 05:05:42       WHO-UNICEF Vaccination Coverage (2020) 5191 World Health Organization (WHO); UNICEF 17921   
{
    "name": "Share of one-year-olds vaccinated against Haemophilus influenzae type B (Hib3)",
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
145106 HepB_BD (% of one-year-olds immunized)     2020-10-02 07:54:05 2023-06-15 05:05:42       WHO-UNICEF Vaccination Coverage (2020) 5191 World Health Organization (WHO); UNICEF 17921   
{}
 0           1                                  
145105 HepB3 (% of one-year-olds immunized)   Hepatitis B is a viral infection that attacks the liver and can cause both acute and chronic disease. 2020-10-02 07:54:05 2023-06-15 05:05:42       WHO-UNICEF Vaccination Coverage (2020) 5191 World Health Organization (WHO); UNICEF 17921   
{
    "name": "Share of one-year-olds vaccinated against hepatitis B (HepB3)",
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
145104 DTP3 (% of one-year-olds immunized)   Diphtheria and pertussis are infectious respiratory diseases caused by bacteria in the throat and airways.Tetanus is a bacterial infection that leads to severe muscle spasms, fever, headache, and can be fatal. 2020-10-02 07:54:05 2023-06-15 05:05:42       WHO-UNICEF Vaccination Coverage (2020) 5191 World Health Organization (WHO); UNICEF 17921   
{
    "name": "Share of one-year-olds vaccinated against diphtheria, pertussis, and tetanus (DTP3)",
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
145103 DTP1 (% of one-year-olds immunized)   Diphtheria and pertussis are infectious respiratory diseases caused by bacteria in the throat and airways.Tetanus is a bacterial infection that leads to severe muscle spasms, fever, headache, and can be fatal. 2020-10-02 07:54:05 2023-06-15 05:05:42       WHO-UNICEF Vaccination Coverage (2020) 5191 World Health Organization (WHO); UNICEF 17921   
{
    "name": "Share of one-year-olds who received the first dose of diphtheria, tetanus and pertussis vaccine (DTP1)",
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
145102 BCG (% of one-year-olds immunized)   Bacillus Calmette-Guérin (BCG) vaccine protects against tuberculosis, which is a chronic lung infection caused by a bacterium that leads to chronic cough with blood-containing mucus, fever, weight loss, and fatigue. 2020-10-02 07:54:05 2023-06-15 05:05:42       WHO-UNICEF Vaccination Coverage (2020) 5191 World Health Organization (WHO); UNICEF 17921   
{
    "name": "Share of one-year-olds vaccinated against tuberculosis (BCG)",
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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");