DOB NOW: Electrical Permit Details by US Government | Demographics and Population Studies

About this Dataset

DOB NOW: Electrical Permit Details

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 details of the electrical scope of work. For each Job Filing Number, there can be multiple rows/records in this dataset. For example, there might be electrical work being performed in the basement as well as on the 4th floor. One row/record for Basement and one for the floor. The job might have some 101 to 200 amps Service Switches as well as some Up to 100 amps Service Switches, and there would be one row/record for each.
Organization: City of New York
Last updated: 2020-11-10T17:06:10.287418
Tags: buildings, code, dob, ed16a, electric, electrical, electrician, filing, job, permit, work

Tables

Table 1

@usgov.city_of_new_york_dob_now_electrical_permit_details.table_1

50.81 MB
1056168 rows
40 columns


CREATE TABLE table_1 (
  "details_id" VARCHAR,
  "work_id" VARCHAR,
  "floor_id" VARCHAR,
  "sign_id" VARCHAR,
  "job_filing_number" VARCHAR,
  "work_description" VARCHAR,
  "item" VARCHAR,
  "quantity" DOUBLE,
  "cost" DOUBLE,
  "fee_amount" DOUBLE,
  "number_size" VARCHAR,
  "floor_name" VARCHAR,
  "floor_from" VARCHAR,
  "floor_to" VARCHAR,
  "floor_description" VARCHAR,
  "fixture" DOUBLE,
  "receptacles_ac" DOUBLE,
  "receptacles_att" DOUBLE,
  "switches" BIGINT,
  "outlets" BIGINT,
  "motors_generators" BIGINT,
  "total_hpkw" BIGINT,
  "heaters" BIGINT,
  "total_kw" BIGINT,
  "transformer" BIGINT,
  "total_kva" BIGINT,
  "sign_dimensions" VARCHAR,
  "sign_square_footage" DOUBLE,
  "total_circuits" BIGINT,
  "total_lamps" DOUBLE,
  "watts_lamps" BIGINT,
  "sign_transformers" BIGINT,
  "va_transformer" DOUBLE,
  "total_watts_va" DOUBLE,
  "awg" VARCHAR,
  "sockets_per_circuit" DOUBLE,
  "material_gauge" VARCHAR,
  "sign_make" VARCHAR,
  "sign_manufacturer" VARCHAR,
  "manufacturer_address" VARCHAR
);