Open data

Download the records behind this site as CSV files. Re-posted and re-imported copies are removed, every column names its government source, and each file lists the date we retrieved it. Files are rebuilt offline from our database, so they may trail the live pages by a few days.

  • Cite the government source for each dataset. Our own work (ids, cleaning, deduplication, matching and anomaly indicators) is licensed CC BY 4.0: credit lovethephilippines.com.
  • Anomaly indicators flag unusual patterns worth a closer look. They are not findings of wrongdoing.
  • No personal data: names of individuals, officials, reviewers and people who sent us evidence are left out. Awardee names that look like a person's name are blank.
  • Need a smaller slice? Agency and office award lists have a "Download this list (CSV)" link that keeps your filters.

Last build: 2026-10-28T23:24+08:00 (Philippine time)

Agency awards (PhilGEPS), deduplicated

Download CSV (544.0 MB, gzip)

Every award notice for every published procuring agency, with re-posted copies removed (rows whose duplicate_of is set are excluded; the kept row is the earliest posting).

Rows
4,877,046
Retrieved on
2026-10-28
Source
PhilGEPS (Philippine Government Electronic Procurement System) award notices, https://open.philgeps.gov.ph/
License
Source data: cite the government source above. Our derived work (ids, cleaning, deduplication, matching, indicators): CC BY 4.0, credit lovethephilippines.com.
SHA-256
4d1e60f3b065f33e2185e0ade39f5913fc39b84fb349675ef92597fdae33e1b4
Data dictionary (18 columns)
ColumnTypeMeaningSource
award_iduuidOur stable id; page at /agency-awards/<award_id>Derived by lovethephilippines.com (CC BY 4.0)
agencytextAgency slug on this site (/agencies/<agency>)Derived by lovethephilippines.com (CC BY 4.0)
procuring_officetextProcuring office name as postedPhilGEPS (Philippine Government Electronic Procurement System) award notices, https://open.philgeps.gov.ph/
reference_idtextPhilGEPS reference numberPhilGEPS (Philippine Government Electronic Procurement System) award notices, https://open.philgeps.gov.ph/
contract_notextContract number as postedPhilGEPS (Philippine Government Electronic Procurement System) award notices, https://open.philgeps.gov.ph/
titletextAward / notice titlePhilGEPS (Philippine Government Electronic Procurement System) award notices, https://open.philgeps.gov.ph/
awardee_nametextAwardee as posted; blank when it looks like a personal name (privacy)PhilGEPS (Philippine Government Electronic Procurement System) award notices, https://open.philgeps.gov.ph/
awardee_org_iduuidOur organization id for the awardee; page at /organizations/<id>Derived by lovethephilippines.com (CC BY 4.0)
area_of_deliverytextArea of delivery as postedPhilGEPS (Philippine Government Electronic Procurement System) award notices, https://open.philgeps.gov.ph/
business_categorytextPhilGEPS business categoryPhilGEPS (Philippine Government Electronic Procurement System) award notices, https://open.philgeps.gov.ph/
categorytextProcurement category (goods, infra, consulting)PhilGEPS (Philippine Government Electronic Procurement System) award notices, https://open.philgeps.gov.ph/
infra_typetextInfrastructure sub-type, when classifiedDerived by lovethephilippines.com (CC BY 4.0)
amount_phpnumericContract/award amount in pesosPhilGEPS (Philippine Government Electronic Procurement System) award notices, https://open.philgeps.gov.ph/
award_datedateAward datePhilGEPS (Philippine Government Electronic Procurement System) award notices, https://open.philgeps.gov.ph/
award_statustextAward status as postedPhilGEPS (Philippine Government Electronic Procurement System) award notices, https://open.philgeps.gov.ph/
source_urltextSource file or page the row came fromPhilGEPS (Philippine Government Electronic Procurement System) award notices, https://open.philgeps.gov.ph/
source_dataset_versiontextSource export/version labelDerived by lovethephilippines.com (CC BY 4.0)
source_retrieved_ondateDate we retrieved the source rowDerived by lovethephilippines.com (CC BY 4.0)

DPWH infrastructure projects, deduplicated

Download CSV (34.8 MB, gzip)

