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

4 rows where group = "B" sorted by wspi_defense

descending

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	1	Germany	B	95.70278239	3.75700988	0.38744414	1.0	0.0	0.0	0.0	0.0	1.0	0.8273	0.6929	0.43975	0.31675
8	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
21	21	Thailand	B	68.33349734	0.89889336	2.71014832	0.0	0.0	0.2397	0.7603	0.0	0.2397	0.00365	0.0001	0.0	0.0
23	23	Ivory Coast	B	71.8384438	1.37944188	2.76162647	0.0	0.0	0.0	0.0	1.0	0.0	0.0	0.0	0.0	0.0

Advanced export

JSON shape: default, array, newline-delimited

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