Additional Information

Field Value
Last updated February 25, 2026
Created March 15, 2023
Format CSV
File size 346.6 KiB
License Open Government License 2.0 (Niagara Region)
Data range start November 30, 2022
Data range end December 30, 2025
Data birth date March 14, 2023
Version 1.12

Data Dictionary

Column Type Label Description
Councilor Name text Councillor Name

Name of elected official Format: Title, First Name, Last Name All names are prefix with position on Niagara Region Council
Journal Id text Journal ID

Niagara Region record identifier Field Size: 10
Journal Date timestamp Journal Date

Date of processing in Niagara Region financial management system Format: YYYY-MM-DD format; Field size:10
Account numeric Account

Niagara Region account identify Field Size: 5
Account Description text Account Description

Description of financial account expenses was coded to
Expenses - Long description text Expenses - Long description

Description of expenses submitted
Expenses - Type text Expenses - Type

Classification of expense Field Size: 7; Expense Type Description MILEAGE Mileage expenses PHONE Phone expenses GRNDADM Ground travel expenses MEALADM Meal expenses SUPPLY Office Supply expenses MEETING Meeting related expenses HOTELON Hotel expenses PRKNGA Parking expenses AIRADMN Airline and flight expenses PRDMOA Per Diem expenses COURIER Courier expenses INCIDTL Incidentals BOOKS Books, publications or subscriptions OP MAT Other program supplies
Expenses - Distance numeric Expenses - Distance

Number of kilometers paid in mileage, unit km.
Project ID numeric Project ID

Project code assigned to elected official
Amount with non-recoverable HST numeric
Visa Expense Merchant text Visa Expense Merchant

provider paid by corporate credit card for service or good
Supplier text Supplier

Provider paid for service or goods
Voucher Description text Voucher Description

Detailed description of expense
Conference Related? text Conference Related

Indicator of costs related to attendance at a conference
Activity text Activity

Indicator of activity expense relates to

Activity Activity Name CONC_REG Councillor Regular Duties CONC_OTHER_1 Councillor (Other) CONC_CONF_FCM Conference Federation of Canadian Municipalities CONC_CONF_AMO Conference Association of Municipalities of Ontario CONC_CONF_FAFA Conference Food and Farming Alliance CONC_CONF_NW Conference Niagara Week CONC_CONF_OGRA Conference Ontario Good Roads Association CONC_CONF_OSUM Conference Ontario Small Urban Municipalities CONC_CONF_1 Conference Other 1 CONC_CONF_2 Conference Other 2 CONC_CONF_3 Councillor (AMO Board) CONC_CONF_4 Conference Other 4 CONC_CONF_5 Conference Other 5 CONC_CONF_6 Conference Other 6 CONC_CONF_7 Conference Other 7 CONC_CONF_8 Conference Other 8 CONC_CONF_9 Conference Other 9 CONC_CONF_10 Conference Other 10 CONC_CONF_11 Conference Other 11 CONC_CONF_12 Conference Other 12 CONC_CONF_13 Conference Other 13 CONC_CONF_14 Conference Other 14 CONC_CONF_15 Conference Other 15 OPEXP_ANNUAL Operating Expense Annual OPEXP_1TIME Operating Expense 1 Time