Barangay project transparency board
For: Barangays
Basis: Full Disclosure Policy, DILG MC 2010-83 as amended by MC 2011-134
Open source
Build your own transparency site
Everything behind this site’s public data is free to reuse: a read-only API, versioned bulk snapshots for the whole country, every region and every LGU, a forkable “My LGU / My Barangay” website template, and printable templates barangays and LGUs can post today.
- Projects
- 248,550
- Contractors
- 7,717
- Anomaly indicators
- 3,883
- LGU records
- 43,766
Public API
JSON, read-only, no key needed. Results are paginated with an opaque cursor (up to 200 rows per page), cached at the edge for an hour, and limited to about 60 requests a minute per IP. Over the limit you get HTTP 429 with a Retry-After header. Responses never include submitter, reviewer or private fields.
| GET /api/open/v1 | Index: endpoints, current snapshot version, license and notices |
| GET /api/open/v1/projects?province=<psgc>&citymun=<psgc>&status=…&limit=…&cursor=… | Canonical DPWH public works projects (re-imported duplicates removed) |
| GET /api/open/v1/projects/{id} | One project |
| GET /api/open/v1/contractors?grade=A…F&limit=…&cursor=… | Contractor firms with their public record grade (individuals are excluded) |
| GET /api/open/v1/contractors/{id} | One contractor firm |
| GET /api/open/v1/flags?rule=…&subject_type=… | Published anomaly indicators: statistical signals, not findings of wrongdoing |
| GET /api/open/v1/lgu?level=Reg|Prov|City|Mun|SubMun|Bgy&parent=<psgc> | Regions down to barangays, with summary counts |
| GET /api/open/v1/lgu/{psgc} | One LGU by its PSGC code |
| GET /api/open/v1/districts | Legislative districts |
| GET /api/open/v1/districts/{slug} | One legislative district |
curl "https://lovethephilippines.com/api/open/v1/projects?citymun=<PSGC code>&limit=50" # next page: add &cursor=<next_cursor from the response>
Bulk snapshots
Snapshot 2026-11-02: 8,270 files in CSV and Parquet, covering the national set, 19 regional sets and 1,723 province, city and municipality sets. Every file has a SHA-256 checksum in the manifest. License: CC BY 4.0.
| Dataset | Rows | File | SHA-256 |
|---|---|---|---|
| projects | 248,550 | projects.csv (147.4 MB) | 23aca671c10f8f15… |
| projects | 248,550 | projects.parquet (30.1 MB) | ae7d2415c5afc16f… |
| contractors | 7,717 | contractors.csv (1.4 MB) | 13edf414fbaa8a4e… |
| contractors | 7,717 | contractors.parquet (434 KB) | b2b16faf4bab32cf… |
| indicators | 3,883 | indicators.csv (2.4 MB) | 3521ea54b97e19c7… |
| indicators | 3,883 | indicators.parquet (333 KB) | 92cded4414766ce8… |
| lgu_summaries | 43,766 | lgu_summaries.csv (7.0 MB) | 85348ddae672ea49… |
| lgu_summaries | 43,766 | lgu_summaries.parquet (975 KB) | fc0c90dc889ec591… |
| districts | 264 | districts.csv (51 KB) | 258dedcbd373e0e9… |
| districts | 264 | districts.parquet (19 KB) | 2111b00c5d122394… |
Regional and LGU files follow the pattern /open/files/2026-11-02/region/<PSGC>/projects.csv and /open/files/2026-11-02/lgu/<PSGC>/projects.parquet. The full list is in the manifest. The older single-file downloads are still on /data.
Templates for LGUs and barangays
Free, editable and printable. Each one cites the rule it supports. They are aids, not legal advice; check with your DILG field office for current requirements.
LGU project tracker spreadsheet
For: Cities, municipalities, provinces
Basis: Columns match this site’s open data dictionary
Full Disclosure Policy posting checklist
For: LGUs and barangays
Basis: DILG MC 2010-83 / 2011-134 and the BFDP Annexes
Citizen project monitoring checklist
For: Residents, CSOs, barangay councils
Basis: RA 12009 (New Government Procurement Act) on observers
Freedom of Information request letter
For: Anyone
Basis: 1987 Constitution Art. III Sec. 7; EO 2 s. 2016
Fork the “My LGU / My Barangay” kit
- Copy the kit repository (a static Next.js site; no database or server needed).
- Set your PSGC code in
kit.config.json. Look it up on any LGU page here or in the PSA’s PSGC list. - Run
npm installthennpm run fetch-data. This downloads your LGU’s snapshot files and verifies their checksums. - Run
npm run buildand host theout/folder free on GitHub Pages, Netlify, Cloudflare Pages or any web host. - Add your own barangay or LGU documents (budgets, bid results, project photos) in
content/.
Public repository: coming soon.
Guardrails
Anomalies, not accusations
Indicators are statistical signals that can have innocent explanations. The kit labels them that way and has no option to call anyone guilty.
No private data
Individual sole proprietors are blanked; no submitter, reviewer, contact or personal data is in the API or files (RA 10173, the Data Privacy Act).
Always cite
Every page shows the source dataset, snapshot version and retrieval date, and links back to the original record.
No names beside audit findings
The template never places an official’s name next to a COA observation.
Right of reply
A built-in corrections page tells agencies and contractors how to dispute a record.
Checksum-verified data
The data fetch fails if a file does not match the manifest’s SHA-256.
Licenses and credits
Code: MIT. Data: CC BY 4.0, credit “lovethephilippines.com” and the original government source.
This kit is meant to complement, not compete with, other civic projects. In particular, see BetterGov’s bettergovph/transparency-portal, an MIT-licensed template for building an FY2027 budget transparency portal for an LGU or DPWH district engineering office on the BetterGov.ph Budget API. Theirs covers budgets; this kit covers projects, contractors and anomaly indicators. Use both.