DPWH projects as listed on the DPWH Transparency portal, with re-imported copies removed (duplicate_of excluded).

Rows
248,550
Retrieved on
2026-10-28
Source
DPWH Transparency portal, https://transparency.dpwh.gov.ph/
License
Source data: cite the government source above. Our derived work (ids, cleaning, deduplication, matching, indicators): CC BY 4.0, credit lovethephilippines.com.
SHA-256
9a73f97f75ccd1ab8cc2f9f210e3305d056116183128b2988d07a1c2d9b432b2
Data dictionary (24 columns)
ColumnTypeMeaningSource
project_iduuidOur stable id; page at /projects/<project_id>Derived by lovethephilippines.com (CC BY 4.0)
dpwh_contract_idtextDPWH contract idDPWH Transparency portal, https://transparency.dpwh.gov.ph/
titletextProject titleDPWH Transparency portal, https://transparency.dpwh.gov.ph/
statustextStatus as reported by DPWHDPWH Transparency portal, https://transparency.dpwh.gov.ph/
progress_pctintegerPhysical progress % as reported by DPWHDPWH Transparency portal, https://transparency.dpwh.gov.ph/
type_of_worktextType of workDPWH Transparency portal, https://transparency.dpwh.gov.ph/
programtextProgram nameDPWH Transparency portal, https://transparency.dpwh.gov.ph/
source_of_fundstextSource of fundsDPWH Transparency portal, https://transparency.dpwh.gov.ph/
infra_yeartextInfrastructure yearDPWH Transparency portal, https://transparency.dpwh.gov.ph/
regiontextRegion as reportedDPWH Transparency portal, https://transparency.dpwh.gov.ph/
provincetextProvince as reportedDPWH Transparency portal, https://transparency.dpwh.gov.ph/
location_psgctextPSGC code we matched the location toDerived by lovethephilippines.com (CC BY 4.0); codes from PSA Philippine Standard Geographic Code (PSGC), https://psa.gov.ph/classification/psgc
latnumericLatitude as reported (or geocoded, see method)DPWH Transparency portal, https://transparency.dpwh.gov.ph/
lonnumericLongitude as reportedDPWH Transparency portal, https://transparency.dpwh.gov.ph/
abc_phpnumericApproved budget for the contract, pesosDPWH Transparency portal, https://transparency.dpwh.gov.ph/
contract_cost_phpnumericContract cost, pesosDPWH Transparency portal, https://transparency.dpwh.gov.ph/
amount_paid_phpnumericAmount paid as reported, pesosDPWH Transparency portal, https://transparency.dpwh.gov.ph/
award_datetextDate of awardDPWH Transparency portal, https://transparency.dpwh.gov.ph/
start_datedateStart dateDPWH Transparency portal, https://transparency.dpwh.gov.ph/
target_end_datedateTarget completionDPWH Transparency portal, https://transparency.dpwh.gov.ph/
actual_end_datedateActual completionDPWH Transparency portal, https://transparency.dpwh.gov.ph/
contractortextContractor as reported; blank when it looks like a personal nameDPWH Transparency portal, https://transparency.dpwh.gov.ph/
contractor_org_iduuidOur organization id; page at /organizations/<id>Derived by lovethephilippines.com (CC BY 4.0)
source_urltextDPWH portal page for the contractDPWH Transparency portal, https://transparency.dpwh.gov.ph/

General Appropriations Act line items, FY2016-FY2026

Download CSV (132.3 MB, gzip)

GAA line items by department, agency, operating unit, program/PAP, fund and object of expenditure, as parsed from DBM files. Amounts in thousands of pesos, as in the source.

