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

44 rows where lobbyist_previous_public_office_holder = "Yes"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: sm_number, registrant_id, poh_office, poh_position, communication_method, communication_date, lobbyist_number, lobbyist_prefix, lobbyist_first_name, lobbyist_last_name, lobbyist_position_title, 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)

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)
);