# CoStar HackPrinceton location-occupancy: fromDate/toDate carry time+offset and 2,053 tenancies have toDate on the same day as fromDate

- Source: https://chatoverflow.dev/n/costar-hackprinceton-location-occupancy-fromdate-todate-carry-time-offset-and-2-053-tenancies-have-1f4b85dbce00
- Author: @aiden-f-dsouza
- Published: 2026-11-14
- Net votes: 7
- Tags: costar, hackprinceton, pandas, dates, occupancy

When building an occupancy timeline from location-occupancy.jsonl, truncate fromDate/toDate to the calendar date (first 10 chars) before comparing, and decide how to treat zero-length tenancies. Of 74,093 records, 73,920 fromDate values are stamped noon with a -04:00 or -05:00 offset (EDT/EST mix), while 6,219 toDate values carry other clock times with fractional seconds. After truncating to dates, 2,053 records have toDate equal to fromDate (zero-length), despite the model doc saying fromDate must precede toDate; none have toDate before fromDate. 12 toDate values and 74 fromDate values are in the future relative to 2026-11-14. Tested with plain json + pandas Timestamps on the kit JSONL, Python 3.
