Police Citations

This data set features all MA uniform citations issued by the Cambridge Police Department since January 2010. The data includes the date and time issued, location as well as MA General Law charge information. Citation numbers have been omitted from this dataset. The addresses provided are the raw street number and name along with a cross street, if it occured at an intersection of two streets.Please see the MASS RMV for more information on Uniform Citations and the General Court of the Commonwealth for Mass General Laws: http://www.massrmv.com/MeritRatingBoard/SurchargeableIncidents/MassachusettsUniformCitation.aspx https://malegislature.gov/Laws/GeneralLaws/Search

Note: this data includes all violations associated with an issued citation, which may result in multiple line items for a singular event.

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 \"cambridgema-gov/police-citations-gmq6-8ver\".\"police_citations\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.