Spectrum Oracle on Trumpton * Online

S P E C T R U M O R A C L E
o n T R U M P T O N - O n - L i n e
( S P O T * O n )
The Sinclair Spectrum magazine index
now incorporating
S P E X
The Sinclair Spectrum magazine adverts extension

Website designed by SPOT Enterprises ^*		Website designed by SPOT Enterprises ^*
"Inspector Clive" cartoon by Hunt Emerson

SPOT is an Omnis3Plus database running on an Apple Macintosh (Trumpton); it is a detailed index of articles relating to the Sinclair Spectrum - the classic 8-bit computer designed by Sir Clive Sinclair and Sinclair Research - in the magazines Crash, Micro Adventurer, Sinclair Answers, Sinclair Programs, Sinclair User, Your Spectrum, Your Sinclair and ZX Computing (plus numerous issues of various multi-format titles). SPOT*On is a project to make all this information available on the Internet.
SPEX is an extension to the database using the same file structures and covering promotional features in the magazines; eg. advertisements, competitions, special offers.

You may DOWNLOAD the index in one of these forms:

SPOT - Full listing alphabetically by product/feature title (750kb - here's a Sample Layout).

SPOT - Concise listing chronologically by magazine+issue (550kb - here's a Sample Layout).

SPOT - Plain data files for loading into your own database application (908kb).

SPEX - Full listing alphabetically by product/feature title (662kb - here's a Sample Layout).

SPEX - Plain data files for loading into your own database application (875kb).

Plus there are these appendices:

A1. SPOT title summary (80kb)

A2. SPOT product summary (76kb)

A3. SPOT publisher summary (93kb)

B1. Sinclair books list (59kb)

B2. Cover tape contents (49kb)

B3. Spectrum utility routines (80kb)

B4. ZX Computing type-ins (69kb)

You may SEARCH the database on-line at Sinclair Info Seek.
Thanks to Martijn van der Heide for doing the work on this search engine.

Note: The publisher/author, product type, reference type and magazine descriptions are shown as short codes against each reference entry in the concise version. The file CODES.ZIP (22kb) has the full descriptions associated with each code.

Here is the SPOT specification.

SPOT/SPEX Summary - Issues currently indexed

	SPOT			SPEX
	done	o/s	total	done
	---	---	---	---
Crash	98	0	98	98
Sinclair Answers	2	0	2	2
Sinclair Programs	35	0	35	35
Sinclair User	133	0	133	133
Your Spectrum	21	0	21	21
Your Sinclair	93	0	93	93
ZX Computing	38	0	38	38
	---	---	---	---
	420	0	420	420

DATABASE STATISTICS
	Topics		Entries
	---		---
SPOT	6,497		52,206
SPEX	7,546		74,284
	---		---
			126,490

	SPOT			SPEX
	done	o/s	total	done
	---	---	---	---
ACE	2	53	55	2
Big K	12	0	12	12
Computer & Video Games	64	62	126	64
Computer Gamer	27	0	27	27
Games Computing	7	8	15	7
Games Machine	1	14	15	1
Micro Adventurer	17	0	17	17
Personal Computer Games	15	0	15	15
TV Gamer	14	0	14	14
Your Computer	53	14	67	53
	---	---	---	---
	212	151	363	212

Home Computing Weekly	31	102	133	31
Personal Computer News	39	70?	109?	39
Popular Computing Weekly	169	247?	416?	169
ZX User (HCW supplement)	1	4	5	1
	---	---	---	---
	240	423?	663?	240

sundry multi-formats (monthly)	20	-	-	20

Computer Choice, Computing Today, Electronics & Computing, Micro Update, Practical Computing, Personal Computing Today, Which Micro?

The Spectrum Oracle on Trumpton - Online (SPOT*On) is a SPOT Enterprises Production
from: Jim Grimwood, Weardale, England
Home of the SPOT database (Spectrum Oracle on Trumpton) and the Your Spectrum Unofficial Archive (YrUA?)
If you want more information on any of the articles listed, or on SPOT or YrUA?, or have any helpful suggestions, or any errors to report,
then please contact me: jg27paw4 at domain globalnet.co.uk .
^* (SPOT Enterprises has no existence beyond the author's imagination. "Hey, I made it up!")

Last updates: SPOTdata: 19th June 2009; SPEXdata: 19th June 2009;
Appendices: 19th March 2008

These pages were prepared with the FlexED HTML editor from Infoflex Pty Ltd. (Spanderific!)

Have a look in Spot's Pourri for some Spectrum programs which you probably won't find anywhere else -
and some which you might not want to find anyway ...

See Links for some other places which might be of interest.