[removed]

Source IMDB.com. Visualization prepared with Excel.

I hope this data is sufficiently beautiful for this sub! There is both complaining and gushing over so-called "Nu-Trek", so I wanted an easy comparison.

The problem with “Nu-Trek” is that they don’t periodically have some of the weirdest episodes of television I’ve ever seen. There needs to be an episode every season or so that just leaves you baffled as to how it ever made it on screen.

TIL Code of Honor is not actually the worst rated episode of TNG after all. (It's the second worst)

A little apples to oranges to compare pre- and post- Disco since the format is changed.

DSC - SNW is 194 episodes and only 125 live action. That’s comparable to Enterprise by itself.

What can we learn from this?

I've been watching Enterprise lately and I think it's slightly underrated

DS9 has some strong numbers.

Glad to see that it was always my favorite.

Eh, it has some good parts particularly in the last season, but it's deservedly bottom tier with Picard and Voyager (and maybe TOS....)

It has some pretty awful episodes early on but it gets exceedingly good at the end. In my personal opinion that last season is some of the best Star Trek ever made. Luckily it's subjective so we don't have to agree lol.

Not everyone knows the TLAs on the top row.

I guess I just like Star Trek in general

Gotta be the ghost sex episode, right?

Fair enough. I like the last season and wish there was another, it felt like it was really on the upswing. Shran as a regular? Yes please.

The xindi arc had its moments but overall just a worse Dominion.

My most recent rewatch takeaway was that T’Pol really carried the first seasons despite the insistence on her eye candy. Then the writers screw up her character and side line her at the end.

It's probably Shades of Grey, because modern audiences.

Even though that's not even the worst episode to bookend season 2.

[removed]

It's a good thing, I know what s TLA is:-)

TOS: The Original Series TNG: The Next Generation DS9: Deep Space 9 VOY: Voyager ENT: Enterprise DSC: Discovery (you'll also see DIS) Short: Short Treks PIC: Picard LD: Lower Decks PRO: Prodigy SNW: Strange New Worlds

Now you are ready for r/startrek!

The lowest is “Shades of Grey” the clip show that ends season 2. Which is kinda fair, but also kinda feels like cheating. Obviously it’s a bad and lazy episode, but it’s not aggressively offensive in the way Code of Honor is.

Maybe this is naïve, but a soft takeaway for me is that this kind of critical analysis (IMDB, not OP) is inarguably impacted by the timeliness of the rating, and so I suspect that the scores would like different if TOS, TNG et al had been reviewed by a contemporary IMDB.

Should include mean and median ratings for each series as well.

The fact that TNG has the best AND worst eppisode should scream for some statistical average information

Thanks for the full names.

You're correct! Somehow Sub Rosa still has a 4.8 rating which I find extremely generous.

Also, lol. I can't believe season 2 started with Troi getting surprise pregnant from an alien and ended with a clip show.

Discovery statistically the worst trek series? sounds right

Also what episode of picard got a 9.4!?

I think it depends on how much you think Sub-Rosa is aware it's cheesy camp and how much you like that sort of thing.

Whereas even in '87 a stranger impregnating you in your sleep is very rape-y even with the sci-fi premise; then raising the rapist, Troi essentially abandoned to her new motherhood, Riker irritated he isn't the father/rapist ... the "It's a badly adapted phase II script" really shows.

[removed]

There was a writers strike then which was why a clip show occurred.

Have you gotten to season 3? Personally, I found it terrible, which really brought down an otherwise adequate average up until then... Also the series finalé is an atrocity.

Have you seen the fantasy storybook episode of Strange New Worlds?

The latest episode is at 9.3 so presumably that one when this was looked up. It will probably come down a bit but this season has been good. I don’t know if they’ll stick the landing though.

This is a spreadsheet not a visualization. Let alone a beautiful one. What happened to this sub? Tableau Public might be my last resort.

I watched all of TOS a couple of years ago. The very good and great episodes completely make up for it. But most of the episodes are bad or terrible. And it's amazing how many times you could recycle a plot back when you could only watch a show when it aired once a week. Kirk must have talked a dozen AIs into self destructing by introducing them to the concept of a logical paradox.

They were also hoping for an influx of new viewers (I forget what the cause for optimism was), and they wanted to catch people up on the series. And a clip show was the only way to do that in the pre-streaming era! (I think this was just barely in the VCR era, but you had to be a pretty hardcore fan to tape every episode)

I actually haven’t gotten to SNW yet

The first two seasons of Picard are a hot mess, but the third season has been terrific. I went in expecting a bunch of empty fan service, but they really delve into the TNG characters and how they've changed over time, and interrogate their relationship to Picard. And that's all balanced with some great action and mystery.

Not everyone sees that as a bad thing!

I think it's fair to say the more recent shows have a higher bar to clear in the Golden Age of Television than the 90s-era shows did when they were essentially the only sci-fi on TV apart from X-Files.

Well you'll definitely get your "WTF?"s when you get there.

There is still another episode next week.

[removed]

I’m glad you’re enjoying it (most people seem to be!). I don’t totally agree on S3 but 🤷🏻‍♂️.

I like Patrick Stewart, I like the TNG cast, but Picard has been easily the worst new series for me, possibly the worst overall if it weren’t for TAS lol.

Grids are listed as a visualization in MicrosStrategy and PowerBi, and I forget Tableau because I haven't used it since 2021 but you can definitely make grids in there. This is a simple one but you can reproduce pivot tables in grids. I disagree a table is not a visualization, just my opinion. Edit for spelling and to correct a point

I feel like the new episodes of Picard are getting skewed ratings just because this season is a lot better than the last two seasons. It's pretty good but I don't really think it's as good as the best episodes of Deep Space 9.

I am working on a matrix right now for my job. I consider tables to count as visualizations, personally. They are even listed as such in both Microstrategy and PowerBi. I haven't used Tableau for a whole but you can make grids in there too. I think it is subjective, but this counts for me.

When you do you will see it there.

I agree the first two seasons were a huge waste of Patrick Stewart's talents. But they really righted the ship with the third and he has some terrific acting moments. (And Frakes really shines as both an actor and director)

For me it's the plotting (I haven't watched today's episode) -

• Picard has a secret child that he never knew about, with his best friend, who also has special john wick powers
• Bringing back the Dominion is great, except these are like, renegade super changelings that behave totally differently to the Founders we've already met. Also they've infiltrated the highest levels of the Federation, just like S1 Zhat Vash.
• Hinging last week's episode on Ro Laren. It's great seeing Michelle Forbes again, but there's a lot of presumed emotional resonance for a character we haven't seen in 30 years.

It feels like *Nemesis-*level plotting.

Over correcting from how badly S2 ended

TOS is more of a great cultural artifact than a "good" TV show.

The movies hold up, at least 2, 3, 4, and 6.

The final season of Picard/TNG is killing it imo. Yeah, it's a nostalgia fest, but I'm eating it up and loving it. I don't care. It's light years better than the final TNG movie, and it will give them a sendoff that's been long overdue.

This data is ugly and I can’t believe that you didn’t even bother to have a row for the average rating for each series. That’s the single most important data point in whatever you’re trying to communicate here.

I also have no idea what your color coding means. And I’m also bothered by how your colored cells lack gridlines while the rest of the chart has them.

This is truly the worst post I’ve seen on this sub in quite some time.

Season 3 opens with a septuagenarian Dr. Beverly Crusher wasting a bunch of aliens with an assault rifle. This season is better than the earlier ones in the same way a smelly fart is better than shitting your pants.

There is another episode of Enterprise next week? What?

>TOS is more of a great cultural artifact than a "good" TV show.

I agree. It's value is mostly in the subsequent material it inspired. But, again, the handful or two of truly great episodes really are all-timers that more than redeem the misses... The many, many misses... Lol

The showrunner this season is the guy who did the 12 Monkeys series, which I quite liked. If opinions I respect stay positive by the end, I'll actually watch it (and give SNW a shot while I'm there).

I wasn't going to. Four seasons of Discovery and Two of Picard and I'm all out of good will toward the thing I used to love.

I know what all the words on the top row mean, but I don’t know what “TLAs” means. You’re a victim of your own observation.

Ds9 was boring af, especially coming off of TNG

Oops wrong comment

How come TNG has two worst rated episodes with different ratings? (I'm not a star trek fan)

I see, interesting to hear season 3 of picard is better, I gave up halfway through season 2 just because it was so bad.

Hey, join us in the newest Trek sub, r/Star_Trek_! q’Pla!

it's a tongue-in-cheek kinda to include TLA (three letter acronym) in it.

I enjoyed that one! It was the kind of silly nonsense I love about ST. Definitely less cringe than some of the bad old-Trek episodes.

[removed]

Well damn I'll have to give S3 of Picard a shot!

Can't wait for S2 of Strange New Worlds!! Dig that #1 😊

I know I’m just another echo on Reddit but SNW is fantastic.

I did enjoy the nostalgia in seasons 1 and 2 of Picard but they really fumbled the conclusions to each season. Which is why I’m not proclaiming season 3 a success until it’s done.

100% this

Seriouslt, it's just Excel and a couple of conditional formatting rules. I make these all the time, never thought of them as beautiful before.

[removed]

Lmfao the top rated Picard episode equals the top rated TNG? That's fucking hysterical. The worst TNG episode is better than the best Picard episode. I'd rather watch Dr. Crusher fuck a ghost for three hours than one minute of fucking Borg Jirarti or android clone Picard.

Enterprise was WAY better than Voyager IMO.

TNG and Voyager and Picard are the best.

The lowest is a flashback episode and as I understand it was only made because of a writer's strike. Since it wasn't planned I guess OP decided to look at the next worst as well.

Really? I feel like DS9 is great as I’m watching it through for the first time. I even enjoyed the first 2 series even though, like TNG, they are not as good as what followed.

My dads a Trekkie and said that things got better in ds9, but I couldn’t get past the first season

Isn’t this a successor sub to the one that got banned for brigading other subreddits and harassing people? Not sure this is one to join

No. It is not. Please stop spreading misinformation.

[deleted]

I mean the last one was called r/star_trek, this one is the same but with another underscore added on the end so you can forgive me for being a little sceptical of that claim.

Yeah you can also create spreadsheets in tableau and all the other tools. Doesn’t make them anything different and definitely not a good or even beautiful viz

That’s fair enough, but I am really enjoying the latter seasons of DS9. I think it is similar to TNG in that the first 2 seasons were not as good, but once they hit their strides they both became really good.

The only characters allowed in the creation of subreddits is letters, numbers, and underscore. So the options are pretty limited, only so many ways to say Star Trek.

I've heard that about SNW. The principle problem is the same with Seasons 2+ of LD: if I don't watch it, it's a nugget of potentially good Star Trek that, if I don't let it prove to me that it's bad, hypothetically might not be.

Honestly, I rather liked season 1 of Picard. It was a little wonky and the bits that weren't were basically Mass Effect with the serial numbers scrubbed off, but sure. (I've been trying to finish this thought about Picard, but I can't find a way to not be extremely unkind if I say anything else, so I'll stop there.)

Star Trek is just... not mine any more. It broke up with me. If Picard season 3 seems good, because I like this show runner theoretically, we'll get together and have a little fling, but that's about as far as I can take it.

It is a lot better so far. I dislike the Raffi scenes (but a certain returning TNG character makes it a bit bearable), but everything else has been pretty great and feels more like old school TNG (not just because of all the returning cast). Strange New Worlds is still easily the best new trek imo.

I guess it depends on what your subjective criteria is. It sounds like the data itself isn't a factor for you. That's cool, but it is an opinion and not a fact

It's the curse of modern TV where everything has to be a slave to the arc. But also modern Trek where the first 85% of the series is them twiddling their thumbs over a season long mystery that they'll then resolve in a rush in the last three episodes.

Shows how bullshit this rating system is if STD gets higher ratings than TNG.

If TOS is bottom tier then what are we even talking about?

Something something recency bias...

Sorry bud, but a crudely coloured spreadsheet is not data viz. Nevermind beautiful data viz. No one even knows what the colours here mean. Less text, more visual, and a legend would all be a good start.

Haven't watched Prodigy, watched Picard through 2.1, and have seen all of the rest. I like Lower Decks best, then TNG, and SNW.

DS9 was my favorite as well.

Though... I'm torn because Picard is better although Picard won't have as many seasons and it doesn't have the multi-season story arc about the dominion war and... It doesn't have Garak! But it is better.

This is the opposite of beautiful.

For me, the data was already interesting. I was surprised by the results.

I was not surprised by the mixed reception on here, but it has motivated me to up my game. I discovered how to download data from IMDB, so I may take a shot at a better visualization.

Thank you everyone for the learning experience.

Season 3 of Picard would change your mind.

I think episode 6 leaned in too much on nostalgia, but the season started OK and just keeps getting better and better.

I felt like Picard got off to an interesting start at the beginning but completely fumbled the rest, and season 2 was not good, though it fleshed out some of his history, which may be of some interest - but the way they did it was weird.

But now I feel like Picard isn't some old dude wandering in to trouble. He feels like elder Picard should. Even Raffi is bearable now, if not one of the better characters.

Why would "non-modern audiences" be more generous with Shades of Grey? I'm 40 (is that non-modern?), and I do consider it pointless and pretty stupid.

That said, the worst is The Game.

Even the recency bias can't save Discovery.

I'm watching it. It's still not good. Everyone saying it's suddenly great has Stockholm syndrome.

​

It's much much better than Picard season 1 & 2, 10x better, but that's like going from a 0.1/10 to a 1/10.

​

There are TNG episodes that are 10/10 and the best Picard episode maybe reaches a 3. MAYBE.

In the pre-youtube/streaming/filesharing era, people were a lot more forgiving of clip shows. Not that they were ever good, but now they get rated as the absolute worst, rather than being average-bad, which is contextually more realistic.

Now you can watch "Ten times Deanna uses her telepathy to deduce the obvious" on youtube, so a clip show is far more redundant than just being a spruced up rerun.

You can like the show or not, that's fine.

But I can say with confidence that your opinion that Shades or Gray is better than any episode of Picard is not something that many people would share.

I didn't care for season 1 and 2, but they had their moments too - and they were all better than the absolute worst of TNG. When your benchmark on a 1-10 scale is 0.1-1, you're being ridiculously hyperbolic.

I sentence you to repeated viewings of Shades of Gray, Sub Rosa, and Code of Honor!

You just don't have "Faith of the heart"

First couple seasons were rough

Nostalgia and recency bias

Season 3 is also when they jazz that up, which makes it actually a bad song on top of being a bad Star Trek theme... 🤮

I hated them back in the day, too. You only get one episode per week, you look forward to it all week, and it's a clip show? That was very disappointing, back then.

This is an underrated comment.

I just recently started watching Enterpise as well, and I totally agree. I cane in with low expectations, but have been pleasantly surprised. As another commenter said, Season 3 was a bit rough but all in all I've enjoyed the series.