Office of Labor Policy & Standards Enforcement Matters

The Department of Consumer and Worker Protection's Office of Labor Policy & Standards (OLPS) protects workers and enforces local labor laws that help ensure a fair workplace for all persons working in the City, and to ensure they can realize their rights.

This dataset provides a list of all worker complaints under the Fair Workwek and Paid Safe and Sick Leave laws that, after preliminary investigation, were taken up by OLPS attorneys as an enforcement matter.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"cityofnewyork-us/office-of-labor-policy-standards-enforcement-c292-vzrn\".\"office_of_labor_policy_standards_enforcement\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.