Aggregated Afrobarometer Survey Responses by Country and Round

Name: Aggregated Afrobarometer Survey Responses by Country and Round
Creator: Afrobarometer
License: Afrobarometer data usage and access policy

One row per survey variable, country, round, and answer category, with weighted response counts and valid percentages from Afrobarometer's Online Data Analysis service. The table contains about 1.2 million aggregated rows across 44 countries and survey rounds R1 through R10. Rows are answer-category aggregates; filter missing-response categories before interpreting substantive opinions, and do not sum percentages across questions or countries as an overall share.

afrobarometer-values·12 columns·10.4 MB·Afrobarometer data usage and access policy·updated 1mo ago

Source: Afrobarometer · connector code

Schema

variable_code	VARCHAR
question_id	BIGINT
question_title	VARCHAR
section	VARCHAR
country	VARCHAR
round_num	INTEGER
round_label	VARCHAR
answer_code	INTEGER
answer_label	VARCHAR
is_missing	BOOLEAN
weighted_n	DOUBLE
pct_valid	DOUBLE

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-values\" 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.