Very nice work, @TGTBT! I love how critically you thought about the data and how you pulled everything together in your presentation. Moreover, it's great to see that you create a new index - the Worrisome Score - as a way to combine several measures into a single metric.
I noted that Wake County was number 50 on the list. Whoa. I live in Wake County... and it's also the location of SAS HQ. So, I was a bit surprised to see us on the list... given that we're not near the coast in a traditional "hotspot" for weather events. In investigating your Worrisome Score a bit more, I'm wondering if the population measure isn't driving things a bit too much. In fact, the top 50 counties are all large - and I didn't see any traditional rural/isolated counties in the list. So, for robustness, I'd love to see your results if you (1) normalized all the subcomponents to range between 0 and 1 (you can do that with a standardized Z-Score) and then (2) aggregate the variables, as specified in your current approach. Wake County concerns aside, great job!!!
... View more