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

89 rows where datasetId = 5689 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: createdAt, updatedAt, 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
526860 $24.35 - share of population above poverty line     2022-09-29 11:30:33 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{}
 0           1                                  
526859 $24.35 - total number of people above poverty line     2022-09-29 11:30:33 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{}
 0           1                                  
526858 $24.35 a day - total shortfall     2022-09-29 11:30:33 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{}
 0           1                                  
526857 $24.35 a day - poverty gap index     2022-09-29 11:30:33 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{}
 0           1                                  
526856 $24.35 a day - share of population below poverty line     2022-09-29 11:30:33 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{}
 0           1                                  
526855 $24.35 - total number of people below poverty line     2022-09-29 11:30:33 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{}
 0           1                                  
525721 Share of the richest decile in total income or expenditure   The income or expenditure of the richest decile (tenth of the population) as a share of total income or expenditure. 2022-09-20 16:58:31 2023-06-30 09:21:45       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true,
    "numDecimalPlaces": 1
}
 0           1                                  
525720 Share of the richest quintile in total income or expenditure   The income or expenditure of the richest quintile (fifth of the population) as a share of total income or expenditure. 2022-09-20 16:54:31 2023-06-29 17:56:04       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true,
    "numDecimalPlaces": 1
}
 0           1                                  
525719 Share of the 4th quintile in total income or expenditure   The income or expenditure of the 4th quintile (fifth of the population) as a share of total income or expenditure. 2022-09-20 16:54:31 2023-06-29 17:56:08       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true,
    "numDecimalPlaces": 1
}
 0           1                                  
525718 Share of the 3rd quintile in total income or expenditure   The income or expenditure of the 3rd quintile (fifth of the population) as a share of total income or expenditure. 2022-09-20 16:54:31 2023-06-29 17:56:11       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true,
    "numDecimalPlaces": 1
}
 0           1                                  
525717 Share of the 2nd quintile in total income or expenditure   The income or expenditure of the 2nd quintile (fifth of the population) as a share of total income or expenditure. 2022-09-20 16:54:31 2023-06-29 17:56:14       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true,
    "numDecimalPlaces": 1
}
 0           1                                  
525716 Share of the poorest quintile in total income or expenditure   The income or expenditure of the poorest quintile (fifth of the population) as a share of total income or expenditure. 2022-09-20 16:54:31 2023-06-29 17:56:20       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true,
    "numDecimalPlaces": 1
}
 0           1                                  
521035 $10-$30 - share of population between poverty lines   % of population living in households with an income or expenditure per person between $10 and $30 a day 2022-09-01 12:08:15 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "includeInTable": true
}
 0           1                                  
521034 $2.15-$10 - share of population between poverty lines   % of population living in households with an income or expenditure per person between $2.15 and $10 a day 2022-09-01 12:08:15 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "includeInTable": true
}
 0           1                                  
