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 Job Application Filings

ic3t-wcy2Housing & Development95 columns
This dataset contains all job applications submitted through the Borough Offices, through eFiling, or through the HUB, which have a "Latest Action Date" since January 1, 2000. This dataset does not include jobs submitted through DOB NOW. See the DOB NOW: Build – Job Application Filings dataset for DOB NOW jobs.
View on NYC Open Data↗

Quality

B87.5 / 100

From a 500-row sample across 90 columns.

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

Related datasets

  • DOB NOW: Build – Job Application Filings0.52
    joins oninitial_costowner_s_business_namestate+21
  • DOB Permit Issuance0.46
    joins onowner_s_business_namegis_council_districtstate+20
  • DOB NOW: Build – Approved Permits0.41
    joins onstreet_namejob_descriptionborough+3
  • DOB Sign Application Filings0.39

Geography

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

Sample rows

job_s1_nojob__doc__boroughhouse__street_nameblocklotbin__total_construction_floor_areajob_typejob_status
329471944067385201QUEENS246-08135 ROAD132280000942843350A2X
329472642178955901

Columns

95 queryable · 95 profiled

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

FieldTypeDescriptionNullValues
job_s1_notextJOB_S1_NO0%100000110000021000003
job__textNumber assigned by DOB to Job Filing0%200478250301199281401323331
doc__categoricalDocument Number0%010203of 13
boroughcategorical1= Manhattan, 2= Bronx, 3 = Brooklyn, 4 = Queens, 5 = Staten Island0%MANHATTANBROOKLYNQUEENSof 5

Query this from your own app

