Companies House fields in every export
Company records carry the company number, name, previous names, status, type, incorporation date, registered office address, SIC codes, accounts and confirmation statement dates.
The company number is the identifier everything joins on. Names change and are reused; the number does not, and a dataset matched on name will merge unrelated companies and split renamed ones.
Officer records carry the name as filed, role, appointment and resignation dates, nationality, occupation and the partial date of birth the register publishes. These describe identified living people and the dataset marks them as such, because what happens downstream to a personal data column should be a deliberate decision rather than an oversight.
Persons with significant control are collected as their own record type, with the nature of control as published.
Document records carry the filing type, date and address, with extracted content where a client needs the accounts as numbers rather than as files.