📊 Data Sources

Comprehensive list of all data sources used in BetterGovPH visualizations

🏛️ Primary Government Data Sources

  • Budget Data (GAA - General Appropriations Act):
    @bettergovph/open-budget-data
    Open Budget by BetterGov.ph
    Used in: Budget Analysis, Budget-NEP Correlation, Budget-Flood Correlation
  • 2026 Senate Committee Report No. 18 on House Bill No. 4058 (FY 2026 GAB):
    Senate Committee Report No. 18 on House Bill No. 4058 (FY 2026 General Appropriations Bill) - Sen. Win Gatchalian
    Used in: Budget Analysis, FY 2026 GAB Analysis
  • Senate Budget Transparency Portal:
    budget-transparency-portal.senate.gov.ph
    Official repository of Senate budget documents and committee reports.
  • National Expenditure Program (NEP):
    @bettergovph/open-budget-data
    Open Budget by BetterGov.ph
    Used in: NEP Analysis, Budget-NEP Correlation
  • Flood Control Projects (DPWH):
    the team from extra.bayanwat.ch
    Sumbong sa Pangulo - Flood Control Map
    BetterGov.ph - Flood Control Projects Map
    Used in: Flood Control Analysis, Interactive Map, Budget-Flood Correlation, Flood-DIME Correlation
  • DILG Projects (Barangay Details):
    the team from extra.bayanwat.ch
    Used in: Barangay-level Analysis, Local Government Projects
  • DIME (Digital Information for Monitoring and Evaluation):
    Department of Budget and Management
    Used in: DIME Infrastructure Analysis, Interactive Map, Flood-DIME Correlation
  • PhilGEPS Contract Data:
    @gabconcepcionph/dpwh-contracts-dashboard
    @csiiiv/philgeps-awards-dashboard
    Used in: Interactive Map, Contractor Verification
    Comprehensive transparency dashboard providing access to Philippine government procurement data from 2013-2025
  • DPWH Integrated Project Code Classification (DO 172 s2016):
    DO 172 s2016 - Integrated Project Code Classification Rules
    Used in: Project Code Decoding, District/Region Classification
    Official DPWH Department Order defining the integrated project code format (YYRDSSSS) and rules for classifying projects into regions and districts. Format: YY (Year) + R (Region letter) + D (District letter) + SSSS (Sequence).
  • DPWH Project Code Mapping:
    Mapping file (dpwh-project-code-mapping.json) containing region letters to region names and district letters to District Engineering Office (DEO) names for all DPWH regions.
    Used in: Project Code Decoding, District/Region Classification, DEO Name Resolution
    Credit: @csiiiv - Comprehensive mapping of integrated project codes to regions and DEOs
  • Raw Philippine Data (Persons, Memberships & Legislative Documents):
    BetterGovPH Raw Philippine Data on HuggingFace
    Used in: Semantic Search, Political Analysis, Legislative Document Research
    Comprehensive dataset containing 45,400+ persons (politicians and public officials), 86,200+ memberships (political positions and party affiliations), and legislative documents (Senate and House bills). Available in Parquet format for easy analysis and DuckDB for SQL queries. Licensed under CC0 1.0 Universal (Public Domain).
  • Political Dynasty Data:
    Ateneo School of Government (ASoG) - Participate Project
    Used in: Dynasty Analysis, Dynasty Map, Family Tree Visualization
    Comprehensive dataset tracking political dynasties at the local government level (2004-2016) with 86,234 records across all provinces. Data accuracy and consistency are the responsibility of the original ASoG source.
  • Philippines GeoJSON Data:
    OSSPhilippines/geoph
    Used in: Dynasty Map, Province Boundaries, Interactive Visualizations
    Open source GeoJSON data formats for the Philippines, providing accurate province and regional boundaries for mapping
  • Congressional District Mappings:
    Comprehensive congressional district mappings for Philippine provinces and cities. For provinces, municipalities are mapped to their respective congressional districts (397 of 417 non-partylist congressmen, 95.2% coverage). For cities, barangays are mapped using official PSGC data (136 cities with 7,418 barangays). Data combines official government sources with geographic boundary data from OSSPhilippines/geoph.
    Used in: District Analysis, Dynasty Projects, Province-District Filtering, Municipality-District Mapping, Congressman Project Matching
    Credit: Philippine Statistics Authority (PSA) - Philippine Standard Geographic Code (PSGC) for official municipality and barangay listings, Commission on Elections (COMELEC) - Official congressional district boundaries and electoral district maps, House of Representatives - Congressional district assignments and representative listings (17th-20th Congress, 2016-2025), OSSPhilippines/geoph - Geographic boundary data for barangays and municipalities, PhilAtlas - District, municipality, and barangay reference data. Additional data from @klescosia/ph-elections2025, @flores-jacob, and Wikipedia: 20th Congress.
  • SEC (Securities and Exchange Commission):
    SEC Philippines - Check with SEC
    Used in: SEC Contractors Database, Interactive Map
  • PhilGEPS Merchant Information:
    PhilGEPS Open Data - Merchant Information
    Used in: Contractor Registration Details, Merchant Verification
    Provides registration details and eligibility status for contractors registered in the PhilGEPS system. Data is queried using normalized contractor names from our database to extract registration information and compliance status.
  • Political Dynasty Network (Dynasty5):
    Dynasty5 Network Visualization
    Used in: Dynasty Analysis, Political Network Visualization
    Interactive network visualization of political dynasty relationships across regions in the Philippines, sourced from Ateneo School of Government (ASoG) Participate Project and Philippine Statistics Authority poverty data

