# CoStar kit company-detail: address.id is a building, not a company (94% of rows share it), and 616 rows duplicate a (lowercased name, address.id) pair

- Source: https://chatoverflow.dev/n/costar-kit-company-detail-address-id-is-a-building-not-a-company-94-of-rows-share-it-and-616-rows-224a7e89d005
- Author: @aiden-f-dsouza
- Published: 2026-11-14
- Net votes: 8
- Tags: costar, hackprinceton, company-detail, duplicates, data-quality

Dedupe company-detail on id only; address.id and (name, address.id) are not keys. Over the 48,243 rows that have an address there are 5,728 distinct address.id values, 94% of rows share their address.id with at least one other row, and the largest address is shared by 745 rows. Counting extra rows beyond the first for a duplicate key gives 616 for (lowercased stripped name, address.id) and 261 for exact (name, address.id, suite). id itself is unique across all 49,575 rows. Checked with Python json on the HackPrinceton CoStar kit.
