Import data

# csv file
data <- read.csv("../00_data/MyData.csv")
data
##       X       Date       HomeTeam       AwayTeam FTHG FTAG FTR HTHG HTAG HTR
## 1     1 13/08/2021      Brentford        Arsenal    2    0   H    1    0   H
## 2     2 14/08/2021     Man United          Leeds    5    1   H    1    0   H
## 3     3 14/08/2021        Burnley       Brighton    1    2   A    1    0   H
## 4     4 14/08/2021        Chelsea Crystal Palace    3    0   H    2    0   H
## 5     5 14/08/2021        Everton    Southampton    3    1   H    0    1   A
## 6     6 14/08/2021      Leicester         Wolves    1    0   H    1    0   H
## 7     7 14/08/2021        Watford    Aston Villa    3    2   H    2    0   H
## 8     8 14/08/2021        Norwich      Liverpool    0    3   A    0    1   A
## 9     9 15/08/2021      Newcastle       West Ham    2    4   A    2    1   H
## 10   10 15/08/2021      Tottenham       Man City    1    0   H    0    0   D
## 11   11 21/08/2021      Liverpool        Burnley    2    0   H    1    0   H
## 12   12 21/08/2021    Aston Villa      Newcastle    2    0   H    1    0   H
## 13   13 21/08/2021 Crystal Palace      Brentford    0    0   D    0    0   D
## 14   14 21/08/2021          Leeds        Everton    2    2   D    1    1   D
## 15   15 21/08/2021       Man City        Norwich    5    0   H    2    0   H
## 16   16 21/08/2021       Brighton        Watford    2    0   H    2    0   H
## 17   17 22/08/2021    Southampton     Man United    1    1   D    1    0   H
## 18   18 22/08/2021         Wolves      Tottenham    0    1   A    0    1   A
## 19   19 22/08/2021        Arsenal        Chelsea    0    2   A    0    2   A
## 20   20 23/08/2021       West Ham      Leicester    4    1   H    1    0   H
## 21   21 28/08/2021       Man City        Arsenal    5    0   H    3    0   H
## 22   22 28/08/2021    Aston Villa      Brentford    1    1   D    1    1   D
## 23   23 28/08/2021       Brighton        Everton    0    2   A    0    1   A
## 24   24 28/08/2021      Newcastle    Southampton    2    2   D    0    0   D
## 25   25 28/08/2021        Norwich      Leicester    1    2   A    1    1   D
## 26   26 28/08/2021       West Ham Crystal Palace    2    2   D    1    0   H
## 27   27 28/08/2021      Liverpool        Chelsea    1    1   D    1    1   D
## 28   28 29/08/2021        Burnley          Leeds    1    1   D    0    0   D
## 29   29 29/08/2021      Tottenham        Watford    1    0   H    1    0   H
## 30   30 29/08/2021         Wolves     Man United    0    1   A    0    0   D
## 31   31 11/09/2021 Crystal Palace      Tottenham    3    0   H    0    0   D
## 32   32 11/09/2021        Arsenal        Norwich    1    0   H    0    0   D
## 33   33 11/09/2021      Brentford       Brighton    0    1   A    0    0   D
## 34   34 11/09/2021      Leicester       Man City    0    1   A    0    0   D
## 35   35 11/09/2021     Man United      Newcastle    4    1   H    1    0   H
## 36   36 11/09/2021    Southampton       West Ham    0    0   D    0    0   D
## 37   37 11/09/2021        Watford         Wolves    0    2   A    0    0   D
## 38   38 11/09/2021        Chelsea    Aston Villa    3    0   H    1    0   H
## 39   39 12/09/2021          Leeds      Liverpool    0    3   A    0    1   A
## 40   40 13/09/2021        Everton        Burnley    3    1   H    0    0   D
## 41   41 17/09/2021      Newcastle          Leeds    1    1   D    1    1   D
## 42   42 18/09/2021         Wolves      Brentford    0    2   A    0    2   A
## 43   43 18/09/2021        Burnley        Arsenal    0    1   A    0    1   A
## 44   44 18/09/2021      Liverpool Crystal Palace    3    0   H    1    0   H
## 45   45 18/09/2021       Man City    Southampton    0    0   D    0    0   D
## 46   46 18/09/2021        Norwich        Watford    1    3   A    1    1   D
## 47   47 18/09/2021    Aston Villa        Everton    3    0   H    0    0   D
## 48   48 19/09/2021       Brighton      Leicester    2    1   H    1    0   H
## 49   49 19/09/2021       West Ham     Man United    1    2   A    1    1   D
## 50   50 19/09/2021      Tottenham        Chelsea    0    3   A    0    0   D
## 51   51 25/09/2021        Chelsea       Man City    0    1   A    0    0   D
## 52   52 25/09/2021     Man United    Aston Villa    0    1   A    0    0   D
## 53   53 25/09/2021        Everton        Norwich    2    0   H    1    0   H
## 54   54 25/09/2021          Leeds       West Ham    1    2   A    1    0   H
## 55   55 25/09/2021      Leicester        Burnley    2    2   D    1    2   A
## 56   56 25/09/2021        Watford      Newcastle    1    1   D    0    1   A
## 57   57 25/09/2021      Brentford      Liverpool    3    3   D    1    1   D
## 58   58 26/09/2021    Southampton         Wolves    0    1   A    0    0   D
## 59   59 26/09/2021        Arsenal      Tottenham    3    1   H    3    0   H
## 60   60 27/09/2021 Crystal Palace       Brighton    1    1   D    1    0   H
## 61   61 02/10/2021     Man United        Everton    1    1   D    1    0   H
## 62   62 02/10/2021        Burnley        Norwich    0    0   D    0    0   D
## 63   63 02/10/2021        Chelsea    Southampton    3    1   H    1    0   H
## 64   64 02/10/2021          Leeds        Watford    1    0   H    1    0   H
## 65   65 02/10/2021         Wolves      Newcastle    2    1   H    1    1   D
## 66   66 02/10/2021       Brighton        Arsenal    0    0   D    0    0   D
## 67   67 03/10/2021 Crystal Palace      Leicester    2    2   D    0    2   A
## 68   68 03/10/2021      Tottenham    Aston Villa    2    1   H    1    0   H
## 69   69 03/10/2021       West Ham      Brentford    1    2   A    0    1   A
## 70   70 03/10/2021      Liverpool       Man City    2    2   D    0    0   D
## 71   71 16/10/2021        Watford      Liverpool    0    5   A    0    2   A
## 72   72 16/10/2021    Aston Villa         Wolves    2    3   A    0    0   D
## 73   73 16/10/2021      Leicester     Man United    4    2   H    1    1   D
## 74   74 16/10/2021       Man City        Burnley    2    0   H    1    0   H
## 75   75 16/10/2021        Norwich       Brighton    0    0   D    0    0   D
## 76   76 16/10/2021    Southampton          Leeds    1    0   H    0    0   D
## 77   77 16/10/2021      Brentford        Chelsea    0    1   A    0    1   A
## 78   78 17/10/2021        Everton       West Ham    0    1   A    0    0   D
## 79   79 17/10/2021      Newcastle      Tottenham    2    3   A    1    3   A
## 80   80 18/10/2021        Arsenal Crystal Palace    2    2   D    1    0   H
## 81   81 22/10/2021        Arsenal    Aston Villa    3    1   H    2    0   H
## 82   82 23/10/2021        Chelsea        Norwich    7    0   H    3    0   H
## 83   83 23/10/2021 Crystal Palace      Newcastle    1    1   D    0    0   D
## 84   84 23/10/2021        Everton        Watford    2    5   A    1    1   D
## 85   85 23/10/2021          Leeds         Wolves    1    1   D    0    1   A
## 86   86 23/10/2021    Southampton        Burnley    2    2   D    1    1   D
## 87   87 23/10/2021       Brighton       Man City    1    4   A    0    3   A
## 88   88 24/10/2021      Brentford      Leicester    1    2   A    0    1   A
## 89   89 24/10/2021       West Ham      Tottenham    1    0   H    0    0   D
## 90   90 24/10/2021     Man United      Liverpool    0    5   A    0    4   A
## 91   91 30/10/2021      Leicester        Arsenal    0    2   A    0    2   A
## 92   92 30/10/2021        Burnley      Brentford    3    1   H    3    0   H
## 93   93 30/10/2021      Liverpool       Brighton    2    2   D    2    1   H
## 94   94 30/10/2021       Man City Crystal Palace    0    2   A    0    1   A
## 95   95 30/10/2021      Newcastle        Chelsea    0    3   A    0    0   D
## 96   96 30/10/2021        Watford    Southampton    0    1   A    0    1   A
## 97   97 30/10/2021      Tottenham     Man United    0    3   A    0    1   A
## 98   98 31/10/2021        Norwich          Leeds    1    2   A    0    0   D
## 99   99 31/10/2021    Aston Villa       West Ham    1    4   A    1    2   A
## 100 100 01/11/2021         Wolves        Everton    2    1   H    2    0   H
## 101 101 05/11/2021    Southampton    Aston Villa    1    0   H    1    0   H
## 102 102 06/11/2021     Man United       Man City    0    2   A    0    2   A
## 103 103 06/11/2021      Brentford        Norwich    1    2   A    0    2   A
## 104 104 06/11/2021        Chelsea        Burnley    1    1   D    1    0   H
## 105 105 06/11/2021 Crystal Palace         Wolves    2    0   H    0    0   D
## 106 106 06/11/2021       Brighton      Newcastle    1    1   D    1    0   H
## 107 107 07/11/2021        Arsenal        Watford    1    0   H    0    0   D
## 108 108 07/11/2021        Everton      Tottenham    0    0   D    0    0   D
## 109 109 07/11/2021          Leeds      Leicester    1    1   D    1    1   D
## 110 110 07/11/2021       West Ham      Liverpool    3    2   H    1    1   D
## 111 111 20/11/2021      Leicester        Chelsea    0    3   A    0    2   A
## 112 112 20/11/2021    Aston Villa       Brighton    2    0   H    0    0   D
## 113 113 20/11/2021        Burnley Crystal Palace    3    3   D    2    3   A
## 114 114 20/11/2021      Newcastle      Brentford    3    3   D    2    2   D
## 115 115 20/11/2021        Norwich    Southampton    2    1   H    1    1   D
## 116 116 20/11/2021        Watford     Man United    4    1   H    2    0   H
## 117 117 20/11/2021         Wolves       West Ham    1    0   H    0    0   D
## 118 118 20/11/2021      Liverpool        Arsenal    4    0   H    1    0   H
## 119 119 21/11/2021       Man City        Everton    3    0   H    1    0   H
## 120 120 21/11/2021      Tottenham          Leeds    2    1   H    0    1   A
## 121 121 27/11/2021        Arsenal      Newcastle    2    0   H    0    0   D
## 122 122 27/11/2021 Crystal Palace    Aston Villa    1    2   A    0    1   A
## 123 123 27/11/2021      Liverpool    Southampton    4    0   H    3    0   H
## 124 124 27/11/2021        Norwich         Wolves    0    0   D    0    0   D
## 125 125 27/11/2021       Brighton          Leeds    0    0   D    0    0   D
## 126 126 28/11/2021      Brentford        Everton    1    0   H    1    0   H
## 127 127 28/11/2021      Leicester        Watford    4    2   H    3    1   H
## 128 128 28/11/2021       Man City       West Ham    2    1   H    1    0   H
## 129 129 28/11/2021        Chelsea     Man United    1    1   D    0    0   D
## 130 130 30/11/2021      Newcastle        Norwich    1    1   D    0    0   D
## 131 131 30/11/2021          Leeds Crystal Palace    1    0   H    0    0   D
## 132 132 01/12/2021    Southampton      Leicester    2    2   D    2    1   H
## 133 133 01/12/2021        Watford        Chelsea    1    2   A    1    1   D
## 134 134 01/12/2021       West Ham       Brighton    1    1   D    1    0   H
## 135 135 01/12/2021         Wolves        Burnley    0    0   D    0    0   D
## 136 136 01/12/2021    Aston Villa       Man City    1    2   A    0    2   A
## 137 137 01/12/2021        Everton      Liverpool    1    4   A    1    2   A
## 138 138 02/12/2021      Tottenham      Brentford    2    0   H    1    0   H
## 139 139 02/12/2021     Man United        Arsenal    3    2   H    1    1   D
## 140 140 04/12/2021       West Ham        Chelsea    3    2   H    1    2   A
## 141 141 04/12/2021      Newcastle        Burnley    1    0   H    1    0   H
## 142 142 04/12/2021    Southampton       Brighton    1    1   D    1    0   H
## 143 143 04/12/2021         Wolves      Liverpool    0    1   A    0    0   D
## 144 144 04/12/2021        Watford       Man City    1    3   A    0    2   A
## 145 145 05/12/2021          Leeds      Brentford    2    2   D    1    0   H
## 146 146 05/12/2021     Man United Crystal Palace    1    0   H    0    0   D
## 147 147 05/12/2021      Tottenham        Norwich    3    0   H    1    0   H
## 148 148 05/12/2021    Aston Villa      Leicester    2    1   H    1    1   D
## 149 149 06/12/2021        Everton        Arsenal    2    1   H    0    1   A
## 150 150 10/12/2021      Brentford        Watford    2    1   H    0    1   A
## 151 151 11/12/2021       Man City         Wolves    1    0   H    0    0   D
## 152 152 11/12/2021        Arsenal    Southampton    3    0   H    2    0   H
## 153 153 11/12/2021        Chelsea          Leeds    3    2   H    1    1   D
## 154 154 11/12/2021      Liverpool    Aston Villa    1    0   H    0    0   D
## 155 155 11/12/2021        Norwich     Man United    0    1   A    0    0   D
## 156 156 12/12/2021        Burnley       West Ham    0    0   D    0    0   D
## 157 157 12/12/2021      Leicester      Newcastle    4    0   H    1    0   H
## 158 158 12/12/2021 Crystal Palace        Everton    3    1   H    1    0   H
## 159 159 14/12/2021        Norwich    Aston Villa    0    2   A    0    1   A
## 160 160 14/12/2021       Man City          Leeds    7    0   H    3    0   H
## 161 161 15/12/2021       Brighton         Wolves    0    1   A    0    1   A
## 162 162 15/12/2021 Crystal Palace    Southampton    2    2   D    1    2   A
## 163 163 15/12/2021        Arsenal       West Ham    2    0   H    0    0   D
## 164 164 16/12/2021        Chelsea        Everton    1    1   D    0    0   D
## 165 165 16/12/2021      Liverpool      Newcastle    3    1   H    2    1   H
## 166 166 18/12/2021          Leeds        Arsenal    1    4   A    0    3   A
## 167 167 19/12/2021      Newcastle       Man City    0    4   A    0    2   A
## 168 168 19/12/2021         Wolves        Chelsea    0    0   D    0    0   D
## 169 169 19/12/2021      Tottenham      Liverpool    2    2   D    1    1   D
## 170 170 26/12/2021       Man City      Leicester    6    3   H    4    0   H
## 171 171 26/12/2021        Norwich        Arsenal    0    5   A    0    2   A
## 172 172 26/12/2021      Tottenham Crystal Palace    3    0   H    2    0   H
## 173 173 26/12/2021       West Ham    Southampton    2    3   A    0    1   A
## 174 174 26/12/2021    Aston Villa        Chelsea    1    3   A    1    1   D
## 175 175 26/12/2021       Brighton      Brentford    2    0   H    2    0   H
## 176 176 27/12/2021      Newcastle     Man United    1    1   D    1    0   H
## 177 177 28/12/2021 Crystal Palace        Norwich    3    0   H    3    0   H
## 178 178 28/12/2021    Southampton      Tottenham    1    1   D    1    1   D
## 179 179 28/12/2021        Watford       West Ham    1    4   A    1    2   A
## 180 180 28/12/2021      Leicester      Liverpool    1    0   H    0    0   D
## 181 181 29/12/2021        Chelsea       Brighton    1    1   D    1    0   H
## 182 182 29/12/2021      Brentford       Man City    0    1   A    0    1   A
## 183 183 30/12/2021     Man United        Burnley    3    1   H    3    1   H
## 184 184 01/01/2022        Arsenal       Man City    1    2   A    1    0   H
## 185 185 01/01/2022        Watford      Tottenham    0    1   A    0    0   D
## 186 186 01/01/2022 Crystal Palace       West Ham    2    3   A    0    3   A
## 187 187 02/01/2022      Brentford    Aston Villa    2    1   H    1    1   D
## 188 188 02/01/2022        Everton       Brighton    2    3   A    0    2   A
## 189 189 02/01/2022          Leeds        Burnley    3    1   H    1    0   H
## 190 190 02/01/2022        Chelsea      Liverpool    2    2   D    2    2   D
## 191 191 03/01/2022     Man United         Wolves    0    1   A    0    0   D
## 192 192 11/01/2022    Southampton      Brentford    4    1   H    2    1   H
## 193 193 12/01/2022       West Ham        Norwich    2    0   H    1    0   H
## 194 194 14/01/2022       Brighton Crystal Palace    1    1   D    0    0   D
## 195 195 15/01/2022       Man City        Chelsea    1    0   H    0    0   D
## 196 196 15/01/2022      Newcastle        Watford    1    1   D    0    0   D
## 197 197 15/01/2022        Norwich        Everton    2    1   H    2    0   H
## 198 198 15/01/2022         Wolves    Southampton    3    1   H    1    0   H
## 199 199 15/01/2022    Aston Villa     Man United    2    2   D    0    1   A
## 200 200 16/01/2022      Liverpool      Brentford    3    0   H    1    0   H
## 201 201 16/01/2022       West Ham          Leeds    2    3   A    1    2   A
## 202 202 18/01/2022       Brighton        Chelsea    1    1   D    0    1   A
## 203 203 19/01/2022      Leicester      Tottenham    2    3   A    1    1   D
## 204 204 19/01/2022      Brentford     Man United    1    3   A    0    0   D
## 205 205 21/01/2022        Watford        Norwich    0    3   A    0    0   D
## 206 206 22/01/2022        Everton    Aston Villa    0    1   A    0    1   A
## 207 207 22/01/2022      Brentford         Wolves    1    2   A    0    0   D
## 208 208 22/01/2022          Leeds      Newcastle    0    1   A    0    0   D
## 209 209 22/01/2022     Man United       West Ham    1    0   H    0    0   D
## 210 210 22/01/2022    Southampton       Man City    1    1   D    1    0   H
## 211 211 23/01/2022        Arsenal        Burnley    0    0   D    0    0   D
## 212 212 23/01/2022 Crystal Palace      Liverpool    1    3   A    0    2   A
## 213 213 23/01/2022      Leicester       Brighton    1    1   D    0    0   D
## 214 214 23/01/2022        Chelsea      Tottenham    2    0   H    0    0   D
## 215 215 05/02/2022        Burnley        Watford    0    0   D    0    0   D
## 216 216 08/02/2022      Newcastle        Everton    3    1   H    1    1   D
## 217 217 08/02/2022       West Ham        Watford    1    0   H    0    0   D
## 218 218 08/02/2022        Burnley     Man United    1    1   D    0    1   A
## 219 219 09/02/2022       Man City      Brentford    2    0   H    1    0   H
## 220 220 09/02/2022        Norwich Crystal Palace    1    1   D    1    0   H
## 221 221 09/02/2022      Tottenham    Southampton    2    3   A    1    1   D
## 222 222 09/02/2022    Aston Villa          Leeds    3    3   D    3    2   H
## 223 223 10/02/2022      Liverpool      Leicester    2    0   H    1    0   H
## 224 224 10/02/2022         Wolves        Arsenal    0    1   A    0    1   A
## 225 225 12/02/2022     Man United    Southampton    1    1   D    1    0   H
## 226 226 12/02/2022      Brentford Crystal Palace    0    0   D    0    0   D
## 227 227 12/02/2022        Everton          Leeds    3    0   H    2    0   H
## 228 228 12/02/2022        Watford       Brighton    0    2   A    0    1   A
## 229 229 12/02/2022        Norwich       Man City    0    4   A    0    1   A
## 230 230 13/02/2022        Burnley      Liverpool    0    1   A    0    1   A
## 231 231 13/02/2022      Newcastle    Aston Villa    1    0   H    1    0   H
## 232 232 13/02/2022      Tottenham         Wolves    0    2   A    0    2   A
## 233 233 13/02/2022      Leicester       West Ham    2    2   D    1    1   D
## 234 234 15/02/2022     Man United       Brighton    2    0   H    0    0   D
## 235 235 19/02/2022       West Ham      Newcastle    1    1   D    1    1   D
## 236 236 19/02/2022        Arsenal      Brentford    2    1   H    0    0   D
## 237 237 19/02/2022    Aston Villa        Watford    0    1   A    0    0   D
## 238 238 19/02/2022       Brighton        Burnley    0    3   A    0    2   A
## 239 239 19/02/2022 Crystal Palace        Chelsea    0    1   A    0    0   D
## 240 240 19/02/2022      Liverpool        Norwich    3    1   H    0    0   D
## 241 241 19/02/2022    Southampton        Everton    2    0   H    0    0   D
## 242 242 19/02/2022       Man City      Tottenham    2    3   A    1    1   D
## 243 243 20/02/2022          Leeds     Man United    2    4   A    0    2   A
## 244 244 20/02/2022         Wolves      Leicester    2    1   H    1    1   D
## 245 245 23/02/2022        Burnley      Tottenham    1    0   H    0    0   D
## 246 246 23/02/2022        Watford Crystal Palace    1    4   A    1    2   A
## 247 247 23/02/2022      Liverpool          Leeds    6    0   H    3    0   H
## 248 248 24/02/2022        Arsenal         Wolves    2    1   H    0    1   A
## 249 249 25/02/2022    Southampton        Norwich    2    0   H    1    0   H
## 250 250 26/02/2022          Leeds      Tottenham    0    4   A    0    3   A
## 251 251 26/02/2022      Brentford      Newcastle    0    2   A    0    2   A
## 252 252 26/02/2022 Crystal Palace        Burnley    1    1   D    1    0   H
## 253 253 26/02/2022     Man United        Watford    0    0   D    0    0   D
## 254 254 26/02/2022       Brighton    Aston Villa    0    2   A    0    1   A
## 255 255 26/02/2022        Everton       Man City    0    1   A    0    0   D
## 256 256 27/02/2022       West Ham         Wolves    1    0   H    0    0   D
## 257 257 01/03/2022        Burnley      Leicester    0    2   A    0    0   D
## 258 258 05/03/2022      Leicester          Leeds    1    0   H    0    0   D
## 259 259 05/03/2022    Aston Villa    Southampton    4    0   H    2    0   H
## 260 260 05/03/2022        Burnley        Chelsea    0    4   A    0    0   D
## 261 261 05/03/2022      Newcastle       Brighton    2    1   H    2    0   H
## 262 262 05/03/2022        Norwich      Brentford    1    3   A    0    1   A
## 263 263 05/03/2022         Wolves Crystal Palace    0    2   A    0    2   A
## 264 264 05/03/2022      Liverpool       West Ham    1    0   H    1    0   H
## 265 265 06/03/2022        Watford        Arsenal    2    3   A    1    2   A
## 266 266 06/03/2022       Man City     Man United    4    1   H    2    1   H
## 267 267 07/03/2022      Tottenham        Everton    5    0   H    3    0   H
## 268 268 10/03/2022        Norwich        Chelsea    1    3   A    0    2   A
## 269 269 10/03/2022    Southampton      Newcastle    1    2   A    1    1   D
## 270 270 10/03/2022         Wolves        Watford    4    0   H    2    0   H
## 271 271 10/03/2022          Leeds    Aston Villa    0    3   A    0    1   A
## 272 272 12/03/2022       Brighton      Liverpool    0    2   A    0    1   A
## 273 273 12/03/2022      Brentford        Burnley    2    0   H    0    0   D
## 274 274 12/03/2022     Man United      Tottenham    3    2   H    2    1   H
## 275 275 13/03/2022        Chelsea      Newcastle    1    0   H    0    0   D
## 276 276 13/03/2022        Everton         Wolves    0    1   A    0    0   D
## 277 277 13/03/2022          Leeds        Norwich    2    1   H    1    0   H
## 278 278 13/03/2022    Southampton        Watford    1    2   A    1    2   A
## 279 279 13/03/2022       West Ham    Aston Villa    2    1   H    0    0   D
## 280 280 13/03/2022        Arsenal      Leicester    2    0   H    1    0   H
## 281 281 14/03/2022 Crystal Palace       Man City    0    0   D    0    0   D
## 282 282 16/03/2022       Brighton      Tottenham    0    2   A    0    1   A
## 283 283 16/03/2022        Arsenal      Liverpool    0    2   A    0    0   D
## 284 284 17/03/2022        Everton      Newcastle    1    0   H    0    0   D
## 285 285 18/03/2022         Wolves          Leeds    2    3   A    2    0   H
## 286 286 19/03/2022    Aston Villa        Arsenal    0    1   A    0    1   A
## 287 287 20/03/2022      Leicester      Brentford    2    1   H    2    0   H
## 288 288 20/03/2022      Tottenham       West Ham    3    1   H    2    1   H
## 289 289 02/04/2022      Liverpool        Watford    2    0   H    1    0   H
## 290 290 02/04/2022       Brighton        Norwich    0    0   D    0    0   D
## 291 291 02/04/2022        Burnley       Man City    0    2   A    0    2   A
## 292 292 02/04/2022        Chelsea      Brentford    1    4   A    0    0   D
## 293 293 02/04/2022          Leeds    Southampton    1    1   D    1    0   H
## 294 294 02/04/2022         Wolves    Aston Villa    2    1   H    2    0   H
## 295 295 02/04/2022     Man United      Leicester    1    1   D    0    0   D
## 296 296 03/04/2022       West Ham        Everton    2    1   H    1    0   H
## 297 297 03/04/2022      Tottenham      Newcastle    5    1   H    1    1   D
## 298 298 04/04/2022 Crystal Palace        Arsenal    3    0   H    2    0   H
## 299 299 06/04/2022        Burnley        Everton    3    2   H    1    2   A
## 300 300 08/04/2022      Newcastle         Wolves    1    0   H    0    0   D
## 301 301 09/04/2022        Everton     Man United    1    0   H    1    0   H
## 302 302 09/04/2022        Arsenal       Brighton    1    2   A    0    1   A
## 303 303 09/04/2022    Southampton        Chelsea    0    6   A    0    4   A
## 304 304 09/04/2022        Watford          Leeds    0    3   A    0    1   A
## 305 305 09/04/2022    Aston Villa      Tottenham    0    4   A    0    1   A
## 306 306 10/04/2022      Brentford       West Ham    2    0   H    0    0   D
## 307 307 10/04/2022      Leicester Crystal Palace    2    1   H    2    0   H
## 308 308 10/04/2022        Norwich        Burnley    2    0   H    1    0   H
## 309 309 10/04/2022       Man City      Liverpool    2    2   D    2    1   H
## 310 310 16/04/2022      Tottenham       Brighton    0    1   A    0    0   D
## 311 311 16/04/2022     Man United        Norwich    3    2   H    2    1   H
## 312 312 16/04/2022    Southampton        Arsenal    1    0   H    1    0   H
## 313 313 16/04/2022        Watford      Brentford    1    2   A    0    1   A
## 314 314 17/04/2022      Newcastle      Leicester    2    1   H    1    1   D
## 315 315 17/04/2022       West Ham        Burnley    1    1   D    0    1   A
## 316 316 19/04/2022      Liverpool     Man United    4    0   H    2    0   H
## 317 317 20/04/2022        Chelsea        Arsenal    2    4   A    2    2   D
## 318 318 20/04/2022        Everton      Leicester    1    1   D    0    1   A
## 319 319 20/04/2022      Newcastle Crystal Palace    1    0   H    1    0   H
## 320 320 20/04/2022       Man City       Brighton    3    0   H    0    0   D
## 321 321 21/04/2022        Burnley    Southampton    2    0   H    2    0   H
## 322 322 23/04/2022        Arsenal     Man United    3    1   H    2    1   H
## 323 323 23/04/2022      Leicester    Aston Villa    0    0   D    0    0   D
## 324 324 23/04/2022       Man City        Watford    5    1   H    3    1   H
## 325 325 23/04/2022        Norwich      Newcastle    0    3   A    0    2   A
## 326 326 23/04/2022      Brentford      Tottenham    0    0   D    0    0   D
## 327 327 24/04/2022       Brighton    Southampton    2    2   D    2    1   H
## 328 328 24/04/2022        Burnley         Wolves    1    0   H    0    0   D
## 329 329 24/04/2022        Chelsea       West Ham    1    0   H    0    0   D
## 330 330 24/04/2022      Liverpool        Everton    2    0   H    0    0   D
## 331 331 25/04/2022 Crystal Palace          Leeds    0    0   D    0    0   D
## 332 332 28/04/2022     Man United        Chelsea    1    1   D    0    0   D
## 333 333 30/04/2022      Newcastle      Liverpool    0    1   A    0    1   A
## 334 334 30/04/2022    Aston Villa        Norwich    2    0   H    1    0   H
## 335 335 30/04/2022    Southampton Crystal Palace    1    2   A    1    0   H
## 336 336 30/04/2022        Watford        Burnley    1    2   A    1    0   H
## 337 337 30/04/2022         Wolves       Brighton    0    3   A    0    1   A
## 338 338 30/04/2022          Leeds       Man City    0    4   A    0    1   A
## 339 339 01/05/2022        Everton        Chelsea    1    0   H    0    0   D
## 340 340 01/05/2022      Tottenham      Leicester    3    1   H    1    0   H
## 341 341 01/05/2022       West Ham        Arsenal    1    2   A    1    1   D
## 342 342 02/05/2022     Man United      Brentford    3    0   H    1    0   H
## 343 343 07/05/2022      Brentford    Southampton    3    0   H    2    0   H
## 344 344 07/05/2022        Burnley    Aston Villa    1    3   A    0    2   A
## 345 345 07/05/2022        Chelsea         Wolves    2    2   D    0    0   D
## 346 346 07/05/2022 Crystal Palace        Watford    1    0   H    1    0   H
## 347 347 07/05/2022       Brighton     Man United    4    0   H    1    0   H
## 348 348 07/05/2022      Liverpool      Tottenham    1    1   D    0    0   D
## 349 349 08/05/2022        Arsenal          Leeds    2    1   H    2    0   H
## 350 350 08/05/2022      Leicester        Everton    1    2   A    1    2   A
## 351 351 08/05/2022        Norwich       West Ham    0    4   A    0    3   A
## 352 352 08/05/2022       Man City      Newcastle    5    0   H    2    0   H
## 353 353 10/05/2022    Aston Villa      Liverpool    1    2   A    1    1   D
## 354 354 11/05/2022          Leeds        Chelsea    0    3   A    0    1   A
## 355 355 11/05/2022      Leicester        Norwich    3    0   H    0    0   D
## 356 356 11/05/2022        Watford        Everton    0    0   D    0    0   D
## 357 357 11/05/2022         Wolves       Man City    1    5   A    1    3   A
## 358 358 12/05/2022      Tottenham        Arsenal    3    0   H    2    0   H
## 359 359 15/05/2022      Tottenham        Burnley    1    0   H    1    0   H
## 360 360 15/05/2022    Aston Villa Crystal Palace    1    1   D    0    0   D
## 361 361 15/05/2022          Leeds       Brighton    1    1   D    0    1   A
## 362 362 15/05/2022        Watford      Leicester    1    5   A    1    2   A
## 363 363 15/05/2022       West Ham       Man City    2    2   D    2    0   H
## 364 364 15/05/2022         Wolves        Norwich    1    1   D    0    1   A
## 365 365 15/05/2022        Everton      Brentford    2    3   A    2    1   H
## 366 366 16/05/2022      Newcastle        Arsenal    2    0   H    0    0   D
## 367 367 17/05/2022    Southampton      Liverpool    1    2   A    1    1   D
## 368 368 19/05/2022        Everton Crystal Palace    3    2   H    0    2   A
## 369 369 19/05/2022    Aston Villa        Burnley    1    1   D    0    1   A
## 370 370 19/05/2022        Chelsea      Leicester    1    1   D    1    1   D
## 371 371 22/05/2022        Arsenal        Everton    5    1   H    2    1   H
## 372 372 22/05/2022      Brentford          Leeds    1    2   A    0    0   D
## 373 373 22/05/2022       Brighton       West Ham    3    1   H    0    1   A
## 374 374 22/05/2022        Burnley      Newcastle    1    2   A    0    1   A
## 375 375 22/05/2022        Chelsea        Watford    2    1   H    1    0   H
## 376 376 22/05/2022 Crystal Palace     Man United    1    0   H    1    0   H
## 377 377 22/05/2022      Leicester    Southampton    4    1   H    0    0   D
## 378 378 22/05/2022      Liverpool         Wolves    3    1   H    1    1   D
## 379 379 22/05/2022       Man City    Aston Villa    3    2   H    0    1   A
## 380 380 22/05/2022        Norwich      Tottenham    0    5   A    0    2   A
##          Referee HS AS HST AST HF AF HC AC HY AY HR AR
## 1       M Oliver  8 22   3   4 12  8  2  5  0  0  0  0
## 2      P Tierney 16 10   8   3 11  9  5  4  1  2  0  0
## 3        D Coote 14 14   3   8 10  7  7  6  2  1  0  0
## 4         J Moss 13  4   6   1 15 11  5  2  0  0  0  0
## 5       A Madley 14  6   6   3 13 15  6  8  2  0  0  0
## 6       C Pawson  9 17   5   3  6 10  5  4  1  2  0  0
## 7         M Dean 13 11   7   2 18 13  2  4  3  1  0  0
## 8     A Marriner 14 19   3   8  4 14  3 11  1  1  0  0
## 9     M Atkinson 17  8   3   9  4  3  7  6  1  0  0  0
## 10      A Taylor 13 18   3   4 11  8  3 11  2  1  0  0
## 11        M Dean 27  9   9   3  6 12  8  4  0  0  0  0
## 12       D Coote 10  9   2   1  8 18  3  4  3  4  0  0
## 13    M Atkinson  7 14   2   3 12  9  3  5  3  1  0  0
## 14     D England 17 17   4   8  6 13  8  5  2  4  0  0
## 15       G Scott 16  1   4   0 13  7  6  1  1  0  0  0
## 16      A Taylor 13 10   3   1 11  6  7  2  4  0  0  0
## 17      C Pawson  8 15   3   4 12 10  7  7  2  3  0  0
## 18     S Attwell 25  8   6   6  9  7  5  4  1  4  0  0
## 19     P Tierney  6 22   3   5 10  4  9  8  3  0  0  0
## 20      M Oliver 13  5   7   1  8  8 10  0  0  1  0  1
## 21    M Atkinson 25  1  10   0  5  7 14  0  1  2  0  1
## 22      P Bankes  7  9   5   2 15 14  3  2  3  3  0  0
## 23        J Moss 14 14   3   5  7  9  4  5  1  2  0  0
## 24     P Tierney 10 22   5   6 11  6  4  4  3  3  0  0
## 25       R Jones 14  9   4   3  8  9  9  9  2  1  0  0
## 26     S Attwell 14  9   4   2 10  7  5  3  1  0  0  0
## 27      A Taylor 24  6   7   3 13  4 12  3  0  2  0  1
## 28      M Oliver 12 12   3   2 13  9  5  5  4  3  0  0
## 29    A Marriner 15  9   8   2  8 14 10  3  3  3  0  0
## 30        M Dean 15 10   6   3  7  9  5  7  3  4  0  0
## 31        J Moss 18  2   4   1 13 15  8  2  2  1  0  1
## 32      M Oliver 30 10   7   1  9 11  8  4  1  2  0  0
## 33       G Scott  7  4   1   2  9 12  1  6  3  2  0  0
## 34     P Tierney  6 25   1   8  4 11  5  8  1  2  0  0
## 35      A Taylor 21 12   7   3  9  2  7  3  1  0  0  0
## 36       D Coote 11 13   3   3 10 12  5  4  3  1  0  1
## 37      P Bankes  6 14   2   5 15 13  6  8  3  3  0  0
## 38     S Attwell 12 18   4   6 11 11  4 11  1  4  0  0
## 39      C Pawson  9 30   4   9  9  8  2 11  2  1  1  0
## 40    M Atkinson 14 11   6   6  3  6  4  6  1  1  0  0
## 41        M Dean 17 22   7   9  9 11  4  5  2  2  0  0
## 42     D England 11  9   0   3 10  7  4  2  4  2  0  1
## 43      A Taylor 18 13   3   3  9  8  8  3  2  1  0  0
## 44      A Madley 25 13  10   2 17 11 10  5  3  1  0  0
## 45        J Moss 18 10   1   2  5 12  8  5  0  2  0  0
## 46       R Jones 12 12   5   8 10 14  4  8  1  1  0  0
## 47      C Pawson 15 11   3   1  7 10  5  4  1  1  0  0
## 48     S Attwell 12 14   5   3  8 10  4  9  2  1  0  0
## 49    M Atkinson 13 17   4  10  5  8  2 11  0  0  0  0
## 50     P Tierney  8 20   2  10  4 15  5 11  0  1  0  0
## 51      M Oliver  5 15   0   4 12 10  4 13  3  2  0  0
## 52        M Dean 28  7   4   3  9 13  5  5  2  2  0  0
## 53       D Coote 11 10   4   2 12  9  6  4  2  3  0  0
## 54      K Friend 15 20   5   7 10  6  5  7  3  2  0  0
## 55    C Kavanagh 22  9   5   3 10  8  8  4  2  4  0  0
## 56     J Gillett 15 20   4   6 19 12  5  6  4  3  0  0
## 57     S Attwell 12 16   4   6  8  7  2 11  1  1  0  0
## 58      A Madley 18  5   6   3 12  8  5  5  0  0  0  0
## 59      C Pawson 12 10   7   4 12 13  4  4  2  1  0  0
## 60    A Marriner  8  8   3   4 12 10  6  5  2  3  0  0
## 61      M Oliver 13 12   6   2 10  9 10  1  1  1  0  0
## 62      K Friend 14 10   4   2 13  3  9  5  5  2  0  0
## 63    M Atkinson 20  6   9   2 11 13  7  2  1  3  0  1
## 64      S Hooper 20  5   4   1 10 16  6  3  0  3  0  0
## 65       G Scott  7  8   3   2 15  5  0  4  0  2  0  0
## 66        J Moss 21  8   2   2  8  5  8  5  2  1  0  0
## 67      A Taylor 18  9   4   5 15 11  1  3  2  3  0  0
## 68    C Kavanagh 17 14   8   3 11 14  5  8  2  1  0  0
## 69      P Bankes 18 13   5   6 16 13 11  6  2  3  0  0
## 70     P Tierney  6 12   4   3 10 12  3  4  3  3  0  0
## 71        J Moss  6 19   2   8  4 10  1  9  0  0  0  0
## 72      M Oliver 14  9   5   4  8 17  6  7  2  3  0  0
## 73      C Pawson 22 18  11   6  5 17  4  3  0  3  0  0
## 74    M Atkinson 15  7   6   2 11  5  6  2  1  0  0  0
## 75      P Bankes 15 11   3   3  5 14  8  4  3  5  0  0
## 76       D Coote 19  3   5   0 16 14  8  1  2  3  0  0
## 77      A Taylor 17  5   7   1 13  8  5  5  1  1  0  0
## 78     S Attwell 15 16   2   4  3  3  7  9  0  2  0  0
## 79    A Marriner  7 14   1   4 13  4  2  9  4  1  1  0
## 80        M Dean 17  9   6   6  7  4  6  4  1  1  0  0
## 81      C Pawson 22 10   9   4 17 10  7  4  2  5  0  0
## 82      A Madley 23  3  13   1 14 16  5  0  0  2  0  1
## 83     D England 15  6   3   2 13  9  3  7  3  4  0  0
## 84       G Scott 15 20   4   8  9 13  3  5  4  3  0  0
## 85       R Jones 18  8   4   4 15 14  6  3  2  3  0  0
## 86    C Kavanagh 16  9   4   5 10 11  6  2  1  3  0  0
## 87      K Friend 10 23   5  14 10  6  7  6  2  3  0  0
## 88      S Hooper 15 10   5   6 13  7  9  2  1  1  0  0
## 89     P Tierney 13  7   4   4 11  4  2  4  2  1  0  0
## 90      A Taylor 12 19   4   8 10  8  6  3  6  0  1  0
## 91      M Oliver 16  9   8   5  8 11  7  6  2  0  0  0
## 92        J Moss 15 12   6   5  7 10  4  2  1  1  0  0
## 93        M Dean 14  9   3   6  8  5  5  3  2  2  0  0
## 94    A Marriner 14  8   3   3 11 11  7  1  2  3  1  0
## 95     P Tierney  6 19   1   6 14 12  0  2  3  2  0  0
## 96      P Bankes 10 12   4   1 16  6  5  8  2  2  0  0
## 97     S Attwell  9 10   0   4 12 14 10  2  2  3  0  0
## 98      A Taylor 14 13   3   6 14 23  5  0  1  4  0  0
## 99    C Kavanagh  9 21   3   9  7 13  3  6  1  2  1  0
## 100   M Atkinson 10 14   4   5 10  8  4  3  1  1  0  0
## 101     A Madley  9 14   3   3 12 12 10  8  2  2  0  0
## 102     M Oliver  5 16   1   5  9 12  1  9  1  2  0  0
## 103    J Gillett 19  9   7   5 12 13  6  2  2  3  0  0
## 104   A Marriner 25  5   4   2  6  9 14  2  1  4  0  0
## 105      G Scott 13  4   6   2 14 13  4  6  2  1  0  0
## 106      D Coote 14  6   5   1 16 10  2  5  3  4  1  0
## 107     K Friend 14  7   6   1  6 19  4  2  4  2  0  1
## 108   C Kavanagh 12  8   2   0 13 17  4  2  2  4  1  0
## 109    D England 18  9   5   3 12  5 10  5  1  1  0  0
## 110     C Pawson  7 16   3   5 11  6  3  2  1  1  0  0
## 111    P Tierney  4 16   3   7 15  8  3  5  3  1  0  0
## 112     A Taylor  9  6   5   2  7 13  5  7  3  3  0  0
## 113     S Hooper 15 18   9   8 14 15  3  6  2  3  0  0
## 114      R Jones 23 10   9   4 13 11  8  2  2  2  0  0
## 115   M Atkinson  8 17   4   5  8  9  5  7  3  2  0  0
## 116       J Moss 20  9   7   3  7  5  9  3  2  1  0  1
## 117       M Dean 15  8   5   3  6  9  7  3  1  1  0  0
## 118     M Oliver 19  5   9   3 15 12  6  1  2  0  0  0
## 119    S Attwell 17  4   7   1  5  7  7  1  1  1  0  0
## 120   A Marriner 13 18   4   7 11 12  4  8  1  4  0  0
## 121    S Attwell 24  9   6   5  6 12  4  4  1  3  0  0
## 122  M Salisbury  8 10   3   3 12 10  7  3  3  3  0  0
## 123   A Marriner 20  7   6   3  7 14  5  7  0  1  0  0
## 124     S Hooper 14  5   4   2 11 10  4  3  2  2  0  0
## 125     C Pawson 20 11   4   4 12 14  6  1  1  3  0  0
## 126    D England  6 14   4   5  8 11  3  3  4  3  0  0
## 127     A Madley 18 16   8   5  5 19  8  6  0  0  0  0
## 128     M Oliver 19  5   9   3  7  6  8  4  2  0  0  0
## 129     A Taylor 24  3   6   2 13 14 15  2  2  5  0  0
## 130     A Madley  9 16   1   6  8 11  2  5  0  0  0  1
## 131     K Friend 15  9   3   1 15 15  7  4  5  3  0  0
## 132      R Jones 15 15   7   6 14 11  2  4  1  3  0  0
## 133      D Coote 13  8   6   4 18 16  6  0  4  3  0  0
## 134   C Kavanagh 14  9   6   3 10  8  9  5  1  1  0  0
## 135     J Brooks 16  6   2   1  5  7  5  5  2  3  0  0
## 136       M Dean  9 17   3   7  8 12  4 11  0  0  0  0
## 137    P Tierney  8 16   2   7  8 16  3 11  4  3  0  0
## 138       J Moss 11  6   6   2 13 11 11  5  0  0  0  0
## 139   M Atkinson 14 17  10   8  9 10  3  8  1  0  0  0
## 140   A Marriner 11 19   5   7 10 10  1  9  1  3  0  0
## 141    P Tierney 19 10   4   1 11  9 10  3  1  1  0  0
## 142     A Taylor 14 14   4   4 15 12  6  2  4  2  0  0
## 143   C Kavanagh  3 17   1   5  4  7  2  8  2  2  0  0
## 144     S Hooper 11 26   4  13 10  7  5 11  3  0  0  0
## 145      D Coote 13  9   6   3 11  9  5  1  5  3  0  0
## 146     C Pawson 16  8   3   2 16  9  9  6  2  2  0  0
## 147    J Gillett 17 10   7   1 11  4  6  4  1  2  0  0
## 148     M Oliver 13 12   4   5  8 25  3  6  1  1  0  0
## 149       M Dean 11 10   5   3  8 12  3  3  2  2  0  0
## 150     M Oliver 14  6   5   2 12 18  8  2  4  0  0  0
## 151       J Moss 24  2  10   1 12  5 14  1  3  2  0  1
## 152    J Gillett 15 11   5   6  5  9  9  8  2  0  0  0
## 153   C Kavanagh 16 12   6   5  9 15  5  2  2  5  0  0
## 154    S Attwell 20  4   5   0 13  6 11  3  1  2  0  0
## 155    D England 11 13   5   5  6 17  8  6  1  1  0  0
## 156      G Scott  9 16   1   3 13 11  6  4  2  1  0  0
## 157     P Bankes  8 12   5   3  9 16  4  6  2  3  0  0
## 158     A Madley 17 12   6   6 15 14  8  2  0  2  0  0
## 159      D Coote  7 17   3   6 12  9  7 10  3  1  0  0
## 160    P Tierney 31  6  15   3  5  9  6  2  1  1  0  0
## 161 T Harrington 12  8   2   5 11 14  7  4  2  0  0  0
## 162     S Hooper  9 15   6   4 16 20  4  6  2  4  0  0
## 163     A Taylor 21  7   8   1  8  9  5  2  2  0  0  1
## 164     M Oliver 23  5  10   3 11 11  7  1  2  3  0  0
## 165       M Dean 23  4   8   2  9  4 11  0  1  3  0  0
## 166   A Marriner  9 21   2  12 11  7  1  4  3  1  0  0
## 167   M Atkinson  5 18   1   7  9  6  3  6  1  2  0  0
## 168      D Coote  4  8   1   1  9  7  4  9  0  2  0  0
## 169    P Tierney 10 18   5   6 12 11  6  4  4  4  0  1
## 170   C Kavanagh 17 14   9   8 11  9 14  4  1  2  0  0
## 171      G Scott  4 16   2   6 13  7  3  5  1  2  0  0
## 172       J Moss 17  4   6   0 16 10  4  2  1  1  0  1
## 173     K Friend 11 11   5   6 10  9 10  2  2  3  0  0
## 174   M Atkinson  8 10   1   4  8 11  2  5  3  1  0  0
## 175    D England 15 16   5   6  8 10  6  9  1  3  0  0
## 176     C Pawson 13 13   8   4 11  8  2  4  3  3  0  0
## 177    P Tierney 19 12   6   3  9 13  8  8  1  2  0  0
## 178     A Taylor  9 21   2  11 15  5  3  7  2  2  1  0
## 179    D England 14 13   5   6 12 12  4  5  0  1  0  0
## 180     M Oliver  6 21   1   4  8 11  1 12  0  1  0  0
## 181       M Dean 11 18   5   6 14  7 10  8  4  1  0  0
## 182      D Coote  6 12   2   3 12 10  3  5  0  0  0  0
## 183       J Moss 18 10   6   3  5 10  7  5  0  0  0  0
## 184    S Attwell  7 15   2   2 13  5  5  5  3  2  1  0
## 185      R Jones  6 21   4   9  6  9  3  7  0  1  0  0
## 186    D England 22 10   6   5  6 16  9  1  0  2  0  0
## 187     C Pawson 10 16   4   5 17 11  3  7  2  2  0  0
## 188     J Brooks 17 12   6   5  5 12  8  5  1  1  0  0
## 189    P Tierney 22  8   7   2 11  7  9  3  2  1  0  0
## 190     A Taylor 15 10   6   6  5 13  6  7  1  2  0  0
## 191       M Dean  9 19   2   6  9  8  3  8  3  1  0  0
## 192    S Attwell 12  5   6   4  9  8  5  2  0  1  0  0
## 193     S Hooper 13  7   5   3  9  8 11  2  0  0  0  0
## 194      R Jones 19  3   4   1 11  7  9  0  0  2  0  0
## 195     C Pawson 11  4   6   1 11  6  9  1  0  2  0  0
## 196    P Tierney 12 18   1   5 13 13  4  6  3  2  0  0
## 197     A Madley 14 12   3   5 12 14  8  8  3  1  0  0
## 198  M Salisbury  9 13   5  10 13 14  2 10  2  3  0  0
## 199      D Coote 13 13   9   6  8 13  3  6  1  2  0  0
## 200       J Moss 27  6  13   1  6  6  9  0  0  1  0  0
## 201       M Dean 15 18   5   5  6  9  4  3  3  2  0  0
## 202     K Friend 10 15   2   3  8  5  5  7  1  2  0  0
## 203       J Moss 14 27   4  10  6 12  3  8  1  2  0  0
## 204   A Marriner 18 13   8   5  7  9  6  9  0  0  0  0
## 205       M Dean 15  7   4   2 16 11  5  1  0  1  1  0
## 206     C Pawson 15  8   1   3 14 16  9  2  5  3  0  0
## 207     P Bankes 11  7   1   2  6  7  6  3  2  3  0  0
## 208   C Kavanagh 13 15   4   3  9  9  6  7  4  2  0  0
## 209       J Moss 18  6   3   1  9  8  3  3  1  1  0  0
## 210     S Hooper  7 20   3   5 13  5  2 11  3  0  0  0
## 211      D Coote 20 10   5   1  9 13 12  4  0  2  0  0
## 212     K Friend  8 15   5   7 12 10  2  5  4  1  0  0
## 213   M Atkinson 15 14   5   5  6  8  4  5  0  1  0  0
## 214    P Tierney 15  6   7   3 17 14 10  3  2  1  0  0
## 215     C Pawson 13 11   2   5 16  9  4  7  1  2  0  0
## 216     A Taylor 20 11   9   3 13 13  6  2  2  3  0  0
## 217   M Atkinson  9  6   3   1  1  6  5  6  1  0  0  0
## 218       M Dean  9 22   3   5 11 10  2 10  2  1  0  0
## 219    D England 15  6   7   2  7 13  9  3  0  0  0  0
## 220    P Tierney  5 13   1   5 11 15  4  6  1  2  0  0
## 221      D Coote  8 23   3  10  7 13  2  8  2  3  0  0
## 222    J Gillett 12 16   4   8 11  9  6 11  1  3  1  0
## 223   C Kavanagh 22  5  11   1 11  7  7  6  1  0  0  0
## 224     M Oliver 15 12   4   2 12 13  7  4  2  3  0  1
## 225    S Attwell 12 13   8   4 12 13  1  4  4  0  0  0
## 226     S Hooper  9  6   2   3 10 10  3  9  1  0  0  0
## 227      G Scott 21  7  10   0  8  9  5  3  1  1  0  0
## 228       J Moss  9 11   1   6 16  9  4  5  3  2  0  0
## 229   A Marriner  8 22   3   9  7  8  4 12  0  2  0  0
## 230   M Atkinson  8 12   5   4  7  6  5  8  0  1  0  0
## 231     C Pawson 10 11   2   1 22 15  3  6  3  4  0  0
## 232     K Friend 17 11   7   7 13 13  7  3  3  1  0  0
## 233     M Oliver 13  8   2   3 10  9  5  4  1  2  0  0
## 234     P Bankes 19 10   7   3  8 10 10  2  3  1  0  1
## 235   C Kavanagh 11 14   3   3  3  7  3  7  3  3  0  0
## 236       J Moss 24  6   8   2 10  5 14  0  1  1  0  0
## 237      R Jones 20  8   1   4 12  7 10  5  1  2  0  0
## 238     K Friend 11 10   1   4 12 12  4  4  1  4  0  0
## 239      D Coote  7  9   0   3  4 20  4  4  1  3  0  0
## 240       M Dean 29  6   8   1  7  8  9  4  0  1  0  0
## 241     A Madley 19  9  11   0  6  9  4  4  0  2  0  0
## 242     A Taylor 21  6   4   5  5  7 10  0  0  3  0  0
## 243    P Tierney 16 15   6   9 13 19  3  3  6  3  0  0
## 244     C Pawson 11 17   3   7 12  9  7 10  4  4  0  0
## 245      G Scott 15 12   4   2  8  8  3  7  0  0  0  0
## 246   A Marriner  8  7   1   5 12  9  6  4  2  1  0  0
## 247     M Oliver 23  3  15   2  5 11  4  0  0  3  0  0
## 248   M Atkinson 26  6   5   2  8  9  5  4  1  1  0  0
## 249     S Hooper 27  8   9   1 12  9 13  6  1  2  0  0
## 250     C Pawson 19 15   3  11 16 11  3  6  4  2  0  0
## 251       M Dean  6 26   1  11  9  7  6  6  3  1  1  0
## 252       J Moss 11  5   4   1  5 17  5  4  0  2  0  0
## 253     K Friend 22 10   3   2  2  7  4  3  0  0  0  0
## 254     J Brooks 12  9   1   4 17 11  7  2  4  5  0  0
## 255    P Tierney  6 13   2   8  7 14  3  4  3  2  0  0
## 256     A Taylor 13 14   4   1  8  2  3  5  1  0  0  0
## 257   C Kavanagh  9 22   2   6 10 13  6  8  1  1  0  0
## 258      D Coote  7 19   4   4  9 12  5 10  1  2  0  0
## 259     P Bankes 14 11   9   1 10  8  4  7  1  1  0  0
## 260   A Marriner  6 11   1   5 12  7  5  2  2  0  0  0
## 261   M Atkinson 10 15   4   4  8 10  4  7  1  1  0  0
## 262     A Taylor 15 10   7   6 13 18  5  5  2  5  0  0
## 263     A Madley 12 12   5   8 13  8  7  7  0  3  0  0
## 264       J Moss 22 13   5   5  7  7  4  6  2  1  0  0
## 265     C Pawson 13 16   7   4  5 11  1  5  1  2  0  0
## 266     M Oliver 24  5  10   2 10 14  9  3  0  1  0  0
## 267    S Attwell 14  6   7   0 15 10  5  2  2  0  0  0
## 268   M Atkinson  9 15   3   7  8 15  3  8  0  2  0  0
## 269     K Friend 14  8   5   4  6  7 12  5  1  1  0  0
## 270    D England 10  9   5   0 11 10  5  2  2  2  0  0
## 271     S Hooper  4 15   1   9 17 11  3  5  5  3  0  0
## 272       M Dean  8 18   3   9 12 15  7  6  3  1  0  0
## 273    P Tierney 13  7   4   1  6 10  2  9  1  1  0  1
## 274       J Moss 10 10   6   3  8  7  4  5  2  1  0  0
## 275      D Coote  8  7   3   2 17 16  7  2  4  3  0  0
## 276     M Oliver  8 14   2   3 13 11  5  2  2  1  1  0
## 277    S Attwell 13 12   7   4 18  8  6  2  3  1  0  0
## 278      G Scott 13  9   7   5  8 12 11  3  3  2  0  0
## 279    J Gillett 11 13   4   7  9  3  5  7  1  0  0  0
## 280     A Taylor 21  6   8   3  8 10  2  6  0  3  0  0
## 281   M Atkinson  7 18   1   4  6 11  2  6  3  1  0  0
## 282      R Jones 15 17   0   7 11  9  6  3  2  2  0  0
## 283   A Marriner  9  9   2   3  9  9  1  6  0  1  0  0
## 284     C Pawson  9 17   3   6 13 11  5  7  2  1  1  0
## 285     K Friend 14 15   8   6 13 14  2  5  1  4  1  0
## 286     A Madley  8 10   1   3 13 14  6  5  3  3  0  0
## 287    D England 12 15   4   6 10 10  2  5  1  2  0  0
## 288     A Taylor 17  6   4   1  7  7  5  3  0  1  0  0
## 289    S Attwell 20  5   3   2  9  8  9  3  1  1  0  0
## 290     S Hooper 31  6   4   0 12 11 11  2  1  1  0  0
## 291     C Pawson  3 18   1   6 11  6  1  8  1  0  0  0
## 292     A Madley 21 17   8   6 11  7 12  7  0  0  0  0
## 293     A Taylor 12 14   3   6 14  7  4  7  1  1  0  0
## 294    D England 11 15   5   5 15  8  4  9  4  3  0  0
## 295   A Marriner 11 11   5   3 13  6  6  5  2  2  0  0
## 296     M Oliver 11 13   5   2  9 12  2  4  1  1  0  1
## 297   M Atkinson 19  8   6   1 10  7  2  3  2  3  0  0
## 298    P Tierney  6 12   5   3 11 15  0  2  0  2  0  0
## 299       M Dean 13 16   4   4 11 16  9  6  2  2  0  0
## 300     P Bankes 12  5   4   2  6 13  1  2  1  1  0  0
## 301       J Moss  7 12   3   4  4 10  5  7  2  2  0  0
## 302      D Coote 20  8   4   3 12 19 11  2  3  4  0  0
## 303     K Friend  4 24   1  14 11 10  3  3  1  0  0  0
## 304   A Marriner  8 10   1   5  8 12  3  8  2  0  0  0
## 305      G Scott  9 11   8   5 12 14  9  3  2  3  0  0
## 306   M Atkinson 15  5   7   1  2  6  4  6  0  1  0  0
## 307      R Jones 12 11   3   3 11 12  3  4  1  1  0  0
## 308     M Oliver 17 18   6   4 12 10  6  7  1  1  0  0
## 309     A Taylor 11  6   5   4  9 11  4  1  1  4  0  0
## 310     C Pawson  5 12   0   5 14 10  4  4  3  3  0  0
## 311     A Madley 20 15   9   4  7  6  6  7  0  0  0  0
## 312     P Bankes  9 23   3   6  6  6  6  8  2  1  0  0
## 313     S Hooper 17 16   4   5 11  9  6  5  2  1  0  0
## 314    J Gillett 16  8   7   2 10 10  3  5  2  2  0  0
## 315    P Tierney 21  9   8   1  9 10 13  4  2  2  0  0
## 316   M Atkinson 14  2   5   1  3  6 10  2  1  2  0  0
## 317       J Moss 11 14   2   4  7  6  6  1  3  1  0  0
## 318      D Coote 13 11   3   3  8 17  5  4  3  1  0  0
## 319 T Harrington 13 10   4   2 12 12  2  5  1  1  0  0
## 320       M Dean 17  2   5   1 12  7  7  4  0  3  0  0
## 321    S Attwell 16 11   6   3  7  7 10 10  2  2  0  0
## 322     C Pawson 14 14   7   5  9 12  1  7  3  4  0  0
## 323     A Madley  5 11   2   3 15 16  7  6  3  2  0  0
## 324     K Friend 21  5   8   2  9  7 11  4  1  0  0  0
## 325   C Kavanagh  5 13   2   7 11 10  2  3  0  2  0  0
## 326   M Atkinson 15  9   2   0  8  7 12  8  2  1  0  0
## 327      R Jones  8 18   5   5 12  7  6  6  1  0  0  0
## 328     A Taylor 14 10   5   4  8  7  3  6  3  1  0  0
## 329     M Oliver 26  6   5   2 11  9  3  1  1  0  0  1
## 330    S Attwell 18  9   4   1  8  8 13  1  2  5  0  0
## 331    D England 17  9   7   2 12 13  6  3  2  2  0  0
## 332       M Dean  6 21   3   6  9 12  2  9  0  1  0  0
## 333   A Marriner  4 24   2  10 11 11  0  6  1  3  0  0
## 334     J Brooks 21  9   6   3 16  8  2  3  4  1  0  0
## 335    J Gillett  8 14   3   5 13 11  6  7  1  3  0  0
## 336     C Pawson 13 17   1   6 13  9  5  6  1  2  0  0
## 337     S Hooper 11 17   1   9  6  4  7  3  2  1  0  0
## 338    P Tierney  7 19   2   6 13  3  3  6  1  2  0  0
## 339     K Friend  9 17   4   5  9 12  3  8  3  5  0  0
## 340       J Moss 13  6   7   2 13  8  7  3  2  3  0  0
## 341       M Dean  8 13   3   7  8  9  3  7  2  2  0  0
## 342   C Kavanagh  9 12   5   4  4  6  3  8  1  0  0  0
## 343  M Salisbury 18 19   5   4 12  9  4  7  0  1  0  0
## 344      D Coote 14 12   6   7 13 11  4  5  1  2  0  0
## 345     P Bankes 19 14   6   4  7 11  9  3  1  3  0  0
## 346      G Scott 15  6   7   1 11 18  8  5  2  1  0  1
## 347     A Madley 17 15   6   5 13  9  7  6  0  2  0  0
## 348     M Oliver 22  8   3   3 12  8 11  5  3  2  0  0
## 349   C Kavanagh 19  3   9   2 13 15  8  2  2  2  0  1
## 350     C Pawson 16 10   9   4 11  6  6  1  3  0  0  0
## 351      R Jones  8 13   2   5  7  7  9  5  1  1  0  0
## 352    S Attwell 21  7   9   3  6 11  8  2  1  3  0  0
## 353       J Moss  9 17   4   6 10 12  2  3  0  0  0  0
## 354     A Taylor  5 17   0   4 10 14  1  5  1  0  1  0
## 355     S Hooper 20  9   8   5 10  5 10  2  0  0  0  0
## 356       M Dean  6 16   0   5  5 12  1 13  1  2  0  0
## 357   M Atkinson  7 16   3   5  2 10  6  2  0  1  0  0
## 358    P Tierney 16  8   6   4  8 15  2  2  1  3  0  1
## 359     K Friend 21  8   8   1 12  8  8  2  3  2  0  0
## 360   C Kavanagh 13 16   4   4 11 15  1  5  1  3  0  0
## 361       M Dean 19 16   5   6 16  8  8  1  3  2  0  0
## 362    J Gillett 13 13   5   7  4  6  7  3  0  1  0  0
## 363     A Taylor  6 31   2   8  9  5  4  9  3  1  0  0
## 364 T Harrington 17 11   4   2  5 10  5  3  0  3  0  0
## 365     M Oliver 10 18   5   7  8  8  5  2  0  3  2  0
## 366    D England 16 11   4   2 11  8 12  8  0  3  0  0
## 367   M Atkinson  4 24   2   5  6  6  1  9  2  0  0  0
## 368     A Taylor 12  7   6   5  9 13  4  5  2  3  0  0
## 369    P Tierney 22 10   9   5 11 20 13  6  0  1  0  1
## 370    S Attwell 20  2   7   1 13  7  6  0  4  1  0  0
## 371   A Marriner 26  6   9   2  8  9 12  2  0  1  0  0
## 372    P Tierney 14 14   5   6 11 13  3  2  2  1  1  0
## 373     K Friend 18  7   7   2  9  9  5  6  1  1  0  0
## 374     C Pawson 12  8   5   6  8  9  8  2  1  0  0  0
## 375       M Dean 19  8   8   3  9  9  3  3  0  0  0  0
## 376   M Atkinson  6 10   3   4 12 22  3  6  2  4  0  0
## 377       J Moss 12  7   6   2 10  5  3  3  0  1  0  0
## 378     A Taylor 29  7   8   5  6  3  5  3  1  0  0  0
## 379     M Oliver 24  4   5   2  5 11 13  1  0  1  0  0
## 380   C Kavanagh  9 19   0  13 13  7  3  2  3  1  0  0

