Data·Citizenan agentic layer over NYC Open Data
CatalogExploreAnalyticsMapAsk the agentFindingsGuideStatus
Data from NYC Open Data via the Socrata Discovery API. Quality scores are computed from a sample and are indicative, not authoritative.
← Catalog

DOB NOW: Electrical Permit Applications

dm9a-ab7wCity Government83 columns
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.)
View on NYC Open Data↗

Quality

B89.9 / 100

From a 500-row sample across 82 columns.

completeness89/ 25% weight
consistency78/ 20% weight
accuracy95/ 20% weight
timeliness100/ 15% weight
usability90/ 20% weight
  • · Very wide (82 columns) — hard to consume directly
  • · Has geographic keys — joinable to other NYC datasets

Related datasets

  • DOB NOW: Build Elevator Permit Applications0.50
    joins onowner_typeblockbin+19
  • OATH Hearings Division Case Status0.33
  • Property Exemption Detail0.33
    joins onblocklot
  • Primary Land Use Tax Lot Output (PLUTO)0.32
    joins onblockboroughlot
  • Parking Violations Issued - Fiscal Year 20270.32

Geography

Has borough codes (`borough`) — joinable, but needs boundary shapes to draw.

Sample rows

job_filing_numberjob_numberfiling_numberfiling_datefiling_typefiling_statusjob_statushouse_numberstreet_nameboroughzip_codeblock
B00334201-I1-ELB00334201I12020-03-17T00:00:00.000New Job FilingPending PaymentJob in Process802FLUSHING AVENUEBROOKLYN112063131
B00009256-I1-EL

Columns

83 queryable · 83 profiled

The machine field names SoQL needs, with the publisher's own description of each.

FieldTypeDescriptionNullValues
job_filing_numbertextA 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)0%Q00665025-I1-ELX00213709-I1-ELX01048957-I1-EL
job_numbertextA 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 number0%M08021494M00458107M00017941
filing_numbertextA 2-digit code identifying the filing type. Should match the last part of the Job Filing Number.0%I1P1P2
filing_date

Query this from your own app

