home / fivethirtyeight

fivethirtyeight

Custom SQL query returning 36 rows (hide)

rowiddategroupteam1team2team1_winteam2_wintie
1 2015-06-06 A Canada China 1.0 0.0 0.0
2 2015-06-06 A New Zealand Netherlands 0.0 1.0 0.0
3 2015-06-07 B Norway Thailand 1.0 0.0 0.0
4 2015-06-07 B Germany Ivory Coast 1.0 0.0 0.0
5 2015-06-08 D Sweden Nigeria 0.0 0.0 1.0
6 2015-06-08 C Cameroon Ecuador 1.0 0.0 0.0
7 2015-06-08 D USA Australia 1.0 0.0 0.0
8 2015-06-08 C Japan Switzerland 1.0 0.0 0.0
9 2015-06-09 F France England 1.0 0.0 0.0
10 2015-06-09 E Spain Costa Rica 0.0 0.0 1.0
11 2015-06-09 F Colombia Mexico 0.0 0.0 1.0
12 2015-06-09 E Brazil South Korea 1.0 0.0 0.0
13 2015-06-11 B Germany Norway 0.0 0.0 1.0
14 2015-06-11 A China Netherlands 1.0 0.0 0.0
15 2015-06-11 B Ivory Coast Thailand 0.0 1.0 0.0
16 2015-06-11 A Canada New Zealand 0.0 0.0 1.0
17 2015-06-12 D Australia Nigeria 1.0 0.0 0.0
18 2015-06-12 C Switzerland Ecuador 1.0 0.0 0.0
19 2015-06-12 D USA Sweden 0.0 0.0 1.0
20 2015-06-12 C Japan Cameroon 1.0 0.0 0.0
21 2015-06-13 F France Colombia 0.0 1.0 0.0
22 2015-06-13 E Brazil Spain 0.65938878 0.1441718 0.19643942
23 2015-06-13 F England Mexico 0.61681086 0.17398608 0.20920306
24 2015-06-13 E South Korea Costa Rica 0.62161091 0.17052793 0.20786117
25 2015-06-15 B Thailand Germany 0.00400582 0.95174061 0.04425357
26 2015-06-15 B Ivory Coast Norway 0.053762 0.81214209 0.13409591
27 2015-06-15 A Netherlands Canada 0.20888011 0.57016064 0.22095925
28 2015-06-15 A China New Zealand 0.45535485 0.30492847 0.23971668
29 2015-06-16 C Ecuador Japan 0.00359574 0.95649615 0.03990811
30 2015-06-16 C Switzerland Cameroon 0.46182367 0.29911653 0.23905979
31 2015-06-16 D Nigeria USA 0.08407639 0.75559956 0.16032405
32 2015-06-16 D Australia Sweden 0.29683253 0.46438104 0.23878643
33 2015-06-17 F Mexico France 0.10907205 0.71355521 0.17737274
34 2015-06-17 F England Colombia 0.64340696 0.15513509 0.20145795
35 2015-06-17 E Costa Rica Brazil 0.02824795 0.86732408 0.10442797
36 2015-06-17 E South Korea Spain 0.37177313 0.38468967 0.2435372
Powered by Datasette · Query took 1.196ms