subject_matters

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

sm_number

Subject matter registration number (format SMnnnnn)

status

Status of subject matter registration e.g. active

type

Lobbyist type (e.g. voluntary, in-house, consultant)

subject_matter

Subject matter (e.g. grants/funding)

particulars

Decision(s) or issue(s) to be lobbied

initial_approval_date

Initial subject matter registration approval date

effective_date

Most recent subject matter registration approval date

proposed_start_date

Start of time period for lobbying on this subject matter

proposed_end_date

End of time period for lobbying on this subject matter

5,071 rows where status = "Closed"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: subject_matter_definition, initial_approval_date (date), effective_date (date), proposed_start_date (date), proposed_end_date (date)

Next page

CREATE TABLE subject_matters (
	sm_number VARCHAR(10) NOT NULL, 
	status VARCHAR(20), 
	type VARCHAR(50), 
	subject_matter VARCHAR, 
	particulars VARCHAR, 
	subject_matter_definition VARCHAR, 
	initial_approval_date VARCHAR, 
	effective_date VARCHAR, 
	proposed_start_date VARCHAR, 
	proposed_end_date VARCHAR, 
	registrant_id INTEGER, 
	PRIMARY KEY (sm_number), 
	UNIQUE (registrant_id), 
	FOREIGN KEY(registrant_id) REFERENCES registrants (id)
);