Urbana Police Traffic Stops - Offense Level (2012 - Feb 2023)

The information is the same data transmitted to the Illinois Department of Transportation (IDOT) with two additions: the "Motivation for Stop", and the offense codes recorded. Traffic stops appear from 2012, when the State revised the format to the current standard, until February 2023 when the system changed.

IMPORTANT!! (please click "More" to read this...) Adding the Offense Codes means that each line of information represents a single Offense.

For example: a traffic stop for speeding results in an arrest for an outstanding warrant and for possession of narcotics. That would appear on this listing THREE times (speeding, arrest warrant, and narcotics). The Incident Number will be the same (and the driver demographics), but the Crime Codes will be different on each line.

So counting rows of this dataset will return a higher count than the actual stops. This will cause some discrepancies with State data, which only count each stop once.

Please refer to the attachment for more details.

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 \"urbanaillinois-us/urbana-police-traffic-stops-offense-level-2012-feb-r5ht-r5ja\".\"urbana_police_traffic_stops_offense_level_2012_feb\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.