SELECT * FROM 1_Kampe WHERE LigaID = '2' AND (Home='Newcastle' OR Away='Newcastle') 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-11 Newcastle 0-1 Arsenal 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-17 Norwich 3-1 Newcastle 1/-3 5,00 0.00/1 0.00/1 0.00/0 0.00/1   0/-1 1,00 0.00/1 0.00/1 0.00/1 0.00/0
2019-08-25 Tottenham 0-1 Newcastle 5/2 4,00 2.00/2 2.00/2 3.00/1 1.00/1   1/-3 2,50 0.00/2 0.00/2 0.00/1 0.00/1
2019-08-31 Newcastle 1-1 Watford 2/-2 2,00 1.00/3 1.00/3 0.00/1 1.50/2   1/-6 2,67 0.00/3 0.00/3 0.00/2 0.00/1
2019-09-14 Liverpool 3-1 Newcastle 12/9 3,75 3.00/4 3.00/4 3.00/2 3.00/2   3/-2 2,00 1.00/4 1.00/4 0.50/2 1.50/2
2019-09-21 Newcastle 0-0 Brighton 4/-4 2,40 0.80/5 0.80/5 0.50/2 1.00/3   5/-3 2,60 1.00/5 1.00/5 0.67/3 1.50/2
2019-09-29 Leicester 5-0 Newcastle 8/3 2,17 1.83/6 1.83/6 2.33/3 1.33/3   4/-4 2,00 0.83/6 0.83/6 0.67/3 1.00/3
2019-10-06 Newcastle 1-0 Manchester Utd 4/-9 2,43 0.71/7 0.71/7 0.67/3 0.75/4   9/2 2,29 1.29/7 1.29/7 1.75/4 0.67/3
2019-10-19 Chelsea 1-0 Newcastle 18/4 4,00 1.75/8 1.75/8 1.25/4 2.25/4   5/-8 2,25 1.00/8 1.00/8 1.25/4 0.75/4
2019-10-27 Newcastle 1-1 Wolves 5/-9 2,11 0.89/9 1.00/8 1.25/4 0.60/5   12/0 2,67 1.22/9 1.25/8 1.20/5 1.25/4
2019-11-02 West Ham 2-3 Newcastle 12/-2 2,60 1.30/10 1.50/8 1.40/5 1.20/5   6/-9 2,10 0.90/10 1.13/8 1.20/5 0.60/5
2019-11-09 Newcastle 2-1 Bournemouth 9/-8 2,36 1.09/11 1.13/8 1.20/5 1.00/6   14/1 2,45 1.45/11 1.50/8 1.50/6 1.40/5
2019-11-25 Aston Villa 2-0 Newcastle 17/-3 3,08 0.92/12 1.00/8 1.33/6 0.50/6   11/-7 2,42 1.25/12 1.38/8 1.50/6 1.00/6
2019-11-30 Newcastle 2-2 Manchester City 11/-9 2,38 1.15/13 1.38/8 1.50/6 0.86/7   37/23 3,92 2.15/13 2.25/8 2.29/7 2.00/6
2019-12-05 Sheffield Utd 0-2 Newcastle 17/4 2,14 1.36/14 1.38/8 1.43/7 1.29/7   13/-9 2,50 1.14/14 1.38/8 1.43/7 0.86/7
2019-12-08 Newcastle 2-1 Southampton 15/-7 2,47 1.27/15 1.75/8 1.43/7 1.13/8   17/-16 3,33 1.00/15 1.00/8 0.88/8 1.14/7
2019-12-14 Burnley 1-0 Newcastle 21/-8 3,13 1.13/16 0.75/8 1.50/8 0.75/8   17/-6 2,50 1.38/16 1.75/8 1.63/8 1.13/8
2019-12-21 Newcastle 1-0 Crystal Palace 17/-7 2,41 1.29/17 1.75/8 1.63/8 1.00/9   15/-4 2,00 1.35/17 1.13/8 1.33/9 1.38/8
2019-12-26 Manchester Utd 4-1 Newcastle 26/4 2,67 1.39/18 1.50/8 1.78/9 1.00/9   18/-6 2,33 1.39/18 2.00/8 1.78/9 1.00/9
2019-12-28 Newcastle 1-2 Everton 19/-9 2,47 1.32/19 1.63/8 1.78/9 0.90/10   21/-8 2,63 1.16/19 1.38/8 1.70/10 0.56/9
2020-01-01 Newcastle 0-3 Leicester 20/-10 2,50 1.25/20 1.25/8 1.60/10 0.90/10   43/24 3,10 2.10/20 2.00/8 2.30/10 1.90/10
2020-01-11 Wolves 1-1 Newcastle 30/3 2,71 1.43/21 1.38/8 1.60/10 1.27/11   20/-13 2,52 1.19/21 1.25/8 1.45/11 0.90/10
2020-01-18 Newcastle 1-0 Chelsea 21/-13 2,50 1.18/22 1.25/8 1.45/11 0.91/11   39/10 3,09 1.77/22 1.63/8 1.55/11 2.00/11
2020-01-21 Everton 2-2 Newcastle 26/-7 2,57 1.26/23 1.88/8 1.82/11 0.75/12   22/-12 2,43 1.26/23 1.25/8 1.58/12 0.91/11
2020-02-01 Newcastle 0-0 Norwich 24/-12 2,50 1.25/24 1.00/8 1.58/12 0.92/12   24/-23 2,96 0.71/24 0.75/8 1.00/12 0.42/12
2020-02-16 Arsenal 4-0 Newcastle 32/-2 2,64 1.24/25 1.13/8 1.42/12 1.08/13   24/-12 2,40 1.24/25 1.13/8 1.54/13 0.92/12
2020-02-22 Crystal Palace 1-0 Newcastle 23/-9 2,12 1.15/26 0.88/8 1.23/13 1.08/13   24/-16 2,46 1.19/26 0.75/8 1.54/13 0.85/13
2020-02-29 Newcastle 0-0 Burnley 24/-17 2,41 1.15/27 0.75/8 1.54/13 0.79/14   33/-6 2,67 1.37/27 1.63/8 1.57/14 1.15/13
2020-03-07 Southampton 0-1 Newcastle 35/-16 3,07 1.21/28 1.50/8 1.00/14 1.43/14   24/-17 2,32 1.14/28 0.88/8 1.50/14 0.79/14
2020-06-21 Newcastle 3-0 Sheffield Utd 25/-16 2,28 1.21/29 1.25/8 1.50/14 0.93/15   30/5 1,90 1.52/29 1.88/8 1.60/15 1.43/14
2020-06-24 Newcastle 1-1 Aston Villa 28/-13 2,30 1.27/30 1.50/8 1.60/15 0.93/15   35/-23 3,10 0.87/30 0.63/8 1.20/15 0.53/15
2020-07-01 Bournemouth 1-4 Newcastle 29/-21 2,55 0.87/31 0.88/8 1.13/15 0.63/16   29/-13 2,29 1.26/31 1.25/8 1.56/16 0.93/15
2020-07-05 Newcastle 2-2 West Ham 33/-10 2,38 1.31/32 1.50/8 1.56/16 1.06/16   38/-18 2,94 0.94/32 0.88/8 1.13/16 0.75/16
2020-07-08 Manchester City 5-0 Newcastle 81/47 3,48 2.00/33 1.88/8 2.38/16 1.65/17   35/-10 2,42 1.30/33 1.50/8 1.53/17 1.06/16
2020-07-11 Watford 2-1 Newcastle 31/-22 2,47 0.91/34 0.88/8 1.24/17 0.59/17   35/-15 2,50 1.26/34 1.50/8 1.53/17 1.00/17
2020-07-15 Newcastle 1-3 Tottenham 36/-16 2,51 1.23/35 1.50/8 1.53/17 0.94/18   54/9 2,83 1.49/35 1.50/8 2.00/18 0.94/17
2020-07-20 Brighton 0-0 Newcastle 37/-16 2,50 1.03/36 1.13/8 1.17/18 0.89/18   37/-18 2,56 1.19/36 1.38/8 1.44/18 0.94/18
2020-07-26 Newcastle 1-3 Liverpool 37/-18 2,49 1.19/37 1.13/8 1.44/18 0.95/19   82/50 3,08 2.59/37 1.75/8 2.89/19 2.28/18