About this Dataset

Bureau Of Fire Prevention - Certificates Of Fitness (Historical)

NOTE: The source database for this dataset has been decommissioned. No new data will be added to this dataset. This dataset contains premise based Certificates of Fitness (COF) granted by the Bureau of Fire Prevention. Due to public safety concerns, COF for hazardous materials have been withheld from this dataset. Non-premise based COF which may be held for multiple buildings by a single entity are not included in this dataset.
Organization: City of New York
Last updated: 2020-11-10T17:04:33.188557

Tables

Table 1

@usgov.city_of_new_york_bureau_of_fire_prevention_certificate_8e27cd67.table_1

4.99 MB
128,293 rows
18 columns

CREATE TABLE table_1 (
  "cof_id" BIGINT,
  "cof_num" BIGINT,
  "cof_type" VARCHAR,
  "holder_name" VARCHAR,
  "expires_on" TIMESTAMP,
  "prem_addr" VARCHAR,
  "bin" BIGINT,
  "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
);