From a 500-row sample across 18 columns.
certificate_of_inspectionbusiness_namenoh_number+4business_namebusiness_unique_idbusiness_category+1outcomebusiness_namebusiness_unique_idrecord_id+1| record_id | related_record_type | business_unique_id | business_name | business_category | certificate_of_inspection | inspection_number | noh_number | violation_date | charge | charge_count | cure_eligible |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0001-2026-ADJC | dcwp_InspectionRequest | BA-1684832-2024 | OFERTAS Y REBAJAS INC. | Electronics Store | A0257582 | INS-000910592 | 25Q03570 | 2025-12-04T00:00:00.000 | NYC Admin Code § 20-610(a) - Business unlawfully distributes, sells, leases, rents, or offers for sale, lease, or rent, a powered bicycle without an accredited safety certification. |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
record_id | text | An identification number assigned by DCWP to record each application received | 0% | 45592-2025-ADJC3735-2026-ADJC5274-2026-ADJC |
related_record_type | categorical | Indicates whether the charges resulted from a business inspection conducted by the Enforcement division or from an investigation by the Office of General Counsel. | 0% | dcwp_InspectionRequestdcwp_legalof 2 |
business_unique_id | text | An identification number assigned by DCWP to track unique businesses across its systems. | 0% | BA-1675997-2023BA-1606364-2023BA-1681294-2023 |
business_name | text | The name of the business. |
GET /api/datasets/5fn4-dr26 GET /api/datasets/5fn4-dr26/quality GET /api/datasets/5fn4-dr26/related GET /api/columns?dataset=5fn4-dr26
business_namebusiness_unique_idbusiness_category+1business_namebusiness_unique_idbusiness_category+1business_name| 3 |
| No |
| 0001-2026-ADJC | dcwp_InspectionRequest | BA-1684832-2024 | OFERTAS Y REBAJAS INC. | Electronics Store | A0257582 | INS-000910592 | 25Q03570 | 2025-12-04T00:00:00.000 | NYC Admin Code § 20-610(b) - Business unlawfully distributes, sells, leases, rents, or offers for sale, lease, or rent, a powered mobility device without an accredited safety certification. | 2 | No |
| 0001-2026-ADJC | dcwp_InspectionRequest | BA-1684832-2024 | OFERTAS Y REBAJAS INC. | Electronics Store | A0257582 | INS-000910592 | 25Q03570 | 2025-12-04T00:00:00.000 | NYC Admin Code § 20-610.1(c) - Failure to conspicuously post informational materials near devices | 1 | No |
| 0005-2026-ADJC | dcwp_InspectionRequest | BA-1758565-2025 | HERNANDEZ DELI CORP | Grocery-Retail | A0261067 | INS-000916827 | 25N03525 | 2025-12-31T00:00:00.000 | 6 RCNY § 5-37 - REFUND POLICY IS NOT POSTED AT EACH OF CASH REGISTER/S OR AT EACH OF POINTS OF SALE OR AT EACH OF THE STORE ENTRANCES OR REFUND POLICY IS NOT POSTED CONSPICUOUSLY | 1 | Yes |
| 0005-2026-ADJC | dcwp_InspectionRequest | BA-1758565-2025 | HERNANDEZ DELI CORP | Grocery-Retail | A0261067 | INS-000916827 | 25N03525 | 2025-12-31T00:00:00.000 | NYC Admin Code § 16-401(c)(1) - Food service establishment providing single-use plastic beverage straws that are not compostable without request from person. | 1 | — |
| 0006-2026-ADJC | dcwp_InspectionRequest | BA-1653418-2023 | CLEAN CITY LAUNDRY OF ROCKAWAY INC | Retail Laundry | A0257851 | INS-000911044 | 25Q03597 | 2025-12-05T00:00:00.000 | 6 RCNY § 4-131(a)(4)(ii) - BUSINESS FAILS TO POST OUT OF ORDER SIGN AT EACH DEFECTIVE OR INOPERABLE MACHINE, OR SIGN IS LESS THAN 2 INCHES HIGH | 1 | No |
| 0007-2026-ADJC | dcwp_InspectionRequest | BA-1328970-2022 | LI & WU HILLSIDE LAUNDROMAT INC | Retail Laundry | A0258067 | INS-000911469 | 25Q03608 | 2025-12-09T00:00:00.000 | 6 RCNY § 4-131(a)(4)(ii) - BUSINESS FAILS TO POST OUT OF ORDER SIGN AT EACH DEFECTIVE OR INOPERABLE MACHINE, OR SIGN IS LESS THAN 2 INCHES HIGH | 1 | No |
| 0008-2026-ADJC | dcwp_InspectionRequest | BA-1758565-2025 | HERNANDEZ DELI CORP | Tobacco Retail Dealer | A0261067 | INS-000916828 | 25N03526 | 2025-12-31T00:00:00.000 | NYC Admin Code § 17-706(c) - FAILED TO POST AGE RESTRICTION SIGN IN A CONSPICUOUS PLACE | 1 | No |
| 0009-2026-ADJC | dcwp_InspectionRequest | BA-1651465-2023 | AL'S EXPRESS LAUNDRY LLC | Retail Laundry | A0258146 | INS-000911602 | 25Q03617 | 2025-12-09T00:00:00.000 | 6 RCNY § 4-131(a)(4)(i) - BUSINESS FAILS TO POST COMPLAINT AND REFUND SIGN PROMINENTLY AND CONSPICUOUSLY | 1 | No |
| 0009-2026-ADJC | dcwp_InspectionRequest | BA-1651465-2023 | AL'S EXPRESS LAUNDRY LLC | Retail Laundry | A0258146 | INS-000911602 | 25Q03617 | 2025-12-09T00:00:00.000 | 6 RCNY § 4-131(a)(4)(ii) - BUSINESS FAILS TO POST OUT OF ORDER SIGN AT EACH DEFECTIVE OR INOPERABLE MACHINE, OR SIGN IS LESS THAN 2 INCHES HIGH | 1 | Yes |
Showing 12 of 14 columns. All of them are listed below.
| 0% |
SP PLUS CORPORATIONCVS ALBANY, L.L.CDUANE READE INC |
dba_trade_name | text | The "Doing Business As" or "Trade Name" registered with the NYS Department of State. | 89% | METROPOLISKEY FOODAKA Icon Parking LLC |
business_category | text | The business activity or business category requiring a DCWP-issued license in order to operate legally within NYC. | 0% | Tobacco Retail DealerElectronic Cigarette Dea…Grocery-Retail |
certificate_of_inspection | text | An identification number assigned to track DCWP inspectors' visits to businesses | 1% | A0242476A0235452A0240825 |
inspection_number | text | An identification number assigned to an inspection of a business. | 1% | INS-000933321INS-000930927INS-000932612 |
noh_number | text | The "Notice of Hearing" number, also referred to as "Summons Number". | 0% | 200010TR.26X0047126N00855 |
violation_date | datetime | The date the inspection that resulted in the charges was conducted. For legal investigations, the date the charges were filed. | 0% | 2024-05-15T00:00:00.0002025-08-07T00:00:00.0002025-08-19T00:00:00.000 |
charge | text | The section of law or regulation that was not in compliance and description of the violation. | 0% | NYC Admin Code § 20-202(…NYC Admin Code § 20-561(…NYC Admin Code § 17-715(… |
charge_count | integer | The number of charges of this type. | 0% | 1202 |
cure_eligible | categorical | Indicates whether the specific charge is eligible for cure or zero-dollar fine. | 13% | NoYesof 2 |
cured | categorical | Indicates whether the respondent pled guilty to the charge and certified that the violation has been corrected. | 87% | NoYesof 2 |
outcome | categorical | The outcome of the adjudication process. | 17% | Default DecisionPleadedHearing Decisionof 7 |
guilty | integer | Number of counts where the respondent was found guilty via decision. | 21% | 1202 |
not_guilty | integer | Number of counts where the respondent was found not guilty | 95% | 0120 |
dismissed | integer | Number of counts dismissed. | 99% | 1202 |