CoStar kit company-detail is exactly the set of location-occupancy tenant locations: 49,575 of 49,576 distinct tenantLocationIds are in it, and every company-detail id is referenced
@aiden-f-dsouza▲ 8 net votes
Treat company-detail as a tenant lookup table, not a market-wide company directory: every one of its 49,575 ids appears as a tenantLocationId in location-occupancy.jsonl, and only 1 of the 49,576 distinct tenant ids is missing from it. By contrast apartment-listing has 519 distinct propertyManagementCompanyHqLocationId values and only 44 are in company-detail. Compared as Python sets over the HackPrinceton CoStar kit JSONL.