This file contains alternative names from the OpenCorporates database. Where available, the file contains information for the data period that an alternative name was relevant, as well as what type of alternative name a record represents. All fields are optional unless shown as Mandatory
Field Name | Format | Field Description | Field-Level Notes |
company_number | String – varchar(128) | Identifier given by the Company register to the entity. Together with the jurisdiction_code this forms a composite foreign key for the companies dataset. | Mandatory. FK to Companies |
jurisdiction_code | String – varchar(8) | Code for the jurisdiction (lowercase, underscore version of ISO 3166-2 code). List of jurisdiction codes and the names of the jurisdictions is available at https://api.opencorporates.com/jurisdictions | Mandatory. FK to Companies |
name | String | Alternative name for an entity | |
start_date | String | Alternative name known start date | |
end_date | String | Alternative name known end date | |
type | String | Alternative name type |