Extract from Companies House: List of Companies (with Revenue) with Russian Ownership
Budget: £250 – £750 GBP
I am looking to compile a list of companies from Companies House website such that any of the owners (they are called "persons with significant control") have nationality in one of the following countries: Russia, Kazakhstan, Ukraine, Belarus, Georgia, Armenia, Kyrgyzstan, Azerbaijan, Tajikistan, Turkmenistan and Uzbekistan
The output should be an Excel file with the following columns:
(1) Full legal company name
(2) Company number
(3) List of all owners (they can be all in one cell separated by commas)
(4) List of all owners who have nationality in one of the countries mentioned above
(5) Last disclosed annual revenue of this company
(6) Nature of business (SIC)
(7) Address of registered office
Please only include "Active" companies (i.e. exclude those that are in process of liquidation or inactive)
Databases that can be downloaded from the following links can be helpful:
https://download.companieshouse.gov.uk/en_pscdata.html
https://download.companieshouse.gov.uk/en_accountsdata.html
The output should be an Excel file with the following columns:
(1) Full legal company name
(2) Company number
(3) List of all owners (they can be all in one cell separated by commas)
(4) List of all owners who have nationality in one of the countries mentioned above
(5) Last disclosed annual revenue of this company
(6) Nature of business (SIC)
(7) Address of registered office
Please only include "Active" companies (i.e. exclude those that are in process of liquidation or inactive)
Databases that can be downloaded from the following links can be helpful:
https://download.companieshouse.gov.uk/en_pscdata.html
https://download.companieshouse.gov.uk/en_accountsdata.html