MTA Subway and Bus Lost Time Accidents: Beginning 2021

The number of reportable job-related incidents that result in the inability of an employee to perform full job duties for at least one working day beyond the day of the incident, as well as a breakdown of the number of Employees and Lost Time Accident Rates.

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-subway-and-bus-lost-time-accidents-beginning-8vjt-4zv4\".\"mta_subway_and_bus_lost_time_accidents_beginning\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.