Well it sounds like your main information would come from the bulk officer data that I suggested above. Once you’ve unified that data (if you need / want - to make sure you’ve one “ID” per “real officer” - as mentioned above) then you just need to fill in the extra details. As described in other replies to you. You can find the company details including “insolvency” using the Company Profile endpoint.
On insolvency - you have to be specific. Is it insolvency (current or previous) particularly or are you needing to know if the company is in receivership, in administration, has made a voluntary agreement etc.?
If you’re not certain about these you’ll want to read up on the details of UK companies law (it’s complicated). Companies House keeps track of a variety of different states. If you want a boolean here do you want to know if the company has declared insolvency now or are you interested if it has ever been insolvent? If the first you would probably look at the company_status member of the Company Profile resource, if the latter then the has_insolvency_history flag.
So you could write the code for this, or you could pay someone else to do it, or you could look through the forum for the various different individuals and companies offering different collections of data that they built from Companies House data.