Updated List of Off World vs Earth Based Episodes

[morjana]

Updated: May 9, 2004 Document Created: February, 2003

MISSION ANALYSIS -- Off World vs Earth Based Episodes


Earth-------Off
Bound-------World

----Season One
5-----------17
----Season Two
5-----------17
----Season Three
5-----------17
----Season Four
6-----------16
----Season Five
6-----------16
----Season Six
7-----------15
----Season Seven
5-----------17


Here are the Off World Episodes:

SEASON ONE

Children of the Gods - Abydos and Chulak
Emancipation - Simarka (P3X-593)
The Broca Divide - "Land of Light" (P3X-797)
The First Commandment - P3X-513
Cold Lazarus - P3X-562
The Nox - P3X-774
Brief Candle - Argos (P3X-8596)
Thor's Hammer - Cimmeria (P3X-974)
The Torment of Tantalus - P3X-972
Bloodlines - Chulak
Fire and Water - Oannes (P3X-866)
Singularity - Hanka (P8X-987)
Cor-ai - Cartago (P3X-1279)
Enigma - Tollan (P3X-7763)
Tin Man - Altair (P3X-989)
There But For the Grace of God - P3R-233/Alternate Earth



SEASON TWO

Prisoners - P3X-775 AND Hadante
The Gamekeeper - P7J-989
Need - P3R-636
Thor's Chariot - Cimmeria (P3X-974)
Family - Chulak
Secrets - Abydos
Bane - BP6-3Q1
The Tok'ra, Part 1 - P34-353J
The Tok'ra, Part 2 - P34-353J
Spirits - PXY-887
Touchstone - Madrona (PX7-941)
The Fifth Race - P3R-272 AND Othala AND P9Q-281
Holiday - P3W-924
Serpent's Song - PB5-926
One False Step - PJ2-445
Show and Tell - Reetalia
Out of Mind - Hathor's Planet



SEASON THREE

Into the Fire - Hathor's Planet and Chulak
Legacy - PY3-948
Learning Curve - Orban
Deadman Switch - PJ6-877
Demons - Unnamed planet
Rules of Engagement - Unnamed planet
Forever In a Day - P8X-873
Past and Present - Vyus
Jolinar's Memories - Vorash, Netu and Delmak
The Devil You Know - Vorash, Netu and Delmak
Pretense - Tollana
Urgo - P4X-884
A Hundred Days - Edora (P5C-768)
Shades of Grey - Tollana, PX3-595, planet where Jack saw SG-1, Rogue NID Base
New Ground - P2X-416 (Bedrosia and Optrica)
Maternal Instinct - Kheb
Crystal Skull - P7X-377



SEASON FOUR

Small Victories - Asgard homeworld
The Other Side - Euronda
Upgrades - PX9-757
Crossroads - Vorash
Window of Opportunity - P4X-639
Watergate - "Water Planet"
The First Ones - P3X-888
Scorched Earth - P5S-381
Beneath the Surface - P3R-118
Tangent - Outer space, near Jupiter
The Serpent's Venom - Chulak and the Tobin System
Absolute Power - Abydos
The Light - P4X-347
Prodigy - M4C-862
Double Jeopardy - Juna (P3X-729)
Exodus - Vorash



SEASON FIVE

Enemies - somewhere in space
Ascension - Velona (P4X-636)
The Fifth Man - P7S-441
Red Sky - K'tau
Beast of Burden - Unnamed planet
The Tomb - P2X-338
Between Two Fires - Tollana
2001 - P3A-194
Summit - Revanna and space station in the Hassara System
Last Stand - Revanna and space station in the Hassara System
Fail Safe - Revanna and space - orbit of Earth
The Warrior - Cal Mah and a planet where Nirrti's Jaffa were
Menace - Unnamed planet
The Sentinel - Latona (P2A-018)
Meridian - Kelowna (P2S-4C3)
Revelations - Adara System, second planet



SEASON SIX

Redemption, Part 1 - P2X-374 and Jaffa Rebel Base
Redemption, Part 2 - Jaffa Rebel Base and Anubis's Planet
Abyss - Ba'al's secret outpost
Shadow Play - Kelowna (P2S-4C3)
The Other Guys - Khonsu's planet and Unnamed planet SG-1 was originally on
Allegiance - Alpha Site on P3X-984
Cure - Pangar
Unnatural Selection - Replicator's planet
Sight Unseen - P9X-391
Paradise Lost - P5X-777 and moon
Metamorphosis - P3X-367
Forsaken - P2X-131
Memento - Tagrea (P3X-744)
Prophecy - Lord Mot's planet (P4S-237)
Full Circle - Abydos




SEASON SEVEN

