311 Call Wait Times

Caller wait time and call talk times for the 311 contact centre. Each row is the value for the average of the last 30 minutes of caller wait time and call talk time.

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 \"winnipeg-ca/311-call-wait-times-vrzk-mj7v\".\"311_call_wait_times\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.