🤝 Civil Society and Research Organizations

  • People's Budget Coalition (PBC):
    Comprehensive analysis of DPWH budget programs (2018-2025) and 2026 Budget Analysis (GAB 2026). Used in: Budget-NEP Program Correlation, Program-level Analysis, and NEP → GAB 2026 tab.
    Credit: People's Budget Coalition (PBC) - Citizens' Budget Tracker
  • Senator Relationships Data:
    Additional senator family relationships data extracted from OCR images. Used in: Dynasty Analysis, Relationship Constellations.
    Credit: inyongmaasahan ([email protected])
  • Kontra Daya Party-List Analysis (2025):
    Kontra Daya Report on 2025 Midterm Elections
    Used in: Dynasty Analysis, Relationship Constellations, Party-List Contractor Connections
    Election watchdog report documenting party-list groups linked to political dynasties and contractors, including FPJ Partylist connections to Grace Poe staff and Patron family contractors (V.R. PATRON BUILDERS).
  • Contractor-Dynasty Relationship Data:
    Investigative data on construction companies and contractors linked to political dynasties. Used in: Dynasty Analysis, Relationship Constellations, Contractor Connections.
    Credit: Rappler, Philippine Daily Inquirer, Manila Standard, Manila Times, Wikipedia, Bilyonaryo, Philippine Star, ABS-CBN, PCIJ, PeoPlaid, DOF Philippines, VOV Philippines - Investigative reporting and reference materials used to validate contractor-family linkages.
  • InfraWatch Augmented Projects (2016-2025):
    Supplemental infrastructure records used to highlight projects without matching PhilGEPS contracts and to enrich `/philgeps` search results.
    Credit: DPWH Infrastructure Status Microsite
  • DPWH Infrastructure Projects Data Pipeline:
    @csiiiv/dpwh-infra-data-scraper
    @csiiiv/dpwh-transparency-data-api-scraper
    DPWH Transparency Portal
    Automated scraping and parsing pipeline that converts DPWH infrastructure project tables into structured CSV datasets, providing contract coverage from 2016-2025 for validation of InfraWatch red-flag indicators.
    Used in: Infrastructure Project Analysis, Contract Validation, InfraWatch Red-Flag Indicators
    Credit: @csiiiv - Comprehensive web scraping and data extraction pipeline for DPWH infrastructure contract data
  • DPWH Project Code Mapping (dpwh-project-code-mapping.json):
    Comprehensive JSON mapping file containing region letters to region names and district letters to District Engineering Office (DEO) names for all DPWH regions. Enables decoding of integrated project codes (YYRDSSSS format) into human-readable region and DEO classifications.
    Used in: Project Code Decoding, District/Region Classification, DEO Name Resolution
    Credit: @csiiiv - Comprehensive mapping of integrated project codes to regions and DEOs
  • Flood Project Red Flag Classification:
    Additional flood project risk indicators and qualitative assessments layered onto DPWH datasets to surface red-flag items in `/flood` dashboards.
    Credit: UP-NCPAG GRIT Labs (NCPAGKilatis)

