communications
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
53,109 rows where lobbyist_type = "In-House Lobbyist"
This data as json, CSV (advanced)
Suggested facets: lobbyist_prefix, lobbyist_previous_public_office_hold_last_date, communication_date (date), lobbyist_previous_public_office_hold_last_date (date)
poh_type 7
- Employee of the City 18,850
- Member of Council 16,115
- Staff of Member of Council 10,541
- Employee of Local Board 2,601
- Member of Local Board 133
- Staff of Member of Local Board 38
- Member of Advisory Body 16
lobbyist_type 1
- In-House Lobbyist · 53,109 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2 | SM30420 | 45196S 2 | Ward 24 Scarborough-Guildwood | Member of Council | Councillor | Paul Ainslie | 2020-08-21 | 93675 | 45198H | In-House Lobbyist | Karen | Gomez | Growth and Community Manager | No | ||||||||
3 | SM30420 | 45196S 2 | Transportation Services Division | Employee of the City | Project Lead | 2020-09-18 | 93881 | 45198H | In-House Lobbyist | Karen | Gomez | Growth and Community Manager | No | |||||||||
4 | SM30420 | 45196S 2 | Transportation Services Division | Employee of the City | Project Lead | 2020-09-09 | 93881 | 45198H | In-House Lobbyist | Karen | Gomez | Growth and Community Manager | No | |||||||||
5 | SM30420 | 45196S 2 | Transportation Services Division | Employee of the City | Manager, Transportation Data and Analytics | Meeting | 2020-10-13 | 94598 | 45264H | In-House Lobbyist | David | Keaney | COO | No | ||||||||
6 | SM30420 | 45196S 2 | Transportation Services Division | Employee of the City | Manager, Transportation Data and Analytics | Meeting | 2020-10-13 | 93880 | 45198H | In-House Lobbyist | Karen | Gomez | Growth and Community Manager | No | ||||||||
8 | SM30420 | 45196S 2 | Transportation Services Division | Employee of the City | Manager, Transportation Data and Analytics | 2020-10-09 | 93880 | 45198H | In-House Lobbyist | Karen | Gomez | Growth and Community Manager | No | |||||||||
9 | SM30420 | 45196S 2 | Transportation Services Division | Employee of the City | Manager, Transportation Data and Analytics | 2020-09-18 | 93880 | 45198H | In-House Lobbyist | Karen | Gomez | Growth and Community Manager | No | |||||||||
10 | SM30420 | 45196S 2 | Transportation Services Division | Employee of the City | Manager, Transportation Data and Analytics | 2020-09-09 | 93880 | 45198H | In-House Lobbyist | Karen | Gomez | Growth and Community Manager | No | |||||||||
11 | SM30420 | 45196S 2 | Transportation Services Division | Employee of the City | Manager, Traffic Systems | Meeting | 2020-10-13 | 94600 | 45264H | In-House Lobbyist | David | Keaney | COO | No | ||||||||
12 | SM30420 | 45196S 2 | Transportation Services Division | Employee of the City | Manager, Traffic Systems | Meeting | 2020-10-13 | 94499 | 45198H | In-House Lobbyist | Karen | Gomez | Growth and Community Manager | No | ||||||||
14 | SM30420 | 45196S 2 | Transportation Services Division | Employee of the City | Manager, Traffic Systems | 2020-10-09 | 94499 | 45198H | In-House Lobbyist | Karen | Gomez | Growth and Community Manager | No | |||||||||
15 | SM30420 | 45196S 2 | Transportation Services Division | Employee of the City | Manager, Operations and Maintenance | Meeting | 2020-10-13 | 94602 | 45264H | In-House Lobbyist | David | Keaney | COO | No | ||||||||
16 | SM30420 | 45196S 2 | Transportation Services Division | Employee of the City | Manager, Operations and Maintenance | Meeting | 2020-10-13 | 94596 | 45198H | In-House Lobbyist | Karen | Gomez | Growth and Community Manager | No | ||||||||
18 | SM30420 | 45196S 2 | Transportation Services Division | Employee of the City | Manager, Operations & Maintenance | Meeting | 2020-10-13 | 94604 | 45264H | In-House Lobbyist | David | Keaney | COO | No | ||||||||
19 | SM30420 | 45196S 2 | Transportation Services Division | Employee of the City | Manager, Operations & Maintenance | Meeting | 2020-10-13 | 94497 | 45198H | In-House Lobbyist | Karen | Gomez | Growth and Community Manager | No | ||||||||
21 | SM30420 | 45196S 2 | Transportation Services Division | Employee of the City | Manager, Operations & Maintenance | 2020-10-09 | 94497 | 45198H | In-House Lobbyist | Karen | Gomez | Growth and Community Manager | No | |||||||||
22 | SM30420 | 45196S 2 | Transportation Services Division | Employee of the City | Manager, Operational Planning and Policy | Meeting | 2020-10-13 | 94610 | 45264H | In-House Lobbyist | David | Keaney | COO | No | ||||||||
23 | SM30420 | 45196S 2 | Transportation Services Division | Employee of the City | Manager, Operational Planning and Policy | Meeting | 2020-10-13 | 94609 | 45198H | In-House Lobbyist | Karen | Gomez | Growth and Community Manager | No | ||||||||
25 | SM30420 | 45196S 2 | Technology Services | Employee of the City | Manager, Connected Communities | Meeting | 2020-08-17 | 93623 | 45264H | In-House Lobbyist | David | Keaney | COO | No | ||||||||
26 | SM30420 | 45196S 2 | Technology Services | Employee of the City | Manager, Connected Communities | Meeting;E-mail | 2020-08-17 | 93513 | 45198H | In-House Lobbyist | Karen | Gomez | Growth and Community Manager | No | ||||||||
28 | SM30420 | 45196S 2 | Technology Services | Employee of the City | Manager, Connected Communities | 2020-08-05 | 93513 | 45198H | In-House Lobbyist | Karen | Gomez | Growth and Community Manager | No | |||||||||
29 | SM30420 | 45196S 2 | Transportation Services Division | Employee of the City | Manager, Operations and Maintenance | 2020-10-09 | 94498 | 45198H | In-House Lobbyist | Karen | Gomez | Growth and Community Manager | No | |||||||||
30 | SM30420 | 45196S 2 | Transportation Services Division | Employee of the City | Manager | 2020-10-09 | 94500 | 45198H | In-House Lobbyist | Karen | Gomez | Growth and Community Manager | No | |||||||||
31 | SM30420 | 45196S 2 | Deputy City Manager, Corporate Services | Employee of the City | Director, Strategic Policy & Planning | 2020-08-17 | 93514 | 45198H | In-House Lobbyist | Karen | Gomez | Growth and Community Manager | No | |||||||||
32 | SM30420 | 45196S 2 | Deputy City Manager, Corporate Services | Employee of the City | Director, Strategic Policy & Planning | 2020-08-05 | 93514 | 45198H | In-House Lobbyist | Karen | Gomez | Growth and Community Manager | No | |||||||||
33 | SM30420 | 45196S 2 | Transportation Services Division | Employee of the City | Director, Policy and Innovation | 2020-10-14 | 94501 | 45198H | In-House Lobbyist | Karen | Gomez | Growth and Community Manager | No | |||||||||
34 | SM30420 | 45196S 2 | Transportation Services Division | Employee of the City | Director, Policy and Innovation | Meeting | 2020-10-13 | 94606 | 45264H | In-House Lobbyist | David | Keaney | COO | No | ||||||||
35 | SM30420 | 45196S 2 | Transportation Services Division | Employee of the City | Director, Policy and Innovation | Meeting | 2020-10-13 | 94501 | 45198H | In-House Lobbyist | Karen | Gomez | Growth and Community Manager | No | ||||||||
37 | SM30420 | 45196S 2 | Transportation Services Division | Employee of the City | Director, Policy and Innovation | 2020-10-09 | 94501 | 45198H | In-House Lobbyist | Karen | Gomez | Growth and Community Manager | No | |||||||||
38 | SM30420 | 45196S 2 | Transportation Services Division | Employee of the City | Director, Policy and Innovation | 2020-10-08 | 94501 | 45198H | In-House Lobbyist | Karen | Gomez | Growth and Community Manager | No | |||||||||
39 | SM30420 | 45196S 2 | Transportation Services Division | Employee of the City | Director, Operations and Maintenance | Meeting | 2020-10-13 | 94611 | 45264H | In-House Lobbyist | David | Keaney | COO | No | ||||||||
40 | SM30420 | 45196S 2 | Transportation Services Division | Employee of the City | Director, Operations and Maintenance | Meeting | 2020-10-13 | 94495 | 45198H | In-House Lobbyist | Karen | Gomez | Growth and Community Manager | No | ||||||||
42 | SM30420 | 45196S 2 | Transportation Services Division | Employee of the City | Director, Operations and Maintenance | 2020-10-09 | 94495 | 45198H | In-House Lobbyist | Karen | Gomez | Growth and Community Manager | No | |||||||||
43 | SM30420 | 45196S 2 | Technology Services | Employee of the City | Director, Enterprise Spatial and Digital Services | 2020-10-09 | 93620 | 45198H | In-House Lobbyist | Karen | Gomez | Growth and Community Manager | No | |||||||||
44 | SM30420 | 45196S 2 | Technology Services | Employee of the City | Director, Enterprise Spatial and Digital Services | 2020-09-18 | 93620 | 45198H | In-House Lobbyist | Karen | Gomez | Growth and Community Manager | No | |||||||||
45 | SM30420 | 45196S 2 | Technology Services | Employee of the City | Director, Enterprise Spatial and Digital Services | 2020-08-31 | 93620 | 45198H | In-House Lobbyist | Karen | Gomez | Growth and Community Manager | No | |||||||||
46 | SM30420 | 45196S 2 | Technology Services | Employee of the City | Director, Enterprise Spatial and Digital Services | Meeting | 2020-08-17 | 93622 | 45264H | In-House Lobbyist | David | Keaney | COO | No | ||||||||
47 | SM30420 | 45196S 2 | Technology Services | Employee of the City | Director, Enterprise Spatial and Digital Services | Meeting;E-mail | 2020-08-17 | 93620 | 45198H | In-House Lobbyist | Karen | Gomez | Growth and Community Manager | No | ||||||||
49 | SM30420 | 45196S 2 | Technology Services | Employee of the City | Director, Enterprise Spatial and Digital Services | 2020-08-05 | 93620 | 45198H | In-House Lobbyist | Karen | Gomez | Growth and Community Manager | No | |||||||||
50 | SM30420 | 45196S 2 | Transformation Office | Employee of the City | Director | 2020-08-05 | 93511 | 45198H | In-House Lobbyist | Karen | Gomez | Growth and Community Manager | No | |||||||||
55 | SM30420 | 45196S 2 | Technology Services | Employee of the City | Chief Technology Officer | 2020-08-05 | 93503 | 45198H | In-House Lobbyist | Karen | Gomez | Growth and Community Manager | No | |||||||||
56 | SM30420 | 45196S 2 | Transportation Services Division | Employee of the City | Assistant to the General Manager | 2020-09-18 | 94109 | 45198H | In-House Lobbyist | Karen | Gomez | Growth and Community Manager | No | |||||||||
57 | SM30420 | 45196S 2 | Engineering & Construction Services | Employee of the City | Assistant to the Chief Engineer and Executive Dire | 2020-09-14 | 94046 | 45198H | In-House Lobbyist | Karen | Gomez | Growth and Community Manager | No | |||||||||
58 | SM30420 | 45196S 2 | Deputy City Manager, Corporate Services | Employee of Local Board | Executive Assistant to Deputy City Manager | 2020-08-05 | 93512 | 45198H | In-House Lobbyist | Karen | Gomez | Growth and Community Manager | No | |||||||||
59 | SM30420 | 45196S 2 | Mayor | Member of Council | Mayor | John Tory | 2020-08-24 | 93686 | 45198H | In-House Lobbyist | Karen | Gomez | Growth and Community Manager | No | ||||||||
60 | SM30420 | 45196S 2 | Ward 25 Scarborough-Rouge Park | Member of Council | Councillor | Jennifer McKelvie | 2020-08-31 | 93676 | 45198H | In-House Lobbyist | Karen | Gomez | Growth and Community Manager | No | ||||||||
61 | SM30420 | 45196S 2 | Ward 25 Scarborough-Rouge Park | Member of Council | Councillor | Jennifer McKelvie | 2020-08-21 | 93676 | 45198H | In-House Lobbyist | Karen | Gomez | Growth and Community Manager | No | ||||||||
62 | SM30420 | 45196S 2 | Ward 24 Scarborough-Guildwood | Member of Council | Councillor | Paul Ainslie | 2020-08-31 | 93675 | 45198H | In-House Lobbyist | Karen | Gomez | Growth and Community Manager | No | ||||||||
66 | SM35349 | 55813S 6 | Councillor Bradford | Staff of Member of Council | Madison Leisk | Meeting | 2024-02-27 | 114567 | 55815H | In-House Lobbyist | Mr. | David | Dunn | Partner | No | |||||||
67 | SM35349 | 55813S 6 | Councillor Bradford | Staff of Member of Council | Madison Leisk | Meeting | 2024-02-27 | 114566 | 55814H | In-House Lobbyist | Mr. | Adam | Lazier | Managing Partner | No | |||||||
69 | SM35349 | 55813S 6 | Ward 19 Beaches-East York | Member of Council | Councillor | Brad Bradford | Meeting | 2024-02-27 | 114564 | 55815H | In-House Lobbyist | Mr. | David | Dunn | Partner | No | ||||||
70 | SM35349 | 55813S 6 | Ward 19 Beaches-East York | Member of Council | Councillor | Brad Bradford | Meeting | 2024-02-27 | 114563 | 55814H | In-House Lobbyist | Mr. | Adam | Lazier | Managing Partner | No | ||||||
73 | SM35394 | 55919S 9 | 55922H | In-House Lobbyist | Chris | Manuel | National Sales Manager | No | ||||||||||||||
74 | SM35394 | 55919S 9 | 55923H | In-House Lobbyist | Jean-François | Dumas | Director Truck Sales | No | ||||||||||||||
76 | SM23684 | 12960S 10 | Ward 34 Don Valley East | Member of Council | Councillor | Denzil Minnan-Wong | Meeting | 2016-11-09 | 61445 | 17490H | In-House Lobbyist | Alain | Brandon | VP, CSR and GR | No | . | . | |||||
91 | SM23135 | 12960S 11 | Mayor's Office | Staff of Member of Council | Luke Robertson | Meeting | 2016-06-13 | 58087 | 17490H | In-House Lobbyist | Alain | Brandon | VP, CSR and GR | No | . | . | ||||||
92 | SM23135 | 12960S 11 | Ward 16 Eglinton-Lawrence | Member of Council | Councillor | Christin Carmichael Greb | Meeting | 2016-09-28 | 60091 | 17490H | In-House Lobbyist | Alain | Brandon | VP, CSR and GR | No | . | . | |||||
93 | SM23135 | 12960S 11 | Mayor | Member of Council | Mayor | John Tory | Telephone | 2016-05-20 | 57661 | 17490H | In-House Lobbyist | Alain | Brandon | VP, CSR and GR | No | . | . | |||||
95 | SM17466 | 12960S 12 | Toronto Public Health | Employee of the City | Medical Officer of Health | 2011-12-01 | 27430 | 17490H | In-House Lobbyist | Alain | Brandon | VP, CSR and GR | No | . | . | |||||||
96 | SM17345 | 12960S 13 | 13143H | In-House Lobbyist | Sonya | Fiorini, Previous senior officer | Sr Director, Corporate Social Responsibility | No | . | . | ||||||||||||
99 | SM17345 | 12960S 13 | Ward 8 York West | Member of Council | Councillor | Anthony Perruzza | 2016-10-17 | 60550 | 17490H | In-House Lobbyist | Alain | Brandon | VP, CSR and GR | No | . | . | ||||||
100 | SM17345 | 12960S 13 | Ward 44 Scarborough East | Member of Council | Councillor | Ron Moeser | 2016-10-17 | 60549 | 17490H | In-House Lobbyist | Alain | Brandon | VP, CSR and GR | No | . | . | ||||||
101 | SM17345 | 12960S 13 | Ward 41 Scarborough-Rouge River | Member of Council | Councillor | Chin Lee | 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 | 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 | 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 | . | . | |||||
117 | SM17345 | 12960S 13 | 13733H | In-House Lobbyist | Mr | Galen | Weston | Executive Chairman | 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 | . | . | ||||||
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 | . | . | ||||||
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 | . | . | |||||
219 | SM35402 | 39005S 16 | Ward 5 York South-Weston | Member of Council | Councillor | Frances Nunziata | Meeting | 2024-03-14 | 114720 | 49775H | In-House Lobbyist | Lily | Nikolovski | Senior Development Coordinator | No | |||||||
222 | SM34047 | 52014S 19 | 52015H | In-House Lobbyist | Nikolas | Papapetrou | Director of Development | No | ||||||||||||||
224 | SM34048 | 52014S 20 | 52015H | In-House Lobbyist | Nikolas | Papapetrou | Director of Development | No | ||||||||||||||
226 | SM34077 | 52014S 21 | 52015H | In-House Lobbyist | Nikolas | Papapetrou | Director of Development | No | ||||||||||||||
228 | SM34125 | 52014S 22 | 52015H | In-House Lobbyist | Nikolas | Papapetrou | Director of Development | No | ||||||||||||||
230 | SM34126 | 52014S 23 | 52015H | In-House Lobbyist | Nikolas | Papapetrou | Director of Development | No | ||||||||||||||
232 | SM34127 | 52014S 24 | 52015H | In-House Lobbyist | Nikolas | Papapetrou | Director of Development | No | ||||||||||||||
234 | SM34128 | 52014S 25 | 52015H | In-House Lobbyist | Nikolas | Papapetrou | Director of Development | No | ||||||||||||||
236 | SM34129 | 52014S 26 | 52015H | In-House Lobbyist | Nikolas | Papapetrou | Director of Development | No | ||||||||||||||
238 | SM34130 | 52014S 27 | 52015H | In-House Lobbyist | Nikolas | Papapetrou | Director of Development | No | ||||||||||||||
241 | SM35417 | 55949S 29 | 55950H | In-House Lobbyist | Tayo | Olafimihan | Senior Account Executive | No | ||||||||||||||
242 | SM35404 | 55938S 30 | 55939H | In-House Lobbyist | Gregory | Schleifman | Director, Business Development | No | ||||||||||||||
244 | SM29758 | 43228S 32 | 43325H | In-House Lobbyist | Christina | Doracin | Southern Ontario Playground Consultant | No | . | . | ||||||||||||
249 | SM35443 | 55992S 37 | 55993H | In-House Lobbyist | Joseph | J | Szymczyk | President | No | |||||||||||||
250 | SM35443 | 55992S 37 | 55994H | In-House Lobbyist | Kirk | Hawkins | Production Manager | No | ||||||||||||||
251 | SM35424 | 55816S 38 | 55817H | In-House Lobbyist | Mr | Jesse | jn | Napoleon | Ontario Specifications | No | ||||||||||||
263 | SM34851 | 54436S 45 | 54437H | In-House Lobbyist | Jeff | Byers | Regional Sales Manager | No |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );