womens-world-cup-predictions/wwc-forecast-20150615-213540

2 rows where group_second = "1.0" sorted by group_third_advance

View and edit SQL

group_second

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
8 Norway B 89.03152686 2.2188491 0.79456345 0.0 1.0 0.0 0.0 0.0 1.0 0.52585 0.24475 0.08945 0.0242
12 China A 85.26258762 1.49017684 0.77733582 0.0 1.0 0.0 0.0 0.0 1.0 0.5522 0.0975 0.0176 0.0046

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "womens-world-cup-predictions/wwc-forecast-20150615-213540" (
"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 32.566ms