Data Aggregation on U.S. Accredited Laboratories
Budget: $30 – $250 USD
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: (https://www.adem.alabama.gov/programs/water/drinkingwater/labcert.cnt)
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.
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: (https://www.adem.alabama.gov/programs/water/drinkingwater/labcert.cnt)
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.