womens-world-cup-predictions/wwc-forecast-20150627-213532

6 rows where group_second = 1

View and edit SQL

Suggested facets: quarter

group_third_no_advance

  • 0 6

group_second

group_first

  • 0 6
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
5 Australia D 89.21394219 2.33337534 0.8830936 0 1 0 0 0 1 1 0 0.0 0.0
6 France F 92.46354832 2.86166617 0.60567606 0 1 0 0 0 1 1 0 0.0 0.0
7 China A 85.29942131 1.45211907 0.73194131 0 1 0 0 0 1 1 0 0.0 0.0
9 Cameroon C 81.17396015 1.2930853 1.27064268 0 1 0 0 0 1 0 0 0.0 0.0
10 Norway B 88.92239869 2.21078224 0.81587755 0 1 0 0 0 1 0 0 0.0 0.0
15 South Korea E 83.18278313 1.68140824 1.36193804 0 1 0 0 0 1 0 0 0.0 0.0

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "womens-world-cup-predictions/wwc-forecast-20150627-213532" (
"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" INTEGER,
  "semi" INTEGER,
  "final" REAL,
  "win" REAL
);
Powered by Datasette · Query took 26.21ms