officer

Data license: CC-By 4.0 · Data source: OpenCorporates

4,803,514 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: start_date (date), end_date (date)

Next page

CREATE TABLE officer (
	id INTEGER NOT NULL, 
	name TEXT, 
	position TEXT, 
	start_date TEXT, 
	type TEXT, 
	company_id TEXT, 
	city TEXT, 
	firstname TEXT, 
	flag TEXT, 
	lastname TEXT, 
	title TEXT, 
	dismissed TEXT, 
	end_date TEXT, 
	maidenname TEXT, 
	reference_no TEXT, 
	PRIMARY KEY (id)
);
CREATE INDEX officer_company_id on officer('company_id');