About this Dataset

Bureau Of Fire Prevention - Inspections (Historical)

NOTE: The source database for this dataset has been decommissioned. No new data will be added to this dataset. This dataset contains permit and Bureau of Fire Prevention inspection information by account holder. Each building may have more than one permit holder. Each permit holder may have multiple permits in multiple buildings.
Organization: City of New York
Last updated: 2020-11-10T17:05:15.764512

Tables

Table 1

@usgov.city_of_new_york_bureau_of_fire_prevention_inspections.table_1

17.43 MB
400,618 rows
20 columns

CREATE TABLE table_1 (
  "acct_id" BIGINT,
  "alpha" VARCHAR,
  "acct_num" BIGINT,
  "owner_name" VARCHAR,
  "last_visit_dt" TIMESTAMP,
  "last_full_insp_dt" TIMESTAMP,
  "last_insp_stat" VARCHAR,
  "prem_addr" VARCHAR,
  "bin" DOUBLE,
  "community_board" DOUBLE,
  "council_district" DOUBLE,
  "bbl" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "postcode" DOUBLE,
  "borough" VARCHAR,
  "number" VARCHAR,
  "street" VARCHAR,
  "census_tract" DOUBLE,
  "nta" VARCHAR
);