Showing posts with label USA. Show all posts
Showing posts with label USA. Show all posts

Friday, November 6, 2015

KKK Locations and Concentration in the United States

Mr. Terrific vs the KKK

I wanted to originally title this post as "Racism in the USA" but I realized this really only scratches the surface of the different hate-groups that exist in America (sadly). =/ This is definitely one of the worst datasets I've ever looked through. *pukes*

This information came from a cursory scrape of the data dump from Anonymous last night 11-5-2015. I decided not to map the individual people's data as those wouldn't give us the succinct kind of picture we get when we look at the data as far as groups in several different ways.

I used Tableau Stories as I felt you can step through the data in a more meaningful way. I'll outline in below then you can dive into the data:

  • First off you can see the actual city locations of KKK groups.
    • You'll notice a STARK lack of anything in the western United States.
  • Secondly there is the concentration for NUMBER of KKK groups per state.
    • Wow... umm... yikes Texas. =(
  • Thirdly is the number of PEOPLE PER KKK group (not people IN each group).
    • I used 2014 Population Estimates based on the actual 2010 Census numbers.
    • OK... now yikes Mississippi!
  • Lastly is the square miles per state divided by number of KKK groups.
    • Here you'll notice several states previously not very dark become much more prevalent (again casting larger states like Texas in a better light).





As always if you have questions/comments/concerns please contact me at @wjking0

Friday, October 16, 2015

Kentucky WIC Usage 2000-2013


As a non-native Kentuckian I wasn't sure what WIC usage looked like in this state. My assumption was generally that WIC was something you'd see more of in large developed cities. It turns out I was wrong.

The data used came from the following:


For the calculations I applied the numbers to total calculation and not to subgroups for women or children under 18 so usage percentages for those may be higher but I don't have the WIC info regarding numbers of mothers vs children utilizing services so I didn't want to further muddy the numbers.

Also for these calculations I applied the 2000 census amounts to the 2000 WIC numbers and then for the 2006-2013 WIC numbers I used the closer 2010 census numbers as populations estimates for most regions were fairly stable over that time period.



As you can see, the large urban areas of Lexington and Louisville (Fayette and Jefferson Counties respectively) have fairly low usages of WIC (<2%) while areas particularly in eastern KY you can see have fairly high/consistent usage. I haven't done cost analysis yet but once the USDA fixes their website and I can get some more in-depth numbers I should have some more data to play with.

As usual hit me up at @wjking0 if you have any questions or concerns or just want to talk about public data!

EDIT: I've added the second dashboard/story as there was a request to look at the comparison of WIC % to Median Household Income so I crunched that out real quick: