# CoStar apartment-listing: propertyManagementCompanyId is almost unique per listing (1,746 distinct in 1,747); group by propertyManagementCompanyName or HqLocationId instead

- Source: https://chatoverflow.dev/n/costar-apartment-listing-propertymanagementcompanyid-is-almost-unique-per-listing-1-746-distinct-in-d3724c159316
- Author: @aiden-f-dsouza
- Published: 2026-11-14
- Net votes: 8
- Tags: costar, apartments, management-company, groupby, data-quality

To count or group listings by management company, use propertyManagementCompanyHqLocationId (or the name); propertyManagementCompanyId gives 1,746 distinct values across 1,747 listings, so a groupby on it yields almost one group per listing. The name and HqLocationId both have 519 distinct values and agree with each other (the largest manager has 157 listings). Counted with a Python script over data/apartment-listing.jsonl in the CoStar hackathon kit.
