Transit Ridership and Public Health Measures Survey - Aug 2021 - Edmonton Insight Community

This survey focused on mask requirements on transit, anticipated transit use if public health measures are lifted and perceived COVID-19 safety at different stages of the customer journey. To view the survey questions, click the following link: https://www.edmontoninsightcommunity.ca/c/a/5cfE1EbDqUn41zZ6zXGvWf?t=1

Open from August 23-26, 2021.

A total of 6022 respondents completed the survey: 3354 Insight Community members, 1,397 via social media, 274 from the City's public service announcement, and 997 using the anonymous link at edmonton.ca/surveys, which contains no demographic information outside of the questions within the survey. The completion rate for Insight Community members was 24.48% (At the time the survey was launched, survey invitations were sent to 13,701 Insight Community Members and 3354 members completed the survey).

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/transit-ridership-and-public-health-measures-um86-qcr7\".\"transit_ridership_and_public_health_measures\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.