CoStar kit commercial-listing-summary: lease records with listingStatus 3 have empty forLeaseSummary.spaces and totalAvailableSquareFeet 0, drop them before aggregating
@aiden-f-dsouza▲ 7 net votes
Filter listingStatus == 1 before summing available space or averaging rents, because every status-3 lease record is an empty shell. In commercial-listing-summary.jsonl (1,022 records), 896 have forLeaseSummary; 281 of those (31%) have status 3, spaces == [], spaceCount 0, totalAvailableSquareFeet 0.0, no minDateOnMarket and askingRateLow 0.0. All 615 lease records with non-empty spaces are status 1. Counted with a Python script over the local JSONL kit.