Rows
3,862,273
Retrieved on
2026-10-28
Source
DBM General Appropriations Act, https://www.dbm.gov.ph/index.php/programs-projects/general-appropriations-act
License
Source data: cite the government source above. Our derived work (ids, cleaning, deduplication, matching, indicators): CC BY 4.0, credit lovethephilippines.com.
SHA-256
91c635a2260c375ad43e7345f629db92a997eb32ffa23c6ab58428c5715601b4
Data dictionary (18 columns)
ColumnTypeMeaningSource
appropriation_iduuidOur stable id; page at /appropriations/<id>Derived by lovethephilippines.com (CC BY 4.0)
fiscal_yearintegerGAA fiscal yearDBM General Appropriations Act, https://www.dbm.gov.ph/index.php/programs-projects/general-appropriations-act
department_codetextDepartment codeDBM General Appropriations Act, https://www.dbm.gov.ph/index.php/programs-projects/general-appropriations-act
departmenttextDepartment nameDBM General Appropriations Act, https://www.dbm.gov.ph/index.php/programs-projects/general-appropriations-act
agency_codetextAgency codeDBM General Appropriations Act, https://www.dbm.gov.ph/index.php/programs-projects/general-appropriations-act
agencytextAgency nameDBM General Appropriations Act, https://www.dbm.gov.ph/index.php/programs-projects/general-appropriations-act
uacs_codetextUACS agency code (department+agency)DBM General Appropriations Act, https://www.dbm.gov.ph/index.php/programs-projects/general-appropriations-act
operating_unit_codetextOperating unit codeDBM General Appropriations Act, https://www.dbm.gov.ph/index.php/programs-projects/general-appropriations-act
region_codetextRegion codeDBM General Appropriations Act, https://www.dbm.gov.ph/index.php/programs-projects/general-appropriations-act
programtextProgram / activity / project descriptionDBM General Appropriations Act, https://www.dbm.gov.ph/index.php/programs-projects/general-appropriations-act
program_paptextPAP (program/activity/project) codeDBM General Appropriations Act, https://www.dbm.gov.ph/index.php/programs-projects/general-appropriations-act
fund_codetextFund codeDBM General Appropriations Act, https://www.dbm.gov.ph/index.php/programs-projects/general-appropriations-act
fund_subcategorytextFund sub-categoryDBM General Appropriations Act, https://www.dbm.gov.ph/index.php/programs-projects/general-appropriations-act
expense_classtextExpense class (PS, MOOE, CO, FinEx)DBM General Appropriations Act, https://www.dbm.gov.ph/index.php/programs-projects/general-appropriations-act
object_codetextUACS object codeDBM General Appropriations Act, https://www.dbm.gov.ph/index.php/programs-projects/general-appropriations-act
object_nametextObject of expenditureDBM General Appropriations Act, https://www.dbm.gov.ph/index.php/programs-projects/general-appropriations-act
amount_thousand_phpnumericAppropriation in thousands of pesos (source unit)DBM General Appropriations Act, https://www.dbm.gov.ph/index.php/programs-projects/general-appropriations-act
source_urltextDBM source fileDBM General Appropriations Act, https://www.dbm.gov.ph/index.php/programs-projects/general-appropriations-act

LGU directory and spending counts

Download CSV (1.6 MB, gzip)

Every region, province, city, municipality and barangay (PSGC) with population and the per-source counts and totals shown on LGU pages (own = records located in this LGU; rollup = including LGUs inside it). Officials are not included.

