Thank you for your Original Content, /u/BeastCheng!Here is some important information about this post:
Not satisfied with this visual? Think you can do better? Remix this visual with the data in the citation, or read the !Sidebar summon below.
OC-Bot v2.3.0(RB1) | Fork with my code | How I Work
Source: my own data. Every time i fill gas i take the receipt to keep track of amount paid, price/L, date, as well as km driven since last fill.
Tool: Microsoft Excel
Note:- I included the vertical lines to show the frequency of my gas runs.
This is the price per liter of 91 octane, in Ontario Canada. There are a few refuels from my trip from Ontario to Massachusetts, these data points are converted from usd/gallon back to cad/liter
Gas prices differ from station to station, within a gas company, at any given time
I started with Petro-Canada, switched to Shell late September 2018. Massachusetts trip I refueled at Sunoco (X2) and Mobil (X1)
If anyone wants to link the hikes and drops to world events, feel free!
Expand More Comments
Thank you for your Original Content, /u/pup2000!Here is some important information about this post:
Source/tools: I log all my spending in Google Sheets. I like how portable is and I can quickly access the sheet from any browser or my phone. I exported it to an Excel doc. I created a pivot table and played around with it to see my spending over time for the year. I have data now for 19 months (how long I've been budgeting) so thinking of doing something bigger to see more long-term trends.
I love taking my in real life data and putting it into charts because I can see more perspective. I can definitely get away with spending more/not worrying so much about coffeeshop spending, home, and gifts. They make up SUCH a small percentage, overall, it isn't worth agonizing over like I tend to do.
Imagine being sent to a largely unknown land on the complete other side of the world for unlawfully chopping down a tree
I’d like to believe an 11 year old Madagascan was given a life sentence for illegally chopping a tree. And was sent on his own ship to make sure he didn’t try to escape
“Intent of robbery” also feels like an odd one on the list. What’s worse? Chopping down a tree or thinking about a robbery?
I bet the guy that lied on the stand really regretted his decision. Goes to show, if you're going to lie, lie for a good reason.
It's not really much relevant to "today's" Australia. Much as everyone loves the "Australians are all descended from convicts" trope, the reality is that the number of convicts sent to Australia was small and was totally swamped by free settlers very quickly. By the conclusion of the Gold Rush in particular, the proportion of white Australians who were, or were descended from, convicts was small. Since then there has been wave after wave of immigration (UK, Irish, Greek, Italian, Vietnamese, Chinese, Indian...) and convicts are a historical footnote at best.
I’m definitely an ancestor of the tree chopping one. My friends and I used to go ‘phantom tree chopping’ around town under the cover of darkness when we were high schoolers
I have made this viz in Tableau and the data is found here.
There is an interactive version of the viz found here.
EDIT: It's come to my attention, thank you /u/must_not_forget_pwd that there is a mistake in the picture i submitted. Apparently there was a filter applied in the Tableau web-viewer, without me noticing.
Here is the correct picture, without the Larceny filter.
I hope the 3 involved in 'escape' understood the irony of their situation. Not only did they escape whatever they escaped, they escaped all the way to the other side of the world.
One of my ancestors got done for house breaking. Sentenced to death! Then commuted to transportation for life. Eventually served seven years. Married a Scottish girl who'd been sent to Australia are 17 by her older brother and sister to be a wife, and had 12 kids. Not First Fleeters though.
1800’s, all trees over a certain height were reserved for naval use. Cutting them down for other uses was a crime.
Just so people are aware, larceny is theft without assault. So most people were transported to the far side of the planet for non violent crimes.
They should reintroduce such sentences for tree chopping given climate change and all. Strap 'em to a rocket and send 'em to the moon to start a new colony.
it's kind of incredible that they set all these prisoners out and they somehow didnt kill each other or the brits
47 Princes of Wales were sent to Australia as prisoners? I didn't know the Royal Family were criminals
“creation of Australia” is a misnomer. Terra Nulius has deprived the indigenous population of their rights and the language needs to be reset.
The worst bit about it is that they got off lightly, by the standards of that time, as usually they'd have been hung.
Just goes to show you, death penalty isn't a deterrent if you are desperate enough or the risk of being apprehended is low.
Pretty offensive, Australia was already "created" before the first penal colony there. Have you not heard of the people native to the land?
They already have burglary and robbery but larceny is still top. Not sure what would be larceny that wouldn’t be one of the other two.
Judge to the 24 "Return Transport":
You came back to England after we exiled you? Well... Guess what? We're exiling you to the furthest reaches of this damn world. Try returning now!
Thank you for your Original Content, /u/Surprise_Institoris!Here is some important information about this post:
Source: Megaphone for download figures. This Wikipedia page for the list of languages.
Inspired by this sub I made this to celebrate 100k downloads, and someone on Twitter suggested I post it here. It's nothing fancy, but it was fun to do!
Thank you for your Original Content, /u/Tville88!Here is some important information about this post:
Source: IMDB & Wikipedia
Tools: Tableau Public
Interactive version found here.
Thank you for your Original Content, /u/BradC!Here is some important information about this post:
Source: I took the data from the taplist on the Great American Beer Festival website.
Tool: MicroStrategy Dossier (aka Visual Insight)
Method: I copy/pasted the raw data from the website into an Excel spreadsheet and reformatted it to have brewery and beer names in columns of the same row. Then I looked up the state for each of the breweries. I loaded the data into MSTR and basically used the row count by state as the color.
MSTR map didn't represent District of Columbia, so I added that in paint.
Thank you for your Original Content, /u/PHealthy!Here is some important information about this post:
The US is looking likely to lose its measles elimination status in October.
If anyone likes infectious disease news, check out r/ID_News
We did it boys, we saved an endangered species from the brink of extinction in its natural habitat. Another win.
Put me down as one of the cases in '76. I was terribly sick for a week and lost ten pounds. I was 15. Measles hurt! Any adult who knowingly allows a child to get measles should be charged with abuse.
If only they hadn't tempted Murphy's law by declaring it eliminated before it was actually eliminated...
If you don't vaccinate your kids. you are an unfit parent and the kids should be removed and placed with someone more responsible.
Don't @ me.
I'm a bot, bleep, bloop. Someone has linked to this thread from another place on reddit:
If you follow any of the above links, please respect the rules of reddit and don't vote in the other threads. (Info / Contact)
I'm going to the US in a month. My country is measles free for decades now. Thankfully I'm vaccinated!
This chart should really go back another 100 years. There was a 97% (or higher) reduction in measles fatalities (not cases) BEFORE the vaccine was introduced. This was due to plumbing, nutrition, refrigeration, and quarantine of infected individuals.
The concerning thing about the world as it is, is I could see this date being recut and used to show a spike in cases after the two dose vaccine was introduced. Then used to show vaccines are bad m'kay.
The zoom in on the second chart (max of 1500 vs max of 800k) is pretty misleading. Seems like if you kept the original axis the recent uptick would essentially be not visible.
Note: this is not a endorsement of anti-vax. Just a commitment to calling out misleading charts.
One anti vaxxer claims to know science jesus i can't even talk to her about it. But didn't vote in 2016 because she didn't have enough information.
Let me preface this by saying I’m not against vaccines.
Serious question: If vaccines work, why are people that are vaccinated worried about getting measles?
If people get sick from measles, does that make them walking proof that the particular vaccine doesn’t work?
Is there something I’m missing?
Thanks in advance for your intellectual responses :)
Would you be willing to explain how to highlighted one of the areas on the top plot in R? I’ve never seen that done before
Interesting how it seems to alternate years. One year it's low, so people forget about it, then the next year everyone gets infected?
Whats fascinating, and unseen, in this chart is that the population nearly doubled in that same time frame.
Interesting. It still barely registers which makes it appear like anti anti vax movements are being quite effective. The media coverage regarding anti vax would make you think it's a movement gaining substantial traction.
I see Darwinism is working...
PS. Please USA get your shit together, you should be the beacon of the western world.
The only thing I have to say is that the aesthetic negative space below the x axis makes me feel like number of measles cases has room to be a negative value. Not exactly beautiful but poignant data.
Be careful with this data and your attempts to mock anti-vaxers. The second graph doesn't even break 1500 cases, but is displayed in a way to create fearmongering (which is odd because the OP blames media for propagating these while also doing the same thing).
The amount of people that are anti-vaxers is almost non-existent, so please don't get your panties in a knot after looking at this data which is fearmongering.
The % of cases in 2019 is roughly .0003643% of the population.The % of cases in 2000 is roughly .0000354% of the population.
The goal is 0 obviously, but based off the growth of the US, assuming that when the measles was declared eliminated and the rate of growth in the US, if these anti-vaxers continued to breed (insert anti-vaxer kids dying early meme/joke here) the % of population in 2019 would be roughly 1.62%.
This obviously has no support for this number, but, it's a number to be shown based off peoples reactions that anti-vaxers exist in droves and that they have been increasing since lets say measles was declared eliminated when in fact the numbers in general are already basically non-existent, but would actually be higher if this was the case.
The nasty combination of letting everyone into your country unchecked and a bunch of huns who think they’re smarter than doctors.
Does anyone know how many of these measles cases resulted in death? Statistically, it should be 1-2 per 1000 but I don't know where to look for raw data. Conversely, it would also be interesting to see the amount of reported injuries caused by the measles vaccine.
Let anti-vaxxers do what they want, if they’re not informed enough to realise that vaccines are saving lives, they shouldn’t have raised children. I feel bad for the kids but they’re the makings of their parents, presumably will be fucking idiots too.
Survival of the fittest... or smartest.
I think the important takeaway from this (that I haven't seen raised so far) is that people who reject the vaccine now have not a shred of an idea just how bad it used to be.
Measles is up hundreds of times from the lowest point theyve seen in their lifetime but its an irrelevant fraction of how many cases there used to be. A measles epedemic today is nothing compared to what it used to be and people who underestimate the disease because of this do so because they weren't alive or old enough to remember when the vaccine was basically a miracle.
That double peak where Battle of Bastards and Winds of Winter were. The thing is, those two episodes were only supposed to be the buildup for the true conflict coming in seasons seven and eight. If you'd told me then that that was the high point of the show, I wouldn't have believed it.
It's just a shame.
Arguably one of the best television series ever produced and they let it all crumble because the writers got bored.
I feel so bad for all the crew, actors and actresses whose work will forever be overshadowed by how fucking terrible that final season was.
S7 was almost as bad tho and yet reviews were good, which continues to confuse me especially in retrospect now that everyone knows D&D are shit.
Season 7 and most of S6 are rated far higher than they deserve.
They are very similar to the final season in terms of their problems. People just weren't willing to start hating it yet.
D&D were great when they were adapting a written story, but they were atrocious once they lost that direction.
Tool: Tableau Public
To be fair, it didn't deserve such a high rating at season 7. People argue that 5 and 6 wasn't great either, but season 7 was just as shit as season 8.
There really needs to be an in-depth post mortem on season 8 so we can find out what the hell happened.
Season 6 and 7 were pretty abysmal as well and no one wanted to believe it yet. That's a hill I don't mind dying on.
It's technically data, but it very low quality. imdb voters can be very fanboyish and toxic, I remember when they mass voted The Godfather rating 1 so The Dark Knight would take the number one spot.
The reason ratings increased in s6/s7 was because of anticipation of something epic happening in last season. Otherwise you can see it jumped shark after s4 when the book material finished.
It’s 3 Months back and I still can’t get over it, how can HBO even let this happen?!No one can tell me that it wasn’t obvious that it is garbage from the scripts. They totally murdered it I’m so sad.
Interesting that episode 4 is where the ratings really plunge, since for me episode 3 is where the show got lost beyond repair
RATINGS in TV implies number of viewers doesn't it? I know it's technically wrong but it's an established jargon. Should have called it REVIEWS imo
Not really ratings... more like reviews. TV ratings are a measurement of how many watch a show. In that case, Season 8 had probably the highest.
Does anyone else hate seeing that low dip in season 5 too? It was a slower season but I loved it. All that backlash over the sansa rape scene too. The episode wasn't shit, it was a shit situation. Of all the shit that happened in GOT that's what was over the line?
I deleted the last season and am trying to pretent it never exsisted. Amazing how 1 bad season can ruin your motivation to watch it all again for like the 10th time. Cunts
I don't really understand why season 7 gets a pass. The decisions characters make, and the way the plot moves, makes even less sense than season 8. The entire "kidnap a zombie to convince Cersei to join us" idea is completely insane on multiple levels, all obvious from the start and several proven out by the way it plays out.
The only way season 8 is significantly worse is that there's no hope of everything getting rescued by a later season. I guess season 7 didn't have any single episode as bad as the battle of Winterfell, but still, it was bad. All the main mistakes of season 8 - inexplicable character motivation, rushed plot development, absurd plot armor for key characters... it's all on display in season 7 as well.
Do yourselves a favour. If you were disappointed in how Game of Thrones ended, pick up Attack on Titan for an example of how a series can be properly built up to a satisfying payoff. Even if you don't like anime, you can enjoy it. Trust me.
Wow the background picture is perfect. A perfect metaphor for the series; Charging as fast as possible towards disaster.
Ah, yes, these totally not brigaded ratings from season 8.
I still remember episode 4 getting 1s before it even aired.
I'm not saying anything about the season itself, but only that IMDb ratings are worthless.
I was one of the people who watched GOT but never went on forums or discussed it, it was something I just did on my own...I was more of a casual watcher and I only really got into it around 2018, so I was never really invested like the rest of the fandom.
I stopped watching after Arya Kills the night king Biggest load of nothing ever. Hyped up to infinity only To be killed like he was nothing I was expected some huge boss fight but NOOOOOOO....That was where I knew the series wasn't going to recover, so I stopped watching it from there. I still Have yet to watch past that and tbh I never will. I'm looking forward to DUNE in 2020 not to be messed up I hope...
I have seen all seasons except last one. I read so many negative reviews for the last season.
Was it that bad? Or should I watch it?
I'm surprised as to how season 7 got such high ratings. It's not season 8 bad, but it was without a doubt the weakest among the first 7 seasons.
Bottom of scale isn't zero, making the drop look larger than it actually is. Don't get me wrong, it's a huge drop, but...like...come on man, that's how to be disingenuous with graphs 101.
I only watched to season 4 and got bored, I actually just went to my local library to pick up the first book, I think reading the story will give me a better experience.
The ratings for season 7 and 5 and to a lesser extent 6 are way too high.
'Beyond the Wall' was an absolutely horrific episode, the worst of the entire series. The Winterfell plot in season 7 was an absolute disaster in basically every way. The season as a whole completely destroyed Tyrion's character. The plan to catch a Wight was one of the most idiotic and contrived things I've ever seen in a TV drama.
Season 5 completely screwed up the Stannis arc and everyone agrees Dorne was a disaster.
As for season 6, 'No-one' is probably the second worst episode of the entire show, BotB was great spectacle but written really badly, the last episode was highly entertaining and cathartic but also very cotrived, and Jon's death and resurrection turned out to be a complete waste of time. The three seasons had their strengths, some more than others, but they were all highly flawed. The writing didn't really get any worse in season 8, so I still find it odd it got such a disproportionate amount of hate. It's almost like all the criticisms building up since season 5 were just bottled up until things got too much and it exploded in season 8, but the shit was a long time coming.
I can't help but imagine the ratings for every episode for Season 8 got bombed hard after the last 3 episodes. The reception for the first two episodes were warm
I felt like the whole show lost its magic around season three when GRRM stopped helping them write it. It went from absolutely epic to just normal good TV... that is until the last season.
I’ve never seen this show before, and I planned on binge watching it after the series was over. Now after hearing how terrible the last season was, I don’t think I’m going to bother watching it anymore.
I won't disagree that season 8 was shit. However IMDB ratings are not to be trusted imo. The highest rated episode of Breaking Bad is the final episode, in which Walter White creates a trap so an automatic rifle on a spring pops out of the trunk of a car and miraculously shoots every member of a meth-dealing biker gang dead. That's what IMDB users think is good television.
The GOT ending wasn't that bad, change my mind.
S7 is way too high in my opinion. It is still better than S8 but not as good as S5-S6 let alone S1-S4.
They had to miss out on a ton of money with that last season.
I bought merchandise, clothing, rewatched the season multiple times....now I’m embarrassed to display the stuff I bought and have no interest in watching the show ever again.
Reminds me of Mass Effect 3. What a waste.
It’s weird how ratings were so high for seasons 6 and 7. They were about as bad as season 8. Recency bias I guess.
Boooo! Bad graph, boo!
I get it and agree, the last season killed the series, but I hate graphs like this (4 to 10 instead of 0 to 10).
No one cares what a bunch of toxic brigading whiny shits did to the IMDB rating.
This chart is a great example of how the existence of data speaks nothing to its quality or usefulness.
I’ll be the first to admit the final season could’ve been better but I do still think people were too harsh on it.
I think people are a little too harsh on episode 3. First of all it was epic, the music was grand, and we got a dope dragon fight but people were raging that not everyone and their mother was dead.... we all knew there were 3 episodes left and it would’ve been kinda bleh if most people you cared about died then... there would’ve been much less suspense
I'd be shit at writing it myself but if I had to....so basically Cersei and Qyburn make a zombie army out of the remaining people in the city, using what they learned on how to make the mountain turn undead and the undead capture, but the zombie army is not controllable and turns on Cersei, killing and turning the remaining humans in the city. The North army finally gets to kings landing to see it already seemingly dead, bit of horror-like style for the rest of the show just how it began (the good parts of GOT), tons of gore and fucked up shit. The wind picks up and the snow comes, almost forever dark, just like Bran saw it in his vision. Everyone is shitting their pants to another zombie army, the mountain tries protecting Cersei and seemingly dies, Cersei hides in some secret hole, then the rest of the humans and remaining dragons nuke the shit out of kings landing with the other dragon dying to the zombies, except for the big guy that sacrifices himself to save Danny and gets killed by the now undead dragon. Danny fights alongside with her heros in an attempt to help blow up the spire (where the iron throne is) which is filled with undead. The hound comes across his brother while fighting and the hound defeats the mountain (by lighting him on fire), but dies from the wounds he gets from the fight. Cersei is found by king slayer and Brienne, Cersei is undead, kingslayer has a tough time killing his sister, trying to ask her to come back he knows she's in there blah, blah, blah, they fight and king slayer dies to Cersei protecting Brienne, Brienne kills zombie Cersei, has to burn the body of king slayer. Zombie dragon almost kills everyone, but then Bronn saves them all by fixing the wildfire to one of those stupid OP giant spear-flinging devices. Bronn gets his earned title as a hero finally. Bran discovers a way to destroy the army using his new powers to "sort of" control them he learned how by almost dying to a undead but making the undead un-see him. They just walk off like their attention went to wherever Bran forced their mind to. Bran now needs a wide view over the city to save everyone. Bran is helped by Arya to get to the spire and Arya fights off Danny and her heros (besides john snow) that would rather blow up the spire. Bran has to crawl his way to a spot where he can see the whole city, Tyrion kinda comes out of nowhere and helps him to it, knowing what must be done. Danny's heros all die including melessandre and grey worm who die holding eachother, Danny is left alone, fighting undead, John Snow saves her and gets her the fuck out. Once again, everyone is surrounded and dying, desperately fighting off the undead and trying to keep them inside the city walls. Bran and Tyrion finally reach the top, Bran uses his power to force the undead to chill the fuck out and slowly walk into the ocean. The sun comes out, everyone is tired as shit. Danny and John rule equally together with a big counsel of people to help rebuild the world. Bran goes to his tree in winterfell and the tree infuses with him, just like the other three-eyed raven. Arya is a fucking ninja assassin with really bad PTSD so she goes into hiding. Sansa is the queen of the North, she just hangs out with Bran now. The northerners are granted full access across the wilderness and rule the upper part of the North. Castle Black is destroyed when the ice wall melts from the sun coming out finally. Samwell starts to write the story and history of all that played out, calling it "A Song of Ice and Fire" The End
Honestly I can't believe people were surprised that it went downhill like this. You could tell as early as season 5 the writing was going to shit.
HBO execs must be idiots. GoT is the main reason I ever subscribed. Now? I've heard such bad things about the last season I don't want to watch it. And I suspect HBO will do the same crap to other shows in the future. So I no longer even consider subscribing.
Word of mouth dies too. My gf had never seen any GoT. I wanted to binge it with her. But now? Forget I mentioned it.
I'm sure we'll all soon here about HBOs bottom line tanking.
I believe people are more prone to giving bad reviews when something they don’t want to end is ending.
That said the last 2 seasons were definitely weak, probably because there was less source material and the show was written to appeal to a broader audience. Tragic really
To be honest I'm surprised season 7 is rated so highly. I first started to think the quality was dropping in season 6, even though it had good moments.
What were the viewer ratings for the last season? I find it interesting that IMDB became the barometer for collective consensus for TV Shows. How did that happen over sites like MetaCritic?
I made this plot a few months ago. The highest rated episode of season 8 rats lower than the lowest rated episode of the remaining seasons.
I wonder why Season 8 started so low?
You couldn't go 5 minutes without seeing an ad or people talking excitedly about what was to come
Season 7 was the real shit show. 8 wasn’t great but not nearly as bad as 7. Pacing was way rushed in 7 to cue up 8. Not saying 8 was great however.
DON’T REMIND ME!
Although I do think time will be kinder to the series. If someone binges it in like 4 years they probably won’t hate it as much
Can we overlay this post with "US Viewers per episode"?
I'm somewhat surprised ratings fell so hard. I hated just about everything about that last season (and much of season 7) but still had to watch the train wreck and at 6 episodes I would have imagined others would have done the same. Even more so the 1st 2 episodes of season 8 were at least interesting and created some build up for...well, you know.
I wonder what the breakdown between those that didn't watch vs those that didn't even bother to resubscribe to HBO because of the rumors.
The only improvement I would make is by showing the silhouetted horseman charging over a sheer cliff.
Thank you for your Original Content, /u/SmirkyGraphs!Here is some important information about this post:
OC-Bot v2.2.3 | Fork with my code | How I Work
Finally got around to adding senate votes and changed some things based on feedback.
This includes everything from votes during "Roll Call" to votes on amendments for bills but only floor votes, so votes during committee assignments are not included. There are 3 types of votes Yes, No and NV (No Vote). The image only looks at 2019 but the interactive version linked below goes back to 2016 for the senate and 2003 for the house.
There is a straight diagonal line of 100% same votes, this is when it shows how often the person votes with themselves. The interactive version has a hover over tool tip that will show both names, party, the number of times they voted the same way and the percentage. sample tooltip image
data gathering: Python
data prep/cleaning: Python
Interactive Version: my site
Interactive Version: tableau's site
Source: RI Senate Floor Votes
updates from feedback:
Thank you for your Original Content, /u/nkxdata!Here is some important information about this post:
Source: Google Sheets, National Sleep Foundation
Tool: Google Sheets, Python, Tableau
Link to Interactive Viz - Non-mobile friendly
I was inspired by this post on this subreddit and decided to record what I've been doing (sleeping, watch movies, studying etc) since the start of the year with a 1-hour interval on Google Sheets. I often slept after 4 AM during the semester (16 weeks) and didn't really try to fix it.
I used Python to transpose and write the values to a new sheet to be used in Tableau.
Feedback and criticism is greatly appreciated :)
I don't really understand the two charts on the right. Do they indicate the number of times you went to sleep after 4am? Or the number of hours of sleep after 4am?
Also, I'd adjust the y-axis label on the first chart to indicate those numbers are hours. At first I thought that thumbtack icon was a percentage symbol.
Made with Love in New York City, New Jersey & Monterrey, Mexico.