About this Dataset

DOB NOW: Electrical Permit Applications

This dataset is part of the DOB NOW Electrical Permit Data Collection: https://data.cityofnewyork.us/browse?Data-Collection_Data-Collection=DOB+NOW+Electrical+Permits+Data
This dataset contains general information about the job filing, including location, applicant, type of work and fee information. Each instance of electrical work might have one row/record for the Initial application, as well as one or more Post Approval Amendment or Subsequent Filing. (See Filing_Type field.)
Organization: City of New York
Last updated: 2020-11-10T17:02:31.887894
Tags: buildings, code, dob, ed16a, electric, electrical, electrician, filing, job, permit, work

Tables

Table 1

@usgov.city_of_new_york_dob_now_electrical_permit_applications.table_1

77.13 MB
494,856 rows
84 columns

CREATE TABLE table_1 (
  "job_filing_number" VARCHAR,
  "job_number" VARCHAR,
  "filing_number" VARCHAR,
  "filing_date" VARCHAR,
  "filing_type" VARCHAR,
  "filing_status" VARCHAR,
  "job_status" VARCHAR,
  "house_number" VARCHAR,
  "street_name" VARCHAR,
  "borough" VARCHAR,
  "zip_code" BIGINT,
  "block" BIGINT,
  "lot" BIGINT,
  "bin" BIGINT,
  "community_board" BIGINT,
  "joint_venture_work" VARCHAR,
  "building_use_type" VARCHAR,
  "applicant_first_name" VARCHAR,
  "applicant_last_name" VARCHAR,
  "license_type" VARCHAR,
  "license_number" DOUBLE,
  "firm_name" VARCHAR,
  "firm_number" DOUBLE,
  "firm_address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" VARCHAR,
  "general_liability_company" VARCHAR,
  "general_liability_policy" VARCHAR,
  "general_liability_expiration_date" VARCHAR,
  "worker_comp_company_name" VARCHAR,
  "worker_comp_policy" VARCHAR,
  "worker_comp_expiration_date" VARCHAR,
  "disability_company_name" VARCHAR,
  "disability_policy" VARCHAR,
  "disability_expiration_date" VARCHAR,
  "owner_first_name" VARCHAR,
  "owner_last_name" VARCHAR,
  "title" VARCHAR,
  "business_name" VARCHAR,
  "owner_address" VARCHAR,
  "owner_city" VARCHAR,
  "owner_state" VARCHAR,
  "owner_zip" VARCHAR,
  "owner_type" VARCHAR,
  "auth_rep_first_name" VARCHAR,
  "auth_rep_last_name" VARCHAR,
  "auth_rep_owner_relation" VARCHAR,
  "coo_related" VARCHAR,
  "const_bis_job_number" VARCHAR,
  "removal_of_vio_or_owner" VARCHAR,
  "svc_work_notify_utility" VARCHAR,
  "general_wiring" VARCHAR,
  "lighting_work" VARCHAR,
  "temp_construction_svc" VARCHAR,
  "temp_light_power" VARCHAR,
  "hvac_wiring" VARCHAR,
  "boiler_burner_wiring" VARCHAR,
  "category_work_list" VARCHAR,
  "n_3_wire" DOUBLE  -- 3 WIRE,
  "n_4_wire" DOUBLE  -- 4 WIRE,
  "n_10_points" DOUBLE  -- 10 POINTS,
  "existing_meters" DOUBLE,
  "new_meters" DOUBLE,
  "remove_meters" DOUBLE,
  "total_meters" DOUBLE,
  "job_description" VARCHAR,
  "permit_issued_date" VARCHAR,
  "job_start_date" VARCHAR,
  "completion_date" VARCHAR,
  "filing_fee" DOUBLE,
  "legalization_fee" DOUBLE,
  "nogood_check_fee" DOUBLE,
  "total_billable_work_fee" DOUBLE,
  "amount_paid" DOUBLE,
  "amount_due" DOUBLE,
  "payment_method" VARCHAR,
  "gis_latitude" DOUBLE,
  "gis_longitude" DOUBLE,
  "gis_council_district" DOUBLE,
  "gis_census_tract" DOUBLE,
  "gis_bin" DOUBLE,
  "gis_bbl" DOUBLE,
  "gis_nta_name" VARCHAR
);