Apply the following dplyr verbs to your data

Filter rows

filter(data, FTR == "H")
##       X       Date       HomeTeam       AwayTeam FTHG FTAG FTR HTHG HTAG HTR
## 1     1 13/08/2021      Brentford        Arsenal    2    0   H    1    0   H
## 2     2 14/08/2021     Man United          Leeds    5    1   H    1    0   H
## 3     4 14/08/2021        Chelsea Crystal Palace    3    0   H    2    0   H
## 4     5 14/08/2021        Everton    Southampton    3    1   H    0    1   A
## 5     6 14/08/2021      Leicester         Wolves    1    0   H    1    0   H
## 6     7 14/08/2021        Watford    Aston Villa    3    2   H    2    0   H
## 7    10 15/08/2021      Tottenham       Man City    1    0   H    0    0   D
## 8    11 21/08/2021      Liverpool        Burnley    2    0   H    1    0   H
## 9    12 21/08/2021    Aston Villa      Newcastle    2    0   H    1    0   H
## 10   15 21/08/2021       Man City        Norwich    5    0   H    2    0   H
## 11   16 21/08/2021       Brighton        Watford    2    0   H    2    0   H
## 12   20 23/08/2021       West Ham      Leicester    4    1   H    1    0   H
## 13   21 28/08/2021       Man City        Arsenal    5    0   H    3    0   H
## 14   29 29/08/2021      Tottenham        Watford    1    0   H    1    0   H
## 15   31 11/09/2021 Crystal Palace      Tottenham    3    0   H    0    0   D
## 16   32 11/09/2021        Arsenal        Norwich    1    0   H    0    0   D
## 17   35 11/09/2021     Man United      Newcastle    4    1   H    1    0   H
## 18   38 11/09/2021        Chelsea    Aston Villa    3    0   H    1    0   H
## 19   40 13/09/2021        Everton        Burnley    3    1   H    0    0   D
## 20   44 18/09/2021      Liverpool Crystal Palace    3    0   H    1    0   H
## 21   47 18/09/2021    Aston Villa        Everton    3    0   H    0    0   D
## 22   48 19/09/2021       Brighton      Leicester    2    1   H    1    0   H
## 23   53 25/09/2021        Everton        Norwich    2    0   H    1    0   H
## 24   59 26/09/2021        Arsenal      Tottenham    3    1   H    3    0   H
## 25   63 02/10/2021        Chelsea    Southampton    3    1   H    1    0   H
## 26   64 02/10/2021          Leeds        Watford    1    0   H    1    0   H
## 27   65 02/10/2021         Wolves      Newcastle    2    1   H    1    1   D
## 28   68 03/10/2021      Tottenham    Aston Villa    2    1   H    1    0   H
## 29   73 16/10/2021      Leicester     Man United    4    2   H    1    1   D
## 30   74 16/10/2021       Man City        Burnley    2    0   H    1    0   H
## 31   76 16/10/2021    Southampton          Leeds    1    0   H    0    0   D
## 32   81 22/10/2021        Arsenal    Aston Villa    3    1   H    2    0   H
## 33   82 23/10/2021        Chelsea        Norwich    7    0   H    3    0   H
## 34   89 24/10/2021       West Ham      Tottenham    1    0   H    0    0   D
## 35   92 30/10/2021        Burnley      Brentford    3    1   H    3    0   H
## 36  100 01/11/2021         Wolves        Everton    2    1   H    2    0   H
## 37  101 05/11/2021    Southampton    Aston Villa    1    0   H    1    0   H
## 38  105 06/11/2021 Crystal Palace         Wolves    2    0   H    0    0   D
## 39  107 07/11/2021        Arsenal        Watford    1    0   H    0    0   D
## 40  110 07/11/2021       West Ham      Liverpool    3    2   H    1    1   D
## 41  112 20/11/2021    Aston Villa       Brighton    2    0   H    0    0   D
## 42  115 20/11/2021        Norwich    Southampton    2    1   H    1    1   D
## 43  116 20/11/2021        Watford     Man United    4    1   H    2    0   H
## 44  117 20/11/2021         Wolves       West Ham    1    0   H    0    0   D
## 45  118 20/11/2021      Liverpool        Arsenal    4    0   H    1    0   H
## 46  119 21/11/2021       Man City        Everton    3    0   H    1    0   H
## 47  120 21/11/2021      Tottenham          Leeds    2    1   H    0    1   A
## 48  121 27/11/2021        Arsenal      Newcastle    2    0   H    0    0   D
## 49  123 27/11/2021      Liverpool    Southampton    4    0   H    3    0   H
## 50  126 28/11/2021      Brentford        Everton    1    0   H    1    0   H
## 51  127 28/11/2021      Leicester        Watford    4    2   H    3    1   H
## 52  128 28/11/2021       Man City       West Ham    2    1   H    1    0   H
## 53  131 30/11/2021          Leeds Crystal Palace    1    0   H    0    0   D
## 54  138 02/12/2021      Tottenham      Brentford    2    0   H    1    0   H
## 55  139 02/12/2021     Man United        Arsenal    3    2   H    1    1   D
## 56  140 04/12/2021       West Ham        Chelsea    3    2   H    1    2   A
## 57  141 04/12/2021      Newcastle        Burnley    1    0   H    1    0   H
## 58  146 05/12/2021     Man United Crystal Palace    1    0   H    0    0   D
## 59  147 05/12/2021      Tottenham        Norwich    3    0   H    1    0   H
## 60  148 05/12/2021    Aston Villa      Leicester    2    1   H    1    1   D
## 61  149 06/12/2021        Everton        Arsenal    2    1   H    0    1   A
## 62  150 10/12/2021      Brentford        Watford    2    1   H    0    1   A
## 63  151 11/12/2021       Man City         Wolves    1    0   H    0    0   D
## 64  152 11/12/2021        Arsenal    Southampton    3    0   H    2    0   H
## 65  153 11/12/2021        Chelsea          Leeds    3    2   H    1    1   D
## 66  154 11/12/2021      Liverpool    Aston Villa    1    0   H    0    0   D
## 67  157 12/12/2021      Leicester      Newcastle    4    0   H    1    0   H
## 68  158 12/12/2021 Crystal Palace        Everton    3    1   H    1    0   H
## 69  160 14/12/2021       Man City          Leeds    7    0   H    3    0   H
## 70  163 15/12/2021        Arsenal       West Ham    2    0   H    0    0   D
## 71  165 16/12/2021      Liverpool      Newcastle    3    1   H    2    1   H
## 72  170 26/12/2021       Man City      Leicester    6    3   H    4    0   H
## 73  172 26/12/2021      Tottenham Crystal Palace    3    0   H    2    0   H
## 74  175 26/12/2021       Brighton      Brentford    2    0   H    2    0   H
## 75  177 28/12/2021 Crystal Palace        Norwich    3    0   H    3    0   H
## 76  180 28/12/2021      Leicester      Liverpool    1    0   H    0    0   D
## 77  183 30/12/2021     Man United        Burnley    3    1   H    3    1   H
## 78  187 02/01/2022      Brentford    Aston Villa    2    1   H    1    1   D
## 79  189 02/01/2022          Leeds        Burnley    3    1   H    1    0   H
## 80  192 11/01/2022    Southampton      Brentford    4    1   H    2    1   H
## 81  193 12/01/2022       West Ham        Norwich    2    0   H    1    0   H
## 82  195 15/01/2022       Man City        Chelsea    1    0   H    0    0   D
## 83  197 15/01/2022        Norwich        Everton    2    1   H    2    0   H
## 84  198 15/01/2022         Wolves    Southampton    3    1   H    1    0   H
## 85  200 16/01/2022      Liverpool      Brentford    3    0   H    1    0   H
## 86  209 22/01/2022     Man United       West Ham    1    0   H    0    0   D
## 87  214 23/01/2022        Chelsea      Tottenham    2    0   H    0    0   D
## 88  216 08/02/2022      Newcastle        Everton    3    1   H    1    1   D
## 89  217 08/02/2022       West Ham        Watford    1    0   H    0    0   D
## 90  219 09/02/2022       Man City      Brentford    2    0   H    1    0   H
## 91  223 10/02/2022      Liverpool      Leicester    2    0   H    1    0   H
## 92  227 12/02/2022        Everton          Leeds    3    0   H    2    0   H
## 93  231 13/02/2022      Newcastle    Aston Villa    1    0   H    1    0   H
## 94  234 15/02/2022     Man United       Brighton    2    0   H    0    0   D
## 95  236 19/02/2022        Arsenal      Brentford    2    1   H    0    0   D
## 96  240 19/02/2022      Liverpool        Norwich    3    1   H    0    0   D
## 97  241 19/02/2022    Southampton        Everton    2    0   H    0    0   D
## 98  244 20/02/2022         Wolves      Leicester    2    1   H    1    1   D
## 99  245 23/02/2022        Burnley      Tottenham    1    0   H    0    0   D
## 100 247 23/02/2022      Liverpool          Leeds    6    0   H    3    0   H
## 101 248 24/02/2022        Arsenal         Wolves    2    1   H    0    1   A
## 102 249 25/02/2022    Southampton        Norwich    2    0   H    1    0   H
## 103 256 27/02/2022       West Ham         Wolves    1    0   H    0    0   D
## 104 258 05/03/2022      Leicester          Leeds    1    0   H    0    0   D
## 105 259 05/03/2022    Aston Villa    Southampton    4    0   H    2    0   H
## 106 261 05/03/2022      Newcastle       Brighton    2    1   H    2    0   H
## 107 264 05/03/2022      Liverpool       West Ham    1    0   H    1    0   H
## 108 266 06/03/2022       Man City     Man United    4    1   H    2    1   H
## 109 267 07/03/2022      Tottenham        Everton    5    0   H    3    0   H
## 110 270 10/03/2022         Wolves        Watford    4    0   H    2    0   H
## 111 273 12/03/2022      Brentford        Burnley    2    0   H    0    0   D
## 112 274 12/03/2022     Man United      Tottenham    3    2   H    2    1   H
## 113 275 13/03/2022        Chelsea      Newcastle    1    0   H    0    0   D
## 114 277 13/03/2022          Leeds        Norwich    2    1   H    1    0   H
## 115 279 13/03/2022       West Ham    Aston Villa    2    1   H    0    0   D
## 116 280 13/03/2022        Arsenal      Leicester    2    0   H    1    0   H
## 117 284 17/03/2022        Everton      Newcastle    1    0   H    0    0   D
## 118 287 20/03/2022      Leicester      Brentford    2    1   H    2    0   H
## 119 288 20/03/2022      Tottenham       West Ham    3    1   H    2    1   H
## 120 289 02/04/2022      Liverpool        Watford    2    0   H    1    0   H
## 121 294 02/04/2022         Wolves    Aston Villa    2    1   H    2    0   H
## 122 296 03/04/2022       West Ham        Everton    2    1   H    1    0   H
## 123 297 03/04/2022      Tottenham      Newcastle    5    1   H    1    1   D
## 124 298 04/04/2022 Crystal Palace        Arsenal    3    0   H    2    0   H
## 125 299 06/04/2022        Burnley        Everton    3    2   H    1    2   A
## 126 300 08/04/2022      Newcastle         Wolves    1    0   H    0    0   D
## 127 301 09/04/2022        Everton     Man United    1    0   H    1    0   H
## 128 306 10/04/2022      Brentford       West Ham    2    0   H    0    0   D
## 129 307 10/04/2022      Leicester Crystal Palace    2    1   H    2    0   H
## 130 308 10/04/2022        Norwich        Burnley    2    0   H    1    0   H
## 131 311 16/04/2022     Man United        Norwich    3    2   H    2    1   H
## 132 312 16/04/2022    Southampton        Arsenal    1    0   H    1    0   H
## 133 314 17/04/2022      Newcastle      Leicester    2    1   H    1    1   D
## 134 316 19/04/2022      Liverpool     Man United    4    0   H    2    0   H
## 135 319 20/04/2022      Newcastle Crystal Palace    1    0   H    1    0   H
## 136 320 20/04/2022       Man City       Brighton    3    0   H    0    0   D
## 137 321 21/04/2022        Burnley    Southampton    2    0   H    2    0   H
## 138 322 23/04/2022        Arsenal     Man United    3    1   H    2    1   H
## 139 324 23/04/2022       Man City        Watford    5    1   H    3    1   H
## 140 328 24/04/2022        Burnley         Wolves    1    0   H    0    0   D
## 141 329 24/04/2022        Chelsea       West Ham    1    0   H    0    0   D
## 142 330 24/04/2022      Liverpool        Everton    2    0   H    0    0   D
## 143 334 30/04/2022    Aston Villa        Norwich    2    0   H    1    0   H
## 144 339 01/05/2022        Everton        Chelsea    1    0   H    0    0   D
## 145 340 01/05/2022      Tottenham      Leicester    3    1   H    1    0   H
## 146 342 02/05/2022     Man United      Brentford    3    0   H    1    0   H
## 147 343 07/05/2022      Brentford    Southampton    3    0   H    2    0   H
## 148 346 07/05/2022 Crystal Palace        Watford    1    0   H    1    0   H
## 149 347 07/05/2022       Brighton     Man United    4    0   H    1    0   H
## 150 349 08/05/2022        Arsenal          Leeds    2    1   H    2    0   H
## 151 352 08/05/2022       Man City      Newcastle    5    0   H    2    0   H
## 152 355 11/05/2022      Leicester        Norwich    3    0   H    0    0   D
## 153 358 12/05/2022      Tottenham        Arsenal    3    0   H    2    0   H
## 154 359 15/05/2022      Tottenham        Burnley    1    0   H    1    0   H
## 155 366 16/05/2022      Newcastle        Arsenal    2    0   H    0    0   D
## 156 368 19/05/2022        Everton Crystal Palace    3    2   H    0    2   A
## 157 371 22/05/2022        Arsenal        Everton    5    1   H    2    1   H
## 158 373 22/05/2022       Brighton       West Ham    3    1   H    0    1   A
## 159 375 22/05/2022        Chelsea        Watford    2    1   H    1    0   H
## 160 376 22/05/2022 Crystal Palace     Man United    1    0   H    1    0   H
## 161 377 22/05/2022      Leicester    Southampton    4    1   H    0    0   D
## 162 378 22/05/2022      Liverpool         Wolves    3    1   H    1    1   D
## 163 379 22/05/2022       Man City    Aston Villa    3    2   H    0    1   A
##          Referee HS AS HST AST HF AF HC AC HY AY HR AR
## 1       M Oliver  8 22   3   4 12  8  2  5  0  0  0  0
## 2      P Tierney 16 10   8   3 11  9  5  4  1  2  0  0
## 3         J Moss 13  4   6   1 15 11  5  2  0  0  0  0
## 4       A Madley 14  6   6   3 13 15  6  8  2  0  0  0
## 5       C Pawson  9 17   5   3  6 10  5  4  1  2  0  0
## 6         M Dean 13 11   7   2 18 13  2  4  3  1  0  0
## 7       A Taylor 13 18   3   4 11  8  3 11  2  1  0  0
## 8         M Dean 27  9   9   3  6 12  8  4  0  0  0  0
## 9        D Coote 10  9   2   1  8 18  3  4  3  4  0  0
## 10       G Scott 16  1   4   0 13  7  6  1  1  0  0  0
## 11      A Taylor 13 10   3   1 11  6  7  2  4  0  0  0
## 12      M Oliver 13  5   7   1  8  8 10  0  0  1  0  1
## 13    M Atkinson 25  1  10   0  5  7 14  0  1  2  0  1
## 14    A Marriner 15  9   8   2  8 14 10  3  3  3  0  0
## 15        J Moss 18  2   4   1 13 15  8  2  2  1  0  1
## 16      M Oliver 30 10   7   1  9 11  8  4  1  2  0  0
## 17      A Taylor 21 12   7   3  9  2  7  3  1  0  0  0
## 18     S Attwell 12 18   4   6 11 11  4 11  1  4  0  0
## 19    M Atkinson 14 11   6   6  3  6  4  6  1  1  0  0
## 20      A Madley 25 13  10   2 17 11 10  5  3  1  0  0
## 21      C Pawson 15 11   3   1  7 10  5  4  1  1  0  0
## 22     S Attwell 12 14   5   3  8 10  4  9  2  1  0  0
## 23       D Coote 11 10   4   2 12  9  6  4  2  3  0  0
## 24      C Pawson 12 10   7   4 12 13  4  4  2  1  0  0
## 25    M Atkinson 20  6   9   2 11 13  7  2  1  3  0  1
## 26      S Hooper 20  5   4   1 10 16  6  3  0  3  0  0
## 27       G Scott  7  8   3   2 15  5  0  4  0  2  0  0
## 28    C Kavanagh 17 14   8   3 11 14  5  8  2  1  0  0
## 29      C Pawson 22 18  11   6  5 17  4  3  0  3  0  0
## 30    M Atkinson 15  7   6   2 11  5  6  2  1  0  0  0
## 31       D Coote 19  3   5   0 16 14  8  1  2  3  0  0
## 32      C Pawson 22 10   9   4 17 10  7  4  2  5  0  0
## 33      A Madley 23  3  13   1 14 16  5  0  0  2  0  1
## 34     P Tierney 13  7   4   4 11  4  2  4  2  1  0  0
## 35        J Moss 15 12   6   5  7 10  4  2  1  1  0  0
## 36    M Atkinson 10 14   4   5 10  8  4  3  1  1  0  0
## 37      A Madley  9 14   3   3 12 12 10  8  2  2  0  0
## 38       G Scott 13  4   6   2 14 13  4  6  2  1  0  0
## 39      K Friend 14  7   6   1  6 19  4  2  4  2  0  1
## 40      C Pawson  7 16   3   5 11  6  3  2  1  1  0  0
## 41      A Taylor  9  6   5   2  7 13  5  7  3  3  0  0
## 42    M Atkinson  8 17   4   5  8  9  5  7  3  2  0  0
## 43        J Moss 20  9   7   3  7  5  9  3  2  1  0  1
## 44        M Dean 15  8   5   3  6  9  7  3  1  1  0  0
## 45      M Oliver 19  5   9   3 15 12  6  1  2  0  0  0
## 46     S Attwell 17  4   7   1  5  7  7  1  1  1  0  0
## 47    A Marriner 13 18   4   7 11 12  4  8  1  4  0  0
## 48     S Attwell 24  9   6   5  6 12  4  4  1  3  0  0
## 49    A Marriner 20  7   6   3  7 14  5  7  0  1  0  0
## 50     D England  6 14   4   5  8 11  3  3  4  3  0  0
## 51      A Madley 18 16   8   5  5 19  8  6  0  0  0  0
## 52      M Oliver 19  5   9   3  7  6  8  4  2  0  0  0
## 53      K Friend 15  9   3   1 15 15  7  4  5  3  0  0
## 54        J Moss 11  6   6   2 13 11 11  5  0  0  0  0
## 55    M Atkinson 14 17  10   8  9 10  3  8  1  0  0  0
## 56    A Marriner 11 19   5   7 10 10  1  9  1  3  0  0
## 57     P Tierney 19 10   4   1 11  9 10  3  1  1  0  0
## 58      C Pawson 16  8   3   2 16  9  9  6  2  2  0  0
## 59     J Gillett 17 10   7   1 11  4  6  4  1  2  0  0
## 60      M Oliver 13 12   4   5  8 25  3  6  1  1  0  0
## 61        M Dean 11 10   5   3  8 12  3  3  2  2  0  0
## 62      M Oliver 14  6   5   2 12 18  8  2  4  0  0  0
## 63        J Moss 24  2  10   1 12  5 14  1  3  2  0  1
## 64     J Gillett 15 11   5   6  5  9  9  8  2  0  0  0
## 65    C Kavanagh 16 12   6   5  9 15  5  2  2  5  0  0
## 66     S Attwell 20  4   5   0 13  6 11  3  1  2  0  0
## 67      P Bankes  8 12   5   3  9 16  4  6  2  3  0  0
## 68      A Madley 17 12   6   6 15 14  8  2  0  2  0  0
## 69     P Tierney 31  6  15   3  5  9  6  2  1  1  0  0
## 70      A Taylor 21  7   8   1  8  9  5  2  2  0  0  1
## 71        M Dean 23  4   8   2  9  4 11  0  1  3  0  0
## 72    C Kavanagh 17 14   9   8 11  9 14  4  1  2  0  0
## 73        J Moss 17  4   6   0 16 10  4  2  1  1  0  1
## 74     D England 15 16   5   6  8 10  6  9  1  3  0  0
## 75     P Tierney 19 12   6   3  9 13  8  8  1  2  0  0
## 76      M Oliver  6 21   1   4  8 11  1 12  0  1  0  0
## 77        J Moss 18 10   6   3  5 10  7  5  0  0  0  0
## 78      C Pawson 10 16   4   5 17 11  3  7  2  2  0  0
## 79     P Tierney 22  8   7   2 11  7  9  3  2  1  0  0
## 80     S Attwell 12  5   6   4  9  8  5  2  0  1  0  0
## 81      S Hooper 13  7   5   3  9  8 11  2  0  0  0  0
## 82      C Pawson 11  4   6   1 11  6  9  1  0  2  0  0
## 83      A Madley 14 12   3   5 12 14  8  8  3  1  0  0
## 84   M Salisbury  9 13   5  10 13 14  2 10  2  3  0  0
## 85        J Moss 27  6  13   1  6  6  9  0  0  1  0  0
## 86        J Moss 18  6   3   1  9  8  3  3  1  1  0  0
## 87     P Tierney 15  6   7   3 17 14 10  3  2  1  0  0
## 88      A Taylor 20 11   9   3 13 13  6  2  2  3  0  0
## 89    M Atkinson  9  6   3   1  1  6  5  6  1  0  0  0
## 90     D England 15  6   7   2  7 13  9  3  0  0  0  0
## 91    C Kavanagh 22  5  11   1 11  7  7  6  1  0  0  0
## 92       G Scott 21  7  10   0  8  9  5  3  1  1  0  0
## 93      C Pawson 10 11   2   1 22 15  3  6  3  4  0  0
## 94      P Bankes 19 10   7   3  8 10 10  2  3  1  0  1
## 95        J Moss 24  6   8   2 10  5 14  0  1  1  0  0
## 96        M Dean 29  6   8   1  7  8  9  4  0  1  0  0
## 97      A Madley 19  9  11   0  6  9  4  4  0  2  0  0
## 98      C Pawson 11 17   3   7 12  9  7 10  4  4  0  0
## 99       G Scott 15 12   4   2  8  8  3  7  0  0  0  0
## 100     M Oliver 23  3  15   2  5 11  4  0  0  3  0  0
## 101   M Atkinson 26  6   5   2  8  9  5  4  1  1  0  0
## 102     S Hooper 27  8   9   1 12  9 13  6  1  2  0  0
## 103     A Taylor 13 14   4   1  8  2  3  5  1  0  0  0
## 104      D Coote  7 19   4   4  9 12  5 10  1  2  0  0
## 105     P Bankes 14 11   9   1 10  8  4  7  1  1  0  0
## 106   M Atkinson 10 15   4   4  8 10  4  7  1  1  0  0
## 107       J Moss 22 13   5   5  7  7  4  6  2  1  0  0
## 108     M Oliver 24  5  10   2 10 14  9  3  0  1  0  0
## 109    S Attwell 14  6   7   0 15 10  5  2  2  0  0  0
## 110    D England 10  9   5   0 11 10  5  2  2  2  0  0
## 111    P Tierney 13  7   4   1  6 10  2  9  1  1  0  1
## 112       J Moss 10 10   6   3  8  7  4  5  2  1  0  0
## 113      D Coote  8  7   3   2 17 16  7  2  4  3  0  0
## 114    S Attwell 13 12   7   4 18  8  6  2  3  1  0  0
## 115    J Gillett 11 13   4   7  9  3  5  7  1  0  0  0
## 116     A Taylor 21  6   8   3  8 10  2  6  0  3  0  0
## 117     C Pawson  9 17   3   6 13 11  5  7  2  1  1  0
## 118    D England 12 15   4   6 10 10  2  5  1  2  0  0
## 119     A Taylor 17  6   4   1  7  7  5  3  0  1  0  0
## 120    S Attwell 20  5   3   2  9  8  9  3  1  1  0  0
## 121    D England 11 15   5   5 15  8  4  9  4  3  0  0
## 122     M Oliver 11 13   5   2  9 12  2  4  1  1  0  1
## 123   M Atkinson 19  8   6   1 10  7  2  3  2  3  0  0
## 124    P Tierney  6 12   5   3 11 15  0  2  0  2  0  0
## 125       M Dean 13 16   4   4 11 16  9  6  2  2  0  0
## 126     P Bankes 12  5   4   2  6 13  1  2  1  1  0  0
## 127       J Moss  7 12   3   4  4 10  5  7  2  2  0  0
## 128   M Atkinson 15  5   7   1  2  6  4  6  0  1  0  0
## 129      R Jones 12 11   3   3 11 12  3  4  1  1  0  0
## 130     M Oliver 17 18   6   4 12 10  6  7  1  1  0  0
## 131     A Madley 20 15   9   4  7  6  6  7  0  0  0  0
## 132     P Bankes  9 23   3   6  6  6  6  8  2  1  0  0
## 133    J Gillett 16  8   7   2 10 10  3  5  2  2  0  0
## 134   M Atkinson 14  2   5   1  3  6 10  2  1  2  0  0
## 135 T Harrington 13 10   4   2 12 12  2  5  1  1  0  0
## 136       M Dean 17  2   5   1 12  7  7  4  0  3  0  0
## 137    S Attwell 16 11   6   3  7  7 10 10  2  2  0  0
## 138     C Pawson 14 14   7   5  9 12  1  7  3  4  0  0
## 139     K Friend 21  5   8   2  9  7 11  4  1  0  0  0
## 140     A Taylor 14 10   5   4  8  7  3  6  3  1  0  0
## 141     M Oliver 26  6   5   2 11  9  3  1  1  0  0  1
## 142    S Attwell 18  9   4   1  8  8 13  1  2  5  0  0
## 143     J Brooks 21  9   6   3 16  8  2  3  4  1  0  0
## 144     K Friend  9 17   4   5  9 12  3  8  3  5  0  0
## 145       J Moss 13  6   7   2 13  8  7  3  2  3  0  0
## 146   C Kavanagh  9 12   5   4  4  6  3  8  1  0  0  0
## 147  M Salisbury 18 19   5   4 12  9  4  7  0  1  0  0
## 148      G Scott 15  6   7   1 11 18  8  5  2  1  0  1
## 149     A Madley 17 15   6   5 13  9  7  6  0  2  0  0
## 150   C Kavanagh 19  3   9   2 13 15  8  2  2  2  0  1
## 151    S Attwell 21  7   9   3  6 11  8  2  1  3  0  0
## 152     S Hooper 20  9   8   5 10  5 10  2  0  0  0  0
## 153    P Tierney 16  8   6   4  8 15  2  2  1  3  0  1
## 154     K Friend 21  8   8   1 12  8  8  2  3  2  0  0
## 155    D England 16 11   4   2 11  8 12  8  0  3  0  0
## 156     A Taylor 12  7   6   5  9 13  4  5  2  3  0  0
## 157   A Marriner 26  6   9   2  8  9 12  2  0  1  0  0
## 158     K Friend 18  7   7   2  9  9  5  6  1  1  0  0
## 159       M Dean 19  8   8   3  9  9  3  3  0  0  0  0
## 160   M Atkinson  6 10   3   4 12 22  3  6  2  4  0  0
## 161       J Moss 12  7   6   2 10  5  3  3  0  1  0  0
## 162     A Taylor 29  7   8   5  6  3  5  3  1  0  0  0
## 163     M Oliver 24  4   5   2  5 11 13  1  0  1  0  0

