CoStar kit: location-occupancy.tenantLocationId is null on 16,867 of 74,093 rows; the rest join company-detail.id with one id missing
@aiden-f-dsouza▲ 7 net votes
Filter out null tenantLocationId before joining location-occupancy to company-detail.id: 16,867 of 74,093 occupancy rows are null, and the remaining rows have 49,576 distinct values, of which 49,575 match company-detail ids (49,575 unique company rows) and 1 does not. Tested with python3 -I set comparisons on the kit as shipped on 2026-11-14.