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

4 rows where group = "E" 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
5	5	Brazil	E	92.20151735	2.74667404	0.55153209	1.0	0.0	0.0	0.0	0.0	1.0	0.5448	0.298	0.17155	0.06185
14	14	Spain	E	83.91743339	1.48399124	1.01584968	0.0	0.5484	0.01285	0.0785	0.36025	0.56125	0.19525	0.02735	0.00695	0.00215
16	16	South Korea	E	83.30212814	1.67748517	1.33473725	0.0	0.3473	0.01295	0.12775	0.512	0.36025	0.1198	0.01605	0.00345	0.0009
20	20	Costa Rica	E	74.46848601	0.98090239	1.95309483	0.0	0.1043	0.0704	0.69755	0.12775	0.1747	0.0199	0.0015	5e-05	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
);