Citizen Satisfaction Survey (2018-2021)

These are the results of the 2018 to 2021 Citizen Satisfaction survey. To see the most recent reports, visit <a href="https://calgary.ca/citizensatisfaction">Calgary.ca/citizensatisfaction</a>.

For detailed information on the variables in this dataset, <a href="https://data.calgary.ca/api/views/btc8-9kef/files/8edca0d5-637f-4333-aaf1-f00a61a1fc11?download=true&filename=Variable-metadata%202018-2021.xlsx">see the variable metadata</a>.

Methodology

The Citizen Satisfaction survey is a telephone survey conducted with a randomly selected sample of Calgarians aged 18 years and older. The survey is conducted on an annual basis.

The data are weighted to ensure the overall sample’s quadrant, ward, and age/gender composition reflects that of the actual Calgary population aged 18 or older according to Municipal and Federal Census data. Weights are included in the dataset.

<a href="https://data.calgary.ca/api/views/btc8-9kef/files/8edca0d5-637f-4333-aaf1-f00a61a1fc11?download=true&filename=Variable-metadata%202018-2021.xlsx">The variable metadata</a> contains detailed information on the variables.

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 \"calgary-ca/citizen-satisfaction-survey-20182021-btc8-9kef\".\"citizen_satisfaction_survey_20182021\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.