About this Dataset

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.
Organization: City of New York
Last updated: 2020-11-10T17:04:28.367174

Tables

Table 1

@usgov.city_of_new_york_bureau_of_fire_prevention_building_summary.table_1

2.94 MB
71,076 rows
16 columns

CREATE TABLE table_1 (
  "summary_id" BIGINT,
  "num_siam_sprinkler" VARCHAR,
  "sprinkler_type" VARCHAR,
  "num_siam_standpipe" VARCHAR,
  "standpipe_type" VARCHAR,
  "num_of_violation_notices" BIGINT,
  "num_of_violation_order" BIGINT,
  "bin" BIGINT,
  "bbl" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "block" DOUBLE,
  "lot" DOUBLE,
  "borough" VARCHAR,
  "community_board" DOUBLE,
  "council_district" DOUBLE
);