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

Invoices for Open Market Order (OMO) Charges

emrz-5p35Housing & Development13 columns
Contains information about invoices submitted to HPD by private contractors under an OMO. This is part of the HPD Charge Data collection of data tables.
View on NYC Open Data↗

Quality

B88.9 / 100

From a 500-row sample across 13 columns.

completeness99/ 25% weight
consistency65/ 20% weight
accuracy85/ 20% weight
timeliness100/ 15% weight
usability95/ 20% weight

Related datasets

  • Handyman Work Order (HWO) Charges0.50
    joins ondatetransferdofadminfeechargeamount+1
  • Open Market Order (OMO) Charges0.46
    joins onomonumber
  • Fee Charges0.44
  • Registration Contacts0.37
  • Multiple Dwelling Registrations0.37
  • Local Law 44 - Projects0.35
  • Buildings Subject to HPD Jurisdiction

Sample rows

invoiceidinvoicesequenceidomonumberinvoicestatusinvoicedateinvoicebillamountinvoicepayamountsalestaxadminfeepaymentidchargeamountdatetransferdof
1EK08601EK08601VCREATE2019-10-21T00:00:00.00050504.4425226437579.442020-02-05T00:00:00.000
1

Columns

13 queryable · 13 profiled

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

FieldTypeDescriptionNullValues
invoiceidintegerSequential number of the Invoice unique within the OMO0%123
invoicesequenceidtextVendor’s identifier of Invoice0%12452015010000033
omonumbertextIdentifier of owning OMO0%EF02298EG07899EF03440
invoicestatuscategoricalCurrent status of Invoice0%VCREATENOPAYHLDof 13

Query this from your own app

GET /api/datasets/emrz-5p35
GET /api/datasets/emrz-5p35/quality
GET /api/datasets/emrz-5p35/related
GET /api/columns?dataset=emrz-5p35
0.35
  • Housing Litigations0.34
    • EK08607
    EK08607
    VCREATE
    2019-12-17T00:00:00.000
    50
    50
    4.44
    25
    2263930
    79.44
    2020-02-05T00:00:00.000
    1EK08644EK08644VCREATE2019-11-15T00:00:00.00029529526.18147.52264634468.682020-02-05T00:00:00.000
    1EK08678EK08678VCREATE2019-10-15T00:00:00.00050504.4425226526079.44—
    1EK08702EK08702VCREATE2019-11-05T00:00:00.00030030026.631502263358476.632020-02-05T00:00:00.000
    1EK08703EK08703VCREATE2019-10-22T00:00:00.00050504.4425226491079.442020-02-05T00:00:00.000
    1EK08710EK08710VCREATE2019-10-28T00:00:00.00016516514.6482.52264558262.142020-02-05T00:00:00.000
    1EK08713EK08713VCREATE2019-12-03T00:00:00.00050504.4425226499779.442020-02-05T00:00:00.000
    1EK08716EK08716VCREATE2019-12-17T00:00:00.00050504.4425226393179.442020-02-05T00:00:00.000
    183277970EN00068VCREATE2023-12-05T00:00:00.000929244624182281422024-01-16T00:00:00.000

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

    invoicedate
    datetime
    Vendor's date on Invoice
    0%
    2005-05-25T00:00:00.0002006-10-31T00:00:00.0002006-01-31T00:00:00.000
    invoicebillamountfloatAmount billed on Invoice0%1005070
    invoicepayamountfloatCurrent amount HPD authorizes to pay on invoice0%1005070
    salestaxfloatImputed sales tax for this invoice0%8.884.440
    adminfeefloatHPD's current administrative cost charged for this Invoice0%157525
    paymentidintegerUnique identifier of PAYMENTS record4%273027312732
    chargeamountfloatTotal lienable amount of to be transferred to DoF0%079.44158.88
    datetransferdofdatetimeDate this charge was transfered to DoF to be liened.7%2019-07-17T00:00:00.0002005-11-22T00:00:00.0002012-07-20T00:00:00.000
    unique_keytext—0%D000005_1_15516D000006_1_7562D000020_1_14057