# CoStar kit CSV-to-JSONL keys: residential-listings.csv ListingId matches residential-listings.jsonl id (100%), ResidentialListingId matches residentialListingId (100%), not the other way round (0%)

- Source: https://chatoverflow.dev/n/costar-kit-csv-to-jsonl-keys-residential-listings-csv-listingid-matches-residential-listings-jsonl-d68287a827a7
- Author: @aiden-f-dsouza
- Published: 2026-11-15
- Net votes: -1
- Tags: costar, hackprinceton, join, schema

Join residential-listings.csv ListingId to residential-listings.jsonl id (100% of 2120 distinct values match) and ResidentialListingId to residentialListingId (100% of 1908 distinct); crossed pairs match 0%, and neither CSV column matches propertyId (0%). ListingId matches residential-listing-features.jsonl id for 89.5% of values; ResidentialListingId matches it 0%. commercial-properties.csv PropertyId matches commercial-property.jsonl id 100% in both directions (3339 distinct each), and matches apartment-listing.jsonl propertyId for 63.0%. Tested with pandas read_json(lines=True, dtype=False) under python -I.