Rows
43,766
Retrieved on
2026-10-28
Source
PSA Philippine Standard Geographic Code (PSGC), https://psa.gov.ph/classification/psgc; counts derived from DPWH Transparency portal, https://transparency.dpwh.gov.ph/, PhilGEPS (Philippine Government Electronic Procurement System) award notices, https://open.philgeps.gov.ph/, DBM General Appropriations Act, https://www.dbm.gov.ph/index.php/programs-projects/general-appropriations-act
License
Source data: cite the government source above. Our derived work (ids, cleaning, deduplication, matching, indicators): CC BY 4.0, credit lovethephilippines.com.
SHA-256
60d9b1aac72afb0bbba683b688577fbae6e62347a077df79acc5bc224634128e
Data dictionary (36 columns)
ColumnTypeMeaningSource
psgctextPSGC codePSA Philippine Standard Geographic Code (PSGC), https://psa.gov.ph/classification/psgc
nametextLGU namePSA Philippine Standard Geographic Code (PSGC), https://psa.gov.ph/classification/psgc
leveltextGeographic levelPSA Philippine Standard Geographic Code (PSGC), https://psa.gov.ph/classification/psgc
slugtextPage at /lgu/<slug>Derived by lovethephilippines.com (CC BY 4.0)
parent_psgctextParent PSGCPSA Philippine Standard Geographic Code (PSGC), https://psa.gov.ph/classification/psgc
region_psgctextRegion PSGCPSA Philippine Standard Geographic Code (PSGC), https://psa.gov.ph/classification/psgc
province_psgctextProvince PSGCPSA Philippine Standard Geographic Code (PSGC), https://psa.gov.ph/classification/psgc
city_classtextCity classPSA Philippine Standard Geographic Code (PSGC), https://psa.gov.ph/classification/psgc
income_classtextIncome classPSA Philippine Standard Geographic Code (PSGC), https://psa.gov.ph/classification/psgc
urban_ruraltextUrban/rural (barangays)PSA Philippine Standard Geographic Code (PSGC), https://psa.gov.ph/classification/psgc
population_2024integer2024 population (POPCEN)PSA Philippine Standard Geographic Code (PSGC), https://psa.gov.ph/classification/psgc
psgc_releasetextPSGC release usedPSA Philippine Standard Geographic Code (PSGC), https://psa.gov.ph/classification/psgc
dpwh_project_own_countnumericDPWH projects: count in this LGUDerived by lovethephilippines.com (CC BY 4.0) from DPWH Transparency portal, https://transparency.dpwh.gov.ph/
dpwh_project_own_total_phpnumericDPWH projects: peso total in this LGUDerived by lovethephilippines.com (CC BY 4.0) from DPWH Transparency portal, https://transparency.dpwh.gov.ph/
dpwh_project_rollup_countnumericDPWH projects: count incl. LGUs insideDerived by lovethephilippines.com (CC BY 4.0) from DPWH Transparency portal, https://transparency.dpwh.gov.ph/
dpwh_project_rollup_total_phpnumericDPWH projects: peso total incl. LGUs insideDerived by lovethephilippines.com (CC BY 4.0) from DPWH Transparency portal, https://transparency.dpwh.gov.ph/
contractors_own_countnumericDPWH contractors active: count in this LGUDerived by lovethephilippines.com (CC BY 4.0) from DPWH Transparency portal, https://transparency.dpwh.gov.ph/
contractors_own_total_phpnumericDPWH contractors active: peso total in this LGUDerived by lovethephilippines.com (CC BY 4.0) from DPWH Transparency portal, https://transparency.dpwh.gov.ph/
contractors_rollup_countnumericDPWH contractors active: count incl. LGUs insideDerived by lovethephilippines.com (CC BY 4.0) from DPWH Transparency portal, https://transparency.dpwh.gov.ph/
contractors_rollup_total_phpnumericDPWH contractors active: peso total incl. LGUs insideDerived by lovethephilippines.com (CC BY 4.0) from DPWH Transparency portal, https://transparency.dpwh.gov.ph/
gaa_own_countnumericGAA line items tagged to this place: count in this LGUDerived by lovethephilippines.com (CC BY 4.0) from DBM General Appropriations Act, https://www.dbm.gov.ph/index.php/programs-projects/general-appropriations-act
gaa_own_total_phpnumericGAA line items tagged to this place: peso total in this LGUDerived by lovethephilippines.com (CC BY 4.0) from DBM General Appropriations Act, https://www.dbm.gov.ph/index.php/programs-projects/general-appropriations-act
gaa_rollup_countnumericGAA line items tagged to this place: count incl. LGUs insideDerived by lovethephilippines.com (CC BY 4.0) from DBM General Appropriations Act, https://www.dbm.gov.ph/index.php/programs-projects/general-appropriations-act
gaa_rollup_total_phpnumericGAA line items tagged to this place: peso total incl. LGUs insideDerived by lovethephilippines.com (CC BY 4.0) from DBM General Appropriations Act, https://www.dbm.gov.ph/index.php/programs-projects/general-appropriations-act
lgsf_own_countnumericLGSF projects: count in this LGUDerived by lovethephilippines.com (CC BY 4.0) from DBM Local Government Support Fund
lgsf_own_total_phpnumericLGSF projects: peso total in this LGUDerived by lovethephilippines.com (CC BY 4.0) from DBM Local Government Support Fund
lgsf_rollup_countnumericLGSF projects: count incl. LGUs insideDerived by lovethephilippines.com (CC BY 4.0) from DBM Local Government Support Fund
lgsf_rollup_total_phpnumericLGSF projects: peso total incl. LGUs insideDerived by lovethephilippines.com (CC BY 4.0) from DBM Local Government Support Fund
philgeps_lgu_buyer_own_countnumericPhilGEPS awards where this LGU is the buyer: count in this LGUDerived by lovethephilippines.com (CC BY 4.0) from PhilGEPS (Philippine Government Electronic Procurement System) award notices, https://open.philgeps.gov.ph/
philgeps_lgu_buyer_own_total_phpnumericPhilGEPS awards where this LGU is the buyer: peso total in this LGUDerived by lovethephilippines.com (CC BY 4.0) from PhilGEPS (Philippine Government Electronic Procurement System) award notices, https://open.philgeps.gov.ph/
philgeps_lgu_buyer_rollup_countnumericPhilGEPS awards where this LGU is the buyer: count incl. LGUs insideDerived by lovethephilippines.com (CC BY 4.0) from PhilGEPS (Philippine Government Electronic Procurement System) award notices, https://open.philgeps.gov.ph/
philgeps_lgu_buyer_rollup_total_phpnumericPhilGEPS awards where this LGU is the buyer: peso total incl. LGUs insideDerived by lovethephilippines.com (CC BY 4.0) from PhilGEPS (Philippine Government Electronic Procurement System) award notices, https://open.philgeps.gov.ph/
published_flags_own_countnumericPublished anomaly indicators: count in this LGUDerived by lovethephilippines.com (CC BY 4.0) from Derived by lovethephilippines.com (CC BY 4.0)
published_flags_own_total_phpnumericPublished anomaly indicators: peso total in this LGUDerived by lovethephilippines.com (CC BY 4.0) from Derived by lovethephilippines.com (CC BY 4.0)
published_flags_rollup_countnumericPublished anomaly indicators: count incl. LGUs insideDerived by lovethephilippines.com (CC BY 4.0) from Derived by lovethephilippines.com (CC BY 4.0)
published_flags_rollup_total_phpnumericPublished anomaly indicators: peso total incl. LGUs insideDerived by lovethephilippines.com (CC BY 4.0) from Derived by lovethephilippines.com (CC BY 4.0)

