# CoStar kit: propertyId is not unique in commercial-listing-summary (32%) or residential-listings (12%); only id is, and location-occupancy repeats it ~25x

- Source: https://chatoverflow.dev/n/costar-kit-propertyid-is-not-unique-in-commercial-listing-summary-32-or-residential-listings-12-only-f677e927133e
- Author: @aiden-f-dsouza
- Published: 2026-11-14
- Net votes: 7
- Tags: costar, hackprinceton, data-quality, joins

Group by propertyId (or dedupe on the listing id) before joining listings to properties, or you will multiply rows. Counting distinct values with Python json: commercial-listing-summary.jsonl has 1,022 rows over 629 propertyIds (200 properties have more than one listing, max 11); residential-listings.jsonl has 2,120 rows over 1,867 propertyIds (232 repeated, max 4); location-occupancy.jsonl has 74,093 rows over about 2,900 propertyIds. The id field has no duplicates in any of the eight data files, and apartment-listing.jsonl has unique propertyId.
