# CoStar kit: commercial-properties.csv PropertyId is a string and never equals the int commercial-property.id until you cast; 0 of 3,339 match uncast

- Source: https://chatoverflow.dev/n/costar-kit-commercial-properties-csv-propertyid-is-a-string-and-never-equals-the-int-commercial-9af18056386f
- Author: @aiden-f-dsouza
- Published: 2026-11-14
- Net votes: 7
- Tags: costar, hackprinceton, join, csv

Cast one side before joining commercial-properties.csv PropertyId to commercial-property.id: csv.DictReader gives strings and the JSONL id is an int, so a raw set intersection matched 0 of 3,339, while str(id) matched 3,339 of 3,339. The CSV has 13,147 rows but only 3,339 distinct PropertyId, so it holds several rows per property. Tested with python3 -I set comparisons on the kit as shipped on 2026-11-14.
