Bureau of Fire Prevention - Building Summary (Historical)
NOTE: The source database for this dataset has been decommissioned. No new data will be added to this dataset. This data set contains sprinkler, standpipe and total number of active violations by building. Note, the number of violations in each building may have been issued to multiple certificate holders, or may not be tied to any certificate holder.
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.
Dormant
- Says it updates
- Historical data
- Actually updates about every
- —
- Publisher last updated the data
- Mar 7, 2019
Our mirror
Whether our copy of this data is current with the source.
In sync
- We last synced
- May 13, 2019, 2:48 PM
- Rows in our copy
- 71,076
- Rows at the source
- 71,076
- Our copy trails the source by
- under a minute
Columns
Each source column, with the name and type we use to store it.
4 of 16 columns carry a concept; 11 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 |
|---|---|---|---|---|---|---|---|---|
num_of_violation | NUM_OF_VIOLATION_NOTICES | Total Quantity of Open Notices of Violation | Not bound | Number | num_of_violation | numeric | — | |
bbl | BBL | Building Block Lot | Not bound | Number | bbl | numeric | — | |
block | BLOCK | The publisher describes this column nowhere. | Not bound | Number | block | numeric | — | |
community_district | COMMUNITY BOARD | The publisher describes this column nowhere. | community_districtdeclared | Number | community_district | numeric | — | |
lot | LOT | The publisher describes this column nowhere. | Not bound | Number | lot | numeric | — | |
bin | BIN | Building Identification Number | bindeclared | Number | bin | numeric | — | |
standpipe_type | STANDPIPE_TYPE | Standpipe type | Not bound | Text | standpipe_type | text | — | |
summary_id | SUMMARY_ID | Record Key | Not bound | Number | summary_id | numeric | — | |
num_siam_standpipe | NUM_SIAM_STANDPIPE | Quantity fo siamese standpipes |
Download
This file was produced on Aug 26, 2026, 10:55 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/nvgj-hbht
- Version
- Content hash:
767990e9b8613d4a8f951782118c33402db21ac179fde2e4e64b427431e51ad4 - What we changed
- We did not change the data. We stored it as published.
- Publisher
- codenownyc
- We retrieved it
- May 13, 2019, 2:48 PM
Update history
| Started | Kind | Result | Rows written | Produced by |
|---|---|---|---|---|
| Aug 26, 2026, 3:52 AM | full_replace | success | 71,076 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.72 |