2017-2021 Council And Committee Meetings - Voting Record with Motion Details

This dataset seeks to merge the following into a user-friendly format:

• Voting record: https://data.edmonton.ca/d/9iqk-6gvh

• Motion details: https://data.edmonton.ca/d/vz4x-u2sk

• Meeting details: https://data.edmonton.ca/d/fepg-365m

To see historical City Ward information (which ward a given councillor was associated with, and between which dates), use the filters in https://data.edmonton.ca/Administrative/City-Wards-Current-Historical-and-Future-Map-View/wsky-72rb.

While every effort is taken to ensure its accuracy, the data presented here is for informational purposes only. The official record of the Council and Committee meetings shall be the Agendas, Minutes and supporting documents approved by and filed with the City Clerk.

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/20172021-council-and-committee-meetings-voting-huhs-auh6\".\"20172021_council_and_committee_meetings_voting\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.