Icon for Socrata external plugin
Open repository in Console
Updated 2 months ago
Indexed 4 hours ago

DMV-Reportable Traffic Ticket Convictions: Four Year Window Data

Data extracted from records of convictions on file with NYS DMV. The convictions were from traffic tickets issued to motorists for violations of:— NYS Vehicle & Traffic Law (VTL),— Thruway Rules and Regulations— Tax Law— Transportation Law— Parks and Recreation Regulations— Local New York City Traffic Ordinances and— NYS Penal Law pertaining to the involvement of a motor vehicle in acts of assault, homicide, manslaughter and criminal negligence resulting in injury or death.

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" \
{"sql": "
    SELECT *
    FROM \"ny-gov/dmvreportable-traffic-ticket-convictions-four-year-yqfe-cnwu\".\"dmvreportable_traffic_ticket_convictions_four_year\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • dmvreportable_traffic_ticket_convictions_four_year
Upstream Metadata