From a 500-row sample across 15 columns.
zipcitycommunity_district+5industryzipcitystateHas borough codes (`borough_name`) — joinable, but needs boundary shapes to draw.
| opened_on | topic | industry | status | completed_on | outcome_activity | civil_penalties_assessed | total_number_of_employees | total_amount_of_restitution | city | state | zip |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 2016-09-27T00:00:00.000 | Paid Safe and Sick Leave | Educational Services | Completed | 2017-01-23T00:00:00.000 | Consent Order Signed | 3300 | 22 | 11000 | Brooklyn | NY | 11249 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
opened_on | datetime | Date enforcement matter was created | 0% | 2014-10-14T00:00:00.0002017-07-27T00:00:00.0002020-04-28T00:00:00.000 |
topic | categorical | Law or rule allegedly violated | 1% | Paid Safe and Sick LeaveFair WorkweekMultiple Topics (2)of 11 |
industry | text | General industry name of the business | 4% | Limited-Service Restaura…Retail TradeHome Health Care Service… |
status | text | Current status of the case | 0% |
GET /api/datasets/c292-vzrn GET /api/datasets/c292-vzrn/quality GET /api/datasets/c292-vzrn/related GET /api/columns?dataset=c292-vzrn
citystatecouncil_districtcitystatecouncil_district| 2015-08-07T00:00:00.000 |
| Paid Safe and Sick Leave |
| Book Stores |
| Completed |
| 2015-12-02T00:00:00.000 |
| Consent Order Signed |
| 1250 |
| — |
| — |
| New York |
| NY |
| 10022 |
| 2019-11-04T00:00:00.000 | Paid Safe and Sick Leave | Drycleaning and Laundry Services (except Coin-Operated) | Completed | 2021-03-25T00:00:00.000 | Consent Order Signed | — | 1 | 10398 | New York | NY | 10032 |
| 2021-01-28T00:00:00.000 | Multiple Topics (2) | Limited-Service Restaurants | Completed | 2023-10-05T00:00:00.000 | Consent Order Signed | — | — | — | — | — | — |
| 2019-03-06T00:00:00.000 | Multiple Topics (2) | Retail Trade | Completed | 2020-03-19T00:00:00.000 | Consent Order Signed | — | 1 | 1000 | Foxhurst | NY | 10459 |
| 2021-10-04T00:00:00.000 | Fair Scheduling - Retail | Pharmacies and Drug Stores | Completed | 2022-03-31T00:00:00.000 | Complainant Withdrew | — | — | — | — | — | — |
| 2021-06-03T00:00:00.000 | Paid Safe and Sick Leave | — | Completed | 2021-07-07T00:00:00.000 | Complainant Withdrew | — | — | — | — | — | — |
| 2022-08-30T00:00:00.000 | Paid Safe and Sick Leave | Health Care and Social Assistance | Completed | 2022-09-21T00:00:00.000 | Closeout Letter Sent – No Jurisdiction | — | — | — | — | — | — |
| 2015-04-27T00:00:00.000 | Paid Safe and Sick Leave | Manufacturing | Completed | 2015-06-26T00:00:00.000 | Consolidation Letter Sent | — | — | — | BROOKLYN | NY | 11211 |
| 2017-02-23T00:00:00.000 | Paid Safe and Sick Leave | Home Health Care Services | Completed | 2017-03-01T00:00:00.000 | Closeout Letter Sent – Declined to Prosecute | — | — | — | Flushing | NY | 11355 |
Showing 12 of 15 columns. All of them are listed below.
Completedof 1completed_on | datetime | Original date the enforcement matter was marked as having an outcome | 0% | 2015-07-06T00:00:00.0002015-06-26T00:00:00.0002014-11-05T00:00:00.000 |
outcome_activity | categorical | The action that closed out the OLPS investigation or enforcement activities | 0% | Consent Order SignedCloseout Letter Sent – D…Complainant Unresponsive…of 9 |
civil_penalties_assessed | integer | Total amount of fines, or Civil Penalties, assessed | 54% | 50010001500 |
total_number_of_employees | integer | Total number of employees entitled to restitution | 55% | 102 |
total_amount_of_restitution | integer | Total amount of restitution awarded, including amounts awarded to employees who were part of the original complaint | 55% | 0500250 |
city | text | Where available, the city where the respondent to the enforcement matter is located | 26% | New YorkBrooklynNEW YORK |
state | text | Where available, the state where the respondent to the enforcement matter is located | 25% | NYNJCA |
zip | text | Where available, the postal code where the respondent to the enforcement matter is located | 27% | 100181000111101 |
borough_name | categorical | Where available, the New York City borough where the respondent to the enforcement matter is located | 31% | ManhattanBrooklynQueensof 6 |
community_district | integer | Where available, the New York City community district where the respondent to the enforcement matter is located | 81% | 512 |
council_district | integer | Where available, the New York City Council district where the respondent to the enforcement matter is located | 81% | 431 |