SELECT * FROM 1_Kampe WHERE LigaID = '36' AND (Home='Carlisle' OR Away='Carlisle') 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 Portsmouth 1-1 Carlisle 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 Carlisle 1-0 Plymouth 1/0 2,00 1.00/1 1.00/1 0.00/0 1.00/1   0/-3 3,00 0.00/1 0.00/1 0.00/1 0.00/0
2016-08-16 Carlisle 1-1 Cheltenham 2/1 1,50 2.00/2 2.00/2 3.00/1 1.00/1   2/0 2,00 1.00/2 1.00/2 1.00/1 1.00/1
2016-08-20 Cambridge Utd 2-2 Carlisle 1/-3 1,67 0.33/3 0.33/3 1.00/1 0.00/2   3/1 1,67 1.67/3 1.67/3 2.00/2 1.00/1
2016-08-27 Barnet 0-1 Carlisle 5/2 2,00 1.50/4 1.50/4 2.00/2 1.00/2   5/1 2,25 1.50/4 1.50/4 2.00/2 1.00/2
2016-09-03 Carlisle 1-1 Accrington 6/2 2,00 1.80/5 1.80/5 2.00/2 1.67/3   7/-3 3,40 0.80/5 0.80/5 1.00/3 0.50/2
2016-09-10 Carlisle 2-2 Leyton Orient 7/2 2,00 1.67/6 1.67/6 1.67/3 1.67/3   9/3 2,50 1.67/6 1.67/6 1.00/3 2.33/3
2016-09-17 Blackpool 2-2 Carlisle 9/2 2,29 1.14/7 1.14/7 1.33/3 1.00/4   9/2 2,29 1.57/7 1.57/7 1.50/4 1.67/3
2016-09-24 Carlisle 1-0 Wycombe 11/2 2,50 1.50/8 1.50/8 1.50/4 1.50/4   7/-6 2,50 1.00/8 1.00/8 1.75/4 0.25/4
2016-09-27 Doncaster 2-2 Carlisle 18/7 3,22 1.78/9 2.00/8 2.50/4 1.20/5   12/3 2,33 1.67/9 1.75/8 1.80/5 1.50/4
2016-10-01 Carlisle 2-0 Colchester 14/3 2,50 1.60/10 1.50/8 1.80/5 1.40/5   16/2 3,00 1.50/10 1.38/8 1.80/5 1.20/5
2016-10-08 Morecambe 0-3 Carlisle 16/-2 3,40 1.60/10 1.63/8 1.20/5 2.00/5   16/5 2,45 1.73/11 1.75/8 2.00/6 1.40/5
2016-10-15 Carlisle 3-2 Hartlepool 19/8 2,50 1.83/12 2.00/8 2.00/6 1.67/6   18/-1 3,08 1.33/12 1.38/8 0.83/6 1.83/6
2016-10-22 Stevenage 1-2 Carlisle 17/-2 3,00 1.17/12 1.25/8 1.50/6 0.83/6   22/9 2,69 1.92/13 2.00/8 2.14/7 1.67/6
2016-10-29 Carlisle 3-1 Crawley 24/10 2,71 2.00/14 2.25/8 2.14/7 1.86/7   15/-1 2,21 1.43/14 1.50/8 1.71/7 1.14/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 Carlisle 3-2 Exeter 27/10 2,75 1.94/16 2.38/8 2.25/8 1.63/8   17/-5 2,44 1.00/16 1.25/8 0.13/8 1.88/8
2016-11-22 Grimsby 2-2 Carlisle 23/3 2,53 1.47/17 1.50/8 1.25/8 1.67/9   30/11 2,88 2.00/17 2.38/8 2.33/9 1.63/8
2016-11-26 Carlisle 5-2 Mansfield 32/11 2,94 1.94/18 2.38/8 2.33/9 1.56/9   19/-1 2,17 1.39/18 1.50/8 1.50/10 1.25/8
2016-12-10 Luton 1-1 Carlisle 28/10 2,42 1.63/19 1.63/8 1.67/9 1.60/10   37/14 3,16 2.00/19 2.38/8 2.40/10 1.56/9
2016-12-17 Carlisle 2-1 Yeovil 38/14 3,10 1.95/20 2.13/8 2.40/10 1.50/10   24/0 2,40 1.40/20 1.88/8 1.73/11 1.00/9
2016-12-26 Crewe 1-1 Carlisle 23/-6 2,48 1.24/21 0.88/8 1.30/10 1.18/11   40/15 3,10 2.00/21 2.13/8 2.45/11 1.50/10
2016-12-31 Notts Co 2-3 Carlisle 25/-12 2,82 1.00/22 0.13/8 0.58/12 1.50/10   41/15 3,05 1.95/22 1.88/8 2.45/11 1.45/11
2017-01-02 Carlisle 1-3 Grimsby 44/16 3,13 2.00/23 1.88/8 2.45/11 1.58/12   29/2 2,43 1.30/23 1.13/8 1.25/12 1.36/11
2017-01-07 Colchester 4-1 Carlisle 36/7 2,71 1.50/24 2.38/8 1.82/11 1.23/13   45/14 3,17 1.92/24 1.88/8 2.25/12 1.58/12
2017-01-14 Carlisle 1-1 Morecambe 46/11 3,24 1.84/25 1.50/8 2.25/12 1.46/13   31/-11 3,04 1.25/24 1.25/8 1.00/13 1.55/11
2017-01-21 Accrington 1-1 Carlisle 23/-11 2,28 1.00/25 0.63/8 1.08/12 0.92/13   47/11 3,19 1.81/26 1.50/8 2.15/13 1.46/13
2017-01-28 Carlisle 1-1 Barnet 48/11 3,15 1.78/27 1.25/8 2.15/13 1.43/14   37/0 2,74 1.48/27 1.63/8 1.29/14 1.69/13
2017-02-04 Leyton Orient 1-2 Carlisle 28/-13 2,56 0.93/27 0.88/8 0.71/14 1.15/13   49/11 3,11 1.75/28 1.25/8 2.07/14 1.43/14
2017-02-11 Carlisle 1-4 Blackpool 51/12 3,10 1.79/29 1.25/8 2.07/14 1.53/15   39/11 2,39 1.36/28 1.00/8 1.50/14 1.21/14
2017-02-14 Carlisle 2-1 Doncaster 52/9 3,17 1.73/30 1.13/8 1.93/15 1.53/15   59/24 3,13 2.10/30 2.25/8 2.47/15 1.73/15
2017-02-18 Wycombe 1-2 Carlisle 38/1 2,50 1.53/30 1.38/8 2.14/14 1.00/16   54/10 3,16 1.77/31 1.13/8 2.00/16 1.53/15
2017-02-25 Carlisle 0-3 Portsmouth 56/11 3,16 1.81/32 1.50/8 2.00/16 1.63/16   45/16 2,39 1.68/31 1.63/8 1.93/15 1.44/16
2017-02-28 Cheltenham 1-0 Carlisle 37/-9 2,52 1.06/33 1.38/8 1.06/17 1.06/16   56/8 3,15 1.76/33 1.50/8 1.88/17 1.63/16
2017-03-04 Plymouth 2-0 Carlisle 52/16 2,67 1.88/33 1.38/8 1.76/17 2.00/16   56/7 3,09 1.71/34 1.38/8 1.88/17 1.53/17
2017-03-11 Carlisle 0-3 Cambridge Utd 56/5 3,06 1.66/35 1.25/8 1.88/17 1.44/18   44/3 2,50 1.38/34 1.00/8 1.22/18 1.56/16
2017-03-14 Carlisle 0-0 Luton 56/2 3,06 1.61/36 1.13/8 1.78/18 1.44/18   53/20 2,46 1.63/35 1.50/8 1.61/18 1.65/17
2017-03-18 Mansfield 2-0 Carlisle 43/1 2,30 1.41/37 1.13/8 1.58/19 1.22/18   56/2 2,97 1.59/37 0.88/8 1.74/19 1.44/18
2017-03-25 Carlisle 0-2 Crewe 56/0 2,95 1.55/38 0.88/8 1.74/19 1.37/19   43/-11 2,55 1.18/38 1.63/8 1.26/19 1.11/19
2017-04-01 Yeovil 0-2 Carlisle 42/-9 2,38 1.18/39 1.00/8 1.40/20 0.95/19   56/-2 2,92 1.51/39 0.50/8 1.65/20 1.37/19
2017-04-08 Carlisle 1-2 Notts Co 58/0 2,90 1.55/40 0.50/8 1.65/20 1.45/20   46/-20 2,80 1.23/40 2.00/8 1.19/21 1.26/19
2017-04-14 Hartlepool 1-1 Carlisle 50/-18 2,88 1.02/41 1.25/8 1.25/20 0.81/21   59/-1 2,90 1.51/41 0.50/8 1.57/21 1.45/20
2017-04-17 Carlisle 1-1 Stevenage 60/-1 2,88 1.50/42 0.63/8 1.57/21 1.43/21   65/8 2,90 1.55/42 1.63/8 1.62/21 1.48/21
2017-04-22 Crawley 3-3 Carlisle 48/-16 2,60 1.14/43 0.75/8 1.38/21 0.91/22   61/-1 2,86 1.49/43 0.75/8 1.55/22 1.43/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 Exeter 2-3 Carlisle 73/20 2,80 1.58/45 1.75/8 1.32/22 1.83/23   66/0 2,93 1.51/45 1.13/8 1.61/23 1.41/22