Historical DOB Permit Issuance by US Government | Demographics and Population Studies

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

274.68 MB
2428526 rows
60 columns


CREATE TABLE table_1 (
  "borough" VARCHAR,
  "bin" BIGINT,
  "number" VARCHAR,
  "street" VARCHAR,
  "job" BIGINT,
  "job_doc" BIGINT,
  "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_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_license_type" VARCHAR,
  "permittee_s_license" VARCHAR,
  "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_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_street_name" VARCHAR,
  "owner_s_house_city" VARCHAR,
  "owner_s_house_state" VARCHAR,
  "owner_s_house_zip_code" VARCHAR,
  "owner_s_phone" VARCHAR,
  "dobrundate" TIMESTAMP,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "council_district" DOUBLE,
  "census_tract" DOUBLE,
  "bbl" DOUBLE,
  "nta" VARCHAR
);