The Cincinnati Community Perceptions Survey was developed by the City's Office of Performance and Data Analytics and ETC Institute in the fall of 2021. This community engagement tool was designed to allow the City Administration to evaluate resident satisfaction with our services and measure that level of satisfaction against cities of similar size, location, and demographics. The survey design also allows the City to capture community priorities for investment in services over the next two years.
The survey was administered during the winter of 2021 by mail to a random sample of households across the city, and was available to complete by mail or online. The goal of 1,200 completed surveys was exceeded, with a total of 1,408 residents completing the survey. The overall residents for the sample of 1,408 households have a precision of at least +/-2.6% at the 95% level of confidence, and are demographically representative of our city's population.
This year's survey will set a baseline for Cincinnati to work from with the goal of better understanding where we are excelling in service delivery and where our local government could benefit from intentional improvement and resources.
Find the link to the Survey landing page here:
https://etcinstitute.com/directionfinder2-0/city-of-cincinnati-ohio/
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/community-perceptions-survey-2021-pkyn-d5t4\".\"community_perceptions_survey_2021\" LIMIT 100 "} EOF
See the Splitgraph documentation for more information.