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: Build Elevator Device Details

juyv-2jekHousing & Development167 columns
This collection contains elevator applications, aka job filings, submitted online through the "DOB NOW: BUILD" portal. An approved application allows the applicant to pull a permit and begin work on an elevator project. DOB NOW: BUILD is an online portal that allows users to file for permit applications, check the status of an application, make payments, schedule appointments, and print permits. Data in this collection is limited to elevator applications (also known as ELV1) submitted through DOB NOW, and includes Initial (New), Subsequent, and Post Approval Amendment (PAA) filing types. The collection includes all electrical applications submitted to the Department of Buildings since December 11, 2017, when the applications were launched in DOB NOW and were no longer accepted through other submission processes. This dataset contains details for each device on the application. There should be one row per device/Job Filing Number in this dataset. For example, an Initial Permit Application for Device 1234 and Device 5678 would have 2 rows (one for 1234 and one for 5678). If a Post Approval Amendment (PAA) was submitted for this application, then the Device rows would be repeated but the Job Filing Number would have a P1 suffix to indicate the PAA.
View on NYC Open Data↗

Quality

B82.2 / 100

From a 500-row sample across 165 columns.

completeness52/ 25% weight
consistency87/ 20% weight
accuracy94/ 20% weight
timeliness100/ 15% weight
usability90/ 20% weight
  • · Very wide (165 columns) — hard to consume directly
  • · Has geographic keys — joinable to other NYC datasets

Related datasets

  • DOB NOW: Build Elevator Permit Applications0.52
    joins onjob_filing_number
  • DOB NOW: Electrical Permit Details0.34
    joins onjob_filing_number
  • DOB Job Application Filings0.33
  • DOB NOW: Certificate of Occupancy0.33
  • DOB Permit Issuance0.33
  • DOB Safety Violations0.31
    joins ondevice_type

Sample rows

job_filing_numberdevice_iddevice_typedevice_statusbis_nyc_device_idelevator_typeelevator_sub_typephysical_addressonly_elevator_in_buildingoccupant_evacuation_elevatormeets_the_stretcher_cardevice_confirming_with_seismic
M00737602-Z11P1002798ElevatorActive1P1002798PassengerN/A303 EAST 102 STREETYesNoYesNo

Columns

167 queryable · 167 profiled

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

FieldTypeDescriptionNullValues
job_filing_numbertext—0%M00072320-I1B00208963-P2B00019159-I1
device_idtext—0%1P259501P09871901P29434
device_typecategorical—0%ElevatorPersonnel HoistAccessibility Liftof 7
device_statuscategorical—0%ActiveWork in ProgressRemovedof 8

Query this from your own app

