mabel's archive UK soccer files

UK SOCCER ARCHIVES FOR ANALYSIS
Summary of File Types, Layout and Formats

There are various sets of files providing
UK soccer data for statistical analysis from
football Season 1990-01 as described below.
Major English and Scottish leagues are covered
plus there are minor league records.

Click here for a description of files.....
RESULTS AND TABLES
RATEFORM RATING VALUES
CUMULATIVE GOALS & POINTS
MATCH SCORE ANALYSIS
HALF-TIME FULL-TIME DATA

Layout and headings of each file type are as described.
The files are available in the formats listed and are suitable
for analyses in spreadsheet and database applications.

In addition 'European Results Files' are provided for.....
England, Germany, France, Holland, Spain and Italy.
( see 'Results and Tables' section below )

Soccer Archives are supplied as email attachments
at a 'TOTAL' cost of only 12 GB pounds for all files.
ORDERING ARCHIVE FILES

Opposite are links to extracts from files and secure payment.

Soccer Archives

RESULTS FILE EXTRACT

TABLES FILE EXTRACT

RATEFORM FILE EXTRACT

GOALS AND LEAGUE POINTS

SCORES ANALYSIS EXTRACT

HALF-TIME FULL-TIME RESULTS

SECURE PAYMENT FORM

RESULTS AND TABLES FROM 1990
These files contain league soccer results and tables
from season 1990-91 to the end of last season. The major English and Scottish league divisions are covered, plus the
Conference, Dr. Martens, Unibond and Ryman premier
league divisions. There are nine files in total.
These are all of the league matches played since
1990-91 and files have the layout described opposite.
View extracts of these files here....

RESULTS FILE EXTRACT

TABLES FILE EXTRACT

Results and tables files available as .....
CSV = Comma Separated for spreadsheets
WDB = MS Works 2.0 Database and later
WKS = MS Works 2.0 Spreadsheet and later
XLS = MS Excel vers 3.0 and later
MDB = MS Access vers 7.0 and later
TXT = Simple Text File

Further notes on file formats .....
Please select only one file format when ordering.
But note that TEXT format is not suitable for sorting
and analysis in a spreadsheet or database.
In fact CSV format is strongly recommended.
CSV files are considerably smaller in size and avoid
problems associated with large files sent as email
attachments. More importantly CSV files will import
into all spreadsheet applications including Excel.

European 'Premier' Leagues .....
An additional set of files gives full results only for six
'Premier' European leagues up to the end of last season.
These are for a minimum of the ten last Seasons.
The European results files have the same layout as
the UK files but are supplied ONLY in CSV format.
The European 'premier' leagues are....
England, Netherlands, France, Spain,
Germany and Italy.

File Compression .....
Archive files for email attachment are compressed
using WINZIP. This is a standard file compression
application. It can be downloaded FREE at the
link opposite although may well already be installed
on your computer system.

return to top of page
_________________________________________________

Layout of Results files .....
index = record index number
season = all from 1990-01 to
the end of last season.
div = league division. Examples...
e0=England Premier, s2=Scotland Div2,
c=Conference, u=Unibond,
m=Dr.Marten, i=Isthmian (Ryman), etc.
h-team = home team name
hg = home team goals scored
a-team = away team name
ag = away team goals scored
match_date = format 'yyyymmdd'

Layout of Table files .....
index = record index number
season = all from 1990-01 to
the end of last season.
div = league division
e3=England Div3, c=Conference, etc
pos = final league position
team = team name
tmp = total matches played
hmw = home matches won
hmd = home matches drawn
hml = home matches lost
hgf = home goals for
hga = home goals against
amw = away matches won
amd = away matches drawn
aml = away matches lost
agf = away goals for
aga = away goals against
tgf = total goals for
tga = total goals against
pts = league points total
tgd = total goal difference

European Results Data .....
These have the same layout as UK results
files but are provided only in CSV format.
Premier divisions are as shown opposite.
A minimumum of ten seasons are provided.

Download WINZIP....

______________________________________ ____

RATEFORM VALUES FROM 1990
These files contain league soccer results and rateform
prediction values from season 1990-91. Major English
and Scottish league divisions are covered, plus the
Conference, Dr. Martens, Unibond and Ryman premier
league divisions. Separate files for each division.
League files for the English Premier, 1st, 2nd and 3rd
begin in season 1992-93, that is from the creation of
the English Premier League. The Scottish 3rd begins
in 1994-95, while all other files provide data from 1990.
Files give the opportunity to analyse the effectivness
of 'Rateform' values as result predictors. Cumulative
values for every league match played up to a decade or
more, plus actual results, are ideal for statistical analysis.
These files have the layout described opposite and are
supplied in CSV format... perfect for spreadsheets.
There are extracts of these files here....

