womens-world-cup-predictions/wwc-matches-20150611-182114

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 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 0.34202399 0.41532182 0.24265419
15 2015-06-11 B Ivory Coast Thailand 0.49062241 0.27383741 0.23554018
16 2015-06-11 A Canada New Zealand 0.68461589 0.12742657 0.18795754
17 2015-06-12 D Australia Nigeria 0.44954466 0.31019118 0.24026416
18 2015-06-12 C Switzerland Ecuador 0.86488991 0.02927898 0.10583112
19 2015-06-12 D USA Sweden 0.57866011 0.20234844 0.21899146
20 2015-06-12 C Japan Cameroon 0.75327309 0.08540645 0.16132046
21 2015-06-13 F France Colombia 0.79870451 0.06060601 0.14068949
22 2015-06-13 E Brazil Spain 0.65941355 0.14415502 0.19643143
23 2015-06-13 F England Mexico 0.62015735 0.17157253 0.20827012
24 2015-06-13 E South Korea Costa Rica 0.62071882 0.17116876 0.20811242
25 2015-06-15 B Thailand Germany 0.00388683 0.9531184 0.04299478
26 2015-06-15 B Ivory Coast Norway 0.06882605 0.78312766 0.1480463
27 2015-06-15 A Netherlands Canada 0.20727069 0.57224554 0.22048377
28 2015-06-15 A China New Zealand 0.45459115 0.3056179 0.23979095
29 2015-06-16 C Ecuador Japan 0.00403959 0.95134984 0.04461057
30 2015-06-16 C Switzerland Cameroon 0.45274322 0.30728901 0.23996777
31 2015-06-16 D Nigeria USA 0.08691421 0.75064907 0.16243672
32 2015-06-16 D Australia Sweden 0.27693605 0.48703267 0.23603128
33 2015-06-17 F Mexico France 0.09299428 0.74020518 0.16680053
34 2015-06-17 F England Colombia 0.68698399 0.12589011 0.1871259
35 2015-06-17 E Costa Rica Brazil 0.02835284 0.86707542 0.10457174
36 2015-06-17 E South Korea Spain 0.37128046 0.38518684 0.2435327

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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