lobbyist_business_addresses

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

127,370 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Next page

CREATE TABLE lobbyist_business_addresses (
	id INTEGER NOT NULL, 
	communication_id INTEGER, 
	address_line1 VARCHAR(100), 
	address_line2 VARCHAR(100), 
	city VARCHAR(50), 
	province VARCHAR(50), 
	country VARCHAR(50), 
	postal_code VARCHAR(20), 
	phone VARCHAR(20), 
	PRIMARY KEY (id), 
	UNIQUE (communication_id), 
	FOREIGN KEY(communication_id) REFERENCES communications (id)
);