MDR Scorecard Open Requests
This dataset focuses on five high volume service requests: missed pickups, potholes, cart repair, weeds, and outside bin pickup. It shows the current number of open requests and the length of time they have been open.
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/mdr-scorecard-open-requests-ys6v-2mwb\".\"mdr_scorecard_open_requests\"
LIMIT 100
"}
EOF
See the Splitgraph documentation
for more information.