owid: variables: 12 rows where sourceId = 18847 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

12 rows where sourceId = 18847 sorted by id descending

descending

✎ View and edit SQL

This data as json, CSV (advanced)

id ▲	name	description	createdAt	updatedAt	code	timespan	datasetId	sourceId	display	originalMetadata	schemaVersion
158424	Proportion of population spending more than 25% of household consumption or income on out-of-pocket health care expenditure (%)	Proportion of population spending more than 25% of household consumption or income on out-of-pocket health care expenditure. Statistical concept and methodology: Out-of-pocket payments are those made by people at the time of getting any type of service (preventive, curative, rehabilitative, palliative or long-term care) provided by any type of provider. They include cost-sharing (the part not covered by a third party like an insurer) and informal payments, but they exclude insurance premiums. Out-of-pocket payments exclude any reimbursement by a third party, such as the government, a health insurance fund or a private insurance company. Out-of-pocket payments are defined as catastrophic at the 25% threshold when they represent 25% or more of total consumption or income.	2021-08-10 01:59:12	2023-06-15 05:05:42	SH.UHC.OOPC.25.ZS	1985-2018	World Development Indicators - World Bank (2021.07.30) 5357	World Health Organization and World Bank 18847	{}	{}	1
158423	Proportion of population spending more than 10% of household consumption or income on out-of-pocket health care expenditure (%)	Proportion of population spending more than 10% of household consumption or income on out-of-pocket health care expenditure. Statistical concept and methodology: Out-of-pocket payments are those made by people at the time of getting any type of service (preventive, curative, rehabilitative, palliative or long-term care) provided by any type of provider. They include cost-sharing (the part not covered by a third party like an insurer) and informal payments, but they exclude insurance premiums. Out-of-pocket payments exclude any reimbursement by a third party, such as the government, a health insurance fund or a private insurance company. Out-of-pocket payments are defined as catastrophic at the 10% threshold when they represent 10% or more of total consumption or income.	2021-08-10 01:59:12	2023-06-15 05:05:42	SH.UHC.OOPC.10.ZS	1985-2018	World Development Indicators - World Bank (2021.07.30) 5357	World Health Organization and World Bank 18847	{}	{}	1
158422	Proportion of population pushed below the $3.20 ($ 2011 PPP) poverty line by out-of-pocket health care expenditure (%)	Proportion of population pushed below the $3.20 ($2011 PPP) poverty line by out-of-pocket health care expenditure. This indicator shows the fraction of a country's households experiencing impoverishing expenditures, defined as expenditures without which the household would have been above the $3.20 poverty line, but because of the expenditures is below the poverty line. Statistical concept and methodology: Out-of-pocket payments are those made by people at the time of getting any type of service (preventive, curative, rehabilitative, palliative or long-term care) provided by any type of provider. They include cost-sharing (the part not covered by a third party like an insurer) and informal payments, but they exclude insurance premiums. Out-of-pocket payments exclude any reimbursement by a third party, such as the government, a health insurance fund or a private insurance company. Out-of-pocket payments are impoverishing at the $3.10 PL (PPP) for a household when consumption gross of out-of-pocket payments is higher than the $3.10 PL, but consumption net of out-of-pocket payments is lower than the 3.10 PL.	2021-08-10 01:59:12	2023-06-15 05:05:42	SH.UHC.NOP2.ZS	2000-2015	World Development Indicators - World Bank (2021.07.30) 5357	World Health Organization and World Bank 18847	{}	{}	1
158421	Proportion of population pushed below the $1.90 ($ 2011 PPP) poverty line by out-of-pocket health care expenditure (%)	Proportion of population pushed below the $1.90 ($ 2011 PPP) poverty line by out-of-pocket health care expenditure. This indicator shows the fraction of a country's households experiencing impoverishing expenditures, defined as expenditures without which the household would have been above the $ 1.90 poverty line, but because of the expenditures is below the poverty line. Statistical concept and methodology: Out-of-pocket payments are those made by people at the time of getting any type of service (preventive, curative, rehabilitative, palliative or long-term care) provided by any type of provider. They include cost-sharing (the part not covered by a third party like an insurer) and informal payments, but they exclude insurance premiums. Out-of-pocket payments exclude any reimbursement by a third party, such as the government, a health insurance fund or a private insurance company. Out-of-pocket payments are impoverishing at the $1.90 PL (PPP) for a household when consumption gross of out-of-pocket payments is higher than the $1.90 PL, but consumption net of out-of-pocket payments is lower than the 1.90 PL.	2021-08-10 01:59:12	2023-06-15 05:05:42	SH.UHC.NOP1.ZS	1985-2018	World Development Indicators - World Bank (2021.07.30) 5357	World Health Organization and World Bank 18847	{}	{}	1
158209	Number of people spending more than 25% of household consumption or income on out-of-pocket health care expenditure	Number of people spending more than 25% of household consumption or income on out-of-pocket health care expenditure Statistical concept and methodology: Out-of-pocket payments are those made by people at the time of getting any type of service (preventive, curative, rehabilitative, palliative or long-term care) provided by any type of provider. They include cost-sharing (the part not covered by a third party like an insurer) and informal payments, but they exclude insurance premiums. Out-of-pocket payments exclude any reimbursement by a third party, such as the government, a health insurance fund or a private insurance company. Out-of-pocket payments are defined as catastrophic at the 25% threshold when they represent 25% or more of total consumption or income.	2021-08-10 01:59:10	2023-06-15 05:05:42	SH.UHC.OOPC.25.TO	2000-2015	World Development Indicators - World Bank (2021.07.30) 5357	World Health Organization and World Bank 18847	{}	{}	1
158208	Number of people spending more than 10% of household consumption or income on out-of-pocket health care expenditure	Number of people spending more than 10% of household consumption or income on out-of-pocket health care expenditure Statistical concept and methodology: Out-of-pocket payments are those made by people at the time of getting any type of service (preventive, curative, rehabilitative, palliative or long-term care) provided by any type of provider. They include cost-sharing (the part not covered by a third party like an insurer) and informal payments, but they exclude insurance premiums. Out-of-pocket payments exclude any reimbursement by a third party, such as the government, a health insurance fund or a private insurance company. Out-of-pocket payments are defined as catastrophic at the 10% threshold when they represent 10% or more of total consumption or income.	2021-08-10 01:59:10	2023-06-15 05:05:42	SH.UHC.OOPC.10.TO	2000-2015	World Development Indicators - World Bank (2021.07.30) 5357	World Health Organization and World Bank 18847	{}	{}	1
158207	Number of people pushed below the $3.20 ($ 2011 PPP) poverty line by out-of-pocket health care expenditure	Number of people pushed below the $3.20 ($ 2011 PPP) poverty line by out-of-pocket health care expenditure. This indicator shows the number of households experiencing impoverishing expenditures, defined as expenditures without which the household would have been above the $1.90 poverty line, but because of the expenditures is below the poverty line. Statistical concept and methodology: Out-of-pocket payments are those made by people at the time of getting any type of service (preventive, curative, rehabilitative, palliative or long-term care) provided by any type of provider. They include cost-sharing (the part not covered by a third party like an insurer) and informal payments, but they exclude insurance premiums. Out-of-pocket payments exclude any reimbursement by a third party, such as the government, a health insurance fund or a private insurance company. Out-of-pocket payments are impoverishing at the $3.10 PL (PPP) for a household when consumption gross of out-of-pocket payments is higher than the $3.10 PL, but consumption net of out-of-pocket payments is lower than the 3.10 PL.	2021-08-10 01:59:10	2023-06-15 05:05:42	SH.UHC.NOP2.TO	2000-2015	World Development Indicators - World Bank (2021.07.30) 5357	World Health Organization and World Bank 18847	{}	{}	1
158206	Number of people pushed below the $1.90 ($ 2011 PPP) poverty line by out-of-pocket health care expenditure	Number of people pushed below the $1.90 ($ 2011 PPP) poverty line by out-of-pocket health care expenditure. This indicator shows the number of households experiencing impoverishing expenditures, defined as expenditures without which the household would have been above the $1.90 poverty line, but because of the expenditures is below the poverty line. Statistical concept and methodology: Out-of-pocket payments are those made by people at the time of getting any type of service (preventive, curative, rehabilitative, palliative or long-term care) provided by any type of provider. They include cost-sharing (the part not covered by a third party like an insurer) and informal payments, but they exclude insurance premiums. Out-of-pocket payments exclude any reimbursement by a third party, such as the government, a health insurance fund or a private insurance company. Out-of-pocket payments are impoverishing at the $1.90 PL (PPP) for a household when consumption gross of out-of-pocket payments is higher than the $1.90 PL, but consumption net of out-of-pocket payments is lower than the 1.90 PL.	2021-08-10 01:59:10	2023-06-15 05:05:42	SH.UHC.NOP1.TO	2000-2015	World Development Indicators - World Bank (2021.07.30) 5357	World Health Organization and World Bank 18847	{}	{}	1
157896	Increase in poverty gap at $3.20 ($ 2011 PPP) poverty line due to out-of-pocket health care expenditure (USD)	Increase in poverty gap at $3.20 ($ 2011 PPP) poverty line due to out-of-pocket health care expenditure, expressed in US dollars (2011 PPP). The poverty gap increase due to out-of-pocket health spending is one way to measure how much out-of-pocket health spending pushes people below or further below the poverty line (the difference in the poverty gap due to out-of-pocket health spending being included or excluded from the measure of household welfare). This difference corresponds to the total out-of-pocket health spending for households that are already below the poverty line, to the amount that exceeds the shortfall between the poverty line and total consumption for households that are impoverished by out-of-pocket health spending and to zero for households whose consumption is above the poverty line after accounting for out-of-pocket health spending. Statistical concept and methodology: Out-of-pocket payments are those made by people at the time of getting any type of service (preventive, curative, rehabilitative, palliative or long-term care) provided by any type of provider. They include cost-sharing (the part not covered by a third party like an insurer) and informal payments, but they exclude insurance premiums. Out-of-pocket payments exclude any reimbursement by a third party, such as the government, a health insurance fund or a private insurance company. This series measures the poverty gap increase attributable to OOP health expenditures. This amount can be interpreted as the per capita amount by which on average OOP spending pushes or further pushes the household below the PL. It is defined as the difference between the poverty gap based on a measure of consumption net of OOP health expenditures and a measure of consumption gross of OOP health expenditures. The difference is expressed in 2011 PPP international dollar.	2021-08-10 01:59:07	2023-06-15 05:05:42	SH.UHC.NOP2.CG	1985-2018	World Development Indicators - World Bank (2021.07.30) 5357	World Health Organization and World Bank 18847	{}	{}	1
157895	Increase in poverty gap at $3.20 ($ 2011 PPP) poverty line due to out-of-pocket health care expenditure (% of poverty line)	Increase in poverty gap at $3.20 ($ 2011 PPP) poverty line due to out-of-pocket health care expenditure, as a percentage of the $3.20 poverty line. The poverty gap increase due to out-of-pocket health spending is one way to measure how much out-of-pocket health spending pushes people below or further below the poverty line (the difference in the poverty gap due to out-of-pocket health spending being included or excluded from the measure of household welfare). This difference corresponds to the total out-of-pocket health spending for households that are already below the poverty line, to the amount that exceeds the shortfall between the poverty line and total consumption for households that are impoverished by out-of-pocket health spending and to zero for households whose consumption is above the poverty line after accounting for out-of-pocket health spending. Statistical concept and methodology: Out-of-pocket payments are those made by people at the time of getting any type of service (preventive, curative, rehabilitative, palliative or long-term care) provided by any type of provider. They include cost-sharing (the part not covered by a third party like an insurer) and informal payments, but they exclude insurance premiums. Out-of-pocket payments exclude any reimbursement by a third party, such as the government, a health insurance fund or a private insurance company. This series measures the poverty gap increase attributable to OOP health expenditures. This amount can be interpreted as the per capita amount by which on average OOP spending pushes or further pushes the household below the PL. It is defined as the difference between the poverty gap based on a measure of consumption net of OOP health expenditures and a measure of consumption gross of OOP health expenditures. The difference is expressed as a percentage of the PL.	2021-08-10 01:59:07	2023-06-15 05:05:42	SH.UHC.NOP2.ZG	1985-2018	World Development Indicators - World Bank (2021.07.30) 5357	World Health Organization and World Bank 18847	{}	{}	1
157894	Increase in poverty gap at $1.90 ($ 2011 PPP) poverty line due to out-of-pocket health care expenditure (USD)	Increase in poverty gap at $1.90 ($ 2011 PPP) poverty line due to out-of-pocket health care expenditure, expressed in US dollars (2011 PPP). The poverty gap increase due to out-of-pocket health spending is one way to measure how much out-of-pocket health spending pushes people below or further below the poverty line (the difference in the poverty gap due to out-of-pocket health spending being included or excluded from the measure of household welfare). This difference corresponds to the total out-of-pocket health spending for households that are already below the poverty line, to the amount that exceeds the shortfall between the poverty line and total consumption for households that are impoverished by out-of-pocket health spending and to zero for households whose consumption is above the poverty line after accounting for out-of-pocket health spending. Statistical concept and methodology: Out-of-pocket payments are those made by people at the time of getting any type of service (preventive, curative, rehabilitative, palliative or long-term care) provided by any type of provider. They include cost-sharing (the part not covered by a third party like an insurer) and informal payments, but they exclude insurance premiums. Out-of-pocket payments exclude any reimbursement by a third party, such as the government, a health insurance fund or a private insurance company. This series measures the poverty gap increase attributable to OOP health expenditures. This amount can be interpreted as the per capita amount by which on average OOP spending pushes or further pushes the household below the PL. It is defined as the difference between the poverty gap based on a measure of consumption net of OOP health expenditures and a measure of consumption gross of OOP health expenditures. The difference is expressed in 2011 PPP international dollar.	2021-08-10 01:59:07	2023-06-15 05:05:42	SH.UHC.NOP1.CG	1985-2018	World Development Indicators - World Bank (2021.07.30) 5357	World Health Organization and World Bank 18847	{}	{}	1
157893	Increase in poverty gap at $1.90 ($ 2011 PPP) poverty line due to out-of-pocket health care expenditure (% of poverty line)	Increase in poverty gap at $1.90 ($ 2011 PPP) poverty line due to out-of-pocket health care expenditure, as a percentage of the $1.90 poverty line. The poverty gap increase due to out-of-pocket health spending is one way to measure how much out-of-pocket health spending pushes people below or further below the poverty line (the difference in the poverty gap due to out-of-pocket health spending being included or excluded from the measure of household welfare). This difference corresponds to the total out-of-pocket health spending for households that are already below the poverty line, to the amount that exceeds the shortfall between the poverty line and total consumption for households that are impoverished by out-of-pocket health spending and to zero for households whose consumption is above the poverty line after accounting for out-of-pocket health spending. Statistical concept and methodology: Out-of-pocket payments are those made by people at the time of getting any type of service (preventive, curative, rehabilitative, palliative or long-term care) provided by any type of provider. They include cost-sharing (the part not covered by a third party like an insurer) and informal payments, but they exclude insurance premiums. Out-of-pocket payments exclude any reimbursement by a third party, such as the government, a health insurance fund or a private insurance company. This series measures the poverty gap increase attributable to OOP health expenditures. This amount can be interpreted as the per capita amount by which on average OOP spending pushes or further pushes the household below the PL. It is defined as the difference between the poverty gap based on a measure of consumption net of OOP health expenditures and a measure of consumption gross of OOP health expenditures. The difference is expressed as a percentage of the PL.	2021-08-10 01:59:07	2023-06-15 05:05:42	SH.UHC.NOP1.ZG	1985-2018	World Development Indicators - World Bank (2021.07.30) 5357	World Health Organization and World Bank 18847	{}	{}	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");