Published anomaly indicators

Download CSV (201 KB, gzip)

Records that a published, reviewed rule flagged as unusual. An indicator is a statistical pattern worth a closer look, not a finding of wrongdoing. Pending and rejected flags, reviewer identities and evidence are not included.

Rows
3,883
Retrieved on
2026-10-28
Source
Derived by lovethephilippines.com (CC BY 4.0); computed from DPWH Transparency portal, https://transparency.dpwh.gov.ph/ and PhilGEPS (Philippine Government Electronic Procurement System) award notices, https://open.philgeps.gov.ph/
License
Source data: cite the government source above. Our derived work (ids, cleaning, deduplication, matching, indicators): CC BY 4.0, credit lovethephilippines.com.
SHA-256
384c0a32af25aacf3be5da7f95bf36d9c9b6f4dd2fe2d0334a32fe74affbe0c5
Data dictionary (9 columns)
ColumnTypeMeaningSource
flag_iduuidOur flag idDerived by lovethephilippines.com (CC BY 4.0)
rule_idtextRule code (see methodology)Derived by lovethephilippines.com (CC BY 4.0)
rule_titletextRule nameDerived by lovethephilippines.com (CC BY 4.0)
subject_typetextWhat is flagged (project, agency_award, organization, office)Derived by lovethephilippines.com (CC BY 4.0)
subject_iduuidId of the flagged recordDerived by lovethephilippines.com (CC BY 4.0)
severityinteger1 (low) to 5 (high), rule-definedDerived by lovethephilippines.com (CC BY 4.0)
published_ondateDate the indicator was publishedDerived by lovethephilippines.com (CC BY 4.0)
indicator_urltextPublic page for this indicator, with the evidence summary and contextDerived by lovethephilippines.com (CC BY 4.0)
method_urltextMethod note for the ruleDerived by lovethephilippines.com (CC BY 4.0)
Method notes for each indicator
  • A1 · DepEd/DOH Award Far Above Office Peers

    A PhilGEPS award is at least 50× the median of the same office's awards in the same business category and year. Compares each DepEd/DOH award with the median of the same procuring office, PhilGEPS business category and year (≥15 peer awards, award ≥₱20M). Reviewers reject cases where the title explains the scale (annual or consolidated supply, major equipment, works).

    Why this may be innocent: Award notices list no quantities, so a large order can explain the gap.

  • A2 · DepEd/DOH Office Awardee Concentration

    One supplier received at least 40% of a procuring office's PhilGEPS award value over three years. Office must have ≥₱50M, ≥30 awards and ≥5 suppliers in the window; the supplier ≥5 awards. Severity rises at 60%.

    Why this may be innocent: May reflect a specialised or thin local market, not favouritism.

  • A3 · Awards Clustered Just Under the Small Value Procurement Ceiling

    3+ awards from one office to one supplier within 30 days, each 85–100% of the SVP ceiling, combined above it. SVP ceiling in force on the award date: ₱500,000 (2009 IRR of RA 9184, Annex H), ₱1,000,000 (2016 Revised IRR, Annex H), ₱2,000,000 (IRR of RA 12009, Sec. 34). Splitting contracts to avoid competitive bidding is prohibited under the IRR.

    Why this may be innocent: Separate requisitions or recurring needs can legitimately fall near the ceiling.

  • A4 · December Award Spike

    At least half of an office's yearly PhilGEPS award value was awarded in December, at least twice its usual December share. Requires ≥₱20M awarded in December, ≥30 awards that year and ≥5 years of office history; compared with the office's own median December share.

    Why this may be innocent: Year-end awarding often follows budget release timing; it is not by itself improper.

  • A5 · Supplier Across Separately Licensed Lines

    One supplier won DepEd/DOH infrastructure works and drugs/medicines awards (≥₱5M each) plus many unrelated categories. Construction requires a PCAB licence and drug distribution an FDA licence; the rule surfaces suppliers active in both.

    Why this may be innocent: A supplier may hold both licences; this is a prompt to check, not a finding.

  • A6 · Low-Graded DPWH Contractor Winning DepEd/DOH Works

    A contractor with a D or F record grade on this site won DepEd/DOH infrastructure awards. Exact name match between the graded organisation and the PhilGEPS awardee. Grades summarise public DPWH project data.

    Why this may be innocent: The grade is this site's summary, not a government blacklist or sanction.

  • R1 · Single Bidder in Competitive Tender

    PhilGEPS award shows only one bidder in an open or competitive mode. Flags procurement awards where num_bidders = 1 and mode indicates competitive bidding.

    Why this may be innocent: Unusual for competitive modes; may reflect a thin market, not wrongdoing.

  • R2 · Award Amount Near Approved Budget for Contract

    Winning bid is within a narrow band of the approved budget for contract (ABC). Compares award amount to ABC where both are present in PhilGEPS records.

    Why this may be innocent: Award ≈ ABC can mean accurate estimates or weak competition.

  • R4 · Supplier Concentration

    A contractor wins a high share of awards in a region or agency. Aggregates awards by contractor and implementing agency over a rolling window.

    Why this may be innocent: High share may reflect specialization, not collusion.

  • R6 · Price Outlier for Project Type

    Project contract cost exceeds the 95th percentile for the same type of work. Uses DPWH/Sumbong project costs grouped by type_of_work; compares each project to the cohort p95.

    Why this may be innocent: Cost above peers may reflect site conditions or classification limits.

  • X3 · Stalled Project (No Progress)

    Past target completion without published physical progress. Projects past target_end_date with null or zero progress_pct in source data.

    Why this may be innocent: May be delay, suspension, or missing progress reporting in Sumbong.

  • C1 · Contractor Concentration (Flood Control)

    A contractor holds a very large share of flood-control contract value in a district or province. Share of contract value by contractor within DEO or province; flags top share > 40% or elevated HHI.

    Why this may be innocent: Concentration is a market-structure signal, not proof of favoritism.

  • C2 · Awards Very Close to the Budget Ceiling

    Contract cost is at or above 99.5% of ABC from Sumbong. ContractCost / ABC ≥ 0.995 using metadata.abc and contract cost fields.

    Why this may be innocent: Suggests limited price competition; verify against bid documents.

  • C3 · Duplicate or Near-Duplicate Projects

    Very similar descriptions within ~100m or identical coordinates across contracts/years. Title similarity + distance or shared coordinates within municipality.

    Why this may be innocent: May be phased works, components, or geocoding overlap.

  • C4 · Schedule / Date Inconsistencies

    Completion before start, implausible duration for cost, or future dates marked complete. Compares start, target, and actual dates from Sumbong with contract cost.

    Why this may be innocent: Often data-entry errors in published GeoJSON.

  • C5 · Pattern Consistent with Contract Splitting

    Multiple similar contracts to the same contractor/DEO just under a threshold in a short window. ≥3 contracts within 120 days, each 85–100% of ₱50M threshold, similar titles.

    Why this may be innocent: Pattern only; legitimate multi-lot awards exist.

  • C6 · Location Could Not Be Confirmed

    Coordinates offshore or heavily reused pins vs stated location. PH bounding box and shared-coordinate clusters from lat/lon fields.

    Why this may be innocent: GIS quality issue until validated on the ground.

  • C7 · High Concurrent Workload for One Contractor

    Contractor linked to many simultaneous projects or very high total value vs peers. Active project count and total value vs peer 95th percentile.

    Why this may be innocent: Capacity strain is operational risk, not fraud by itself.

  • X-source · Cross-Source Mismatch (PhilGEPS vs DPWH)

    Linked PhilGEPS award amount or awardee disagrees with Sumbong contract row. Compares linked award and project contractor/cost above tolerance.

    Why this may be innocent: May be linkage error, JV naming, or post-award change order.

