RSS iconTwitter iconFacebook icon

The Trek BBS title image

The Trek BBS statistics

Threads: 139,692
Posts: 5,430,980
Members: 24,829
Currently online: 498
Newest member: 713brianp27


Welcome! The Trek BBS is the number one place to chat about Star Trek with like-minded fans. Please login to see our full range of forums as well as the ability to send and receive private messages, track your favourite topics and of course join in the discussions.

If you are a new visitor, join us for free. If you are an existing member please login below. Note: for members who joined under our old messageboard system, please login with your display name not your login name.


Go Back   The Trek BBS > Welcome to the Trek BBS! > General Trek Discussion

General Trek Discussion Trek TV and cinema subjects not related to any specific series or movie.

Reply
 
Thread Tools
Old April 6 2011, 05:24 PM   #1
busfahrer
Cadet
 
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
busfahrer is offline   Reply With Quote
Old April 6 2011, 10:43 PM   #2
Rom's Sehlat
Fleet Captain
 
Rom's Sehlat's Avatar
 
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.
Rom's Sehlat is offline   Reply With Quote
Old April 6 2011, 10:57 PM   #3
busfahrer
Cadet
 
Re: I made a list of all episodes sorted by air date

Rom's Sehlat wrote: View Post
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

Rom's Sehlat wrote: View Post
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
busfahrer is offline   Reply With Quote
Old April 7 2011, 02:38 AM   #4
Chang
Admiral
 
Chang's Avatar
 
Location: Upstate New York
Re: I made a list of all episodes sorted by air date

The stardates look correct
Chang is offline   Reply With Quote
Old April 7 2011, 09:23 AM   #5
KirkPicard
Captain
 
KirkPicard's Avatar
 
Location: Phila. PA
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.
__________________
GARTH: Mister Spock, do you consider Captain Kirk and yourself brothers?
SPOCK: Captain Kirk speaks somewhat figuratively and with undue emotion. However, what he says is logical and I do, in fact, agree with it.
KirkPicard is offline   Reply With Quote
Old April 7 2011, 01:05 PM   #6
Forbin
Admiral
 
Forbin's Avatar
 
Location: I said out, dammit!
Re: I made a list of all episodes sorted by air date

An amazing feat!
Forbin is offline   Reply With Quote
Old April 7 2011, 06:25 PM   #7
Rom's Sehlat
Fleet Captain
 
Rom's Sehlat's Avatar
 
Re: I made a list of all episodes sorted by air date

busfahrer wrote: View Post
Rom's Sehlat wrote: View Post
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

Rom's Sehlat wrote: View Post
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!
Rom's Sehlat is offline   Reply With Quote
Old April 9 2011, 12:16 PM   #8
Tiberius
Commodore
 
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?
Tiberius is offline   Reply With Quote
Old April 9 2011, 03:42 PM   #9
Forbin
Admiral
 
Forbin's Avatar
 
Location: I said out, dammit!
Re: I made a list of all episodes sorted by air date

Nobody should ever put Enterprise first.
Forbin is offline   Reply With Quote
Old April 10 2011, 10:32 PM   #10
Arpy
Rear Admiral
 
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.
Arpy is offline   Reply With Quote
Old April 11 2011, 09:33 AM   #11
RyuRoots
Fleet Captain
 
RyuRoots's Avatar
 
Location: Ul'Dah
View RyuRoots's Twitter Profile Send a message via AIM to RyuRoots
Re: I made a list of all episodes sorted by air date

Forbin wrote: View Post
Nobody should ever put Enterprise first.


For a wide variety of reasons, indeed.
__________________
Star Trek: 1987-Present
RyuRoots is offline   Reply With Quote
Old April 11 2011, 10:01 AM   #12
Tiberius
Commodore
 
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...
Tiberius is offline   Reply With Quote
Old February 9 2013, 11:23 PM   #13
HGN2001
Commander
 
HGN2001's Avatar
 
Location: Sunny Central Florida
Re: I made a list of all episodes sorted by air date

Arpy wrote: View Post
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
HGN2001 is offline   Reply With Quote
Old February 9 2013, 11:39 PM   #14
CoveTom
Rear Admiral
 
Location: CoveTom
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.
CoveTom is offline   Reply With Quote
Old February 10 2013, 03:39 AM   #15
ZapBrannigan
Fleet Captain
 
ZapBrannigan's Avatar
 
Location: New York State
Re: I made a list of all episodes sorted by air date

busfahrer wrote: View Post
I hope you guys will find this useful as well!
That's a useful overview of STAR TREK history, all in a nutshell. Thanks.
ZapBrannigan is offline   Reply With Quote
Reply

Bookmarks

Tags
air date, episode list, star date, star trek, stardate

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump



All times are GMT +1. The time now is 09:19 PM.

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