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

26 rows where sourceId = 27023 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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
525247 $10-$30 - number between poverty lines   Number of people living in households between $10 and $30 a day. The sharp increase in the number of people in poverty in Sub-Saharan Africa in 1950 is due the inclusion of several countries only from that year onward. 2022-09-08 23:32:38 2023-06-15 05:05:42       Global extreme poverty: Present and past since 1820 (Moatsos in OECD, 2021) 5756 Moatsos (2021) 27023   
{
    "includeInTable": true,
    "numDecimalPlaces": 0,
    "entityAnnotationsMap": "Sub-Saharan Africa: Several countries added to the Sub-Saharan Africa data from 1950 onwards"
}
 0           1                                  
525246 $5-$10 - number between poverty lines   Number of people living in households between $5 and $10 a day. The sharp increase in the number of people in poverty in Sub-Saharan Africa in 1950 is due the inclusion of several countries only from that year onward. 2022-09-08 23:32:38 2023-06-15 05:05:42       Global extreme poverty: Present and past since 1820 (Moatsos in OECD, 2021) 5756 Moatsos (2021) 27023   
{
    "includeInTable": true,
    "numDecimalPlaces": 0,
    "entityAnnotationsMap": "Sub-Saharan Africa: Several countries added to the Sub-Saharan Africa data from 1950 onwards"
}
 0           1                                  
525245 $1.90-$5 - number between poverty lines   Number of people living in households between $1.90 and $5 a day. The sharp increase in the number of people in poverty in Sub-Saharan Africa in 1950 is due the inclusion of several countries only from that year onward. 2022-09-08 23:32:38 2023-06-15 05:05:42       Global extreme poverty: Present and past since 1820 (Moatsos in OECD, 2021) 5756 Moatsos (2021) 27023   
{
    "includeInTable": true,
    "numDecimalPlaces": 0,
    "entityAnnotationsMap": "Sub-Saharan Africa: Several countries added to the Sub-Saharan Africa data from 1950 onwards"
}
 0           1                                  
525244 $30 - number above poverty line   Number of people living in households above $30 a day. The sharp increase in the number of people in poverty in Sub-Saharan Africa in 1950 is due the inclusion of several countries only from that year onward. 2022-09-08 23:32:38 2023-06-15 05:05:42       Global extreme poverty: Present and past since 1820 (Moatsos in OECD, 2021) 5756 Moatsos (2021) 27023   
{
    "includeInTable": true,
    "numDecimalPlaces": 0,
    "entityAnnotationsMap": "Sub-Saharan Africa: Several countries added to the Sub-Saharan Africa data from 1950 onwards"
}
 0           1                                  
525243 $10 - number above poverty line   Number of people living in households above $10 a day. The sharp increase in the number of people in poverty in Sub-Saharan Africa in 1950 is due the inclusion of several countries only from that year onward. 2022-09-08 23:32:38 2023-06-15 05:05:42       Global extreme poverty: Present and past since 1820 (Moatsos in OECD, 2021) 5756 Moatsos (2021) 27023   
{
    "includeInTable": true,
    "numDecimalPlaces": 0,
    "entityAnnotationsMap": "Sub-Saharan Africa: Several countries added to the Sub-Saharan Africa data from 1950 onwards"
}
 0           1                                  
525242 $5 - number above poverty line   Number of people living in households above $5 a day. The sharp increase in the number of people in poverty in Sub-Saharan Africa in 1950 is due the inclusion of several countries only from that year onward. 2022-09-08 23:32:38 2023-06-15 05:05:42       Global extreme poverty: Present and past since 1820 (Moatsos in OECD, 2021) 5756 Moatsos (2021) 27023   
{
    "includeInTable": true,
    "numDecimalPlaces": 0,
    "entityAnnotationsMap": "Sub-Saharan Africa: Several countries added to the Sub-Saharan Africa data from 1950 onwards"
}
 0           1                                  
525241 $1.90 - number above poverty line   Number of people living in households above $1.90 a day. The sharp increase in the number of people in poverty in Sub-Saharan Africa in 1950 is due the inclusion of several countries only from that year onward. 2022-09-08 23:32:38 2023-06-15 05:05:42       Global extreme poverty: Present and past since 1820 (Moatsos in OECD, 2021) 5756 Moatsos (2021) 27023   
{
    "includeInTable": true,
    "numDecimalPlaces": 0,
    "entityAnnotationsMap": "Sub-Saharan Africa: Several countries added to the Sub-Saharan Africa data from 1950 onwards"
}
 0           1                                  
