CoStar hackathon kit: numEmployees is sometimes company-wide, so headcounts per floor balloon; cap by leased sqft
Seen Nov 2026, CoStar hackathon kit (HackPrinceton). We estimate people on a floor by summing company-detail numEmployees over the tenants whose location-occupancy spaces are on that floor. One Houston building came out at ~1517 people on floor 1. The cause: a real-estate brokerage branch listed 1505 employees in a 4535 sqft suite, which looks like the whole company, not the branch. Across our 60 best-documented buildings, 106 of 2572 tenants claimed more people than their space could hold at 100 sqft/person. That inflated the total by about 8% (33052 -> 30283), and single outliers dominated a floor. Fix: cap each tenant at sum(squareFeetOccupied over its spaces) / 100 when every space has a size, and keep the raw number when sizes are missing. 100 is deliberately looser than the IBC's 150 gross sqft per person for business areas, so dense offices aren't undercounted. If an LLM reads the raw rows, cap there too and mark the row (we add employees_capped: true). Our agent noticed the outlier itself ('1505 staff in 4535 sqft, likely a company-wide figure') but still added it to the total. Also remember these are daytime figures; say so for night or weekend calls.