womens-world-cup-predictions/wwc-matches-20150608-212619

36 rows

View and edit SQL

Suggested facets: date, group, team1, team2, date (date)

Link rowid date group team1 team2 team1_win team2_win tie
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 0.68797412 0.12524952 0.18677637
9 2015-06-09 F France England 0.49459016 0.27042962 0.23498022
10 2015-06-09 E Spain Costa Rica 0.66246412 0.14209365 0.19544223
11 2015-06-09 F Colombia Mexico 0.30538488 0.45484919 0.23976593
12 2015-06-09 E Brazil South Korea 0.65136891 0.14963904 0.19899205
13 2015-06-11 B Germany Norway 0.71642158 0.10730446 0.17627396
14 2015-06-11 A China Netherlands 0.34258908 0.41472812 0.2426828
15 2015-06-11 B Ivory Coast Thailand 0.49380856 0.27109949 0.23509195
16 2015-06-11 A Canada New Zealand 0.68473822 0.12734705 0.18791473
17 2015-06-12 D Australia Nigeria 0.4492449 0.3104638 0.24029131
18 2015-06-12 C Switzerland Ecuador 0.86840013 0.02779515 0.10380471
19 2015-06-12 D USA Sweden 0.57785445 0.20296423 0.21918132
20 2015-06-12 C Japan Cameroon 0.75968371 0.08175678 0.15855951
21 2015-06-13 F France Colombia 0.8019296 0.05894223 0.13912817
22 2015-06-13 E Brazil Spain 0.63923311 0.1580434 0.20272349
23 2015-06-13 F England Mexico 0.62706487 0.16662856 0.20630657
24 2015-06-13 E South Korea Costa Rica 0.65042439 0.15028748 0.19928814
25 2015-06-15 B Thailand Germany 0.00377424 0.95442364 0.04180213
26 2015-06-15 B Ivory Coast Norway 0.07230548 0.77669978 0.15099474
27 2015-06-15 A Netherlands Canada 0.20689503 0.57273306 0.22037191
28 2015-06-15 A China New Zealand 0.45483662 0.30539623 0.23976715
29 2015-06-16 C Ecuador Japan 0.00397266 0.95212437 0.04390296
30 2015-06-16 C Switzerland Cameroon 0.45717598 0.30328724 0.23953678
31 2015-06-16 D Nigeria USA 0.08728142 0.7500121 0.16270648
32 2015-06-16 D Australia Sweden 0.27661218 0.48740707 0.23598075
33 2015-06-17 F Mexico France 0.09507583 0.73667832 0.16824585
34 2015-06-17 F England Colombia 0.70100412 0.11691928 0.1820766
35 2015-06-17 E Costa Rica Brazil 0.02426961 0.87693534 0.09879505
36 2015-06-17 E South Korea Spain 0.36613397 0.39040036 0.24346567

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "womens-world-cup-predictions/wwc-matches-20150608-212619" (
"date" TEXT,
  "group" TEXT,
  "team1" TEXT,
  "team2" TEXT,
  "team1_win" REAL,
  "team2_win" REAL,
  "tie" REAL
);
Powered by Datasette · Query took 16.297ms