Residential & Commercial Alarms

This dataset shows detailed information related to the operation of the City's Metro Alarm Office, including the number of permits issued and the number of false alarms recorded each month.

Please note: From July 2017-present, the columns "False Alarms" and False Alarms Historical" are identical. Prior to the ordnance passed in June 2017, the only false alarms that could be counted were those verified and matched by MPD's reporting database. This is reflected in the "False Alarms" column, pre July 2017. In order to get a true reflection of the volume of historical false alarms, dispatched records were matched and aggregated. This is reflected in the column "False Alarms Historical," pre July 2017.

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 \"memphistn-gov/residential-commercial-alarms-wwn8-sipn\".\"residential_commercial_alarms\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.