RATEFORM FILE EXTRACT

The Rateform Method .....
A simple but effective system used to rate football
teams and make predictions has, for convenience, been
named 'rateform'. It has its origins in Professor Elo's
'The Rating of Chessplayers' and there are further
details in the book 'Football Fortunes' and at this site...

MABEL's MATCH ANALYSIS

The basic idea is that as football matches are played
over a season individual points totals are updated for
each team depending upon match results.
In allocating points to teams this method considers
important variables such as the comparative quality
of the opposition and whether results are achieved
at home or away. These are factors not considered
when league points or goal averages are compared.
Rateform values carry forward from one season to
the next and form the basis of match predictions.



  return to top of page
_________________________________________________

Layout of Rateform files .....
index = record index number
season = varies from 1990-01 to
the end of last season
date = date match played
( format 'yyyymmdd' )
home-team = home team name
h-pld = home team matches played up
to but not including the shown date
h-rf = home team rateform value
before the given match is played
away-team = away team name
a-pld = away team matches played up
to but not including the shown date
a-rf = away team rateform value
before the given match is played
res = result of match as H, D or A
h-gls = home team goals scored in match
a-gls = away team goals scored in match
rfdif = rateform difference before match
played. This value equals h-rf minus a-rf
plus 100, where 100 is home advantage.
rfpred = values over 100 are Homes,
less than minus 100 are Aways, while
intermediate values predict a Draw.

Gambling books relating
to soccer prediction plus
the 'rateform' method .....

___________________________________________

CUMULATIVE GOALS AND POINTS
These files contain league soccer results plus
cumulative goals scored and lost. Also recorded are
cumulative league points, for each match played.
Complementing the cumulative 'rateform' files, these
are values from season 1990-91. The major English
and Scottish league divisions are covered, plus the
Conference, Dr. Martens, Unibond and Ryman premier
divisions. There are separate files for each division.
Files for the English Premier, 1st, 2nd and 3rd begin
in football season 1992-93, that is from the creation of
the English Premier League. The Scottish 3rd begins
in 1994-95, while all other files provide data from 1990.

The total goals scored and lost, and league points
gained to date, are shown prior to every match. The
resulting match score is recorded. So it is an easy
matter to analyse the relevance of goals and league
points as factors in determining subsequent results.

These files have the layout described opposite and are
supplied in CSV format for spreadsheet analysis.
View an extract from these files here....

GOALS AND POINTS FILE EXTRACT

Files provided by email are compressed with WINZIP.



  return to top of page


_________________________________________________

Layout of Goals / Points files .....
index = record index number
season = varies from 1990-01 to
   the end of last season
date = date match played
( format 'yyyymmdd' )
home-team = home team name
h-pld = home team matches played up
to but not including the shown date
h-tgf = home team cumulative goals 'for'
( ie scored by home team ) before match
h-tga = home team cumulative goals 'against'
( ie lost by home team ) before match
h-pts = home team cumulative league points
    before the match is played
away-team = away team name
a-pld = away team matches played up
to but not including the shown date
a-tgf = away team cumulative goals 'for'
( ie scored by away team ) before match
a-tga = away team cumulative goals 'against'
( ie lost by away team ) before match
a-pts = away team cumulative league points
    before the match is played
res = result of match as H, D or A
h-gls = home team goals scored in match
a-gls = away team goals scored in match

________________________________ __________

MATCH SCORES ANALYSIS FROM 1990
This single CSV file uses the headings opposite.
This data depicts the number and percentage of
a range of match scores within several divisions
and football seasons. Suitable for spreadsheets.
Covers major English and Scottish league divisions,
plus the Conference, Dr. Martens, Unibond and
Ryman premier divisions.
Data for the English Premier, 1st, 2nd & 3rd divisions
begins in season 1992-93, ie from the creation of
the English Premiership. The Scottish 3rd begins
in 1994-95, while all other data is from 1990.

Statistical analysis will show the spread of match
results and scores in different leagues and divisions
over more many seasons of league matches.

There is an extract from these files here....

SCORE ANALYSIS EXTRACT

Supplied as a single compressed 'WINZIPPED' file.



  return to top of page
_________________________________________________

