About this Dataset

Historical DOB Permit Issuance

A list of permits issued by the Department of Buildings from 1989 to 2013. This dataset was originally released to provide data from before the DOB Permit Issuance dataset began. DOB Permit Issuance has since been updated to incorporate this date range, and this historical dataset is now redundant.
Organization: City of New York
Last updated: 2020-11-10T17:02:04.171164

Tables

Table 1

@usgov.city_of_new_york_historical_dob_permit_issuance.table_1

288.02 MB
2,428,526 rows
60 columns

CREATE TABLE table_1 (
  "borough" VARCHAR,
  "bin" BIGINT,
  "number" VARCHAR,
  "street" VARCHAR,
  "job" BIGINT  -- Job #,
  "job_doc" BIGINT  -- Job Doc. #,
  "job_type" VARCHAR,
  "self_cert" VARCHAR,
  "block" VARCHAR,
  "lot" VARCHAR,
  "community_board" VARCHAR,
  "postcode" DOUBLE,
  "bldg_type" DOUBLE,
  "residential" VARCHAR,
  "special_district_1" VARCHAR,
  "special_district_2" VARCHAR,
  "work_type" VARCHAR,
  "permit_status" VARCHAR,
  "filing_status" VARCHAR,
  "permit_type" VARCHAR,
  "permit_sequence" BIGINT  -- Permit Sequence #,
  "permit_subtype" VARCHAR,
  "oil_gas" VARCHAR,
  "site_fill" VARCHAR,
  "filing_date" TIMESTAMP,
  "issuance_date" TIMESTAMP,
  "expiration_date" TIMESTAMP,
  "job_start_date" VARCHAR,
  "permittee_s_first_name" VARCHAR,
  "permittee_s_last_name" VARCHAR,
  "permittee_s_business_name" VARCHAR,
  "permittee_s_phone" VARCHAR  -- Permittee's Phone #,
  "permittee_s_license_type" VARCHAR,
  "permittee_s_license" VARCHAR  -- Permittee's License #,
  "act_as_superintendent" VARCHAR,
  "permittee_s_other_title" VARCHAR,
  "hic_license" VARCHAR,
  "site_safety_mgr_s_first_name" VARCHAR,
  "site_safety_mgr_s_last_name" VARCHAR,
  "site_safety_mgr_business_name" VARCHAR,
  "superintendent_first_last_name" VARCHAR  -- Superintendent First & Last Name,
  "superintendent_business_name" VARCHAR,
  "owner_s_business_type" VARCHAR,
  "non_profit" VARCHAR,
  "owner_s_business_name" VARCHAR,
  "owner_s_first_name" VARCHAR,
  "owner_s_last_name" VARCHAR,
  "owner_s_house" VARCHAR  -- Owner's House #,
  "owner_s_house_street_name" VARCHAR,
  "owner_s_house_city" VARCHAR,
  "owner_s_house_state" VARCHAR,
  "owner_s_house_zip_code" VARCHAR,
  "owner_s_phone" VARCHAR  -- Owner's Phone #,
  "dobrundate" TIMESTAMP,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "council_district" DOUBLE,
  "census_tract" DOUBLE,
  "bbl" DOUBLE,
  "nta" VARCHAR
);