311 Call Center Reported Issues

This is the new 311 call center data from MyKCMO, which replaced PeopleSoft CRM on March 4th, 2021. Detailed work order data and resolution of requests may not be found in this system as this represents 311 requests only; for more information see those specific departments.

For older data from PS CRM, please see https://data.kcmo.org/311/311-Call-Center-Service-Requests-2007-March-2021/7at3-sxhp

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 \"kcmo/311-call-center-reported-issues-d4px-6rwg\".\"311_call_center_reported_issues\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.