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

6 rows where group_second = 1 sorted by sixteen

View and edit SQL

Suggested facets: quarter, semi, final, win

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
4 Canada A 89.5109479 2.20922425 0.67481575 0 1 0 0 0 1 0.75945 0.4416 0.2324 0.07055
6 Australia D 89.47502224 2.40500589 0.89766517 0 1 0 0 0 1 1.0 0.4297 0.2085 0.05095
7 England F 89.21274468 2.22302813 0.75997928 0 1 0 0 0 1 0.51025 0.24705 0.11215 0.02495
8 Norway B 89.02838895 2.21382891 0.79255032 0 1 0 0 0 1 0.48975 0.234 0.104 0.0218
13 Cameroon C 81.15073192 1.28820488 1.26752494 0 1 0 0 0 1 0.0 0.0 0.0 0.0
15 South Korea E 83.17624518 1.67940032 1.35913104 0 1 0 0 0 1 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-175918" (
"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 34.651ms