SELECT * FROM 1_Kampe WHERE LigaID = '320' AND (Home='Birmingham' OR Away='Birmingham') 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
2021-08-07 Sheffield Utd 0-1 Birmingham 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
2021-08-14 Birmingham 0-0 Stoke 1/1 1,00 3.00/1 3.00/1 0.00/0 3.00/1   3/1 5,00 3.00/1 3.00/1 3.00/1 0.00/0
2021-08-18 Birmingham 0-2 Bournemouth 1/1 0,50 2.00/2 2.00/2 1.00/1 3.00/1   4/1 3,50 2.00/2 2.00/2 1.00/1 3.00/1
2021-08-21 Luton 0-5 Birmingham 6/3 3,00 2.00/3 2.00/3 3.00/1 1.50/2   1/-1 1,00 1.33/3 1.33/3 0.50/2 3.00/1
2021-08-28 Barnsley 1-1 Birmingham 4/0 2,00 1.25/4 1.25/4 1.50/2 1.00/2   6/4 2,00 1.75/4 1.75/4 0.50/2 3.00/2
2021-09-10 Birmingham 2-0 Derby 7/4 2,00 1.60/5 1.60/5 0.50/2 2.33/3   4/0 1,60 1.20/5 1.20/5 1.00/3 1.50/2
2021-09-15 Birmingham 1-4 Fulham 9/6 2,00 1.83/6 1.83/6 1.33/3 2.33/3   13/9 2,83 2.17/6 2.17/6 2.33/3 2.00/3
2021-09-18 Peterborough 3-0 Birmingham 7/-10 3,43 0.57/7 0.57/7 1.33/3 0.00/4   10/3 2,43 1.57/7 1.57/7 1.00/4 2.33/3
2021-09-25 Birmingham 0-0 Preston 10/0 2,50 1.38/8 1.38/8 1.00/4 1.75/4   9/-2 2,50 1.13/8 1.13/8 1.75/4 0.50/4
2021-09-28 QPR 2-0 Birmingham 17/3 3,44 1.33/9 1.38/8 1.25/4 1.40/5   10/0 2,22 1.33/9 1.13/8 1.00/5 1.75/4
2021-10-02 Birmingham 0-3 Nottingham 10/-2 2,20 1.20/10 1.00/8 1.00/5 1.40/5   11/-3 2,50 0.80/10 1.00/8 0.20/5 1.40/5
2021-10-15 West Brom 1-0 Birmingham 20/11 2,64 2.00/11 1.88/8 2.20/5 1.83/6   10/-5 2,27 1.09/11 1.00/8 0.83/6 1.40/5
2021-10-20 Huddersfield 0-0 Birmingham 18/4 2,67 1.67/12 1.63/8 2.00/6 1.33/6   10/-6 2,17 1.00/12 0.63/8 0.83/6 1.17/6
2021-10-23 Birmingham 2-1 Swansea 10/-6 2,00 1.00/13 0.63/8 0.83/6 1.14/7   14/-1 2,23 1.31/13 1.63/8 1.71/7 0.83/6
2021-10-30 Middlesbrough 0-2 Birmingham 17/4 2,14 1.50/14 1.88/8 1.86/7 1.14/7   12/-5 2,07 1.14/14 0.63/8 1.14/7 1.14/7
2021-11-02 Birmingham 3-0 Bristol City 14/-3 2,07 1.27/15 1.00/8 1.14/7 1.38/8   17/-4 2,53 1.27/15 1.25/8 0.88/8 1.71/7
2021-11-06 Birmingham 1-2 Reading 17/0 2,13 1.38/16 1.38/8 1.38/8 1.38/8   20/-7 2,94 1.19/16 1.13/8 1.63/8 0.75/8
2021-11-20 Hull 2-0 Birmingham 11/-11 1,94 0.71/17 0.88/8 0.63/8 0.78/9   18/-1 2,18 1.29/17 1.25/8 1.22/9 1.38/8
2021-11-23 Coventry 0-0 Birmingham 25/4 2,56 1.72/18 1.50/8 2.44/9 1.00/9   18/-3 2,17 1.22/18 1.25/8 1.22/9 1.22/9
2021-11-27 Birmingham 1-0 Blackpool 18/-3 2,05 1.21/19 1.38/8 1.22/9 1.20/10   20/-1 2,16 1.42/19 1.50/8 1.40/10 1.44/9
2021-12-04 Millwall 3-1 Birmingham 20/-1 2,05 1.35/20 1.50/8 1.60/10 1.10/10   19/-2 2,00 1.30/20 1.75/8 1.40/10 1.20/10
2021-12-11 Birmingham 2-2 Cardiff 20/-4 2,10 1.24/21 1.63/8 1.40/10 1.09/11   23/-14 2,86 1.00/21 1.25/8 0.64/11 1.40/10
2021-12-18 Blackburn 4-0 Birmingham 37/10 2,91 1.77/22 2.38/8 2.09/11 1.45/11   22/-4 2,18 1.23/22 1.38/8 1.36/11 1.09/11
2022-01-02 Birmingham 1-2 QPR 22/-8 2,26 1.17/23 1.00/8 1.36/11 1.00/12   35/6 2,78 1.65/23 2.00/8 1.75/12 1.55/11
2022-01-15 Preston 1-1 Birmingham 26/-3 2,39 1.35/23 1.63/8 1.73/11 1.00/12   23/-9 2,29 1.13/24 0.63/8 1.25/12 1.00/12
2022-01-18 Fulham 6-2 Birmingham 64/43 3,40 2.04/25 1.63/8 2.08/13 2.00/12   24/-9 2,28 1.12/25 0.75/8 1.25/12 1.00/13
2022-01-22 Birmingham 2-1 Barnsley 26/-13 2,50 1.08/26 0.75/8 1.25/12 0.93/14   16/-20 2,17 0.58/24 0.38/8 0.83/12 0.33/12
2022-01-25 Birmingham 2-2 Peterborough 28/-12 2,52 1.15/27 1.00/8 1.38/13 0.93/14   21/-30 2,88 0.76/25 0.50/8 1.33/12 0.23/13
2022-01-30 Derby 2-2 Birmingham 26/0 1,93 1.30/27 1.63/8 1.77/13 0.86/14   30/-12 2,57 1.14/28 0.75/8 1.36/14 0.93/14
2022-02-04 Birmingham 1-2 Sheffield Utd 32/-12 2,62 1.14/29 0.88/8 1.36/14 0.93/15   35/3 2,58 1.50/26 2.38/8 1.55/11 1.47/15
2022-02-09 Bournemouth 3-1 Birmingham 44/20 2,43 1.86/28 1.25/8 1.85/13 1.87/15   33/-13 2,63 1.10/30 0.75/8 1.27/15 0.93/15
2022-02-12 Birmingham 3-0 Luton 34/-15 2,68 1.06/31 0.75/8 1.27/15 0.88/16   41/8 2,55 1.55/29 2.13/8 1.73/15 1.36/14
2022-02-19 Stoke 2-2 Birmingham 38/6 2,33 1.43/30 1.00/8 1.60/15 1.27/15   37/-12 2,69 1.13/32 1.13/8 1.38/16 0.88/16
2022-02-22 Reading 2-1 Birmingham 39/-23 3,16 1.00/32 0.50/8 1.00/16 1.00/16   39/-12 2,73 1.12/33 1.13/8 1.38/16 0.88/17
2022-02-26 Birmingham 0-2 Huddersfield 40/-13 2,74 1.09/34 1.13/8 1.38/16 0.83/18   44/8 2,35 1.65/34 2.00/8 1.88/17 1.41/17
2022-03-05 Bristol City 1-2 Birmingham 45/-18 3,09 1.14/35 0.88/8 1.44/18 0.82/17   40/-15 2,71 1.06/35 0.75/8 1.29/17 0.83/18
2022-03-12 Birmingham 0-0 Hull 42/-14 2,72 1.11/36 1.00/8 1.29/17 0.95/19   30/-11 1,97 1.03/36 0.63/8 1.00/18 1.06/18
2022-03-15 Birmingham 0-2 Middlesbrough 42/-14 2,65 1.11/37 1.00/8 1.28/18 0.95/19   46/6 2,39 1.56/36 1.38/8 2.11/18 1.00/18
2022-03-19 Swansea 0-0 Birmingham 41/-11 2,58 1.31/36 1.50/8 1.65/17 1.00/19   42/-16 2,63 1.08/38 1.00/8 1.21/19 0.95/19
2022-04-03 Birmingham 1-0 West Brom 42/-16 2,56 1.08/39 1.13/8 1.21/19 0.95/20   42/6 2,05 1.42/38 1.13/8 1.89/18 1.00/20
2022-04-09 Nottingham 2-0 Birmingham 59/23 2,50 1.68/38 2.25/8 1.70/20 1.67/18   43/-15 2,53 1.13/40 1.13/8 1.30/20 0.95/20
2022-04-15 Birmingham 2-4 Coventry 43/-17 2,51 1.10/41 1.00/8 1.30/20 0.90/21   54/3 2,56 1.44/41 1.00/8 1.67/21 1.20/20
2022-04-18 Blackpool 6-1 Birmingham 45/-4 2,29 1.29/41 1.38/8 1.57/21 1.00/20   45/-19 2,60 1.07/42 1.00/8 1.24/21 0.90/21
2022-04-23 Birmingham 2-2 Millwall 46/-24 2,70 1.05/43 1.00/8 1.24/21 0.86/22   48/6 2,09 1.51/43 1.50/8 1.91/22 1.10/21
2022-04-30 Cardiff 1-1 Birmingham 48/-19 2,61 1.11/44 0.88/8 1.09/22 1.14/22   48/-24 2,73 1.05/44 0.75/8 1.23/22 0.86/22
2022-05-07 Birmingham 1-2 Blackburn 49/-24 2,71 1.04/45 0.75/8 1.23/22 0.87/23   57/8 2,36 1.47/45 1.00/8 1.78/23 1.14/22