A | B | C | D | E | F | G | H | I | J | |
---|---|---|---|---|---|---|---|---|---|---|
1 | Mean income per capita Dataset - v4 via Gapminder | |||||||||
2 | About this file | This 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: | v4 | ||||||||
4 | Updated: | February 10 2023 | ||||||||
5 | Download latest version: | Excel file » | ||||||||
6 | Latest version online: | http://gapm.io/dmincpcap_cppp | ||||||||
7 | Contributor(s) to this version: | Ola Rosling | ||||||||
8 | Feedback | Please give feedback here | ||||||||
9 | ||||||||||
10 | # | Indicator(s) | Description | Full name | Unit | ID | type | Usage | ||
11 | 1 | Average daily income per capita | This is the average daily household per capita income (or consumption expenditure) from the survey expressed in 2017 PPP (constant international dollars). | Daily income per capita, PPP( constant 2011 international $) | $ | mincpcap_cppp | measure | 2 | ||
12 | ||||||||||
13 | Sources | |||||||||
14 | Dataset description: | The data on mean income household per capita was compiled by Gapminder as follows, to be used for income distributions over hundreds of years. These numebrs are anchored in the official Mean Income indicator from the World Bank for the present period with data form houshold surveys. For coutnries with no such data from the World Bank, Gapminder has estimated mean income based on the countries GDP per capita. For the years outside the available timeframe of actual World Bank data (the outer range being 1967 to 2021, but most countries have veru few of these years, when surveys were conducted). Gapmidner used the growth rates of the constant dollar GDP per capita, to estimate mean incomes historically back to 1800 and up to 2100. No need to say that these are rough estimates. For the period 1981-2019 : we use data from the World Bank, which is the source with the most comparable and broad coverage, published in the World Development Indicators: "Survey mean consumption or income per capita, total population (2017 PPP $ per day)". The indicator we align to is described like this in World Bank PIP (Poverty and Inequality Platform) "Indicators Survey mean/average consumption or income per capita, total population (2017 PPP $ per day) The mean is the average monthly household per capita income or consumption expenditure from the survey in 2017 PPP." | ||||||||
15 | Link to documentation: | http://gapm.io/dmincpcap_cppp | ||||||||
16 | Short source summary: | GM based WB | ||||||||
17 | ||||||||||
18 | # | Source id | Name | Link | ||||||
19 | 1 | wbpip | https://pip.worldbank.org/poverty-calculator | |||||||
20 | 2 | gm21 | Gapminder ( GDP per capita) | https://docs.google.com/spreadsheets/d/1gZZ28UiWCVue-tFHMEVOvSO58x7x-w20E23l1wZTR3E/edit#gid=501532268 | ||||||
21 | ||||||||||
22 | License | |||||||||
23 | 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/dmincpcap_cppp | ||||||||
24 | License link: | Creative Common License CC BY 4.0 | ||||||||
25 | 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. | ||||||||
26 | ||||||||||
27 | Versions | Link | Changes compared to previous | Date | Contributors | |||||
28 | v1 | https://docs.google.com/spreadsheets/d/1xLN-R8pxjoWFXWTszUf2hhNIFi3xKYab6islP9HuhLk/edit#gid=501532268 | First version | 2017 October 31 | Ola Rosling | |||||
29 | v2 | https://docs.google.com/spreadsheets/d/1nXQrAb6bbJmhhitrvjOtuCLtE8IxnCoJ_TxjFEJQP2M/edit#gid=501532268 | added new povalnet estimates and estimates for countries with no data in povcalnet | 2021 September 13 | Diane I | |||||
30 | v3 | https://docs.google.com/spreadsheets/d/1Ii3BCSnpDJ071gw1kIY4-7CL3B8icL2IQ50hoTXrgSs/edit#gid=501532268 | Updating to PPP 2017 | 2023 January 2 | Ola Rosling | |||||
31 | v4 | https://docs.google.com/spreadsheets/d/1q1-E6S8P3wepkD1WZbx2YdB95mZCPE7iEXQ6Fz_Qpn0/edit#gid=665755634 | Improved Updating to PPP 2017 | 2023 February 10 | Ola Rosling | |||||
32 | ||||||||||
33 | Technical stuff | |||||||||
34 | Dataset name: | Mean income per capita | ||||||||
35 | Dataset id: | mincpcap_cppp | ||||||||
36 | Doc url | https://docs.google.com/spreadsheets/d/1Ii3BCSnpDJ071gw1kIY4-7CL3B8icL2IQ50hoTXrgSs/edit | ||||||||
37 | Doc id of work doc spreadsheet | 1Ii3BCSnpDJ071gw1kIY4-7CL3B8icL2IQ50hoTXrgSs | ||||||||
38 | Formulas | The 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. | ||||||||
39 | For developers | If 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. | ||||||||
40 | Read more: | gapm.io/dataworks | ||||||||
41 | CHART PREVIEWS | |||||||||
42 | [c] | data-for-countries-etc-by-year | https://www.gapminder.org/tools/#$state$time$dim=time;&entities$dim=geo;&marker$axis_x$which=income_per_person_gdppercapita_ppp_inflation_adjusted&scaleType=log&spaceRef:null;&axis_y$data=data_&which=Average%20daily%20income%20per%20capita&spaceRef:null;&label$which=name&scaleType=ordinal;&size$which=population_total&use=indicator&scaleType=linear&spaceRef:null;&color$data=data_fasttrack&which=world_4region&use=property&scaleType=ordinal&spaceRef=entities;;;&data$reader=ddfbw&dataset=sg-master&service=https:////big-waffle.gapminder.org;&data_$reader=google_csv&path=https:////docs.google.com//spreadsheets//d//1Ii3BCSnpDJ071gw1kIY4-7CL3B8icL2IQ50hoTXrgSs//gviz//tq?tqx=out:csv/&sheet=data-for-countries-etc-by-year&hasNameColumn:true&nameColumnIndex:1;&data_wdi$reader=ddfbw&dataset=wdi-master&service=https:////big-waffle.gapminder.org;&data_fasttrack$reader=ddfbw&dataset=fasttrack&service=https:////big-waffle.gapminder.org;&chart-type=bubbles | |||||||
43 | Average%20daily%20income%20per%20capita | |||||||||
44 | DDF mapping: | schema for indicator table | ||||||||
45 | concept_id | 6 | ||||||||
46 | name_short | 2 | ||||||||
47 | name | 4 | ||||||||
48 | description | 3 | ||||||||
49 | unit | 5 | ||||||||
50 | type | 7 | ||||||||
51 | usage | 8 | ||||||||
52 | ||||||||||
53 | Catalog status | Indicator ID | Time unit | Countries etc | Regions | In. Levels | World | |||
54 | Average daily income per capita | mincpcap_cppp | year | GOOD | BAD: No concept matches concept_id "mincpcap_cppp", time_unit "year", fasttrackCatalogGeography "regions" in the fasttrack catalog | BAD: No concept matches concept_id "mincpcap_cppp", time_unit "year", fasttrackCatalogGeography "income-levels" in the fasttrack catalog | BAD: No concept matches concept_id "mincpcap_cppp", time_unit "year", fasttrackCatalogGeography "world" in the fasttrack catalog | |||
55 | ||||||||||
56 | # | Validation | ||||||||
57 | 1 | output-sheets | GOOD: There is at least one output sheet present (sheets starting with 'data-for-' and not ending with '-in-columns') | |||||||
58 | 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 | |||||||
59 | 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) | |||||||
60 | 4 | version | GOOD: Named range 'version' exists | |||||||
61 | 5 | version | GOOD: 'Version:' is filled in | |||||||
62 | 6 | version | GOOD: The version at 'Version:' starts with a v, followed by an integer | |||||||
63 | 7 | date | GOOD: Named range 'date' exists | |||||||
64 | 8 | date | GOOD: 'Updated:' is filled in | |||||||
65 | 9 | gapmio | GOOD: Named range 'gapmio' exists | |||||||
66 | 10 | gapmio | GOOD: 'Latest version online:' is filled in | |||||||
67 | 11 | contributors | GOOD: Named range 'contributors' exists | |||||||
68 | 12 | contributors | GOOD: 'Contributor(s) to this version:' is filled in | |||||||
69 | 13 | indicator_table | GOOD: Named range 'indicator_table' exists | |||||||
70 | 14 | indicator_table | GOOD: The named range 'indicator_table' covers the whole Indicator(s) table (the rows immediately above and below the table are empty) | |||||||
71 | 15 | indicator_table:row_1 | GOOD: This first column of row '1' in the indicator(s) table is incremental (from 1 and up) | |||||||
72 | 16 | indicator_table:row_1 | GOOD: Indicator 1 has a short indicator name (Column 2) | |||||||
73 | 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" | |||||||
74 | 18 | indicator_table:row_1 | GOOD: Indicator 1 has a description (Column 3) | |||||||
75 | 19 | indicator_table:row_1 | GOOD: Indicator 1 has a full name (Column 4) | |||||||
76 | 20 | indicator_table:row_1 | GOOD: Indicator 1 has a unit (Column 5) | |||||||
77 | 21 | indicator_table:row_1 | GOOD: Indicator 1's unit does not start or end with a space | |||||||
78 | 22 | indicator_table:row_1 | GOOD: Indicator 1 has an ID (Column 6) | |||||||
79 | 23 | indicator_table:row_1 | GOOD: Indicator 1's ID contains only lowercase latin characters (a-z) or numbers, and no space, dashes or underscores. (Column 6) | |||||||
80 | 24 | indicator_table:row_1 | GOOD: Indicator 1's ID has less than or equal to 20 characters | |||||||
81 | 25 | indicator_table:row_1 | GOOD: Indicator 1 has a type set (Column 7) | |||||||
82 | 26 | indicator_table:row_1 | GOOD: Indicator 1 has a usage level set (Column 8) | |||||||
83 | 27 | dataset_description | GOOD: Named range 'dataset_description' exists | |||||||
84 | 28 | dataset_description | GOOD: 'Dataset description:' is filled in | |||||||
85 | 29 | source_url | GOOD: Named range 'source_url' exists | |||||||
86 | 30 | source_url | GOOD: 'Link to documentation:' is filled in | |||||||
87 | 31 | source_short_text | GOOD: Named range 'source_short_text' exists | |||||||
88 | 32 | source_short_text | GOOD: 'Short source summary:' is filled in | |||||||
89 | 33 | source_short_text | GOOD: 'Short source summary:' has less than or equal to 45 characters | |||||||
90 | 34 | source_table | GOOD: Named range 'source_table' exists | |||||||
91 | 35 | source_table | GOOD: The named range 'source_table' covers the whole Sources table (the rows immediately above and below the table are empty) | |||||||
92 | 36 | source_table:row_1 | GOOD: This first column of row '1' in the sources table is incremental (from 1 and up) | |||||||
93 | 37 | source_table:row_1 | GOOD: Source 1 has a source id (Column 2) | |||||||
94 | 38 | source_table:row_1 | BAD: Source 1 has no name (Column 3) | |||||||
95 | 39 | source_table:row_1 | GOOD: Source 1 has a link (Column 4) | |||||||
96 | 40 | source_table:row_2 | GOOD: This first column of row '2' in the sources table is incremental (from 1 and up) | |||||||
97 | 41 | source_table:row_2 | GOOD: Source 2 has a source id (Column 2) | |||||||
98 | 42 | source_table:row_2 | GOOD: Source 2 has a name (Column 3) | |||||||
99 | 43 | source_table:row_2 | GOOD: Source 2 has a link (Column 4) | |||||||
100 | 44 | version_table | GOOD: Named range 'version_table' exists |