Linking person_number to company number in bulk data

Data Issues
1

Hi,

In the bulk data for company appointments (both the snapshot files [Prod 195/216] and the daily updates [Prod 198]), all related officers are assigned a person_number.

If the corporate_indicator is set to “Y”, the officer is a corporate body, meaning it is itself a company with its own company number. My question is: Where can I find the corresponding company number for such officers?

Here is an example:

Company Number: 00719418 (NUMBER SEVENTEEN TENANTS ASSOCIATION LIMITED)

This company currently has a secretary that is a corporate body:
Company Number: 06097668 (BNS SERVICES LIMITED)
See: https://find-and-update.company-information.service.gov.uk/company/00719418/officers

In the bulk data, this secretary appears under two different person_numbers:

  • 118762960001 in files Prod195_4082_ew_1.dat and Prod216_4082_ew_1.dat

  • 340942380001 in file Prod198_4060.txt

How can these person_numbers be linked to the corresponding company number?

Kind regards,
Alex

2

Clarification on this would be appreciated, as it likely affects all users of the bulk datasets.

3

I don’t know about the bulk data products, but in the streaming api the reg. number under the identification:

"identification": {
    "identification_type": "string",
    "legal_authority": "string",
    "legal_form": "string",
    "place_registered": "string",
    "registration_number": "string"
},