📊 Visual 🏪 Merchant 🔍 Projects Search 🔍 Excluded Flood Control 🏛️ AMO

Total Contractors

Loading...

In system

Processed

Loading...

From scraping

✅ With SEC Data

Loading...

Verified

⚠️ NO SEC Results

Loading...

Suspicious

🔵🟢🟡 Contractor Data Sources Distribution

Venn diagram showing overlap between Flood Control, DIME, and PhilGEPS contractor databases

🔵 Flood Only
-
🟢 DIME Only
-
🟡 PhilGEPS Only
-
🔵🟢 Flood + DIME
-
🔵🟡 Flood + PhilGEPS
-
🟢🟡 DIME + PhilGEPS
-
🔵🟢🟡 All Three
-

Top Contractors by Project Count

📊 Standard Deviation Analysis Chart

Statistical analysis of contractor project counts from SEC database (all contractors across all databases)

-
Total Contractors
-
Mean Projects
-
Std Deviation
-
Outliers

🏪 PhilGEPS Merchant Information

Showing 0 of 0 merchants
Status:
Platinum
Gold
Silver
Red
Company Type:
Corp = Corporation/Incorporated OPC = One Person Corporation Part = Partnership Sole = Sole Proprietorship
Merchant Name Company Type PhilGEPS Number PhilGEPS Expiry Status SEC Number PCAB License PCAB Category Projects
Loading merchants...

🔍 Search Contractor Projects

Search for any contractor and view all their projects across Flood Control, DIME, and PhilGEPS databases

ℹ️ Augmented dataset: Results now include unmatched entries from the 2016–2025 DPWH Microsite infrastructure tracker. These rows appear only when no PhilGEPS contract has been linked yet, giving you a fuller view of public works pipelines.

⚠️ Data Quality Notice
Source databases may contain errors and duplicates. We perform best-effort deduplication and validation, but cannot guarantee 100% accuracy due to:
  • Duplicate contract entries in source databases
  • Same project appearing in multiple databases (Flood/DIME/PhilGEPS overlap)
  • PhilGEPS lacks location data, limiting cross-matching accuracy
  • Inconsistent contractor name formatting across databases
✅ Basic Check: Deduplicated total ≥ any single database total
Quick Search:

🔍 Excluded Flood Control Projects

This tab reveals potential flood control projects from PhilGEPS that are excluded from the Flood Control source (Sumbong sa Pangulo). These contracts mention flood, drainage, canal, or water-related terms but are not present in the official flood control database. The analysis helps uncover infrastructure contracts and contractor patterns that exist in PhilGEPS but are missing from the Flood Control source, revealing potential data gaps and transparency issues in flood control project tracking.

Excluded Contracts

Loading...

Excluded Value

Loading...

Top Excluded Contractor

Loading...

Data Omission Rate

Loading...

👥 Top 20 Excluded Flood Contractors

📊 Excluded Flood Contracts

Loading...
# Project Name Contractor Cost Location Status Dates
Loading excluded flood projects...

🏛️ PCAB AMO Analysis

Analysis of PCAB Authorized Managing Officers (AMOs) who are elected politicians, revealing potential conflicts of interest. Person names are shown only for AMOs matched to politicians in the linked political records. SEC officer and incorporator names are shown in full only for exact political-record matches or when the same person and SEC company are named on the legacy /zarah contractor page. Other names are masked. A name match alone does not establish identity.

Loading AMO analysis data...