tgherzog

Overview

The Data Catalog API enables users to retrieve the contents of the data catalog along with data and metadata about individual datasets and their resources.

All API endpoints begin with the protocol and hostname: https://datacatalogapi.worldbank.org

tgherzog

import wbgapi as wb
import pandas as pd
import json

# Background: this is an attempt to make part of the data API more consistent and coherent.
# The API back-end has a mapping table that specifies the canonical database for each
# indicator when indicators appear in more than one database and the user doesn't explicitly
# specify a database, e.g.:
#   https://api.worldbank.org/v2/indicator/SP.POP.TOTL           (database is ambiguous)
#   https://api.worldbank.org/v2/indicator/SP.POP.TOTL?source=16 (database is clear)

tgherzog

/**
 * Fetches data from the World Bank API
 *
 * @param {string} indicator The indicator code
 * @param {string} country The 2- or 3-character ISO country code
 * @param {number} year The optional year. If omitted, fetch most recent available
 * @return The data value.
 * @customfunction
 */
function WBAPI(indicator, country, year) {

tgherzog

Stage	Open License Maturity Model	Data Access Maturity Model
1	Is the license prominent on the website?	Is data available online?
2	Is it clearly linked from each dataset?	In non-proprietary/open formats?
3	Does it include both short and long/legal versions?	With sufficient metadata?
4	Standard license (CC, OdBL)?	API access?
5	Conform to Open Data principles (freely available for any purpose)?	Interoperable standards?

tgherzog

MRY Age of Indicators

Ages are relative to the previous year. An age of 0 means 2018 for the "Original Report" and 2020 for "Oct, 2021".

indicatorID	indicator	Original Report	Oct, 2021	Change
EN.ATM.NOXE.PC	Nitrous oxide emissions (metric tons of CO2 equivalent per capita)	6	2	-4
EN.ATM.METH.PC	Methane emissions (metric tons of CO2 equivalent per capita)	6	2	-4
AG.LND.FRST.ZS	Forest area (% of land area)	2	0	-2
EN.ATM.CO2E.PC	CO2 emissions (metric tons per capita)	4	2	-2

tgherzog

'''
Script that iterates the API databases to check if the indicator endpoints are internally consistent.
See https://gist.github.com/tgherzog/f213ff55b254a940d3e18e038da01495 for sample reports

Usage:
  apitest1.py [--deep] [ID]

Options:

tgherzog

#!/usr/bin/python -u

#wbgapi module available here: https://github.com/tgherzog/wbgapi

"""
coverage.py produces quick density coverage stats for an indicator

Usage:
  coverage.py [--verbose --sources --prefixes --bssi --gaps] [--start YEAR] [--income INC] [--region RGN] [--since YEARS] [--archived-dbs IDS] INDICATOR...

tgherzog

# Run this in a Jupyter Notebook

import wbgapi as wb
import pandas as pd
from pyquery import PyQuery # JQuery for Python, sort of

pd.options.display.max_rows = 300


# scrape a list of UN member states

tgherzog

World Bank Reports

• Incorporating Environmental, Social and Governance Factors Into Fixed Income Investment \ The result of a partnership between the World Bank Group and Government Pension Investment Fund (GPIF) of Japan: to collaborate on initiatives that promote strategies for including environmental, social and governance (ESG) criteria in investment decisions across asset classes.

• Governance Improvements and Sovereign Financing Costs in Developing Countries \

tgherzog

"""
Upload files to a terre-biodiv s3 bucket

The first form uploads files from a local directory to an S3 bucket

The second form uses an S3 bucket as the source

Either BUCKET or SRCBUCKET can include a path prefix to control the
copy operation, e.g., wbg-terre-biodiv/data