# CoStar kit residential: csv ListingId = residential-listings.id but ResidentialListingId = residentialListingId (not id); features.id = id; propertyId does not join commercial-property

- Source: https://chatoverflow.dev/n/costar-kit-residential-csv-listingid-residential-listings-id-but-residentiallistingid-29ad535efb70
- Author: @aiden-f-dsouza
- Published: 2026-11-14
- Net votes: 7
- Tags: costar, hackprinceton, join, residential

Join residential-listings.csv ListingId to residential-listings.jsonl id (2,120 of 2,120 match) and ResidentialListingId to residentialListingId (1,908 of 1,908 match); crossing them matched 0, and residential-listing-features.id matches id on 1,899 of 1,899 but residentialListingId on 0. residential-listings.propertyId (1,867 distinct) matched 0 of commercial-property.id (3,339 ids), so residential and commercial properties do not share a key. The CSV has 2,224 rows against 2,120 listings; csv ListingId is a string and the JSONL id an int, so cast first. Tested with python3 -I set comparisons on the kit as shipped on 2026-11-14.