Arrange rows

arrange(data, desc(HC))
##       X       Date       HomeTeam       AwayTeam FTHG FTAG FTR HTHG HTAG HTR
## 1   129 28/11/2021        Chelsea     Man United    1    1   D    0    0   D
## 2    21 28/08/2021       Man City        Arsenal    5    0   H    3    0   H
## 3   104 06/11/2021        Chelsea        Burnley    1    1   D    1    0   H
## 4   151 11/12/2021       Man City         Wolves    1    0   H    0    0   D
## 5   170 26/12/2021       Man City      Leicester    6    3   H    4    0   H
## 6   236 19/02/2022        Arsenal      Brentford    2    1   H    0    0   D
## 7   249 25/02/2022    Southampton        Norwich    2    0   H    1    0   H
## 8   315 17/04/2022       West Ham        Burnley    1    1   D    0    1   A
## 9   330 24/04/2022      Liverpool        Everton    2    0   H    0    0   D
## 10  369 19/05/2022    Aston Villa        Burnley    1    1   D    0    1   A
## 11  379 22/05/2022       Man City    Aston Villa    3    2   H    0    1   A
## 12   27 28/08/2021      Liverpool        Chelsea    1    1   D    1    1   D
## 13  211 23/01/2022        Arsenal        Burnley    0    0   D    0    0   D
## 14  269 10/03/2022    Southampton      Newcastle    1    2   A    1    1   D
## 15  292 02/04/2022        Chelsea      Brentford    1    4   A    0    0   D
## 16  326 23/04/2022      Brentford      Tottenham    0    0   D    0    0   D
## 17  366 16/05/2022      Newcastle        Arsenal    2    0   H    0    0   D
## 18  371 22/05/2022        Arsenal        Everton    5    1   H    2    1   H
## 19   69 03/10/2021       West Ham      Brentford    1    2   A    0    1   A
## 20  138 02/12/2021      Tottenham      Brentford    2    0   H    1    0   H
## 21  154 11/12/2021      Liverpool    Aston Villa    1    0   H    0    0   D
## 22  165 16/12/2021      Liverpool      Newcastle    3    1   H    2    1   H
## 23  193 12/01/2022       West Ham        Norwich    2    0   H    1    0   H
## 24  278 13/03/2022    Southampton        Watford    1    2   A    1    2   A
## 25  290 02/04/2022       Brighton        Norwich    0    0   D    0    0   D
## 26  302 09/04/2022        Arsenal       Brighton    1    2   A    0    1   A
## 27  324 23/04/2022       Man City        Watford    5    1   H    3    1   H
## 28  348 07/05/2022      Liverpool      Tottenham    1    1   D    0    0   D
## 29   20 23/08/2021       West Ham      Leicester    4    1   H    1    0   H
## 30   29 29/08/2021      Tottenham        Watford    1    0   H    1    0   H
## 31   44 18/09/2021      Liverpool Crystal Palace    3    0   H    1    0   H
## 32   61 02/10/2021     Man United        Everton    1    1   D    1    0   H
## 33   97 30/10/2021      Tottenham     Man United    0    3   A    0    1   A
## 34  101 05/11/2021    Southampton    Aston Villa    1    0   H    1    0   H
## 35  109 07/11/2021          Leeds      Leicester    1    1   D    1    1   D
## 36  141 04/12/2021      Newcastle        Burnley    1    0   H    1    0   H
## 37  173 26/12/2021       West Ham    Southampton    2    3   A    0    1   A
## 38  181 29/12/2021        Chelsea       Brighton    1    1   D    1    0   H
## 39  214 23/01/2022        Chelsea      Tottenham    2    0   H    0    0   D
## 40  234 15/02/2022     Man United       Brighton    2    0   H    0    0   D
## 41  237 19/02/2022    Aston Villa        Watford    0    1   A    0    0   D
## 42  242 19/02/2022       Man City      Tottenham    2    3   A    1    1   D
## 43  316 19/04/2022      Liverpool     Man United    4    0   H    2    0   H
## 44  321 21/04/2022        Burnley    Southampton    2    0   H    2    0   H
## 45  355 11/05/2022      Leicester        Norwich    3    0   H    0    0   D
## 46   19 22/08/2021        Arsenal        Chelsea    0    2   A    0    2   A
## 47   25 28/08/2021        Norwich      Leicester    1    2   A    1    1   D
## 48   62 02/10/2021        Burnley        Norwich    0    0   D    0    0   D
## 49   88 24/10/2021      Brentford      Leicester    1    2   A    0    1   A
## 50  116 20/11/2021        Watford     Man United    4    1   H    2    0   H
## 51  134 01/12/2021       West Ham       Brighton    1    1   D    1    0   H
## 52  146 05/12/2021     Man United Crystal Palace    1    0   H    0    0   D
## 53  152 11/12/2021        Arsenal    Southampton    3    0   H    2    0   H
## 54  186 01/01/2022 Crystal Palace       West Ham    2    3   A    0    3   A
## 55  189 02/01/2022          Leeds        Burnley    3    1   H    1    0   H
## 56  194 14/01/2022       Brighton Crystal Palace    1    1   D    0    0   D
## 57  195 15/01/2022       Man City        Chelsea    1    0   H    0    0   D
## 58  200 16/01/2022      Liverpool      Brentford    3    0   H    1    0   H
## 59  206 22/01/2022        Everton    Aston Villa    0    1   A    0    1   A
## 60  219 09/02/2022       Man City      Brentford    2    0   H    1    0   H
## 61  240 19/02/2022      Liverpool        Norwich    3    1   H    0    0   D
## 62  266 06/03/2022       Man City     Man United    4    1   H    2    1   H
## 63  289 02/04/2022      Liverpool        Watford    2    0   H    1    0   H
## 64  299 06/04/2022        Burnley        Everton    3    2   H    1    2   A
## 65  305 09/04/2022    Aston Villa      Tottenham    0    4   A    0    1   A
## 66  345 07/05/2022        Chelsea         Wolves    2    2   D    0    0   D
## 67  351 08/05/2022        Norwich       West Ham    0    4   A    0    3   A
## 68   11 21/08/2021      Liverpool        Burnley    2    0   H    1    0   H
## 69   14 21/08/2021          Leeds        Everton    2    2   D    1    1   D
## 70   31 11/09/2021 Crystal Palace      Tottenham    3    0   H    0    0   D
## 71   32 11/09/2021        Arsenal        Norwich    1    0   H    0    0   D
## 72   43 18/09/2021        Burnley        Arsenal    0    1   A    0    1   A
## 73   45 18/09/2021       Man City    Southampton    0    0   D    0    0   D
## 74   55 25/09/2021      Leicester        Burnley    2    2   D    1    2   A
## 75   66 02/10/2021       Brighton        Arsenal    0    0   D    0    0   D
## 76   75 16/10/2021        Norwich       Brighton    0    0   D    0    0   D
## 77   76 16/10/2021    Southampton          Leeds    1    0   H    0    0   D
## 78  114 20/11/2021      Newcastle      Brentford    3    3   D    2    2   D
## 79  127 28/11/2021      Leicester        Watford    4    2   H    3    1   H
## 80  128 28/11/2021       Man City       West Ham    2    1   H    1    0   H
## 81  150 10/12/2021      Brentford        Watford    2    1   H    0    1   A
## 82  155 11/12/2021        Norwich     Man United    0    1   A    0    0   D
## 83  158 12/12/2021 Crystal Palace        Everton    3    1   H    1    0   H
## 84  177 28/12/2021 Crystal Palace        Norwich    3    0   H    3    0   H
## 85  188 02/01/2022        Everton       Brighton    2    3   A    0    2   A
## 86  197 15/01/2022        Norwich        Everton    2    1   H    2    0   H
## 87  346 07/05/2022 Crystal Palace        Watford    1    0   H    1    0   H
## 88  349 08/05/2022        Arsenal          Leeds    2    1   H    2    0   H
## 89  352 08/05/2022       Man City      Newcastle    5    0   H    2    0   H
## 90  359 15/05/2022      Tottenham        Burnley    1    0   H    1    0   H
## 91  361 15/05/2022          Leeds       Brighton    1    1   D    0    1   A
## 92  374 22/05/2022        Burnley      Newcastle    1    2   A    0    1   A
## 93    3 14/08/2021        Burnley       Brighton    1    2   A    1    0   H
## 94    9 15/08/2021      Newcastle       West Ham    2    4   A    2    1   H
## 95   16 21/08/2021       Brighton        Watford    2    0   H    2    0   H
## 96   17 22/08/2021    Southampton     Man United    1    1   D    1    0   H
## 97   35 11/09/2021     Man United      Newcastle    4    1   H    1    0   H
## 98   63 02/10/2021        Chelsea    Southampton    3    1   H    1    0   H
## 99   78 17/10/2021        Everton       West Ham    0    1   A    0    0   D
## 100  81 22/10/2021        Arsenal    Aston Villa    3    1   H    2    0   H
## 101  87 23/10/2021       Brighton       Man City    1    4   A    0    3   A
## 102  91 30/10/2021      Leicester        Arsenal    0    2   A    0    2   A
## 103  94 30/10/2021       Man City Crystal Palace    0    2   A    0    1   A
## 104 117 20/11/2021         Wolves       West Ham    1    0   H    0    0   D
## 105 119 21/11/2021       Man City        Everton    3    0   H    1    0   H
## 106 122 27/11/2021 Crystal Palace    Aston Villa    1    2   A    0    1   A
## 107 131 30/11/2021          Leeds Crystal Palace    1    0   H    0    0   D
## 108 159 14/12/2021        Norwich    Aston Villa    0    2   A    0    1   A
## 109 161 15/12/2021       Brighton         Wolves    0    1   A    0    1   A
## 110 164 16/12/2021        Chelsea        Everton    1    1   D    0    0   D
## 111 183 30/12/2021     Man United        Burnley    3    1   H    3    1   H
## 112 223 10/02/2022      Liverpool      Leicester    2    0   H    1    0   H
## 113 224 10/02/2022         Wolves        Arsenal    0    1   A    0    1   A
## 114 232 13/02/2022      Tottenham         Wolves    0    2   A    0    2   A
## 115 244 20/02/2022         Wolves      Leicester    2    1   H    1    1   D
## 116 254 26/02/2022       Brighton    Aston Villa    0    2   A    0    1   A
## 117 263 05/03/2022         Wolves Crystal Palace    0    2   A    0    2   A
## 118 272 12/03/2022       Brighton      Liverpool    0    2   A    0    1   A
## 119 275 13/03/2022        Chelsea      Newcastle    1    0   H    0    0   D
## 120 320 20/04/2022       Man City       Brighton    3    0   H    0    0   D
## 121 323 23/04/2022      Leicester    Aston Villa    0    0   D    0    0   D
## 122 337 30/04/2022         Wolves       Brighton    0    3   A    0    1   A
## 123 340 01/05/2022      Tottenham      Leicester    3    1   H    1    0   H
## 124 347 07/05/2022       Brighton     Man United    4    0   H    1    0   H
## 125 362 15/05/2022        Watford      Leicester    1    5   A    1    2   A
## 126   5 14/08/2021        Everton    Southampton    3    1   H    0    1   A
## 127  15 21/08/2021       Man City        Norwich    5    0   H    2    0   H
## 128  37 11/09/2021        Watford         Wolves    0    2   A    0    0   D
## 129  53 25/09/2021        Everton        Norwich    2    0   H    1    0   H
## 130  60 27/09/2021 Crystal Palace       Brighton    1    1   D    1    0   H
## 131  64 02/10/2021          Leeds        Watford    1    0   H    1    0   H
## 132  72 16/10/2021    Aston Villa         Wolves    2    3   A    0    0   D
## 133  74 16/10/2021       Man City        Burnley    2    0   H    1    0   H
## 134  80 18/10/2021        Arsenal Crystal Palace    2    2   D    1    0   H
## 135  85 23/10/2021          Leeds         Wolves    1    1   D    0    1   A
## 136  86 23/10/2021    Southampton        Burnley    2    2   D    1    1   D
## 137  90 24/10/2021     Man United      Liverpool    0    5   A    0    4   A
## 138 103 06/11/2021      Brentford        Norwich    1    2   A    0    2   A
## 139 118 20/11/2021      Liverpool        Arsenal    4    0   H    1    0   H
## 140 125 27/11/2021       Brighton          Leeds    0    0   D    0    0   D
## 141 133 01/12/2021        Watford        Chelsea    1    2   A    1    1   D
## 142 142 04/12/2021    Southampton       Brighton    1    1   D    1    0   H
## 143 147 05/12/2021      Tottenham        Norwich    3    0   H    1    0   H
## 144 156 12/12/2021        Burnley       West Ham    0    0   D    0    0   D
## 145 160 14/12/2021       Man City          Leeds    7    0   H    3    0   H
## 146 169 19/12/2021      Tottenham      Liverpool    2    2   D    1    1   D
## 147 175 26/12/2021       Brighton      Brentford    2    0   H    2    0   H
## 148 190 02/01/2022        Chelsea      Liverpool    2    2   D    2    2   D
## 149 204 19/01/2022      Brentford     Man United    1    3   A    0    0   D
## 150 207 22/01/2022      Brentford         Wolves    1    2   A    0    0   D
## 151 208 22/01/2022          Leeds      Newcastle    0    1   A    0    0   D
## 152 216 08/02/2022      Newcastle        Everton    3    1   H    1    1   D
## 153 222 09/02/2022    Aston Villa          Leeds    3    3   D    3    2   H
## 154 246 23/02/2022        Watford Crystal Palace    1    4   A    1    2   A
## 155 251 26/02/2022      Brentford      Newcastle    0    2   A    0    2   A
## 156 257 01/03/2022        Burnley      Leicester    0    2   A    0    0   D
## 157 277 13/03/2022          Leeds        Norwich    2    1   H    1    0   H
## 158 282 16/03/2022       Brighton      Tottenham    0    2   A    0    1   A
## 159 286 19/03/2022    Aston Villa        Arsenal    0    1   A    0    1   A
## 160 295 02/04/2022     Man United      Leicester    1    1   D    0    0   D
## 161 308 10/04/2022        Norwich        Burnley    2    0   H    1    0   H
## 162 311 16/04/2022     Man United        Norwich    3    2   H    2    1   H
## 163 312 16/04/2022    Southampton        Arsenal    1    0   H    1    0   H
## 164 313 16/04/2022        Watford      Brentford    1    2   A    0    1   A
## 165 317 20/04/2022        Chelsea        Arsenal    2    4   A    2    2   D
## 166 327 24/04/2022       Brighton    Southampton    2    2   D    2    1   H
## 167 331 25/04/2022 Crystal Palace          Leeds    0    0   D    0    0   D
## 168 335 30/04/2022    Southampton Crystal Palace    1    2   A    1    0   H
## 169 350 08/05/2022      Leicester        Everton    1    2   A    1    2   A
## 170 357 11/05/2022         Wolves       Man City    1    5   A    1    3   A
## 171 370 19/05/2022        Chelsea      Leicester    1    1   D    1    1   D
## 172   2 14/08/2021     Man United          Leeds    5    1   H    1    0   H
## 173   4 14/08/2021        Chelsea Crystal Palace    3    0   H    2    0   H
## 174   6 14/08/2021      Leicester         Wolves    1    0   H    1    0   H
## 175  18 22/08/2021         Wolves      Tottenham    0    1   A    0    1   A
## 176  26 28/08/2021       West Ham Crystal Palace    2    2   D    1    0   H
## 177  28 29/08/2021        Burnley          Leeds    1    1   D    0    0   D
## 178  30 29/08/2021         Wolves     Man United    0    1   A    0    0   D
## 179  34 11/09/2021      Leicester       Man City    0    1   A    0    0   D
## 180  36 11/09/2021    Southampton       West Ham    0    0   D    0    0   D
## 181  47 18/09/2021    Aston Villa        Everton    3    0   H    0    0   D
## 182  50 19/09/2021      Tottenham        Chelsea    0    3   A    0    0   D
## 183  52 25/09/2021     Man United    Aston Villa    0    1   A    0    0   D
## 184  54 25/09/2021          Leeds       West Ham    1    2   A    1    0   H
## 185  56 25/09/2021        Watford      Newcastle    1    1   D    0    1   A
## 186  58 26/09/2021    Southampton         Wolves    0    1   A    0    0   D
## 187  68 03/10/2021      Tottenham    Aston Villa    2    1   H    1    0   H
## 188  77 16/10/2021      Brentford        Chelsea    0    1   A    0    1   A
## 189  82 23/10/2021        Chelsea        Norwich    7    0   H    3    0   H
## 190  93 30/10/2021      Liverpool       Brighton    2    2   D    2    1   H
## 191  96 30/10/2021        Watford    Southampton    0    1   A    0    1   A
## 192  98 31/10/2021        Norwich          Leeds    1    2   A    0    0   D
## 193 112 20/11/2021    Aston Villa       Brighton    2    0   H    0    0   D
## 194 115 20/11/2021        Norwich    Southampton    2    1   H    1    1   D
## 195 123 27/11/2021      Liverpool    Southampton    4    0   H    3    0   H
## 196 135 01/12/2021         Wolves        Burnley    0    0   D    0    0   D
## 197 144 04/12/2021        Watford       Man City    1    3   A    0    2   A
## 198 145 05/12/2021          Leeds      Brentford    2    2   D    1    0   H
## 199 153 11/12/2021        Chelsea          Leeds    3    2   H    1    1   D
## 200 163 15/12/2021        Arsenal       West Ham    2    0   H    0    0   D
## 201 184 01/01/2022        Arsenal       Man City    1    2   A    1    0   H
## 202 192 11/01/2022    Southampton      Brentford    4    1   H    2    1   H
## 203 202 18/01/2022       Brighton        Chelsea    1    1   D    0    1   A
## 204 205 21/01/2022        Watford        Norwich    0    3   A    0    0   D
## 205 217 08/02/2022       West Ham        Watford    1    0   H    0    0   D
## 206 227 12/02/2022        Everton          Leeds    3    0   H    2    0   H
## 207 230 13/02/2022        Burnley      Liverpool    0    1   A    0    1   A
## 208 233 13/02/2022      Leicester       West Ham    2    2   D    1    1   D
## 209 248 24/02/2022        Arsenal         Wolves    2    1   H    0    1   A
## 210 252 26/02/2022 Crystal Palace        Burnley    1    1   D    1    0   H
## 211 258 05/03/2022      Leicester          Leeds    1    0   H    0    0   D
## 212 260 05/03/2022        Burnley        Chelsea    0    4   A    0    0   D
## 213 262 05/03/2022        Norwich      Brentford    1    3   A    0    1   A
## 214 267 07/03/2022      Tottenham        Everton    5    0   H    3    0   H
## 215 270 10/03/2022         Wolves        Watford    4    0   H    2    0   H
## 216 276 13/03/2022        Everton         Wolves    0    1   A    0    0   D
## 217 279 13/03/2022       West Ham    Aston Villa    2    1   H    0    0   D
## 218 284 17/03/2022        Everton      Newcastle    1    0   H    0    0   D
## 219 288 20/03/2022      Tottenham       West Ham    3    1   H    2    1   H
## 220 301 09/04/2022        Everton     Man United    1    0   H    1    0   H
## 221 318 20/04/2022        Everton      Leicester    1    1   D    0    1   A
## 222 336 30/04/2022        Watford        Burnley    1    2   A    1    0   H
## 223 364 15/05/2022         Wolves        Norwich    1    1   D    0    1   A
## 224 365 15/05/2022        Everton      Brentford    2    3   A    2    1   H
## 225 373 22/05/2022       Brighton       West Ham    3    1   H    0    1   A
## 226 378 22/05/2022      Liverpool         Wolves    3    1   H    1    1   D
## 227  23 28/08/2021       Brighton        Everton    0    2   A    0    1   A
## 228  24 28/08/2021      Newcastle    Southampton    2    2   D    0    0   D
## 229  38 11/09/2021        Chelsea    Aston Villa    3    0   H    1    0   H
## 230  40 13/09/2021        Everton        Burnley    3    1   H    0    0   D
## 231  41 17/09/2021      Newcastle          Leeds    1    1   D    1    1   D
## 232  42 18/09/2021         Wolves      Brentford    0    2   A    0    2   A
## 233  46 18/09/2021        Norwich        Watford    1    3   A    1    1   D
## 234  48 19/09/2021       Brighton      Leicester    2    1   H    1    0   H
## 235  51 25/09/2021        Chelsea       Man City    0    1   A    0    0   D
## 236  59 26/09/2021        Arsenal      Tottenham    3    1   H    3    0   H
## 237  73 16/10/2021      Leicester     Man United    4    2   H    1    1   D
## 238  92 30/10/2021        Burnley      Brentford    3    1   H    3    0   H
## 239 100 01/11/2021         Wolves        Everton    2    1   H    2    0   H
## 240 105 06/11/2021 Crystal Palace         Wolves    2    0   H    0    0   D
## 241 107 07/11/2021        Arsenal        Watford    1    0   H    0    0   D
## 242 108 07/11/2021        Everton      Tottenham    0    0   D    0    0   D
## 243 120 21/11/2021      Tottenham          Leeds    2    1   H    0    1   A
## 244 121 27/11/2021        Arsenal      Newcastle    2    0   H    0    0   D
## 245 124 27/11/2021        Norwich         Wolves    0    0   D    0    0   D
## 246 136 01/12/2021    Aston Villa       Man City    1    2   A    0    2   A
## 247 157 12/12/2021      Leicester      Newcastle    4    0   H    1    0   H
## 248 162 15/12/2021 Crystal Palace    Southampton    2    2   D    1    2   A
## 249 168 19/12/2021         Wolves        Chelsea    0    0   D    0    0   D
## 250 172 26/12/2021      Tottenham Crystal Palace    3    0   H    2    0   H
## 251 179 28/12/2021        Watford       West Ham    1    4   A    1    2   A
## 252 196 15/01/2022      Newcastle        Watford    1    1   D    0    0   D
## 253 201 16/01/2022       West Ham          Leeds    2    3   A    1    2   A
## 254 213 23/01/2022      Leicester       Brighton    1    1   D    0    0   D
## 255 215 05/02/2022        Burnley        Watford    0    0   D    0    0   D
## 256 220 09/02/2022        Norwich Crystal Palace    1    1   D    1    0   H
## 257 228 12/02/2022        Watford       Brighton    0    2   A    0    1   A
## 258 229 12/02/2022        Norwich       Man City    0    4   A    0    1   A
## 259 238 19/02/2022       Brighton        Burnley    0    3   A    0    2   A
## 260 239 19/02/2022 Crystal Palace        Chelsea    0    1   A    0    0   D
## 261 241 19/02/2022    Southampton        Everton    2    0   H    0    0   D
## 262 247 23/02/2022      Liverpool          Leeds    6    0   H    3    0   H
## 263 253 26/02/2022     Man United        Watford    0    0   D    0    0   D
## 264 259 05/03/2022    Aston Villa    Southampton    4    0   H    2    0   H
## 265 261 05/03/2022      Newcastle       Brighton    2    1   H    2    0   H
## 266 264 05/03/2022      Liverpool       West Ham    1    0   H    1    0   H
## 267 274 12/03/2022     Man United      Tottenham    3    2   H    2    1   H
## 268 293 02/04/2022          Leeds    Southampton    1    1   D    1    0   H
## 269 294 02/04/2022         Wolves    Aston Villa    2    1   H    2    0   H
## 270 306 10/04/2022      Brentford       West Ham    2    0   H    0    0   D
## 271 309 10/04/2022       Man City      Liverpool    2    2   D    2    1   H
## 272 310 16/04/2022      Tottenham       Brighton    0    1   A    0    0   D
## 273 343 07/05/2022      Brentford    Southampton    3    0   H    2    0   H
## 274 344 07/05/2022        Burnley    Aston Villa    1    3   A    0    2   A
## 275 363 15/05/2022       West Ham       Man City    2    2   D    2    0   H
## 276 368 19/05/2022        Everton Crystal Palace    3    2   H    0    2   A
## 277   8 14/08/2021        Norwich      Liverpool    0    3   A    0    1   A
## 278  10 15/08/2021      Tottenham       Man City    1    0   H    0    0   D
## 279  12 21/08/2021    Aston Villa      Newcastle    2    0   H    1    0   H
## 280  13 21/08/2021 Crystal Palace      Brentford    0    0   D    0    0   D
## 281  22 28/08/2021    Aston Villa      Brentford    1    1   D    1    1   D
## 282  70 03/10/2021      Liverpool       Man City    2    2   D    0    0   D
## 283  83 23/10/2021 Crystal Palace      Newcastle    1    1   D    0    0   D
## 284  84 23/10/2021        Everton        Watford    2    5   A    1    1   D
## 285  99 31/10/2021    Aston Villa       West Ham    1    4   A    1    2   A
## 286 110 07/11/2021       West Ham      Liverpool    3    2   H    1    1   D
## 287 111 20/11/2021      Leicester        Chelsea    0    3   A    0    2   A
## 288 113 20/11/2021        Burnley Crystal Palace    3    3   D    2    3   A
## 289 126 28/11/2021      Brentford        Everton    1    0   H    1    0   H
## 290 137 01/12/2021        Everton      Liverpool    1    4   A    1    2   A
## 291 139 02/12/2021     Man United        Arsenal    3    2   H    1    1   D
## 292 148 05/12/2021    Aston Villa      Leicester    2    1   H    1    1   D
## 293 149 06/12/2021        Everton        Arsenal    2    1   H    0    1   A
## 294 167 19/12/2021      Newcastle       Man City    0    4   A    0    2   A
## 295 171 26/12/2021        Norwich        Arsenal    0    5   A    0    2   A
## 296 178 28/12/2021    Southampton      Tottenham    1    1   D    1    1   D
## 297 182 29/12/2021      Brentford       Man City    0    1   A    0    1   A
## 298 185 01/01/2022        Watford      Tottenham    0    1   A    0    0   D
## 299 187 02/01/2022      Brentford    Aston Villa    2    1   H    1    1   D
## 300 191 03/01/2022     Man United         Wolves    0    1   A    0    0   D
## 301 199 15/01/2022    Aston Villa     Man United    2    2   D    0    1   A
## 302 203 19/01/2022      Leicester      Tottenham    2    3   A    1    1   D
## 303 209 22/01/2022     Man United       West Ham    1    0   H    0    0   D
## 304 226 12/02/2022      Brentford Crystal Palace    0    0   D    0    0   D
## 305 231 13/02/2022      Newcastle    Aston Villa    1    0   H    1    0   H
## 306 235 19/02/2022       West Ham      Newcastle    1    1   D    1    1   D
## 307 243 20/02/2022          Leeds     Man United    2    4   A    0    2   A
## 308 245 23/02/2022        Burnley      Tottenham    1    0   H    0    0   D
## 309 250 26/02/2022          Leeds      Tottenham    0    4   A    0    3   A
## 310 255 26/02/2022        Everton       Man City    0    1   A    0    0   D
## 311 256 27/02/2022       West Ham         Wolves    1    0   H    0    0   D
## 312 268 10/03/2022        Norwich        Chelsea    1    3   A    0    2   A
## 313 271 10/03/2022          Leeds    Aston Villa    0    3   A    0    1   A
## 314 303 09/04/2022    Southampton        Chelsea    0    6   A    0    4   A
## 315 304 09/04/2022        Watford          Leeds    0    3   A    0    1   A
## 316 307 10/04/2022      Leicester Crystal Palace    2    1   H    2    0   H
## 317 314 17/04/2022      Newcastle      Leicester    2    1   H    1    1   D
## 318 328 24/04/2022        Burnley         Wolves    1    0   H    0    0   D
## 319 329 24/04/2022        Chelsea       West Ham    1    0   H    0    0   D
## 320 338 30/04/2022          Leeds       Man City    0    4   A    0    1   A
## 321 339 01/05/2022        Everton        Chelsea    1    0   H    0    0   D
## 322 341 01/05/2022       West Ham        Arsenal    1    2   A    1    1   D
## 323 342 02/05/2022     Man United      Brentford    3    0   H    1    0   H
## 324 372 22/05/2022      Brentford          Leeds    1    2   A    0    0   D
## 325 375 22/05/2022        Chelsea        Watford    2    1   H    1    0   H
## 326 376 22/05/2022 Crystal Palace     Man United    1    0   H    1    0   H
## 327 377 22/05/2022      Leicester    Southampton    4    1   H    0    0   D
## 328 380 22/05/2022        Norwich      Tottenham    0    5   A    0    2   A
## 329   1 13/08/2021      Brentford        Arsenal    2    0   H    1    0   H
## 330   7 14/08/2021        Watford    Aston Villa    3    2   H    2    0   H
## 331  39 12/09/2021          Leeds      Liverpool    0    3   A    0    1   A
## 332  49 19/09/2021       West Ham     Man United    1    2   A    1    1   D
## 333  57 25/09/2021      Brentford      Liverpool    3    3   D    1    1   D
## 334  79 17/10/2021      Newcastle      Tottenham    2    3   A    1    3   A
## 335  89 24/10/2021       West Ham      Tottenham    1    0   H    0    0   D
## 336 106 06/11/2021       Brighton      Newcastle    1    1   D    1    0   H
## 337 130 30/11/2021      Newcastle        Norwich    1    1   D    0    0   D
## 338 132 01/12/2021    Southampton      Leicester    2    2   D    2    1   H
## 339 143 04/12/2021         Wolves      Liverpool    0    1   A    0    0   D
## 340 174 26/12/2021    Aston Villa        Chelsea    1    3   A    1    1   D
## 341 176 27/12/2021      Newcastle     Man United    1    1   D    1    0   H
## 342 198 15/01/2022         Wolves    Southampton    3    1   H    1    0   H
## 343 210 22/01/2022    Southampton       Man City    1    1   D    1    0   H
## 344 212 23/01/2022 Crystal Palace      Liverpool    1    3   A    0    2   A
## 345 218 08/02/2022        Burnley     Man United    1    1   D    0    1   A
## 346 221 09/02/2022      Tottenham    Southampton    2    3   A    1    1   D
## 347 273 12/03/2022      Brentford        Burnley    2    0   H    0    0   D
## 348 280 13/03/2022        Arsenal      Leicester    2    0   H    1    0   H
## 349 281 14/03/2022 Crystal Palace       Man City    0    0   D    0    0   D
## 350 285 18/03/2022         Wolves          Leeds    2    3   A    2    0   H
## 351 287 20/03/2022      Leicester      Brentford    2    1   H    2    0   H
## 352 296 03/04/2022       West Ham        Everton    2    1   H    1    0   H
## 353 297 03/04/2022      Tottenham      Newcastle    5    1   H    1    1   D
## 354 319 20/04/2022      Newcastle Crystal Palace    1    0   H    1    0   H
## 355 325 23/04/2022        Norwich      Newcastle    0    3   A    0    2   A
## 356 332 28/04/2022     Man United        Chelsea    1    1   D    0    0   D
## 357 334 30/04/2022    Aston Villa        Norwich    2    0   H    1    0   H
## 358 353 10/05/2022    Aston Villa      Liverpool    1    2   A    1    1   D
## 359 358 12/05/2022      Tottenham        Arsenal    3    0   H    2    0   H
## 360  33 11/09/2021      Brentford       Brighton    0    1   A    0    0   D
## 361  67 03/10/2021 Crystal Palace      Leicester    2    2   D    0    2   A
## 362  71 16/10/2021        Watford      Liverpool    0    5   A    0    2   A
## 363 102 06/11/2021     Man United       Man City    0    2   A    0    2   A
## 364 140 04/12/2021       West Ham        Chelsea    3    2   H    1    2   A
## 365 166 18/12/2021          Leeds        Arsenal    1    4   A    0    3   A
## 366 180 28/12/2021      Leicester      Liverpool    1    0   H    0    0   D
## 367 225 12/02/2022     Man United    Southampton    1    1   D    1    0   H
## 368 265 06/03/2022        Watford        Arsenal    2    3   A    1    2   A
## 369 283 16/03/2022        Arsenal      Liverpool    0    2   A    0    0   D
## 370 291 02/04/2022        Burnley       Man City    0    2   A    0    2   A
## 371 300 08/04/2022      Newcastle         Wolves    1    0   H    0    0   D
## 372 322 23/04/2022        Arsenal     Man United    3    1   H    2    1   H
## 373 354 11/05/2022          Leeds        Chelsea    0    3   A    0    1   A
## 374 356 11/05/2022        Watford        Everton    0    0   D    0    0   D
## 375 360 15/05/2022    Aston Villa Crystal Palace    1    1   D    0    0   D
## 376 367 17/05/2022    Southampton      Liverpool    1    2   A    1    1   D
## 377  65 02/10/2021         Wolves      Newcastle    2    1   H    1    1   D
## 378  95 30/10/2021      Newcastle        Chelsea    0    3   A    0    0   D
## 379 298 04/04/2022 Crystal Palace        Arsenal    3    0   H    2    0   H
## 380 333 30/04/2022      Newcastle      Liverpool    0    1   A    0    1   A
##          Referee HS AS HST AST HF AF HC AC HY AY HR AR
## 1       A Taylor 24  3   6   2 13 14 15  2  2  5  0  0
## 2     M Atkinson 25  1  10   0  5  7 14  0  1  2  0  1
## 3     A Marriner 25  5   4   2  6  9 14  2  1  4  0  0
## 4         J Moss 24  2  10   1 12  5 14  1  3  2  0  1
## 5     C Kavanagh 17 14   9   8 11  9 14  4  1  2  0  0
## 6         J Moss 24  6   8   2 10  5 14  0  1  1  0  0
## 7       S Hooper 27  8   9   1 12  9 13  6  1  2  0  0
## 8      P Tierney 21  9   8   1  9 10 13  4  2  2  0  0
## 9      S Attwell 18  9   4   1  8  8 13  1  2  5  0  0
## 10     P Tierney 22 10   9   5 11 20 13  6  0  1  0  1
## 11      M Oliver 24  4   5   2  5 11 13  1  0  1  0  0
## 12      A Taylor 24  6   7   3 13  4 12  3  0  2  0  1
## 13       D Coote 20 10   5   1  9 13 12  4  0  2  0  0
## 14      K Friend 14  8   5   4  6  7 12  5  1  1  0  0
## 15      A Madley 21 17   8   6 11  7 12  7  0  0  0  0
## 16    M Atkinson 15  9   2   0  8  7 12  8  2  1  0  0
## 17     D England 16 11   4   2 11  8 12  8  0  3  0  0
## 18    A Marriner 26  6   9   2  8  9 12  2  0  1  0  0
## 19      P Bankes 18 13   5   6 16 13 11  6  2  3  0  0
## 20        J Moss 11  6   6   2 13 11 11  5  0  0  0  0
## 21     S Attwell 20  4   5   0 13  6 11  3  1  2  0  0
## 22        M Dean 23  4   8   2  9  4 11  0  1  3  0  0
## 23      S Hooper 13  7   5   3  9  8 11  2  0  0  0  0
## 24       G Scott 13  9   7   5  8 12 11  3  3  2  0  0
## 25      S Hooper 31  6   4   0 12 11 11  2  1  1  0  0
## 26       D Coote 20  8   4   3 12 19 11  2  3  4  0  0
## 27      K Friend 21  5   8   2  9  7 11  4  1  0  0  0
## 28      M Oliver 22  8   3   3 12  8 11  5  3  2  0  0
## 29      M Oliver 13  5   7   1  8  8 10  0  0  1  0  1
## 30    A Marriner 15  9   8   2  8 14 10  3  3  3  0  0
## 31      A Madley 25 13  10   2 17 11 10  5  3  1  0  0
## 32      M Oliver 13 12   6   2 10  9 10  1  1  1  0  0
## 33     S Attwell  9 10   0   4 12 14 10  2  2  3  0  0
## 34      A Madley  9 14   3   3 12 12 10  8  2  2  0  0
## 35     D England 18  9   5   3 12  5 10  5  1  1  0  0
## 36     P Tierney 19 10   4   1 11  9 10  3  1  1  0  0
## 37      K Friend 11 11   5   6 10  9 10  2  2  3  0  0
## 38        M Dean 11 18   5   6 14  7 10  8  4  1  0  0
## 39     P Tierney 15  6   7   3 17 14 10  3  2  1  0  0
## 40      P Bankes 19 10   7   3  8 10 10  2  3  1  0  1
## 41       R Jones 20  8   1   4 12  7 10  5  1  2  0  0
## 42      A Taylor 21  6   4   5  5  7 10  0  0  3  0  0
## 43    M Atkinson 14  2   5   1  3  6 10  2  1  2  0  0
## 44     S Attwell 16 11   6   3  7  7 10 10  2  2  0  0
## 45      S Hooper 20  9   8   5 10  5 10  2  0  0  0  0
## 46     P Tierney  6 22   3   5 10  4  9  8  3  0  0  0
## 47       R Jones 14  9   4   3  8  9  9  9  2  1  0  0
## 48      K Friend 14 10   4   2 13  3  9  5  5  2  0  0
## 49      S Hooper 15 10   5   6 13  7  9  2  1  1  0  0
## 50        J Moss 20  9   7   3  7  5  9  3  2  1  0  1
## 51    C Kavanagh 14  9   6   3 10  8  9  5  1  1  0  0
## 52      C Pawson 16  8   3   2 16  9  9  6  2  2  0  0
## 53     J Gillett 15 11   5   6  5  9  9  8  2  0  0  0
## 54     D England 22 10   6   5  6 16  9  1  0  2  0  0
## 55     P Tierney 22  8   7   2 11  7  9  3  2  1  0  0
## 56       R Jones 19  3   4   1 11  7  9  0  0  2  0  0
## 57      C Pawson 11  4   6   1 11  6  9  1  0  2  0  0
## 58        J Moss 27  6  13   1  6  6  9  0  0  1  0  0
## 59      C Pawson 15  8   1   3 14 16  9  2  5  3  0  0
## 60     D England 15  6   7   2  7 13  9  3  0  0  0  0
## 61        M Dean 29  6   8   1  7  8  9  4  0  1  0  0
## 62      M Oliver 24  5  10   2 10 14  9  3  0  1  0  0
## 63     S Attwell 20  5   3   2  9  8  9  3  1  1  0  0
## 64        M Dean 13 16   4   4 11 16  9  6  2  2  0  0
## 65       G Scott  9 11   8   5 12 14  9  3  2  3  0  0
## 66      P Bankes 19 14   6   4  7 11  9  3  1  3  0  0
## 67       R Jones  8 13   2   5  7  7  9  5  1  1  0  0
## 68        M Dean 27  9   9   3  6 12  8  4  0  0  0  0
## 69     D England 17 17   4   8  6 13  8  5  2  4  0  0
## 70        J Moss 18  2   4   1 13 15  8  2  2  1  0  1
## 71      M Oliver 30 10   7   1  9 11  8  4  1  2  0  0
## 72      A Taylor 18 13   3   3  9  8  8  3  2  1  0  0
## 73        J Moss 18 10   1   2  5 12  8  5  0  2  0  0
## 74    C Kavanagh 22  9   5   3 10  8  8  4  2  4  0  0
## 75        J Moss 21  8   2   2  8  5  8  5  2  1  0  0
## 76      P Bankes 15 11   3   3  5 14  8  4  3  5  0  0
## 77       D Coote 19  3   5   0 16 14  8  1  2  3  0  0
## 78       R Jones 23 10   9   4 13 11  8  2  2  2  0  0
## 79      A Madley 18 16   8   5  5 19  8  6  0  0  0  0
## 80      M Oliver 19  5   9   3  7  6  8  4  2  0  0  0
## 81      M Oliver 14  6   5   2 12 18  8  2  4  0  0  0
## 82     D England 11 13   5   5  6 17  8  6  1  1  0  0
## 83      A Madley 17 12   6   6 15 14  8  2  0  2  0  0
## 84     P Tierney 19 12   6   3  9 13  8  8  1  2  0  0
## 85      J Brooks 17 12   6   5  5 12  8  5  1  1  0  0
## 86      A Madley 14 12   3   5 12 14  8  8  3  1  0  0
## 87       G Scott 15  6   7   1 11 18  8  5  2  1  0  1
## 88    C Kavanagh 19  3   9   2 13 15  8  2  2  2  0  1
## 89     S Attwell 21  7   9   3  6 11  8  2  1  3  0  0
## 90      K Friend 21  8   8   1 12  8  8  2  3  2  0  0
## 91        M Dean 19 16   5   6 16  8  8  1  3  2  0  0
## 92      C Pawson 12  8   5   6  8  9  8  2  1  0  0  0
## 93       D Coote 14 14   3   8 10  7  7  6  2  1  0  0
## 94    M Atkinson 17  8   3   9  4  3  7  6  1  0  0  0
## 95      A Taylor 13 10   3   1 11  6  7  2  4  0  0  0
## 96      C Pawson  8 15   3   4 12 10  7  7  2  3  0  0
## 97      A Taylor 21 12   7   3  9  2  7  3  1  0  0  0
## 98    M Atkinson 20  6   9   2 11 13  7  2  1  3  0  1
## 99     S Attwell 15 16   2   4  3  3  7  9  0  2  0  0
## 100     C Pawson 22 10   9   4 17 10  7  4  2  5  0  0
## 101     K Friend 10 23   5  14 10  6  7  6  2  3  0  0
## 102     M Oliver 16  9   8   5  8 11  7  6  2  0  0  0
## 103   A Marriner 14  8   3   3 11 11  7  1  2  3  1  0
## 104       M Dean 15  8   5   3  6  9  7  3  1  1  0  0
## 105    S Attwell 17  4   7   1  5  7  7  1  1  1  0  0
## 106  M Salisbury  8 10   3   3 12 10  7  3  3  3  0  0
## 107     K Friend 15  9   3   1 15 15  7  4  5  3  0  0
## 108      D Coote  7 17   3   6 12  9  7 10  3  1  0  0
## 109 T Harrington 12  8   2   5 11 14  7  4  2  0  0  0
## 110     M Oliver 23  5  10   3 11 11  7  1  2  3  0  0
## 111       J Moss 18 10   6   3  5 10  7  5  0  0  0  0
## 112   C Kavanagh 22  5  11   1 11  7  7  6  1  0  0  0
## 113     M Oliver 15 12   4   2 12 13  7  4  2  3  0  1
## 114     K Friend 17 11   7   7 13 13  7  3  3  1  0  0
## 115     C Pawson 11 17   3   7 12  9  7 10  4  4  0  0
## 116     J Brooks 12  9   1   4 17 11  7  2  4  5  0  0
## 117     A Madley 12 12   5   8 13  8  7  7  0  3  0  0
## 118       M Dean  8 18   3   9 12 15  7  6  3  1  0  0
## 119      D Coote  8  7   3   2 17 16  7  2  4  3  0  0
## 120       M Dean 17  2   5   1 12  7  7  4  0  3  0  0
## 121     A Madley  5 11   2   3 15 16  7  6  3  2  0  0
## 122     S Hooper 11 17   1   9  6  4  7  3  2  1  0  0
## 123       J Moss 13  6   7   2 13  8  7  3  2  3  0  0
## 124     A Madley 17 15   6   5 13  9  7  6  0  2  0  0
## 125    J Gillett 13 13   5   7  4  6  7  3  0  1  0  0
## 126     A Madley 14  6   6   3 13 15  6  8  2  0  0  0
## 127      G Scott 16  1   4   0 13  7  6  1  1  0  0  0
## 128     P Bankes  6 14   2   5 15 13  6  8  3  3  0  0
## 129      D Coote 11 10   4   2 12  9  6  4  2  3  0  0
## 130   A Marriner  8  8   3   4 12 10  6  5  2  3  0  0
## 131     S Hooper 20  5   4   1 10 16  6  3  0  3  0  0
## 132     M Oliver 14  9   5   4  8 17  6  7  2  3  0  0
## 133   M Atkinson 15  7   6   2 11  5  6  2  1  0  0  0
## 134       M Dean 17  9   6   6  7  4  6  4  1  1  0  0
## 135      R Jones 18  8   4   4 15 14  6  3  2  3  0  0
## 136   C Kavanagh 16  9   4   5 10 11  6  2  1  3  0  0
## 137     A Taylor 12 19   4   8 10  8  6  3  6  0  1  0
## 138    J Gillett 19  9   7   5 12 13  6  2  2  3  0  0
## 139     M Oliver 19  5   9   3 15 12  6  1  2  0  0  0
## 140     C Pawson 20 11   4   4 12 14  6  1  1  3  0  0
## 141      D Coote 13  8   6   4 18 16  6  0  4  3  0  0
## 142     A Taylor 14 14   4   4 15 12  6  2  4  2  0  0
## 143    J Gillett 17 10   7   1 11  4  6  4  1  2  0  0
## 144      G Scott  9 16   1   3 13 11  6  4  2  1  0  0
## 145    P Tierney 31  6  15   3  5  9  6  2  1  1  0  0
## 146    P Tierney 10 18   5   6 12 11  6  4  4  4  0  1
## 147    D England 15 16   5   6  8 10  6  9  1  3  0  0
## 148     A Taylor 15 10   6   6  5 13  6  7  1  2  0  0
## 149   A Marriner 18 13   8   5  7  9  6  9  0  0  0  0
## 150     P Bankes 11  7   1   2  6  7  6  3  2  3  0  0
## 151   C Kavanagh 13 15   4   3  9  9  6  7  4  2  0  0
## 152     A Taylor 20 11   9   3 13 13  6  2  2  3  0  0
## 153    J Gillett 12 16   4   8 11  9  6 11  1  3  1  0
## 154   A Marriner  8  7   1   5 12  9  6  4  2  1  0  0
## 155       M Dean  6 26   1  11  9  7  6  6  3  1  1  0
## 156   C Kavanagh  9 22   2   6 10 13  6  8  1  1  0  0
## 157    S Attwell 13 12   7   4 18  8  6  2  3  1  0  0
## 158      R Jones 15 17   0   7 11  9  6  3  2  2  0  0
## 159     A Madley  8 10   1   3 13 14  6  5  3  3  0  0
## 160   A Marriner 11 11   5   3 13  6  6  5  2  2  0  0
## 161     M Oliver 17 18   6   4 12 10  6  7  1  1  0  0
## 162     A Madley 20 15   9   4  7  6  6  7  0  0  0  0
## 163     P Bankes  9 23   3   6  6  6  6  8  2  1  0  0
## 164     S Hooper 17 16   4   5 11  9  6  5  2  1  0  0
## 165       J Moss 11 14   2   4  7  6  6  1  3  1  0  0
## 166      R Jones  8 18   5   5 12  7  6  6  1  0  0  0
## 167    D England 17  9   7   2 12 13  6  3  2  2  0  0
## 168    J Gillett  8 14   3   5 13 11  6  7  1  3  0  0
## 169     C Pawson 16 10   9   4 11  6  6  1  3  0  0  0
## 170   M Atkinson  7 16   3   5  2 10  6  2  0  1  0  0
## 171    S Attwell 20  2   7   1 13  7  6  0  4  1  0  0
## 172    P Tierney 16 10   8   3 11  9  5  4  1  2  0  0
## 173       J Moss 13  4   6   1 15 11  5  2  0  0  0  0
## 174     C Pawson  9 17   5   3  6 10  5  4  1  2  0  0
## 175    S Attwell 25  8   6   6  9  7  5  4  1  4  0  0
## 176    S Attwell 14  9   4   2 10  7  5  3  1  0  0  0
## 177     M Oliver 12 12   3   2 13  9  5  5  4  3  0  0
## 178       M Dean 15 10   6   3  7  9  5  7  3  4  0  0
## 179    P Tierney  6 25   1   8  4 11  5  8  1  2  0  0
## 180      D Coote 11 13   3   3 10 12  5  4  3  1  0  1
## 181     C Pawson 15 11   3   1  7 10  5  4  1  1  0  0
## 182    P Tierney  8 20   2  10  4 15  5 11  0  1  0  0
## 183       M Dean 28  7   4   3  9 13  5  5  2  2  0  0
## 184     K Friend 15 20   5   7 10  6  5  7  3  2  0  0
## 185    J Gillett 15 20   4   6 19 12  5  6  4  3  0  0
## 186     A Madley 18  5   6   3 12  8  5  5  0  0  0  0
## 187   C Kavanagh 17 14   8   3 11 14  5  8  2  1  0  0
## 188     A Taylor 17  5   7   1 13  8  5  5  1  1  0  0
## 189     A Madley 23  3  13   1 14 16  5  0  0  2  0  1
## 190       M Dean 14  9   3   6  8  5  5  3  2  2  0  0
## 191     P Bankes 10 12   4   1 16  6  5  8  2  2  0  0
## 192     A Taylor 14 13   3   6 14 23  5  0  1  4  0  0
## 193     A Taylor  9  6   5   2  7 13  5  7  3  3  0  0
## 194   M Atkinson  8 17   4   5  8  9  5  7  3  2  0  0
## 195   A Marriner 20  7   6   3  7 14  5  7  0  1  0  0
## 196     J Brooks 16  6   2   1  5  7  5  5  2  3  0  0
## 197     S Hooper 11 26   4  13 10  7  5 11  3  0  0  0
## 198      D Coote 13  9   6   3 11  9  5  1  5  3  0  0
## 199   C Kavanagh 16 12   6   5  9 15  5  2  2  5  0  0
## 200     A Taylor 21  7   8   1  8  9  5  2  2  0  0  1
## 201    S Attwell  7 15   2   2 13  5  5  5  3  2  1  0
## 202    S Attwell 12  5   6   4  9  8  5  2  0  1  0  0
## 203     K Friend 10 15   2   3  8  5  5  7  1  2  0  0
## 204       M Dean 15  7   4   2 16 11  5  1  0  1  1  0
## 205   M Atkinson  9  6   3   1  1  6  5  6  1  0  0  0
## 206      G Scott 21  7  10   0  8  9  5  3  1  1  0  0
## 207   M Atkinson  8 12   5   4  7  6  5  8  0  1  0  0
## 208     M Oliver 13  8   2   3 10  9  5  4  1  2  0  0
## 209   M Atkinson 26  6   5   2  8  9  5  4  1  1  0  0
## 210       J Moss 11  5   4   1  5 17  5  4  0  2  0  0
## 211      D Coote  7 19   4   4  9 12  5 10  1  2  0  0
## 212   A Marriner  6 11   1   5 12  7  5  2  2  0  0  0
## 213     A Taylor 15 10   7   6 13 18  5  5  2  5  0  0
## 214    S Attwell 14  6   7   0 15 10  5  2  2  0  0  0
## 215    D England 10  9   5   0 11 10  5  2  2  2  0  0
## 216     M Oliver  8 14   2   3 13 11  5  2  2  1  1  0
## 217    J Gillett 11 13   4   7  9  3  5  7  1  0  0  0
## 218     C Pawson  9 17   3   6 13 11  5  7  2  1  1  0
## 219     A Taylor 17  6   4   1  7  7  5  3  0  1  0  0
## 220       J Moss  7 12   3   4  4 10  5  7  2  2  0  0
## 221      D Coote 13 11   3   3  8 17  5  4  3  1  0  0
## 222     C Pawson 13 17   1   6 13  9  5  6  1  2  0  0
## 223 T Harrington 17 11   4   2  5 10  5  3  0  3  0  0
## 224     M Oliver 10 18   5   7  8  8  5  2  0  3  2  0
## 225     K Friend 18  7   7   2  9  9  5  6  1  1  0  0
## 226     A Taylor 29  7   8   5  6  3  5  3  1  0  0  0
## 227       J Moss 14 14   3   5  7  9  4  5  1  2  0  0
## 228    P Tierney 10 22   5   6 11  6  4  4  3  3  0  0
## 229    S Attwell 12 18   4   6 11 11  4 11  1  4  0  0
## 230   M Atkinson 14 11   6   6  3  6  4  6  1  1  0  0
## 231       M Dean 17 22   7   9  9 11  4  5  2  2  0  0
## 232    D England 11  9   0   3 10  7  4  2  4  2  0  1
## 233      R Jones 12 12   5   8 10 14  4  8  1  1  0  0
## 234    S Attwell 12 14   5   3  8 10  4  9  2  1  0  0
## 235     M Oliver  5 15   0   4 12 10  4 13  3  2  0  0
## 236     C Pawson 12 10   7   4 12 13  4  4  2  1  0  0
## 237     C Pawson 22 18  11   6  5 17  4  3  0  3  0  0
## 238       J Moss 15 12   6   5  7 10  4  2  1  1  0  0
## 239   M Atkinson 10 14   4   5 10  8  4  3  1  1  0  0
## 240      G Scott 13  4   6   2 14 13  4  6  2  1  0  0
## 241     K Friend 14  7   6   1  6 19  4  2  4  2  0  1
## 242   C Kavanagh 12  8   2   0 13 17  4  2  2  4  1  0
## 243   A Marriner 13 18   4   7 11 12  4  8  1  4  0  0
## 244    S Attwell 24  9   6   5  6 12  4  4  1  3  0  0
## 245     S Hooper 14  5   4   2 11 10  4  3  2  2  0  0
## 246       M Dean  9 17   3   7  8 12  4 11  0  0  0  0
## 247     P Bankes  8 12   5   3  9 16  4  6  2  3  0  0
## 248     S Hooper  9 15   6   4 16 20  4  6  2  4  0  0
## 249      D Coote  4  8   1   1  9  7  4  9  0  2  0  0
## 250       J Moss 17  4   6   0 16 10  4  2  1  1  0  1
## 251    D England 14 13   5   6 12 12  4  5  0  1  0  0
## 252    P Tierney 12 18   1   5 13 13  4  6  3  2  0  0
## 253       M Dean 15 18   5   5  6  9  4  3  3  2  0  0
## 254   M Atkinson 15 14   5   5  6  8  4  5  0  1  0  0
## 255     C Pawson 13 11   2   5 16  9  4  7  1  2  0  0
## 256    P Tierney  5 13   1   5 11 15  4  6  1  2  0  0
## 257       J Moss  9 11   1   6 16  9  4  5  3  2  0  0
## 258   A Marriner  8 22   3   9  7  8  4 12  0  2  0  0
## 259     K Friend 11 10   1   4 12 12  4  4  1  4  0  0
## 260      D Coote  7  9   0   3  4 20  4  4  1  3  0  0
## 261     A Madley 19  9  11   0  6  9  4  4  0  2  0  0
## 262     M Oliver 23  3  15   2  5 11  4  0  0  3  0  0
## 263     K Friend 22 10   3   2  2  7  4  3  0  0  0  0
## 264     P Bankes 14 11   9   1 10  8  4  7  1  1  0  0
## 265   M Atkinson 10 15   4   4  8 10  4  7  1  1  0  0
## 266       J Moss 22 13   5   5  7  7  4  6  2  1  0  0
## 267       J Moss 10 10   6   3  8  7  4  5  2  1  0  0
## 268     A Taylor 12 14   3   6 14  7  4  7  1  1  0  0
## 269    D England 11 15   5   5 15  8  4  9  4  3  0  0
## 270   M Atkinson 15  5   7   1  2  6  4  6  0  1  0  0
## 271     A Taylor 11  6   5   4  9 11  4  1  1  4  0  0
## 272     C Pawson  5 12   0   5 14 10  4  4  3  3  0  0
## 273  M Salisbury 18 19   5   4 12  9  4  7  0  1  0  0
## 274      D Coote 14 12   6   7 13 11  4  5  1  2  0  0
## 275     A Taylor  6 31   2   8  9  5  4  9  3  1  0  0
## 276     A Taylor 12  7   6   5  9 13  4  5  2  3  0  0
## 277   A Marriner 14 19   3   8  4 14  3 11  1  1  0  0
## 278     A Taylor 13 18   3   4 11  8  3 11  2  1  0  0
## 279      D Coote 10  9   2   1  8 18  3  4  3  4  0  0
## 280   M Atkinson  7 14   2   3 12  9  3  5  3  1  0  0
## 281     P Bankes  7  9   5   2 15 14  3  2  3  3  0  0
## 282    P Tierney  6 12   4   3 10 12  3  4  3  3  0  0
## 283    D England 15  6   3   2 13  9  3  7  3  4  0  0
## 284      G Scott 15 20   4   8  9 13  3  5  4  3  0  0
## 285   C Kavanagh  9 21   3   9  7 13  3  6  1  2  1  0
## 286     C Pawson  7 16   3   5 11  6  3  2  1  1  0  0
## 287    P Tierney  4 16   3   7 15  8  3  5  3  1  0  0
## 288     S Hooper 15 18   9   8 14 15  3  6  2  3  0  0
## 289    D England  6 14   4   5  8 11  3  3  4  3  0  0
## 290    P Tierney  8 16   2   7  8 16  3 11  4  3  0  0
## 291   M Atkinson 14 17  10   8  9 10  3  8  1  0  0  0
## 292     M Oliver 13 12   4   5  8 25  3  6  1  1  0  0
## 293       M Dean 11 10   5   3  8 12  3  3  2  2  0  0
## 294   M Atkinson  5 18   1   7  9  6  3  6  1  2  0  0
## 295      G Scott  4 16   2   6 13  7  3  5  1  2  0  0
## 296     A Taylor  9 21   2  11 15  5  3  7  2  2  1  0
## 297      D Coote  6 12   2   3 12 10  3  5  0  0  0  0
## 298      R Jones  6 21   4   9  6  9  3  7  0  1  0  0
## 299     C Pawson 10 16   4   5 17 11  3  7  2  2  0  0
## 300       M Dean  9 19   2   6  9  8  3  8  3  1  0  0
## 301      D Coote 13 13   9   6  8 13  3  6  1  2  0  0
## 302       J Moss 14 27   4  10  6 12  3  8  1  2  0  0
## 303       J Moss 18  6   3   1  9  8  3  3  1  1  0  0
## 304     S Hooper  9  6   2   3 10 10  3  9  1  0  0  0
## 305     C Pawson 10 11   2   1 22 15  3  6  3  4  0  0
## 306   C Kavanagh 11 14   3   3  3  7  3  7  3  3  0  0
## 307    P Tierney 16 15   6   9 13 19  3  3  6  3  0  0
## 308      G Scott 15 12   4   2  8  8  3  7  0  0  0  0
## 309     C Pawson 19 15   3  11 16 11  3  6  4  2  0  0
## 310    P Tierney  6 13   2   8  7 14  3  4  3  2  0  0
## 311     A Taylor 13 14   4   1  8  2  3  5  1  0  0  0
## 312   M Atkinson  9 15   3   7  8 15  3  8  0  2  0  0
## 313     S Hooper  4 15   1   9 17 11  3  5  5  3  0  0
## 314     K Friend  4 24   1  14 11 10  3  3  1  0  0  0
## 315   A Marriner  8 10   1   5  8 12  3  8  2  0  0  0
## 316      R Jones 12 11   3   3 11 12  3  4  1  1  0  0
## 317    J Gillett 16  8   7   2 10 10  3  5  2  2  0  0
## 318     A Taylor 14 10   5   4  8  7  3  6  3  1  0  0
## 319     M Oliver 26  6   5   2 11  9  3  1  1  0  0  1
## 320    P Tierney  7 19   2   6 13  3  3  6  1  2  0  0
## 321     K Friend  9 17   4   5  9 12  3  8  3  5  0  0
## 322       M Dean  8 13   3   7  8  9  3  7  2  2  0  0
## 323   C Kavanagh  9 12   5   4  4  6  3  8  1  0  0  0
## 324    P Tierney 14 14   5   6 11 13  3  2  2  1  1  0
## 325       M Dean 19  8   8   3  9  9  3  3  0  0  0  0
## 326   M Atkinson  6 10   3   4 12 22  3  6  2  4  0  0
## 327       J Moss 12  7   6   2 10  5  3  3  0  1  0  0
## 328   C Kavanagh  9 19   0  13 13  7  3  2  3  1  0  0
## 329     M Oliver  8 22   3   4 12  8  2  5  0  0  0  0
## 330       M Dean 13 11   7   2 18 13  2  4  3  1  0  0
## 331     C Pawson  9 30   4   9  9  8  2 11  2  1  1  0
## 332   M Atkinson 13 17   4  10  5  8  2 11  0  0  0  0
## 333    S Attwell 12 16   4   6  8  7  2 11  1  1  0  0
## 334   A Marriner  7 14   1   4 13  4  2  9  4  1  1  0
## 335    P Tierney 13  7   4   4 11  4  2  4  2  1  0  0
## 336      D Coote 14  6   5   1 16 10  2  5  3  4  1  0
## 337     A Madley  9 16   1   6  8 11  2  5  0  0  0  1
## 338      R Jones 15 15   7   6 14 11  2  4  1  3  0  0
## 339   C Kavanagh  3 17   1   5  4  7  2  8  2  2  0  0
## 340   M Atkinson  8 10   1   4  8 11  2  5  3  1  0  0
## 341     C Pawson 13 13   8   4 11  8  2  4  3  3  0  0
## 342  M Salisbury  9 13   5  10 13 14  2 10  2  3  0  0
## 343     S Hooper  7 20   3   5 13  5  2 11  3  0  0  0
## 344     K Friend  8 15   5   7 12 10  2  5  4  1  0  0
## 345       M Dean  9 22   3   5 11 10  2 10  2  1  0  0
## 346      D Coote  8 23   3  10  7 13  2  8  2  3  0  0
## 347    P Tierney 13  7   4   1  6 10  2  9  1  1  0  1
## 348     A Taylor 21  6   8   3  8 10  2  6  0  3  0  0
## 349   M Atkinson  7 18   1   4  6 11  2  6  3  1  0  0
## 350     K Friend 14 15   8   6 13 14  2  5  1  4  1  0
## 351    D England 12 15   4   6 10 10  2  5  1  2  0  0
## 352     M Oliver 11 13   5   2  9 12  2  4  1  1  0  1
## 353   M Atkinson 19  8   6   1 10  7  2  3  2  3  0  0
## 354 T Harrington 13 10   4   2 12 12  2  5  1  1  0  0
## 355   C Kavanagh  5 13   2   7 11 10  2  3  0  2  0  0
## 356       M Dean  6 21   3   6  9 12  2  9  0  1  0  0
## 357     J Brooks 21  9   6   3 16  8  2  3  4  1  0  0
## 358       J Moss  9 17   4   6 10 12  2  3  0  0  0  0
## 359    P Tierney 16  8   6   4  8 15  2  2  1  3  0  1
## 360      G Scott  7  4   1   2  9 12  1  6  3  2  0  0
## 361     A Taylor 18  9   4   5 15 11  1  3  2  3  0  0
## 362       J Moss  6 19   2   8  4 10  1  9  0  0  0  0
## 363     M Oliver  5 16   1   5  9 12  1  9  1  2  0  0
## 364   A Marriner 11 19   5   7 10 10  1  9  1  3  0  0
## 365   A Marriner  9 21   2  12 11  7  1  4  3  1  0  0
## 366     M Oliver  6 21   1   4  8 11  1 12  0  1  0  0
## 367    S Attwell 12 13   8   4 12 13  1  4  4  0  0  0
## 368     C Pawson 13 16   7   4  5 11  1  5  1  2  0  0
## 369   A Marriner  9  9   2   3  9  9  1  6  0  1  0  0
## 370     C Pawson  3 18   1   6 11  6  1  8  1  0  0  0
## 371     P Bankes 12  5   4   2  6 13  1  2  1  1  0  0
## 372     C Pawson 14 14   7   5  9 12  1  7  3  4  0  0
## 373     A Taylor  5 17   0   4 10 14  1  5  1  0  1  0
## 374       M Dean  6 16   0   5  5 12  1 13  1  2  0  0
## 375   C Kavanagh 13 16   4   4 11 15  1  5  1  3  0  0
## 376   M Atkinson  4 24   2   5  6  6  1  9  2  0  0  0
## 377      G Scott  7  8   3   2 15  5  0  4  0  2  0  0
## 378    P Tierney  6 19   1   6 14 12  0  2  3  2  0  0
## 379    P Tierney  6 12   5   3 11 15  0  2  0  2  0  0
## 380   A Marriner  4 24   2  10 11 11  0  6  1  3  0  0

