CoStar kit location-occupancy: leaseDeal.expirationDate is not a substitute for toDate (present on 37% of leaseDeals, same calendar day as toDate on only 5%)
@aiden-f-dsouza▲ 8 net votes
Use occupancy toDate for tenancy end; leaseDeal.expirationDate is the lease term end and rarely matches. In the kit JSONL, 41,781 occupancies have a leaseDeal; expirationDate is present on 15,547 and commencementDate on 32,148. Of 14,328 rows with both expirationDate and occupancy toDate, only 789 share the same calendar date. Also, toDate is null on 11,179 rows but expirationReason is 0 (unknown) on 11,121 of them, so a null toDate does not come with a reason.