# Linking person\_number to company number in bulk data

**URL:** <http://forum.companieshouse.gov.uk/t/linking-person-number-to-company-number-in-bulk-data/12670>\
**Category:** Data Issues\
**Created:** [February 12, 2026, 2:05pm UTC](http://forum.companieshouse.gov.uk/t/linking-person-number-to-company-number-in-bulk-data/12670 "2026-02-12T14:05:04Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![companies.house1](http://forum.companieshouse.gov.uk/letter_avatar_proxy/v4/letter/c/90ced4/32.png) [@companies.house1](http://forum.companieshouse.gov.uk/u/companies.house1)\
**Post date:** [February 12, 2026, 2:05pm UTC](http://forum.companieshouse.gov.uk/t/linking-person-number-to-company-number-in-bulk-data/12670/1 "2026-02-12T14:05:05Z")

</div>

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](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

---

<div class="post-metadata">

**Author:** ![youssefaferdou90](http://forum.companieshouse.gov.uk/letter_avatar_proxy/v4/letter/y/5daacb/32.png) [@youssefaferdou90](http://forum.companieshouse.gov.uk/u/youssefaferdou90)\
**Post date:** [February 23, 2026, 4:03pm UTC](http://forum.companieshouse.gov.uk/t/linking-person-number-to-company-number-in-bulk-data/12670/2 "2026-02-23T16:03:07Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![bchazalet](http://forum.companieshouse.gov.uk/letter_avatar_proxy/v4/letter/b/94ad74/32.png) [@bchazalet](http://forum.companieshouse.gov.uk/u/bchazalet)\
**Post date:** [February 26, 2026, 4:15pm UTC](http://forum.companieshouse.gov.uk/t/linking-person-number-to-company-number-in-bulk-data/12670/3 "2026-02-26T16:15:24Z")

</div>

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

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

```