Would anyone be interested in a ship database

[Graham2001]

This is a case of me floating a question. I am thinking of putting together a database (Using Open Office) of ships that have appeared in the magazines I have access to (Space Gamer/JTAS/Challenge) for use by Referees, this would give Magazine/Issue/Page and if deckplans had been provided in the article or not.

What I would like to know is (a. If any such project has been attempted in the past. (b. Are there any good lists of just what was published in what magazine (by topic), this would help in searching.

 

[GypsyComet]

The biggest of the G+ Communities has compiled deckplan appearances of most of the Type ships, but that's a few years back and takes some scrolling to get to.

I had a list on my (now defunct) website of all deckplans I found, compiled late 90s. I was ignoring appearances without deckplans, though. Here's A-C.

Ship Name & Nationality Size Edition
Location Notes

"Shuttle" Pinnace (Imp) 40 CT
Spinward Marches Campaign see also "Fast Shuttle"

Annic Nova 600 CT
Dbl Adv 1: Annic Nova

Annic Nova 600 CT
JTAS #1

Argosy Traveller ATV 10 CT
Ordeal by Eshaar

Arzhent Prospector/Surveyor 180 CT
High Passage #4

Athena Starfreighter 200+ CT
Different Worlds #18 modular

Avenger Patrol Frigate 800 CT
Letter of Marque

Beanstalk ? CT
White Dwarf #71

Blue Yonder class Yacht 200 MT
Challenge #48 incomplete

Bounty Scout 100 none
The Traveller's Digest 4 Seeker ad

Brilliant Gem Coreship Liner 36117 CT
Doom of the Singing Star

Brilliant Gem Moduleship Liner 13363 CT
Doom of the Singing Star

Broadsword (Type C) Cruiser 800 CT
JTAS #8

BroadSword (Type C) Cruiser 800 MT
Challenge #38

Camel Medical Launch (Imp.) 20 CT
Adventure Class Ships Vol 1 FASA folio

Chameleon Commerce Raider 800 CT
Adventure Class Ships Vol 1 FASA folio

Chatl Leader Scout (Zho.) 150 CT
Adventure Class Ships Vol 1 FASA folio

Cobra Corsair 200 TNE
Challenge #75

Condor System Defense Boat 500 CT
Adventure Class Ships Vol 1 FASA folio

Corporation Building MT
Building Complex Series: 1 Corporation Building Seeker plan set

Corsair M:0 400 T4
T4: Starships

Corsair M:0 400 T4
Annililik Run

Cutter 50 CT
Starships and Spacecraft (Judges Guild) variant

Cutter 50 MT
Imperial Small Craft Seeker deckplan set

Cutter (Modular) 50 CT
Traders and Gunboats Standard

Cutter (Modular) 50 CT
JTAS #5 w/modules

Cutter (Modular) 50 CT
JTAS #8

Cutter (Modular) 50 MT
MT World Builder's Handbook

Cutter (Modular) 50 CT
Grand Survey

Cutter (Modular) M:0 50 T4
T4: Starships

 

[Graham2001]

Thanks for the additional information. As I said in the OP, at least initially I plan to focus on the magazines I have.

I think I have all the fields sorted out and should have a test version ready by next week.

 

[Timerover51]

One question I would have is what edition of Book 2 were the ships designed under? The 1977 edition is different from the 1981 edition, and I prefer the 1977 edition

 

[Graham2001]

Ok,

Here is my current listing of the fields that will be used.

Author
Class
Type
Hull
Publication
Magazine (Y/N)
Issue
Page
Stats (Y/N)
Deckplan (Y/N)
Notes

I am going to start putting together the test database tomorrow. Thanks for the suggestion regarding edition, but it's not always clear from the publication just which is being used.

At the moment I am considering just leaving out the CT/MT aspect of it and simply indicate where the ship can be found.

Something else I am considering listing are cases of ships where only a class name is given (For example the Sylea Class Battleships (aka pseudo Star Destroyers)) that appear in the Battleships entry of Supplement 8.

 

[aramis]

One question I would have is what edition of Book 2 were the ships designed under? The 1977 edition is different from the 1981 edition, and I prefer the 1977 edition

Not always relevant.

The easiest and fastest signs it's CT-77:
M# > P#
J# > Computer Model

There are slight differences in the performance tables. Easily missed ones.

If it isn't in those, the differences between editions are usually immaterial.

The one case where it matters much at all is for CT-81 ships with...
If M# = P# and M# > J#... in which case the PP can be reduced to the M# in a CT-77 driven game.

 

[Graham2001]

Does anyone have the complete run of Tidewater Traveller Times (1-43), the archived version of the page on the Internet archive has some issues complete, but with several of the others the download just does not work or a "this resource cannot be displayed" message appears.

 

[GypsyComet]

I have most of those from before Geo let the site lapse. I'm missing 35, 38, 40-42. First ten issues have just one ship for standard Traveller:

Wheeled APC (Striker; internal plan; Geo) TTT#2
Load Lifter and Combat Walker (MT;;Geo) TTT#8
T-95 MBT (MT;;Geo) TTT#9
Go Kart and Lobster Trap (2300AD;;Geo) TTT#10

Button class (2300AD; graphics; Geo) TTT#5 (though the Geo's Variant's section is labeled #4)
Express Modular Cargo Ship (MT;art (maybe); Geo) TTT#9

 

[Graham2001]

I have most of those from before Geo let the site lapse. I'm missing 35, 38, 40-42. First ten issues have just one ship for standard Traveller:

Wheeled APC (Striker; internal plan; Geo) TTT#2
Load Lifter and Combat Walker (MT;;Geo) TTT#8
T-95 MBT (MT;;Geo) TTT#9
Go Kart and Lobster Trap (2300AD;;Geo) TTT#10

Button class (2300AD; graphics; Geo) TTT#5 (though the Geo's Variant's section is labeled #4)
Express Modular Cargo Ship (MT;art (maybe); Geo) TTT#9

The ones I was able to download were 1, 26, 31, 39, 43. I tried to download two of the others (42 & 37) using a download manager and it gave me the full file size (around 2.5mb) but then cut out saying that the remote server had cancelled the connection.

 

[tjoneslo]

This is a case of me floating a question. I am thinking of putting together a database (Using Open Office) of ships that have appeared in the magazines I have access to (Space Gamer/JTAS/Challenge) for use by Referees, this would give Magazine/Issue/Page and if deckplans had been provided in the article or not.

What I would like to know is (a. If any such project has been attempted in the past. (b. Are there any good lists of just what was published in what magazine (by topic), this would help in searching.

I would like to point out the wiki has much of this information. Based upon the conversation above we could add more information to the ship entries to capture everything. But I think this would be a better distribution mechanism than other documents.

As an interesting challenge, what would you plan to do with designs like the Beowoulf which is present in every Traveller design system? Including multiple deck plans?

 

[Graham2001]

Well I thought it might be good way to point out what is out there/where it came from and it points out areas that might need more detailing (See my earlier post mentioning the Sylea Class Battleships).

Anyway I've completed a four entry database which is linked below:

https://app.box.com/s/su9jikh7j5gynxupnrqtyeklbgtbkyvg

Now I have also hit the issue you mentioned with Third Imperium, I need to confirm just which plans appearing in Third Imperium appeared in other publications first (Issue one has Corsair deckplans/stats.)

 

[GypsyComet]

Now I have also hit the issue you mentioned with Third Imperium, I need to confirm just which plans appearing in Third Imperium appeared in other publications first (Issue one has Corsair deckplans/stats.)

The Vargr Corsair, specifically. The classic Type P is under-represented in deckplans until much later.

First step is to compile a raw list. Then start identifying actual duplicates, duplicated efforts, and other repeats.

 

[GypsyComet]

Pulled from the G+ group posts I did in 2013. These are specifically deckplan appearances, and are limited to the Types and closely related ships.

Type A
Alexandria Free Trader, 200 tons, CT, Adventure Class Ships Vol 2 FASA folio
Beowulf Free Trader, "200" tons, MT, Starship Operator's Manual (off size)
Free Trader, 200 tons, CT, Starships and Spacecraft (Judges Guild) variant (I normally refer to this as the "Guilder" or the JG)
"Beowulf" Free Trader, 200 tons, CT, Snapshot variant
"Crystal Queen" Free Trader, 200 tons, MT, Explorer #1 (German license fanzine)
Free Trader, 200 tons, T4, T4 Starships
Free Trader, 200 tons, MGT, Core Rule Book
Fanzhienz Far Trader (Zhodani), 200 tons, CT, Adventure Class Ships Vol 2 FASA folio
Fanzhienz Far Trader (Zhodani), 200 tons, CT, The Stazhlekh Report (FASA)
Wilds Free Trader (1248), 200 tons, CT, Starships 1-Small Merchant Ships (Comstar/Avenger)
Beowulf Free Trader, 200 tons, GT, GT Main Rule Book (hexes)
Trader (Droyne), 200 tons, GT, GT Alien Races 3 (hexes)

Type A2
Garu Far Trader, "200" tons, MT, The Flaming Eye (too big)
Garu Far Trader, "200" tons, MT, MegaTraveller Journal #4
Jayhawk Far Trader, 200 tons, TNE (2m plans), The Guilded Lilly (the RIGHT size)
Empress Marava Far Trader, "200" tons, CT, Traders and Gunboats Standard
Far Trader, 200 tons, T4, T4 Starships
Salamander Far Trader, 200 tons, T20, QLI "Forgotten War" and "Gabriel Enigma"
Far Trader, 200 tons, MGT, Core Rule Book
Wilds Far Trader (1248), 200 tons, CT, Starships 1-Small Merchant Ships (Comstar/Avenger)
Empress Marava, 200 tons, GT, GT Far Trader (hexes)

Other "Traders":
Frontier Trader (1248), 300 tons, CT, Starships 1-Small Merchant Ships (Comstar/Avenger)
Empress Marava Far Trader, 400 tons, MT, Empress Marava Seeker deckplan set
Diafrenzo Long Trader, 200 tons, TNE, Traveller Chronicle #9
Secure Trader, 200 tons, T4, T4 Starships

Type C
Type C-77 (two Pinnaces)
Cruiser, 800 tons, CT, Starships and Spacecraft (Judges Guild)

Type C-81 (two Cutters plus Modules)
Broadsword Cruiser, 800 tons, CT, JTAS #8
Broadsword Cruiser, 800 tons, CT, Adventure 7 - Broadsword
Broadsword Cruiser, 800 tons, MT, Challenge #38
Explorer Survey Cruiser, 800 tons, CT, Adventure Class Ships Vol 2 FASA folio
Mercenary Cruiser, 800 tons, T4, T4 Starships
Mercenary Cruiser, 800 tons, MGT, Core Rule Book
Broadsword Mercenary Cruiser, 800 tons, GT, GT Star Mercs (hexes)

Type CM (different subcraft loadout):
Lorimar Merchant Cruiser, 800 tons, T20, Epic Adventure 4-Merchant Cruiser (QLI)

Type MC (smaller, same role):
Javelin Mercenary Cruiser, 600 tons, T20, Epic Adventure 6-Mercenary Cruiser (QLI)

Caen Dropship, 1200 tons, GT, GT Ground Forces (hexes)

Type J
Seeker, 100 tons, CT, Traders and Gunboats
Khazad Seeker, 100 tons, CT, White Dwarf #23
Seeker, 100 tons, MT, Traveller's Digest #21 DGP ad; partial plans
1248 Seeker, 100 tons, CT, Starships 2-Scout Ships (Comstar/Avenger)
Seeker, 100 tons, MGT, Mongoose CRB

Type K
Animal class Safari Ship, 200 tons, CT, Adv 10:Safari Ship
Simba class Safari Ship, 200 tons, CT, Simba Safari (Judges Guild)
Leaping Snowcat Safari Ship, 200 tons, GT, GT Starships (hexes)

Type L: Lab Ships
Type L Lab Ship, 400 tons, CT, Dbl Adv3: Death Station
Type L Lab Ship, 400 tons, TNE, Challenge #71
Type L Lab Ship, 400 tons, MT, Lab Ship (Seeker deckplan set)
Type L Lab Ship, 400 tons, MT, Traveller's Digest #16 (Seeker ad)
Lab Ship M:0, 400 tons, T4, T4: Starships
Lab Ship M:0,400 tons, T4, Annililik Run
Kugashin Lab Ship, 400 tons, GT, GT Starships (hexes)
Calipso Lab Ship, 400 tons, MGT, Signs & Portents #87

Other Lab Ships:
Kurgilash Medical Scout, 400 tons, CT, Adventure Class Ships Vol 2 (FASA folio)

Type M
Lord Somerset Subsidized Liner, 600 tons, CT, Adventure Class Ships Vol 2 FASA folio
Subsidized Liner, 600 tons, CT, Adv 13: Signal GK
Subsidized Liner, 600 tons, MT, Challenge #46
Pride of Vhodan, Subsidized Liner, 600 tons, TNE, Challenge #75
Subsidized Merchant, 600 tons, CT, Starships and Spacecraft (Judges Guild)
Subsidized Merchant, 600 tons, CT, Darthanon Queen (Judges Guild)
Subsidized Liner M:0, 600 tons, T4, T4: Starships
Subsidized Liner M:0, 600 tons, T4, Annililik Run
Subsidized Liner, 600 tons, T20, One Crowded Hour (Comstar/Avenger)
The T20 artwork does not appear to have made the jump to deckplans.

Other mid-size Merchants
Possum Merchant, 400 tons, CT, Variant v1n3
Maru class Merchant, 500 tons, CT, Adventure Class Ships Vol.1 (FASA)
Nymph Merchant, 400 tons, CT, Letter of Marque
Green Horizon Merchant Explorer, 560 tons, CT, White Dwarf #35

Type P (and other "Corsairs"):
Iron Fist Corsair, 400 tons, CT, High Passage #2
Raider, 400 tons, CT, Letter of Marque
Corsair, 400 tons, CT, Corsairs of the Turku Waste (Judges Guild)
"Jolly Roger", 400 tons, CT, Third Imperium (fanzine) #4
Corsair, 440 tons, MT, Traveller's Digest #15
Nightspeed Corsair, 440 tons, MT, Challenge #62
Corsair M:0, 400 tons, T4, T4: Starships
Corsair M:0, 400 tons, T4, Annililik Run
Buccaneer, 400 tons, T20/CT, Golden Age Starships 6-Corsair
Corsair, 400 tons, MGT, Core Rule Book

Chameleon Commerce Raider, 800 tons, CT, Adventure Class Ships Vol 1 (FASA)
Shark Raider, 1000 tons, CT, Variant v1n1
Cobra Corsair, 200 tons, TNE, Challenge #75
Ueknou Corsair (Vargr), 400 tons, MT, Vilani & Vargr (DGP)

Type R
March Harrier Sub. Merchant, 400 tons, CT, The Traveller Adventure
Challenge Subsidized Merchant, 400 tons, CT, Starships and Spacecraft (Judges Guild)
Subsidized Merchant, 400 tons, CT, Traders and Gunboats (Standard)
Subsidized Merchant, 400 tons, MT, MegaTraveller Journal #1 Seeker ad
Subsidized Merchant, 400 tons, MT, Challenge #45, 46, 48, 49 Seeker ad
Subsidized Merchant, 400 tons, MT, Challenge #62
Subsidized Merchant, 400 tons, MT, Traveller's Digest #19, 20, 21 Seeker ad
Subsidized Merchant M:0, 400 tons, T4, T4: Starships
Subsidized Merchant (1248), 400 tons, CT, Starships 1-Small Merchant Ships (Comstar/Avenger)
"Fat Trader" Subsidized Merchant, 400 tons, MGT, Mongoose CRB
Akkigish Subsidized Merchant, 400 tons, GT, GT Far Trader (hexes)

Type S
Scout/Courier, 100 tons, CT, Starships and Spacecraft (Judges Guild)
Intrepid Scout/Courier, 100 tons, CT, Snapshot
Sulieman Scout/Courier, 100 tons, CT, Traders and Gunboats
Bounty Scout, 100 tons, n/a, The Traveller's Digest 4 (Seeker ad)
Monitor Scout, 100 tons, MT, Challenge #38
Ninz Scout (Zhodani), 100 tons CT, Adventure Class Ships Vol 1 FASA folio
Ranger Courier (Imp.), 100 tons, CT, Space Gamer #81
M:0 Scout/Courier, 100 tons, T4, Starships (incomplete; nuff said)
Scout (Vargr), 100 tons, TNE, Traveller Chronicle #8
Serpent Scout, "100" tons, CT, JTAS #2
Serpent Scout (CS), "100" tons, CT, Scouts and Assassins pull out
Scout/Courier, 100 tons, T20, Epic Adventure 1-Stoner Express, Epic Adventure 2-Into the Glimmer Drift, and Epic Adventure 3-Chimera
1248 Scout/Courier, 100 tons, CT, Starships 2-Scout Ships (Comstar/Avenger)
Scout/Courier, 100 tons, MGT, Mongoose CRB
Sulieman Scout/Courier, 100 tons, GT, GT Main Rulebook (hexes)
Scout (Droyne), 100 tons, GT, GT Alien Races 3 (hexes)

Other "Scout" ships:
X-Boat, 100 tons, CT, Traders and Gunboats
1248 X-Boat, 100 tons, CT, Starships 2-Scout Ships (Comstar/Avenger)
Express Boat, 100 tons, GT, GT First In (hexes)
Fast Courier/Blockade Runner (Sword Worlds), 130 tons, T20, QLI "Forgotten War"
Chatl Leader Scout (Zhodani), 150 tons, CT, Adventure Class Ships Vol 1 FASA folio
CF Fast Courier, 200 tons, T20, Golden Age Starships 1-Fast Courier
Stayaow Combat Scout (Aslan), 200 tons, CT, Adventure Class Ships Vol 2 FASA folio
EDSV Fighting Scout, 300 tons, T4, Gateway
EDSV Fighting Scout, 300 tons, T4, Long Way Home
Explorer Scout Ship, 300 tons, CT, White Dwarf #40
Donosev Scout Cruiser, 400 tons, MT, World Builder's Handbook
Donosev Survey Ship, 400 tons, CT, Grand Survey
Donosev Survey Ship, 400 tons, GT, GT First In (hexes)
Khadumir Fast Courier, 400 tons, GT, GT First In (hexes)
Telemon Survey Scout (1248), 400 tons, CT, Starships 2-Scout Ships (Comstar/Avenger)
St. Christopher Explorer, 490 tons, CT, White Dwarf #26
Kurgilash Medical Scout, 400 tons, CT, Adventure Class Ships Vol 2 FASA folio
Kon-Tiki Scout Cruiser, 800 tons, T4, Milieu 0 Campaign
X-Boat Tender, 1000 tons, CT, Traders & Gunboats
Purcell X-Boat Tender, 1000 tons, GT, GT First In (hexes)
1248 X-Boat Tender, 1000 tons, CT, Starships 2-Scout Ships (Comstar/Avenger)
Qasar Scout Cruiser, 1000 tons, T20, Epic Adventure 5-Scout Cruiser
Machii Scout Cruiser (1248), 1000 tons, CT, Starships 2-Scout Ships (Comstar/Avenger)

System Defense Boats:
Dragon SDB, 400 tons, CT, Supplement 7 - Traders & Gunboats
Dragon System Defense Boat, 400 tons, MT, SDB and Jump Shuttle (Seeker Deckplan Set)
Dragon SDB, 400 tons, GT, GT Starships (hexes)

SDB Jump Shuttles:
Dragon Jump Shuttle, 200 tons, CT, Supplement 7 - Traders & Gunboats
Dragon Jump Shuttle, 200 tons, MT, SDB and Jump Shuttle (Seeker Deckplan Set)
Dragon/S Jump Shuttle, 300 tons, GT, GT Starships (hexes)

Type T
Lurushaar Kilaalum Patrol Ship, 400 tons, CT, Adventure Class Ships Vol 2 FASA folio
Patrol Cruiser M:0, 400 tons, T4, T4: Starships
Vayu Patrol Cruiser, 400 tons, GT, GT Starships (hexes)

Other related ships:
Type L (whatever that is; lumping it with the Type T) Ramada Corvette, 400 tons, T20, Epic Adventure 2-Into the Glimmer Drift
Valkarie Patrol Cruiser (Sword Worlds), 600 tons, T20, Golden Age Starships 2 (Avenger)

 

[GypsyComet]

and the tail of that list (since I hit the board's post size limit):

Type Y
Yacht, 200 tons, CT, Starships and Spacecraft (Judges Guild)
Lady of Shallot Yacht, 200 tons, CT, Adventure Class Ships Vol.2 (FASA)
Starjammer Yacht, 200 tons, CT, Space Gamer #85
"Blue Yonder" Yacht, 200 tons, MT, Challenge #48 incomplete
"Venturi" Yacht, 200 tons, MT, Challenge #50 incomplete
Lady Charlotte Yacht, 200 tons, TNE, The Traveller Chronicle #3
Yacht, 200 tons, MGT, CRB

Other Yachts and Excursion Ships
Solar Flare Casino Yacht, ? tons, CT, High Passage #1
Desiree Keah Private Yacht, 400 tons, CT, Adventure Class Ships Vol.1 (FASA)
Ocelot Yacht, 400 tons, CT, Variant v1n2
Lone Dragon Armed Yacht, 300 tons, CT, White Dwarf #68
Wanderer Yacht, 100 tons, GT, GT Nobles (hexes)
Midas "Fast Courier", 800 tons, GT, GT Nobles (hexes)

 

[Timerover51]

The following quote comes from the 1981 Edition of Book 2: Starships.

In all cases, the power plant letter must equal or exceed either the maneuver drive letter or the jump drive letter, whichever is higher

If that is not the case for the ship, it was probably designed under the 1977 edition of the rules. Either way, that can be compensated for.

I do like the idea of a ship's data base, as that would save time, and also serve as a source for ideas.

 

[coliver988]

I'm assuming this is for more-or-less officially published material? Just wondering about the excellent ships such as Y is for Yacht sort of thing.

 

[agorski]

This is a case of me floating a question. I am thinking of putting together a database (Using Open Office) of ships that have appeared in the magazines I have access to (Space Gamer/JTAS/Challenge) for use by Referees, this would give Magazine/Issue/Page and if deckplans had been provided in the article or not.

What I would like to know is (a. If any such project has been attempted in the past. (b. Are there any good lists of just what was published in what magazine (by topic), this would help in searching.

I've done this:

https://rpggeek.com/geeklist/108815/ships-third-imperium

Sorted by chronological appearance. No page numbers, but listings include the article name.

If you are looking at a periodical issue or Traveller supplement in the rpggeek database, if there was a CT starship design in there, you will see a link to the item in this list under the Geeklists section on the page.

 

[agorski]

Does anyone have the complete run of Tidewater Traveller Times (1-43), the archived version of the page on the Internet archive has some issues complete, but with several of the others the download just does not work or a "this resource cannot be displayed" message appears.

AFAIK, there were no CT starship designs ever published in TTT.

 

[Graham2001]

I've done this:

https://rpggeek.com/geeklist/108815/ships-third-imperium

Sorted by chronological appearance. No page numbers, but listings include the article name.

If you are looking at a periodical issue or Traveller supplement in the rpggeek database, if there was a CT starship design in there, you will see a link to the item in this list under the Geeklists section on the page.

Thanks for the link. I am still double checking things though. I will add that I cannot wait for High Passage and Far Traveller to get re-released.