Survey Question Catalog for Afrobarometer Rounds

One row per distinct Afrobarometer survey variable, with its ODA question identifier, question text, section, and the rounds in which the variable appears. The catalog contains 4,296 variables spanning R1 through R10, with the latest round covering 2024/2025; question identifiers and variable codes can recur across rounds, so use the values table's round fields for time-specific analysis.

afrobarometer-questions·7 columns·151 KB·Afrobarometer data usage and access policy·updated 2mo ago

Schema

variable_codeVARCHAR
question_idBIGINT
titleVARCHAR
sectionVARCHAR
n_roundsINTEGER
round_numsVARCHAR
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-questions\" 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.