Readme
Updated 18 hours ago
‧ Indexed 2 hours ago
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.)
Columns
| Name | Socrata field name | Column name in sgr mount | Data type | Description |
|---|---|---|---|---|
| HVAC_WIRING | hvac_wiring | hvac_wiring | Text | Indicates whether "HVAC Wiring" category of work is selected |
| OWNER_ZIP | owner_zip | owner_zip | Text | ZIP code of the building's owner |
| CITY | city | city | Text | City of the applicant's firm |
| AMOUNT_DUE | amount_due | amount_due | Number | Balance remaining to be paid by applicant |
| TOTAL_METERS | total_meters | total_meters | Number | Indicates total number of meters (existing meters + new meters - removed meters) |
| GIS_BIN | gis_bin | gis_bin | Text | |
| DISABILITY_COMPANY_NAME | disability_company_name | disability_company_name | Text | Name of the company providing Disability insurance to the applicant's firm |
| PERMIT_ISSUED_DATE | permit_issued_date | permit_issued_date | Calendar date | Date and time the permit was issued |
| OWNER_STATE | owner_state | owner_state | Text | State of the building's owner |
| JOB_NUMBER | job_number | job_number | Text | A 9-digit identifier for the job. Should match the first part of the Job Filing Number. The first letter indicates the borough for which the filing is associated, followed by an 8-digit ID number |
| AUTH_REP_OWNER_RELATION | auth_rep_owner_relation | auth_rep_owner_relation | Text | Indicates type of relationship between the authorized representative and the building's owner. Example: Management Agent |
| CONST_BIS_JOB_NUMBER | const_bis_job_number | const_bis_job_number | Text | If this application is related to another job appliation at DOB, the job number will be found here. |
| FILING_DATE | filing_date | filing_date | Calendar date | Date the filing was created. This should be the earliest date associated with this Job Filing Number. |
| ZIP | zip | zip | Text | ZIP code of the applicant's firm |
| COMMUNITY_BOARD | community_board | community_board | Text | A 3-digit identifier of the Community Board of the job location |
| OWNER_CITY | owner_city | owner_city | Text | City of the building's owner |
| WORKER_COMP_COMPANY_NAME | worker_comp_company_name | worker_comp_company_name | Text | Name of the company providing Workers Compensation insurance to the applicant's firm |
| GENERAL_LIABILITY_POLICY | general_liability_policy | general_liability_policy | Text | Policy number of the General Liability insurance covering the applicant's firm |
| GENERAL_LIABILITY_EXPIRATION_DATE | general_liability_expiration | general_liability_expiration | Calendar date | Expiration date of the General Liability insurance policy covering the applicant's firm |
| BUSINESS_NAME | business_name | business_name | Text | Business name of the building's owner |
| DISABILITY_POLICY | disability_policy | disability_policy | Text | Policy number of the Disability insurance covering the applicant's firm |
| DISABILITY_EXPIRATION_DATE | disability_expiration_date | disability_expiration_date | Calendar date | Expiration date of the Disability insurance policy covering the applicant's firm |
| CATEGORY_WORK_LIST | category_work_list | category_work_list | Text | "Includes description of other work category selected by the applicant. " |
| REMOVE_METERS | remove_meters | remove_meters | Number | Indicates number of meters to be removed by this work |
| OWNER_FIRST_NAME | owner_first_name | owner_first_name | Text | First name of the building's owner |
| FILING_TYPE | filing_type | filing_type | Text | Indicates whether this filing is new, subsequent or Post Approval Amendment (PAA) filing |
| OWNER_LAST_NAME | owner_last_name | owner_last_name | Text | Last name of the building's owner |
| NEW_METERS | new_meters | new_meters | Number | Indicates number of meters to be added by this work |
| GIS_BBL | gis_bbl | gis_bbl | Text | |
| FILING_NUMBER | filing_number | filing_number | Text | A 2-digit code identifying the filing type. Should match the last part of the Job Filing Number. |
| LOT | lot | lot | Text | Tax lot number of the job location. Assigned by the Department of Finance. |
| FILING_FEE | filing_fee | filing_fee | Number | Fee required for the job filing |
| AUTH_REP_FIRST_NAME | auth_rep_first_name | auth_rep_first_name | Text | First name of the person designated as authorized representative by the building's owner |
| OWNER_ADDRESS | owner_address | owner_address | Text | Address of the building's owner |
| EXISTING_METERS | existing_meters | existing_meters | Number | Indicates number of existing meters in scope of this work |
| LEGALIZATION_FEE | legalization_fee | legalization_fee | Number | Fee required for removal of violations for illegal work |
| NOGOOD_CHECK_FEE | nogood_check_fee | nogood_check_fee | Number | A fee required if first check payment to DOB was rejected / returned |
| GIS_LONGITUDE | gis_longitude | gis_longitude | Text | |
| COMPLETION_DATE | completion_date | completion_date | Calendar date | Planned end date and time of the work |
| FILING_STATUS | filing_status | filing_status | Text | Indicates the stage of this filing as it progresses through the permit application process. |
| STREET_NAME | street_name | street_name | Text | The street name of the job location |
| BOILER_BURNER_WIRING | boiler_burner_wiring | boiler_burner_wiring | Text | Indicates whether "Boiler Burner Wiring" category of work is selected |
| REMOVAL_OF_VIO_OR_OWNER | removal_of_vio_or_owner | removal_of_vio_or_owner | Text | Indicates whether this filing is related to removal of violations or owner/occupant objections; |
| APPLICANT_FIRST_NAME | applicant_first_name | applicant_first_name | Text | First name of the applicant |
| LICENSE_NUMBER | license_number | license_number | Text | Applicant's license number, included in the DOB-issued licenses for qualified professionals in the construction trades |
| GENERAL_LIABILITY_COMPANY | general_liability_company | general_liability_company | Text | Name of the company providing General Liability insurance to the applicant's firm |
| GENERAL_WIRING | general_wiring | general_wiring | Text | Indicates whether "General Wiring" category of work is selected |
| TEMP_LIGHT_POWER | temp_light_power | temp_light_power | Text | Indicates whether "Temporary Light Power" category of work is selected |
| ZIP_CODE | zip_code | zip_code | Text | ZIP Code of the job location |
| LICENSE_TYPE | license_type | license_type | Text | Type of license issued by DOB to the applicant. |
| JOB_FILING_NUMBER | job_filing_number | job_filing_number | Text | A unique identifier assigned to a job filing. It consists of job number (a letter indicating the borough followed by an 8-digit number) hyphenated with Filing Number (a 2-digit code identifying the filing type). Once the permit is issued, a suffix "-EL" is added to the job filing number. (Example: M00000001-I1-EL) |
| GIS_CENSUS_TRACT | gis_census_tract | gis_census_tract | Text | |
| TOTAL_BILLABLE_WORK_FEE | total_billable_work_fee | total_billable_work_fee | Number | The total amount that the applicant will need to pay, including Filing Fee and Legalization Fee, which are paid when the application is first submitted to DOB, as well as all parts fees, which must be paid before the application can marked complete. |
| 3_WIRE | _3_wire | _3_wire | Number | Indicates number of "3 Wire" needed for meter work |
| AUTH_REP_LAST_NAME | auth_rep_last_name | auth_rep_last_name | Text | Last name of the building's owner |
| BUILDING_USE_TYPE | building_use_type | building_use_type | Text | Letter code and description of the building class |
| 10_POINTS | _10_points | _10_points | Number | Indicates number of "10 points" needed for meter work |
| WORKER_COMP_POLICY | worker_comp_policy | worker_comp_policy | Text | Policy number of the Workers Compensation insurance covering the applicant's firm |
| BLOCK | block | block | Text | Tax block number of the job location. Assigned by the Department of Finance. |
| JOB_DESCRIPTION | job_description | job_description | Text | A description of the electrical work to be performed. This description will be printed on the work permit. |
| JOB_STATUS | job_status | job_status | Text | Indicates the overall status of the electrical job. |
| OWNER_TYPE | owner_type | owner_type | Text | Type of building ownership. |
| COO_RELATED | coo_related | coo_related | Text | Indicates whether or not this filing will result in a new Certificate of Occupancy |
| 4_WIRE | _4_wire | _4_wire | Number | Indicates number of "4 Wire" needed for meter work |
| GIS_LATITUDE | gis_latitude | gis_latitude | Text | |
| TITLE | title | title | Text | Title of the building's owner |
| STATE | state | state | Text | State of the applicant's firm |
| JOINT_VENTURE_WORK | joint_venture_work | joint_venture_work | Text | Indicates whether the work will be performed by other licensed firm(s) as a joint venture (As per NYC Electrical Code §27-3014.13) |
| GIS_NTA_NAME | gis_nta_name | gis_nta_name | Text | |
| LIGHTING_WORK | lighting_work | lighting_work | Text | Indicates whether "Lighting Work" category of work is selected |
| SVC_WORK_NOTIFY_UTILITY | svc_work_notify_utility | svc_work_notify_utility | Text | Indicates whether "Service Work / Notify Utility" category of work is selected |
| GIS_COUNCIL_DISTRICT | gis_council_district | gis_council_district | Text | |
| BOROUGH | borough | borough | Text | The borough of the job location |
| AMOUNT_PAID | amount_paid | amount_paid | Number | Total amount paid by applicant so far. |
| TEMP_CONSTRUCTION_SVC | temp_construction_svc | temp_construction_svc | Text | Indicates whether "Temporary Construction Service" category of work is selected |
| JOB_START_DATE | job_start_date | job_start_date | Calendar date | Planned start date and time of the work |
| WORKER_COMP_EXPIRATION_DATE | worker_comp_expiration_date | worker_comp_expiration_date | Calendar date | Expiration date of the Workers Compensation insurance policy covering the applicant's firm |
| FIRM_ADDRESS | firm_address | firm_address | Text | Street address of the applicant's firm |
| FIRM_NUMBER | firm_number | firm_number | Text | Firm number assigned to the applicant's business, corporation, or partnership by DOB |
| FIRM_NAME | firm_name | firm_name | Text | Name of the applicant's firm (business, corporation, or partnership) |
| HOUSE_NUMBER | house_number | house_number | Text | The house number of the job location |
| APPLICANT_LAST_NAME | applicant_last_name | applicant_last_name | Text | Last name of the applicant |
| PAYMENT_METHOD | payment_method | payment_method | Text | Method used in fee payment |
| BIN | bin | bin | Text | Building Identification Number (BIN) of the job location. Assigned by Department of City Planning. |
Upstream Metadata