521033 $10-$30 - total number of people between poverty lines   Number of people living in households with an income or expenditure per person between $10 and $30 a day 2022-09-01 12:08:15 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
521032 $2.15-$10 - total number of people between poverty lines   Number of people living in households with an income or expenditure per person between $2.15 and $10 a day 2022-09-01 12:08:15 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
514081 $30-$40 - share of population between poverty lines   % of population living in households with an income or expenditure per person between $30 and $40 a day 2022-08-26 14:28:02 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
514080 $20-$30 - share of population between poverty lines   % of population living in households with an income or expenditure per person between $20 and $30 a day 2022-08-26 14:28:02 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
514079 $10-$20 - share of population between poverty lines   % of population living in households with an income or expenditure per person between $10 and $20 a day 2022-08-26 14:28:02 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
514078 $6.85-$10 - share of population between poverty lines   % of population living in households with an income or expenditure per person between $6.85 and $10 a day 2022-08-26 14:28:02 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
514077 $3.65-$6.85 - share of population between poverty lines   % of population living in households with an income or expenditure per person between $3.65 and $6.85 a day 2022-08-26 14:28:02 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
514076 $2.15-$3.65 - share of population between poverty lines   % of population living in households with an income or expenditure per person between $2.15 and $3.65 a day 2022-08-26 14:28:02 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
514075 $1-$2.15 - share of population between poverty lines   % of population living in households with an income or expenditure per person between $1 and $2.15 a day 2022-08-26 14:28:02 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
514072 $30-$40 - total number of people between poverty lines   Number of people living in households with an income or expenditure per person between $30 and $40 a day 2022-08-26 14:28:02 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
514071 $20-$30 - total number of people between poverty lines   Number of people living in households with an income or expenditure per person between $20 and $30 a day 2022-08-26 14:28:02 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
514070 $10-$20 - total number of people between poverty lines   Number of people living in households with an income or expenditure per person between $10 and $20 a day 2022-08-26 14:28:02 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
514069 $6.85-$10 - total number of people between poverty lines   Number of people living in households with an income or expenditure per person between $6.85 and $10 a day 2022-08-26 14:28:02 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
514068 $3.65-$6.85 - total number of people between poverty lines   Number of people living in households with an income or expenditure per person between $3.65 and $6.85 a day 2022-08-26 14:28:02 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
514067 $2.15-$3.65 - total number of people between poverty lines   Number of people living in households with an income or expenditure per person between $2.15 and $3.65 a day 2022-08-26 14:28:02 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
514066 $1-$2.15 - total number of people between poverty lines   Number of people living in households with an income or expenditure per person between $1 and $2.15 a day 2022-08-26 14:28:02 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
514064 $40 - share of population above poverty line   % of population living in households with an income or expenditure per person above $40 a day 2022-08-26 14:28:02 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
514063 $30 - share of population above poverty line   % of population living in households with an income or expenditure per person above $30 a day 2022-08-26 14:28:02 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
514062 $20 - share of population above poverty line   % of population living in households with an income or expenditure per person above $20 a day 2022-08-26 14:28:02 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
514061 $10 - share of population above poverty line   % of population living in households with an income or expenditure per person above $10 a day 2022-08-26 14:28:02 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
514060 $6.85 - share of population above poverty line   % of population living in households with an income or expenditure per person above $6.85 a day 2022-08-26 14:28:02 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
514059 $3.65 - share of population above poverty line   % of population living in households with an income or expenditure per person above $3.65 a day 2022-08-26 14:28:02 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
514058 $2.15 - share of population above poverty line   % of population living in households with an income or expenditure per person above $2.15 a day 2022-08-26 14:28:02 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
514057 $1 - share of population above poverty line   % of population living in households with an income or expenditure per person above $1 a day 2022-08-26 14:28:02 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
514056 $40 - total number of people above poverty line   Number of people living in households with an income or expenditure per person above $40 a day 2022-08-26 14:28:02 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
514055 $30 - total number of people above poverty line   Number of people living in households with an income or expenditure per person above $30 a day 2022-08-26 14:28:02 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
514054 $20 - total number of people above poverty line   Number of people living in households with an income or expenditure per person above $20 a day 2022-08-26 14:28:02 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
514053 $10 - total number of people above poverty line   Number of people living in households with an income or expenditure per person above $10 a day 2022-08-26 14:28:02 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
514052 $6.85 - total number of people above poverty line   Number of people living in households with an income or expenditure per person above $6.85 a day 2022-08-26 14:28:02 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
514051 $3.65 - total number of people above poverty line   Number of people living in households with an income or expenditure per person above $3.65 a day 2022-08-26 14:28:02 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
514050 $2.15 - total number of people above poverty line   Number of people living in households with an income or expenditure per person above $2.15 a day 2022-08-26 14:28:02 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
514049 $1 - total number of people above poverty line   Number of people living in households with an income or expenditure per person above $1 a day 2022-08-26 14:28:02 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
514048 $40 a day - total shortfall   The total shortfall from a poverty line of $40 a day. This is the amount of money that would be theoretically needed to lift the income or expenditure of all people in poverty up to the poverty line. However this is not a measure of the actual cost of eliminating poverty, since it does not take into account the costs involved in making the necessary transfers nor any changes in behaviour they would bring about. 2022-08-26 14:28:02 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "unit": "international-$ at 2017 prices",
    "shortUnit": "$",
    "includeInTable": true
}
 0           1                                  
