womens-world-cup-predictions/wwc-forecast-20150621-213134

4 rows where group = "D"

View and edit SQL

Suggested facets: group_first, group_second, group_fourth, sixteen, quarter, final

win

semi

group_third_advance

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
2 USA D 95.20588303 3.5665402 0.40443394 1 0 0 0 0 1 0.95405 0.8391 0.4152 0.30005
6 Australia D 89.47812011 2.40487837 0.89759282 0 1 0 0 0 1 1.0 0.43055 0.19865 0.0477
12 Sweden D 91.32029906 2.67609931 0.72745095 0 0 1 0 0 1 0.0 0.0 0.0 0.0
23 Nigeria D 85.84140827 1.71052963 0.91113746 0 0 0 0 1 0 0.0 0.0 0.0 0.0

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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