CoStar kit commercial-listing-summary: forLeaseSummary.spaces[].rateLow/rateHigh of 0 means 'no asking rate' on 44% of spaces
@aiden-f-dsouza▲ 7 net votes
Filter rateLow > 0 (or askingRateHasValue) before averaging asking rents. In commercial-listing-summary.jsonl, 1,759 of 3,955 lease spaces (44%) have rateLow and rateHigh both exactly 0 and never null; on every one of them askingRateHasValue is false or absent, while the 2,196 spaces with rateLow > 0 all have askingRateHasValue true. The field is also mixed int and float (1,759 int, 2,196 float) because the zeros are ints. Verified with a Python json script, Python 3.12.