SELECT * FROM 1_Kampe WHERE LigaID = '320' AND (Home='Nottingham' OR Away='Nottingham') ORDER BY Dato ASC;
Dato Home Score Away H Goals/Dif A Goals Av. H Avp/M H Avp Last/M H Avp Home/M H Avp Away/M   A Goals/Dif A Goals Av. A Avp/M A Avp Last/M A Avp Home/M A Avp Away/M
2021-08-08 Coventry 2-1 Nottingham 0/0 0,00 0.00/0 0.00/0 0.00/0 0.00/0   0/0 0,00 0.00/0 0.00/0 0.00/0 0.00/0
2021-08-14 Nottingham 1-2 Bournemouth 1/-1 3,00 0.00/1 0.00/1 0.00/0 0.00/1   2/0 4,00 1.00/1 1.00/1 1.00/1 0.00/0
2021-08-18 Nottingham 1-2 Blackburn 2/-2 3,00 0.00/2 0.00/2 0.00/1 0.00/1   3/1 2,50 2.00/2 2.00/2 3.00/1 1.00/1
2021-08-21 Stoke 1-0 Nottingham 6/3 3,00 2.33/3 2.33/3 3.00/1 2.00/2   3/-3 3,00 0.00/3 0.00/3 0.00/2 0.00/1
2021-08-28 Derby 1-1 Nottingham 3/0 1,50 1.25/4 1.25/4 1.00/2 1.50/2   3/-4 2,50 0.00/4 0.00/4 0.00/2 0.00/2
2021-09-12 Nottingham 1-2 Cardiff 4/-4 2,40 0.20/5 0.20/5 0.00/2 0.33/3   9/3 3,00 1.60/5 1.60/5 1.33/3 2.00/2
2021-09-15 Nottingham 0-2 Middlesbrough 5/-5 2,50 0.17/6 0.17/6 0.00/3 0.33/3   6/-2 2,33 1.00/6 1.00/6 1.33/3 0.67/3
2021-09-18 Huddersfield 0-2 Nottingham 13/4 3,14 1.86/7 1.86/7 2.00/3 1.75/4   5/-7 2,43 0.14/7 0.14/7 0.00/4 0.33/3
2021-09-25 Nottingham 1-1 Millwall 7/-5 2,38 0.50/8 0.50/8 0.00/4 1.00/4   8/-2 2,25 1.00/8 1.00/8 1.25/4 0.75/4
2021-09-29 Barnsley 1-3 Nottingham 6/-4 1,78 0.89/9 0.88/8 1.25/4 0.60/5   8/-5 2,33 0.56/9 0.63/8 0.20/5 1.00/4
2021-10-02 Birmingham 0-3 Nottingham 10/-2 2,20 1.20/10 1.00/8 1.00/5 1.40/5   11/-3 2,50 0.80/10 1.00/8 0.20/5 1.40/5
2021-10-16 Nottingham 2-1 Blackpool 14/0 2,55 1.00/11 1.38/8 0.20/5 1.67/6   11/-3 2,27 1.36/11 1.75/8 1.50/6 1.20/5
2021-10-19 Bristol City 1-2 Nottingham 14/-1 2,42 1.33/12 1.50/8 0.67/6 2.00/6   16/1 2,58 1.17/12 1.75/8 0.67/6 1.67/6
2021-10-24 Nottingham 0-4 Fulham 18/2 2,62 1.31/13 2.00/8 0.67/6 1.86/7   29/15 3,31 2.00/13 1.63/8 2.29/7 1.67/6
2021-10-29 QPR 1-1 Nottingham 25/3 3,36 1.50/14 1.13/8 2.00/7 1.00/7   18/-2 2,71 1.21/14 2.00/8 0.57/7 1.86/7
2021-11-02 Nottingham 1-1 Sheffield Utd 19/-2 2,67 1.20/15 2.13/8 0.57/7 1.75/8   20/-2 2,80 1.20/15 1.50/8 1.25/8 1.14/7
2021-11-06 Nottingham 3-0 Preston 20/-2 2,63 1.19/16 1.88/8 0.63/8 1.75/8   18/-1 2,31 1.31/16 1.50/8 1.88/8 0.75/8
2021-11-20 Reading 1-1 Nottingham 22/-6 2,94 1.29/17 1.13/8 1.63/8 1.00/9   23/1 2,65 1.29/17 2.13/8 0.89/9 1.75/8
2021-11-23 Nottingham 0-0 Luton 24/1 2,61 1.28/18 1.88/8 0.89/9 1.67/9   26/2 2,78 1.33/18 1.38/8 1.67/9 1.00/9
2021-11-26 West Brom 0-0 Nottingham 27/11 2,26 1.74/19 1.38/8 2.33/9 1.20/10   24/1 2,47 1.26/19 1.63/8 0.90/10 1.67/9
2021-12-04 Nottingham 2-0 Peterborough 24/1 2,35 1.25/20 1.38/8 0.90/10 1.60/10   17/-21 2,75 0.80/20 1.00/8 1.30/10 0.30/10
2021-12-11 Swansea 1-4 Nottingham 25/-2 2,48 1.29/21 1.25/8 1.60/10 1.00/11   26/3 2,33 1.33/21 1.38/8 1.09/11 1.60/10
2021-12-18 Nottingham 2-1 Hull 30/6 2,45 1.41/22 1.75/8 1.09/11 1.73/11   19/-7 2,05 1.05/22 1.75/8 1.09/11 1.00/11
2021-12-26 Middlesbrough 2-0 Nottingham 25/2 2,09 1.43/23 1.50/8 1.67/12 1.18/11   32/7 2,48 1.48/23 2.00/8 1.25/12 1.73/11
2021-12-30 Nottingham 0-1 Huddersfield 32/5 2,46 1.42/24 1.88/8 1.25/12 1.58/12   31/2 2,50 1.50/24 1.38/8 1.92/12 1.08/12
2022-01-15 Millwall 0-1 Nottingham 27/0 2,25 1.38/24 1.13/8 1.73/11 1.08/13   32/4 2,40 1.36/25 1.50/8 1.15/13 1.58/12
2022-01-22 Nottingham 2-1 Derby 33/5 2,35 1.42/26 1.75/8 1.15/13 1.69/13   25/1 1,88 1.35/26 1.75/8 1.77/13 0.92/13
2022-01-25 Nottingham 3-0 Barnsley 35/6 2,37 1.48/27 2.00/8 1.29/14 1.69/13   17/-21 2,20 0.56/25 0.38/8 0.83/12 0.31/13
2022-01-30 Cardiff 2-1 Nottingham 28/-19 2,88 0.88/26 0.63/8 0.58/12 1.14/14   38/9 2,39 1.54/28 2.25/8 1.40/15 1.69/13
2022-02-09 Blackburn 0-2 Nottingham 45/14 2,53 1.77/30 1.75/8 2.20/15 1.33/15   39/8 2,41 1.48/29 1.88/8 1.40/15 1.57/14
2022-02-12 Nottingham 2-2 Stoke 41/10 2,40 1.53/30 1.88/8 1.40/15 1.67/15   36/6 2,28 1.45/29 1.00/8 1.60/15 1.29/14
2022-02-22 Preston 0-0 Nottingham 37/-1 2,27 1.36/33 1.50/8 1.44/16 1.29/17   43/10 2,45 1.52/31 1.63/8 1.38/16 1.67/15
2022-02-26 Nottingham 2-0 Bristol City 43/10 2,38 1.50/32 1.75/8 1.38/16 1.63/16   45/-16 3,12 1.18/34 1.25/8 1.44/18 0.88/16
2022-03-04 Sheffield Utd 1-1 Nottingham 44/10 2,36 1.61/33 2.13/8 1.80/15 1.44/18   45/12 2,36 1.55/33 2.13/8 1.47/17 1.63/16
2022-03-12 Nottingham 4-0 Reading 46/12 2,35 1.53/34 1.88/8 1.47/17 1.59/17   42/-26 3,14 1.00/35 0.88/8 1.06/18 0.94/17
2022-03-16 Nottingham 3-1 QPR 50/16 2,40 1.57/35 1.88/8 1.56/18 1.59/17   52/10 2,61 1.64/36 1.00/8 1.74/19 1.53/17
2022-04-02 Blackpool 1-4 Nottingham 42/1 2,24 1.41/37 1.50/8 1.65/20 1.12/17   53/18 2,44 1.61/36 1.88/8 1.63/19 1.59/17
2022-04-06 Nottingham 2-0 Coventry 57/21 2,51 1.65/37 2.25/8 1.63/19 1.67/18   51/3 2,54 1.44/39 1.13/8 1.67/21 1.17/18
2022-04-09 Nottingham 2-0 Birmingham 59/23 2,50 1.68/38 2.25/8 1.70/20 1.67/18   43/-15 2,53 1.13/40 1.13/8 1.30/20 0.95/20
2022-04-15 Luton 1-0 Nottingham 59/12 2,59 1.59/41 1.38/8 1.80/20 1.38/21   61/25 2,49 1.72/39 2.50/8 1.76/21 1.67/18
2022-04-18 Nottingham 4-0 West Brom 61/24 2,45 1.68/40 2.38/8 1.76/21 1.58/19   47/6 2,10 1.43/42 1.75/8 1.90/21 0.95/21
2022-04-23 Peterborough 0-1 Nottingham 38/-45 2,81 0.79/43 1.50/8 1.05/21 0.55/22   65/28 2,49 1.71/41 2.38/8 1.82/22 1.58/19
2022-04-26 Fulham 0-1 Nottingham 99/61 3,19 2.02/43 1.38/8 2.05/21 2.00/22   66/29 2,45 1.74/42 2.63/8 1.82/22 1.65/20
2022-04-30 Nottingham 5-1 Swansea 67/30 2,42 1.77/43 2.63/8 1.82/22 1.71/21   57/-5 2,70 1.39/44 1.75/8 1.59/22 1.18/22
2022-05-03 Bournemouth 1-0 Nottingham 72/33 2,52 1.86/44 1.63/8 1.90/21 1.83/23   72/34 2,50 1.80/44 2.63/8 1.87/23 1.71/21
2022-05-07 Hull 1-1 Nottingham 40/-13 2,07 1.11/45 1.50/8 1.09/22 1.13/23   72/33 2,47 1.76/45 2.25/8 1.87/23 1.64/22