GET /api/datasets/juyv-2jek
GET /api/datasets/juyv-2jek/quality
GET /api/datasets/juyv-2jek/related
GET /api/columns?dataset=juyv-2jek
DOB NOW: Electrical Permit Applications
0.31
joins onjob_filing_number
  • Buildings Subject to HPD Jurisdiction0.31
    • M00471844-I11P6969ElevatorActive1P6969Passenger—126 WEST 46 STREET————
    M00243855-I11F5696ElevatorRemoved1F5696FreightN/A1 EAST 70 STREETNoNoNoNo
    M00643244-I11P13236ElevatorActive1P13236Passenger—29 EAST 45 STREET————
    M00047252-I11P37080ElevatorRemoved1P37080PassengerN/A686 BROADWAYYesNoNoNo
    M00442288-I11P26034ElevatorActive1P26034Passenger—1532 YORK AVENUE————
    B00205361-I13P14888ElevatorActive3P14888PassengerN/A2236 NOSTRAND AVENUEYesYesYesNo
    M00267166-I11P12074ElevatorActive1P12074PassengerN/A121 FULTON STREETYesNoNoNo
    M00507170-I11D0993371DumbwaiterActive———30 PELL STREET————
    Q00451442-I14P0992758ElevatorActive—PassengerN/A21-15 75 STREETNoNoYesYes

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

    building_elevator_numbers
    text
    —
    61%
    1PE1PE2
    bis_nyc_device_idtext—14%1P259504P51603P3987
    elevator_typecategorical—7%PassengerFreightEscalatorof 6
    elevator_sub_typecategorical—18%N/AShipboard ElevatorPrivate residenceof 9
    physical_addressaddress—0%200 PARK AVENUE66 HUDSON BOULEVARD415 10 AVENUE
    only_elevator_in_buildingcategorical—18%NoYesof 2
    occupant_evacuation_elevatorcategorical—18%NoYesof 2
    meets_the_stretcher_carcategorical—18%NoYesof 2
    device_confirming_with_seismiccategorical—18%NoYesof 2
    fire_emergency_phasecategorical—18%YesNoof 2
    destination_dispatch_systemcategorical—18%NoYesof 2
    fire_service_access_elevatorcategorical—18%NoYesof 2
    device_in_conjunction_withcategorical—14%NoYesof 2
    new_hoistwaycategorical—18%NoYesof 2
    loft_law_buildingcategorical—18%NoYesof 2
    device_job_descriptiontext—10%Provide door lock monito…PROVIDE NEW DOOR LOCK MO…Provide New Door Lock Mo…
    machine_manufacturertext—34%Hollister WhitneyOtisIMPERIAL
    machine_modeltext—39%existingEXISTINGExisting
    machine_typecategorical—10%TractionHydraulicMRLof 13
    type_of_machine_breakcategorical—17%DrumDiscN/Aof 5
    machine_locationtext—17%OverheadOVERHEADoverhead
    controller_manufacturertext—43%MCEESIOtis
    controller_modeltext—46%VVVFKCM831A1
    controller_locationtext—17%OverheadOVERHEADROOF
    hoist_rope_qtytext—28%645
    hoist_rope_sizetext—29%1/25/81/2"
    hoist_rope_ultimate_strengthtext—44%145002300014,500
    hoist_rope_materialcategorical—31%SteelBeltIronof 3
    car_counterweight_ropes_qtytext—87%N/A05
    car_counterweight_ropes_sizetext—93%N/A05/8
    car_counterweight_ropestext—93%N/A023,000
    car_counterweight_ropes_1categorical—97%SteelIronBeltof 3
    machine_counterweight_ropestext—90%N/A0NA
    machine_counterweight_ropes_1text—95%N/A05/8
    machine_counterweight_ropes_2text—95%N/A08200
    machine_counterweight_ropes_3categorical—99%SteelIronBeltof 3
    cargovernor_ropes_qtytext—32%1N/A01
    cargovernor_ropes_sizetext—33%3/81/23/8"
    cargovernor_ropes_ultimatetext—48%8200145008,200#
    cargovernor_ropes_materialcategorical—37%SteelIronBeltof 3
    cwtgovernor_ropes_qtytext—77%1N/A0
    cwtgovernor_ropes_sizetext—82%3/81/2N/A
    cwtgovernor_ropes_ultimatetext—92%N/A014500
    cwtgovernor_ropes_materialcategorical—85%SteelIronBeltof 3
    cargovernor_locationtext—37%OverheadOVERHEADoverhead
    cargovernor_tripping_speedinteger—39%175452280
    cargovernor_typecategorical—29%CentrifugalFly BallTensionof 3
    cwtgovernor_locationtext—90%N/AOverheadOVERHEAD
    cwtgovernor_tripping_speedinteger—95%013201584
    cwtgovernor_typecategorical—81%CentrifugalFly BallTensionof 3
    powertypecategorical—10%ACDCof 2
    main_supply_power_typecategorical—10%ACDCof 2
    travel_from_floortext—2%B1C
    travel_to_floortext—2%657
    total_travel_feetinteger—9%607065
    number_of_stopsinteger—10%726
    elevator_capacity_lbstext—2%200035002500
    elevator_speed_fpminteger—5%100350200
    elevator_controlcategorical—13%Solid StateResistanceMulti-Voltageof 4
    mode_of_operationcategorical—13%Automatic P.B.Constant Pressureof 2
    load_weighing_devicecategorical—14%NoYesof 2
    glass_hoistwaycategorical—18%NoYesof 2
    atruim_elevatorcategorical—18%NoYesof 2
    regenerative_drivecategorical—18%NoYesof 2
    car_safety_typecategorical—9%Flexible GuideInstantaneousGradual WCof 8
    car_safety_type_othertext—99%Rupture ValveRUPTURE VALVEWinding Drum
    counter_weight_safety_typecategorical—15%N/AFlexible GuideGradual WCof 8
    counter_weight_safety_type_1text—100%SA SGM 02SA SGM02SA SGC 02
    car_openingcategorical—16%DoorGateof 2
    car_opening_directioncategorical—16%HorizontalVerticalof 2
    car_opening_operationcategorical—16%PowerManualof 2
    contact_typetext—11%GGSg
    elevator_manufacturertext—10%GALG.A.L.gal
    car_to_counterweight_ratiofloat—56%4017500E-10
    top_emergency_exit_min_areainteger—18%4003576
    top_emergency_exit_min_sideinteger—18%162024
    car_inside_width_feetinteger—11%654
    car_inside_width_inchescategorical—11%80E-106of 12
    car_inside_depth_feetinteger—11%453
    car_inside_depth_inchescategorical—11%0E-1036of 12
    car_inside_areafloat—11%24.0828.3336.11
    sized_for_stretchercategorical—18%NoYesof 2
    glass_carcategorical—18%NoYesof 2
    multicompartmentcategorical—18%NoYesof 2
    hoist_openingcategorical—10%DoorGateof 2
    hoist_directioncategorical—10%HorizontalVerticalof 2
    elevator_operationcategorical—14%PowerManualof 2
    elevator_doorfeaturescategorical—12%InterlocksLocks & ContactsVision Panelof 5
    interlocks_typetext—19%MONMOH
    hoist_manufacturertext—19%GALG.A.L.gal
    elevator_landingtext—18%76B, 1-6
    number_of_openings_frontinteger—10%712
    number_of_openings_sideinteger—10%012
    number_of_openings_rearinteger—10%012
    total_number_of_openingsinteger—1%702
    door_monitoring_circuitscategorical—18%YesNoof 2
    fire_rated_construction_typecategorical—14%YesNoof 2
    self_closing_emergency_doorscategorical—18%NoYesof 2
    interlockin_blind_hoistwaycategorical—18%NoYesof 2
    car_buffer_typecategorical—10%OilSpringOtherof 3
    car_buffer_manufacturertext—14%EXISTINGHollister WhitneyOtis
    car_buffer_engagement_speedinteger—14%100200350
    car_buffer_stroke_feetinteger—14%012
    car_buffer_stroke_inchesfloat—14%495
    car_buffer_reduced_strokecategorical—18%NoYesof 2
    counterweight_buffercategorical—93%NoYesof 2
    counter_weight_buffer_typecategorical—43%OilSpringOtherof 3
    counter_weight_buffertext—45%Hollister WhitneyOtisOTIS
    counter_weight_buffer_1integer—45%350200100
    counter_weight_buffer_strokeinteger—43%012
    counter_weight_buffer_stroke_1float—43%945
    compensation_meanscategorical—18%N/AChainRopeof 3
    elevator_length_feetinteger—18%01601
    elevator_length_inchescategorical—18%0E-1064of 12
    counter_weight_buffer_reducedcategorical—19%NoYesof 2
    occupied_space_belowcategorical—13%NoYesof 2
    compensation_tie_downcategorical—18%NoYesof 2
    counter_weight_guardcategorical—18%NoYesof 2
    attendant_operationcategorical—98%NoYesof 2
    glass_or_transparentcategorical—98%NoYesof 2
    pit_depthinteger—98%312
    conveyor_configurationcategorical—99%213of 3
    conveyor_safety_device_typetext—100%N/AInstantaneousInstantaneous wedge type…
    conveyor_counter_weight_safetycategorical—100%N/An/anaof 15
    hole_less_elevatorcategorical—89%YesNoof 2
    plunger_typecategorical—35%Double PlungerSingle Plungerof 2
    car_buffercategorical—93%YesNoof 2
    counter_weight_buffer_2text—75%YesYESN/A
    accessibility_liftcategorical—98%Platform LiftStairway Chairliftof 2
    conveyor_typecategorical—99%Vertical Reciprocating c…Belt conveyorMaterial Liftof 14
    machine_jack_typecategorical—89%Single JackDual Jackof 2
    overload_devicecategorical—99%NoYesof 2
    platform_lift_typecategorical—98%Vertical Platform LiftInclined Platform LiftPrivate Residence Vertic…of 4
    car_hoist_cwt_or_noncwtcategorical—96%Non-CounterweightCounterweightof 2
    car_hoist_locationcategorical—96%OutsideInsideof 2
    private_residencecategorical—97%NoYesof 2
    car_hoist_openingcategorical—96%DualSingleof 2
    hoist_capacitytext—96%700060007100
    hoist_car_weighttext—96%550058507981
    hoist_car_manufacturertext—96%STROSALIMAKAlimak
    hoist_counter_weightedcategorical—96%21of 2
    hoist_mast_manufacturertext—96%STROSALIMAKAlimak
    hoist_safety_serial_numbertext—96%518545185351987
    hoist_safety_expiration_datedate—96%2024-11-302022-12-312024-10-31
    hoist_model_numtext—96%SCANDONOV 3242NOV 2738
    hoist_safety_capacitytext—96%1622516,22513450
    escalator_energy_savingcategorical—99%NoYesof 2
    escalator_angle_of_inclinationcoordinate—99%30.000000000031.000000000035.0000000000of 17
    escalator_brake_torquecoordinate—99%50.0000000000100.0000000000120.0000000000
    escalator_capacity_lbscoordinate—99%6000.00000000009000.00000000004500.0000000000
    flame_heat_smoke_protectioncategorical—99%YesNoof 2
    escalator_manufacturertext—99%SchindlerOtisKONE
    escalator_modeltext—99%9300existingEXISTING
    escalator_number_of_flattext—99%213
    outdoor_escalatorcategorical—99%NoYesof 2
    escalator_rise_feetcoordinate—99%16.000000000012.000000000013.0000000000
    escalator_rise_inchescoordinate—99%0.00000000006.00000000005.0000000000of 12
    escalator_speedcoordinate—99%100.000000000090.000000000098.0000000000
    escalator_step_width_feetcoordinate—99%3.00000000002.00000000001.0000000000of 15
    escalator_step_width_inchescoordinate—99%0.00000000004.00000000008.0000000000of 11
    escalator_tandem_operationcategorical—99%NoYesof 2
    escalator_travel_from_floortext—99%123
    escalator_travel_to_floortext—99%213