Indicator C4 — Schedule / Date Inconsistencies

AI-verified / Na-verify ng AI Data as of October 21, 2026

Schedule / Date Inconsistencies

Completion before start, implausible duration for cost, or future dates marked complete.

This is a statistical anomaly or indicator worth examining — not proof of wrongdoing, fraud, or corruption against any person.

Indicator: contract 23CI0037 (₱48.99M) is recorded as completed in 77 days against 149 planned; similar-cost projects take a median of 239 days, putting it in the fastest 2.5%. This may be due to unusually efficient work, favorable conditions, or an overestimated planned duration.

Public record entityConstruction of Reinforced Concrete Slope Protection along Sapang Balen Creek, Brgy. Santo Rosario, Magalang, to Brgy. Paralayunan, Mabalacat City, Pampanga

LocationMABALACAT CITY (PAMPANGA), PAMPANGA, Region IIIContract 23CI0037

Amount₱48,990,144.99 sumbong source

Only contractors and government agencies named in public procurement records are shown. Private individuals are not named.

Satellite before / after

Esri Wayback · ~0.5 m

Before capture: 2022-01-13 · Maxar

After capture: 2025-11-18 · Vantor

Satellite comparison for public reference — not proof of completion or non-completion.

Imagery may not show small or linear works; no visible change is not evidence of wrongdoing.

Imagery © Esri, Maxar, Earthstar Geographics, and the GIS User Community

Caveats & resolution

Esri World Imagery Wayback (~0.5–1 m); dates are archive release dates, not capture timestamps.
Imagery may not show small or linear works; no visible change is not evidence of wrongdoing.
DPWH coordinates can be approximate; marker shows the imagery center (may be snapped to riverbank/coast).

Disclaimer

Click imagery to enlarge

Loading satellite imagery…

How this was checked

publish · confidence 0.98

Model: gpt-4.1

Prompt: v4

Checked: October 22, 2026

The project was completed in 77 days, which is much faster than both the planned duration (149 days) and the median for similar-cost projects (239 days), placing it in the fastest 2.5%. All relevant figures and record links are present, and the anomaly is clear and checkable. Innocent explanations (e.g., favorable weather, efficient contractor, or overestimated planned duration) are plausible but do not negate the anomaly.

Full AI audit log →

View project record

Submit evidence about this

Named in this indicator? Respond or report an error · Corrections policy

Project completion

Schedule fields from DPWH transparency portal records and the Sumbong sa Pangulo flood-control list — not inferred beyond those columns.

Reported complete (DPWH): 1Ongoing: 0Delayed: 0Status unknown: 0

Project	Prog.	Target end	Actual end	Days late	Status
Construction of Reinforced Concrete Slope Protection along Sapang Balen Creek, Brgy. Santo Rosario, Magalang, to Brgy. Paralayunan, Mabalacat City, Pampanga23CI0037	100%	August 2, 2023	May 22, 2023	No target date from DPWH, so lateness cannot be computed	completedsumbong source

Start: March 6, 2023 · Source fetched October 21, 2026

Rule Definition

Compares start, target, and actual dates from Sumbong with contract cost.

Triggering Data & citations

Contract schedule fields are inconsistent or implausible

{
  "issues": [
    "implausibly_short_duration"
  ],
  "startDate": "2023-03-06T00:00:00.000Z",
  "contractId": "23CI0037",
  "actualEndDate": "2023-05-22T00:00:00.000Z",
  "targetEndDate": "2023-08-01T00:00:00.000Z",
  "contractCostPhp": 48990144.99
}

Source documents

sumbong — https://raw.githubusercontent.com/rukku/sumbongsapangulo.ph-datasets/main/flood_control_projects.geojsonFetched October 21, 2026

Possible Innocent Explanations

Revised dates not yet reflected in Sumbong export
Early completion certificate vs planned start typo
This may be due to unusually efficient work, favorable conditions, or an overestimated planned duration.

Satellite before / after

Project completion

Rule Definition

Triggering Data & citations

Possible Innocent Explanations

Where this project sits