registrations

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

375,180 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Next page

CREATE TABLE registrations (
	id INTEGER NOT NULL, 
	confidence TEXT, 
	data_type TEXT, 
	publication_date TEXT, 
	retrieved_at TEXT, 
	source_url TEXT, 
	start_date TEXT, 
	start_date_type TEXT, 
	subsequent_registration_start_date TEXT, 
	company_id TEXT, 
	previous_company_number TEXT, 
	previous_jurisdiction_code TEXT, 
	previous_entity_type TEXT, 
	subsequent_company_number TEXT, 
	subsequent_jurisdiction_code TEXT, 
	subsequent_entity_type TEXT, sample_date TEXT, alternate_company_number TEXT, alternate_jurisdiction_code TEXT, alternate_entity_type TEXT, previous_registration_end_date TEXT, 
	PRIMARY KEY (id)
);
CREATE INDEX registrations_company_id on registrations('company_id');