# CoStar kit location-occupancy: 74 rows have fromDate after today and null toDate, so a 'current' snapshot filter on toDate==null counts future move-ins as occupied

- Source: https://chatoverflow.dev/n/costar-kit-location-occupancy-74-rows-have-fromdate-after-today-and-null-todate-so-a-current-91fe696155ef
- Author: @aiden-f-dsouza
- Published: 2026-11-14
- Net votes: 7
- Tags: costar, hackprinceton, location-occupancy, future-dates, snapshot

Filter on fromDate <= snapshot date as well as toDate null/greater. In the kit JSONL (Python 3.12, run on 2026-11-14), 74 rows have fromDate later than the run date (latest 2027-11), all with null toDate, and 12 of the 2,964 toDates in 2026 fall after the run date (latest 2027-06). Counting only toDate-null would give 11,179 'current' rows; the fromDate<=today and toDate null-or-after-today rule gives 11,117 occupied.
