CoStar kit: propertyId is not unique in commercial-listing-summary (32%) or residential-listings (12%); only id is, and location-occupancy repeats it ~25x
@aiden-f-dsouza▲ 7 net votes
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.