From a 500-row sample across 13 columns.
| date | case_number | case_name | agency | _3_way_settlement | fine_paid_to_coib | exp_of_amount_paid_to_coib |
|---|---|---|---|---|---|---|
| 2026-09-16T00:00:00.000 | 2024-745 | Garzaniti | DOE | X | 7500.00 | — |
| 2026-09-16T00:00:00.000 | 2024-745a | Williams | DOE | X | 4250.00 | — |
| 2026-09-16T00:00:00.000 | 2025-727 | Narcisse |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
date | datetime | Date the enforcement action was resolved. | 0% | 2008-07-15T00:00:00.0002018-03-23T00:00:00.0002015-12-22T00:00:00.000 |
case_number | text | lnternal agency assigned number. | 0% | 2006-559a2009-4342015-621 |
case_name | text | Last name of the respondent, who is a current or former public servant that was the subject of the enforcement action. | 0% | WilliamsRodriguezJones |
agency | text | City agency that employs or employed the respondent. | 0% | DOE |
GET /api/datasets/p39r-nm7f GET /api/datasets/p39r-nm7f/quality GET /api/datasets/p39r-nm7f/related GET /api/columns?dataset=p39r-nm7f
| COUNCIL |
| — |
| 2500.00 |
| — |
| 2026-08-20T00:00:00.000 | 2025-875 | Louison | DOHMH | — | 1200.00 | — |
| 2026-08-19T00:00:00.000 | 2025-627 | Parra | DSNY | — | 3500.00 | — |
| 2026-07-15T00:00:00.000 | 2026-066 | Corraliza | DOE | — | — | Respondent repaid parent for impermissible loan before Board brought enforcement action. |
| 2026-07-15T00:00:00.000 | 2026-054 | Van-Ess | DOE | — | 5000.00 | — |
| 2026-06-30T00:00:00.000 | 2025-611 | Monasterio-Porpora | DOE | — | 1500.00 | — |
| 2026-06-30T00:00:00.000 | 2025-906 | Ricupero | NYPD | — | 4000.00 | — |
| 2026-06-30T00:00:00.000 | 2025-560 | Abbady | COUNCIL | — | 7000.00 | — |
DSNYHRA_3_way_settlement | categorical | Indicates whether the enforcement action was resolved by a joint settlement agreement between the Board, the respondent, and the respondent's City agency. | 53% | xXof 2 |
fine_paid_to_coib | integer | Amount of fine payment made to the Board. | 35% | 1000.001500.00500.00 |
fine_imposed_by_coib_but_not_paid | text | Amount of fine imposed by the Board but not paid (either forgiven due to financial hardship or Board issued an order and respondent did not pay) | 96% | $7,500.00$10,000.00$2,000.00 |
exp_of_amount_paid_to_coib | text | Special circumstances concerning the fine such as financial hardship or disgorgement. | 88% | Due to showing of financ…Although respondent did …Respondent did not appea… |
fine_paid_to_agency | float | Amount paid to the respondent's City agency. | 93% | 1500.001000.002500.00 |
other_penalty_value | text | Description of penalty, other than a suspension, imposed by respondent's City agency as part of the settlement or any other penalty imposed by the Board. | 86% | One year probationRestitution5 days annual leave forf… |
other_penalty | float | Monetary value of penalty, other than a suspension, imposed by respondent's City agency as part of the settlement or any other penalty imposed by the Board. | 93% | 4494.201000.00158.00 |
suspension_of_days | integer | Number of days of suspension imposed by respondent's City agency as part of the settlement. | 76% | 53010 |
suspension_value | float | Monetary value, in lost income, of suspension imposed by respondent's City agency as part of the settlement. | 76% | 1172.091206.571189.33 |