The Trek BBS

The Trek BBS (http://www.trekbbs.com/index.php)
-   General Trek Discussion (http://www.trekbbs.com/forumdisplay.php?f=44)
-   -   I made a list of all episodes sorted by air date (http://www.trekbbs.com/showthread.php?t=139946)

busfahrer April 6 2011 05:24 PM

I made a list of all episodes sorted by air date
 
Hi!

I'm new here, so I hope this is the right place for this:

I only recently began watching Star Trek, and since I want to watch the episodes in the right order (seeing as there is a lot of overlap during TNG/DS9/Voyager), I looked for a list like this, but couldn't find one, so I made one myself :)

A list of all the Star Trek episodes, ordered by their original air date:
http://startreklist.blogspot.com/
(The page also contains a list of episodes ordered by star date, if known. Interestingly enough (if you disregard Enterprise for a moment), the episode with the oldest star date is an episode from the animated series)

I hope you guys will find this useful as well! Comments and suggestions are appreciated, of course!

Greetings,
busfahrer

edit: speeling

Rom's Sehlat April 6 2011 10:43 PM

Re: I made a list of all episodes sorted by air date
 
Thank you! I admire good Excel work!

It appears the stardate system received an overhaul just like the warp scale did.

busfahrer April 6 2011 10:57 PM

Re: I made a list of all episodes sorted by air date
 
Quote:

Rom's Sehlat wrote: (Post 4867379)
Thank you! I admire good Excel work!

My pleasure! However, Excel was not involved. I took the respective episode lists on Wikipedia and hit them with various Linux command line tools until they agreed to voluntarily settle into a MySQL database. From there I could generate the HTML markup for the page :)

Quote:

Rom's Sehlat wrote: (Post 4867379)
It appears the stardate system received an overhaul just like the warp scale did.

Did I get the star dates wrong? As I mentioned in my first post, I'm quite new to Star Trek :)

Chang April 7 2011 02:38 AM

Re: I made a list of all episodes sorted by air date
 
The stardates look correct

KirkPicard April 7 2011 09:23 AM

Re: I made a list of all episodes sorted by air date
 
I would just add that the Star Trek '09 movie occurs on Stardate 2258.42 also all the Trek movies stated their respective Stardates I believe.

Forbin April 7 2011 01:05 PM

Re: I made a list of all episodes sorted by air date
 
An amazing feat!

Rom's Sehlat April 7 2011 06:25 PM

Re: I made a list of all episodes sorted by air date
 
Quote:

busfahrer wrote: (Post 4867419)
Quote:

Rom's Sehlat wrote: (Post 4867379)
Thank you! I admire good Excel work!

My pleasure! However, Excel was not involved. I took the respective episode lists on Wikipedia and hit them with various Linux command line tools until they agreed to voluntarily settle into a MySQL database. From there I could generate the HTML markup for the page :)

Quote:

Rom's Sehlat wrote: (Post 4867379)
It appears the stardate system received an overhaul just like the warp scale did.

Did I get the star dates wrong? As I mentioned in my first post, I'm quite new to Star Trek :)

As Chang said, they look correct. I have no reason to doubt you. But somehow the writers of the shows changed their timeline scale or something.

So you did all that in Linux and MySQL? Wow. I can't even do that stuff in Excel, let alone real programming tools!

Tiberius April 9 2011 12:16 PM

Re: I made a list of all episodes sorted by air date
 
I've been looking for something much like this! A list of all the episodes and movies in watching order.

If you don't mind, I'd like to take this list and do a little bit of rearanging, such as:
  • Putting Enterprise first.
  • Putting the Classic trek episodes in production order (as that's the way they were made, and some episodes were held for quite a while before they were aired.)
  • Where possible, putting all parts of multi-part episodes together (to make it easier to follow the story...

Do you mind if I post the finished list in this thread?

Forbin April 9 2011 03:42 PM

Re: I made a list of all episodes sorted by air date
 
Nobody should ever put Enterprise first.
;)

Arpy April 10 2011 10:32 PM

Re: I made a list of all episodes sorted by air date
 
This, in my opinion, is how one should watch Star Trek to get the most out of it.

I love you.

RyuRoots April 11 2011 09:33 AM

Re: I made a list of all episodes sorted by air date
 
Quote:

Forbin wrote: (Post 4874031)
Nobody should ever put Enterprise first.
;)

:lol: :bolian:

For a wide variety of reasons, indeed.

Tiberius April 11 2011 10:01 AM

Re: I made a list of all episodes sorted by air date
 
I like Star trek as a whole. I don't like to say one series is better than another one...

HGN2001 February 9 2013 11:23 PM

Re: I made a list of all episodes sorted by air date
 
Quote:

Arpy wrote: (Post 4876391)
This, in my opinion, is how one should watch Star Trek to get the most out of it.

I love you.

I admire the effort and applaud the list. However, having lived through it, and seeing all of STAR TREK in that order, I have to say that I'm not sold that it is the best way.

The reason is because of how it diminishes DEEP SPACE NINE. That series had exactly half a season - 12 episodes - all by itself, with no other Treks around it concurrently. TOS, TAS, TNG, ENT all had many seasons all by themselves, and VOY had at least two years of being the only Trek in the universe.

(I know that movies interspersed some of these, but those were more singular special events.)

DEEP SPACE NINE never really got a chance to fly on its own, and my memories of watching the shows in those weeks when there were two Treks going, always seemed to diminish the power of DEEP SPACE NINE. I found it a bit of a chore to be forced to watch two episodes in the same week during my busy time working and living life. But I did it - and videotaped every last episode.

It wasn't until years later, when DVDs made it possible to really watch these series again and again that I began to really appreciate how good DEEP SPACE NINE was. Its arcing story lines were no longer interrupted by visits to the Enterprise or Voyager. It stood on its own - and stood very well I might add.

Now, it's also true that DVDs can give a dedicated viewer lots of chances to schedule things any way at all. And if someone wants to watch Trek in its airing order, but compressed into several viewings every evening, then a different perspective could be gathered.

But while I've never tried the compressed, in-order approach, I still recommend letting each series stand on its own. I appreciate the work compiling a list like this, and see it as a valuable reference.

Harry

CoveTom February 9 2013 11:39 PM

Re: I made a list of all episodes sorted by air date
 
An excellent piece of work!

One caveat: The air dates for TNG and DS9 are somewhat less than exact. The reason is because those two shows aired in syndication, rather than on a network. Therefore, while they were transmitted out to the stations on the same day and time each week, it was up to each individual station to decide the day and time during the week they would air them. One station might schedule TNG on Thursdays at 8 pm, while another might schedule it for Saturdays at 2 am.

Therefore, the dates listed for TNG and DS9 are really an "aired the week of" date than a specific air date.

ZapBrannigan February 10 2013 03:39 AM

Re: I made a list of all episodes sorted by air date
 
Quote:

busfahrer wrote: (Post 4866601)
I hope you guys will find this useful as well!

That's a useful overview of STAR TREK history, all in a nutshell. Thanks. :techman:


All times are GMT +1. The time now is 01:52 PM.

Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
FireFox 2+ or Internet Explorer 7+ highly recommended.