Fallen - the planet where Daniel is found, and Teal'c goes to Yu's homeworld
Homecoming - Kelowna (P2S-4C3)
Orpheus - The planet SG-1 is on at the beginning of the episode, and then Erebus
Revisions - P3X 289
Lifeboat - P2A-347
Enemy Mine - P3X-403
Space Race - Hebridan (use of Stargate is implied to gate to a planet near the Serrakin homeworld, so that Warrick could pick up SG-1 and fly them there, as they don't have a gate.)
Avenger 2.0 - P3C-249 - the planet Jack and Teal'c went to meet the rebel Jaffa, P5S-117 - Ba'al's principal naquada mining site, P3L-997 - the planet Daniel went to, P4F 221 - the planet the mining team was returning from
Birthright - Started out on P3X-955, and went to Hak'tyl
Evolution, Part 1 - the planet that Teal'c and Bra'tac start out on, Ramius' planet,
Evolution, Part 2 - Tartarus
Grace - Carter is aboard the Prometheus somewhere in space; Jack and the boys visit at least seven planets searching for the Prometheus crew (off camera)
Fallout - Kelowna (P2S-4C3)
Death Knell - Alpha Site
Heroes, Part 2 - P3X-666
The Lost City, Part 1 - P3X-439
The Lost City, Part 2 - Praclarush Taonas




Here are the Earth Based Episodes:

SEASON ONE

The Enemy Within
Hathor
Solitudes - However, SG-1 was returning from P4A-771
Politics
Within the Serpent's Grasp - However, SG-1 was aboard a ha'tak, orbiting Earth for most of the episode


SEASON TWO

The Serpent's Lair - However, SG-1 spent most of the episode aboard a ha'tak, orbiting Earth for most of the episode
In the Line of Duty - Nasya
Message In a Bottle - P5C-353
A Matter of Time - P3W-451 visited by SG-10 - Daniel is on PX3-808
1969


SEASON THREE

Seth
Fair Game
Point of View - An Alternate Reality Earth
Foothold - However, SG-1 was returning from offworld at the beginning of the episode
Nemesis - Most of SG-1 was orbiting Earth aboard the Beliskner and planet P3X-234 that SG-1 escaped to



SEASON FOUR

Divide and Conquer - Vorash
Point of No Return - Unnamed Planet
The Curse
Chain Reaction
2010 - Earth in the future
Entity - P9C-372 visited only by MALP


SEASON FIVE

Threshold
Rite of Passage - Hanka (P8X-987)
Desperate Measures
Wormhole X-Treme!
Proving Ground
48 Hours - P3X-116



SEASON SIX

Descent - however, SG-1 spent the first half of the episode in space, in orbit of Earth
Frozen
Nightwalkers
Prometheus - SG-1 did end up in space at the end of the episode
Smoke and Mirrors
Disclosure
The Changeling - Teal'c was offworld to an unnamed site


SEASON SEVEN

Fragile Balance - Asgard
Chimera - Goa'uld
Heroes, Part 1 -However, SG-13 goes to P3X-666
Resurrection - NID episode/Goa'uld
Inauguration - clip show



|*|(*)|*|(*)|*|

Morjana

SG1-Spoilergate
http://tv.groups.yahoo.com/group/SG1-Spoilergate/

[David]

Very cool analysis. Thanks, Morjana!

[Madeleine]

Thanks Morjana, that's really interesting, and very detailed..

Looking through the list I can see why I had thought the number of Earth-based eps per series rose over the years.

Solitudes *felt* like a non Earth-based ep. Watching it for the first time I believed they were offworld, and the attentions of the SGC folk were focussed offworld. Serpent's Lair & Grasp and Nemesis also felt like offworld stories, with them being set on a spaceship. And Foothold and Fair Game had so many aliens and SF in them that I didn't have time to notice that we never got any new planets. 2010 was Earth-based, but it was as much a Strange New World as a lot of the alien planets.

There's nothing in your list that I'd actually disagree with except that I'd swap Redemption 1&2 which seemed mostly to happen on Earth with Descent - same reason as SL/G - and Changeling, which mostly happened in Teal'c's Head while Teal'c was offworld, and the Earth in his fantasies wasn't real. And I had thought Avenger was mostly Earthbound.

[Lil Naitch]

You have entirely to much time on your hands.

But thanks anyways.

[Slainte]

Wow!
Thanks for all the research. I know how many tedious, grueling hours it took forcing yourself to watch RDA in those episode to gather this research data.

Thanks. It really is useful to have this type of info available for us fans.
What would be do without you, Morjana?

[auralan]

Thanks for another great list! It's interesting to look at the balance of episodes and see that it has been fairly consistent over the past seven seasons.

Season 8 spoilers below

S
P
O
I
L
E
R
S
P
A
C
E

We have spoilers for ten season eight episodes so far. While spoilers can be misleading, it looks like Lockdown and Avatar are both set on the base itself. Covenant seems to be heavily earth based with a short trip to the Alpha site. Affinity looks entirely earth based. Endgame is hard to tell, but it sounds like one of those earth-based conspiracy bits with the possibility of an off world component. That's half of the known episodes and as many earth based episodes as we get in most non-abbreviated seasons. Not exactly a typical percentage and we haven't even gotten to the inevitable cost saving clip episode. It doesn't mean the season will be weak. Some earth based episodes have been great, but it is a little worrisome that there is such a difference from previous seasons.

[Sam_o_Neill]

WOW, thats great morjana!
Must of taken you quite a while to compile that list...

[Jeff O'Connor]

I love Earth-based episodes most of the time. This is great. Thanks for the information!

[FixxxeR]

That must have taken a while. Thanks!

[SGSlugger]

Wow...nice Morjana.

It's interesting that they have kept a constant number of offworld/earth-based eps throughout the years.

[SeaBee]

I wonder if there is a deliberate policy at work here, or if it's accidental, it certainly looks too regular to be coincidence.

[KokiriChild]

Wow, that's great! Even got a list of all the planets too! Waay too much time on your hands, but using it in an SG1 way is something I admire you for!

[shelsfc]

Wow, that's really impressive! Thanks Morjana, it must have taken you ages!

[WraithWarrior]

Thanks Majorna, but dont you think that 115 planets is not enough compared to how many gate combinations there are. I know there have only been seven, in the middle of the eigth season but there is enough planets left to keep the show alive for at least two more seasons.

[WraithWarrior]

Sorry about the name, I meant Morjana. Thanks again

[NowIWillDestroyAbydos]

Come on, Update the list with Season Eight episodes.

[briguy213]

obviosly there are more offworld mixed with on world than anything.

[Qasim]

Thanks a lot - good work