July 2023 Mixed Topic - Additional Demographics - Edmonton Insight Community

This was one single topic among many, from the July 2023 Mixed Topic survey. To view the survey questions, click the following link:

https://www.edmontoninsightcommunity.ca/c/a/60LJc5x0CKSC4IWTjAtHOF?t=1

Open from July 11-18, 2023.

At the time the survey was launched survey invitations were sent to 17,076 Insight Community Members. 4,477 members completed the survey which represents a completion rate of 26.22%. A total of 4,548 respondents completed the survey: 4,477 Insight Community Members, 7 from the call to action button on our webpage, 24 from the City of Edmonton's social media channels (Facebook, Twitter, Instagram) and 40 using the anonymous link on Edmonton.ca/Surveys which will have no demographic info.

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 \"edmonton-ca/july-2023-mixed-topic-additional-demographics-a242-xmyu\".\"july_2023_mixed_topic_additional_demographics\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.