Surveyed African Countries in the Afrobarometer ODA Corpus

One row per country or ODA region entry in the Afrobarometer Online Data Analysis corpus, with the internal region identifiers and the survey rounds in which that country appears. The table covers 55 entries across rounds R1 through R10; some ODA region rows currently have no surveyed rounds, so use the round participation fields before treating every row as observed survey coverage.

afrobarometer-countries·8 columns·4 KB·Afrobarometer data usage and access policy·updated 1mo ago

Schema

countryVARCHAR
region_idBIGINT
mpcodVARCHAR
valorBIGINT
round_numsVARCHAR
n_roundsINTEGER
first_round_numINTEGER
latest_round_numINTEGER

Get this dataset on your machine

subsets sync --bundle medium clones the mid-size tiers as queryable local tables — use --bundle large for the widest tier

pip install subsetsio
subsets sync --bundle small # or medium, or large
subsets serve # search + SQL at http://localhost:8080

Free and open — the data syncs straight from the public bucket, and search + SQL run entirely on your machine. See docs →

Query it locally

Full docs →
Bash
subsets serve   # local API on http://localhost:8080
curl -s -X POST "http://localhost:8080/query" \
  -H "Content-Type: application/json" \
  -d '{"sql": "SELECT * FROM \"afrobarometer-countries\" LIMIT 5"}'

No account, no API key — the data syncs straight from bundles.subsets.io and every query runs on your machine. See the local API reference.