communications

Records of communications between lobbyists and public office holders

Data license: Open Government Licence – Toronto · Data source: Toronto Open Data · About: Built by Ram Vasuthevan with ❤️ on the shoulders of giants

poh_office
Ward, office, division or agency of the public office holder
poh_type
Public office holder type
poh_position
Public office holder's position title
poh_name
Name of public office holder
communication_method
List of communication methods used
communication_date
Date of communication in yyyy-mm-dd format
communication_group_id
Identifier of group receiving communication
lobbyist_number
Lobbyist registration number
lobbyist_type
Lobbyist type i.e. voluntary, in-house, consultant
lobbyist_prefix
Lobbyist's name prefix (e.g. Mr, Mrs, Ms)
lobbyist_first_name
Lobbyist's first name
lobbyist_middle_initials
Lobbyist's middle initial(s)
lobbyist_last_name
Lobbyist's last name
lobbyist_suffix
Lobbyist's name suffix (e.g. Esq, BA, PhD)
lobbyist_business
Name of lobbyist's business
lobbyist_position_title
Lobbyist's position title

127,369 rows

✎ View and edit SQL

This data as json, CSV (advanced)

lobbyist_type 2

lobbyist_previous_public_office_holder 2

id ▼ sm_number registrant_id poh_office poh_type poh_position poh_name communication_method communication_date communication_group_id lobbyist_number lobbyist_type lobbyist_prefix lobbyist_first_name lobbyist_middle_initials lobbyist_last_name lobbyist_suffix lobbyist_business lobbyist_position_title lobbyist_previous_public_office_holder lobbyist_previous_public_office_hold_position lobbyist_previous_public_office_position_program_name lobbyist_previous_public_office_hold_last_date
101 SM17345 12960S 13 Ward 41 Scarborough-Rouge River Member of Council Councillor Chin Lee E-mail 2016-10-17 60548 17490H In-House Lobbyist   Alain   Brandon     VP, CSR and GR No . .  
102 SM17345 12960S 13 Ward 3 Etobicoke Centre Member of Council Councillor Stephen Holyday Telephone;E-mail 2016-10-17 60547 17490H In-House Lobbyist   Alain   Brandon     VP, CSR and GR No . .  
103 SM17345 12960S 13 Ward 32 Beaches-East York Member of Council Councillor Mary-Margaret McMahon Telephone;E-mail 2016-10-17 60546 17490H In-House Lobbyist   Alain   Brandon     VP, CSR and GR No . .  
104 SM17345 12960S 13 Ward 35 Scarborough Southwest Member of Council Councillor Michelle Berardinetti Meeting 2012-04-30 29230 17490H In-House Lobbyist   Alain   Brandon     VP, CSR and GR No . .  
105 SM17345 12960S 13 Ward 25 Don Valley West Member of Council Councillor Jaye Robinson Telephone;E-mail 2016-10-17 27957 17490H In-House Lobbyist   Alain   Brandon     VP, CSR and GR No . .  
106 SM17345 12960S 13 Ward 25 Don Valley West Member of Council Councillor Jaye Robinson Meeting 2016-09-28 27957 17490H In-House Lobbyist   Alain   Brandon     VP, CSR and GR No . .  
107 SM17345 12960S 13 Ward 25 Don Valley West Member of Council Councillor Jaye Robinson E-mail 2016-09-23 27957 17490H In-House Lobbyist   Alain   Brandon     VP, CSR and GR No . .  
108 SM17345 12960S 13 Ward 25 Don Valley West Member of Council Councillor Jaye Robinson Meeting 2016-09-16 27957 17490H In-House Lobbyist   Alain   Brandon     VP, CSR and GR No . .  
109 SM17345 12960S 13 Ward 25 Don Valley West Member of Council Councillor Jaye Robinson Meeting 2015-09-14 27957 17490H In-House Lobbyist   Alain   Brandon     VP, CSR and GR No . .  
110 SM17345 12960S 13 Ward 25 Don Valley West Member of Council Councillor Jaye Robinson E-mail 2015-06-17 27957 17490H In-House Lobbyist   Alain   Brandon     VP, CSR and GR No . .  
111 SM17345 12960S 13 Ward 25 Don Valley West Member of Council Councillor Jaye Robinson Meeting 2012-01-23 27957 17490H In-House Lobbyist   Alain   Brandon     VP, CSR and GR No . .  
112 SM17345 12960S 13 Ward 33 Don Valley East Member of Council Councillor Shelley Carroll Meeting 2012-08-23 30901 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
113 SM17345 12960S 13 Ward 34 Don Valley East Member of Council Councillor Denzil Minnan-Wong Meeting 2012-08-23 30900 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
114 SM17345 12960S 13 Ward 25 Don Valley West Member of Council Councillor Jaye Robinson Meeting 2015-09-14 27955 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
115 SM17345 12960S 13 Ward 25 Don Valley West Member of Council Councillor Jaye Robinson Meeting 2012-01-23 27955 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
116 SM17345 12960S 13 Mayor Member of Council Mayor Rob Ford Meeting 2011-10-11 27072 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
117 SM17345 12960S 13               13733H In-House Lobbyist Mr Galen   Weston     Executive Chairman No . .  
118 SM17345 12960S 13               12960S-1 Sr. Officer   Daniel   Tremblay     Sr VP, Corporate Social Responsibility No      
119 SM13190 12960S 14 Ward 34 Don Valley East Member of Council Councillor Denzil Minnan-Wong Telephone 2012-11-23 32644 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
120 SM13190 12960S 14 Office of Councillor Anthony Perruzza, Ward 8 Staff of Member of Council   Tom Rakocevic E-mail 2012-11-26 32814 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
121 SM13190 12960S 14 Office of Councillor Gary Crawford, Ward 33 Staff of Member of Council   Tina Ferreira E-mail 2012-11-26 32785 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
122 SM13190 12960S 14 Office of Councillor Norm Kelly, Ward 40 Staff of Member of Council   Tas Borovilos E-mail 2012-11-26 32797 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
123 SM13190 12960S 14 Office of Councillor Paula Fletcher, Ward 30 Staff of Member of Council   Susan Serran E-mail 2012-11-26 32793 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
124 SM13190 12960S 14 Office of Councillor Peter Milczyn, Ward 5 Staff of Member of Council   Susan O'Connor E-mail 2012-11-26 32806 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
125 SM13190 12960S 14 Office of Councillor Mark Grimes, Ward 6 Staff of Member of Council   Sheila Paxton E-mail 2012-11-26 32795 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
126 SM13190 12960S 14 Office of Councillor Doug Holyday, Ward 3 Staff of Member of Council   Sheila Henderson E-mail 2012-11-26 32796 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
127 SM13190 12960S 14 Office of Councillor Maria Augimeri, Ward 9 Staff of Member of Council   Robert Andreacchi E-mail 2012-11-26 32780 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
128 SM13190 12960S 14 Office of Councillor Cesar Palacio, Ward 17 Staff of Member of Council   Mike Makrigiorgos E-mail 2012-11-26 32810 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
129 SM13190 12960S 14 Office of Councillor Karen Stintz, Ward 16 Staff of Member of Council   Michele Sardy E-mail 2012-11-26 32817 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
130 SM13190 12960S 14 Office of Councillor Mike Layton, Ward 19 Staff of Member of Council   Michal Hay E-mail 2012-11-26 32798 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
131 SM13190 12960S 14 Office of Councillor M. Berardinetti, Ward 35 Staff of Member of Council   Michael Giles E-mail 2012-11-26 32782 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
132 SM13190 12960S 14 Office of Councillor Giorgio Mammoliti, Ward 7 Staff of Member of Council   Melissa Palladino E-mail 2012-11-26 32801 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
133 SM13190 12960S 14 Office of Councillor John Filion, Ward 23 Staff of Member of Council   Markus O'Brien Fehr E-mail 2012-11-26 32790 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
134 SM13190 12960S 14 Office of Councillor Denzil Minnan Wong, Ward 34 Staff of Member of Council   Mark Wilson E-mail 2012-11-26 32807 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
135 SM13190 12960S 14 Office of Councillor Joe Mihevic, Ward 21 Staff of Member of Council   Lydia Hanson E-mail 2012-11-26 32805 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
136 SM13190 12960S 14 Office of Councillor David Shiner, Ward 24 Staff of Member of Council   Karen Wood E-mail 2012-11-26 32816 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
137 SM13190 12960S 14 Office of Councillor Gord Perks, Ward 14 Staff of Member of Council   Karen Duffy E-mail 2012-11-26 32813 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
138 SM13190 12960S 14 Office of Councillor Vincent Crisanti, Ward 1 Staff of Member of Council   Justin Hane E-mail 2012-11-26 32786 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
139 SM13190 12960S 14 Office of Councillor Frank DiGiorgio, Ward 12 Staff of Member of Council   John Mele E-mail 2012-11-26 32789 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
140 SM13190 12960S 14 Office of Councillor Gloria Lindsay Luby, Ward 4 Staff of Member of Council   Jim Burnett E-mail 2012-11-26 32800 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
141 SM13190 12960S 14 Office of Councillor Shelley Carroll, Ward 33 Staff of Member of Council   Jennifer Daws E-mail 2012-11-26 32783 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
142 SM13190 12960S 14 Office of Councillor Mike Del Grande, Ward 39 Staff of Member of Council   Jennifer Coutinho E-mail 2012-11-26 32788 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
143 SM13190 12960S 14 Office of Councillor Janet Davis, Ward 31 Staff of Member of Council   Jay Thiessen E-mail 2012-11-26 32787 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
144 SM13190 12960S 14 Office of Councillor Jaye Robinson, Ward 25 Staff of Member of Council   Jacqueline Czajka E-mail 2012-11-26 32815 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
145 SM13190 12960S 14 Office of Councillor James Pasternak, Ward 10 Staff of Member of Council   Jacob Katz E-mail 2012-11-26 32812 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
146 SM13190 12960S 14 Office of Councillor John Parker, Ward 26 Staff of Member of Council   Ishrath Velshi E-mail 2012-11-26 32811 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
147 SM13190 12960S 14 Office of Councillor Michael Thompson, Ward 37 Staff of Member of Council   Ihor Wons E-mail 2012-11-26 32818 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
148 SM13190 12960S 14 Office of Councillor Pam McConnell, Ward 28 Staff of Member of Council   Glenn Gustafson E-mail 2012-11-26 32803 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
149 SM13190 12960S 14 Office of Councillor Chin Lee, Ward 41 Staff of Member of Council   Geoffrey Chambers E-mail 2012-11-26 32799 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
150 SM13190 12960S 14 Office of Councillor Mary M. McMahon, Ward 32 Staff of Member of Council   Edward Birnbaum Telephone 2012-11-27 32845 17490H In-House Lobbyist   Alain   Brandon     VP, CSR and GR No . .  
151 SM13190 12960S 14 Office of Councillor Mary M. McMahon, Ward 32 Staff of Member of Council   Edward Birnbaum E-mail 2012-11-26 32804 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
152 SM13190 12960S 14 Office of Councillor Mary Fragedakis, Ward 29 Staff of Member of Council   Daryl Finlayson E-mail 2012-11-26 32794 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
153 SM13190 12960S 14 Office of Councillor Ron Moeser, Ward 44 Staff of Member of Council   Calum MacMillan E-mail 2012-11-26 32808 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
154 SM13190 12960S 14 Office of Councillor Ana Bailao, Ward 18 Staff of Member of Council   Braden Root-McCaig E-mail 2012-11-26 32781 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
155 SM13190 12960S 14 Office of Councillor Frances Nunziata, Ward 11 Staff of Member of Council   Bianca Lankheit Telephone 2012-11-27 32844 17490H In-House Lobbyist   Alain   Brandon     VP, CSR and GR No . .  
156 SM13190 12960S 14 Office of Councillor Frances Nunziata, Ward 11 Staff of Member of Council   Bianca Lankheit E-mail 2012-11-26 32809 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
157 SM13190 12960S 14 Office of Councillor Doug Ford, Ward 2 Staff of Member of Council   Armin Massoudi E-mail 2012-11-26 32792 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
158 SM13190 12960S 14 Office of Councillor Paul Ainslie, Ward 43 Staff of Member of Council   Antonette DiNovo E-mail 2012-11-26 32779 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
159 SM13190 12960S 14 Office of Councillor Josh Colle, Ward 15 Staff of Member of Council   Angelina Conte E-mail 2012-11-26 32784 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
160 SM13190 12960S 14 Office of Councillor Adam Vaughan, Ward 20 Staff of Member of Council   Ange Valentini E-mail 2012-11-26 32819 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
161 SM13190 12960S 14 Office of Councillor Josh Matlow, Ward 22 Staff of Member of Council   Andrew Athanasiu E-mail 2012-11-26 32802 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
162 SM13190 12960S 14 Office of Councillor Kristyn Wong Tam, Ward 27 Staff of Member of Council   Alina Chatterjee E-mail 2012-11-26 32820 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
163 SM13190 12960S 14 Ward 16 Eglinton-Lawrence Member of Council Councillor Karen Stintz Other:voicemail message 2012-11-27 32852 17490H In-House Lobbyist   Alain   Brandon     VP, CSR and GR No . .  
164 SM13190 12960S 14 Ward 25 Don Valley West Member of Council Councillor Jaye Robinson Other:voicemail message 2012-11-27 32851 17490H In-House Lobbyist   Alain   Brandon     VP, CSR and GR No . .  
165 SM13190 12960S 14 Ward 26 Don Valley West Member of Council Councillor John Parker Other:voicemail message 2012-11-27 32850 17490H In-House Lobbyist   Alain   Brandon     VP, CSR and GR No . .  
166 SM13190 12960S 14 Ward 5 Etobicoke-Lakeshore Member of Council Councillor Peter Milczyn Other:voicemail message 2012-11-27 32849 17490H In-House Lobbyist   Alain   Brandon     VP, CSR and GR No . .  
167 SM13190 12960S 14 Ward 21 St. Paul's Member of Council Councillor Joe Mihevc Other:voicemail message 2012-11-27 32848 17490H In-House Lobbyist   Alain   Brandon     VP, CSR and GR No . .  
168 SM13190 12960S 14 Ward 28 Toronto Centre-Rosedale Member of Council Councillor Pam McConnell Other:voicemail message 2012-11-27 32847 17490H In-House Lobbyist   Alain   Brandon     VP, CSR and GR No . .  
169 SM13190 12960S 14 Ward 22 St. Paul's Member of Council Councillor Josh Matlow Other:voicemail message 2012-11-27 32846 17490H In-House Lobbyist   Alain   Brandon     VP, CSR and GR No . .  
170 SM13190 12960S 14 Mayor Member of Council Mayor Rob Ford Meeting 2011-10-11 26967 12960S-2 Sr. Officer   Inge   van den Berg     Senior Vice President, Corporate Affairs No      
171 SM13190 12960S 14 Ward 44 Scarborough East Member of Council Councillor Ron Moeser E-mail 2012-11-26 32778 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
172 SM13190 12960S 14 Ward 43 Scarborough East Member of Council Councillor Paul Ainslie E-mail 2012-11-26 32777 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
173 SM13190 12960S 14 Ward 42 Scarborough-Rouge River Member of Council Councillor Raymond Cho E-mail 2012-11-26 32776 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
174 SM13190 12960S 14 Ward 41 Scarborough-Rouge River Member of Council Councillor Chin Lee E-mail 2012-11-26 32775 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
175 SM13190 12960S 14 Ward 40 Scarborough-Agincourt Member of Council Councillor Norman Kelly E-mail 2012-11-26 32774 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
176 SM13190 12960S 14 Ward 39 Scarborough-Agincourt Member of Council Councillor Mike Del Grande E-mail 2012-11-26 32773 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
177 SM13190 12960S 14 Ward 38 Scarborough Centre Member of Council Councillor Glenn De Baeremaeker E-mail 2012-11-26 32772 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
178 SM13190 12960S 14 Ward 37 Scarborough Centre Member of Council Councillor Michael Thompson E-mail 2012-11-26 32771 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
179 SM13190 12960S 14 Ward 36 Scarborough Southwest Member of Council Councillor Gary Crawford E-mail 2012-11-26 32770 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
180 SM13190 12960S 14 Ward 35 Scarborough Southwest Member of Council Councillor Michelle Berardinetti E-mail 2012-11-26 32769 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
181 SM13190 12960S 14 Ward 33 Don Valley East Member of Council Councillor Shelley Carroll E-mail 2012-11-26 32768 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
182 SM13190 12960S 14 Ward 32 Beaches-East York Member of Council Councillor Mary-Margaret McMahon E-mail 2012-11-26 32767 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
183 SM13190 12960S 14 Ward 31 Beaches-East York Member of Council Councillor Janet Davis E-mail 2012-11-26 32766 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
184 SM13190 12960S 14 Ward 30 Toronto-Danforth Member of Council Councillor Paula Fletcher E-mail 2012-11-26 32765 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
185 SM13190 12960S 14 Ward 29 Toronto-Danforth Member of Council Councillor Mary Fragedakis Telephone 2012-11-27 32764 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
186 SM13190 12960S 14 Ward 29 Toronto-Danforth Member of Council Councillor Mary Fragedakis E-mail 2012-11-26 32764 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
187 SM13190 12960S 14 Ward 28 Toronto Centre-Rosedale Member of Council Councillor Pam McConnell E-mail 2012-11-26 32763 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
188 SM13190 12960S 14 Ward 27 Toronto Centre-Rosedale Member of Council Councillor Kristyn Wong-Tam E-mail 2012-11-26 32762 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
189 SM13190 12960S 14 Ward 26 Don Valley West Member of Council Councillor John Parker E-mail 2012-11-26 32761 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
190 SM13190 12960S 14 Ward 25 Don Valley West Member of Council Councillor Jaye Robinson E-mail 2012-11-26 32760 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
191 SM13190 12960S 14 Ward 24 Willowdale Member of Council Councillor David Shiner E-mail 2012-11-26 32759 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
192 SM13190 12960S 14 Ward 23 Willowdale Member of Council Councillor John Filion E-mail 2012-11-26 32758 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
193 SM13190 12960S 14 Ward 22 St. Paul's Member of Council Councillor Josh Matlow E-mail 2012-11-26 32757 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
194 SM13190 12960S 14 Ward 21 St. Paul's Member of Council Councillor Joe Mihevc E-mail 2012-11-26 32756 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
195 SM13190 12960S 14 Ward 20 Trinity-Spadina Member of Council Councillor Adam Vaughan E-mail 2012-11-26 32755 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
196 SM13190 12960S 14 Ward 19 Trinity-Spadina Member of Council Councillor Mike Layton E-mail 2012-11-26 32754 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
197 SM13190 12960S 14 Ward 18 Davenport Member of Council Councillor Ana Bailão E-mail 2012-11-26 32753 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
198 SM13190 12960S 14 Ward 17 Davenport Member of Council Councillor Cesar Palacio E-mail 2012-11-26 32752 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
199 SM13190 12960S 14 Ward 16 Eglinton-Lawrence Member of Council Councillor Karen Stintz E-mail 2012-11-26 32751 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      
200 SM13190 12960S 14 Ward 15 Eglinton-Lawrence Member of Council Councillor Josh Colle E-mail 2012-11-26 32750 12960S-3 Sr. Officer   Bob   Chant     SVP, Corporate Affairs and Communication No      

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE communications (
	id INTEGER NOT NULL, 
	sm_number VARCHAR(10), 
	registrant_id INTEGER, 
	poh_office VARCHAR(100), 
	poh_type VARCHAR(50), 
	poh_position VARCHAR(100), 
	poh_name VARCHAR(100), 
	communication_method VARCHAR(50), 
	communication_date VARCHAR, 
	communication_group_id VARCHAR(50), 
	lobbyist_number VARCHAR(20), 
	lobbyist_type VARCHAR(50), 
	lobbyist_prefix VARCHAR(10), 
	lobbyist_first_name VARCHAR(100), 
	lobbyist_middle_initials VARCHAR(10), 
	lobbyist_last_name VARCHAR(100), 
	lobbyist_suffix VARCHAR(10), 
	lobbyist_business VARCHAR(100), 
	lobbyist_position_title VARCHAR(100), 
	lobbyist_previous_public_office_holder VARCHAR(3), 
	lobbyist_previous_public_office_hold_position VARCHAR(100), 
	lobbyist_previous_public_office_position_program_name VARCHAR(100), 
	lobbyist_previous_public_office_hold_last_date VARCHAR, 
	PRIMARY KEY (id), 
	FOREIGN KEY(sm_number) REFERENCES subject_matters (sm_number), 
	FOREIGN KEY(registrant_id) REFERENCES registrants (id)
);