SELECT * FROM 1_Kampe WHERE LigaID = '36' AND (Home='Newport' OR Away='Newport') 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
2016-08-06 Newport 2-3 Mansfield 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
2016-08-13 Leyton Orient 0-1 Newport 1/0 2,00 1.00/1 1.00/1 0.00/0 1.00/1   2/-1 5,00 0.00/1 0.00/1 0.00/1 0.00/0
2016-08-16 Luton 2-1 Newport 4/3 2,50 2.00/2 2.00/2 1.00/1 3.00/1   3/0 3,00 1.50/2 1.50/2 0.00/1 3.00/1
2016-08-20 Newport 1-1 Crewe 4/-1 3,00 1.00/3 1.00/3 0.00/1 1.50/2   5/1 3,00 1.67/3 1.67/3 1.00/2 3.00/1
2016-08-27 Hartlepool 2-2 Newport 7/0 3,50 1.25/4 1.25/4 0.50/2 2.00/2   5/-1 2,75 1.00/4 1.00/4 0.50/2 1.50/2
2016-09-10 Newport 2-2 Cheltenham 7/-1 3,00 1.00/5 1.00/5 0.50/2 1.33/3   5/0 1,67 1.00/6 1.00/6 1.33/3 0.67/3
2016-09-17 Doncaster 2-0 Newport 15/7 3,29 1.86/7 1.86/7 2.33/3 1.50/4   9/-1 3,17 1.00/6 1.00/6 0.67/3 1.33/3
2016-09-24 Newport 1-2 Cambridge Utd 9/-3 3,00 0.86/7 0.86/7 0.67/3 1.00/4   5/-8 2,25 0.38/8 0.38/8 0.50/4 0.25/4
2016-09-27 Grimsby 1-0 Newport 16/2 3,33 1.44/9 1.25/8 1.50/4 1.40/5   10/-4 3,00 0.75/8 0.75/8 0.50/4 1.00/4
2016-10-08 Colchester 0-0 Newport 16/0 2,91 1.36/11 1.00/8 1.80/5 1.00/6   10/-5 2,78 0.67/9 0.75/8 0.50/4 0.80/5
2016-10-15 Yeovil 1-0 Newport 12/-7 2,58 1.08/12 1.13/8 1.50/6 0.67/6   10/-5 2,50 0.70/10 0.50/8 0.50/4 0.83/6
2016-10-22 Newport 1-3 Plymouth 10/-6 2,36 0.64/11 0.50/8 0.50/4 0.71/7   21/10 2,46 2.23/13 2.50/8 2.00/7 2.50/6
2016-10-25 Newport 2-2 Barnet 11/-8 2,50 0.58/12 0.38/8 0.40/5 0.71/7   15/-4 2,62 1.15/13 1.13/8 1.00/7 1.33/6
2016-10-29 Accrington 1-3 Newport 18/1 2,50 1.43/14 1.88/8 1.57/7 1.29/7   13/-8 2,62 0.62/13 0.38/8 0.50/6 0.71/7
2016-11-12 Newport 2-0 Carlisle 16/-6 2,71 0.79/14 0.63/8 0.50/6 1.00/8   27/12 2,80 2.07/15 2.50/8 2.25/8 1.86/7
2016-11-19 Notts Co 0-3 Newport 22/-3 2,94 1.38/16 1.38/8 0.88/8 1.88/8   18/-4 2,67 0.93/15 1.00/8 0.86/7 1.00/8
2016-11-22 Newport 0-1 Wycombe 21/-1 2,69 1.06/16 1.38/8 0.86/7 1.22/9   20/-2 2,47 1.29/17 1.75/8 2.00/8 0.67/9
2016-11-26 Blackpool 4-1 Newport 29/8 2,78 1.33/18 1.38/8 1.88/8 0.90/10   21/-2 2,59 1.00/17 1.38/8 0.75/8 1.22/9
2016-12-06 Newport 0-2 Stevenage 22/-5 2,72 0.94/18 1.25/8 0.75/8 1.10/10   28/-1 3,17 1.33/18 1.63/8 1.11/9 1.56/9
2016-12-17 Crawley 3-1 Newport 23/-9 2,75 1.30/20 0.88/8 1.67/9 1.00/11   22/-7 2,68 0.89/19 1.25/8 0.67/9 1.10/10
2016-12-26 Newport 2-3 Portsmouth 23/-9 2,75 0.85/20 1.25/8 0.67/9 1.00/11   33/13 2,52 1.67/21 1.75/8 1.70/10 1.64/11
2016-12-31 Newport 1-4 Exeter 25/-10 2,86 0.81/21 1.13/8 0.60/10 1.00/11   25/-1 2,32 1.23/22 1.75/8 0.50/10 1.83/12
2017-01-02 Wycombe 2-1 Newport 30/5 2,39 1.65/23 2.75/8 2.20/10 1.23/13   26/-13 2,95 0.77/22 0.75/8 0.55/11 1.00/11
2017-01-07 Stevenage 3-1 Newport 35/-4 3,08 1.25/24 1.13/8 0.83/12 1.67/12   27/-14 2,96 0.74/23 0.38/8 0.55/11 0.92/12
2017-01-14 Newport 1-1 Colchester 28/-16 3,00 0.71/24 0.00/8 0.55/11 0.85/13   40/10 2,80 1.56/25 2.75/8 1.92/12 1.23/13
2017-01-21 Barnet 0-0 Newport 37/0 2,85 1.50/26 1.88/8 1.31/13 1.69/13   29/-16 2,96 0.72/25 0.13/8 0.58/12 0.85/13
2017-01-28 Newport 3-1 Hartlepool 29/-16 2,85 0.73/26 0.25/8 0.58/12 0.86/14   35/-9 2,93 1.11/27 1.00/8 1.21/14 1.00/13
2017-02-04 Cheltenham 1-1 Newport 31/-10 2,57 1.00/28 1.25/8 0.93/15 1.08/13   32/-14 2,89 0.81/27 0.63/8 0.77/13 0.86/14
2017-02-10 Newport 0-0 Doncaster 33/-14 2,86 0.82/28 0.75/8 0.77/13 0.87/15   59/24 3,24 2.14/29 2.50/8 2.47/15 1.79/14
2017-02-14 Newport 0-0 Grimsby 33/-14 2,76 0.83/29 0.88/8 0.79/14 0.87/15   36/-3 2,50 1.33/30 1.38/8 1.27/15 1.40/15
2017-02-18 Cambridge Utd 3-2 Newport 37/2 2,40 1.33/30 0.75/8 1.20/15 1.47/15   33/-14 2,67 0.83/30 1.00/8 0.80/15 0.87/15
2017-02-21 Newport 1-1 Morecambe 35/-15 2,74 0.81/31 1.00/8 0.80/15 0.81/16   39/-7 2,83 1.37/30 1.88/8 1.07/15 1.67/15
2017-02-25 Mansfield 2-1 Newport 41/4 2,44 1.47/32 2.13/8 1.59/17 1.33/15   36/-15 2,72 0.81/32 1.13/8 0.81/16 0.81/16
2017-03-04 Newport 0-4 Leyton Orient 37/-16 2,73 0.79/33 1.00/8 0.81/16 0.76/17   36/-19 2,68 0.85/34 0.50/8 0.56/18 1.19/16
2017-03-11 Crewe 1-2 Newport 37/-15 2,54 1.11/35 1.38/8 1.24/17 1.00/18   37/-20 2,76 0.76/34 0.88/8 0.76/17 0.76/17
2017-03-14 Morecambe 0-1 Newport 44/-10 2,80 1.31/35 1.38/8 1.12/17 1.50/18   39/-19 2,77 0.83/35 0.88/8 0.76/17 0.89/18
2017-03-18 Newport 1-3 Blackpool 40/-18 2,72 0.89/36 1.13/8 0.76/17 1.00/19   56/18 2,54 1.46/37 1.63/8 1.61/18 1.32/19
2017-03-21 Newport 1-1 Luton 41/-20 2,76 0.86/37 1.00/8 0.72/18 1.00/19   54/20 2,38 1.59/37 1.63/8 1.58/19 1.61/18
2017-03-25 Portsmouth 2-1 Newport 59/25 2,45 1.71/38 1.75/8 1.83/18 1.60/20   42/-20 2,74 0.87/38 1.00/8 0.74/19 1.00/19
2017-04-01 Newport 1-0 Crawley 43/-21 2,74 0.85/39 1.00/8 0.74/19 0.95/20   47/-13 2,74 1.23/39 1.13/8 1.47/19 1.00/20
2017-04-08 Exeter 0-1 Newport 65/17 2,83 1.55/40 1.50/8 1.21/19 1.86/21   44/-20 2,70 0.90/40 1.25/8 0.85/20 0.95/20
2017-04-14 Newport 1-0 Yeovil 45/-19 2,66 0.95/41 1.63/8 0.85/20 1.05/21   43/-13 2,41 1.12/41 0.88/8 1.33/21 0.90/20
2017-04-17 Plymouth 6-1 Newport 62/19 2,50 1.88/42 1.75/8 1.71/21 2.05/21   46/-18 2,62 1.00/42 2.00/8 0.95/21 1.05/21
2017-04-22 Newport 1-0 Accrington 47/-23 2,72 0.98/43 1.63/8 0.95/21 1.00/22   55/4 2,47 1.44/43 2.25/8 1.68/22 1.19/21
2017-04-29 Carlisle 2-1 Newport 64/-1 2,93 1.48/44 0.88/8 1.55/22 1.41/22   48/-22 2,68 1.02/44 1.63/8 1.05/22 1.00/22
2017-05-06 Newport 2-1 Notts Co 49/-23 2,69 1.00/45 1.63/8 1.05/22 0.96/23   53/-21 2,82 1.24/45 2.00/8 1.22/23 1.27/22