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

4 rows where group = "B"

View and edit SQL

Suggested facets: group_first, group_second, group_third_no_advance, group_fourth, sixteen, quarter, semi, final, win

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
1 Germany B 95.98858345 3.87986661 0.39052221 1 0 0 0 0 1 1.0 0.71525 0.44325 0.34775
8 Norway B 89.02838895 2.21382891 0.79255032 0 1 0 0 0 1 0.48975 0.234 0.104 0.0218
17 Thailand B 68.3687825 0.89820002 2.70336013 0 0 0 1 0 0 0.0 0.0 0.0 0.0
20 Ivory Coast B 71.92101504 1.38407212 2.75436424 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-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 31.385ms