GET /api/datasets/dm9a-ab7w
GET /api/datasets/dm9a-ab7w/quality
GET /api/datasets/dm9a-ab7w/related
GET /api/columns?dataset=dm9a-ab7w
joins on
street_name
house_number
  • NYC Permitted Event Information0.32
    joins oncommunity_board
  • DOB NOW: Build Elevator Device Details0.31
    joins onjob_filing_number
  • Suitability of City-Owned and Leased Property for Urban Agriculture (LL 48 of 2011)0.31
    joins onblockbinlot+1
    • B00009256
    I1
    2018-01-09T00:00:00.000
    New Job Filing
    Permit Issued
    Job in Process
    924
    58 STREET
    BROOKLYN
    11219
    5701
    B00006222-I1-ELB00006222I12017-12-15T00:00:00.000New Job FilingPermit IssuedJob in Process243HANCOCK STREETBROOKLYN112161834
    B00044661-I1-ELB00044661I12018-06-04T00:00:00.000New Job FilingPermit IssuedJob in Process2845BRIGHTON 7 STREETBROOKLYN112357263
    B00044661-P1B00044661P12018-07-31T00:00:00.000PAAApprovedJob in Process2845BRIGHTON 7 STREETBROOKLYN112357263
    M00043954-S2-ELM00043954S22020-01-07T00:00:00.000Subsequent FilingPermit IssuedJob in Process100EAST 53 STREETMANHATTAN100221307
    B00511820-S1-ELB00511820S12021-04-28T00:00:00.000Subsequent FilingCancelInspection not complete due to withdrawal488MARCUS GARVEY BOULEVARDBROOKLYN112161859
    B00067079-I1-ELB00067079I12018-08-01T00:00:00.000New Job FilingPermit IssuedJob in Process26MARCY AVENUEBROOKLYN112112369
    M00475519-I1-ELM00475519I12021-02-24T00:00:00.000New Job FilingCancelInspection not complete due to withdrawal150WEST 120 STREETMANHATTAN100271904
    B00072620-I1-ELB00072620I12018-08-21T00:00:00.000New Job FilingPermit IssuedJob in Process1PLAZA STREETBROOKLYN112171060

    Showing 12 of 82 columns. All of them are listed below.

    datetime
    Date the filing was created. This should be the earliest date associated with this Job Filing Number.
    0%
    2025-12-18T00:00:00.0002025-12-17T00:00:00.0002025-12-19T00:00:00.000
    filing_typecategoricalIndicates whether this filing is new, subsequent or Post Approval Amendment (PAA) filing0%New Job FilingPAASubsequent Filingof 3
    filing_statuscategoricalIndicates the stage of this filing as it progresses through the permit application process.0%CompletePermit IssuedApprovedof 14
    job_statuscategoricalIndicates the overall status of the electrical job.0%Job is completeJob in ProcessInspection not complete …of 3
    house_numbertextThe house number of the job location0%120030
    street_nametextThe street name of the job location0%BROADWAY5 AVENUEPARK AVENUE
    boroughcategoricalThe borough of the job location0%ManhattanBrooklynQueensof 10
    zip_codetextZIP Code of the job location0%100221001110003
    blocktextTax block number of the job location. Assigned by the Department of Finance.0%972317516
    lottextTax lot number of the job location. Assigned by the Department of Finance.0%175017502
    bintextBuilding Identification Number (BIN) of the job location. Assigned by Department of City Planning.0%108290810889614433859
    community_boardtextA 3-digit identifier of the Community Board of the job location0%105108107
    joint_venture_workcategoricalIndicates whether the work will be performed by other licensed firm(s) as a joint venture (As per NYC Electrical Code §27-3014.13)0%NoYesof 2
    building_use_typecategoricalLetter code and description of the building class0%L Five or more FamilyA One FamilyB Two Familyof 16
    applicant_first_nametextFirst name of the applicant0%RICHARDCARLOSJOSEPH
    applicant_last_nametextLast name of the applicant0%BERGERNEUMARINELLO
    license_typetextType of license issued by DOB to the applicant.0%Electricianof 1
    license_numbertextApplicant's license number, included in the DOB-issued licenses for qualified professionals in the construction trades0%011068011545012012
    firm_nametextName of the applicant's firm (business, corporation, or partnership)0%BERGER QUALITY ELEC'L CO…RICHARD NEUSUNRUN SOLAR ELECTL CORP
    firm_numbertextFirm number assigned to the applicant's business, corporation, or partnership by DOB0%003535003052004719
    firm_addresstextStreet address of the applicant's firm0%195 7TH AVENUE4347 HYLAN BLVD516 INDUSTRIAL LOOP SUIT…
    citytextCity of the applicant's firm0%BROOKLYNNEW YORKSTATEN ISLAND
    statecategoricalState of the applicant's firm0%NYNJFLof 7
    ziptextZIP code of the applicant's firm0%111011030911215
    general_liability_companytextName of the company providing General Liability insurance to the applicant's firm0%MERCHANTS MUTUAL INS COTRAVELERS INS COMPANYUTICA FIRST INS CO
    general_liability_policytextPolicy number of the General Liability insurance covering the applicant's firm0%BOPI082851N8BP606140CPP5181954
    general_liability_expirationdatetimeExpiration date of the General Liability insurance policy covering the applicant's firm0%2027-10-07T00:00:00.0002027-04-01T00:00:00.0002027-07-25T00:00:00.000
    worker_comp_company_nametextName of the company providing Workers Compensation insurance to the applicant's firm0%NYSIFNYS INSURANCE FUNDNEW YORK STATE INS FUND
    worker_comp_policytextPolicy number of the Workers Compensation insurance covering the applicant's firm1%G1419 580-4WCA 90992372026-077857
    worker_comp_expiration_datedatetimeExpiration date of the Workers Compensation insurance policy covering the applicant's firm1%2026-10-31T00:00:00.0002027-04-01T00:00:00.0002027-09-22T00:00:00.000
    disability_company_nametextName of the company providing Disability insurance to the applicant's firm0%SHELTERPOINT LIFE INS COSHELTERPOINT INS COMPANYSTANDARD SECURITY LIFE
    disability_policytextPolicy number of the Disability insurance covering the applicant's firm1%L81808-000DBL 5958072026-077857
    disability_expiration_datedatetimeExpiration date of the Disability insurance policy covering the applicant's firm1%2026-12-31T00:00:00.0002023-12-31T00:00:00.0002022-12-31T00:00:00.000
    owner_first_nametextFirst name of the building's owner0%MICHAELJOSEPHDAVID
    owner_last_nametextLast name of the building's owner0%SINGHROBERTKAUR
    titletextTitle of the building's owner100%—
    business_nametextBusiness name of the building's owner38%PRNot ApplicableN/A
    owner_addresstextAddress of the building's owner100%30S Wacker Drive Suite 9…289 MERSEROLE ST512 7TH AVE
    owner_citytextCity of the building's owner100%BROOKLYNNEW YORKBrooklyn
    owner_statecategoricalState of the building's owner100%NYnyIlof 5
    owner_ziptextZIP code of the building's owner100%606061120611385
    owner_typecategoricalType of building ownership.0%IndividualCorporationPartnershipof 13
    auth_rep_first_nametextFirst name of the person designated as authorized representative by the building's owner80%RICHARDJasonJASON
    auth_rep_last_nametextLast name of the building's owner80%NEUPETERSSampogna
    auth_rep_owner_relationtextIndicates type of relationship between the authorized representative and the building's owner. Example: Management Agent81%SUBCONTRACTORContractorCONTRACTOR
    coo_relatedcategoricalIndicates whether or not this filing will result in a new Certificate of Occupancy0%NoYesof 2
    const_bis_job_numbertextIf this application is related to another job appliation at DOB, the job number will be found here.97%122829591321188415210178225
    removal_of_vio_or_ownercategoricalIndicates whether this filing is related to removal of violations or owner/occupant objections;0%NoYesof 2
    svc_work_notify_utilitycategoricalIndicates whether "Service Work / Notify Utility" category of work is selected0%NoYesof 2
    general_wiringcategoricalIndicates whether "General Wiring" category of work is selected0%YesNoof 2
    lighting_workcategoricalIndicates whether "Lighting Work" category of work is selected0%NoYesof 2
    temp_construction_svccategoricalIndicates whether "Temporary Construction Service" category of work is selected0%NoYesof 2
    temp_light_powercategoricalIndicates whether "Temporary Light Power" category of work is selected0%NoYesof 2
    hvac_wiringcategoricalIndicates whether "HVAC Wiring" category of work is selected0%NoYesof 2
    boiler_burner_wiringcategoricalIndicates whether "Boiler Burner Wiring" category of work is selected0%NoYesof 2
    category_work_listcategorical"Includes description of other work category selected by the applicant. "68%Sustainable Energy Insta…Sidewalk Shed Wiring & L…Minor Workof 13
    _3_wireintegerIndicates number of "3 Wire" needed for meter work0%013
    _4_wireintegerIndicates number of "4 Wire" needed for meter work0%012
    _10_pointsintegerIndicates number of "10 points" needed for meter work0%012
    existing_metersintegerIndicates number of existing meters in scope of this work0%012
    new_metersintegerIndicates number of meters to be added by this work0%013
    remove_metersintegerIndicates number of meters to be removed by this work0%012
    total_metersintegerIndicates total number of meters (existing meters + new meters - removed meters)0%013
    job_descriptiontextA description of the electrical work to be performed. This description will be printed on the work permit.0%Connect the solar system…sidewalk shed lighting w…SIDEWALK SHED
    permit_issued_datedatetimeDate and time the permit was issued16%2025-12-18T00:00:00.0002025-12-17T00:00:00.0002025-12-19T00:00:00.000
    job_start_datedatetimePlanned start date and time of the work0%2025-12-19T00:00:00.0002025-12-18T00:00:00.0002025-12-17T00:00:00.000
    completion_datedatetimePlanned end date and time of the work0%2025-12-31T00:00:00.0002021-12-31T00:00:00.0002023-12-30T00:00:00.000
    filing_feecategoricalFee required for the job filing0%40015of 4
    legalization_feefloatFee required for removal of violations for illegal work0%0400550
    nogood_check_feecategoricalA fee required if first check payment to DOB was rejected / returned0%02040of 5
    total_billable_work_feefloatThe 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.0%02338
    amount_paidfloatTotal amount paid by applicant so far.0%40150
    amount_duefloatBalance remaining to be paid by applicant0%012515
    payment_methodcategoricalMethod used in fee payment18%Credit CardCheckPayPalof 4
    gis_latitudecoordinate—0%40.74970740.75304540.723485
    gis_longitudecoordinate—0%-73.993421-74.000282-73.84849
    gis_council_districttext—0%040301
    gis_census_tracttext—0%1012133
    gis_bbltext—1%100972000140317500011007810001
    gis_nta_nametext—0%Midtown-Times SquareUpper East Side-Carnegie…Upper West Side (Central…