3. Monthly discussion thread | October, 2019

Monthly discussion thread | October, 2019

I'm sorta new to this but I've been wanting to put a dataset like this together for quite some time and I have a few days off so I figured I'd give it a go. Problem is I can't quite figure out how to get the data and get it efficiently (so that it's "easy" to refresh later). I spent about 5 hours yesterday trying to figure out the Census data and where to get it and well I don't think I'm stupid but I can't quite figure out how to actually get the data much less the data I want.

So below is what I'm trying to put together, I pulled the Arkansas data manually. I think all of this data is available via the Census and I'm sure there is a central repository with election info.

I'd prefer to use the 2010 census data (then in a couple years replace it with the 2020) and for the calcs to make add up (which they don't right now). For instance Sum of AR District Populations = 2,978,204 but the population of the state shows 3,026,412.

Any guidance would be appreciated, not looking for someone to do my work for me, just point me to where I can get this data efficiently and if you recommend tools for doing this sort of thing better than Excel or SQL Server then hook me up :)

|State|FederalRole|Name|Party|Represented Population|Population<18|Population>18|Total Votes|Voted For|Voted Against|#Registered Democrat|#RegisteredRepublican|#Registered Other |:-|:-|:-| |Arkansas|District 1|Rick Crawford|Republican|722,402|||201,245|138,757|62,488||| |Arkansas|District 2|French Hill|Republican|761,348|||253,453|132,125|121,328||| |Arkansas|District 3|Steve Womack|Republican|782,717|||229,708|148,717|80,991||| |Arkansas|District 4|Bruce Westerman|Republican|711,737|||204,892|136,740|68,152||| |Arkansas|Senator 1|Tom Cotton|Republican|3,026,412|705,718|2,272,226|847,505|478,819|368,686||| |Arkansas|Senator 2|John Boozman|Republican|3,026,412|705,718|2,272,226|1,107,522|661,984|445,538||| |Arkansas|US President|Donald Trump|Republican|3,026,412|705,718|2,272,226|1,130,635|684,872|445,763|||

https://factfinder.census.gov/faces/tableservices/jsf/pages/productview.xhtml?src=bkmk https://en.wikipedia.org/wiki/Arkansas https://en.wikipedia.org/wiki/Arkansas%27s_congressional_districts https://en.wikipedia.org/wiki/Arkansas%27s_1st_congressional_district https://en.wikipedia.org/wiki/Arkansas%27s_2nd_congressional_district https://en.wikipedia.org/wiki/Arkansas%27s_3rd_congressional_district https://en.wikipedia.org/wiki/Arkansas%27s_4th_congressional_district https://en.wikipedia.org/wiki/List_of_United_States_senators_from_Arkansas

/r/datasets Thread
Previous
Next

More Random Comments

Warren Buffett gives away another $4.1 billion, resigns as trustee at Gates Foundation John Robson: Racial segregation in schools is apparently now cool AITA for calling my best friend a bitch because of the behaviour in the recent time? Need help, please! I don't know what my options are. I'm currently self-employed with no health insurance and I'm living in a different city every few months. A Good Faith Conversation Possible transfer to Atiesh? What path is there towards addressing aspects of electoral reform? I think this is hypocritical. Weekly Community Post - Post your Communities, Discord servers, and Western Marches games here! Daily Discussion, June 23, 2021 No more masks for vaccinated folks! I want to watch the Marvel movies, what should I start with? HAHAHAHAHAHAHAHHAH!!! SQN, evasores de ban não passarão! Need help with best but card pitches Should I consider answering 'no' to the disability question on apps?