Senior management expenses

As part of The City of Calgary's commitment to an open, transparent and accountable local government we release the Senior Management Expense report twice per year in the spring and fall. It includes line item details, including business travel, meals and hosting, and employee recognition for the Senior Management Team. The Senior Management Team includes the City Manager, general managers and directors.

Budgets for the City Manager and each General Manager are reviewed and approved annually by City Council as part of budget deliberations.

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 \"calgary-ca/senior-management-expenses-y3tg-gbwj\".\"senior_management_expenses\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.