Dataset available @
tramsys-b0cc6.web.app
# π³π¬ Nigeria Cities Data
### State-Level Geographic and Population Inventory
> **File:** `nigeria_cities_data.xlsx` + `state_json_files/`
> **Created:** 2026-03-18 Β· 11:47:31 UTC
---
## Overview
A comprehensive inventory of cities, towns, and settlements across **35 Nigerian states** and the **Federal Capital Territory (FCT)**. Each record represents a named settlement with its geographic coordinates, elevation, and population estimate.
The dataset is available in two formats:
| # | Format | Description |
|---|--------|-------------|
| 1 | **Excel Workbook** | Single consolidated `.xlsx` file with one sheet per state and a master `Summary` sheet |
| 2 | **JSON Files** | Individual `.json` files per state, stored in the `state_json_files/` subfolder |
---
## File Structure
```
nigeria_cities_data.xlsx
β
βββ Sheet: Summary β one row per state with aggregated statistics
βββ Sheet: [State Name] β full city records per state (auto-filter enabled)
state_json_files/
βββ *.json β 35 individual files, one per state (root-level arrays)
```
---
## Schema
| Field | Type | Description |
|-------|------|-------------|
| `name` | `string` | Settlement / city name |
| `what` | `string` | Feature type (e.g. `"city"`) |
| `region` | `string` | Nigerian state or FCT name |
| `country` | `string` | Country (`Nigeria`) |
| `lat` | `float` | Latitude in decimal degrees (WGS84) |
| `long` | `float` | Longitude in decimal degrees (WGS84) |
| `elev ft` | `int` | Elevation above sea level (feet) |
| `pop est` | `int` | Estimated population (`0` = unpopulated or data unavailable) |
---
## Coverage
| Attribute | Value |
|-----------|-------|
| **Geographic scope** | 35 Nigerian states + FCT |
| **Unit type** | Settlement-level point data |
| **Total records** | 28,874 |
| **Largest file** | Borno β 1,438 records |
| **Smallest file** | Ekiti β 223 records |
View all included states (35 + FCT)
| | | | |
|---|---|---|---|
| Abia | Adamawa | Akwa β¦