People. Plans. Progress.
Project locations
Every site of a published project: where it is, its status and progress. Filters apply to the projects.
Dataset description
Every site of a published project: where it is, its status and progress. Filters apply to the projects.
The same records as the portal page, with the same filters (q, organisation, status, project_type, sector, location, budget_min, budget_max, target_year, has_feedback, multi_location, freshness). Live downloads are built from the published records when you ask for them; for a fixed file you can cite and download again later, use a dated release.
Data fields (21)
Every file has exactly these columns, in this order. No contact details, private locations or staff identities are ever included.
| Field | Label | Type | Description |
|---|---|---|---|
site_id | Site ID | integer | |
project_id | Project ID | integer | |
project | Project | text | |
organisation | Organisation | text | |
name | Site | text | |
address | Address | text | |
community | Community | text | |
lga | LGA | text | |
state | State | text | |
area | Area | text | The site's area (jurisdiction) |
latitude | Latitude | number | Of the site, as published by the organisation |
longitude | Longitude | number | |
status | Status | text | |
progress_percent | Progress (%) | integer | |
start_date | Start date | date | |
target_date | Target date | date | |
completed_date | Completed | date | |
budget | Budget | number | Empty when the organisation has not published the budget |
actual_cost | Actual cost | number | |
contractor | Contractor | text | |
last_progress_update | Last progress update | datetime |
Preview data (first 0 records)
Full datasetNo records yet.
Usage & API
The JSON download is the API: the same records with the dataset's name, when it was generated, its licence, filters and schema. Every response carries X-API-Version: 1 and the number of records in X-Row-Count.
https://public.andystrategy.com.ng/app/index.php?r=public/download&dataset=project-locations&format=jsonReleases
No dated release yet.