MTA Workplace Violence Labor Law Incidents: Beginning 2019

This dataset reflects the monthly number of employee-reported incidents of workplace violence, as defined by New York State Labor Law Section 27-B, against on-duty MTA employees. This dataset divides workplace violence incidents into groupings as reported pursuant to New York State Labor Law Section 27-B. The same data is available in the MTA Workplace Violence Penal Law Incidents dataset, which divides the data according to New York State Penal Law Related Offenses.

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 \"ny-gov/mta-workplace-violence-labor-law-incidents-7i3h-vdya\".\"mta_workplace_violence_labor_law_incidents\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.