514047 $30 a day - total shortfall   The total shortfall from a poverty line of $30 a day. This is the amount of money that would be theoretically needed to lift the income or expenditure of all people in poverty up to the poverty line. However this is not a measure of the actual cost of eliminating poverty, since it does not take into account the costs involved in making the necessary transfers nor any changes in behaviour they would bring about. 2022-08-26 14:28:02 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "unit": "international-$ at 2017 prices",
    "shortUnit": "$",
    "includeInTable": true
}
 0           1                                  
514046 $20 a day - total shortfall   The total shortfall from a poverty line of $20 a day. This is the amount of money that would be theoretically needed to lift the income or expenditure of all people in poverty up to the poverty line. However this is not a measure of the actual cost of eliminating poverty, since it does not take into account the costs involved in making the necessary transfers nor any changes in behaviour they would bring about. 2022-08-26 14:28:02 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "unit": "international-$ at 2017 prices",
    "shortUnit": "$",
    "includeInTable": true
}
 0           1                                  
514045 $10 a day - total shortfall   The total shortfall from a poverty line of $10 a day. This is the amount of money that would be theoretically needed to lift the income or expenditure of all people in poverty up to the poverty line. However this is not a measure of the actual cost of eliminating poverty, since it does not take into account the costs involved in making the necessary transfers nor any changes in behaviour they would bring about. 2022-08-26 14:28:02 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "unit": "international-$ at 2017 prices",
    "shortUnit": "$",
    "includeInTable": true
}
 0           1                                  
514044 $6.85 a day - total shortfall   The total shortfall from a poverty line of $6.85 a day. This is the amount of money that would be theoretically needed to lift the income or expenditure of all people in poverty up to the poverty line. However this is not a measure of the actual cost of eliminating poverty, since it does not take into account the costs involved in making the necessary transfers nor any changes in behaviour they would bring about. 2022-08-26 14:28:02 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "unit": "international-$ at 2017 prices",
    "shortUnit": "$",
    "includeInTable": true
}
 0           1                                  
514043 $3.65 a day - total shortfall   The total shortfall from a poverty line of $3.65 a day. This is the amount of money that would be theoretically needed to lift the income or expenditure of all people in poverty up to the poverty line. However this is not a measure of the actual cost of eliminating poverty, since it does not take into account the costs involved in making the necessary transfers nor any changes in behaviour they would bring about. 2022-08-26 14:28:02 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "unit": "international-$ at 2017 prices",
    "shortUnit": "$",
    "includeInTable": true
}
 0           1                                  
514042 $2.15 a day - total shortfall   The total shortfall from a poverty line of $2.15 a day. This is the amount of money that would be theoretically needed to lift the income or expenditure of all people in poverty up to the poverty line. However this is not a measure of the actual cost of eliminating poverty, since it does not take into account the costs involved in making the necessary transfers nor any changes in behaviour they would bring about. We calculate the total annual shortfall from the poverty line ('poverty gap') from estimates of the poverty gap index produced by the World Bank using the following formula: Total annual poverty gap = Poverty gap index x total population (including both poor and non-poor) x $2.15 x 365. 2022-08-26 14:28:02 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "unit": "international-$ at 2017 prices",
    "shortUnit": "$",
    "includeInTable": true
}
 0           1                                  
