firms

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

type

Business/organization type (e.g. voluntary, in-house, consultant)

name

Business/organization name

trade_name

Other trade names used

fiscal_start

Fiscal year of the business/organization start date

fiscal_end

Fiscal year of the business/organization end date

description

Description of business activities

business_type

Business/organization type (e.g. corporation)

957 rows where type = "Subsidiary"

✎ View and edit SQL

This data as json, CSV (advanced)

Next page

CREATE TABLE firms (
	id INTEGER NOT NULL, 
	sm_number VARCHAR(10), 
	type VARCHAR(50), 
	name VARCHAR(100), 
	trade_name VARCHAR(100), 
	fiscal_start VARCHAR, 
	fiscal_end VARCHAR, 
	description VARCHAR, 
	business_type VARCHAR(50), 
	PRIMARY KEY (id), 
	FOREIGN KEY(sm_number) REFERENCES subject_matters (sm_number)
);