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

Open Market Order (OMO) Charges

mdbu-nrqnHousing & Development32 columns
The data set contains information on work orders created through HPD's Emergency Repair Program, Alternative Enforcement Program and Demolition programs and fees assessed against properties by HPD pursuant to the Housing Maintenance Code. The work orders are created to conduct emergency repair work when an owner fails to address a hazardous condition pursuant to the requirements of an HPD-issued violation, 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 may be issued to a private vendor following the City's Procurement Rules or may be conducted by agency staff. This is part of the HPD Charge Data collection of data tables.
View on NYC Open Data↗

Quality

A91.2 / 100

From a 500-row sample across 30 columns.

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

Related datasets

  • Handyman Work Order (HWO) Charges0.67
    joins onlatitudefemaeventiscommercialdemolition+18
  • Fee Charges0.53
    joins onlatitudeblockstreetname+13
  • Invoices for Open Market Order (OMO) Charges0.46
    joins onomonumber
  • Housing Litigations0.46
    joins onlatitudeblockstreetname+10

Geography

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

Open on the map →

Sample rows

omoidomonumberbuildingidboro_idborohousenumberstreetnamezipblocklotlifecycleworktypegeneral
5355228DO0006510097032Bronx211EAST 188 STREET10458315341Standing BuildingDEMOL
4988169DL00071507427

Columns

32 queryable · 32 profiled

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

FieldTypeDescriptionNullValues
omoidintegerUnique number identifying OMO0%6626536268
omonumbertextHPD unique identifier of OMO0%D000002D000004D000005
buildingidintegerHPD unique identifier of the building0%6049189503115724
boro_idcategoricalUnique identifier of a borough0%321of 5
borocategorical

Query this from your own app

GET /api/datasets/mdbu-nrqn
GET /api/datasets/mdbu-nrqn/quality
GET /api/datasets/mdbu-nrqn/related
GET /api/columns?dataset=mdbu-nrqn
  • Buildings Subject to HPD Jurisdiction0.45
    joins onblockstreetnamebuildingid+6
  • Housing Maintenance Code Complaints and Problems0.43
    joins onlatitudeblocklot+8
  • Housing Maintenance Code Violations0.42
    joins onlatitudeblockstreetname+10
  • Multiple Dwelling Registrations0.40
    joins onblockstreetnamebuildingid+5
    • 4
    Queens
    143-31
    97 AVENUE
    11435
    10008
    27
    Standing Building
    GC
    5268709DN000013036143Brooklyn143GREEN STREET11222251258Standing BuildingASBEST
    4971951EL003003219513Brooklyn1050LAFAYETTE AVENUE11221161219Standing BuildingGC
    5272679EN023023358253Brooklyn333MENAHAN STREET11237331048Standing Building7AFA
    5370669EO082576767574Queens64-36MADISON STREET11385361965Standing BuildingGC
    5027912EL07415890612Bronx1419JESUP AVENUE10452287229Standing BuildingGC
    5371519EO086548095543Brooklyn726STANLEY AVENUE1120743771Standing BuildingGC
    4956440EK25397648392Bronx865EAST 165 STREET10459269144Standing BuildingGC
    4956443EK25400589622Bronx628COURTLANDT AVENUE1045123987Standing BuildingGC

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

    Boro code (1 = Manhattan, 2 = Bronx, 3 = Brooklyn, 4 = Queens, 5 = Staten Island)
    0%
    BrooklynBronxManhattanof 5
    housenumbertextPrincipal house number0%2092015
    streetnametextThe normalized street name associated with a given Geosupport Information System (GIS) Street Code0%GRAND CONCOURSEBROADWAYOCEAN AVENUE
    apartmenttext—25%123
    ziptextZipcode for the property0%112261122111233
    blockintegerNumber assigned by DoF identifying the Tax block in which the lot is included0%213633041988
    lotintegerUnique number assigned by DoF identifying the lot within a Tax Block0%1620
    lifecyclecategoricalThe stage in the building life cycle0%Standing BuildingDemolished BuildingVacant Landof 5
    worktypegeneraltextGeneral Description of Type of work performed by this OMO0%GCDELEADUTIL
    omostatusreasontextReason this OMO was closed1%OMO CompletedNo AccessLandlord Complied
    omoawardamountfloatAmount this OMO was awarded for0%1500
    omocreatedatedatetimeDate OMO was created by system0%2014-07-01T00:00:00.0002013-07-01T00:00:00.0002011-07-01T00:00:00.000
    netchangeordersintegerNet value of approved Change Orders associated with this OMO0%0of 1
    omoawarddatedatetimeDate OMO was awarded4%2014-07-01T00:00:00.0002013-07-01T00:00:00.0002011-07-01T00:00:00.000
    isaeptextIndicates if this OMO was created thru the Alternative Enforcement program93%AEPof 1
    iscommercialdemolitiontextIndicates if this OMO was for the demolition of commercial property100%COMM DEMOLof 1
    servicechargeflagcategoricalIndicates if there is a service charge associated with this OMO0%FalseTrueof 2
    femaeventidcategoricalUnique identifier of FEMA Event100%36602398of 3
    femaeventcategoricalName of FEMA reimbursable event100%Hurricane SandyHurricane Idaof 2
    omodescriptiontextDescription of OMO0%perform total lead analy…as per hpd's lead abatem…nationalgrid provide gas…
    latitudecoordinate—0%40.85746240.82066640.839424
    longitudecoordinate—0%-73.905634-73.895902-73.845226
    community_boardtext—0%1245
    council_districttext—0%371536
    census_tracttext—0%245225253
    bintext—0%300000040000002000000
    bbltext—0%304271900120319600182027030018
    ntatext—0%Crown Heights NorthFlatbushBushwick North