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

4 rows where group = "A" 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
4	4	Canada	A	89.48663963	2.20450402	0.67258603	1.0	0.0	0.0	0.0	0.0	1.0	0.807	0.46265	0.2162	0.07175
12	12	China	A	85.26258762	1.49017684	0.77733582	0.0	1.0	0.0	0.0	0.0	1.0	0.5522	0.0975	0.0176	0.0046
11	11	Netherlands	A	86.25827639	1.85865642	0.98939868	0.0	0.0	0.99995	5e-05	0.0	0.99995	0.2197	0.07085	0.02495	0.005
24	24	New Zealand	A	82.7981143	1.47447794	1.19842544	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
);