About this Dataset

DOB Certificate Of Occupancy

A Certificate of Occupancy (CO) states a building’s legal use and/or type of permitted occupancy. New buildings must have a CO, and existing buildings must have a current or amended CO when there is a change in use, egress or type of occupancy. No one may legally occupy a building until the Department has issued a Certificate of Occupancy or Temporary Certificate of Occupancy. The Department issues a final Certificate of Occupancy when the completed work matches the submitted plans for new buildings or major alterations. It issues a Letter of Completion for minor alterations to properties. These documents confirm the work complies with all applicable laws, all paperwork has been completed, all fees owed to the Department have been paid, all relevant violations have been resolved and all necessary approvals have been received from other City Agencies.

This dataset contains all Certificates of Occupancy issued since 7/12/12.
Organization: City of New York
Last updated: 2020-11-10T17:02:03.847114
Tags: building, c-of-o, certificate, co, occupancy

Tables

Table 1

@usgov.city_of_new_york_dob_certificate_of_occupancy.table_1

6.82 MB
141,610 rows
25 columns

CREATE TABLE table_1 (
  "job_number" BIGINT,
  "job_type" VARCHAR,
  "c_o_issue_date" TIMESTAMP,
  "bin_number" BIGINT,
  "borough" VARCHAR,
  "number" VARCHAR,
  "street" VARCHAR,
  "block" BIGINT,
  "lot" DOUBLE,
  "postcode" DOUBLE,
  "pr_dwelling_unit" VARCHAR,
  "ex_dwelling_unit" VARCHAR,
  "application_status_raw" VARCHAR,
  "filing_status_raw" VARCHAR,
  "item_number" BIGINT,
  "issue_type" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "community_board" DOUBLE,
  "council_district" DOUBLE,
  "census_tract" DOUBLE,
  "bin" DOUBLE,
  "bbl" DOUBLE,
  "nta" VARCHAR,
  "location" VARCHAR
);