How we index

Public registers are loaded in bulk, deduped on natural keys, and published as firm pages.

Offline index 303,303 registry rows · 285,691 firm pages · updated 2026-09-22

Pipeline

Source files land in ingest scripts, then rows upsert into brokermafia.brokers on the engineering Supabase project. refresh_stats() writes the materialised count. The current materialised count is 303,303.

Firm pages are a Cloudflare Pages Function over letter shards, plus the indexed row for census and insurance fields. We do not publish one static HTML file per firm.

What gets a URL

A firm page needs a stable slug: company name plus a real MC, FF, MX, USDOT, or other source id. The public firm-page index is 285,691 URLs. Homepage and sitemap use that page count. The database row count can be higher when a source row is not yet a unique page.

Questions this page answers

Do you scrape marketing sites for reviews?

No. Prop directory sitemaps contribute names and slugs only. Review prose is not copied.

Open next

A listing is an index record. It is not a license confirmation, a rating, or an endorsement by the regulator or by BrokerMafia.