Dear all,
I have just run the following request in my Java code:
https://api.company-information.service.gov.uk/advanced-search/companies?dissolved_from=2022-01-01&dissolved_to=2022-02-01&size=5000
and strangely I get the Company Number: 10304075.
But this company is not dissolved.
Regards,
Alex
Hello @depire, if you have a look in the filling history for the company, you’ll see the company was struck off in Jan 2022 and was subsequently re-instated in February 2023.
You’ll have to make coding or record notes for these updates in your system - it does happen fairly often with companies.
Hope it helps you.
Thank a lot. Do you know how to download the list of dissolved companies? I see that on 4th Jaunary 2022, more than 10 000 companies were dissolved, but with API we can download a maximum of 5000 records.
Can you help me ?
Hello @depire I assume from you comments that you want to build a back catalogue of Dissolved records to hold on your system?
CHS have loaded the dissolved records back to the start 0f 2010 – that’s somewhere around 6 million plus records - For 2022 alone the number of days that have more than 5000 records is around 45
Dissol_Date Status Count
04/01/2022 Dissolved 21312
11/01/2022 Dissolved 10925
18/01/2022 Dissolved 14662
01/02/2022 Dissolved 20313
08/02/2022 Dissolved 10562
15/02/2022 Dissolved 12990
22/02/2022 Dissolved 10095
01/03/2022 Dissolved 12068
08/03/2022 Dissolved 9958
22/03/2022 Dissolved 17831
29/03/2022 Dissolved 12463
05/04/2022 Dissolved 11730
12/04/2022 Dissolved 8544
19/04/2022 Dissolved 14855
26/04/2022 Dissolved 15153
03/05/2022 Dissolved 8904
10/05/2022 Dissolved 10407
17/05/2022 Dissolved 11179
24/05/2022 Dissolved 12918
31/05/2022 Dissolved 7476
07/06/2022 Dissolved 11625
14/06/2022 Dissolved 12103
21/06/2022 Dissolved 13032
28/06/2022 Dissolved 12642
05/07/2022 Dissolved 10619
12/07/2022 Dissolved 10052
19/07/2022 Dissolved 12499
26/07/2022 Dissolved 11358
02/08/2022 Dissolved 7691
09/08/2022 Dissolved 13799
16/08/2022 Dissolved 12559
23/08/2022 Dissolved 9240
30/08/2022 Dissolved 11763
06/09/2022 Dissolved 9280
13/09/2022 Dissolved 14350
20/09/2022 Dissolved 11029
27/09/2022 Dissolved 10571
04/10/2022 Dissolved 10420
11/10/2022 Dissolved 10024
18/10/2022 Dissolved 13210
25/10/2022 Dissolved 11906
01/11/2022 Dissolved 10224
13/12/2022 Dissolved 16614
20/12/2022 Dissolved 17400
27/12/2022 Dissolved 21384
So, you need a way to split those days into smaller exports - I would not use the API for this as you are limited to 10000 with that – unless you introduced the Incorporation Date parameter(s). Your second question would not work – that will just produce a blank return error from the API, with start index 10000.
Perhaps try the Advanced Search on the CHS website and manipulate the incorporation date there to reduce the size of the records returned; This method will give you a Flat File output.
Attached is the file from this method for 04/01/2022 for you;
dbo_CompaniesHouseSearchResults_Dissolved-2024-01-04.txt (3.5 MB)
Hope it helps.
Whilst this works well it will be time consuming and somewhat expensive if properly costed.
Those who want to build a back catalogue of Dissolved records to hold on their own system may like to know that StatBooks hold over 8 million curated Dissolved company records and can supply some or all (as required) of these as text files and also have a daily update service that provides both new dissolved and restored to our subscribers.
Curated data does have a price but is likely be more cost-effective and demonstrably precise than multiple downloads.
Please contact admin@statbooks.co.uk with your requirements.
Maybe I misunderstood something, but do you mean that we can download from somewhere this listing of 6 million records? If yes, can you provide the URL?
Thanks
For the Back Catalogue of dissolved companies, as far as I can see - there are only two options for this;
Companies House in the past had a facility where you could buy a DVD of dissolved records, but that has now been superseded by this URL:
But that URL, regretfully, will not help you with bulk downloads and I am not aware of any facility on CHS that will supply a bulk download of the data you’re looking for, perhaps others may advise differently.
Finally, once you have your back catalogue - you then have to keep it up-to-date - for that you may want to investigate the Live Streaming Option(s) on CHS 
How did you find this list of dates having more than 5000 records ? Did you retrieve using a specific script or using a API or from a URL ?
Thanks
The officers bulk data file contains a line for companies with their company number, name and current status (dissolved represented by character ‘D’).
See my unofficial Officer bulk data record types | CH Guide .
This includes historically dissolved companies so you could at least get a list of all the companies which are dissolved, but it doesn’t include details about when/why they are dissolved.