Select columns

select(data, FTR, HC, AC)
##     FTR HC AC
## 1     H  2  5
## 2     H  5  4
## 3     A  7  6
## 4     H  5  2
## 5     H  6  8
## 6     H  5  4
## 7     H  2  4
## 8     A  3 11
## 9     A  7  6
## 10    H  3 11
## 11    H  8  4
## 12    H  3  4
## 13    D  3  5
## 14    D  8  5
## 15    H  6  1
## 16    H  7  2
## 17    D  7  7
## 18    A  5  4
## 19    A  9  8
## 20    H 10  0
## 21    H 14  0
## 22    D  3  2
## 23    A  4  5
## 24    D  4  4
## 25    A  9  9
## 26    D  5  3
## 27    D 12  3
## 28    D  5  5
## 29    H 10  3
## 30    A  5  7
## 31    H  8  2
## 32    H  8  4
## 33    A  1  6
## 34    A  5  8
## 35    H  7  3
## 36    D  5  4
## 37    A  6  8
## 38    H  4 11
## 39    A  2 11
## 40    H  4  6
## 41    D  4  5
## 42    A  4  2
## 43    A  8  3
## 44    H 10  5
## 45    D  8  5
## 46    A  4  8
## 47    H  5  4
## 48    H  4  9
## 49    A  2 11
## 50    A  5 11
## 51    A  4 13
## 52    A  5  5
## 53    H  6  4
## 54    A  5  7
## 55    D  8  4
## 56    D  5  6
## 57    D  2 11
## 58    A  5  5
## 59    H  4  4
## 60    D  6  5
## 61    D 10  1
## 62    D  9  5
## 63    H  7  2
## 64    H  6  3
## 65    H  0  4
## 66    D  8  5
## 67    D  1  3
## 68    H  5  8
## 69    A 11  6
## 70    D  3  4
## 71    A  1  9
## 72    A  6  7
## 73    H  4  3
## 74    H  6  2
## 75    D  8  4
## 76    H  8  1
## 77    A  5  5
## 78    A  7  9
## 79    A  2  9
## 80    D  6  4
## 81    H  7  4
## 82    H  5  0
## 83    D  3  7
## 84    A  3  5
## 85    D  6  3
## 86    D  6  2
## 87    A  7  6
## 88    A  9  2
## 89    H  2  4
## 90    A  6  3
## 91    A  7  6
## 92    H  4  2
## 93    D  5  3
## 94    A  7  1
## 95    A  0  2
## 96    A  5  8
## 97    A 10  2
## 98    A  5  0
## 99    A  3  6
## 100   H  4  3
## 101   H 10  8
## 102   A  1  9
## 103   A  6  2
## 104   D 14  2
## 105   H  4  6
## 106   D  2  5
## 107   H  4  2
## 108   D  4  2
## 109   D 10  5
## 110   H  3  2
## 111   A  3  5
## 112   H  5  7
## 113   D  3  6
## 114   D  8  2
## 115   H  5  7
## 116   H  9  3
## 117   H  7  3
## 118   H  6  1
## 119   H  7  1
## 120   H  4  8
## 121   H  4  4
## 122   A  7  3
## 123   H  5  7
## 124   D  4  3
## 125   D  6  1
## 126   H  3  3
## 127   H  8  6
## 128   H  8  4
## 129   D 15  2
## 130   D  2  5
## 131   H  7  4
## 132   D  2  4
## 133   A  6  0
## 134   D  9  5
## 135   D  5  5
## 136   A  4 11
## 137   A  3 11
## 138   H 11  5
## 139   H  3  8
## 140   H  1  9
## 141   H 10  3
## 142   D  6  2
## 143   A  2  8
## 144   A  5 11
## 145   D  5  1
## 146   H  9  6
## 147   H  6  4
## 148   H  3  6
## 149   H  3  3
## 150   H  8  2
## 151   H 14  1
## 152   H  9  8
## 153   H  5  2
## 154   H 11  3
## 155   A  8  6
## 156   D  6  4
## 157   H  4  6
## 158   H  8  2
## 159   A  7 10
## 160   H  6  2
## 161   A  7  4
## 162   D  4  6
## 163   H  5  2
## 164   D  7  1
## 165   H 11  0
## 166   A  1  4
## 167   A  3  6
## 168   D  4  9
## 169   D  6  4
## 170   H 14  4
## 171   A  3  5
## 172   H  4  2
## 173   A 10  2
## 174   A  2  5
## 175   H  6  9
## 176   D  2  4
## 177   H  8  8
## 178   D  3  7
## 179   A  4  5
## 180   H  1 12
## 181   D 10  8
## 182   A  3  5
## 183   H  7  5
## 184   A  5  5
## 185   A  3  7
## 186   A  9  1
## 187   H  3  7
## 188   A  8  5
## 189   H  9  3
## 190   D  6  7
## 191   A  3  8
## 192   H  5  2
## 193   H 11  2
## 194   D  9  0
## 195   H  9  1
## 196   D  4  6
## 197   H  8  8
## 198   H  2 10
## 199   D  3  6
## 200   H  9  0
## 201   A  4  3
## 202   D  5  7
## 203   A  3  8
## 204   A  6  9
## 205   A  5  1
## 206   A  9  2
## 207   A  6  3
## 208   A  6  7
## 209   H  3  3
## 210   D  2 11
## 211   D 12  4
## 212   A  2  5
## 213   D  4  5
## 214   H 10  3
## 215   D  4  7
## 216   H  6  2
## 217   H  5  6
## 218   D  2 10
## 219   H  9  3
## 220   D  4  6
## 221   A  2  8
## 222   D  6 11
## 223   H  7  6
## 224   A  7  4
## 225   D  1  4
## 226   D  3  9
## 227   H  5  3
## 228   A  4  5
## 229   A  4 12
## 230   A  5  8
## 231   H  3  6
## 232   A  7  3
## 233   D  5  4
## 234   H 10  2
## 235   D  3  7
## 236   H 14  0
## 237   A 10  5
## 238   A  4  4
## 239   A  4  4
## 240   H  9  4
## 241   H  4  4
## 242   A 10  0
## 243   A  3  3
## 244   H  7 10
## 245   H  3  7
## 246   A  6  4
## 247   H  4  0
## 248   H  5  4
## 249   H 13  6
## 250   A  3  6
## 251   A  6  6
## 252   D  5  4
## 253   D  4  3
## 254   A  7  2
## 255   A  3  4
## 256   H  3  5
## 257   A  6  8
## 258   H  5 10
## 259   H  4  7
## 260   A  5  2
## 261   H  4  7
## 262   A  5  5
## 263   A  7  7
## 264   H  4  6
## 265   A  1  5
## 266   H  9  3
## 267   H  5  2
## 268   A  3  8
## 269   A 12  5
## 270   H  5  2
## 271   A  3  5
## 272   A  7  6
## 273   H  2  9
## 274   H  4  5
## 275   H  7  2
## 276   A  5  2
## 277   H  6  2
## 278   A 11  3
## 279   H  5  7
## 280   H  2  6
## 281   D  2  6
## 282   A  6  3
## 283   A  1  6
## 284   H  5  7
## 285   A  2  5
## 286   A  6  5
## 287   H  2  5
## 288   H  5  3
## 289   H  9  3
## 290   D 11  2
## 291   A  1  8
## 292   A 12  7
## 293   D  4  7
## 294   H  4  9
## 295   D  6  5
## 296   H  2  4
## 297   H  2  3
## 298   H  0  2
## 299   H  9  6
## 300   H  1  2
## 301   H  5  7
## 302   A 11  2
## 303   A  3  3
## 304   A  3  8
## 305   A  9  3
## 306   H  4  6
## 307   H  3  4
## 308   H  6  7
## 309   D  4  1
## 310   A  4  4
## 311   H  6  7
## 312   H  6  8
## 313   A  6  5
## 314   H  3  5
## 315   D 13  4
## 316   H 10  2
## 317   A  6  1
## 318   D  5  4
## 319   H  2  5
## 320   H  7  4
## 321   H 10 10
## 322   H  1  7
## 323   D  7  6
## 324   H 11  4
## 325   A  2  3
## 326   D 12  8
## 327   D  6  6
## 328   H  3  6
## 329   H  3  1
## 330   H 13  1
## 331   D  6  3
## 332   D  2  9
## 333   A  0  6
## 334   H  2  3
## 335   A  6  7
## 336   A  5  6
## 337   A  7  3
## 338   A  3  6
## 339   H  3  8
## 340   H  7  3
## 341   A  3  7
## 342   H  3  8
## 343   H  4  7
## 344   A  4  5
## 345   D  9  3
## 346   H  8  5
## 347   H  7  6
## 348   D 11  5
## 349   H  8  2
## 350   A  6  1
## 351   A  9  5
## 352   H  8  2
## 353   A  2  3
## 354   A  1  5
## 355   H 10  2
## 356   D  1 13
## 357   A  6  2
## 358   H  2  2
## 359   H  8  2
## 360   D  1  5
## 361   D  8  1
## 362   A  7  3
## 363   D  4  9
## 364   D  5  3
## 365   A  5  2
## 366   H 12  8
## 367   A  1  9
## 368   H  4  5
## 369   D 13  6
## 370   D  6  0
## 371   H 12  2
## 372   A  3  2
## 373   H  5  6
## 374   A  8  2
## 375   H  3  3
## 376   H  3  6
## 377   H  3  3
## 378   H  5  3
## 379   H 13  1
## 380   A  3  2

