World Bank Open Data
Let AI connect your sources for you
Skip the manual setup — run this in your project and the wizard auto-detects your databases and APIs and connects them to PostHog.
Connect World Bank Open Data to PostHog to sync your data into the PostHog data warehouse for analysis and modeling.
Pull country-level development statistics from the World Bank Indicators API into the PostHog Data warehouse.
The API is open, so no credentials are required. The World Bank publishes around 16,000 indicator series, which is far too much to sync wholesale, so enter the indicator codes you want (up to 50), one per line. For example:
SP.POP.TOTL
NY.GDP.PCAP.CD
IT.NET.USER.ZS
You can look codes up in the indicators table or on data.worldbank.org. Observations for every code you enter land in a single indicator_data table.
The API has no "changed since" filter, and the World Bank revises historical values on each quarterly release, so every table syncs as a full refresh.
Configuration
| Option | Type | Required |
|---|---|---|
Indicator codes | textarea | Yes |
Linking World Bank Open Data to PostHog
- Go to the Data pipeline page in PostHog
- Click New source and select World Bank Open Data
- Fill in the required configuration fields
- Click Next, select the tables you want to sync, and then press Import
Supported tables
| Table | Description | Sync method | Incremental field | Primary key |
|---|---|---|---|---|
countries | Countries and aggregates, with their region, income level, lending type, and capital city. | Full refresh | — | — |
indicators | Catalog of every indicator series the API exposes, with its unit, source, and topics. | Full refresh | — | — |
sources | Databases the indicator data comes from, such as World Development Indicators. | Full refresh | — | — |
topics | Subject areas indicators are grouped under, such as Health or Climate Change. | Full refresh | — | — |
regions | Geographic regions and regional aggregates used to group countries. | Full refresh | — | — |
income_levels | World Bank income classifications, such as high income or low income. | Full refresh | — | — |
lending_types | World Bank lending categories, such as IBRD, IDA, or blend. | Full refresh | — | — |
indicator_data | Observations for every indicator code you configured, one row per country and period. | Full refresh | — | — |