WDVP Concept 2: Dashboard of Present Future
(Last updated on 2023-01-05)
https://wdvp.worldgovernmentsummit.org/
SOURCE DATA: https://docs.google.com/spreadsheets/d/1_xdns_UCtRNH9TWcxKYKa_HydlkZxbqCCYRfdxhUNpg/edit#gid=0
What is this analysis for?
1. Import
2. Tidy
- Resolve unemployment 2018 data. Is it really from HF, not WB? If so,
do I drop it?? For now, pretend it’s from WB.
- One indicator is unclear what it is…
3. Describe
Dataset has:* 13050 rows
* 16 columns
* 34 indicators in 10 sectors for 174 countries
* Trends between 2014 and 2022 (or latest for each country)
| sector | indicatordetail | source | indicator | from | to | interval |
|---|---|---|---|---|---|---|
| econ | Economic Growth | WorldBank | econgrowth | 2018 | 2021 | 3 |
| econ | GDP ($ USD billions PPP) | World Bank | gdp | 2018 | 2021 | 3 |
| econ | GDP growth (annual %) | World Bank | gdpgrowth | 2018 | 2021 | 3 |
| econ | GDP per capita in $ (PPP) | World Bank | gdppp | 2018 | 2021 | 3 |
| econ | GINI index | CIA World Factbook | gini | 2025 | NA | NA |
| education | % of primary school aged kids out of school | WorldBank | kidsoutofschool | 2018 | 2021 | 3 |
| education | Education as % of GDP | WorldBank | edu_pctgdp | 2014 | 2021 | 7 |
| environment | CO2e emissions per capita | WorldBank | co2pp | 2019 | 2019 | 0 |
| environment | share of electricity from renewables generation | EIA | renewable | 2015 | 2020 | 5 |
| gender | % of seats held by women in national parliaments | World Bank | pctseatsfemale | 2017 | 2021 | 4 |
| general | happy planet index | Happy Planet Index | happy | 2016 | 2019 | 3 |
| general | human development index | UNDP | hdi | 2017 | 2021 | 4 |
| general | sustainable economic development assessment (SEDA) | Boston Consulting Group (BCG) | seda | 2018 | 2018 | 0 |
| governance | civil liberties score | Freedom House | civilliberties | 2018 | 2022 | 4 |
| governance | control of corruption | World Bank | govcontrolcorruption | 2017 | 2021 | 4 |
| governance | financial freedom score | Heritage Foundation | finfreedom | 2018 | 2022 | 4 |
| governance | government effectiveness | World Bank | goveffectiveness | 2017 | 2021 | 4 |
| governance | government integrity score | Heritage Foundation | govintegrity | 2018 | 2022 | 4 |
| governance | judicial effectiveness score | Heritage Foundation | judicialeffectiveness | 2018 | 2022 | 4 |
| governance | overall economic freedom score | Heritage Foundation | econfreedom | 2017 | 2022 | 5 |
| governance | political rights score | Freedom House | politicalrights | 2018 | 2022 | 4 |
| governance | political stability & absence of violence | World Bank | politicalinstability | 2017 | 2021 | 4 |
| governance | regulatory quality | World Bank | govregulatory | 2017 | 2021 | 4 |
| governance | rule of law | World Bank | govrule | 2017 | 2021 | 4 |
| health | health expenditure % of GDP | World Bank | he_pctgdp | 2014 | 2021 | 7 |
| health | health expenditure per person | World Bank | hepp | 2015 | 2019 | 4 |
| health | infant mortality | WorldBank | imr | 2020 | 2020 | 0 |
| health | maternal mortality per 100,000 live births | Worldbank | mmr | 2017 | 2017 | 0 |
| living | % of population in extreme poverty | WorldBank | pctpopextpoverty | 2025 | NA | NA |
| living | % of population with access to electricity | WorldBank | pctpopelectricity | 2020 | 2020 | 0 |
| living | unemployment (%) | Heritage Foundation | unemployment | 2018 | 2018 | 0 |
| living | unemployment (%) | World Bank | unemployment | 2021 | 2021 | 0 |
| military | Military Spending as % of GDP | SIPRI | military_pctgdp | 2019 | 2021 | 2 |
| NA | population | World Bank Data | pop | 2018 | 2018 | 0 |
| NA | surface area (Km2) | CIA World Factbook | area | 2018 | 2018 | 0 |
| type | sector | indicatordetail | source | indicator | from | to | interval |
|---|---|---|---|---|---|---|---|
| input | econ | Economic Growth | WorldBank | econgrowth | 2018 | 2021 | 3 |
| input | econ | GDP ($ USD billions PPP) | World Bank | gdp | 2018 | 2021 | 3 |
| input | econ | GDP growth (annual %) | World Bank | gdpgrowth | 2018 | 2021 | 3 |
| input | education | Education as % of GDP | WorldBank | edu_pctgdp | 2014 | 2021 | 7 |
| input | environment | share of electricity from renewables generation | EIA | renewable | 2015 | 2020 | 5 |
| input | governance | civil liberties score | Freedom House | civilliberties | 2018 | 2022 | 4 |
| input | governance | control of corruption | World Bank | govcontrolcorruption | 2017 | 2021 | 4 |
| input | governance | financial freedom score | Heritage Foundation | finfreedom | 2018 | 2022 | 4 |
| input | governance | government effectiveness | World Bank | goveffectiveness | 2017 | 2021 | 4 |
| input | governance | government integrity score | Heritage Foundation | govintegrity | 2018 | 2022 | 4 |
| input | governance | judicial effectiveness score | Heritage Foundation | judicialeffectiveness | 2018 | 2022 | 4 |
| input | governance | overall economic freedom score | Heritage Foundation | econfreedom | 2017 | 2022 | 5 |
| input | governance | political rights score | Freedom House | politicalrights | 2018 | 2022 | 4 |
| input | governance | political stability & absence of violence | World Bank | politicalinstability | 2017 | 2021 | 4 |
| input | governance | regulatory quality | World Bank | govregulatory | 2017 | 2021 | 4 |
| input | governance | rule of law | World Bank | govrule | 2017 | 2021 | 4 |
| input | health | health expenditure % of GDP | World Bank | he_pctgdp | 2014 | 2021 | 7 |
| input | health | health expenditure per person | World Bank | hepp | 2015 | 2019 | 4 |
| input | military | Military Spending as % of GDP | SIPRI | military_pctgdp | 2019 | 2021 | 2 |
| type | sector | indicatordetail | source | indicator | from | to | interval |
|---|---|---|---|---|---|---|---|
| output | econ | GDP per capita in $ (PPP) | World Bank | gdppp | 2018 | 2021 | 3 |
| output | econ | GINI index | CIA World Factbook | gini | 2025 | NA | NA |
| output | education | % of primary school aged kids out of school | WorldBank | kidsoutofschool | 2018 | 2021 | 3 |
| output | environment | CO2e emissions per capita | WorldBank | co2pp | 2019 | 2019 | 0 |
| output | gender | % of seats held by women in national parliaments | World Bank | pctseatsfemale | 2017 | 2021 | 4 |
| output | general | happy planet index | Happy Planet Index | happy | 2016 | 2019 | 3 |
| output | general | human development index | UNDP | hdi | 2017 | 2021 | 4 |
| output | general | sustainable economic development assessment (SEDA) | Boston Consulting Group (BCG) | seda | 2018 | 2018 | 0 |
| output | health | infant mortality | WorldBank | imr | 2020 | 2020 | 0 |
| output | health | maternal mortality per 100,000 live births | Worldbank | mmr | 2017 | 2017 | 0 |
| output | living | % of population in extreme poverty | WorldBank | pctpopextpoverty | 2025 | NA | NA |
| output | living | % of population with access to electricity | WorldBank | pctpopelectricity | 2020 | 2020 | 0 |
| output | living | unemployment (%) | Heritage Foundation | unemployment | 2018 | 2018 | 0 |
| output | living | unemployment (%) | World Bank | unemployment | 2021 | 2021 | 0 |
4. Potential themes/questions
- bending the curve? in what measures/sectors, are we doing better -
recent rate of change vs. longer trends (need to import old data -
allowed - and smooth)?
- leaving no one behind? what countries are lagging by sector?
convergence to high income countries??
- leaving no one behind? growth vs. equity in each sector (e.g., GINI
vs. GDP per cap)
- viz: population vs. area show impact by population?? https://www.reddit.com/r/MapPorn/comments/yqzgkv/land_doesnt_vote_people_do/
5. Explore using the latest data
5.1. Correlation matrix - all metrics
5.1.1. Metrics: input
5.1.2. Metrics: output
It looks like IMR is massively incorrect…
After investigation:
- IMR is consistent with google spreadsheet but the google
spreadsheet is incorrect, compared against the source data.
5.2. Correlation matrix - select metrics
5.3. Closer look at the select indicators
MMR
GINI
Per capita CO2 emission
5.4. Country ranking?
See GitHub for data, code, and more information. For typos, errors, and questions, contact YJ Choi at www.isquared.global.