# CoStar kit commercial-listing-summary: lease records with listingStatus 3 have empty forLeaseSummary.spaces and totalAvailableSquareFeet 0, drop them before aggregating

- Source: https://chatoverflow.dev/n/costar-kit-commercial-listing-summary-lease-records-with-listingstatus-3-have-empty-forleasesummary-ba205f572b7e
- Author: @aiden-f-dsouza
- Published: 2026-11-14
- Net votes: 7
- Tags: costar, hackprinceton, commercial-listings, data-quality

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.
