Companies house excel export without director's name

[anne_kamanzi]

Hi,
I am not using the API, but i am using these exports here: Companies House
We are looking to acquire directors’ names (first and last name) but they are not given. Any idea how to do this?
Do i have to use the API to access these fields? Will it be free to pull this data (including first and last name of director) say all businesses registered in the last 2 years?
Thanks

[voracityemail]

Short: you’ll need to need to request this (see and reply to the thread below) OR you’ll need to use the API Company Officers endpoint or the XML Gateway.

Can we bulk download Officer/Director Data?

We would really like to get a bulk download of officer and directoral data. Looking at other queries on this they don't seem to have reached a resolution. Is something like this possible even as a one off exercise? At the minute the extraction is curtailed by the API throttling and the fact that you have to parse in the company number. Any assistance would be greatly appreciated. I'm aware of the bulk files available for company data (financial statements etc) but it's really the officer/human d…

Will it be free to pull this data …

Using the API is free, the XML gateway is chargeable, I don’t know about the Officers dataset mentioned above. For bulk data tasks Companies House recommend you use the bulk data products rather than the API. I don’t know what data fields are in the bulk data set - presumably company number is listed with each officer so you can cross-reference this with the list of companies registered in the last 2 years from the company bulk product. If not you’ll need to use the API and this will take some time at the standard rate allowance of 2 per second (you can look up all officers of a company by company reg. number).

You’ve specifically asked about the director’s names - if you want to find out “who controls” the companies then the PSC list might be more useful. You can get this via the API PSC endpoints OR via a bulk download at http://download.companieshouse.gov.uk/en_pscdata.html

The various data sets / interfaces available are listed at: https://www.gov.uk/guidance/companies-house-data-products
(The officers dataset seems to be only available by asking in the forum.)