Citizen Service Request (CSR) Call Center Calls

Data Description: This dataset contains the record of all Citizen Service Request (CSR) calls received at the call center at the Department of Public Services (DPS). For full CSR data visit: https://data.cincinnati-oh.gov/Innovative-Government/Customer-Service-Requests-CSRs-/gcej-gmiw

Citizen Service Requests (CSR) gives Cincinnati residents the opportunity to submit service request for concerns like furniture pick-up, tall grass and pothole repairs. Using the Fix It Cincy! Mobile App, the customer service request online portal and the hotline (513-591-6000), citizen service requests are routed directly to City departments to be completed

Data Creation: Data is generated by incoming calls received at the DPS call center

Data Created By: DPS

Refresh Frequency: Daily

Data Dictionary: A data dictionary providing definitions of columns and attributes is available as an attachment to this dataset.

Processing: The City of Cincinnati is committed to providing the most granular and accurate data possible. In that pursuit the Office of Performance and Data Analytics facilitates standard processing to most raw data prior to publication. Processing includes but is not limited: address verification, geocoding, decoding attributes, and addition of administrative areas (i.e. Census, neighborhoods, police districts, etc.).

Data Usage: For directions on downloading and using open data please visit our How-to Guide: https://data.cincinnati-oh.gov/dataset/Open-Data-How-To-Guide/gdr9-g3ad

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 \"cincinnati-oh-gov/citizen-service-request-csr-call-center-calls-k2qr-ck2v\".\"citizen_service_request_csr_call_center_calls\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.