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

4 rows where group = "D" sorted by wspi_defense

descending

Link	rowid	team	group	wspi	wspi_offense	wspi_defense ▼	group_first	group_second	group_third_advance	group_fourth	sixteen	quarter	semi	final	win
2	2	USA	D	95.10437316	3.50649052	0.38484998	1	0	0	0	1	1	1	0.43485	0.3043
11	11	Sweden	D	91.33973649	2.68134434	0.73009993	0	0	1	0	1	0	0	0.0	0.0
5	5	Australia	D	89.21394219	2.33337534	0.8830936	0	1	0	0	1	1	0	0.0	0.0
23	23	Nigeria	D	85.8629464	1.71701819	0.91543867	0	0	0	1	0	0	0	0.0	0.0

Advanced export

JSON shape: default, array, newline-delimited

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
);