womens-world-cup-predictions/wwc-forecast-20150609-205725

24 rows

View and edit SQL

Suggested facets: group, group_third_no_advance, group_fourth, sixteen, win

Link rowid team group wspi wspi_offense wspi_defense group_first group_second group_third_advance group_third_no_advance group_fourth sixteen quarter semi final win
1 Germany B 95.9550555 3.88225525 0.38932083 0.88995 0.1095 0.0005 5e-05 0.0 0.99995 0.84355 0.6467 0.4192 0.30575
2 USA D 95.42478214 3.70070804 0.4374701 0.81485 0.14445 0.0326 0.0014 0.0067 0.9919 0.86795 0.72815 0.4232 0.2859
3 Japan C 92.56045504 2.83954615 0.5370566 0.86135 0.1207 0.0179 5e-05 0.0 0.99995 0.79175 0.4006 0.2331 0.0887
4 Canada A 90.05238631 2.33930494 0.68009407 0.6942 0.2257 0.0662 0.00145 0.01245 0.9861 0.7586 0.40775 0.18865 0.07065
5 Brazil E 92.28800101 2.80000652 0.57653432 0.89785 0.09175 0.00765 0.0003 0.00245 0.99725 0.55285 0.3102 0.1796 0.0655
6 France F 92.43737082 2.84868968 0.58467324 0.8992 0.08245 0.01195 0.0003 0.0061 0.9936 0.75615 0.2917 0.13065 0.065
7 Sweden D 91.66015784 2.76740295 0.72321922 0.1215 0.3924 0.1848 0.12375 0.17755 0.6987 0.35155 0.21025 0.1023 0.0384
8 Norway B 88.91200316 2.20458319 0.803032 0.10965 0.8434 0.04425 0.0026 0.0001 0.9973 0.5328 0.2518 0.09445 0.0233
9 England F 89.29271289 2.2104216 0.72119056 0.05955 0.6169 0.19215 0.02825 0.10315 0.8686 0.41025 0.19665 0.07635 0.02155
10 Australia D 88.82385916 2.37879596 1.0137119 0.02125 0.25075 0.27375 0.04565 0.4086 0.54575 0.17765 0.0836 0.0355 0.0106
11 Netherlands A 86.37501219 1.89809105 1.0070285 0.2464 0.4055 0.27695 0.0169 0.05425 0.92885 0.463 0.1323 0.038 0.00855
12 Nigeria D 86.616765 1.86284533 0.92025667 0.0424 0.2124 0.21305 0.125 0.40715 0.46785 0.1331 0.0562 0.01845 0.0045
13 China A 85.09606755 1.44552845 0.75657804 0.0379 0.27995 0.2881 0.07875 0.3153 0.60595 0.23895 0.05185 0.0134 0.0033
14 Spain E 84.09582552 1.56291567 1.06800619 0.0714 0.3675 0.14655 0.22175 0.1928 0.58545 0.13185 0.0328 0.00895 0.00255
15 Switzerland C 83.53356183 1.80714675 1.4341178 0.00865 0.42855 0.4921 0.05275 0.01795 0.9293 0.3024 0.06755 0.0131 0.0023
16 South Korea E 83.83177784 1.67641363 1.23890981 0.0201 0.41305 0.2804 0.0591 0.22735 0.71355 0.1354 0.03015 0.00575 0.00165
17 Cameroon C 80.57810971 1.24722636 1.31289427 0.13 0.4503 0.41615 0.00345 0.0001 0.99645 0.28655 0.04665 0.00795 0.001
18 New Zealand A 82.21672369 1.40790152 1.22051803 0.0215 0.08885 0.22025 0.0514 0.618 0.3306 0.0948 0.0195 0.00465 0.0004
19 Mexico F 80.97828298 1.51385079 1.54021231 0.02615 0.1765 0.1247 0.2954 0.37725 0.32735 0.0773 0.02045 0.0044 0.00035
20 Ivory Coast B 73.06459752 1.34694638 2.55321771 0.0003 0.04605 0.3063 0.19235 0.455 0.35265 0.03115 0.00385 0.0008 5e-05
21 Colombia F 78.09474689 0.8660494 1.28455511 0.0151 0.12415 0.09935 0.2479 0.5135 0.2386 0.0426 0.0092 0.0014 0.0
22 Costa Rica E 73.6999476 0.87075652 1.94159477 0.01065 0.1277 0.1189 0.16535 0.5774 0.25725 0.01465 0.0018 0.0001 0.0
23 Thailand B 67.45017141 0.87224919 2.79655245 5e-05 0.00105 0.1726 0.2814 0.5449 0.1737 0.00495 0.0003 5e-05 0.0
24 Ecuador C 59.00788812 0.43526592 3.38739414 0.0 0.00045 0.01285 0.00475 0.98195 0.0133 0.0002 0.0 0.0 0.0

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "womens-world-cup-predictions/wwc-forecast-20150609-205725" (
"team" TEXT,
  "group" TEXT,
  "wspi" REAL,
  "wspi_offense" REAL,
  "wspi_defense" REAL,
  "group_first" REAL,
  "group_second" REAL,
  "group_third_advance" REAL,
  "group_third_no_advance" REAL,
  "group_fourth" REAL,
  "sixteen" REAL,
  "quarter" REAL,
  "semi" REAL,
  "final" REAL,
  "win" REAL
);
Powered by Datasette · Query took 36.621ms