World Health Organization Global Health Observatory (GHO)

Connect World Health Organization Global Health Observatory (GHO) to PostHog to sync your data into the PostHog data warehouse for analysis and modeling.

Pull public health statistics from the WHO Global Health Observatory into the PostHog Data warehouse.

The API is open, so no credentials are required. WHO publishes over 2,000 indicator series, which is far too much to sync wholesale, so enter the indicator codes you want, one per line. For example:

WHOSIS_000001
WHOSIS_000002
NCD_BMI_30A

You can look codes up in the indicators table or in the GHO OData API documentation. Observations for every code you enter land in a single indicator_data table.

WHO refreshes each indicator on its own publication cycle, typically annually, so a daily or weekly sync is more than enough to pick up changes.

Configuration

Option	Type	Required
Indicator codes	textarea	Yes

Linking World Health Organization Global Health Observatory (GHO) to PostHog

1. Go to the Data pipeline page in PostHog
2. Click New source and select World Health Organization Global Health Observatory (GHO)
3. Fill in the required configuration fields
4. Click Next, select the tables you want to sync, and then press Import

Supported tables

Table	Description	Sync method	Incremental field	Primary key
indicators	Catalog of every health indicator code the Global Health Observatory publishes.	Full refresh	—	—
dimensions	Dimensions observations can be disaggregated by, such as country, sex, or age group.	Full refresh	—	—
dimension_values	Values for every dimension, such as country codes for the COUNTRY dimension or SEX_MLE / SEX_FMLE for the SEX dimension.	Full refresh	—	—
indicator_data	Observations for every indicator code you configured, one row per country, year, and disaggregation.	Incremental, Full refresh	Date	—