People. Plans. Progress.
Public projects
Every published project with its status, progress, dates, and budget where the organisation has chosen to publish it.
Dataset description
Every published project with its status, progress, dates, and budget where the organisation has chosen to publish it.
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 (28)
Every file has exactly these columns, in this order. No contact details, private locations or staff identities are ever included.
| Field | Label | Type | Description |
|---|---|---|---|
project_id | Project ID | integer | |
title | Project | text | |
summary | Summary | text | |
organisation | Organisation | text | |
organisation_slug | Organisation key | text | |
goal | Goal | text | The published goal the project serves, if any |
initiative | Initiative | text | |
sector | Main sector | text | |
area | Main area | text | |
project_type | Type | text | |
status | Status | text | Reported by the organisation |
progress_percent | Progress (%) | integer | |
progress_method | Progress basis | text | manual (reported), sites or milestones (calculated) |
start_date | Start date | date | |
target_date | Target date | date | |
actual_completion_date | Completed | date | |
budget | Budget | number | Empty when the organisation has not published the budget |
actual_cost | Actual cost | number | Empty when the organisation has not published the budget |
currency | Currency | text | |
contractor | Contractor | text | |
contract_reference | Contract reference | text | |
sites | Sites | integer | |
sites_completed | Sites completed | integer | |
evidence | Public evidence | integer | |
public_reports | Public reports | integer | |
unresolved_issues | Unresolved issues | integer | |
last_public_update_at | Last public update | datetime | |
url | Portal page | url | Web address of the item on the portal |
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=projects&format=jsonReleases
No dated release yet.