SELECT * FROM 1_Kampe WHERE LigaID = '14' AND (Home='Ipswich' OR Away='Ipswich') 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
2019-08-03 Burton 0-1 Ipswich 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
2019-08-10 Ipswich 1-1 Sunderland 1/1 1,00 3.00/1 3.00/1 0.00/0 3.00/1   1/0 2,00 1.00/1 1.00/1 1.00/1 0.00/0
2019-08-17 Peterborough 2-2 Ipswich 1/-3 2,50 0.00/2 0.00/2 0.00/1 0.00/1   2/1 1,50 2.00/2 2.00/2 1.00/1 3.00/1
2019-08-20 Ipswich 2-1 AFC Wimbledon 4/1 2,33 1.67/3 1.67/3 1.00/1 2.00/2   3/-2 2,67 0.33/3 0.33/3 0.50/2 0.00/1
2019-08-24 Bolton 0-5 Ipswich 0/-7 2,33 0.33/3 0.33/3 1.00/1 0.00/2   6/2 2,50 2.00/4 2.00/4 2.00/2 2.00/2
2019-08-31 Ipswich 3-0 Shrewsbury 11/7 3,00 2.20/5 2.20/5 2.00/2 2.33/3   4/1 1,40 1.60/5 1.60/5 1.67/3 1.50/2
2019-09-14 Ipswich 0-0 Doncaster 14/10 3,00 2.33/6 2.33/6 2.33/3 2.33/3   9/3 3,00 2.20/5 2.20/5 2.50/4 1.00/1
2019-09-17 MK Dons 0-1 Ipswich 11/0 3,14 1.71/7 1.71/7 2.25/4 1.00/3   14/10 2,57 2.14/7 2.14/7 2.00/4 2.33/3
2019-09-21 Gillingham 0-1 Ipswich 14/5 2,88 1.25/8 1.25/8 1.75/4 0.75/4   15/11 2,38 2.25/8 2.25/8 2.00/4 2.50/4
2019-09-28 Ipswich 4-1 Tranmere 16/12 2,22 2.33/9 2.25/8 2.00/4 2.60/5   14/-2 3,33 1.00/9 1.13/8 1.60/5 0.25/4
2019-10-05 Fleetwood 0-1 Ipswich 20/7 3,30 2.00/10 1.75/8 2.60/5 1.40/5   20/15 2,50 2.40/10 2.50/8 2.20/5 2.60/5
2019-10-20 Accrington 2-0 Ipswich 15/-6 3,00 0.92/12 1.25/8 1.00/5 0.86/7   21/16 2,36 2.45/11 2.75/8 2.20/5 2.67/6
2019-10-23 Ipswich 0-2 Rotherham 21/14 2,33 2.25/12 2.38/8 2.20/5 2.29/7   19/7 2,58 1.50/12 1.38/8 1.33/6 1.67/6
2019-10-26 Southend 1-3 Ipswich 15/-25 3,93 0.36/14 0.63/8 0.14/7 0.57/7   21/12 2,31 2.08/13 2.00/8 1.83/6 2.29/7
2019-11-05 Rochdale 0-1 Ipswich 20/-7 2,94 1.19/16 1.13/8 1.13/8 1.25/8   24/14 2,43 2.14/14 2.00/8 1.83/6 2.38/8
2019-11-23 Ipswich 2-2 Blackpool 25/15 2,33 2.20/15 2.25/8 1.83/6 2.44/9   24/5 2,53 1.65/17 1.63/8 1.89/9 1.38/8
2019-11-26 Ipswich 0-0 Wycombe 27/15 2,44 2.13/16 2.00/8 1.71/7 2.44/9   28/14 2,33 2.17/18 2.50/8 2.60/10 1.63/8
2019-12-07 Coventry 1-1 Ipswich 23/3 2,39 1.67/18 1.25/8 2.30/10 0.88/8   27/15 2,29 2.06/17 1.75/8 1.63/8 2.44/9
2019-12-14 Ipswich 1-2 Bristol Rovers 28/15 2,28 2.00/18 1.50/8 1.63/8 2.30/10   27/3 2,83 1.72/18 2.00/8 1.90/10 1.50/8
2019-12-21 Portsmouth 1-0 Ipswich 29/5 2,79 1.47/19 1.88/8 2.00/10 0.89/9   29/14 2,32 1.89/19 1.13/8 1.44/9 2.30/10
2019-12-26 Ipswich 0-0 Gillingham 29/13 2,25 1.80/20 1.13/8 1.44/9 2.09/11   26/3 2,33 1.33/21 1.75/8 1.73/11 0.90/10
2019-12-29 Lincoln 5-3 Ipswich 21/-3 2,14 1.14/21 1.00/8 2.00/8 0.62/13   29/13 2,14 1.76/21 1.25/8 1.40/10 2.09/11
2020-01-01 Wycombe 1-1 Ipswich 31/10 2,26 1.87/23 1.63/8 2.42/12 1.27/11   32/11 2,41 1.68/22 0.88/8 1.40/10 1.92/12
2020-01-11 Ipswich 4-1 Accrington 33/11 2,39 1.65/23 0.63/8 1.40/10 1.85/13   34/1 2,79 1.21/24 1.75/8 1.55/11 0.92/13
2020-01-14 Oxford Utd 0-0 Ipswich 42/17 2,79 1.63/24 1.63/8 2.09/11 1.23/13   37/14 2,50 1.71/24 0.88/8 1.55/11 1.85/13
2020-01-18 Tranmere 1-2 Ipswich 27/-16 2,92 0.92/24 0.75/8 1.17/12 0.67/12   37/14 2,40 1.68/25 0.88/8 1.55/11 1.79/14
2020-01-25 Ipswich 1-0 Lincoln 39/15 2,42 1.73/26 1.13/8 1.55/11 1.87/15   36/3 2,56 1.37/27 1.63/8 2.33/12 0.60/15
2020-01-28 Rotherham 1-0 Ipswich 49/21 2,85 1.74/27 2.13/8 1.62/13 1.86/14   40/16 2,37 1.78/27 1.50/8 1.67/12 1.87/15
2020-02-01 Ipswich 1-4 Peterborough 40/15 2,32 1.71/28 1.50/8 1.67/12 1.75/16   52/16 3,03 1.59/29 1.25/8 2.14/14 1.07/15
2020-02-08 Sunderland 1-0 Ipswich 37/11 2,25 1.61/28 2.13/8 1.93/14 1.29/14   41/12 2,41 1.66/29 1.38/8 1.54/13 1.75/16
2020-02-11 AFC Wimbledon 0-0 Ipswich 35/-9 2,72 0.97/29 1.00/8 1.40/15 0.50/14   41/11 2,37 1.60/30 1.38/8 1.54/13 1.65/17
2020-02-15 Ipswich 4-1 Burton 41/11 2,29 1.58/31 1.38/8 1.54/13 1.61/18   41/3 2,63 1.43/30 1.63/8 1.60/15 1.27/15
2020-02-22 Ipswich 0-1 Oxford Utd 45/14 2,38 1.63/32 1.38/8 1.64/14 1.61/18   52/18 2,77 1.55/31 1.13/8 2.00/15 1.13/16
2020-02-29 Blackpool 2-1 Ipswich 41/1 2,53 1.28/32 0.88/8 1.73/15 0.88/17   45/13 2,33 1.58/33 1.25/8 1.53/15 1.61/18
2020-03-03 Ipswich 0-1 Fleetwood 46/12 2,35 1.53/34 0.88/8 1.53/15 1.53/19   48/12 2,63 1.72/32 2.25/8 2.12/17 1.27/15
2020-03-07 Ipswich 0-1 Coventry 46/11 2,31 1.49/35 0.50/8 1.44/16 1.53/19   47/17 2,33 1.94/33 2.50/8 2.24/17 1.63/16
2020-03-14 Bristol Rovers - Ipswich / /0 / / /   / /0 / / /
2020-03-21 Ipswich - Portsmouth / /0 / / /   / /0 / / /
2020-04-04 Ipswich - Southend / /0 / / /   / /0 / / /
2020-04-10 Ipswich - Bolton / /0 / / /   / /0 / / /
2020-04-13 Shrewsbury - Ipswich / /0 / / /   / /0 / / /
2020-04-18 Ipswich - Rochdale / /0 / / /   / /0 / / /
2020-04-25 Doncaster - Ipswich / /0 / / /   / /0 / / /
2020-05-03 Ipswich - MK Dons / /0 / / /   / /0 / / /