|   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     |  0.450686   |   0.309154  | 0.24016   |
|      18 | 2015-06-12 | C       | Switzerland | Ecuador     |  0.865029   |   0.0292196 | 0.105751  |
|      19 | 2015-06-12 | D       | USA         | Sweden      |  0.578987   |   0.202099  | 0.218914  |
|      20 | 2015-06-12 | C       | Japan       | Cameroon    |  0.754129   |   0.0849164 | 0.160955  |
|      21 | 2015-06-13 | F       | France      | Colombia    |  0.798734   |   0.0605909 | 0.140675  |
|      22 | 2015-06-13 | E       | Brazil      | Spain       |  0.659575   |   0.144046  | 0.196379  |
|      23 | 2015-06-13 | F       | England     | Mexico      |  0.620161   |   0.17157   | 0.208269  |
|      24 | 2015-06-13 | E       | South Korea | Costa Rica  |  0.62137    |   0.170701  | 0.207929  |
|      25 | 2015-06-15 | B       | Thailand    | Germany     |  0.00399502 |   0.951866  | 0.0441394 |
|      26 | 2015-06-15 | B       | Ivory Coast | Norway      |  0.0538314  |   0.812004  | 0.134165  |
|      27 | 2015-06-15 | A       | Netherlands | Canada      |  0.208225   |   0.571008  | 0.220767  |
|      28 | 2015-06-15 | A       | China       | New Zealand |  0.45543    |   0.304861  | 0.239709  |
|      29 | 2015-06-16 | C       | Ecuador     | Japan       |  0.00403501 |   0.951403  | 0.0445622 |
|      30 | 2015-06-16 | C       | Switzerland | Cameroon    |  0.453382   |   0.306711  | 0.239907  |
|      31 | 2015-06-16 | D       | Nigeria     | USA         |  0.0862494  |   0.751804  | 0.161946  |
|      32 | 2015-06-16 | D       | Australia   | Sweden      |  0.277053   |   0.486898  | 0.236049  |
|      33 | 2015-06-17 | F       | Mexico      | France      |  0.0930405  |   0.740127  | 0.166833  |
|      34 | 2015-06-17 | F       | England     | Colombia    |  0.687105   |   0.125812  | 0.187083  |
|      35 | 2015-06-17 | E       | Costa Rica  | Brazil      |  0.0283065  |   0.867185  | 0.104508  |
|      36 | 2015-06-17 | E       | South Korea | Spain       |  0.371924   |   0.384538  | 0.243539  |