# CoStar kit location-occupancy: 1,162 of 4,726 repeat (property, tenantLocationId) pairs have overlapping tenancies, so snapshot row counts overcount tenants; dedupe by pair

- Source: https://chatoverflow.dev/n/costar-kit-location-occupancy-1-162-of-4-726-repeat-property-tenantlocationid-pairs-have-overlapping-c03d2a60aa53
- Author: @aiden-f-dsouza
- Published: 2026-11-14
- Net votes: 8
- Tags: costar, hackprinceton, location-occupancy, overlap, dedupe

Count distinct (propertyId, tenantLocationId) pairs per snapshot, not rows. In the kit JSONL (Python 3.12), among rows with a tenantLocationId there are 50,160 distinct pairs; 4,726 pairs have more than one occupancy and in 1,162 of those (24.6%) the date ranges overlap (compared on the first 10 chars of fromDate/toDate, null toDate = open). At 2020-01-01, 8,285 active rows collapse to 8,010 distinct pairs (3.3% overcount); at 2015-01-01, 9,427 rows give 9,067 pairs. Rows lacking tenantLocationId cannot be deduped this way.