525240 ‘cost of basic needs’ approach - number above poverty line   Number of people that was able to meet basic needs (including minimal nutrition and adequately heated shelter) according to prices of locally-available goods and services at the time. Moatsos describes the methodology as follows: “In this approach, poverty lines are calculated for every year and country separately, rather than using a single global line. The second step is to gather the necessary data to operationalise this approach, alongside imputation methods in cases where not all the necessary data are available. The third step is to devise a method for aggregating countries’ poverty estimates on a global scale to account for countries that lack some of the relevant data.” In his publication – linked above – you find much more detail on all of the shown poverty data. The sharp increase in the number of people in poverty in Sub-Saharan Africa in 1950 is due the inclusion of several countries only from that year onward. 2022-09-08 23:32:38 2023-06-15 05:05:42       Global extreme poverty: Present and past since 1820 (Moatsos in OECD, 2021) 5756 Moatsos (2021) 27023   
{
    "includeInTable": true,
    "numDecimalPlaces": 0,
    "entityAnnotationsMap": "Sub-Saharan Africa: Several countries added to the Sub-Saharan Africa data from 1950 onwards"
}
 0           1                                  
525239 $30 - number below poverty line   Number of people living in households below $30 a day. The sharp increase in the number of people in poverty in Sub-Saharan Africa in 1950 is due the inclusion of several countries only from that year onward. 2022-09-08 23:32:38 2023-06-15 05:05:42       Global extreme poverty: Present and past since 1820 (Moatsos in OECD, 2021) 5756 Moatsos (2021) 27023   
{
    "includeInTable": true,
    "numDecimalPlaces": 0,
    "entityAnnotationsMap": "Sub-Saharan Africa: Several countries added to the Sub-Saharan Africa data from 1950 onwards"
}
 0           1                                  
525238 $10 - number below poverty line   Number of people living in households below $10 a day. The sharp increase in the number of people in poverty in Sub-Saharan Africa in 1950 is due the inclusion of several countries only from that year onward. 2022-09-08 23:32:38 2023-06-15 05:05:42       Global extreme poverty: Present and past since 1820 (Moatsos in OECD, 2021) 5756 Moatsos (2021) 27023   
{
    "unit": "",
    "includeInTable": true,
    "numDecimalPlaces": 0,
    "entityAnnotationsMap": "Sub-Saharan Africa: Several countries added to the Sub-Saharan Africa data from 1950 onwards"
}
 0           1                                  
525237 $5 - number below poverty line   Number of people living in households below $5 a day. The sharp increase in the number of people in poverty in Sub-Saharan Africa in 1950 is due the inclusion of several countries only from that year onward. 2022-09-08 23:32:38 2023-06-15 05:05:42       Global extreme poverty: Present and past since 1820 (Moatsos in OECD, 2021) 5756 Moatsos (2021) 27023   
{
    "includeInTable": true,
    "numDecimalPlaces": 0,
    "entityAnnotationsMap": "Sub-Saharan Africa: Several countries added to the Sub-Saharan Africa data from 1950 onwards"
}
 0           1                                  
525236 $1.90 - number below poverty line   Number of people living in households below $1.90 a day. The sharp increase in the number of people in poverty in Sub-Saharan Africa in 1950 is due the inclusion of several countries only from that year onward. 2022-09-08 23:32:38 2023-06-15 05:05:42       Global extreme poverty: Present and past since 1820 (Moatsos in OECD, 2021) 5756 Moatsos (2021) 27023   
{
    "includeInTable": true,
    "numDecimalPlaces": 0,
    "entityAnnotationsMap": "Sub-Saharan Africa: Several countries added to the Sub-Saharan Africa data from 1950 onwards"
}
 0           1                                  
525235 ‘cost of basic needs’ approach - number below poverty line   Number of people that was unable to meet basic needs (including minimal nutrition and adequately heated shelter) according to prices of locally-available goods and services at the time. Moatsos describes the methodology as follows: “In this approach, poverty lines are calculated for every year and country separately, rather than using a single global line. The second step is to gather the necessary data to operationalise this approach, alongside imputation methods in cases where not all the necessary data are available. The third step is to devise a method for aggregating countries’ poverty estimates on a global scale to account for countries that lack some of the relevant data.” In his publication – linked above – you find much more detail on all of the shown poverty data. The sharp increase in the number of people in poverty in Sub-Saharan Africa in 1950 is due the inclusion of several countries only from that year onward. 2022-09-08 23:32:38 2023-06-15 05:05:42       Global extreme poverty: Present and past since 1820 (Moatsos in OECD, 2021) 5756 Moatsos (2021) 27023   
{
    "includeInTable": true,
    "numDecimalPlaces": 0,
    "entityAnnotationsMap": "Sub-Saharan Africa: Several countries added to the Sub-Saharan Africa data from 1950 onwards"
}
 0           1                                  
