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

36 rows

View and edit SQL

Suggested facets: date, group, team1, 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 0.49470583 0.27033055 0.23496363
10 2015-06-09 E Spain Costa Rica 0.66246231 0.14209488 0.19544282
11 2015-06-09 F Colombia Mexico 0.30538411 0.45485004 0.23976585
12 2015-06-09 E Brazil South Korea 0.65142438 0.14960098 0.19897463
13 2015-06-11 B Germany Norway 0.71651282 0.10724834 0.17623884
14 2015-06-11 A China Netherlands 0.34262031 0.41469532 0.24268437
15 2015-06-11 B Ivory Coast Thailand 0.49380762 0.2711003 0.23509208
16 2015-06-11 A Canada New Zealand 0.68473659 0.12734811 0.1879153
17 2015-06-12 D Australia Nigeria 0.44946305 0.31026539 0.24027156
18 2015-06-12 C Switzerland Ecuador 0.86530464 0.02910265 0.10559271
19 2015-06-12 D USA Sweden 0.5779983 0.20285422 0.21914747
20 2015-06-12 C Japan Cameroon 0.75412568 0.08491828 0.16095603
21 2015-06-13 F France Colombia 0.80202309 0.0588942 0.13908271
22 2015-06-13 E Brazil Spain 0.63931778 0.15798422 0.202698
23 2015-06-13 F England Mexico 0.6270672 0.1666269 0.2063059
24 2015-06-13 E South Korea Costa Rica 0.65045107 0.15026914 0.19927978
25 2015-06-15 B Thailand Germany 0.00377353 0.95443188 0.04179459
26 2015-06-15 B Ivory Coast Norway 0.07230832 0.77669458 0.15099711
27 2015-06-15 A Netherlands Canada 0.20690161 0.57272452 0.22037387
28 2015-06-15 A China New Zealand 0.45487672 0.30536002 0.23976326
29 2015-06-16 C Ecuador Japan 0.00402498 0.9515189 0.04445612
30 2015-06-16 C Switzerland Cameroon 0.45255286 0.30746139 0.23998575
31 2015-06-16 D Nigeria USA 0.08721986 0.75011883 0.16266131
32 2015-06-16 D Australia Sweden 0.27682061 0.4871661 0.23601329
33 2015-06-17 F Mexico France 0.0950146 0.73678172 0.16820368
34 2015-06-17 F England Colombia 0.7010071 0.11691739 0.1820755
35 2015-06-17 E Costa Rica Brazil 0.02424717 0.8769906 0.09876223
36 2015-06-17 E South Korea Spain 0.36616233 0.39037153 0.24346614

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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