womens-world-cup-predictions/wwc-matches-20150609-175933

36 rows

View and edit SQL

Suggested facets: date, group, team1, team2, team1_win, team2_win, tie, 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 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 0.65155428 0.14951189 0.19893383
13 2015-06-11 B Germany Norway 0.71705289 0.10691638 0.17603073
14 2015-06-11 A China Netherlands 0.34249248 0.41482957 0.24267794
15 2015-06-11 B Ivory Coast Thailand 0.49387222 0.27104491 0.23508287
16 2015-06-11 A Canada New Zealand 0.68468475 0.1273818 0.18793345
17 2015-06-12 D Australia Nigeria 0.44950223 0.31022976 0.24026801
18 2015-06-12 C Switzerland Ecuador 0.86483926 0.02930053 0.10586021
19 2015-06-12 D USA Sweden 0.57845419 0.20250576 0.21904005
20 2015-06-12 C Japan Cameroon 0.75383778 0.08508303 0.16107919
21 2015-06-13 F France Colombia 0.79866496 0.06062649 0.14070855
22 2015-06-13 E Brazil Spain 0.6564693 0.14615404 0.19737666
23 2015-06-13 F England Mexico 0.62017085 0.17156282 0.20826633
24 2015-06-13 E South Korea Costa Rica 0.63267231 0.16265262 0.20467507
25 2015-06-15 B Thailand Germany 0.00377528 0.95441156 0.04181316
26 2015-06-15 B Ivory Coast Norway 0.07271277 0.77595338 0.15133385
27 2015-06-15 A Netherlands Canada 0.20695783 0.57265153 0.22039063
28 2015-06-15 A China New Zealand 0.45475804 0.30546718 0.23977478
29 2015-06-16 C Ecuador Japan 0.00403328 0.95142286 0.04454386
30 2015-06-16 C Switzerland Cameroon 0.4525484 0.30746543 0.23998617
31 2015-06-16 D Nigeria USA 0.08699823 0.75050324 0.16249852
32 2015-06-16 D Australia Sweden 0.27686603 0.4871136 0.23602037
33 2015-06-17 F Mexico France 0.09309236 0.74003846 0.16686918
34 2015-06-17 F England Colombia 0.68712768 0.12579708 0.18707524
35 2015-06-17 E Costa Rica Brazil 0.02925314 0.86495065 0.10579622
36 2015-06-17 E South Korea Spain 0.38317016 0.37328094 0.2435489

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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