ABCDEFGHIJ
1
National Poverty lines Dataset - v2 via Gapminder
2
About this fileThis file has multiple sheets with data for one or more indicators used by Gapminder. In this sheet below you'll first find an overview of the indicators (measures) and the list of underlying sources. The actual data we use, is found in the sheet(s) labeled "data-...".
This file is also a documentation of the data process. To follow how the data was transformed from the original sources, start in the sheet to the far right, which holds the input data. You can then follow the process step by step, by looking at the formulas in the sheets from right to left, until you reach the output in the "data-..." sheets.
3
Version:v2
4
Updated:November 22 2023
5
Download latest version:Excel file »
6
Latest version online:http://gapm.io/dnpl
7
Contributor(s) to this version: Claudia S
8
FeedbackPlease give feedback here
9
10
#Indicator(s)DescriptionFull nameUnitIDtypeUsage
11
1National poverty lineThis is the minimum level of income deemed adequate in a particular country. It is converted to international dollars using purchasing power parity rate and is expressed in per capita terms per dayNational Poverty line, PPP (2017 US$ per day)US$nplmeasure2
12
13
Sources
14
Dataset description:The National poverty lines have been imported from Our world in data. We also used the World Bank's Policy Research Working Paper: "Estimating International Poverty Lines from Comparable National Thresholds"written by Dean Jolliffe Espen Beer Prydz in 2016. We converted the data from USD 2011 PPP to USD 2017 PPP. If there were two values for the same year and country from different sources we took as valid the value from OWID.
In this dataset the poverty and inequality data are expressed in 2017 Purchasing Power Parity (PPP) prices, versus 2011 PPP in previous editions. The backbone of the poverty and inequality estimates are country-level household survey unit record data or grouped data, obtained largely by the Poverty and Equity Global Practice, which works closely with National Statistical Offices, and collected in the World Bank’s Global Monitoring Database (GMD). Consumption or income aggregates from such surveys are deflated over time using national consumer price indices and price differences across countries are reflected through purchasing power parity conversion factors.
15
Link to documentation:http://gapm.io/dnpl
16
Short source summary:owid
17
18
#Source idNameLink
19
1OWIDOur World in Data
https://ourworldindata.org/grapher/national-poverty-lines-vs-gdp-per-capita?tab=table
20
21
License
22
Attribution:
We believe in free knowledge and therefor we share free data. Most sheets in this file are provided under the open license, called Creative Commmon Attribution License CC BY 4.0., except those sheets mentioned in the exceptions section below. This means you can freely use, copy, and spread the data in those sheets, as long as you mention the following: 'Free data from Gapminder.org'.
You should also mention the underlaying data sources listed above and include this link: http://gapm.io/dnpl
23
License link:Creative Common License CC BY 4.0
24
Exceptions:
The sheets starting with the word "data" are covered by this license. Other sheets are included for documentation purpose, and may include data that is governed by other licenses. Check the underlying sources for the specific licenses in these cases.
25
26
VersionsLinkChanges compared to previousDateContributors
27
v1
https://docs.google.com/spreadsheets/d/1Rb7hcxD6UVThpHTDu-wM7ZCcmuQ15s7vl9ooit3btc0/edit#gid=1962563621
First version2020 February 4Diane I
28
v2
https://docs.google.com/spreadsheets/d/1gu2rBC1lZENxQW36Om1_--Uy8lXnZKzPDcACwppD2zw/edit#gid=1962563621
Updated data with 2017 PPP2023 November 22Claudia S
29
30
Technical stuff
31
Dataset name:National Poverty lines
32
Dataset id:npl
33
Doc urlhttps://docs.google.com/spreadsheets/d/1ip5eftTzJ3grJ-03fxqTyzr4nmDB9bPWjrIizBoy7Kg/edit#gid=1962563621
34
Doc id of work doc spreadsheet1ip5eftTzJ3grJ-03fxqTyzr4nmDB9bPWjrIizBoy7Kg
35
FormulasThe formulas in this workbook may be referring to other spreadsheets online, by their named ranges, and not by sheet names. Search for "named ranges" to see how to use those instead of cell ranges.
36
For developersIf you like the data we use into your own products, it's better if you fetch data from our standardized gitHub repo on https://open-numbers.github.io
These spreadsheets are part of Gapminder's data compilation process and allow end users to track how we combine data.
37
Read more:gapm.io/dataworks
38
CHART PREVIEWS
39
[c]
data-for-countries-etc-by-year
https://www.gapminder.org/tools/#$state$time$dim=time;&entities$dim=geo;&entities_colorlegend$dim=geo;&marker$axis_x$which=income_per_person_gdppercapita_ppp_inflation_adjusted&scaleType=log&spaceRef:null;&axis_y$data=data_&which=National%20poverty%20line&spaceRef:null;&label$which=name&scaleType=ordinal;&size$which=population_total&use=indicator&scaleType=linear;&color$which=_default&use=constant&scaleType=ordinal;;;&data$reader=ddfbw&service=https:////big-waffle.gapminder.org&dataset=sg-master&translateContributionLink:///crowdin.com//project//systema-globalis;&data_$reader=google_csv&path=https:////docs.google.com//spreadsheets//d//1ip5eftTzJ3grJ-03fxqTyzr4nmDB9bPWjrIizBoy7Kg//gviz//tq?tqx=out:csv/&sheet=data-for-countries-etc-by-year&hasNameColumn:true&nameColumnIndex:1;&chart-type=bubbles
40
National%20poverty%20line
41
DDF mapping:schema for indicator table
42
concept_id6
43
name_short2
44
name4
45
description3
46
unit5
47
type7
48
usage8
49
50
Catalog statusIndicator IDTime unit
Countries etc
RegionsIn. LevelsWorld
51
National poverty linenplyearGOOD---
52
53
#Validation
54
1output-sheetsGOOD: There is at least one output sheet present (sheets starting with 'data-for-' and not ending with '-in-columns')
55
2
output-sheet:data-for-countries-etc-by-year
GOOD: The 'data-for-countries-etc-by-year' output sheet has at least 4 header columns
56
3
output-sheet:data-for-countries-etc-by-year
GOOD: The 'data-for-countries-etc-by-year' output sheet does not have filter mode turned on (since it breaks the CSV endpoint)
57
4versionGOOD: Named range 'version' exists
58
5versionGOOD: 'Version:' is filled in
59
6versionGOOD: The version at 'Version:' starts with a v, followed by an integer
60
7dateGOOD: Named range 'date' exists
61
8dateGOOD: 'Updated:' is filled in
62
9gapmioGOOD: Named range 'gapmio' exists
63
10gapmioGOOD: 'Latest version online:' is filled in
64
11contributorsGOOD: Named range 'contributors' exists
65
12contributorsGOOD: 'Contributor(s) to this version:' is filled in
66
13indicator_tableGOOD: Named range 'indicator_table' exists
67
14indicator_tableGOOD: The named range 'indicator_table' covers the whole Indicator(s) table (the rows immediately above and below the table are empty)
68
15indicator_table:row_1GOOD: This first column of row '1' in the indicator(s) table is incremental (from 1 and up)
69
16indicator_table:row_1GOOD: Indicator 1 has a short indicator name (Column 2)
70
17
indicator_table:row_1:data-for-countries-etc-by-year
GOOD: The indicator name cell of indicator 1 is referenced in the 'data-for-countries-etc-by-year' output sheet in column 4 as "=ABOUT!B11"
71
18indicator_table:row_1GOOD: Indicator 1 has a description (Column 3)
72
19indicator_table:row_1GOOD: Indicator 1 has a full name (Column 4)
73
20indicator_table:row_1GOOD: Indicator 1 has a unit (Column 5)
74
21indicator_table:row_1GOOD: Indicator 1's unit does not start or end with a space
75
22indicator_table:row_1GOOD: Indicator 1 has an ID (Column 6)
76
23indicator_table:row_1GOOD: Indicator 1's ID contains only lowercase latin characters (a-z) or numbers, and no space, dashes or underscores. (Column 6)
77
24indicator_table:row_1GOOD: Indicator 1's ID has less than or equal to 20 characters
78
25indicator_table:row_1GOOD: Indicator 1 has a type set (Column 7)
79
26indicator_table:row_1GOOD: Indicator 1 has a usage level set (Column 8)
80
27dataset_descriptionGOOD: Named range 'dataset_description' exists
81
28dataset_descriptionGOOD: 'Dataset description:' is filled in
82
29source_urlGOOD: Named range 'source_url' exists
83
30source_urlGOOD: 'Link to documentation:' is filled in
84
31source_short_textGOOD: Named range 'source_short_text' exists
85
32source_short_textGOOD: 'Short source summary:' is filled in
86
33source_short_textGOOD: 'Short source summary:' has less than or equal to 45 characters
87
34source_tableGOOD: Named range 'source_table' exists
88
35source_tableGOOD: The named range 'source_table' covers the whole Sources table (the rows immediately above and below the table are empty)
89
36source_table:row_1GOOD: This first column of row '1' in the sources table is incremental (from 1 and up)
90
37source_table:row_1GOOD: Source 1 has a source id (Column 2)
91
38source_table:row_1GOOD: Source 1 has a name (Column 3)
92
39source_table:row_1GOOD: Source 1 has a link (Column 4)
93
40version_tableGOOD: Named range 'version_table' exists
94
41version_tableGOOD: The named range 'version_table' covers the whole Versions table (the rows immediately above and below the table are empty)
95
42version_table:row_1GOOD: Version-listing 1 has a version reference set (Column 1)
96
43version_table:row_1GOOD: The version in column 1 starts with a v, followed by an integer
97
44version_table:row_1GOOD: Version-listing 1 has a link (Column 2)
98
45version_table:row_1GOOD: Version-listing 1 has "Changes compared to previous" (Column 3)
99
46dataset_nameGOOD: Named range 'dataset_name' exists
100
47dataset_nameGOOD: 'Dataset name:' is filled in