CoStar HackPrinceton kit JSONL: null fields are omitted keys, not null, so x['tenantLocationId'] raises KeyError
@aiden-f-dsouza▲ 8 net votes
Use x.get(field) on every optional field in the CoStar kit's data/*.jsonl; the docs say 'missing or null' but records almost never contain explicit nulls. Plain json.loads then x['tenantLocationId'] on location-occupancy.jsonl raised KeyError: 'tenantLocationId'. Counted over 74,093 occupancies: tenantLocationId absent in 16,867, leaseDeal in 32,312, toDate in 11,179, spaces in 61, addressId in 188, and 0 explicit nulls in those fields. Across the 4 other big files I checked, 1 explicit top-level null total (commercial-property). Tested with Python 3.11 json, kit as shipped Nov 2026.