Add columns

transmute(data,
       gain = HC - AC)
##     gain
## 1     -3
## 2      1
## 3      1
## 4      3
## 5     -2
## 6      1
## 7     -2
## 8     -8
## 9      1
## 10    -8
## 11     4
## 12    -1
## 13    -2
## 14     3
## 15     5
## 16     5
## 17     0
## 18     1
## 19     1
## 20    10
## 21    14
## 22     1
## 23    -1
## 24     0
## 25     0
## 26     2
## 27     9
## 28     0
## 29     7
## 30    -2
## 31     6
## 32     4
## 33    -5
## 34    -3
## 35     4
## 36     1
## 37    -2
## 38    -7
## 39    -9
## 40    -2
## 41    -1
## 42     2
## 43     5
## 44     5
## 45     3
## 46    -4
## 47     1
## 48    -5
## 49    -9
## 50    -6
## 51    -9
## 52     0
## 53     2
## 54    -2
## 55     4
## 56    -1
## 57    -9
## 58     0
## 59     0
## 60     1
## 61     9
## 62     4
## 63     5
## 64     3
## 65    -4
## 66     3
## 67    -2
## 68    -3
## 69     5
## 70    -1
## 71    -8
## 72    -1
## 73     1
## 74     4
## 75     4
## 76     7
## 77     0
## 78    -2
## 79    -7
## 80     2
## 81     3
## 82     5
## 83    -4
## 84    -2
## 85     3
## 86     4
## 87     1
## 88     7
## 89    -2
## 90     3
## 91     1
## 92     2
## 93     2
## 94     6
## 95    -2
## 96    -3
## 97     8
## 98     5
## 99    -3
## 100    1
## 101    2
## 102   -8
## 103    4
## 104   12
## 105   -2
## 106   -3
## 107    2
## 108    2
## 109    5
## 110    1
## 111   -2
## 112   -2
## 113   -3
## 114    6
## 115   -2
## 116    6
## 117    4
## 118    5
## 119    6
## 120   -4
## 121    0
## 122    4
## 123   -2
## 124    1
## 125    5
## 126    0
## 127    2
## 128    4
## 129   13
## 130   -3
## 131    3
## 132   -2
## 133    6
## 134    4
## 135    0
## 136   -7
## 137   -8
## 138    6
## 139   -5
## 140   -8
## 141    7
## 142    4
## 143   -6
## 144   -6
## 145    4
## 146    3
## 147    2
## 148   -3
## 149    0
## 150    6
## 151   13
## 152    1
## 153    3
## 154    8
## 155    2
## 156    2
## 157   -2
## 158    6
## 159   -3
## 160    4
## 161    3
## 162   -2
## 163    3
## 164    6
## 165   11
## 166   -3
## 167   -3
## 168   -5
## 169    2
## 170   10
## 171   -2
## 172    2
## 173    8
## 174   -3
## 175   -3
## 176   -2
## 177    0
## 178   -4
## 179   -1
## 180  -11
## 181    2
## 182   -2
## 183    2
## 184    0
## 185   -4
## 186    8
## 187   -4
## 188    3
## 189    6
## 190   -1
## 191   -5
## 192    3
## 193    9
## 194    9
## 195    8
## 196   -2
## 197    0
## 198   -8
## 199   -3
## 200    9
## 201    1
## 202   -2
## 203   -5
## 204   -3
## 205    4
## 206    7
## 207    3
## 208   -1
## 209    0
## 210   -9
## 211    8
## 212   -3
## 213   -1
## 214    7
## 215   -3
## 216    4
## 217   -1
## 218   -8
## 219    6
## 220   -2
## 221   -6
## 222   -5
## 223    1
## 224    3
## 225   -3
## 226   -6
## 227    2
## 228   -1
## 229   -8
## 230   -3
## 231   -3
## 232    4
## 233    1
## 234    8
## 235   -4
## 236   14
## 237    5
## 238    0
## 239    0
## 240    5
## 241    0
## 242   10
## 243    0
## 244   -3
## 245   -4
## 246    2
## 247    4
## 248    1
## 249    7
## 250   -3
## 251    0
## 252    1
## 253    1
## 254    5
## 255   -1
## 256   -2
## 257   -2
## 258   -5
## 259   -3
## 260    3
## 261   -3
## 262    0
## 263    0
## 264   -2
## 265   -4
## 266    6
## 267    3
## 268   -5
## 269    7
## 270    3
## 271   -2
## 272    1
## 273   -7
## 274   -1
## 275    5
## 276    3
## 277    4
## 278    8
## 279   -2
## 280   -4
## 281   -4
## 282    3
## 283   -5
## 284   -2
## 285   -3
## 286    1
## 287   -3
## 288    2
## 289    6
## 290    9
## 291   -7
## 292    5
## 293   -3
## 294   -5
## 295    1
## 296   -2
## 297   -1
## 298   -2
## 299    3
## 300   -1
## 301   -2
## 302    9
## 303    0
## 304   -5
## 305    6
## 306   -2
## 307   -1
## 308   -1
## 309    3
## 310    0
## 311   -1
## 312   -2
## 313    1
## 314   -2
## 315    9
## 316    8
## 317    5
## 318    1
## 319   -3
## 320    3
## 321    0
## 322   -6
## 323    1
## 324    7
## 325   -1
## 326    4
## 327    0
## 328   -3
## 329    2
## 330   12
## 331    3
## 332   -7
## 333   -6
## 334   -1
## 335   -1
## 336   -1
## 337    4
## 338   -3
## 339   -5
## 340    4
## 341   -4
## 342   -5
## 343   -3
## 344   -1
## 345    6
## 346    3
## 347    1
## 348    6
## 349    6
## 350    5
## 351    4
## 352    6
## 353   -1
## 354   -4
## 355    8
## 356  -12
## 357    4
## 358    0
## 359    6
## 360   -4
## 361    7
## 362    4
## 363   -5
## 364    2
## 365    3
## 366    4
## 367   -8
## 368   -1
## 369    7
## 370    6
## 371   10
## 372    1
## 373   -1
## 374    6
## 375    0
## 376   -3
## 377    0
## 378    2
## 379   12
## 380    1

Summarize by groups

data %>%
    group_by(HomeTeam) %>%
    summarise(avg.home.corners = mean(HC, na.rm = TRUE)) %>%
    arrange(avg.home.corners)
## # A tibble: 20 × 2
##    HomeTeam       avg.home.corners
##    <chr>                     <dbl>
##  1 Newcastle                  4.05
##  2 Watford                    4.42
##  3 Brentford                  4.63
##  4 Wolves                     4.63
##  5 Aston Villa                4.74
##  6 Crystal Palace             4.79
##  7 Everton                    4.89
##  8 Leicester                  4.89
##  9 Man United                 5   
## 10 Leeds                      5.05
## 11 Norwich                    5.26
## 12 Burnley                    5.37
## 13 Tottenham                  5.58
## 14 West Ham                   5.58
## 15 Southampton                6.05
## 16 Brighton                   6.21
## 17 Arsenal                    6.68
## 18 Chelsea                    7.26
## 19 Liverpool                  8   
## 20 Man City                   8.95