Layout of Scores Analysis files .....
index = record index number
div = division name
en0 to en3 = England Premier to Div.3
sc0 to sc3 = Scotland Premier to Div.3
con=Conference    drm=Dr.Marten
rym=Ryman uni=Unibond
season = varies from 1990-01 to
the end of last season
Scores, numbers and percentages
as Homes, Draws and Aways =
D:0-0, A:0-1, A:0-2, A:0-3, A:0-4, A:0-5,
A:0-6, H:1-0, D:1-1, A:1-2, A:1-3, A:1-4,
A:1-5, A:1-6, H:2-0, H:2-1, D:2-2, A:2-3,
A:2-4, A:2-5, A:2-6, H:3-0, H:3-1, H:3-2,
D:3-3, A:3-4, A:3-5, A:3-6, H:4-0, H:4-1,
H:4-2, H:4-3, D:4-4, A:4-5, A:4-6, H:5-0,
H:5-1, H:5-2, H:5-3, H:5-4, D:5-5, A:5-6,
H:6-0, H:6-1, H:6-2, H:6-3, H:6-4, H:6-5,
D:6-6 plus H:7-? and A:?-7.
(other scores in which one team scores 7)
Total = total matches
HWs = total home wins as numbers & percentages
DRs = total draws as numbers & percentages
AWs = total away wins as numbers & percentage
n/p = record is either a number or a percentage

______________________________   ______ _____

HALF-TIME FULL-TIME DATA
These are files with both half-time and full time
results from 1998-99 to the end of last season.
Data is for both English and Scottish Premier
Leagues plus Divisions 1, 2 and 3.
Files provide an opportunity to analyse and
compare half-time and full-time results. There
are nine possible combinations of half and full
time match results as shown opposite.
Results files include scores and match dates.

HTFT files are provided in CSV format and as
such are eminently suitable for import into all
spreadsheet applications including Excel.
View extracts of some HTFT files here....

HTFT RESULTS FILE EXTRACT

As with others, data has been compressed into
a single file for email attachment using WINZIP.



  return to top of page
_________________________________________________

Layout of HTFT Results files .....
idx = record index number
season = from 1998-99 to
the end of last season
div = league division
e0=England Premier, s2=Scotland Div2, etc
season = from 1998-99 to end of last
home-team = home team name
away-team = away team name
hthg = half-time home goals
htag = half-time away goals
htres = Home, Draw or Away
fthg = full-time home goals
ftag = full-time away goals
ftres = Home, Draw or Away
date = of match in format 'yyyymmdd'
htft = half-time and full-time result as
HH, HD, HA, DH, DD, DA, AH, AD or AA

___________________________________________

ORDERING MABEL's ARCHIVE FILES
The full range of archive files are supplied only as
email attachments at a total cost of 12 GB pounds.
However, if you also subscribe to Mabel's weekly email
service, normally priced at 7 GB pounds, you will
receive all of the archives, plus the weekly files for
a full calendar year, at a combined cost of 15 GB pounds.

There is more about the weekly email service here ....
WEEKLY SOCCER DATA BY EMAIL
There are links and other details for ordering archive files
and subscribing to the weekly service opposite.

Purchase these files using Mastercard or VISA at....
SECURE PAYMENT WEB SITE
Information is encrypted for total security.


Supply of Archive Files .....
Files are sent are sent only as e-mail attachments.
Comma-Separated files are the smallest and fastest to
transfer and will import into all spreadsheet applications.
Many archive files are available only in the CSV format.
However an alternative format, as listed on the payment
page, can be selected for the Results and Tables files
.... the first set of files appearing at the top of this page.
If ordering Mabel's data there is no need to provide
postal information, only your name, e-mail address
and card payment details.

Please note that all archive files are compressed using
WINZIP and the data must be 'extracted' upon receipt.
WINZIP is a popular file compression application.

In fact the facility to extract compressed files will most likely
already exists on your computer system.
Double-clicking on the compressed files sent to you will
result in the extraction of the data files.

Remember safe credit card payment
can be made at our Secure Sites

  return to top of page
_________________________________________________

Ordering and Payment .....
The easiest way to purchase files
is using Mastercard or VISA at the
SECURE PAYMENT web site.
Information is encrypted for total security.
The total charge for the complete range
of all ARCHIVE FILES is 12 GB pounds.

There are five steps in the process....
1. Select Item Number(s)
2. Choose Format where applicable
3. Enter Name and E-mail Address
4. Input Credit Card Details
5. Submit Your Order to Mabel

Payment can also be made by cheque,
payable to 'MABEL' at this address :
Mabels-Tables, ( archives )
PO Box 14555, DUNFERMLINE
Scotland. KY11 4WA
Alternatively, telephone 01383 721729
to place your order or email :
mabel@mabels-tables.co.uk

Download WINZIP here .....

___________________________________________