Senior Management Expense Disclosure

The City Manager and Deputy City Managers quarterly release the expenses they incur while conducting City business. For details on allowable expenses, see the Employee Business Expense Administrative Directive A14151 (https://www.edmonton.ca/city_government/documents/PoliciesDirectives/A1415I_Employee_Business_Expense_Dir.pdf)

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/senior-management-expense-disclosure-ihuy-w3s8\".\"senior_management_expense_disclosure\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.