ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Match data is provided for a range of leagues (see tab names). Format in each sheet:
2
3
ColumnDescription
4
match_dateDate of match
5
match_idUnique id for each match in the league
6
event_idId for an attempt in a match
7
time_of_attemptTime of attempt in a match
8
home_teamHome team
9
away_teamAway team
10
home_goalsHome team's total goals after each attempt in the match
11
away_goalsAway team's total goals after each attempt in the match
12
home_xgHome team's total xG after each attempt in the match
13
away_xgAway team's xG total after each attempt in the match
14
playerThe player with the attempt on goal, team name in brackets
15
goal1 if the attempt was a goal, 0 if not.
16
xgThe xG (expected goals) of an attempt
17
assistThe player with the assist (where applicable), team name in brackets
18
goal1 if a player assisted a goal, 0 if not.
19
xaThe xA (expected assist) of an attempt
20
21
Note:
22
This data is generated by myself, I do not take it from another source. This is achieved by:
23
- Scraping publicly available text commentary and using regular expressions to extract details regarding an attempt in a match.
24
- Using this converted data for historical seasons to generate the likelihood of scoring (expected goals) for current games based on the type of attempt
25
26
Whilst I think the xG data I produce is a good approximation of sources such as Statsbomb, Opta, etc. they are obviously the better ones to use should you have access to them.
27
28
If you do use this data for any analysis or plots, a reference to this data source would be much appreciated.
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100