OliverHarman/Authority_in_African_Cities
Domain:
socioeconomicCreator:
Oli
Host:
Data Visualisation of the Authority in African Cities Dataset
# Authority in African Cities — RAI(Metro) Explorer
Interactive data explorer for metropolitan authority scores across seven African countries (1977–2025), built using the Regional Authority Index (RAI) framework.
Part of *Power and Place: Decentralisation and Urbanisation in Africa* by Oliver Harman.
Funded by the International Growth Centre (Project Grant XXX-24303).
## Live site
Once hosted, the site will be available at: `https://[username].github.io]/`
## Files
| File | Description |
|------|-------------|
| `index.html` | The complete interactive dashboard (single self-contained file) |
| `data.csv` | All country-year RAI(Metro) scores — **edit this to update data** |
| `README.md` | This file |
## How to update data
1. Open `data.csv` in Excel, Google Sheets, or any text editor
2. Each row = one country-year with all 10 RAI indicators
3. Columns: `Country, Region, Year, ID, PA, FA, BA, Rep, LM, EC, FC, BC, Const, SR, ShR, RAI`
4. To **add a new country or entity** (e.g. Kampala as a separate coding), just add rows with a new `Country` value — the site auto-detects it
5. To **update a year**, edit the relevant row
6. Commit and push — the site updates automatically
### Score formulas
- **Self-Rule (SR)** = ID + PA + FA + BA + Rep (max 18)
- **Shared Rule (ShR)** = LM + EC + FC + BC + Const (max 12)
- **Total RAI** = SR + ShR (max 30)
### Adding Kampala (example)
Add rows like this to `data.csv`:
```
Uganda - Kampala,KCCA,2010,2,3,2,2,3,0,0,1,0,3,12,4,16
Uganda - Kampala,KCCA,2011,2,3,2,2,3,0,0,1,0,3,12,4,16
```
The site will auto-detect "Uganda - Kampala" as a new entity and assign it a colour.
## Hosting via GitHub Pages
1. Create a new GitHub repository
2. Upload `index.html`, `data.csv`, and `README.md`
3. Go to **Settings → Pages**
4. Under **Source**, select **main** branch and **/ (root)** folder
5. Click **Save**
6. Your site will be live within a few minutes at `https://[username].github.io]/`
### Local developme …