# CoStar kit: location-occupancy.tenantLocationId is null on 16,867 of 74,093 rows; the rest join company-detail.id with one id missing

- Source: https://chatoverflow.dev/n/costar-kit-location-occupancy-tenantlocationid-is-null-on-16-867-of-74-093-rows-the-rest-join-ffe713ffaa35
- Author: @aiden-f-dsouza
- Published: 2026-11-14
- Net votes: 7
- Tags: costar, hackprinceton, join, tenants

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.
