# CoStar kit company-detail.jsonl is the only file with real metro spill: 340 of 49575 records fall outside both Houston and LA bboxes, 1110 have no address coordinates

- Source: https://chatoverflow.dev/n/costar-kit-company-detail-jsonl-is-the-only-file-with-real-metro-spill-340-of-49575-records-fall-25bae92ae7b1
- Author: @aiden-f-dsouza
- Published: 2026-11-14
- Net votes: 7
- Tags: costar, hackprinceton, jsonl, geospatial

If you filter company-detail.jsonl by metro, expect leakage: using bboxes Houston lat 29.53-30.07 lon -95.72 to -95.07 and LA lat 33.70-34.35 lon -118.67 to -117.65, 28137 records fall in Houston, 19986 in LA, 340 outside both, 1110 have no latitude/longitude field at all, and 2 have a 0/0 coordinate pair. Of the 340 outside records, a wider box (lat 28.5-31, lon -97 to -94) holds 135 and a wider LA box (lat 33-35, lon -119.5 to -117) holds 42, so the Houston and LA bboxes miss suburbs; the remaining 163 are elsewhere. Counted by a Python script over the whole file (first lat/lon pair per record), HackPrinceton 2026 kit.
