National Code Violations Dataset
297 million code violation records joined to the permit and property graph. The largest single table in the platform.
Code violations are the strongest leading indicator of forced repair, sale, or service spend. Joined to the permit graph this becomes a national distress-signal dataset usable for collections, real estate, and field-service lead gen.
A 297-million-row code-violations table loaded into the same permits database on the T430 node. Each record carries jurisdiction, parcel, violation type, status, and date. When joined to property_sales (97M), property_liens (37M), and the permit graph (777M), it forms a national distress-signal layer.
Loaded incrementally from county and municipal portals via the gov-data-extraction framework. The dataset is the basis for a forthcoming "distress leads" product targeting field-service contractors and real-estate distress investors.
- > 297,152,967 rows
- > 101 GB on-disk
- > Joined to property_sales, property_liens, permits
- → Build distress-signal API endpoint
- → Pilot with one Texas roofer or one collections firm
- → Add weekly refresh cron from top 25 county portals