Data sources

Official feeds we mirror, with live row counts and last refresh from this database. Methodology: how we ingest and link.

DPWH infrastructure projects (transparency portal mirror)

Official URL: https://transparency.dpwh.gov.ph/
Database table: project
Rows in DB: 248,578
Coverage: 2003–2025 (contract start dates)
Last refresh: October 21, 2026

DPWH Transparency Portal (via BetterGov.PH mirror, snapshot 22 Jan 2026). Sumbong sa Pangulo flood-control list (https://raw.githubusercontent.com/rukku/sumbongsapangulo.ph-datasets/main/flood_control_projects.geojson). 3 source_document row(s) tagged sumbong/dpwh.

DBM General Appropriations Act (By-Object Excel)

Official URL: https://www.dbm.gov.ph/wp-content/uploads/GAA/GAA2026/FY2026-GAA-Byobject.xlsx
Database table: appropriation
Rows in DB: 3,160,037
Coverage: FY2020–FY2026
Last refresh: October 21, 2026

Configured download URLs: FY2023: https://www.dbm.gov.ph/wp-content/uploads/GAA/GAA2023/FY2023-GAA-Byobject.xlsx FY2024: https://www.dbm.gov.ph/wp-content/uploads/GAA/GAA2024/FY2024-GAA-Byobject.xlsx FY2025: https://www.dbm.gov.ph/wp-content/uploads/GAA/GAA2025/FY2025-GAA-Byobject.xlsx FY2026: https://www.dbm.gov.ph/wp-content/uploads/GAA/GAA2026/FY2026-GAA-Byobject.xlsx

PhilGEPS procurement awards

Official URL: https://open.philgeps.gov.ph/
Database table: award
Rows in DB: 91,910
Coverage: 2002–2025
Last refresh: October 21, 2026

1 PhilGEPS source documents. Ingest via npm run ingest philgeps <export-url>.

DBM allotment releases (COMPASS / SARO)

Official URL: https://www.dbm.gov.ph/index.php/secretarys-report/allotment-releases
Database table: release
Rows in DB: 224,712
Coverage: See release.fiscal_year in database
Last refresh: October 21, 2026

Commission on Audit observations (AAR extracts)

Official URL: https://www.coa.gov.ph/index.php/reports/annual-audit-reports
Database table: audit_observation
Rows in DB: 16
Coverage: Calendar years in audit_observation.calendar_year
Last refresh: October 21, 2026

Cross-record links (budget ↔ project ↔ award)

Official URL: /methodology#linking
Database table: link
Rows in DB: 33,921
Coverage: Matcher versions stored on link.matcher_version
Last refresh: No source_document fetch timestamp for this feed

Internal derived dataset — not a government feed.

Rule-generated risk indicators

Official URL: /methodology#flags
Database table: flag
Rows in DB: 20,656
Coverage: All rule IDs in methodology catalog
Last refresh: No source_document fetch timestamp for this feed

AI-reviewed via review-flags job; see /review audit log.