We are looking to aggregate data on accredited laboratories from individual U.S. state environmental agency websites into a consolidated data set. Through an industry association, we have already aggregated data for 14 states in total and would like to augment this data set with the labs accredited by the remaining 36 states. Some labs may be accredited in multiple states, however, and we would like to avoid double counting accredited labs. The final product should be a list of every unique lab accredited by at least one U.S. state environmental agency with no duplications of labs.
To do this, you will likely have to Google search each state agency individually (full list below) followed by “list of accredited environmental labs.” For example for Alabama, we searched “Alabama Department of Environmental Management list of accredited labs” and clicked on the first link: ([login to view URL])
This webpage included 5 lists of certified labs. Pull the data from each list and consolidate the data in the attached spreadsheet (which includes the labs from the first 14 states). Please include the URLs for each data source in the designated column in the spreadsheet.
I have included the list of state agencies and have also included screenshots from the example process, Alabama.
Full instructions and additional detail with screen shots can be found in the attached Word doc and the start of the aggregated list can be found in the attached Excel doc. There may be tools or scripting that can speed up certain elements, but overall this is probably mostly a manual process.
41 freelancers are bidding on average $117 for this job
Hello there, I can start your project right now with 100% accuracy and within time deadlines. I am happy to provide you a sample work. Please let me know. Thank you.
Hi there, I would love to assist you with your project. Please send me a message so we can discuss more details. I am Looking forward to hearing back from you. Thank you, Best Regards, Banuka Kannangara
Im a data scientist and i work with this on a daily basis, it would be my pleasure to assist you with the project and provide the solution timeously and efficiently to your satisfication.