Mapping US pump stations by CWNS number

Hi there, We would be interested to scrape the number of lift stations + treatment plants for a list of ~20,000 utilities. the utilities are in a clean data set by CWNS number from the EPA and include latitude/longitude and facility names, as well as state and county. There will be disparate data sources to understand the pump/lift station count -- and these are usually detailed records from the utility website. There is likely a more automated way to scrape all of this information. We would love to understand how long you would expect such an effort to take. We could prioritize the ~5,000 utilities where we would expect pump stations would be concentrated, but it would still be 5,000 rows of work. thank you for considering and happy to chat more. Regards, Scott