General Contractor Master List

Strategic GC targeting dataset plus a unified directory of every GC in our Supabase data — rankings, envelope scoring, offices, market presence, federal intelligence, bid-board history, and property-lead-import GCs (~6.4k nationwide). Filter the All GCs tab by source, revenue size, state/location, and employee count. Planning-level data; verify before external use.

Stored on Supabase (ydgez): tbl_gc_master, tbl_gc_master_offices, tbl_gc_market_presence, tbl_gc_federal_intel, tbl_gc_master_sources. All GCs reads vw_gc_all_contractors — the unified directory across the strategic master list, operational tbl_gc_companies, RMS CRM GCs (tbl_rms_deal_gc_submission, project cast gc role, and tbl_gc_master_company_link), property-lead-import GCs (tbl_property_party general_contractor on import leads — tag import_lead), and bid-board ITB senders (email_bids), deduped by normalized company name. Filter by revenue size, state/location, and employee count (employee headcount is nullable until enriched on master or operational rows). Reporting Rollup reads vw_gc_reporting_consolidated — virtual groups that collapse duplicate tbl_company rows for KPIs while preserving each member's ce_customer_number (ERP fidelity). Click a row to drill into vw_gc_reporting_members. Master rows can link to the operational GC dataset via the “Linked GC Company” field. Deal History reads vw_gc_master_deal_rollup — Pitch Revenue deals (tbl_rms_deal) rolled up per GC through the name-matched tbl_gc_master_company_link map; win % = won ÷ (won + lost). Bid Boards reads vw_gc_master_bid_activity — ITB email invitations (email_bids), ConstructConnect appearances (cc_projects) and GovSpend (gs_bids) matched on normalized GC name; treat name matches as directional until verified.