|   rowid | date       | group   | team1       | team2       |   team1_win |   team2_win |       tie |
|---------+------------+---------+-------------+-------------+-------------+-------------+-----------|
|       1 | 2015-06-06 | A       | Canada      | China       |  1          |    0        | 0         |
|       2 | 2015-06-06 | A       | New Zealand | Netherlands |  0          |    1        | 0         |
|       3 | 2015-06-07 | B       | Norway      | Thailand    |  1          |    0        | 0         |
|       4 | 2015-06-07 | B       | Germany     | Ivory Coast |  1          |    0        | 0         |
|       5 | 2015-06-08 | D       | Sweden      | Nigeria     |  0          |    0        | 1         |
|       6 | 2015-06-08 | C       | Cameroon    | Ecuador     |  1          |    0        | 0         |
|       7 | 2015-06-08 | D       | USA         | Australia   |  1          |    0        | 0         |
|       8 | 2015-06-08 | C       | Japan       | Switzerland |  1          |    0        | 0         |
|       9 | 2015-06-09 | F       | France      | England     |  1          |    0        | 0         |
|      10 | 2015-06-09 | E       | Spain       | Costa Rica  |  0          |    0        | 1         |
|      11 | 2015-06-09 | F       | Colombia    | Mexico      |  0          |    0        | 1         |
|      12 | 2015-06-09 | E       | Brazil      | South Korea |  1          |    0        | 0         |
|      13 | 2015-06-11 | B       | Germany     | Norway      |  0          |    0        | 1         |
|      14 | 2015-06-11 | A       | China       | Netherlands |  1          |    0        | 0         |
|      15 | 2015-06-11 | B       | Ivory Coast | Thailand    |  0          |    1        | 0         |
|      16 | 2015-06-11 | A       | Canada      | New Zealand |  0          |    0        | 1         |
|      17 | 2015-06-12 | D       | Australia   | Nigeria     |  1          |    0        | 0         |
|      18 | 2015-06-12 | C       | Switzerland | Ecuador     |  1          |    0        | 0         |
|      19 | 2015-06-12 | D       | USA         | Sweden      |  0          |    0        | 1         |
|      20 | 2015-06-12 | C       | Japan       | Cameroon    |  1          |    0        | 0         |
|      21 | 2015-06-13 | F       | France      | Colombia    |  0          |    1        | 0         |
|      22 | 2015-06-13 | E       | Brazil      | Spain       |  1          |    0        | 0         |
|      23 | 2015-06-13 | F       | England     | Mexico      |  1          |    0        | 0         |
|      24 | 2015-06-13 | E       | South Korea | Costa Rica  |  0          |    0        | 1         |
|      25 | 2015-06-15 | B       | Thailand    | Germany     |  0          |    1        | 0         |
|      26 | 2015-06-15 | B       | Ivory Coast | Norway      |  0          |    1        | 0         |
|      27 | 2015-06-15 | A       | Netherlands | Canada      |  0          |    0        | 1         |
|      28 | 2015-06-15 | A       | China       | New Zealand |  0          |    0        | 1         |
|      29 | 2015-06-16 | C       | Ecuador     | Japan       |  0.00358912 |    0.956573 | 0.0398377 |
|      30 | 2015-06-16 | C       | Switzerland | Cameroon    |  0.461634   |    0.299286 | 0.23908   |
|      31 | 2015-06-16 | D       | Nigeria     | USA         |  0.0841251  |    0.755514 | 0.160361  |
|      32 | 2015-06-16 | D       | Australia   | Sweden      |  0.297264   |    0.463897 | 0.238839  |
|      33 | 2015-06-17 | F       | Mexico      | France      |  0.111676   |    0.709359 | 0.178965  |
|      34 | 2015-06-17 | F       | England     | Colombia    |  0.640721   |    0.157004 | 0.202274  |
|      35 | 2015-06-17 | E       | Costa Rica  | Brazil      |  0.0348484  |    0.852096 | 0.113055  |
|      36 | 2015-06-17 | E       | South Korea | Spain       |  0.362438   |    0.394167 | 0.243395  |