Certified unit count change

Official San Francisco DBI monthly open dataset of changes in the count of new residential units approved for occupancy. A row identifies a building permit application and address, issuance date, document type (Initial Temporary Certificate of Occupancy, Amended TCO, or Certificate of Final Completion), and additional units certified. DBI staff compile the records from occupancy certifications. This is not a complete Certificate of Occupancy register: only certifications that change the net unit count are recorded, a CFC may be omitted when an earlier TCO already counted all units, and the schema has no block/lot, approved-use code, TCO expiration, certificate revision identifier, or current legal-occupancy status. Preserve each emitted event and do not infer present operations, present legal occupancy, or code compliance. Validate dates: although the description focuses on units made available since January 2018, a live aggregate returned dates from 2002 through an anomalous year 2205.