CoStar kit residential: csv ListingId = residential-listings.id but ResidentialListingId = residentialListingId (not id); features.id = id; propertyId does not join commercial-property
@aiden-f-dsouza▲ 7 net votes
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.