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

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.66247075 0.14208918 0.19544006
11 2015-06-09 F Colombia Mexico 0.30538056 0.45485397 0.23976547
12 2015-06-09 E Brazil South Korea 0.6514837 0.1495603 0.198956
13 2015-06-11 B Germany Norway 0.71692745 0.10699346 0.1760791
14 2015-06-11 A China Netherlands 0.3425088 0.41481244 0.24267877
15 2015-06-11 B Ivory Coast Thailand 0.49386336 0.2710525 0.23508414
16 2015-06-11 A Canada New Zealand 0.68464684 0.12740645 0.18794671
17 2015-06-12 D Australia Nigeria 0.44949184 0.31023921 0.24026895
18 2015-06-12 C Switzerland Ecuador 0.8652997 0.02910475 0.10559555
19 2015-06-12 D USA Sweden 0.57820128 0.20269905 0.21909967
20 2015-06-12 C Japan Cameroon 0.75383902 0.08508232 0.16107866
21 2015-06-13 F France Colombia 0.80205956 0.05887547 0.13906498
22 2015-06-13 E Brazil Spain 0.63934798 0.15796311 0.20268891
23 2015-06-13 F England Mexico 0.61663862 0.17411062 0.20925075
24 2015-06-13 E South Korea Costa Rica 0.65043021 0.15028348 0.19928631
25 2015-06-15 B Thailand Germany 0.00377534 0.95441089 0.04181377
26 2015-06-15 B Ivory Coast Norway 0.07264921 0.77606978 0.15128101
27 2015-06-15 A Netherlands Canada 0.20694386 0.57266967 0.22038647
28 2015-06-15 A China New Zealand 0.45471672 0.3055045 0.23977878
29 2015-06-16 C Ecuador Japan 0.00402772 0.95148718 0.0444851
30 2015-06-16 C Switzerland Cameroon 0.45255022 0.30746378 0.239986
31 2015-06-16 D Nigeria USA 0.08712443 0.75028431 0.16259126
32 2015-06-16 D Australia Sweden 0.27685645 0.48712468 0.23601888
33 2015-06-17 F Mexico France 0.09499259 0.73681889 0.16818852
34 2015-06-17 F England Colombia 0.69115932 0.123196 0.18564467
35 2015-06-17 E Costa Rica Brazil 0.02423667 0.87701648 0.09874685
36 2015-06-17 E South Korea Spain 0.3661331 0.39040125 0.24346566

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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