📅 Data Coverage & Range

  • Budget Data (GAA): 2020-2025 government budget allocations
  • NEP Data: 2020-2025 expenditure programs
  • Flood Control Projects: Multi-year DPWH infrastructure projects
  • DIME Projects: 2016-2026 infrastructure monitoring data
  • Contractor Data: Active SEC-registered contractors with government projects
  • Raw Philippine Data: 2004-2016 political memberships, legislative documents (various congress sessions)
  • Political Dynasty Data: 2004-2016 local government political dynasty records
  • Congressional District Mappings: Working coverage of 85 provinces and 22 cities with municipality-to-district and barangay-to-district mappings across 256 districts (7,418 barangays) supporting 416 of 417 non-partylist congressmen (99.8% coverage)

📈 Dataset Statistics

  • Budget Line Items: Comprehensive nationwide budget allocations
  • NEP Items: Detailed expenditure program entries
  • Flood Control Projects: DPWH flood control infrastructure nationwide
  • DIME Projects: 12,870+ major infrastructure projects worth ₱740B+
  • SEC Contractors: 2,100+ verified contractors with SEC registration data
  • PhilGEPS Data: Philippine government procurement data from 2000-2025, providing comprehensive transparency on contract awards and government transactions
  • Raw Philippine Data: 45,400+ persons, 86,200+ political memberships, and legislative documents (Senate and House bills) available for semantic search and analysis
  • Political Dynasty Records: 86,234 political dynasty records across all 82 provinces (2004-2016)
  • GeoJSON Boundaries: Complete province and regional boundary data for interactive mapping
  • Congressional District Mappings: 256 districts mapped across 85 provinces and 22 cities, with municipality-to-district and barangay-to-district coverage (7,418 barangays) supporting 416 of 417 non-partylist congressmen (99.8% coverage)

🔬 Methodology & Processing

All data undergoes rigorous processing to ensure accuracy and usability:

  • Data Cleaning: Removal of duplicates, standardization of formats, and validation of entries
  • Fuzzy Matching: Advanced string matching algorithms to correlate contractor names across different datasets
  • Geolocation: Coordinate validation and mapping for spatial analysis
  • SEC Verification: Automated scraping and verification of contractor registrations
  • Correlation Analysis: Cross-referencing datasets to identify patterns and ensure consistency

📚 Academic References

Our corruption risk analysis is based on peer-reviewed academic research:

  • EOGO Corruption Risk Analysis:
    "Corruption risk and political dynasties: exploring the links using public procurement data in the Philippines"
    Authors: Daniel Bruno Davis, Ronald U. Mendoza, Jurel K. Yap
    Journal: Economics of Governance (2023)
    DOI: https://doi.org/10.1007/s10101-023-00306-4
    Used in: EOGO Corruption Risk Analysis, Political Dynasty Impact Assessment, CRI Implementation

💻 Open Source & Transparency

All source code and data processing scripts are publicly available:

🤝 Contact & Contributions

We welcome contributions, corrections, and suggestions to improve data quality and transparency.

For questions about data sources or to report issues, please visit our GitHub repository or contact the maintainers.