I’d like to request access to the following officers bulk data products:
• Product 195: snapshot of active officer appointments
• Product 198: daily update files, to keep the snapshot current
• Product 216: all officer appointments, including resigned officers
We provide prospect research and relationship mapping services to charities, helping them understand the connections between organisations and the people who lead them.
The officers data will let us map directorships and board connections across companies, including historical appointments, which the API can’t practically provide at this scale.
We’re looking for the officer information shown on the public register, including:
• Full name and title
• Officer role (director, secretary, LLP member, corporate director, etc.)
• Appointment and resignation dates
• Month and year of birth
• Nationality, country of residence and occupation
• Correspondence (service) address
• Any person identifier that links the same officer across multiple appointments
I have also emailed CH directly for follow-up if preferred.
Many thanks,
Konna Beeson
Director
Hi Konna,
I have been working on a Company Intelligence Portal using Companies House bulk data and your use case sounds very similar to some of the challenges I set out to solve.
For director and officer analysis, I used the Product 195 dataset as the foundation for a relational Director table. By using the Companies House person number and company number identifiers, I was able to link directors to multiple appointments and companies, making it possible to navigate from a company to its directors and from a director to their wider appointment history.
I also incorporated the PSC bulk data. The PSC files are supplied in JSON format, so one of the first challenges was converting the hierarchical JSON structure into a flat relational table that could be linked back to company records using company number. Once loaded into the database, PSC relationships could be analysed alongside director appointments and company information.
This approach enabled features such as:
- Company-to-director navigation.
- Director appointment histories across multiple companies.
- Discovery of companies connected through common directors.
- PSC and director relationship analysis.
- Enhanced company intelligence and research capabilities.
My experience was that the key to making the bulk data useful was transforming it from the source formats into a relational model centred on company number and person number. Once those relationships were established, the analysis became far more powerful than working directly with the raw files.
I’d be interested to hear how you’re planning to combine the officer and PSC datasets within your relationship mapping work.