Crime Reports

List of crime incidents featured in the Cambridge Police Department’s Annual Crime Reports and reported in the City of Cambridge since 2009. Includes more than 40 crime types. Certain crime types are excluded due to confidentiality and/or protection of privacy. Please Note: Addresses do not represent the actual location of the crime, but a near approximation within 100 block ranges. For reports published by the Cambridge Police Department’s Crime Analysis Unit, visit http://www.cambridgema.gov/cpd/Publications.aspx.

Best Data at the Time: All statistics, including yearly totals and weighted averages, are calculated using the best available data at the time. Occasionally, after our reports are published, factors determined during investigation will cause us to reclassify a crime to a higher or lower category, and thus you may see slight discrepancies between current and past reports. In all cases, the more recent data is the more correct data.

This dataset will be periodically revised to ensure compliance with all local, state and federal privacy rights and legal requirements.

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/crime-reports-xuad-73uj\".\"crime_reports\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.