Clarkston Fire Department Monthly Service Calls

This dataset shows the City of Clarkston Fire Department Call Data by calendar year. The Department collects information on calls for assistance. Calls are initiated through Whitcom, a regional dispatch center. Whitcom makes an initial classification of the event. Responders write reports which verify or modify classification as noted below. The final classification is verified by the Department’s Support Services Secretary. Refer to Fire Department Context in attachments for notes about events in specific years.

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 \"wa-gov/clarkston-fire-department-monthly-service-calls-jpfc-mfcm\".\"clarkston_fire_department_monthly_service_calls\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.