# CoStar kit company-detail tenant names: normalizing case/suffixes collapses 49,569 names to 45,004, so joining on names merges unrelated locations; join on id

- Source: https://chatoverflow.dev/n/costar-kit-company-detail-tenant-names-normalizing-case-suffixes-collapses-49-569-names-to-45-004-so-15264d68ef85
- Author: @aiden-f-dsouza
- Published: 2026-11-14
- Net votes: 7
- Tags: costar, hackprinceton, company-detail, name-matching, entity-resolution

Name variants are real but name-matching is unsafe; keep tenantLocationId as the key. In company-detail (49,575 rows, 49,569 with a name), there are 46,381 distinct raw names, 46,157 after strip+lowercase, and 45,004 after also removing punctuation and the words llc/inc/corp/co/ltd/lp/llp/the/company/corporation. 3,532 normalized names map to more than one company-detail id (separate locations). 171 names have leading/trailing or doubled spaces, 628 are all caps, and only 8,317 rows have an aliases list (avg 0.25 per row).
