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

Handyman Work Order (HWO) Charges

sbnd-xujnHousing & Development32 columns
Contains information about work orders created to conduct emergency repair work when an owner fails to address a hazardous condition pursuant to the requirements of an HPD issued violation. HPD issues violations when an owner fails to address a condition pursuant New York City Housing Maintenance Code (HMC) or the New York State Multiple Dwelling Law (MDL), a Department of Buildings Declaration of Emergency, a Department of Health Commissioner's Order to Abate or an emergency violation issued by another City Agency. The work orders were carried out by agency staff. This is part of the HPD Charge Data collection of data tables.
View on NYC Open Data↗

Quality

A91.3 / 100

From a 500-row sample across 29 columns.

completeness96/ 25% weight
consistency66/ 20% weight
accuracy96/ 20% weight
timeliness100/ 15% weight
usability100/ 20% weight
  • · Has coordinates — directly mappable, and joinable to other NYC datasets

Related datasets

  • Open Market Order (OMO) Charges0.67
    joins onlifecyclecouncil_districtcensus_tract+18
  • Fee Charges0.53
    joins onlifecyclecouncil_districtcensus_tract+14
  • Invoices for Open Market Order (OMO) Charges0.50
    joins onsalestaxchargeamountadminfee+1
  • Housing Litigations0.44
    joins oncouncil_district

Geography

Mappable — coordinate pair `latitude` / `longitude`.

Open on the map →

Sample rows

hwoidhwonumberbuildingidboroidborohousenumberstreetnamezipblocklotlifecycleworktypegeneral
3653508EF065513034013BROOKLYN89GRATTAN STREET11237300441Standing BuildingGC
4645929EJ02360109435

Columns

32 queryable · 32 profiled

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

FieldTypeDescriptionNullValues
hwoidintegerUnique number identifying this HWO0%148064714879741489502
hwonumbertextHPD unique identifier of HWO0%E517714E520439E520939
buildingidintegerUnique identifier of building0%807742077258700
boroidcategoricalUnique identifier of borough0%321of 5
borocategorical

Query this from your own app

GET /api/datasets/sbnd-xujn
GET /api/datasets/sbnd-xujn/quality
GET /api/datasets/sbnd-xujn/related
GET /api/columns?dataset=sbnd-xujn
census_tract
bin
+11
  • Housing Maintenance Code Complaints and Problems0.43
    joins oncouncil_districtcensus_tractbin+7
  • Buildings Subject to HPD Jurisdiction0.43
    joins onlifecyclebinlot+7
  • Housing Maintenance Code Violations0.42
    joins onbinlotnta+10
  • Multiple Dwelling Registrations0.41
    joins onbinlotblock+6
    • 2
    BRONX
    1225
    SHERIDAN AVENUE
    10456
    2457
    26
    Standing Building
    DELEAD
    2103028EA00992634812BRONX341EAST 146 STREET10451232994Standing BuildingDELEAD
    3099848ED102246528484QUEENS88-35ELMHURST AVENUE11373151226Standing BuildingGC
    2785374EB352355265874QUEENS155-44114 ROAD114341218730Standing BuildingPLUMB
    4674193EJ048642176243BROOKLYN1520CARROLL STREET1121314127501Standing BuildingGC
    1707971E8211573214383BROOKLYN814KNICKERBOCKER AVENUE11207341829Standing BuildingDELEAD
    4678994EJ05510272021MANHATTAN1795RIVERSIDE DRIVE100342246125Standing BuildingGC
    2041497E9262186319484QUEENS416BEACH 25 STREET116911577458Standing BuildingPLUMB
    5133608EL237061655353BROOKLYN120266 STREET1121957607Standing BuildingGC

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

    Boro code (1 = Manhattan, 2 = Bronx, 3 = Brooklyn, 4 = Queens, 5 = Staten Island)
    0%
    BROOKLYNBRONXMANHATTANof 5
    housenumbertextPrinciple house number0%2092015
    streetnametextThe normalized street name associated with a given Geosupport Information System (GIS) Street Code0%GRAND CONCOURSEBROADWAYOCEAN AVENUE
    ziptextZipcode for the property0%112261122111237
    blockintegerNumber assigned by DoF identifying the Tax block in which the lot is included0%213621171988
    lotintegerUnique number assigned by DoF identifying the lot within a Tax Block0%1640
    lifecyclecategoricalThe stage in the building life cycle0%Standing BuildingDemolished BuildingVacant Landof 5
    worktypegeneralcategoricalGeneral description of type of work performed by this HWO0%GCDELEADPLUMBof 18
    hwostatusreasontextReason this HWO was closed0%OMO CompletedWork Done by OthersNo Access
    hwocreatedatedatetimeDate HWO was created by system0%2025-07-02T00:00:00.0002021-10-26T00:00:00.0002025-04-21T00:00:00.000
    isaeptextIndicates if this HWO was created thru the Alternative Enforcement program99%AEPof 1
    iscommercialdemolitiontextIndicates if this HWO was for the demolition of commercial property100%—
    femaeventidcategoricalunique identifier of FEMA event100%03662of 3
    femaeventcategoricalName of FEMA reimbursable event100%Hurricane SandyHof 2
    hwodescriptiontextDescription of HWO0%local law #1 violation :…local law #1 violation :…as per hpd's lead abatem…
    hwoapprovedamountfloatThe total cost of the HWO (labor + materials)0%024.2148.42
    salestaxfloatImputed sales tax for this HWO0%02.150.73
    adminfeefloatHPD's current administrative cost charged for this HWO0%0156.05
    chargeamountfloatTotal lienable amount to be transferred to DoF0%041.313.08
    datetransferdofdatetimeDate this charge was transferred to DoF to be liened20%2019-07-12T00:00:00.0002007-04-20T00:00:00.0002006-06-20T00:00:00.000
    latitudecoordinate—0%40.82781640.84149840.826433
    longitudecoordinate—0%-73.949427-73.948344-73.945794
    community_boardcategorical—0%4125of 18
    council_districttext—0%371514
    census_tracttext—0%245225253
    bintext—0%300000010619691061959
    bbltext—0%102079000110207800113048710052
    ntatext—0%Crown Heights NorthBushwick NorthFlatbush