Data downloads

The same data the site shows, as files you can open in Excel or Google Sheets or load into your own tools. Each dataset lists what its columns mean, where it comes from, when it last changed and a checksum to confirm your copy is intact.

Licence

All datasets are licensed CC BY 4.0: you may copy, share and adapt them, including commercially, as long as you credit "Ogbaru site (independent preview)" and the source named under each dataset. The licence covers our compilation only. It does not change the rights of the original sources.

Some figures are disputed or coming soon. Read the data quality statement before relying on them.

Opening the files

  • Excel: use the CSV with BOM. The BOM is a short marker at the start of the file that tells Excel it is UTF-8, so names are not garbled. Double-click the file, or choose Data, then From Text/CSV.
  • Google Sheets: choose File, then Import, then Upload. Either CSV works.
  • Other tools and code: use the CSV without BOM, or the JSON.
  • Checking a file: on Windows run certutil -hashfile ogbaru-wards.csv SHA256; on Linux or macOS run sha256sum ogbaru-wards.csv. The result should match the checksum shown here.

Ogbaru electoral wards

The 16 INEC wards with their state constituency and polling-unit counts.

Rows
16
Last updated
Licence
CC BY 4.0
Source
Compiled INEC-derived list, March 2026; total summed by the dossier author. Confirm on INEC's polling-unit locator.
Files for Ogbaru electoral wards
Format Size SHA-256 checksum
CSV, UTF-8 with BOM (Excel) for Ogbaru electoral wards 731 bytes 39a9a6591c43733522a51f32fecad55a9063a0a8eae65dc1d8835a532527c17b
CSV, UTF-8 without BOM for Ogbaru electoral wards 728 bytes e21df017b2f99a3b485ef6f1db1a5b8884692c559fcc3ee2a8be4084e420a7f5
JSON for Ogbaru electoral wards 4.2 KB d58e5efc1fddb33b59c61aa10fb3459616ff628f902fd4ffe7ba3f3b647644fb
Data dictionary: 6 columns
Columns in Ogbaru electoral wards
Column Type Meaning
inec_code text INEC ward code, in the form 04-16-WW (state 04, LGA 16, ward WW).
name text Ward name.
state_constituency text State Assembly constituency: Ogbaru I or Ogbaru II.
polling_unit_count integer Polling units recorded for the ward in the compiled INEC-derived list (March 2026). Medium confidence: confirm on INEC's locator.
polling_units_listed integer Polling units of this ward whose names and codes are listed in polling-units.csv. Lower than polling_unit_count until the unit list is imported.
verified boolean 1 if an editor has checked this row against its source, 0 if it is still coming soon.

Blank cells mean no source gives the value. They are never filled with a guess. In the JSON they are null.

Ogbaru polling units

Every polling unit that has been imported and checked. The columns are the ones the admin importer reads, so a downloaded file can be corrected and imported again.

A unit list is published only once it has been imported from INEC and checked. Until then the file may hold fewer rows than the ward totals in wards.json.

Rows
0
Last updated
No rows yet
Licence
CC BY 4.0
Source
Compiled INEC-derived list, March 2026; total summed by the dossier author. Confirm on INEC's polling-unit locator.
Files for Ogbaru polling units
Format Size SHA-256 checksum
CSV, UTF-8 with BOM (Excel) for Ogbaru polling units 41 bytes 7a48a1ef8632fe9ee3683704d430e159ca32a060c88ad2c459fe0ce20e3097c1
CSV, UTF-8 without BOM for Ogbaru polling units 38 bytes b69be98b01e123ba62be7ea6515bf64c3e6cd3aaca7779b2d30588051238a001
JSON for Ogbaru polling units 506 bytes d6b058e3771ec7ed0b7f787920bd0b45421c42ba1963ca4f1687f6b7e742bd60
Data dictionary: 5 columns
Columns in Ogbaru polling units
Column Type Meaning
ward_code text INEC ward code; matches inec_code in wards.csv.
ward_name text Ward name.
code text INEC polling-unit code, in the form 04-16-WW-PPP.
name text Polling-unit name.
is_new boolean 1 if the unit is newly created, 0 if it is long-standing.

Blank cells mean no source gives the value. They are never filled with a guess. In the JSON they are null.

Ogbaru communities

The published communities, including the Okpoko urban settlement. Names of traditional rulers and the written histories are not included: they are shown on each community's page once verified.

