Mayor's Lobbyist Registry

For the 2017-2021 term, the Mayor’s Office has voluntarily implemented a lobbyist registry.

The purpose of the registry is to contribute to increasing Edmontonians’ confidence in the integrity of the local government decision-making process, and to promote government transparency and accountability.

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/mayors-lobbyist-registry-3dkh-9hnu\".\"mayors_lobbyist_registry\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.