Computer Aided Dispatch Entries

The Computer Aided Dispatch (CAD) Entries data set reflects information approved for general release by the Cambridge Police Department and the Cambridge Fire Department. All entries are inputted by dispatchers in the Emergency Communications Center (ECC). This data set does not reflect all events received by the ECC. Certain entries are not included due to concerns related to privacy, criminal investigation, or protected data. Additionally, not all entries reflect a dispatched response and some data may reflect a duplicate entry for a specific incident. This dataset does not include any first responder calls related to emergency medical services (EMS), and does not contain all police or fire entries.

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/computer-aided-dispatch-entries-ppai-cur6\".\"computer_aided_dispatch_entries\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.