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

4 rows where group = "F" sorted by group_second

View and edit SQL

group

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
6 France F 92.44230774 2.84962269 0.58502645 0.8933 0.08635 0.01525 0.00015 0.00495 0.9949 0.7565 0.2884 0.12755 0.0638
21 Colombia F 78.09223453 0.86604793 1.2845892 0.01905 0.1201 0.10135 0.2445 0.515 0.2405 0.0458 0.0103 0.00165 5e-05
19 Mexico F 80.97936649 1.51418181 1.54026572 0.02875 0.1746 0.12335 0.297 0.3763 0.3267 0.07795 0.0206 0.0041 0.0006
9 England F 89.29381923 2.21047358 0.72126998 0.0589 0.61895 0.1907 0.0277 0.10375 0.86855 0.4086 0.1926 0.07505 0.0195

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "womens-world-cup-predictions/wwc-forecast-20150611-182114" (
"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 28.977ms