1. Home
  2. Bulk Delivery
  3. Dictionaries
  4. Data Dictionary: Non-Registered Addresses

Data Dictionary: Non-Registered Addresses

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 NameFormatField DescriptionField-Level Notes
company_numberString – 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_codeString – 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/jurisdictionsMandatory. FK to Companies
address_typeString
Size limit – see Addtl Info sheet – Note [2]
Address type – eg mailing, companyIf blank, the address type is unspecified
street_addressString
Size limit – see Addtl Info sheet – Note [2]
Street address part of address object for non-registered address (where available parsed from source)
localityString
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)
regionString
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_codeString
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)
countryString
Size limit – see Addtl Info sheet – Note [2]
Country part of address object for non-registered address (where available parsed from source)
country_codeString
Size limit – see Addtl Info sheet – Note [2]
Country part of address object for non-registered address (where available parsed from source)
in_fullStringAddress in full – for when it has not been normalised into street address, locality, etc
start_dateDate (ISO 8601: YYYY-MM-DD)Start date of an address
end_dateDate (ISO 8601: YYYY-MM-DD)End date of an address
Updated on July 7, 2023
Was this article helpful?

Related Articles

Need Support?
Can’t find the answer you’re looking for? Don’t worry we’re here to help!
Contact Support