Rows
16
Last updated
Licence
CC BY 4.0
Source
Research dossier (29 Sep 2026), section 3.1.
Files for Ogbaru communities
Format Size SHA-256 checksum
CSV, UTF-8 with BOM (Excel) for Ogbaru communities 679 bytes f9ba73a49c8fe3e5b8b77b329315574bce98c41b7d882f3e51cb98df1378b605
CSV, UTF-8 without BOM for Ogbaru communities 676 bytes e0e3ddeaee6d463f9d6d99ae132c84fe7e0bdbebe8bbdb2f9edd11818cd473fb
JSON for Ogbaru communities 5.0 KB 5ec9a5a4e67371ddba16540ad5989c7b08c511b0d80d983ed758bd8a48a001c6
Data dictionary: 7 columns
Columns in Ogbaru communities
Column Type Meaning
slug text Web address name of the community page: /communities/<slug>.
name text Community name.
is_indigenous boolean 1 for the indigenous communities, 0 for Okpoko, the urban settlement.
ward_codes list INEC codes of the wards the community touches. Joined by ";" in the CSV, an array in the JSON. Blank if not yet assigned.
latitude decimal Degrees north, WGS 84. Blank until a location has been surveyed.
longitude decimal Degrees east, WGS 84. Blank until a location has been surveyed.
verified boolean 1 if an editor has checked this row against its source, 0 if it is still coming soon.

Blank cells mean no source gives the value. They are never filled with a guess. In the JSON they are null.

Ogbaru health and education facilities

Facilities the research dossier names. This is a partial list: a full directory is being verified, so a facility missing here is not a sign that it does not exist.

Rows
20
Last updated
Licence
CC BY 4.0
Source
Research dossier (29 Sep 2026), sections 8.3 and 8.4.
Files for Ogbaru health and education facilities
Format Size SHA-256 checksum
CSV, UTF-8 with BOM (Excel) for Ogbaru health and education facilities 1.5 KB 62467e43208ad1282b4beeecfbfd89c2bd8fbc54bfdb154d866eddf2c2cdcb37
CSV, UTF-8 without BOM for Ogbaru health and education facilities 1.5 KB 64b1be43246cbd189e3d397a6235d1475a9a53c5eeb17f39bbb7be2ce092cb86
JSON for Ogbaru health and education facilities 7.4 KB 2fdcbe631d5618b3188decf74935162a3a5df578f0321193f9797df0b1b2d6a3
Data dictionary: 10 columns
Columns in Ogbaru health and education facilities
Column Type Meaning
type text health, school or other.
name text Facility name as the source gives it.
ownership text For example public or faith-based. Blank where no source says.
level text For example primary, secondary or tertiary. Blank where no source says.
ward_code text INEC ward code. Blank if the ward is not known.
community text Community slug, matching communities.csv. Blank if not known.
latitude decimal Degrees north, WGS 84. Blank until surveyed.
longitude decimal Degrees east, WGS 84. Blank until surveyed.
contact text Contact details, included only once an editor has verified them. Blank otherwise.
verified boolean 1 if an editor has checked this row against its source, 0 if it is still coming soon.

Blank cells mean no source gives the value. They are never filled with a guess. In the JSON they are null.

Ogbaru projects

Projects the research dossier reports. Status follows what the sources say: a project resting on one news report, or on sources that disagree, is "reported" or "disputed" rather than "ongoing" or "completed".

Rows
6
Last updated
Licence
CC BY 4.0
Source
Research dossier (29 Sep 2026), sections 7 and 8, and the sources named in each row.
Files for Ogbaru projects
Format Size SHA-256 checksum
CSV, UTF-8 with BOM (Excel) for Ogbaru projects 2.7 KB ec7ac0ab9242aed738adebaeb7d7f453e192fe1c45fc6e66cb1403ce10a9f6de
CSV, UTF-8 without BOM for Ogbaru projects 2.7 KB 28e458d143cc6b30494eea55b4fb3a73ebb9be94e019d34873b2afbfba189ca1
JSON for Ogbaru projects 5.5 KB 98d4e8ebce75d8709d01b7af961c2c8d68b8d3bbc61a58f3a9e3ec819c2114de
Data dictionary: 15 columns
Columns in Ogbaru projects
Column Type Meaning
slug text Web address name of the project page: /projects/<slug>.
title text Project title.
type text For example road or health.
project_status text planned, ongoing, completed, reported or disputed.
status_note text What the status rests on and its date. Read this before relying on project_status.
funder text Who the sources say is paying.
cost_ngn decimal A cost in naira, only where a source gives one. Blank does not mean free.
cost_note text What cost_ngn is: approved, spent or estimated, and when.
start_date date YYYY-MM-DD, only where a source gives the exact date.
target_date date YYYY-MM-DD, only where a source gives the exact date.
completed_date date YYYY-MM-DD, only where a source gives the exact date.
ward_code text INEC ward code. Blank if the project is not tied to one ward.
description text Plain-language summary; allegations are attributed to who made them.
source text Where the row comes from, with the source's confidence.
verified boolean 1 if an editor has checked this row against its source, 0 if it is still coming soon.

Blank cells mean no source gives the value. They are never filled with a guess. In the JSON they are null.