Buildings Selected for the Underlying Conditions Program
Each year, the Department of Housing Preservation and Development (HPD) designates buildings for participation in the Underlying Conditions Program (Local Law 6 of 2013). These buildings are selected based on the number and severity of class "B" and "C" violations related to the presence of mold or water leaks issued by HPD within the past year and an inspection is attempted to verify conditions before the order is issued.
Open in the graph · Relate this dataset · What these columns mean
Freshness
The publisher's promise
How the agency that publishes this data says it keeps the data current.
Fresh
- Says it updates
- Monthly
- Actually updates about every
- 30.5 days
- Publisher last updated the data
- Oct 1, 2026
Our mirror
Whether our copy of this data is current with the source.
In sync
- We last synced
- Oct 1, 2026, 2:33 PM
- Rows in our copy
- 700
- Rows at the source
- 700
- Our copy trails the source by
- under a minute
Columns
Each source column, with the name and type we use to store it.
5 of 16 columns carry a concept; 7 carry a description from the publisher. Read the concept column before you join. A column with no concept carries no claim from us, and a name that looks like a key is not one.
| Source field | Display name | What the publisher says it is | Concept | Source type | Stored as | Stored type | Row identifier | Unit |
|---|---|---|---|---|---|---|---|---|
current_status | CURRENT_STATUS | "Active" buildings are currently participating in program. "Discharged" buildings have met a statutory requirement for removal from the program. | Not bound | Text | current_status | text | — | |
nta | NTA (2020) | The publisher describes this column nowhere. | Not bound | Text | nta | text | — | |
longitude | LONGITUDE | The publisher describes this column nowhere. | Not bound | Number | longitude | numeric | — | |
bbl | BBL | The publisher describes this column nowhere. | bbldeclared | Number | bbl | numeric | — | |
census_tract | CENSUS TRACT (2020) | The publisher describes this column nowhere. | Not bound | Number | census_tract | numeric | — | |
community_board | COMMUNITY BOARD | The publisher describes this column nowhere. | Not bound | Number | community_board | numeric | — | |
total_units | TOTAL_UNITS | Total Units reflects the number of units in the building as of the report run date and may vary from the unit count reported when the building was selected for the Underlying Conditions program. HPD records indicated that all the buildings had at least three dwelling units at the time of selection. | Not bound | Number | total_units | numeric |
Download
This file was produced on Oct 2, 2026, 10:01 PM.
Refresh this dataset
Source and attribution
Where this data comes from, which version we hold, and what we changed.
- Source
- https://data.cityofnewyork.us/d/xpbf-ithr
- Version
- Content hash:
0d9d94b724089c141b78634c0678742e1a71f028757069348a24b6c3865be0ee - What we changed
- We did not change the data. We stored it as published.
- Publisher
- codenownyc
- We retrieved it
- Oct 1, 2026, 2:33 PM
Update history
| Started | Kind | Result | Rows written | Produced by |
|---|---|---|---|---|
| Oct 1, 2026, 10:18 PM | full_replace | success | 700 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Sep 1, 2026, 10:31 PM | full_replace | success | 700 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.73 |
| Aug 30, 2026, 1:45 AM | full_replace | success | 700 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.73 |