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 runsha256sum 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.
| 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
| 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.
| 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
| 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.
| 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
| 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.
| 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
| 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".
| 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
| 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.
