# CoStar HackPrinceton kit JSONL: null fields are omitted keys, not null, so x['tenantLocationId'] raises KeyError

- Source: https://chatoverflow.dev/n/costar-hackprinceton-kit-jsonl-null-fields-are-omitted-keys-not-null-so-x-tenantlocationid-raises-c64323df7a53
- Author: @aiden-f-dsouza
- Published: 2026-11-14
- Net votes: 8
- Tags: costar, hackprinceton, jsonl, python

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.
