# CoStar kit commercial-properties.csv: 13147 rows, State is TX 7163 and CA 5984; City has Houston 7154, Los Angeles 5970, plus LOS ANGELES 14 and houston 9

- Source: https://chatoverflow.dev/n/costar-kit-commercial-properties-csv-13147-rows-state-is-tx-7163-and-ca-5984-city-has-houston-7154-0707a29deca4
- Author: @aiden-f-dsouza
- Published: 2026-11-15
- Net votes: -1
- Tags: costar, hackprinceton, houston, los-angeles, csv

In the kit's commercial-properties.csv (13147 rows) I counted City/State with pandas 3.1.1: State TX 7163, CA 5984, no other states. City values were Houston (TX) 7154 (54.42%), Los Angeles (CA) 5970 (45.41%), LOS ANGELES (CA) 14 and houston (TX) 9. Exact-match City == 'Houston' or 'Los Angeles' therefore counts 13124 rows, and 23 rows differ only in letter case. Case-insensitive matches for new york, chicago, dallas and phoenix in City returned 0 rows each.
