From a 500-row sample across 15 columns.
name| case_number | name | type | category | subcategory | opened | original_conference | original_trial_date | record_closed | report_issued | dispo_code | filing_agency_case_id |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 260790 | Mayor's Office of Special Enforcement v. Ahmed, Mafiz (05/20/2026) | License | Administrative Code | Q1 - License matters (other than TLC) | 2025-11-03T00:00:00.000 | 2026-01-08T00:00:00.000 | 2026-02-10T00:00:00.000 | 2026-02-25T00:00:00.000 | 2026-05-20T00:00:00.000 | 51 - License Revoked |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
filing_agency_case_id | text | The identifying number that belongs to the agency filing a case at OATH Trials Division | 16% | SEE NOTESv5375006 |
case_number | text | OATH Case ID | 0% | 221748140377171036 |
name | text | Full name of a case including petitioner's and/or respondent's names | 0% | Taxi and Limousine Commi…Department of CorrectionNavesink Prestige LLC v.… |
type | categorical | Indicates the type of case based on the categories of subject matter set by the Trials Division | 0% |
GET /api/datasets/y3hw-z6bm GET /api/datasets/y3hw-z6bm/quality GET /api/datasets/y3hw-z6bm/related GET /api/columns?dataset=y3hw-z6bm
| — |
| 232125 | Navesink Prestige LLC v. Department of Design and Construction (12/01/2025) | Contract | Contract Dispute Resolution Board | P4 - CD - Construction Contract | 2023-02-06T00:00:00.000 | — | — | 2025-12-01T00:00:00.000 | 2025-12-01T00:00:00.000 | 95 - CDRB-Claim Denied | ADR2022LW013885 |
| 232122 | Navesink Prestige LLC v. Department of Design and Construction (12/01/2025) | Contract | Contract Dispute Resolution Board | P4 - CD - Construction Contract | 2023-02-06T00:00:00.000 | — | — | 2025-12-01T00:00:00.000 | 2025-12-01T00:00:00.000 | 95 - CDRB-Claim Denied | ADR2020LW031282 |
| 232113 | Navensink Prestige v. Department of Design and Construction (12/01/2025) | Contract | Contract Dispute Resolution Board | P4 - CD - Construction Contract | 2023-02-06T00:00:00.000 | — | — | 2025-12-01T00:00:00.000 | 2025-12-01T00:00:00.000 | 95 - CDRB-Claim Denied | ADR2021LW000035 |
| 260850 | Mayor's Office of Special Enforcement v. Haque, Mafruha (05/20/2026) | License | Administrative Code | Q1 - License matters (other than TLC) | 2025-11-12T00:00:00.000 | 2026-01-12T00:00:00.000 | 2026-02-17T00:00:00.000 | 2026-02-25T00:00:00.000 | 2026-05-20T00:00:00.000 | 51 - License Revoked | — |
| 232118 | Navesink Prestige LLC v. Department of Design and Construction (12/01/2025) | Contract | Contract Dispute Resolution Board | P4 - CD - Construction Contract | 2023-02-06T00:00:00.000 | — | — | 2025-12-01T00:00:00.000 | 2025-12-01T00:00:00.000 | 95 - CDRB-Claim Denied | ADR2021LW002976 |
| 232114 | Navesink Prestige LLC v. Department of Design and Construction (12/01/2025) | Contract | Contract Dispute Resolution Board | P4 - CD - Construction Contract | 2023-02-06T00:00:00.000 | — | — | 2025-12-01T00:00:00.000 | 2025-12-01T00:00:00.000 | 95 - CDRB-Claim Denied | ADR2021LW000037 |
| 232115 | Navensink Prestige LLC v. Department of Design and Construction (12/01/2025) | Contract | Contract Dispute Resolution Board | P4 - CD - Construction Contract | 2023-02-06T00:00:00.000 | — | — | 2025-12-01T00:00:00.000 | 2025-12-01T00:00:00.000 | 95 - CDRB-Claim Denied | ADR2020LW032012 |
| 232126 | Navesink Prestige LLC v. Department of Design and Construction (12/01/2025) | Contract | Contract Dispute Resolution Board | P4 - CD - Construction Contract | 2023-02-06T00:00:00.000 | — | — | 2025-12-01T00:00:00.000 | 2025-12-01T00:00:00.000 | 95 - CDRB-Claim Denied | ADR2022LW013881 |
| 232123 | Navesink Prestige LLC v. Department of Design and Construction (12/01/2025) | Contract | Contract Dispute Resolution Board | P4 - CD - Construction Contract | 2023-02-06T00:00:00.000 | — | — | 2025-12-01T00:00:00.000 | 2025-12-01T00:00:00.000 | 95 - CDRB-Claim Denied | ADR2020LW031298 |
Showing 12 of 14 columns. All of them are listed below.
LicensePersonnelForfeitureof 7category | categorical | Identifies categories of a case type based on the description of the subject matter | 0% | Taxi & LimousineSection 75Forfeitureof 10 |
subcategory | text | Short description of the primary charge brought by the filing agency | 1% | 04 - Fitness Drug UseX10 - Forefeiture - Vehi…BI - BIC |
opened | datetime | The date the case was officially opened at OATH Trials Division | 0% | 2023-02-06T00:00:00.0002024-03-08T00:00:00.0002023-03-13T00:00:00.000 |
original_conference | datetime | Initial date the conference between parties in the case is scheduled | 81% | 2022-04-18T00:00:00.0002021-03-22T00:00:00.0002021-03-03T00:00:00.000 |
original_trial_date | datetime | Initial date the case is scheduled for trial | 25% | 2023-12-29T00:00:00.0002023-02-23T00:00:00.0002024-04-18T00:00:00.000 |
trial_concluded | datetime | The date on which trial was concluded | 100% | — |
record_closed | datetime | After the close of the trial, the date on which all evidence, arguments and conclusions are submitted as final | 0% | 2025-12-01T00:00:00.0002025-06-12T00:00:00.0002022-07-12T00:00:00.000 |
premises | address | The subject location | 95% | 239 Banker Street, Brook…135 Kent Avenue, Brookly…100 Metropolitan Avenue,… |
report_issued | datetime | The date on which decision after the trial was issued | 0% | 2025-12-01T00:00:00.0002022-11-02T00:00:00.0002024-01-24T00:00:00.000 |
dispo_code | text | Decision or outcome of the trial | 0% | 111 - License Revoked107 - Forfeiture -- Prop…128 - BIC -- Violation a… |
agency_head_decision | categorical | The final determination made by the head of the filing agency after his or her review of ALJ's decision (report and recommendation) | 33% | U - Recommendation uphel…N/AP - Upheld -- penalty mo…of 7 |
appeal_action_date | date | The date on which appeal was filed | 74% | N/A2025-05-212021-07-09 |