514041 $1 a day - total shortfall   The total shortfall from a poverty line of $1 a day. This is the amount of money that would be theoretically needed to lift the income or expenditure of all people in poverty up to the poverty line. However this is not a measure of the actual cost of eliminating poverty, since it does not take into account the costs involved in making the necessary transfers nor any changes in behaviour they would bring about. 2022-08-26 14:28:02 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "unit": "international-$ at 2017 prices",
    "shortUnit": "$",
    "includeInTable": true
}
 0           1                                  
472296 Gini coefficient   The Gini coefficient measures inequality on a scale between 0 and 1, where higher values indicate greater inequality. 2022-08-23 12:30:49 2023-07-05 13:59:53       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "unit": "",
    "includeInTable": true,
    "numDecimalPlaces": 2
}
 0           1                                  
472295 P90   The level of income or expenditure per day below which 90% of the population falls. 2022-08-23 12:30:49 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "unit": "international-$ at 2017 prices",
    "shortUnit": "$",
    "includeInTable": true
}
 0           1                                  
472294 P10   The level of income or expenditure per day below which 10% of the population falls. 2022-08-23 12:30:49 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "unit": "international-$ at 2017 prices",
    "shortUnit": "$",
    "includeInTable": true
}
 0           1                                  
472293 60% of median - share of population below poverty line   % of population living in households with an income or expenditure per person below 60% of the median 2022-08-23 12:30:49 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
472292 50% of median - share of population below poverty line   % of population living in households with an income or expenditure per person below 50% of the median 2022-08-23 12:30:49 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
472291 40% of median - share of population below poverty line   % of population living in households with an income or expenditure per person below 40% of the median 2022-08-23 12:30:49 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
472290 60% of median - total number of people below poverty line   Number of people living in households with an income or expenditure per person below 60% of the median 2022-08-23 12:30:49 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
472289 50% of median - total number of people below poverty line   Number of people living in households with an income or expenditure per person below 50% of the median 2022-08-23 12:30:49 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
472288 40% of median - total number of people below poverty line   Number of people living in households with an income or expenditure per person below 40% of the median 2022-08-23 12:30:49 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
472287 $40 a day - poverty gap index   The poverty gap index calculated at a poverty line of $30 a day. The poverty gap index is a measure that reflects both the depth and prevalence of poverty. It is defined as the mean shortfall of the total population from the poverty line counting the non-poor as having zero shortfall and expressed as a percentage of the poverty line. It is worth unpacking that definition a little. For those below the poverty line, the shortfall corresponds to the amount of money required in order to reach the poverty line. For those at or above the poverty line, the shortfall is counted as zero. The average shortfall is then calculated across the total population – both poor and non-poor – and then expressed as a share of the poverty line. Unlike the more commonly-used metric of the headcount ratio, the poverty gap index is thus sensitive not only to whether a person’s income falls below the poverty line or not, but also by how much – i.e. to the depth of poverty they experience. 2022-08-23 12:30:49 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
472286 $30 a day - poverty gap index   The poverty gap index calculated at a poverty line of $30 a day. The poverty gap index is a measure that reflects both the depth and prevalence of poverty. It is defined as the mean shortfall of the total population from the poverty line counting the non-poor as having zero shortfall and expressed as a percentage of the poverty line. It is worth unpacking that definition a little. For those below the poverty line, the shortfall corresponds to the amount of money required in order to reach the poverty line. For those at or above the poverty line, the shortfall is counted as zero. The average shortfall is then calculated across the total population – both poor and non-poor – and then expressed as a share of the poverty line. Unlike the more commonly-used metric of the headcount ratio, the poverty gap index is thus sensitive not only to whether a person’s income falls below the poverty line or not, but also by how much – i.e. to the depth of poverty they experience. 2022-08-23 12:30:49 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
472285 $20 a day - poverty gap index   The poverty gap index calculated at a poverty line of $20 a day. The poverty gap index is a measure that reflects both the depth and prevalence of poverty. It is defined as the mean shortfall of the total population from the poverty line counting the non-poor as having zero shortfall and expressed as a percentage of the poverty line. It is worth unpacking that definition a little. For those below the poverty line, the shortfall corresponds to the amount of money required in order to reach the poverty line. For those at or above the poverty line, the shortfall is counted as zero. The average shortfall is then calculated across the total population – both poor and non-poor – and then expressed as a share of the poverty line. Unlike the more commonly-used metric of the headcount ratio, the poverty gap index is thus sensitive not only to whether a person’s income falls below the poverty line or not, but also by how much – i.e. to the depth of poverty they experience. 2022-08-23 12:30:49 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
472284 $10 a day - poverty gap index   The poverty gap index calculated at a poverty line of $10 a day. The poverty gap index is a measure that reflects both the depth and prevalence of poverty. It is defined as the mean shortfall of the total population from the poverty line counting the non-poor as having zero shortfall and expressed as a percentage of the poverty line. It is worth unpacking that definition a little. For those below the poverty line, the shortfall corresponds to the amount of money required in order to reach the poverty line. For those at or above the poverty line, the shortfall is counted as zero. The average shortfall is then calculated across the total population – both poor and non-poor – and then expressed as a share of the poverty line. Unlike the more commonly-used metric of the headcount ratio, the poverty gap index is thus sensitive not only to whether a person’s income falls below the poverty line or not, but also by how much – i.e. to the depth of poverty they experience. 2022-08-23 12:30:49 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
472283 $6.85 a day - poverty gap index   The poverty gap index calculated at a poverty line of $6.85 a day. The poverty gap index is a measure that reflects both the depth and prevalence of poverty. It is defined as the mean shortfall of the total population from the poverty line counting the non-poor as having zero shortfall and expressed as a percentage of the poverty line. It is worth unpacking that definition a little. For those below the poverty line, the shortfall corresponds to the amount of money required in order to reach the poverty line. For those at or above the poverty line, the shortfall is counted as zero. The average shortfall is then calculated across the total population – both poor and non-poor – and then expressed as a share of the poverty line. Unlike the more commonly-used metric of the headcount ratio, the poverty gap index is thus sensitive not only to whether a person’s income falls below the poverty line or not, but also by how much – i.e. to the depth of poverty they experience. 2022-08-23 12:30:49 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
472282 $3.65 a day - poverty gap index   The poverty gap index calculated at a poverty line of $3.65 a day. The poverty gap index is a measure that reflects both the depth and prevalence of poverty. It is defined as the mean shortfall of the total population from the poverty line counting the non-poor as having zero shortfall and expressed as a percentage of the poverty line. It is worth unpacking that definition a little. For those below the poverty line, the shortfall corresponds to the amount of money required in order to reach the poverty line. For those at or above the poverty line, the shortfall is counted as zero. The average shortfall is then calculated across the total population – both poor and non-poor – and then expressed as a share of the poverty line. Unlike the more commonly-used metric of the headcount ratio, the poverty gap index is thus sensitive not only to whether a person’s income falls below the poverty line or not, but also by how much – i.e. to the depth of poverty they experience. 2022-08-23 12:30:49 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
472281 $2.15 a day - poverty gap index   The poverty gap index calculated at a poverty line of $2.15 a day. The poverty gap index is a measure that reflects both the depth and prevalence of poverty. It is defined as the mean shortfall of the total population from the poverty line counting the non-poor as having zero shortfall and expressed as a percentage of the poverty line. It is worth unpacking that definition a little. For those below the poverty line, the shortfall corresponds to the amount of money required in order to reach the poverty line. For those at or above the poverty line, the shortfall is counted as zero. The average shortfall is then calculated across the total population – both poor and non-poor – and then expressed as a share of the poverty line. Unlike the more commonly-used metric of the headcount ratio, the poverty gap index is thus sensitive not only to whether a person’s income falls below the poverty line or not, but also by how much – i.e. to the depth of poverty they experience. 2022-08-23 12:30:49 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
472280 $1 a day - poverty gap index   The poverty gap index calculated at a poverty line of $1 a day. The poverty gap index is a measure that reflects both the depth and prevalence of poverty. It is defined as the mean shortfall of the total population from the poverty line counting the non-poor as having zero shortfall and expressed as a percentage of the poverty line. It is worth unpacking that definition a little. For those below the poverty line, the shortfall corresponds to the amount of money required in order to reach the poverty line. For those at or above the poverty line, the shortfall is counted as zero. The average shortfall is then calculated across the total population – both poor and non-poor – and then expressed as a share of the poverty line. Unlike the more commonly-used metric of the headcount ratio, the poverty gap index is thus sensitive not only to whether a person’s income falls below the poverty line or not, but also by how much – i.e. to the depth of poverty they experience. 2022-08-23 12:30:49 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
472279 $40 a day - share of population below poverty line   % of population living in households with an income or expenditure per person below $40 a day 2022-08-23 12:30:49 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
472278 $30 a day - share of population below poverty line   % of population living in households with an income or expenditure per person below $30 a day 2022-08-23 12:30:49 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
472277 $20 a day - share of population below poverty line   % of population living in households with an income or expenditure per person below $20 a day 2022-08-23 12:30:49 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
472276 $10 a day - share of population below poverty line   % of population living in households with an income or expenditure per person below $10 a day 2022-08-23 12:30:49 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
472275 $6.85 a day - share of population below poverty line   % of population living in households with an income or expenditure per person below $6.85 a day 2022-08-23 12:30:49 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
472274 $3.65 a day - share of population below poverty line   % of population living in households with an income or expenditure per person below $3.65 a day 2022-08-23 12:30:49 2023-07-18 08:16:19       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true,
    "numDecimalPlaces": 1
}
 0           1                                  
