fivethirtyeight

Custom SQL query returning 44 rows (hide)

rowiddategroupteam1team2team1_winteam2_wintie
1 2015-06-06 A Canada China 1.0 0.0 0
2 2015-06-06 A New Zealand Netherlands 0.0 1.0 0
3 2015-06-07 B Norway Thailand 1.0 0.0 0
4 2015-06-07 B Germany Ivory Coast 1.0 0.0 0
5 2015-06-08 D Sweden Nigeria 0.0 0.0 1
6 2015-06-08 C Cameroon Ecuador 1.0 0.0 0
7 2015-06-08 D USA Australia 1.0 0.0 0
8 2015-06-08 C Japan Switzerland 1.0 0.0 0
9 2015-06-09 F France England 1.0 0.0 0
10 2015-06-09 E Spain Costa Rica 0.0 0.0 1
11 2015-06-09 F Colombia Mexico 0.0 0.0 1
12 2015-06-09 E Brazil South Korea 1.0 0.0 0
13 2015-06-11 B Germany Norway 0.0 0.0 1
14 2015-06-11 A China Netherlands 1.0 0.0 0
15 2015-06-11 B Ivory Coast Thailand 0.0 1.0 0
16 2015-06-11 A Canada New Zealand 0.0 0.0 1
17 2015-06-12 D Australia Nigeria 1.0 0.0 0
18 2015-06-12 C Switzerland Ecuador 1.0 0.0 0
19 2015-06-12 D USA Sweden 0.0 0.0 1
20 2015-06-12 C Japan Cameroon 1.0 0.0 0
21 2015-06-13 F France Colombia 0.0 1.0 0
22 2015-06-13 E Brazil Spain 1.0 0.0 0
23 2015-06-13 F England Mexico 1.0 0.0 0
24 2015-06-13 E South Korea Costa Rica 0.0 0.0 1
25 2015-06-15 B Thailand Germany 0.0 1.0 0
26 2015-06-15 B Ivory Coast Norway 0.0 1.0 0
27 2015-06-15 A Netherlands Canada 0.0 0.0 1
28 2015-06-15 A China New Zealand 0.0 0.0 1
29 2015-06-16 C Ecuador Japan 0.0 1.0 0
30 2015-06-16 C Switzerland Cameroon 0.0 1.0 0
31 2015-06-16 D Nigeria USA 0.0 1.0 0
32 2015-06-16 D Australia Sweden 0.0 0.0 1
33 2015-06-17 F Mexico France 0.0 1.0 0
34 2015-06-17 F England Colombia 1.0 0.0 0
35 2015-06-17 E Costa Rica Brazil 0.0 1.0 0
36 2015-06-17 E South Korea Spain 1.0 0.0 0
37 2015-06-20   China Cameroon 0.61125071 0.38874929 0
38 2015-06-22   USA Colombia 0.9503981 0.0496019 0
39 2015-06-20   Germany Sweden 0.74126777 0.25873223 0
40 2015-06-21   France South Korea 0.79388795 0.20611205 0
41 2015-06-21   Brazil Australia 0.61719037 0.38280963 0
42 2015-06-23   Japan Netherlands 0.73040336 0.26959664 0
43 2015-06-22   Norway England 0.49317263 0.50682737 0
44 2015-06-21   Canada Switzerland 0.75540501 0.24459499 0
Powered by Datasette · Query took 1.313ms