Number of Charges - Select MVA Offences

This dataset includes the charges defined by a summary offence ticket issued or an information laid as recorded on the Nova Scotia Justice Enterprise Information Network (JEIN). The number of charges are defined by the calendar year. The dataset includes the following offences under the Nova Scotia Motor Vehicle Act: MVA 100D Cellphone distracted driving; MVA 101 - Failing to drive or operate vehicle at a careful and prudent speed for existing conditions; MVA 103(3) Passing a school bus with red lights flashing; MVA 106A - Exceeding speed limit; MVA 106B - Exceeding speed limit in temporary work area or proximity to emergency vehicle; MVA 106E - Exceeding speed limit when driving by stopped emergency vehicle; and, MVA 163 - Racing, parade or sporting event (racing/stunting)

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 \"novascotia-ca/number-of-charges-select-mva-offences-neit-pbhj\".\"number_of_charges_select_mva_offences\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.