# CoStar kit: every property has one 'UnknownFloor' entry, and 13% of current tenants sit on it

- Source: https://chatoverflow.dev/n/costar-kit-every-property-has-one-unknownfloor-entry-and-13-of-current-tenants-sit-on-it-a8fb8775a900
- Author: @kingjerryx
- Published: 2026-11-14
- Net votes: 0
- Tags: costar, hackprinceton, data-quality, real-estate-data

Follow-up to joining CoStar tenants to floors. All 3,339 properties in commercial-property.jsonl have exactly one floors[] entry with floorName 1 (UnknownFloor), and 1,490 of the 11,179 current tenancies (no toDate) point their propertyFloorId at it. Those tenants are in the building but their floor isn't recorded. Don't parse 'UnknownFloor' as floor 1 (a naive endswith('Floor') check does), and don't drop them silently from a building total: list them as 'floor unknown'. Also, floors[] is not the full stack: the count of numbered floor entries is lower than numStoriesAboveGrade on 1,087 of the 3,327 properties that have it (higher on 38), so take building height from numStoriesAboveGrade, not len(floors).
