Ran this through Google’s Big Query on the two largest political subreddits on reddit.com. The two queries were
SELECT domain,count(*) as Count FROM [fh-bigquery:reddit_posts.2017_01] WHERE subreddit = "politics" GROUP BY domain ORDER BY Count DESC
SELECT domain,count(*) as Count FROM [fh-bigquery:reddit_posts.2017_01] WHERE subreddit = "The_Donald" GROUP BY domain ORDER BY Count DESC
Make your own conclusions, but the results are pretty telling for the diversity of posts and their content.
Beautiful drive up, next time I want to take my bicycle. I have a couple more photos I plan on posting as well. They turned out pretty great (in my opinion).
This was taken on my trip down to Arizona this winter. My family and I drove up and watched the climate change over just a few miles. The saguaro disappeared and were replaced by long grasses, and eventually pine trees.
Below is the code I used to create the CSV file which was read into Tableau. One could also use ggplot to graph the data.
This was taken on a bicycle trip Sara and I took from Minneapolis to Duluth (and back) over the course of five days starting August 19th. We saw some great sites, got some great photos, and most importantly saw a giant rubber duck.
This is a neat little call I whipped up that returns the two x and y points from a list which have the shortest distance. It also returns the distance between those two points.
Pretty weird solution right? Seems to work though!
Farmer’s Market Popcorn and Bike Rides
This is the data which resulted from scraping the top 1,000 “hot” posts from various subreddits. As you can see, the_donald posts originate heavily from new accounts. You could explain the discrepancy as “political season”, but SandersForPresident doesn’t seem to have that issue. Reddit was predominately left beforehand, but then you have to wonder why people are starting to gravitate toward reddit for their pro-trump discussions.
Seems like something is up. An explanation given by a pro-trump person was “conservatives get banned”, but they sure don’t get banned from the_donald, and it is against policy to create new accounts to access subreddits you have been banned from. Heck, when the_donald banned me they explicitly stated that. Anyhow, enjoy.
Whipped this up based on the 2011-2013 ODOT data because someone was complaining about cyclists not paying the gas tax where they lived (Portland). Whelp, taking into account the damage (1/9,600 the damage of a car, and roads cost a pretty penny to repair) and that many cyclists have cars if not at least a license, (89%) it is clear that cyclists subsidize motorists. Oh yeah, pollution. It is 2016, can we stop hating cyclists?