Can't get data from Companies House and HMRC API that have more than £2m in turnover data

I've been dealing with this issue for a day now and have troubles getting company data from HMRC and Companies House API. I mainly need companies that have more than £1m turnover. I have set MIN_TURNOVER = 1_000_000 in my code to filter out companies that have less than £1m…