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
@aiden-f-dsouza▲ 7 net votes
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).