I emailed both sources, and County Health Rankings got back! They offer a spreadsheet download here.
I’ve copied the data to this Google sheet here (under tab “Ranked Measure Data”, column BN) for easier access. What’s remaining before we can get it to the statistician:
Get access to the water database (they might charge for this? not super sure, I just pinged them again)
Line up counties to zip codes (I think this link should suffice)
Write a script to combine these into a single zip code (I could probably do this)
The Tap Water Database seems to be less forthcoming with their data. Their response: “We don’t share the back end of the database with anyone.… I’m happy to run your proposal by the science team. Just send me a few detailed sentences about your research, whom you’re affiliated with, and where you’re going to publish it.”
I have no credentials in this space (my background is in software dev); would anyone with a relevant background be willing to help compose a reply + lend their affiliation?
I emailed both sources, and County Health Rankings got back! They offer a spreadsheet download here.
I’ve copied the data to this Google sheet here (under tab “Ranked Measure Data”, column BN) for easier access. What’s remaining before we can get it to the statistician:
Get access to the water database (they might charge for this? not super sure, I just pinged them again)
Line up counties to zip codes (I think this link should suffice)
Write a script to combine these into a single zip code (I could probably do this)
Happy for anyone else to jump in too!
The Tap Water Database seems to be less forthcoming with their data. Their response: “We don’t share the back end of the database with anyone.… I’m happy to run your proposal by the science team. Just send me a few detailed sentences about your research, whom you’re affiliated with, and where you’re going to publish it.”
I have no credentials in this space (my background is in software dev); would anyone with a relevant background be willing to help compose a reply + lend their affiliation?
Hi Austin- I keep holding off responding until I have a new plan, but now I’m swamped so that’s going to take a big. Thank you for trying!