This data provides additional addresses obtained from official company data sources. Additionally, this data file excludes registered addresses, which are included in the Company data file, as well as registered agent addresses, which are included in the Officers data file. There may be 0, 1 or more per company.
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 |
address_type | String Size limit – see Addtl Info sheet – Note [2] | Address type – eg mailing, company | If blank, the address type is unspecified |
street_address | String Size limit – see Addtl Info sheet – Note [2] | Street address part of address object for non-registered address (where available parsed from source) | |
locality | String Size limit – see Addtl Info sheet – Note [2] | Locality (e.g. city) part of address object for non-registered address (where available parsed from source) | |
region | String Size limit – see Addtl Info sheet – Note [2] | Region (e.g. state) part of address object for non-registered address (where available parsed from source) | |
postal_code | String Size limit – see Addtl Info sheet – Note [2] | Postal code (e.g. ZIP) part of address object for non-registered address (where available parsed from source) | |
country | String Size limit – see Addtl Info sheet – Note [2] | Country part of address object for non-registered address (where available parsed from source) | |
country_code | String Size limit – see Addtl Info sheet – Note [2] | Country part of address object for non-registered address (where available parsed from source) | |
in_full | String | Address in full – for when it has not been normalised into street address, locality, etc | |
start_date | Date (ISO 8601: YYYY-MM-DD) | Start date of an address | |
end_date | Date (ISO 8601: YYYY-MM-DD) | End date of an address |