Treasury cash operations and debt service

Download CSV (2 KB, gzip)

Monthly national government revenues, expenditures, financing and debt service lines as published by the Bureau of the Treasury, in PHP million.

Rows
45
Retrieved on
2026-10-28
Source
Bureau of the Treasury Cash Operations Report (https://www.treasury.gov.ph/)
License
Source data: cite the government source above. Our derived work (ids, cleaning, deduplication, matching, indicators): CC BY 4.0, credit lovethephilippines.com.
SHA-256
9d73657a11c75aaf2a6ca0c2003db30c14cdb91fce3c48a73f3fec65fcf3b975
Data dictionary (19 columns)
ColumnTypeMeaningSource
reporttextReport table (summary, debt_service, ...)Bureau of the Treasury Cash Operations Report (https://www.treasury.gov.ph/)
yearintegerYearBureau of the Treasury Cash Operations Report (https://www.treasury.gov.ph/)
line_nointegerLine order in the reportBureau of the Treasury Cash Operations Report (https://www.treasury.gov.ph/)
labeltextLine label as publishedBureau of the Treasury Cash Operations Report (https://www.treasury.gov.ph/)
depthintegerIndent level in the reportBureau of the Treasury Cash Operations Report (https://www.treasury.gov.ph/)
jan_php_mnnumericJan amount, PHP millionBureau of the Treasury Cash Operations Report (https://www.treasury.gov.ph/)
feb_php_mnnumericFeb amount, PHP millionBureau of the Treasury Cash Operations Report (https://www.treasury.gov.ph/)
mar_php_mnnumericMar amount, PHP millionBureau of the Treasury Cash Operations Report (https://www.treasury.gov.ph/)
apr_php_mnnumericApr amount, PHP millionBureau of the Treasury Cash Operations Report (https://www.treasury.gov.ph/)
may_php_mnnumericMay amount, PHP millionBureau of the Treasury Cash Operations Report (https://www.treasury.gov.ph/)
jun_php_mnnumericJun amount, PHP millionBureau of the Treasury Cash Operations Report (https://www.treasury.gov.ph/)
jul_php_mnnumericJul amount, PHP millionBureau of the Treasury Cash Operations Report (https://www.treasury.gov.ph/)
aug_php_mnnumericAug amount, PHP millionBureau of the Treasury Cash Operations Report (https://www.treasury.gov.ph/)
sep_php_mnnumericSep amount, PHP millionBureau of the Treasury Cash Operations Report (https://www.treasury.gov.ph/)
oct_php_mnnumericOct amount, PHP millionBureau of the Treasury Cash Operations Report (https://www.treasury.gov.ph/)
nov_php_mnnumericNov amount, PHP millionBureau of the Treasury Cash Operations Report (https://www.treasury.gov.ph/)
dec_php_mnnumericDec amount, PHP millionBureau of the Treasury Cash Operations Report (https://www.treasury.gov.ph/)
total_php_mnnumericTotal, PHP millionBureau of the Treasury Cash Operations Report (https://www.treasury.gov.ph/)
source_file_urltextSource fileBureau of the Treasury Cash Operations Report (https://www.treasury.gov.ph/)

BIR collections by region, revenue district and LGU

Download CSV (15 KB, gzip)

Monthly BIR collections by collection unit as published, in PHP million, with the PSGC places each unit covers as matched by lovethephilippines.com. Units combined into another row point to it.

Rows
145
Retrieved on
2026-10-28
Source
Bureau of Internal Revenue collection statistics (https://www.bir.gov.ph/); PSGC matching by lovethephilippines.com
License
Source data: cite the government source above. Our derived work (ids, cleaning, deduplication, matching, indicators): CC BY 4.0, credit lovethephilippines.com.
SHA-256
5340dcf6bc139031f3766ed14e8e099c01699c8666f546a2f577b2c0d57bed9a
Data dictionary (22 columns)
ColumnTypeMeaningSource
yearintegerYearBureau of Internal Revenue collection statistics (https://www.bir.gov.ph/)
row_nointegerRow in the BIR tableBureau of Internal Revenue collection statistics (https://www.bir.gov.ph/)
kindtextUnit kind (region, district, ...)Bureau of Internal Revenue collection statistics (https://www.bir.gov.ph/)
nametextCollection unit nameBureau of Internal Revenue collection statistics (https://www.bir.gov.ph/)
footnotetextBIR footnoteBureau of Internal Revenue collection statistics (https://www.bir.gov.ph/)
combined_with_rowintegerRow this unit is reported insideBureau of Internal Revenue collection statistics (https://www.bir.gov.ph/)
jan_php_mnnumericJan amount, PHP millionBureau of Internal Revenue collection statistics (https://www.bir.gov.ph/)
feb_php_mnnumericFeb amount, PHP millionBureau of Internal Revenue collection statistics (https://www.bir.gov.ph/)
mar_php_mnnumericMar amount, PHP millionBureau of Internal Revenue collection statistics (https://www.bir.gov.ph/)
apr_php_mnnumericApr amount, PHP millionBureau of Internal Revenue collection statistics (https://www.bir.gov.ph/)
may_php_mnnumericMay amount, PHP millionBureau of Internal Revenue collection statistics (https://www.bir.gov.ph/)
jun_php_mnnumericJun amount, PHP millionBureau of Internal Revenue collection statistics (https://www.bir.gov.ph/)
jul_php_mnnumericJul amount, PHP millionBureau of Internal Revenue collection statistics (https://www.bir.gov.ph/)
aug_php_mnnumericAug amount, PHP millionBureau of Internal Revenue collection statistics (https://www.bir.gov.ph/)
sep_php_mnnumericSep amount, PHP millionBureau of Internal Revenue collection statistics (https://www.bir.gov.ph/)
oct_php_mnnumericOct amount, PHP millionBureau of Internal Revenue collection statistics (https://www.bir.gov.ph/)
nov_php_mnnumericNov amount, PHP millionBureau of Internal Revenue collection statistics (https://www.bir.gov.ph/)
dec_php_mnnumericDec amount, PHP millionBureau of Internal Revenue collection statistics (https://www.bir.gov.ph/)
ytd_php_mnnumericYear to date, PHP millionBureau of Internal Revenue collection statistics (https://www.bir.gov.ph/)
period_labeltextPeriod coveredBureau of Internal Revenue collection statistics (https://www.bir.gov.ph/)
psgcstextPSGC codes this unit covers (semicolon-separated)Derived by lovethephilippines.com (CC BY 4.0)
source_file_urltextSource fileBureau of Internal Revenue collection statistics (https://www.bir.gov.ph/)

See also data sources and methodology.