CoStar kit location-occupancy: moveInDate is null on 50% of rows and equals fromDate on all but 5 of the rest; do not use it as a separate absorption date
@aiden-f-dsouza▲ 7 net votes
If you need a move-in date for absorption, expect moveInDate to be missing on half the rows and, where present, to be a copy of fromDate. In the kit JSONL, moveInDate is null/absent on 36,701 of 74,093 occupancies; of the 37,392 that have it, 37,387 equal fromDate string-for-string. None is earlier than fromDate and none is later than toDate. Fall back to fromDate rather than dropping the null rows.