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
32,495 rows where poh_type = "Employee of the City"
This data as json, CSV (advanced)
Suggested facets: lobbyist_prefix, lobbyist_suffix, lobbyist_previous_public_office_hold_position, lobbyist_previous_public_office_position_program_name, lobbyist_previous_public_office_hold_last_date, communication_date (date), lobbyist_previous_public_office_hold_last_date (date)
lobbyist_type 2
- In-House Lobbyist 18,850
- Sr. Officer 6,197
poh_type 1
- Employee of the City · 32,495 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||
7 | SM30420 | 45196S 2 | Transportation Services Division | Employee of the City | Manager, Transportation Data and Analytics | Meeting | 2020-10-13 | 94597 | 45196S-1 | Sr. Officer | Emil | Ramos | CEO | 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 | ||||||||
13 | SM30420 | 45196S 2 | Transportation Services Division | Employee of the City | Manager, Traffic Systems | Meeting | 2020-10-13 | 94599 | 45196S-1 | Sr. Officer | Emil | Ramos | CEO | 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 | ||||||||
17 | SM30420 | 45196S 2 | Transportation Services Division | Employee of the City | Manager, Operations and Maintenance | Meeting | 2020-10-13 | 94601 | 45196S-1 | Sr. Officer | Emil | Ramos | CEO | 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 | ||||||||
20 | SM30420 | 45196S 2 | Transportation Services Division | Employee of the City | Manager, Operations & Maintenance | Meeting | 2020-10-13 | 94603 | 45196S-1 | Sr. Officer | Emil | Ramos | CEO | 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 | ||||||||
24 | SM30420 | 45196S 2 | Transportation Services Division | Employee of the City | Manager, Operational Planning and Policy | Meeting | 2020-10-13 | 94608 | 45196S-1 | Sr. Officer | Emil | Ramos | CEO | 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 | ||||||||
27 | SM30420 | 45196S 2 | Technology Services | Employee of the City | Manager, Connected Communities | Meeting | 2020-08-17 | 93624 | 45196S-1 | Sr. Officer | Emil | Ramos | CEO | 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 | ||||||||
36 | SM30420 | 45196S 2 | Transportation Services Division | Employee of the City | Director, Policy and Innovation | Meeting | 2020-10-13 | 94605 | 45196S-1 | Sr. Officer | Emil | Ramos | CEO | 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 | ||||||||
41 | SM30420 | 45196S 2 | Transportation Services Division | Employee of the City | Director, Operations and Maintenance | Meeting | 2020-10-13 | 94607 | 45196S-1 | Sr. Officer | Emil | Ramos | CEO | 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 | ||||||||
48 | SM30420 | 45196S 2 | Technology Services | Employee of the City | Director, Enterprise Spatial and Digital Services | Meeting | 2020-08-17 | 93621 | 45196S-1 | Sr. Officer | Emil | Ramos | CEO | 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 | |||||||||
51 | SM30420 | 45196S 2 | Corporate Services | Employee of the City | Deputy City Manager, Corporate Services | 2020-07-23 | 93481 | 45196S-1 | Sr. Officer | Emil | Ramos | CEO | No | |||||||||
52 | SM30420 | 45196S 2 | Corporate Services | Employee of the City | Deputy City Manager, Corporate Services | 2020-07-20 | 93481 | 45196S-1 | Sr. Officer | Emil | Ramos | CEO | No | |||||||||
53 | SM30420 | 45196S 2 | City Managers Office | Employee of the City | City Manager | 2020-07-23 | 93480 | 45196S-1 | Sr. Officer | Emil | Ramos | CEO | No | |||||||||
54 | SM30420 | 45196S 2 | City Managers Office | Employee of the City | City Manager | 2020-07-20 | 93480 | 45196S-1 | Sr. Officer | Emil | Ramos | CEO | 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 | |||||||||
94 | SM17466 | 12960S 12 | Toronto Public Health | Employee of the City | Medical Officer of Health | Meeting | 2011-11-14 | 27352 | 12960S-3 | Sr. Officer | Bob | Chant | SVP, Corporate Affairs and Communication | 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 | . | . | |||||||
259 | SM30922 | 46059S 44 | Transportation Services | Employee of the City | Manager, Strategic Policy and Innovation | Meeting | 2022-12-14 | 107357 | 46059S-1 | Sr. Officer | Lyle | Jones | Co-Founder | No | ||||||||
266 | SM22809 | 20086C 46 | City Manager's Office | Employee of the City | City Manager | Meeting | 2016-05-25 | 57718 | ||||||||||||||
267 | SM22809 | 20086C 46 | Economic Development & Culture | Employee of the City | Manager, Entrepreneurship Services | Telephone | 2016-03-17 | 56230 | ||||||||||||||
268 | SM22809 | 20086C 46 | Economic Development & Culture | Employee of the City | Manager, Entrepreneurship Services | Meeting | 2016-03-15 | 56230 | ||||||||||||||
269 | SM22809 | 20086C 46 | Information & Technology | Employee of the City | Chief Information Officer | Meeting | 2016-05-25 | 57717 | ||||||||||||||
360 | SM35072 | 37069C 54 | Planning | Employee of the City | Executive Director | 2024-04-01 | 114967 | |||||||||||||||
376 | SM22507 | 18186C 59 | Office of The City Manager | Employee of the City | City Manager | Meeting | 2016-06-03 | 57919 | ||||||||||||||
652 | SM32574 | 11252S 84 | Economic Development & Culture | Employee of the City | Sector Development Officers, Strategic Initiatives | 2023-01-18 | 107797 | 37380H | In-House Lobbyist | Craig | Ruttan | Director, Policy | No | . | . | |||||||
653 | SM32574 | 11252S 84 | Economic Development & Culture | Employee of the City | Sector Development Officers, Strategic Initiatives | Meeting;E-mail | 2023-01-10 | 107553 | 37380H | In-House Lobbyist | Craig | Ruttan | Director, Policy | No | . | . | ||||||
654 | SM32574 | 11252S 84 | Economic Development & Culture | Employee of the City | Sector Development Officer, Life Sciences | 2022-04-20 | 101975 | 37380H | In-House Lobbyist | Craig | Ruttan | Director, Policy | No | . | . | |||||||
655 | SM32574 | 11252S 84 | Economic Development & Culture | Employee of the City | Sector Development Officer, Life Sciences | Meeting | 2021-11-25 | 101975 | 37380H | In-House Lobbyist | Craig | Ruttan | Director, Policy | No | . | . | ||||||
656 | SM32574 | 11252S 84 | Economic Development & Culture | Employee of the City | Sector Development Officer, Life Sciences | 2021-11-17 | 101975 | 37380H | In-House Lobbyist | Craig | Ruttan | Director, Policy | No | . | . | |||||||
657 | SM32574 | 11252S 84 | Economic Development & Culture | Employee of the City | Sector Development Officer, Green Sectors | 2022-04-20 | 101974 | 37380H | In-House Lobbyist | Craig | Ruttan | Director, Policy | No | . | . | |||||||
658 | SM32574 | 11252S 84 | Economic Development & Culture | Employee of the City | Sector Development Officer, Green Sectors | Meeting | 2021-11-25 | 101974 | 37380H | In-House Lobbyist | Craig | Ruttan | Director, Policy | No | . | . | ||||||
659 | SM32574 | 11252S 84 | Economic Development & Culture | Employee of the City | Sector Development Officer, Green Sectors | 2021-11-17 | 101974 | 37380H | In-House Lobbyist | Craig | Ruttan | Director, Policy | No | . | . | |||||||
660 | SM32574 | 11252S 84 | Environment & Climate | Employee of the City | Program Manager, Policy and Research | 2023-02-22 | 106601 | 37380H | In-House Lobbyist | Craig | Ruttan | Director, Policy | No | . | . | |||||||
661 | SM32574 | 11252S 84 | Environment & Climate | Employee of the City | Program Manager, Policy and Research | Meeting | 2023-02-21 | 106601 | 37380H | In-House Lobbyist | Craig | Ruttan | Director, Policy | No | . | . | ||||||
662 | SM32574 | 11252S 84 | Environment & Climate | Employee of the City | Program Manager, Policy and Research | Meeting | 2023-01-20 | 106601 | 37380H | In-House Lobbyist | Craig | Ruttan | Director, Policy | No | . | . | ||||||
663 | SM32574 | 11252S 84 | Environment & Climate | Employee of the City | Program Manager, Policy and Research | 2022-11-25 | 106601 | 37380H | In-House Lobbyist | Craig | Ruttan | Director, Policy | No | . | . | |||||||
664 | SM32574 | 11252S 84 | Environment & Climate | Employee of the City | Program Manager, Policy and Research | 2022-11-24 | 106601 | 37380H | In-House Lobbyist | Craig | Ruttan | Director, Policy | No | . | . | |||||||
665 | SM32574 | 11252S 84 | Environment & Climate | Employee of the City | Program Manager, Policy and Research | 2022-11-24 | 106748 | 30771H | In-House Lobbyist | Matthew | Kofsky | Director, Stakeholder Relations | No | . | . | |||||||
666 | SM32574 | 11252S 84 | Environment & Climate | Employee of the City | Program Manager, Policy and Research | 2022-11-15 | 106601 | 37380H | In-House Lobbyist | Craig | Ruttan | Director, Policy | No | . | . | |||||||
667 | SM32574 | 11252S 84 | Environment and Climate | Employee of the City | Program Manager, Policy and Research | 2022-09-15 | 106028 | 37380H | In-House Lobbyist | Craig | Ruttan | Director, Policy | No | . | . | |||||||
668 | SM32574 | 11252S 84 | Environment & Energy | Employee of the City | Program Manager, Policy and Research | 2022-08-19 | 101976 | 37380H | In-House Lobbyist | Craig | Ruttan | Director, Policy | No | . | . | |||||||
669 | SM32574 | 11252S 84 | Environment & Energy | Employee of the City | Program Manager, Policy and Research | 2022-04-20 | 101976 | 37380H | In-House Lobbyist | Craig | Ruttan | Director, Policy | No | . | . | |||||||
670 | SM32574 | 11252S 84 | Economic Development & Culture | Employee of the City | Program Manager, Policy and Research | Meeting | 2021-11-25 | 102172 | 37380H | In-House Lobbyist | Craig | Ruttan | Director, Policy | No | . | . | ||||||
671 | SM32574 | 11252S 84 | Environment & Energy | Employee of the City | Program Manager, Policy and Research | 2021-11-17 | 101976 | 37380H | In-House Lobbyist | Craig | Ruttan | Director, Policy | No | . | . | |||||||
672 | SM32574 | 11252S 84 | Environment & Energy | Employee of the City | Manager, Public Energy Initiatives New Developme | 2022-02-10 | 103328 | 37380H | In-House Lobbyist | Craig | Ruttan | Director, Policy | No | . | . | |||||||
673 | SM32574 | 11252S 84 | Environment & Energy | Employee of the City | Manager, Public Energy Initiatives Existing Buil | 2022-02-10 | 103331 | 37380H | In-House Lobbyist | Craig | Ruttan | Director, Policy | No | . | . | |||||||
674 | SM32574 | 11252S 84 | Environment & Energy | Employee of the City | Manager, Policy and Research | 2022-02-10 | 103329 | 37380H | In-House Lobbyist | Craig | Ruttan | Director, Policy | No | . | . | |||||||
675 | SM32574 | 11252S 84 | Environment & Climate | Employee of the City | Manager, Policy & Research | 2023-02-22 | 107798 | 37380H | In-House Lobbyist | Craig | Ruttan | Director, Policy | No | . | . | |||||||
676 | SM32574 | 11252S 84 | Environment & Climate | Employee of the City | Manager, Policy & Research | Meeting | 2023-01-20 | 107798 | 37380H | In-House Lobbyist | Craig | Ruttan | Director, Policy | No | . | . | ||||||
677 | SM32574 | 11252S 84 | Environment & Energy | Employee of the City | Manager, Environment and Energy Program Administra | 2022-02-10 | 103330 | 37380H | In-House Lobbyist | Craig | Ruttan | Director, Policy | No | . | . | |||||||
678 | SM32574 | 11252S 84 | Environment & Climate | Employee of the City | Management Consultant | Meeting | 2022-11-07 | 106476 | 45116H | In-House Lobbyist | Roselle | Martino | Vice President, Policy | No | ||||||||
679 | SM32574 | 11252S 84 | Environment & Climate | Employee of the City | Management Consultant | Meeting | 2022-11-07 | 106475 | 37380H | In-House Lobbyist | Craig | Ruttan | Director, Policy | No | . | . | ||||||
680 | SM32574 | 11252S 84 | Environment & Climate Division | Employee of the City | Executive Director | 2023-11-24 | 112799 | 54393H | In-House Lobbyist | Monika | Wyrzykowska | Director, Policy | No | |||||||||
681 | SM32574 | 11252S 84 | Environment & Climate Division | Employee of the City | Executive Director | 2023-11-24 | 112800 | 54369H | In-House Lobbyist | David | Campbell | Associate Vice President, Policy & Research | No | |||||||||
682 | SM32574 | 11252S 84 | Environment and Climate Division | Employee of the City | Executive Director | Meeting | 2023-11-17 | 112722 | 54393H | In-House Lobbyist | Monika | Wyrzykowska | Director, Policy | No | ||||||||
683 | SM32574 | 11252S 84 | Environment and Climate Division | Employee of the City | Executive Director | Meeting | 2023-11-17 | 112721 | 54369H | In-House Lobbyist | David | Campbell | Associate Vice President, Policy & Research | No | ||||||||
684 | SM32574 | 11252S 84 | Environment & Climate | Employee of the City | Executive Director | 2022-11-16 | 106473 | 37380H | In-House Lobbyist | Craig | Ruttan | Director, Policy | No | . | . | |||||||
685 | SM32574 | 11252S 84 | Environment & Climate | Employee of the City | Executive Director | 2022-11-15 | 106473 | 37380H | In-House Lobbyist | Craig | Ruttan | Director, Policy | No | . | . | |||||||
686 | SM32574 | 11252S 84 | Environment & Climate | Employee of the City | Executive Director | Meeting | 2022-11-07 | 106474 | 45116H | In-House Lobbyist | Roselle | Martino | Vice President, Policy | No | ||||||||
687 | SM32574 | 11252S 84 | Environment & Climate | Employee of the City | Executive Director | Meeting | 2022-11-07 | 106473 | 37380H | In-House Lobbyist | Craig | Ruttan | Director, Policy | 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) );