524227 $10-$30 - share of population between poverty lines   % of population living in households between $10 and $30 a day 2022-09-02 19:43:45 2023-06-15 05:05:42       Global extreme poverty: Present and past since 1820 (Moatsos in OECD, 2021) 5756 Moatsos (2021) 27023   
{
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
524226 $5-$10 - share of population between poverty lines   % of population living in households between $5 and $10 a day 2022-09-02 19:43:45 2023-06-15 05:05:42       Global extreme poverty: Present and past since 1820 (Moatsos in OECD, 2021) 5756 Moatsos (2021) 27023   
{
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
524225 $1.90-$5 - share of population between poverty lines   % of population living in households between $1.90 and $5 a day 2022-09-02 19:43:45 2023-06-15 05:05:42       Global extreme poverty: Present and past since 1820 (Moatsos in OECD, 2021) 5756 Moatsos (2021) 27023   
{
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
524224 $30 - share of population above poverty line   % of population living in households above $30 a day 2022-09-02 19:43:45 2023-06-15 05:05:42       Global extreme poverty: Present and past since 1820 (Moatsos in OECD, 2021) 5756 Moatsos (2021) 27023   
{
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
524223 $10 - share of population above poverty line   % of population living in households above $10 a day 2022-09-02 19:43:45 2023-06-15 05:05:42       Global extreme poverty: Present and past since 1820 (Moatsos in OECD, 2021) 5756 Moatsos (2021) 27023   
{
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
524222 $5 - share of population above poverty line   % of population living in households above $5 a day 2022-09-02 19:43:45 2023-06-15 05:05:42       Global extreme poverty: Present and past since 1820 (Moatsos in OECD, 2021) 5756 Moatsos (2021) 27023   
{
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
524221 $1.90 - share of population above poverty line   % of population living in households above $1.90 a day 2022-09-02 19:43:45 2023-06-15 05:05:42       Global extreme poverty: Present and past since 1820 (Moatsos in OECD, 2021) 5756 Moatsos (2021) 27023   
{
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
524220 ‘cost of basic needs’ approach - share of population above poverty line   Share of the population that was able to meet basic needs (including minimal nutrition and adequately heated shelter) according to prices of locally-available goods and services at the time. Moatsos describes the methodology as follows: “In this approach, poverty lines are calculated for every year and country separately, rather than using a single global line. The second step is to gather the necessary data to operationalise this approach, alongside imputation methods in cases where not all the necessary data are available. The third step is to devise a method for aggregating countries’ poverty estimates on a global scale to account for countries that lack some of the relevant data.” In his publication – linked above – you find much more detail on all of the shown poverty data. 2022-09-02 19:43:45 2023-06-15 05:05:42       Global extreme poverty: Present and past since 1820 (Moatsos in OECD, 2021) 5756 Moatsos (2021) 27023   
{
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
524219 $30 - share of population below poverty line   % of population living in households below $30 a day 2022-09-02 16:50:48 2023-06-15 05:05:42       Global extreme poverty: Present and past since 1820 (Moatsos in OECD, 2021) 5756 Moatsos (2021) 27023   
{
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
524218 $10 - share of population below poverty line   % of population living in households below $10 a day 2022-09-02 16:50:48 2023-06-15 05:05:42       Global extreme poverty: Present and past since 1820 (Moatsos in OECD, 2021) 5756 Moatsos (2021) 27023   
{
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
524217 $5 - share of population below poverty line   % of population living in households below $5 a day 2022-09-02 16:50:48 2023-06-15 05:05:42       Global extreme poverty: Present and past since 1820 (Moatsos in OECD, 2021) 5756 Moatsos (2021) 27023   
{
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
524216 $1.90 - share of population below poverty line   % of population living in households below $1.90 a day 2022-09-02 16:50:48 2023-06-15 05:05:42       Global extreme poverty: Present and past since 1820 (Moatsos in OECD, 2021) 5756 Moatsos (2021) 27023   
{
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
524215 ‘cost of basic needs’ approach - share of population below poverty line   Share of the population that was unable to meet basic needs (including minimal nutrition and adequately heated shelter) according to prices of locally-available goods and services at the time. Moatsos describes the methodology as follows: “In this approach, poverty lines are calculated for every year and country separately, rather than using a single global line. The second step is to gather the necessary data to operationalise this approach, alongside imputation methods in cases where not all the necessary data are available. The third step is to devise a method for aggregating countries’ poverty estimates on a global scale to account for countries that lack some of the relevant data.” In his publication – linked above – you find much more detail on all of the shown poverty data. 2022-09-02 16:50:48 2023-06-15 05:05:42       Global extreme poverty: Present and past since 1820 (Moatsos in OECD, 2021) 5756 Moatsos (2021) 27023   
{
    "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");