# Data Issues **URL:** http://forum.companieshouse.gov.uk/c/data-issues/20.md [Latest](http://forum.companieshouse.gov.uk/latest.md) · [Categories](http://forum.companieshouse.gov.uk/categories.md) --- ## [About the Data Issues category](http://forum.companieshouse.gov.uk/t/about-the-data-issues-category/1078)
**Author:** [@mfairhurst](http://forum.companieshouse.gov.uk/u/mfairhurst)\ **Replies:** 0
The Data Issues category should be used to record data issues found within the API. --- ## [Extractives company information](http://forum.companieshouse.gov.uk/t/extractives-company-information/13068)
**Author:** [@gael.perrot29](http://forum.companieshouse.gov.uk/u/gael.perrot29)\ **Replies:** 1\ **Last updated:** [October 12, 2026, 1:21pm UTC](http://forum.companieshouse.gov.uk/t/extractives-company-information/13068 "2026-10-12T13:21:16Z")
Hello, I am compiling Companies House extractives data for academic research and need some clarification about the meaning and stability of project codes across reporting years. For example, in the data reported by Tul… --- ## [Officers Updates (Prod198) duplicate records](http://forum.companieshouse.gov.uk/t/officers-updates-prod198-duplicate-records/13046)
**Author:** [@dawn.barnaby](http://forum.companieshouse.gov.uk/u/dawn.barnaby)\ **Replies:** 0\ **Last updated:** [October 1, 2026, 11:19am UTC](http://forum.companieshouse.gov.uk/t/officers-updates-prod198-duplicate-records/13046 "2026-10-01T11:19:43Z")
We are trying to ingest the Officers updates file and apply it to our snapshot. I am currently working with the snapshot from 27 Sept, and the update file from 29 Sept. In the update file, I have two records where: com… --- ## [Officers Snapshot (Prod 195) Duplicate Records](http://forum.companieshouse.gov.uk/t/officers-snapshot-prod-195-duplicate-records/13045)
**Author:** [@dawn.barnaby](http://forum.companieshouse.gov.uk/u/dawn.barnaby)\ **Replies:** 0\ **Last updated:** [October 1, 2026, 11:19am UTC](http://forum.companieshouse.gov.uk/t/officers-snapshot-prod-195-duplicate-records/13045 "2026-10-01T11:19:37Z")
I am finding duplicate records (4876) in the Officers snapshot file for the same company number, person number and appointment type. For example, in the latest Snapshot file (27 Sept), there are 2 records for: company … --- ## [Officers (Prod195/198) Snapshot Missing Records?](http://forum.companieshouse.gov.uk/t/officers-prod195-198-snapshot-missing-records/13042)
**Author:** [@dawn.barnaby](http://forum.companieshouse.gov.uk/u/dawn.barnaby)\ **Replies:** 0\ **Last updated:** [September 30, 2026, 1:50pm UTC](http://forum.companieshouse.gov.uk/t/officers-prod195-198-snapshot-missing-records/13042 "2026-09-30T13:50:49Z")
I have recently ingested the latest snapshot file (26Sept) and the first update file uploaded after this (29Sept). The update file has 19,550 records, of which 228 I cannot work out how they should be applied. These are … --- ## [Restrictions = active-companies brings in Dissolved companies](http://forum.companieshouse.gov.uk/t/restrictions-active-companies-brings-in-dissolved-companies/13039)
**Author:** [@avni.patel](http://forum.companieshouse.gov.uk/u/avni.patel)\ **Replies:** 0\ **Last updated:** [September 30, 2026, 10:50am UTC](http://forum.companieshouse.gov.uk/t/restrictions-active-companies-brings-in-dissolved-companies/13039 "2026-09-30T10:50:22Z")
Hello, Using restrictions = active-companies filter within the list brings in companies status listed dissolve, any reason how to resolve this? Thanks --- ## [PSC Resource ID](http://forum.companieshouse.gov.uk/t/psc-resource-id/13022)
**Author:** [@radhika.sharma](http://forum.companieshouse.gov.uk/u/radhika.sharma)\ **Replies:** 1\ **Last updated:** [September 23, 2026, 11:25am UTC](http://forum.companieshouse.gov.uk/t/psc-resource-id/13022 "2026-09-23T11:25:31Z")
Is “resource\_id” the only field which can help us identify PSCs uniquely? Does it correspond to the “links\_self” field in the bulk PSC Snapshot? --- ## [1 August 2026 snapshot - Blank/malformed record in the Basic Company Data CSV](http://forum.companieshouse.gov.uk/t/1-august-2026-snapshot-blank-malformed-record-in-the-basic-company-data-csv/13020)
**Author:** [@companieshousedata](http://forum.companieshouse.gov.uk/u/companieshousedata)\ **Replies:** 0\ **Last updated:** [September 22, 2026, 8:17am UTC](http://forum.companieshouse.gov.uk/t/1-august-2026-snapshot-blank-malformed-record-in-the-basic-company-data-csv/13020 "2026-09-22T08:17:45Z")
In the 1 August 2026 snapshot, one parsed record was empty and had a column count that did not match the 54-column header: File: BasicCompanyDataAsOneFile-2026-08-01.csv SHA-256: 85d6048890adbce33ee9e6967b36cef1603d8f2… --- ## [20 August 2026 PSC snapshot - Null elements inside PSC \`natures\_of\_control\` arrays](http://forum.companieshouse.gov.uk/t/20-august-2026-psc-snapshot-null-elements-inside-psc-natures-of-control-arrays/13019)
**Author:** [@companieshousedata](http://forum.companieshouse.gov.uk/u/companieshousedata)\ **Replies:** 0\ **Last updated:** [September 22, 2026, 8:17am UTC](http://forum.companieshouse.gov.uk/t/20-august-2026-psc-snapshot-null-elements-inside-psc-natures-of-control-arrays/13019 "2026-09-22T08:17:41Z")
The 20 August 2026 PSC snapshot contained two null nature-of-control entries. Both were the first array element of individual-beneficial-owner records for company OE020203: File: psc-snapshot-2026-08-20\_14of32.txt Sour… --- ## [Corporate-looking Officers encoded as natural persons](http://forum.companieshouse.gov.uk/t/corporate-looking-officers-encoded-as-natural-persons/13017)
**Author:** [@companieshousedata](http://forum.companieshouse.gov.uk/u/companieshousedata)\ **Replies:** 0\ **Last updated:** [September 22, 2026, 8:17am UTC](http://forum.companieshouse.gov.uk/t/corporate-looking-officers-encoded-as-natural-persons/13017 "2026-09-22T08:17:32Z")
I identified records in the Officers bulk export represented as natural-person Officers that have blank forenames and corporate legal names, for example “KINGSWAY SECRETARIAL LIMITED”, “PELICAN SECRETARIES LIMITED”, and … --- ## [Uniquley identify the PSC records](http://forum.companieshouse.gov.uk/t/uniquley-identify-the-psc-records/13005)
**Author:** [@ahmed.sammour](http://forum.companieshouse.gov.uk/u/ahmed.sammour)\ **Replies:** 2\ **Last updated:** [September 21, 2026, 8:56am UTC](http://forum.companieshouse.gov.uk/t/uniquley-identify-the-psc-records/13005 "2026-09-21T08:56:53Z")
Is there a way to uniquely identify a PSC data. For example: PCS of Company A: PSC 1: Individual (John Kennedy) - born 1990 PSC2: Individual (Morgan Freeman) born in 2000 Then after few days, suppose we receive an ev… --- ## [Malformed 56-field row in BasicCompanyDataAsOneFile-2026-09-01.csv — company 08652773](http://forum.companieshouse.gov.uk/t/malformed-56-field-row-in-basiccompanydataasonefile-2026-09-01-csv-company-08652773/12971)
**Author:** [@munsroy](http://forum.companieshouse.gov.uk/u/munsroy)\ **Replies:** 1\ **Last updated:** [September 15, 2026, 10:22am UTC](http://forum.companieshouse.gov.uk/t/malformed-56-field-row-in-basiccompanydataasonefile-2026-09-01-csv-company-08652773/12971 "2026-09-15T10:22:35Z")
Hello, I have found a reproducible defect in the September 2026 Basic Company Data Product. Affected archive BasicCompanyDataAsOneFile-2026-09-01.zip Affected CSV BasicCompanyDataAsOneFile-2026-09-01.csv The CSV he… --- ## [Invalid BasicCompanyData-YYYY-MM-DD-part4\_7](http://forum.companieshouse.gov.uk/t/invalid-basiccompanydata-yyyy-mm-dd-part4-7/12863)
**Author:** [@krisjanis.bruveris](http://forum.companieshouse.gov.uk/u/krisjanis.bruveris)\ **Replies:** 1\ **Last updated:** [August 3, 2026, 2:26pm UTC](http://forum.companieshouse.gov.uk/t/invalid-basiccompanydata-yyyy-mm-dd-part4-7/12863 "2026-08-03T14:26:32Z")
Hello, For the third consecutive month, we have encountered an issue with the Basic Data CSV file. This month, the affected file is BasicCompanyData-2026-07-01-part4\_7.zip. As in the previous months, the problem is in B… --- ## [Update of the latest snapshot register](http://forum.companieshouse.gov.uk/t/update-of-the-latest-snapshot-register/12739)
**Author:** [@galanakis.gian](http://forum.companieshouse.gov.uk/u/galanakis.gian)\ **Replies:** 1\ **Last updated:** [April 9, 2026, 12:54pm UTC](http://forum.companieshouse.gov.uk/t/update-of-the-latest-snapshot-register/12739 "2026-04-09T12:54:07Z")
Hello, when will the latest snapshot of the register become available please? --- ## [The Free Company Data Product unzipped files issue](http://forum.companieshouse.gov.uk/t/the-free-company-data-product-unzipped-files-issue/12687)
**Author:** [@harsha.para](http://forum.companieshouse.gov.uk/u/harsha.para)\ **Replies:** 0\ **Last updated:** [February 27, 2026, 9:20am UTC](http://forum.companieshouse.gov.uk/t/the-free-company-data-product-unzipped-files-issue/12687 "2026-02-27T09:20:26Z")
The Free Company Data Product Companies House unzipped files got different structure from today’s zipped files (home/bulkdata/scripts/temp/217), it should be simple csv file after unzipping --- ## [Linking person\_number to company number in bulk data](http://forum.companieshouse.gov.uk/t/linking-person-number-to-company-number-in-bulk-data/12670)
**Author:** [@companies.house1](http://forum.companieshouse.gov.uk/u/companies.house1)\ **Replies:** 2\ **Last updated:** [February 26, 2026, 4:15pm UTC](http://forum.companieshouse.gov.uk/t/linking-person-number-to-company-number-in-bulk-data/12670 "2026-02-26T16:15:24Z")
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 Occupation is Missing](http://forum.companieshouse.gov.uk/t/officer-occupation-is-missing/12685)
**Author:** [@API\_User](http://forum.companieshouse.gov.uk/u/API_User)\ **Replies:** 2\ **Last updated:** [February 25, 2026, 3:34pm UTC](http://forum.companieshouse.gov.uk/t/officer-occupation-is-missing/12685 "2026-02-25T15:34:55Z")
I work for a company that regularly uses the Companies House Public Data API to look up company and officer information. We have noticed that previously we would be receiving Occupation data for Officers as part of an o… --- ## [Inconsistency between Officer Bulk Snapshot and Stream: Incorrect officer\_role and Address Formatting](http://forum.companieshouse.gov.uk/t/inconsistency-between-officer-bulk-snapshot-and-stream-incorrect-officer-role-and-address-formatting/12647)
**Author:** [@darius.staisiunas](http://forum.companieshouse.gov.uk/u/darius.staisiunas)\ **Replies:** 1\ **Last updated:** [February 5, 2026, 10:35am UTC](http://forum.companieshouse.gov.uk/t/inconsistency-between-officer-bulk-snapshot-and-stream-incorrect-officer-role-and-address-formatting/12647 "2026-02-05T10:35:19Z")
We have noticed significant inconsistencies between the Officer Bulk Snapshot and the Streaming API data. The Streaming API (and CH Service) appears to be correct, but the Bulk Snapshot contains conflicting information f… --- ## [Officers bulk data from Companies House Data mismatch with no.of officers](http://forum.companieshouse.gov.uk/t/officers-bulk-data-from-companies-house-data-mismatch-with-no-of-officers/12644)
**Author:** [@harsha.para](http://forum.companieshouse.gov.uk/u/harsha.para)\ **Replies:** 1\ **Last updated:** [February 3, 2026, 10:19am UTC](http://forum.companieshouse.gov.uk/t/officers-bulk-data-from-companies-house-data-mismatch-with-no-of-officers/12644 "2026-02-03T10:19:50Z")
Initially we have loaded snapshot bulk data (Product 195) few years back as one of load and then we have been loading corresponding update files( Product 198) Mon-Fri except weekends Currently we are seeing number of of… --- ## [Officers bulk data from Companies House Data mismatch with no.of officers](http://forum.companieshouse.gov.uk/t/officers-bulk-data-from-companies-house-data-mismatch-with-no-of-officers/12643)
**Author:** [@harsha.para](http://forum.companieshouse.gov.uk/u/harsha.para)\ **Replies:** 0\ **Last updated:** [January 30, 2026, 1:18pm UTC](http://forum.companieshouse.gov.uk/t/officers-bulk-data-from-companies-house-data-mismatch-with-no-of-officers/12643 "2026-01-30T13:18:52Z")
Initially we have loaded snapshot bulk data (Product 195) few years back as one of load and then we have been loading corresponding update files( Product 198) Mon-Fri except weekends Currently we are seeing number of of… --- ## [Huge increase in unallocated company numbers](http://forum.companieshouse.gov.uk/t/huge-increase-in-unallocated-company-numbers/12504)
**Author:** [@tmg745](http://forum.companieshouse.gov.uk/u/tmg745)\ **Replies:** 1\ **Last updated:** [December 10, 2025, 12:05pm UTC](http://forum.companieshouse.gov.uk/t/huge-increase-in-unallocated-company-numbers/12504 "2025-12-10T12:05:43Z")
I have noticed there has been a huge increase in unallocated company numbers since November 2025. I am sure this is because registrations have been declared invalid due to improved vetting following legislation over the… --- ## [Missing PSC timepoints & insufficient backlog in PSC streaming API](http://forum.companieshouse.gov.uk/t/missing-psc-timepoints-insufficient-backlog-in-psc-streaming-api/12375)
**Author:** [@jburant](http://forum.companieshouse.gov.uk/u/jburant)\ **Replies:** 4\ **Last updated:** [December 4, 2025, 3:02pm UTC](http://forum.companieshouse.gov.uk/t/missing-psc-timepoints-insufficient-backlog-in-psc-streaming-api/12375 "2025-12-04T15:02:13Z")
Due to the recent and unprecedented ingestion of approximately 5 million PSC records by Companies House over the period of a few days combined with a brief outage on my infrastructure, I realized I am missing about 2 mil… --- ## [Officer appointment verified but identify is not verified](http://forum.companieshouse.gov.uk/t/officer-appointment-verified-but-identify-is-not-verified/12446)
**Author:** [@bchazalet](http://forum.companieshouse.gov.uk/u/bchazalet)\ **Replies:** 6\ **Last updated:** [November 26, 2025, 12:31pm UTC](http://forum.companieshouse.gov.uk/t/officer-appointment-verified-but-identify-is-not-verified/12446 "2025-11-26T12:31:30Z")
We have found that the majority of verified appointments have no identity verified date. We have counted 38647 so far (for 47161 verified appointments in total). We collect the data via the streaming api (the officers an… --- ## [Officer verification date is before 2025](http://forum.companieshouse.gov.uk/t/officer-verification-date-is-before-2025/12445)
**Author:** [@bchazalet](http://forum.companieshouse.gov.uk/u/bchazalet)\ **Replies:** 0\ **Last updated:** [November 24, 2025, 2:32pm UTC](http://forum.companieshouse.gov.uk/t/officer-verification-date-is-before-2025/12445 "2025-11-24T14:32:22Z")
We have found 481 officer appointments whose verification date, identity\_verified\_on, is before the official date, i.e. 2025-04-01. This is data collected the data from the streaming api, officers and psc endpoints speci… --- ## [9-character resource\_id in companies streaming api?](http://forum.companieshouse.gov.uk/t/9-character-resource-id-in-companies-streaming-api/11782)
**Author:** [@jburant](http://forum.companieshouse.gov.uk/u/jburant)\ **Replies:** 3\ **Last updated:** [November 8, 2025, 3:08pm UTC](http://forum.companieshouse.gov.uk/t/9-character-resource-id-in-companies-streaming-api/11782 "2025-11-08T15:08:45Z")
I encountered an expected value in the resource\_id field in the response for timepoint 98011753 of the companies data streaming api, which was published at 2025-07-01T11:18:03. The value was RS009557Z, which is 9 charac… --- ## [Bulk company file missing previous names](http://forum.companieshouse.gov.uk/t/bulk-company-file-missing-previous-names/7718)
**Author:** [@ebrian101](http://forum.companieshouse.gov.uk/u/ebrian101)\ **Replies:** 5\ **Last updated:** [August 29, 2025, 9:27am UTC](http://forum.companieshouse.gov.uk/t/bulk-company-file-missing-previous-names/7718 "2025-08-29T09:27:17Z")
I’ve found cases where the previous names of companies are not included in the bulk product (Basic Company Profile Data CSV from https://download.companieshouse.gov.uk/en\_output.html). Company 03587701, line from CSV fi… --- ## [Accounts daily download zips missing from Aug 19th](http://forum.companieshouse.gov.uk/t/accounts-daily-download-zips-missing-from-aug-19th/12012)
**Author:** [@effahid](http://forum.companieshouse.gov.uk/u/effahid)\ **Replies:** 6\ **Last updated:** [August 24, 2025, 9:54pm UTC](http://forum.companieshouse.gov.uk/t/accounts-daily-download-zips-missing-from-aug-19th/12012 "2025-08-24T21:54:09Z")
The company accounts daily zip files haven’t been uploaded from Tuesday 19th. This is a bit disappointing as it happens every few months and is the third such occurrence that I can remember within the last year, acros… --- ## [Response missing leading zeros in registration number](http://forum.companieshouse.gov.uk/t/response-missing-leading-zeros-in-registration-number/11899)
**Author:** [@TomRF](http://forum.companieshouse.gov.uk/u/TomRF)\ **Replies:** 1\ **Last updated:** [July 24, 2025, 1:39pm UTC](http://forum.companieshouse.gov.uk/t/response-missing-leading-zeros-in-registration-number/11899 "2025-07-24T13:39:56Z")
I’ve found a scenario where the registration\_number within the response for a corporate persons of significant control is missing the leading zero. It doesn’t appear to happen in every case but is causing issues when we … --- ## [Bulk Data issue](http://forum.companieshouse.gov.uk/t/bulk-data-issue/11717)
**Author:** [@neil3](http://forum.companieshouse.gov.uk/u/neil3)\ **Replies:** 3\ **Last updated:** [July 21, 2025, 2:26pm UTC](http://forum.companieshouse.gov.uk/t/bulk-data-issue/11717 "2025-07-21T14:26:34Z")
Hello I am trying to read the iXRBL files that you can get from the Companies House page but when I try and use the code that has worked perfectly for all the months before (Except Oct 2024) I am getting fail after fail… --- ## [Discrepancies between bulk snapshot and CH API](http://forum.companieshouse.gov.uk/t/discrepancies-between-bulk-snapshot-and-ch-api/11833)
**Author:** [@harry.marshall](http://forum.companieshouse.gov.uk/u/harry.marshall)\ **Replies:** 2\ **Last updated:** [July 15, 2025, 8:51am UTC](http://forum.companieshouse.gov.uk/t/discrepancies-between-bulk-snapshot-and-ch-api/11833 "2025-07-15T08:51:54Z")
Hi, I have been transforming and loading the officer and company bulk snapshot kindly provided by your bulk data team. I have been comparing my data to the data returned by the Companies House API and noticed a few discr… [Next page](http://forum.companieshouse.gov.uk/c/data-issues/20.md?page=1)