472273 $2.15 a day - share of population below poverty line   % of population living in households with an income or expenditure per person below $2.15 a day 2022-08-23 12:30:49 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
472272 $1 a day - share of population below poverty line   % of population living in households with an income or expenditure per person below $1 a day 2022-08-23 12:30:49 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
472271 $40 - total number of people below poverty line   Number of people living in households with an income or expenditure per person below $40 a day 2022-08-23 12:30:49 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
472270 $30 - total number of people below poverty line   Number of people living in households with an income or expenditure per person below $30 a day 2022-08-23 12:30:49 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
472269 $20 - total number of people below poverty line   Number of people living in households with an income or expenditure per person below $20 a day 2022-08-23 12:30:49 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
472268 $10 - total number of people below poverty line   Number of people living in households with an income or expenditure per person below $10 a day 2022-08-23 12:30:49 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
472267 $6.85 - total number of people below poverty line   Number of people living in households with an income or expenditure per person below $6.85 a day 2022-08-23 12:30:49 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
472266 $3.65 - total number of people below poverty line   Number of people living in households with an income or expenditure per person below $3.65 a day 2022-08-23 12:30:49 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
472265 $2.15 - total number of people below poverty line   Number of people living in households with an income or expenditure per person below $2.15 a day 2022-08-23 12:30:49 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
472264 $1 - total number of people below poverty line   Number of people living in households with an income or expenditure per person below $1 a day 2022-08-23 12:30:49 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
472263 Median income or expenditure per day   The level of income or expenditure per day below which half of the population live. 2022-08-23 12:30:49 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "unit": "international-$ at 2017 prices",
    "shortUnit": "$",
    "includeInTable": true
}
 0           1                                  
472262 Mean income or expenditure per day   The mean level of income or expenditure per day. 2022-08-23 12:30:49 2023-06-15 05:05:42       World Bank Poverty and Inequality Platform (PIP) 5689 World Bank Poverty and Inequality Platform (2022) 26712   
{
    "unit": "international-$ at 2017 prices",
    "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");