owid: variables: 6 rows where sourceId = 18143 sorted by id descending

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

6 rows where sourceId = 18143 sorted by id descending

descending

✎ View and edit SQL

This data as json, CSV (advanced)

id ▲	name	unit	description	createdAt	updatedAt	code	timespan	datasetId	sourceId	shortUnit	display	originalMetadata	schemaVersion
157521	Completeness of birth registration, urban (%)		Completeness of birth registration is the percentage of children under age 5 whose births were registered at the time of the survey. The numerator of completeness of birth registration includes children whose birth certificate was seen by the interviewer or whose mother or caretaker says the birth has been registered. Statistical concept and methodology: Health systems - the combined arrangements of institutions and actions whose primary purpose is to promote, restore, or maintain health (World Health Organization, World Health Report 2000) - are increasingly being recognized as key to combating disease and improving the health status of populations. The World Bank's Healthy Development: Strategy for Health, Nutrition, and Population Results emphasizes the need to strengthen health systems, which are weak in many countries, in order to increase the effectiveness of programs aimed at reducing specific diseases and further reduce morbidity and mortality. To evaluate health systems, the World Health Organization (WHO) has recommended that key components - such as financing, service delivery, workforce, governance, and information - be monitored using several key indicators. The data are a subset of the key indicators. Monitoring health systems allows the effectiveness, efficiency, and equity of different health system models to be compared. Health system data also help identify weaknesses and strengths and areas that need investment, such as additional health facilities, better health information systems, or better trained human resources. Numerous indicators have been proposed to assess a country's health information system.They can be grouped into two broad types: indicators related to data generation using core sources and methods (health surveys, civil registration, censuses, facility reporting, health system resource tracking) and indicators related to capacity for data synthesis, analysis, and validation. Indicators related to data generation reflect a country's capacity to collect relevant data at suitable …	2021-08-10 01:59:04	2023-06-15 05:05:42	SP.REG.BRTH.UR.ZS	2000-2019	World Development Indicators - World Bank (2021.07.30) 5357	UNICEF (via World Bank) 18143		{}	{}	1
157520	Completeness of birth registration, rural (%)		Completeness of birth registration is the percentage of children under age 5 whose births were registered at the time of the survey. The numerator of completeness of birth registration includes children whose birth certificate was seen by the interviewer or whose mother or caretaker says the birth has been registered. Statistical concept and methodology: Health systems - the combined arrangements of institutions and actions whose primary purpose is to promote, restore, or maintain health (World Health Organization, World Health Report 2000) - are increasingly being recognized as key to combating disease and improving the health status of populations. The World Bank's Healthy Development: Strategy for Health, Nutrition, and Population Results emphasizes the need to strengthen health systems, which are weak in many countries, in order to increase the effectiveness of programs aimed at reducing specific diseases and further reduce morbidity and mortality. To evaluate health systems, the World Health Organization (WHO) has recommended that key components - such as financing, service delivery, workforce, governance, and information - be monitored using several key indicators. The data are a subset of the key indicators. Monitoring health systems allows the effectiveness, efficiency, and equity of different health system models to be compared. Health system data also help identify weaknesses and strengths and areas that need investment, such as additional health facilities, better health information systems, or better trained human resources. Numerous indicators have been proposed to assess a country's health information system.They can be grouped into two broad types: indicators related to data generation using core sources and methods (health surveys, civil registration, censuses, facility reporting, health system resource tracking) and indicators related to capacity for data synthesis, analysis, and validation. Indicators related to data generation reflect a country's capacity to collect relevant data at suitable …	2021-08-10 01:59:04	2023-06-15 05:05:42	SP.REG.BRTH.RU.ZS	2000-2019	World Development Indicators - World Bank (2021.07.30) 5357	UNICEF (via World Bank) 18143		{}	{}	1
157519	Completeness of birth registration, male (%)		Completeness of birth registration is the percentage of children under age 5 whose births were registered at the time of the survey. The numerator of completeness of birth registration includes children whose birth certificate was seen by the interviewer or whose mother or caretaker says the birth has been registered. Statistical concept and methodology: Health systems - the combined arrangements of institutions and actions whose primary purpose is to promote, restore, or maintain health (World Health Organization, World Health Report 2000) - are increasingly being recognized as key to combating disease and improving the health status of populations. The World Bank's Healthy Development: Strategy for Health, Nutrition, and Population Results emphasizes the need to strengthen health systems, which are weak in many countries, in order to increase the effectiveness of programs aimed at reducing specific diseases and further reduce morbidity and mortality. To evaluate health systems, the World Health Organization (WHO) has recommended that key components - such as financing, service delivery, workforce, governance, and information - be monitored using several key indicators. The data are a subset of the key indicators. Monitoring health systems allows the effectiveness, efficiency, and equity of different health system models to be compared. Health system data also help identify weaknesses and strengths and areas that need investment, such as additional health facilities, better health information systems, or better trained human resources. Numerous indicators have been proposed to assess a country's health information system.They can be grouped into two broad types: indicators related to data generation using core sources and methods (health surveys, civil registration, censuses, facility reporting, health system resource tracking) and indicators related to capacity for data synthesis, analysis, and validation. Indicators related to data generation reflect a country's capacity to collect relevant data at suitable …	2021-08-10 01:59:04	2023-06-15 05:05:42	SP.REG.BRTH.MA.ZS	2003-2020	World Development Indicators - World Bank (2021.07.30) 5357	UNICEF (via World Bank) 18143		{}	{}	1
157518	Completeness of birth registration, female (%)		Completeness of birth registration is the percentage of children under age 5 whose births were registered at the time of the survey. The numerator of completeness of birth registration includes children whose birth certificate was seen by the interviewer or whose mother or caretaker says the birth has been registered. Statistical concept and methodology: Health systems - the combined arrangements of institutions and actions whose primary purpose is to promote, restore, or maintain health (World Health Organization, World Health Report 2000) - are increasingly being recognized as key to combating disease and improving the health status of populations. The World Bank's Healthy Development: Strategy for Health, Nutrition, and Population Results emphasizes the need to strengthen health systems, which are weak in many countries, in order to increase the effectiveness of programs aimed at reducing specific diseases and further reduce morbidity and mortality. To evaluate health systems, the World Health Organization (WHO) has recommended that key components - such as financing, service delivery, workforce, governance, and information - be monitored using several key indicators. The data are a subset of the key indicators. Monitoring health systems allows the effectiveness, efficiency, and equity of different health system models to be compared. Health system data also help identify weaknesses and strengths and areas that need investment, such as additional health facilities, better health information systems, or better trained human resources. Numerous indicators have been proposed to assess a country's health information system.They can be grouped into two broad types: indicators related to data generation using core sources and methods (health surveys, civil registration, censuses, facility reporting, health system resource tracking) and indicators related to capacity for data synthesis, analysis, and validation. Indicators related to data generation reflect a country's capacity to collect relevant data at suitable …	2021-08-10 01:59:04	2023-06-15 05:05:42	SP.REG.BRTH.FE.ZS	2003-2020	World Development Indicators - World Bank (2021.07.30) 5357	UNICEF (via World Bank) 18143		{}	{}	1
147947	Vitamin A supplementation coverage rate (% of children ages 6-59 months)	% of children ages 6-59 months	Vitamin A supplementation refers to the percentage of children ages 6-59 months old who received at least two doses of vitamin A in the previous year.	2021-08-09 06:23:34	2023-06-15 05:05:42	SN.ITK.VITA.ZS	1999-2018	World Development Indicators - World Bank (2021.07.30) 5357	UNICEF (via World Bank) 18143	%	{}	{}	1
147820	Completeness of birth registration (%)	%	Completeness of birth registration is the percentage of children under age 5 whose births were registered at the time of the survey. The numerator of completeness of birth registration includes children whose birth certificate was seen by the interviewer or whose mother or caretaker says the birth has been registered. Statistical concept and methodology: Health systems - the combined arrangements of institutions and actions whose primary purpose is to promote, restore, or maintain health (World Health Organization, World Health Report 2000) - are increasingly being recognized as key to combating disease and improving the health status of populations. The World Bank's Healthy Development: Strategy for Health, Nutrition, and Population Results emphasizes the need to strengthen health systems, which are weak in many countries, in order to increase the effectiveness of programs aimed at reducing specific diseases and further reduce morbidity and mortality. To evaluate health systems, the World Health Organization (WHO) has recommended that key components - such as financing, service delivery, workforce, governance, and information - be monitored using several key indicators. The data are a subset of the key indicators. Monitoring health systems allows the effectiveness, efficiency, and equity of different health system models to be compared. Health system data also help identify weaknesses and strengths and areas that need investment, such as additional health facilities, better health information systems, or better trained human resources. Numerous indicators have been proposed to assess a country's health information system.They can be grouped into two broad types: indicators related to data generation using core sources and methods (health surveys, civil registration, censuses, facility reporting, health system resource tracking) and indicators related to capacity for data synthesis, analysis, and validation. Indicators related to data generation reflect a country's capacity to collect relevant data at suitable …	2021-08-09 06:23:32	2023-06-15 05:05:42	SP.REG.BRTH.ZS	2000-2019	World Development Indicators - World Bank (2021.07.30) 5357	UNICEF (via World Bank) 18143	%	{}	{}	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");