Proof of concept.This is an unofficial demo built by Datopian from the City of Port Moody's public data. The official portal is data.portmoody.ca. Questions or feedback: hello@datopian.com

Council Expenses by Councillor (combined)

Every per-councillor "Council Expenses" table on the City's Hub, joined into one table by this demo: 13 tables, 329 expense lines, 2018 to 2025. "Councillor" is the name in each table's title and "SourceDataset" names the table each row came from. The Hub also has an all-council "Council Expenses" table with more years; 329 of these 329 rows appear in it with the same official, date and amount.

Rows
329
Formats
2
Last updated
Jul 9, 2026

Data

Showing 0 of 0 rows

Download & API

Council Expenses by Councillor (combined) (CSV)csv
Spreadsheet — attributes, with coordinates for point layers
Download
Council Expenses by Councillor (combined) (Parquet)parquet
Columnar — query with DuckDB / SQL
Download

Schema

FieldTypeValues
Councillorstring
ElectedOfficialstring
Yearinteger2018 to 2025
Quarterinteger1 to 4
Datedatetime
ExpenseTypestring10 values: Conference (134), Cell Phone (89), Mileage (30)…
ExpenseDescriptionstring
Vendorstring
Amountnumber-2,301 to 2,371
SourceDatasetstring