July 2020 Mixed Topic - Snow and Ice Control Opt-in - Edmonton Insight Community

This was the July 2020 Mixed Topic survey. Test link to view these questions:

https://www.edmontoninsightcommunity.ca/c/a/6adRlA0lB4q1SZeGaPn6ns?t=1rEFID2vM8?t=1

Open from July 14-21, 2020.

At the time the survey was launched survey invitations were sent to 12,131 Insight Community Members. 3811 members completed the survey which represents a completion rate of 31.42%. A total of 6005 respondents completed the survey: 3811 Insight Community Members, 790 from the call to action button on our webpage, and 1404 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-2020-mixed-topic-snow-and-ice-control-optin-vqmk-c3wc\".\"july_2020_mixed_topic_snow_and_ice_control_optin\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.