Icon for Socrata external plugin
Open repository in Console
Updated 20 days ago
Indexed 2 hours ago

Aggregated Service Requests

This dataset shows the number of service requests completed each month by type, and the average number of days it took to complete them. These service requests are aggregated from multiple sources, including 311 service requests, SeeClickFix, and requests created by city users. Where applicable, the service level agreement (SLA) is also shown, as well as the number of service requests completed within the SLA, within two times the SLA, and more than two times the SLA.

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 \
    -H "Content-Type: application/json" \
{"sql": "
    SELECT *
    FROM \"memphistn-gov/aggregated-service-requests-bh6e-ahmc\".\"aggregated_service_requests\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • aggregated_service_requests
Upstream Metadata