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

0-0

Ipswich

38/-11

2,49

1.29/35

0.88/8

1.50/18

1.06/17

46/10

2,28

1.44/36

0.50/8

1.35/17

1.53/19

2020-03-21

Ipswich

0-0

Portsmouth

46/10

2,22

1.41/37

0.50/8

1.35/17

1.45/20

53/17

2,41

1.62/37

1.25/8

2.10/20

1.06/17

2020-04-04

Ipswich

0-0

Southend

46/10

2,16

1.37/38

0.50/8

1.28/18

1.45/20

39/-46

3,26

0.50/38

0.38/8

0.53/19

0.47/19

2020-04-10

Ipswich

0-0

Bolton

46/10

2,10

1.33/39

0.38/8

1.21/19

1.45/20

27/-39

2,38

0.67/39

0.38/8

1.00/20

0.32/19

2020-04-13

Shrewsbury

0-0

Ipswich

31/-11

1,87

1.05/39

0.38/8

1.21/19

0.90/20

46/10

2,05

1.30/40

0.00/8

1.15/20

1.45/20

2020-04-18

Ipswich

0-0

Rochdale

46/10

2,00

1.27/41

0.00/8

1.15/20

1.38/21

39/-18

2,34

0.88/41

0.38/8

0.90/21

0.85/20

2020-04-25

Doncaster

0-0

Ipswich

51/18

2,00

1.29/42

0.00/8

1.67/21

0.90/21

46/10

1,95

1.24/42

0.00/8

1.10/21

1.38/21

2020-05-03

Ipswich

0-0

MK Dons

46/10

1,91

1.21/43

0.00/8

1.10/21

1.32/22

36/-11

1,93

0.86/43

0.00/8

1.27/22

0.43/21