From: steve@picard.cs.wisc.edu (Steven Glinberg)
Newsgroups: rec.arts.startrek.current
Subject: Episodes/explainations lists
Summary: Here is one, more to be gotten
Date: 7 Sep 92 19:41:09 GMT
Organization: University of Wisconsin, Madison -- Computer Sciences Dept.

Very many people mailed me and asked for the database I talked
about, so I'm posting it.  For easy porting, there are tabs after 
fields, returns after records.  If you are not going to put it in
a db, put returns after the title and the abstracts will go the the line 
under for easy reading.  I have a rating of how good [my roommate and
I think] the episodes are, between 1 thru 5.  Just look at Yesterday's
Enterprise or Canundrum, and Cost of Living to get a grip on this
system (Ha ha).

If anyone knows the stardate of The Next Phase, I'd appreciate if you'd
let me know. Dr. Crushers monitor said Ro died at 45902.4 I believe but
I'm not sure if this is accurate. 

I (actually my roommate) got an excellent info file on TNG with everything
you could ever imagine about the show - actors info, seasonal changes,
continuity errors, Romulan/Klingon/Cardasian/etc. encounters, and
an amazing quantity more.

He got it from this ftp site:

ftp.cs.widener.edu

It is a bit burried somewhere there but it is closed today so I cannot tell
you exactly where it is.  Try there first, let me know if it's nowhere to
be found and I'll find it or mail it to you.  It is definately worth the
search!  It is too huge to post here (I think?!)

If anyone has contributions (changes, additions, corrections) to my db
I would really love to know!  
(steve@picard.cs.wisc.edu)

Oh, the episode numbers are the official ones from Paramount, I took them
from the info file my roommate got from the ftp.



Tape#	Rating	Episode	Stardate	Title	Abstract
0.11	3	1	41153.7	Encounter at Farpoint Part I	Ship explores mystery of Farpoint station at Deneb IV
0.12	3	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, Tasha 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 deah 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	Bynars 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's competency is investigated
0.72	3	20	41503.7	Heart of Glory	Two Klingon fugitives take over ship, attempt to persuade Warf 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	2	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 Okana 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 uncharastic 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 dissassembling 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, Warf 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 Jordy 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	Luaxana 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 thier 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 Warfs command, boy copes
-0.83	3	54	43205.6	Booby Trap	Ship trapped by asteroids, Lea Broms with LaForge on holodeck
-0.21	4	55	43349.2	The Enemy	LaForge 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, figths 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 acused 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	Warf'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	Captian'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 emotionaly stable
-0.88	1	72	43930.7	Menage A Troy	Ferenge abduct Troi, Luaxana, 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 Nishara uses Data to fight her battle
3.10	4	81	44246.3	Reunion	Picard is chosen to mediate Klingon power struggle, warf 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, Entprise in 2-d drift
3.50	4	85	44390.1	Data's Day	Data narrates letter to Maddock, 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 Conatact	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	Luaxana 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	Warf resigns, fights in klingon civil war, Sela (Yar as Ramulan) 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 Romulus 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	Warf's son comes aboard, ship conducts warp wave experiment
8.30	3	111	45397.3	Hero Worship	Boy saved from destroyed Veko, immitates 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	Warf is paralized, 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 accedent at academy, receives sanctions
10.30	1	120	45733.6	Cost of Living	Luaxana 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	Jordi & Ro are 'phased' in transporter accedent and assumed dead
13.00	5	125	45944.1	The Inner Light	Picard taken over by a probe, lives entire life with other people
14.00	4	126	45959.1	Times arrow	Data lost in the past, Picard must time travel to save Data and much more
Newsgroups: rec.arts.startrek.current,rec.arts.startrek.misc