DBE / ACDBE IFR Recertification Status Dashboard

State DOT Unified Certification Programs  ·  50 States + DC + Puerto Rico + U.S. Virgin Islands  ·  Interim Final Rule Compliance
Last updated: —
⚠ Sample Data Mode — Set GOOGLE_SHEET_ID in the script to connect live data. See setup instructions in the page source.
—
Previously Certified Firms
—
Firms Recertified
—
National Recertification Rate
—
Jurisdictions w/ Both Goals Reestablished
Recertification Progress by Jurisdiction — click any state for details
Loading map…
% Recertified:
No Data
<25%
25–49%
50–74%
75–89%
90–100%
Selected
Detail View
🗺️
Click any state or territory on the map — or any row in the table — to view full detail here.
—
—
— % Recertified
Previously Certified—
Recertified Firms—
Remaining—
IFR Goal Compliance
Overall Goals Reestablished—
Contract Goals Reestablished—
State / Territory Detail — click any row to highlight on map
State / Territory Prev. Certified Recertified % Complete Overall Goals Contract Goals
About: Tracks DBE and ACDBE recertification progress and goal-setting compliance under the Interim Final Rule (IFR) across all State DOT Unified Certification Programs (UCPs). "Overall Goals" and "Contract Goals" reflect whether the UCP and DOT recipients have reestablished program participation goals as required following completion of the recertification process.  |  Map color = % of previously certified firms that have completed IFR recertification.  |  Data source: State UCP submissions.
⚙ How This Was Built
API Orchestration & Data Architecture

Architected as a cloud-native, zero-dependency intelligence layer — a single deployment artifact with no backend infrastructure required. Compliance data flows from a live Google Sheets API integration, with deterministic fallback logic ensuring the dashboard remains fully operational as a standalone demonstration. All metric calculations — national recertification rates, jurisdiction tallies, goal status aggregations — execute client-side at load time, applying the same precision required to govern compliance data across a 3,200+ node federal infrastructure.

Operational Scale & Coverage
  • 53 jurisdictions tracked: 50 States + DC + Puerto Rico + U.S. Virgin Islands
  • Interim Final Rule (IFR) compliance scope: recertification deadlines and goal reestablishment
  • 4 key metrics per jurisdiction: previously certified firms, recertified firms, recertification rate, overall & contract goal status
  • 5 goal statuses: Yes, No, In Progress, N/A, and Pending
  • Architected to the compliance scope of the FAA Interim Final Rule — the same regulatory framework this tool was designed to operationalize
  • Governance by design: deterministic fallback logic ensures data integrity and consistent output regardless of API state — audit-ready at every load
Cloud-Native Deployment Stack

Orchestrated as a production-grade static deployment — no framework overhead, no build pipeline dependencies. Visualization logic leverages D3.js for SVG-rendered choropleth mapping and TopoJSON for federal boundary topology. Deployed via Netlify's global CDN with instant cold-start performance. The same cloud-native architecture pattern used across the full portfolio stack — engineered for scale, not for demos.

  • Bi-directional sort on all columns with live text search
  • Goal-status and recertification rate range filtering
  • Built through an agentic AI workflow — the same rapid implementation model delivered to clients