From: steve@picard.cs.wisc.edu (Steven Glinberg)
Newsgroups: rec.arts.startrek.current
Subject: Re: Episodes/explanations lists
Date: 13 Sep 92 21:22:28 GMT
Organization: University of Wisconsin, Madison -- Computer Sciences Dept.



Here's the db list of episodes.  It has tabs and returns, so import it 
into a db.  Otherwise add return after the titles - easily read.


I made some changes following the blasts I got for spelling
(friendly suggestions for additions or changes are welcome, 
steve@picard.cs.wisc.edu).  I made this for myself initially - 
you may disagree with the ratings I gave the episodes, oh well. 
Look to Yesterday's Enterprise and Cost of Living for a grip on 
my system.

I hope this is helpfull.
sg


Tape	Rating	Episode	Stardate	Title	Abstract
0.11	2	1	41153.7	Encounter at Farpoint Part I	Ship explores mystery of Farpoint station at Deneb IV
0.12	2	2	41153.8	Encounter at Farpoint Part II	Crew on trial, reunites alien beings, pass Q's test
0.43	3	3	41209.2	The Naked Now	Crew becomes intoxicated, ship endangered, Data does Yar
0.44	2	4	41235.25	Code of Honor	Lugonians kidnap Yar, Yar fights for her freedom
0.51	4	5	41386.4	The Last Outpost	Ferengi and Riker tested for wisdom by guardian of the Tkon empire
0.46	5	6	41263.1	Where no one has Gone Before	Propulsion system test sends ship to alternate reality
0.52	5	7	41249.3	Lonely Among Us	Energy force enters ship and eventually takes over Picard's mind
0.53	3	8	41255.6	Justice	Wesley sentenced to death for violating law of the Edo
0.54	4	9	41723.9	The Battle	Stargazer is found, logs show Picard attacked innocent vessel
0.31	5	10	41590.5	Hide and Q	Q returns to challenge crew, Riker has Q powers, gives crew gifts
0.45	1	11	41294.5	Haven	Troi prepares to marry Wyatt, who leaves to save Terellians' lives
0.37	2	12	41997.7	The Big Goodbye	Picard, Crusher, Data trapped in 1941 San Francisco on holodeck
0.38	5	13	41242.4	Datalore	Lore discovered on Omecron Theta, calls crystalline entity
0.55	2	14	41636.9	Angel One	Female government sentences survivors of crash to death
0.56	3	15	41365.9	111001001	Binars take over ship, crew evacuated except for Riker and Picard
0.32	4	16	41309.5	Too Short a Season	Admiral Jameson takes youth drugs, must undo mistake of the past
0.36	3	17	41509.1	When the Bough Breaks	Enterprise discover Aldeans who cannot reproduce, kidnap children of ship
0.35	2	18	41463.9	Home Soil	Life form declares war on humans, takes over ships computers and lab
0.71	3	19	41416.2	Coming of Age	Wesley endures Starfleet's entrance exam, Picard is investigated
0.72	3	20	41503.7	Heart of Glory	Two Klingon fugitives take over ship, attempt to persuade Worf to join them
0.33	5	21	41798.2	The Arsenal of Freedom	Ship and away team attacked by advanced weaponry demo on Minos
0.21	3	22	unknown	Symbiosis	One planet exploits another planet's dependence upon them
0.34	3	23	41601.3	Skin of Evil	Armus keeps Troi from rescue team on Varga 2, kills Yar for fun
0.22	4	24	41697.9	We'll Always Have Paris	Data patches Manheim's 'time hole'
0.23	2	25	41775.5	Conspiracy	Alien race of parasites attempts to take over federation
0.24	4	26	41986.0	The Neutral Zone	Frozen Americans from 20th century found, Romulans are back
0.27	1	27	42073.1	The Child	Counselor Troi gets pregnant with alien child that emmits radiation
0.28	2	28	42193.6	Where Silence has Lease	Nagilum captures ship to observe death, auto destruct initiated
0.61	5	29	42286.3	Elementary, Dear Data	Holodeck defeats Data in Holmes mystery, Moriarti threatens ship
0.62	2	30	42402.7	The Outrageous Okona	Ship finds Okona fleeing from rivals, Data learns to tell jokes
0.64	1	31	42477.2	Loud as a Whisper*	Deaf Peacemaker Riva's 'chours' is evaporated, he must stop a war
0.63	3	32	42437.5	The Schitzoid Man*	Ira Graves puts himself into Data, Data displays unusual behavior
0.41	3	33	42493.1	Unnatural Selection	Artificial children cause rapid aging at Darwin station, Pulaski infected
0.42	4	34	42506.5	A Matter of Honor	Riker serves on klingon ship, pagh, must fight Enterprise
0.25	4	35	42523.7	The Measure of a Man	Data fights for rights prevents Captain Maddox from disassembling him
0.26	2	36	42568.6	The Dauphin	Salia is escorted to planet she was born to rule, Wesley falls in love
0.73	5	37	42609.1	Contagion	Iconian technology rewrites Enterprise, Yamato, Data, Romulan ship
0.74	3	38	42625.4	The Royale	Away team stuck in mystery story hotel, needs to solve to escape
-0.86	5	39	42679.2	Time Squared	Picard meets future Picard, tries to avoid imminent destruction
-0.61	1	40	42686.4	The Icarius Factor	Riker's father on ship, Worf goes through right of assention
-0.35	3	41	42695.3	Pen Pals	Data talks with young girl, violates prime directive to save her
-0.81	5	42	42761.3	Q Who	Q introduces ship to the Borg, Borg attack, Q saves ship
-0.36	3	43	42779.1	Samaritan Snare	Paclevs capture Geordi to 'make ship go', Picard undergoes heart transplant
-0.33	3	44	42823.2	Up the Long Ladder	Farmer-type people evacuate to ship, placed on planet with cloning people
0.00	1	45	42859.2	Manhunt	Lwaxana searches for the perfect mate, chooses Picard
-0.23	4	46	42901.3	The Emissary	Klingon ship wakes up, must be convinced of peace treaty
0.75	4	47	42923.4	Peak Performance	Simulated war game turns into reality, crew is ambushed by Ferengi ship
0.65	2	48	42976.1	Shades of Grey	Riker's nervous system is inhabited by fatal organism, he has flashbacks
0.84	3	49	43125.8	Evolution	Nanites from Wesley's genetics experiment hinder study of star explosion
0.83	4	50	unknown	The Ensigns of Command	Sheliak claim their planet according to treaty, Data must evacuate planet
0.81	3	51	43152.4	The Survivors	Ship responds to distress call of a decimated planet and finds two survivors
0.82	5	52	43173.5	Who Watches the Watchers	Observation post exposed, must undo contamination to uphold prime directive
-0.82	2	53	43198.7	The Bonding	Boy's mother dies under Worf's command, boy copes
-0.83	3	54	43205.6	Booby Trap	Ship trapped by asteroids, Geordi creates Lea Brahms on holodeck
-0.21	4	55	43349.2	The Enemy	Geordi and Romulan stuck on Galorndan Core, work together  to escape
-0.27	2	56	43385.6	Price	Negotiations on ship over unstable worm hole
0.00	5	57	43421.9	The Vengeance Factor	Picard mediates a dispute between warring clans
-0.63	5	58	43462.5	The Defector	Romulan defector takes bait, attempts to warn federation of attack
-0.24	4	59	43489.2	The Hunted	Enhanced man escapes from Luna 5 prison, fights for freedom
-0.65	4	60	43510.7	The High Ground	Dr. Crusher is abducted by terrorists who dimensional shift
-0.71	4	61	43539.1	Deja Q	Q looses his powers, ship attempts to keep asteroid from crashing to planet
-0.64	2	62	43610.4	A Matter of Perspective	Riker accused of killing Abgar, trial on holodeck
-0.72	5	63	43625.2	Yesterdays Enterprise	1701C comes forward, Federation at war with Klingons, Yar comes back
-0.73	3	64	43657.0	The Offspring	Data creates android, custody battle over her, she dies
-0.74	4	65	43685.2	Sins of the Father	Worf's brother Kern revealed, they loose family honor
-0.75	3	66	43714.1	Allegiance	Picard abducted, replaced by clone, is observed working with three others
-0.76	4	67	43745.2	Captain's Holiday	Picard on Risa, meets Vash, search for tax-utat: a future weapon
-0.62	3	68	43779.3	Tin Man	Betazoid joins enterprise to investigate alive ship
-0.66	3	69	43807.4	Hollow Pursuits	Barkely simulates crew on holodeck, identifies invidium problem in injectors
-0.65	4	70	43872.2	The Most Toys	Fajo abducts Data to display him in his museum
-0.26	3	71	43917.4	Sarek	Picard melds with Sarek so he can be emotionally stable
-0.88	1	72	43930.7	Menage A Troy	Ferengi abduct Troi, Lwaxana, Riker.  Wesley saves them, is promoted
-0.22	3	73	43957.2	Transfigurations	Dr. Crusher's patient recovers quick, becomes a new type of life
1.20	5	74	43992.6	The Best of Both Worlds I	Borg threaten Earth, Borg take Picard and make him a Borg
1.10	5	75	44001.4	The Best of Both Worlds II	Enterprise retrieves Picard, Data accesses Borg thru Riker
2.10	1	76	44012.3	Family	Picard returns home, must decide about staying in Starfleet
2.20	4	77	44085.7	Brothers	Data & Lore are summoned by Dr. Sung to give emotions to Data
2.30	1	78	44143.7	Suddenly Human	Picard refuses to return a human boy to his Tularian father
2.40	5	79	44161.2	Remember Me	Wesley's warp bubble experiment results in the disappearance of the crew
2.50	2	80	44215.2	Legacy	Tasha Yar's sister Ishara uses Data to fight her battle
3.10	4	81	44246.3	Reunion	Picard is chosen to mediate Klingon power struggle, Worf kills Duras
3.20	4	82	44286.5	Future Imperfect	Riker wakes up in sickbay 14 years in the future and now commands the ship
3.30	3	83	44307.3	Final Mission	Wesley is accepted into the Academy, keeps Picard alive on shuttle mission 
3.40	2	84	44356.2	The Loss	Troy looses her empathic abilities, Enterprise in 2-d drift
3.50	4	85	44390.1	Data's Day	Data narrates letter to Maddox, O'Brian get married
3.60	3	86	44429.6	The Wounded	O'Brian's old commander attacks Cardassians
4.10	3	87	44474.5	Devil's Due	Ardra the devil claims her planet after 1000 yrs. of peace
4.20	4	88	44502.7	Clues	Data is forced to lie to protect ship from Xenophobes
4.30	5	89	unknown	First Contact	First contact is made with a race not quite ready yet
4.40	2	90	44614.6	Galaxy's Child	Lia Brahms teams up with Geordi to get rid of space-baby
4.50	4	91	44631.2	Night Terrors	Enterprise is stuck, aliens communicate w/ Troy to save ship
4.60	3	92	44664.5	Identity Crisis	Parasite metamorphasizes Geordi into alien creature
4.70	5	93	44704.2	The Nth Degree	Barkley joins with computer and takes ship to meet other race
5.10	2	94	44741.9	Q pid	Q creates Robin Hood, Picard saves Vash, Vash joins Q
5.20	3	95	44769.2	The Drumhead	Vulcan-Romulan & Picard put on trial for contrived crimes
5.30	1	96	44805.3	Half a Life	Lwaxana falls in love with a scientist who is required by his society to die
5.40	2	97	44821.3	The Host	Symbiotic life needs new body to live, falls in love w/ Beverly
5.50	5	98	44885.5	The Mind's Eye	Geordi abducted by Romulans, attempts to kill klingon
5.60	2	99	44932.3	In Theory	Data experiments with love, holes in space rip apart ship
6.10	5	100	44995.3	Redemption	Worf resigns, fights in klingon civil war, Sela (Yar as Romulan) introduced
6.20	5	101	45020.4	Redemption II	Data commands a ship, exposes Romulans, Sela is Yar's daughter
7.10	3	102	45047.2	Darmok	Ship learns to communicate with race that only speaks in metaphor
7.20	2	103	45076.3	Ensign Ro	Picard uncovers federation plot to break Cardassian treaty
7.30	3	104	45122.3	Silicon Avatar	Ship attempts to talk with crystalline entity, entity is destroyed
7.40	4	105	45156.1	Disaster	Rare phenomenon completely disables the ship, crew must deal w/disaster
7.50	4	106	45208.2	The Game	Crew is mind-controlled by simple game, Wesley saves the ship
7.60	5	107	45233.1	Unification I	Picard and Data go to Romulas in search of Mr. Spock
7.70	5	108	45245.8	Unification II	Data, Picard, Spock captured by Sela, Pardek is a traitor
8.10	5	109	45349.1	A Matter of Time	Picard must make life/death decision, time traveller won't help
8.20	2	110	45375.?	New Ground	Worf's son comes aboard, ship conducts warp wave experiment
8.30	3	111	45397.3	Hero Worship	Boy saved from destroyed Veko, imitates Data, saves Enterprise
8.40	2	112	45429.3	Violations	Telepathic historian mentally rapes Troi, Riker, & Crusher
8.50	4	113	45470.1	The Masterpiece Society	Biosphere society must be assisted by the outside world
9.10	5	114	45492.7	Canundrum	Crew looses identity, assume orders to "end war with Lisians"
9.20	4	115	45571.2	Power Play	Data, Troi, and Riker take over ship, hold crew hostage
9.30	2	116	45587.3	Ethics	Worf is paralyzed, wants help in killing himself
9.40	1	117	45614.6	The Outcast	Abnormal Genii is born female, falls in love with Riker
10.10	5	118	45652.1	Cause and Effect	Ship caught in endless time loop, crew experiences de ja vou
10.20	3	119	45703.9	The First Duty	Wesley contributes to accident at academy, receives sanctions
10.30	1	120	45733.6	Cost of Living	Lwaxana almost gets married, teaches Alexander about happiness
10.40	3	121	45761.3	The Perfect Mate	Kamala falls in love with Picard despite his effort to prevent it
10.50	2	122	unknown	Imaginary Friend	A little girl's Imaginary friend becomes real and endangers the ship
11.00	4	123	45854.2	I Borg	Borg survivor found, taken back to ship, becomes an individual
12.00	5	124	45902.4	The Next Phase	Geordi & Ro are 'phased' in transporter accident and assumed dead
13.00	5	125	45944.1	The Inner Light	Picard contacted by a probe, lives through an entire lifetime 
14.00	4	126	45959.1	Times arrow	Data lost in the past, Picard must time travel to save Data and much more