World Bank Data
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	• ntsako
	May 26 2022, 9:26 AM

Description

Create and store data from world bank api

Status	Assigned	Task
Open	None	T305468 Deploy the GDI Equity Landscape Dashboard
Open	None	T305475 Milestone: Ingest and Transform Input Data
Open	None	T306625 Extract + Transformation Raw Data into Input Metrics
Resolved	• ntsako	T309282 World Bank Data

Data loaded on

SELECT *
   FROM ntsako.world_bank_data

• ntsako changed the task status from Open to In Progress.May 26 2022, 9:29 AM

Update world bank series pulled from:

GDP, PPP (current international $)

https://data.worldbank.org/indicator/NY.GDP.MKTP.PP.CD

AND
GDP, PPP (constant 2017 international $)

https://data.worldbank.org/indicator/NY.GDP.MKTP.PP.KD

To instead pull the per capita adjusted metrics:
GDP per capita, PPP (current international $)

https://data.worldbank.org/indicator/NY.GDP.PCAP.PP.CD

AND
GDP per capita, PPP (constant 2017 international $)

https://data.worldbank.org/indicator/NY.GDP.PCAP.PP.KD

Table renamed to

select *
  from ntsako.world_bank_data_input_metrics