2021 Edmonton Election - Third Party Advertisers

An election Third Party Advertiser (TPA) is an individual, corporation or group who promotes or opposes a municipal or school board candidate through election advertising. TPAs can take part in election advertising from May 1 to October 17, 2021.

All TPAs who intend to incur expenses or contributions of at least $1,000 must register with their local municipality. If a TPA plans to advertise in more than 10 jurisdictions, then they are required to register with the Provincial Registrar at Municipal Affairs

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/2021-edmonton-election-third-party-advertisers-h26g-8g9s\".\"2021_edmonton_election_third_party_advertisers\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.