GET /api/datasets/ic3t-wcy2
GET /api/datasets/ic3t-wcy2/quality
GET /api/datasets/ic3t-wcy2/related
GET /api/columns?dataset=ic3t-wcy2
joins onadult_estabinitial_costlandmarked+36
  • DOB NOW: Build Elevator Permit Applications0.38
    joins onstreet_nameboroughbuilding_type+5
  • DOB Cellular Antenna Filings0.37
    joins oninitial_costlandmarkedowner_s_business_name+38
  • DOB NOW: Safety – Facades Compliance Filings0.33
    joins onstreet_nameboroughlot+1
  • DOB NOW: Build Elevator Device Details0.33
    • QUEENS
    98-87
    QUEENS BLVD
    02105
    00001
    4050525
    0
    DM
    R
    329470124030416701BRONX101LINCOLN AVE023160000121307350A3R
    333438344070770901QUEENS131-24223 STREET129320010842785320A2R
    330869434081935001BROOKLYN154872ND STREET061910002734291080A3J
    329473742178948901QUEENS91-57GAR109 STREET093160003344965640DME
    329475744067390501QUEENS64-46UTOPIA PARKWAY069040005741491020A2H
    329476144067391401QUEENS64-46UTOPIA PARKWAY069040005741491020A2X
    329476844067392301QUEENS2012STANHOPE STREET033790001640804470A2X
    329475834081124101BROOKLYN393EAST 57TH STREET079050002432215010A2X

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

    house__
    text
    House Number of Residence or Commercial Property
    0%
    1200100
    street_nametextStreet Name where Property is located0%BROADWAYPARK AVENUEMADISON AVENUE
    blocktextTax block assigned by Department of Finance0%000160083500972
    lottextTax lot assigned by Department of Finance0%000010750100029
    bin__textNumber assigned by City Planning to a specific building0%101586210143871076262
    total_construction_floor_areatextTotal Construction Floor Area0%01300
    job_typecategoricalJob Type, based on DOB Job Code (NB-New Building, A1, A2, A3- Alterations 1-3, SG-Sign, etc.)0%A2A3A1of 9
    job_statuscategoricalDOB Status code of job (A-Pre Filed, I-Sign Off, P- Approved, R-Permit Entire) Complete List - http://www.nyc.gov/html/dob/downloads/pdf/bisjobstatus.pdf0%XRPof 16
    job_status_descrpcategoricalStatus code description0%SIGNED OFFPERMIT ISSUED - ENTIRE J…PLAN EXAM - APPROVEDof 16
    latest_action_datedateLatest status date0%10/13/201702/12/201805/18/2017
    building_typecategorical1-2-3 Family or Other0%OTHERS1-2-3 FAMILYof 2
    community___boardtext3-digit identifier: Borough code = first position, last 2 = community board0%105108102
    clustercategoricalCluster36%NYof 2
    landmarkedcategoricalL code indicates that the building has been assigned landmark status6%NYLof 4
    adult_estabcategoricalAdult Estab11%NYof 2
    loft_boardcategoricalLoft Board20%NYof 2
    city_ownedcategoricalCity Owned92%YNIof 4
    little_ecategoricalHazardous41%NYHof 5
    pc_filedcategoricalApplication Filed electronically, rather than manually66%YNof 2
    efiling_filedcategoricalApplication Filed electronically, rather than manually39%YRNof 3
    plumbingtextPlumbing Work Type? (X=Yes, Blank=No)69%Xof 1
    mechanicaltextMechanical Work Type? (X=Yes, Blank=No)84%Xof 1
    boilertextBoiler Work Type? (X=Yes, Blank=No)97%Xof 1
    fuel_burningtextFuel Burning Work Type? (X=Yes, Blank=No)99%Xof 1
    fuel_storagecategoricalFuel Storage Work Type? (X=Yes, Blank=No)99%XNof 2
    standpipetextStandpipe Work Type? (X=Yes, Blank=No)99%Xof 1
    sprinklertextSprinkler Work Type? (X=Yes, Blank=No)94%Xof 1
    fire_alarmtextFire Alarm Work Type? (X=Yes, Blank=No)95%Xof 1
    equipmenttextEquipment Work Type? (X=Yes, Blank=No)83%Xof 1
    fire_suppressiontextFire Suppression Work Type? (X=Yes, Blank=No)98%Xof 1
    curb_cuttextCurb Cut Work Type? (X=Yes, Blank=No)96%Xof 1
    othertextOther? (X=Yes, Blank=No)40%Xof 1
    other_descriptiontextOther Description41%GEN. CONSTR.GCGEN. CONSTR
    withdrawal_flagcategoricalWithdrawal Indicator0%012of 13
    applicant_s_first_nametextFirst Name of Applicant0%MICHAELJOHNROBERT
    applicant_s_last_nametextLast Name of Applicant0%HOQUEKATZLEE
    applicant_professional_titletextApplicant's Professional Title0%PERAGC
    applicant_license__textNumber assigned to the skilled trade person/contractor or licensed professional3%083278050579066709
    professional_certcategoricalJob is Professionally Certified by Licensed Professional instead of having it reviewed by Department of Building's Plan Examiners21%YNJof 5
    pre__filing_datedateDate when job is prefiled0%06/28/201912/30/201406/27/2019
    paiddateDate when job is paid1%06/28/201912/30/201406/26/2008
    fully_paiddateDate when job is paid and entered0%06/28/201912/30/201406/26/2008
    assigneddateDate when job is assigned to plan examiner32%08/09/200107/01/200901/12/2018
    approveddateDate when job is approved18%06/26/200806/25/200805/21/2015
    fully_permitteddateDate when job is fully permitted26%08/15/200111/12/201507/25/2017
    signoff_datedateSign-off Date37%02/12/201801/25/201710/13/2017
    special_action_statuscategoricalSpecial Action Status1%NWAof 4
    special_action_datedateSpecial Action Date89%10/24/201205/12/201702/10/2017
    initial_costtextEstimated cost of job0%$0.00$10000.00$1000.00
    total_est__feetextEstimated fee of job0%$100.00$0.00$160.00
    fee_statuscategoricalType of Fee0%STANDARDEXEMPTDEFERREDof 3
    existing_zoning_sqftintegerExisting Zoning Sqft0%012000
    proposed_zoning_sqftintegerProposed Zoning Sqft0%01300
    horizontal_enlrgmtcategoricalHorizontal Enlrgmt97%YNof 2
    vertical_enlrgmtcategoricalVertical Enlrgmt98%YNof 2
    enlargement_sq_footageintegerEnlargement SQ Footage0%0200300
    street_frontageintegerStreet Frontage0%02550
    existingno_of_storiesintegerExistingNo. of Stories0%023
    proposed_no_of_storiesintegerProposed No. of Stories0%023
    existing_heightintegerExisting Height0%02530
    proposed_heightintegerProposed Height0%02530
    existing_dwelling_unitstextExisting Dwelling Units64%120
    proposed_dwelling_unitstextProposed Dwelling Units48%123
    existing_occupancytextExisting Occupancy30%RESCOME
    proposed_occupancytextProposed Occupancy40%RESCOMR-3
    site_fillcategoricalSite Fill20%NOT APPLICABLENONEON-SITEof 5
    zoning_dist1textZoning Distr 119%R6R5R3-2
    zoning_dist2textZoning Distr 289%R8BR6C5-2.5
    zoning_dist3textZoning Distr 399%C6-6R8BR6
    special_district_1textSpecial Distr 186%MIDLMSRD
    special_district_2categoricalSpecial District 295%POPSIBZMS4of 17
    owner_typecategoricalOwner Type4%INDIVIDUALCORPORATIONPARTNERSHIPof 14
    non_profitcategoricalNon-Profit4%NYof 2
    owner_s_first_nametextFirst Name of property owner0%MICHAELJOSEPHROBERT
    owner_s_last_nametextLast Name of property owner0%SINGHCOHENSONITIS
    owner_s_business_nametextBusiness Name of Property Owner2%N/ANANY SCHOOL CONSTRUCTION A…
    owner_s_house_numbertextHouse Number of Property Owner100%3259022
    owner_shouse_street_nametextHouse Street Name of Property Owner100%32 COURT ST SUITE 205590 MADISON AVENUE1950 Coney Island Avenue
    city_textCity100%BROOKLYNNEW YORKNY
    statecategoricalState100%NYMDNJof 3
    ziptextZip100%112011120410304
    building_classtextBuilding Class0%R0O4D4
    job_descriptiontextJob Description11%INSTALLATION OF SOLAR PA…FILING HEREWITH TAX ABAT…PROPOSED INSTALLATION OF…
    job_no_good_countcategoricalJob No Good Count0%01122of 13
    gis_latitudecoordinateLatitude0%40.75875440.74787840.751614
    gis_longitudecoordinateLongitude0%-73.978692-73.984979-73.992121
    gis_council_districttextCouncil District0%040301
    gis_census_tracttextCensus Tract0%10279
    gis_nta_nametextNTA Name0%Midtown-Times SquareUpper East Side-Carnegie…Midtown-Midtown South
    bbltextBIN1%300000040000001000000
    dobrundatedatetimeDate when query is run and pushed to Open Data. Could be used to differentiate report dates.0%2026-10-12T00:00:00.0002022-05-03T00:00:00.0002021-04-28T00:00:00.000