Grouping |
Sub Group |
Detail |
Notes |
Match |
Date/Time |
Day
DD |
|
Match |
Date/Time |
Month
MM |
|
Match |
Date/Time |
Year
CCYY |
|
Match |
Date/Time |
CCYYMMDD |
Derived
from DD,MM,CCYY |
Match |
Date/Time |
Nominal
Date Indicator |
Indicates
that a nominal date has been assigned. The result is 'known' but not the date
of the match. |
Match |
Date/Time |
Kick
Off Time |
Time
game kicked off |
Match |
Date/Time |
Day
of Week |
Derived
from DD,MM,CCYY |
New Years Day Indicator |
Holiday |
Indicator
that this is a 'New Years Day' Game |
1
= game played on 1st Jan, 2 = game played on 2nd, 3rd or 4th Jan but is the
designated NY fIxture, 3 = the match played when original fixture was
postponed |
Match |
Date/Time |
Team
1 Seq |
Number
where a Team has played 2 games in one day to allow unique identification of
that match. |
Match |
Date/Time |
Team
2 Seq |
Number
where a Team has played 2 games in one day to allow unique identification of
that match. |
Match |
Season |
Temporal
Season |
The
season the game played based on the date |
Match |
Season |
Competitive
Season |
The
competitive season of the game for games held over from an earlier season |
Match |
Competition |
Tournament |
eg
SC2010 |
Match |
Team |
Team
1 Name |
|
Match |
Team |
Team
1 Unique Name |
|
Match |
Team |
Team
1 Town |
Can
be derived from master team venue list |
Match |
Team |
Team
1 Country |
Can
be derived from master team venue list |
Match |
Team |
Team
2 Name |
|
Match |
Team |
Team
2 Unique Name |
|
Match |
Team |
Team
2 Town |
Can
be derived from master team venue list |
Match |
Team |
Team
2 Country |
Can
be derived from master team venue list |
Match |
Officials |
Referee
Name |
|
Match |
Officials |
Referee
Unique Name |
Possibly
Derived from a master referee list |
Match |
Officials |
Referee
Town (or Club) |
Possibly
Derived from a master referee list |
Match |
Officials |
Referee
Country |
Possibly
Derived from a master referee list |
Match |
Officials |
Linesman
Name 1 |
|
Match |
Officials |
Linesman
Unique Name 1 |
Possibly
Derived from a master referee list |
Match |
Officials |
Linesman
Town (or Club) 1 |
Possibly
Derived from a master referee list |
Match |
Officials |
Linesman
Country 1 |
Possibly
Derived from a master referee list |
Match |
Officials |
Linesman
Name 2 |
|
Match |
Officials |
Linesman
Unique Name 2 |
Possibly
Derived from a master referee list |
Match |
Officials |
Linesman
Town (or Club) 2 |
Possibly
Derived from a master referee list |
Match |
Officials |
Linesman
Country 2 |
Possibly
Derived from a master referee list |
Match |
Officials |
Fourth
Official Name |
|
Match |
Officials |
Fourth
Official Unique Name |
|
Match |
Officials |
Fourth
Official Town (or Club) |
Possibly
Derived from a master referee list |
Match |
Officials |
Fourth
Official Country |
Possibly
Derived from a master referee list |
Match |
Officials |
Assistant
Referee Name 3 |
|
Match |
Officials |
Assistant
Referee Unique Name 3 |
Possibly
Derived from a master referee list |
Match |
Officials |
Assistant
Referee Town (or Club) 3 |
Possibly
Derived from a master referee list |
Match |
Officials |
Assistant
Referee Country 3 |
Possibly
Derived from a master referee list |
Match |
Officials |
Assistant
Referee Name 4 |
|
Match |
Officials |
Assistant
Referee Unique Name 4 |
Possibly
Derived from a master referee list |
Match |
Officials |
Assistant
Referee Town (or Club) 4 |
Possibly
Derived from a master referee list |
Match |
Officials |
Assistant
Referee Country 4 |
|
Match |
Venue |
Venue
Name |
Can
be partially derived from master team venue list |
Match |
Venue |
Venue
Town |
Can
be derived from master team venue list |
Match |
Venue |
Venue
Country |
Can
be derived from master team venue list |
Match |
Venue |
Venue
Type |
H,A,N |
Match |
Competition |
Competition
Name |
|
Match |
Competition |
Competition
Type |
SPL,
Premier, D1 etc |
Match |
Competition |
Competition
Group |
eg
'L', 'SC', 'LC' etc |
Match |
Competition |
Competition
Round |
Name
of Round of Competion |
Match |
Competition |
Competition
Teams Left In |
A
nominal value for the teams left in or 'how many rounds left to the final' |
Match |
Competition |
Leg |
1,
2, Replay 1, Replay 2 etc |
Match |
Competition |
Group |
Name
of group or section |
Match |
Duration |
90
Minutes, Extra Time, Golden Goal, Silver Goal |
|
Match |
Goals |
Team
1 Full Time Goals |
|
Match |
Goals |
Team
1 Half Time Goals |
|
Match |
Goals |
Team
1 90 Minute Goals |
For
games that go to extra time |
Match |
Goals |
Team
1 Penalties (or Corners) |
|
Match |
Goals |
Team
1 Aggregate Goals |
Can
be derived from complete results set |
Match |
Goals |
Team
1 Aggregate Home Goals |
Can
be derived from complete results set |
Match |
Goals |
Team
1 Aggregate Away Goals |
Can
be derived from complete results set |
Match |
Goals |
Team
2 Full Time Goals |
For
games that go to extra time |
Match |
Goals |
Team
2 Half Time Goals |
|
Match |
Goals |
Team
2 90 Minute Goals |
|
Match |
Goals |
Team
2 Penalties (or Corners) |
|
Match |
Goals |
Team
2 Aggregate Goals |
Can
be derived from complete results set |
Match |
Goals |
Team
2 Aggregate Home Goals |
Can
be derived from complete results set |
Match |
Goals |
Team
2 Aggregate Away Goals |
Can
be derived from complete results set |
Match |
Result |
Game
Result - W, D, L, A |
Abandonded
as well |
Match |
Result |
Tie
Result - W Away Goals, Win Penalties, Win Corner Kicks, Win coin toss etc |
|
Match |
Manager |
Team
1 Manager Name |
Can
be derived from master team manager list |
Match |
Manager |
Team
1 Manager Unique Name |
Can
be derived from master team manager list |
Match |
Manager |
Team
1 Manager Age |
Can
be derived from master team manager list |
Match |
Manager |
Team
2 Manager Name |
Can
be derived from master team manager list |
Match |
Manager |
Team
2 Manager Unique Name |
Can
be derived from master team manager list |
Match |
Manager |
Team
2 Manager Age |
Can
be derived from master team manager list |
Match |
League
Position |
Team
1 League Division Name |
Can
be derived from master league positions by Date |
Match |
League
Position |
Team
1 League Tier |
Can
be derived from master league positions by Date |
Match |
League
Position |
Team
1 League position within division before game |
Can
be derived from master league positions by Date |
Match |
League
Position |
Team
1 League position within division after game |
Can
be derived from master league positions by Date |
Match |
League
Position |
Team
1 Absolute League position before game |
Can
be derived from master league positions by Date |
Match |
League
Position |
Team
1 Absolute League position after game |
Can
be derived from master league positions by Date |
Match |
League
Position |
Team
2 League Division Name |
Can
be derived from master league positions by Date |
Match |
League
Position |
Team
2 League Tier |
Can
be derived from master league positions by Date |
Match |
League
Position |
Team
2 League position within division before game |
Can
be derived from master league positions by Date |
Match |
League
Position |
Team
2 League position within division after game |
Can
be derived from master league positions by Date |
Match |
League
Position |
Team
2 Absolute League position before game |
Can
be derived from master league positions by Date |
Match |
League
Position |
Team
2 Absolute League position after game |
Can
be derived from master league positions by Date |
Match |
League
Points |
Team
1 Points Deduction |
Points
deducted from a team from particular date allows calculation of the 'proper'
league table |
Match |
League
Points |
Team
2 Points Deduction |
Points
deducted from a team from particular date allows calculation of the 'proper'
league table |
Match |
TV |
On
Live TV indicator |
|
Match |
TV |
Name
of Live TV Channels |
|
|
|
|
|