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

4 rows where group = "A"

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	Canada	A	89.7058039	2.24199953	0.6623747	0.68935	0.12235	0.18825	5e-05	0.0	0.99995	0.72525	0.3954	0.1863	0.06615
11	11	Netherlands	A	86.02741298	1.83711664	1.01192734	0.1542	0.10545	0.60505	0.03095	0.10435	0.8647	0.2935	0.0951	0.03075	0.00755
12	12	China	A	85.29283885	1.44790154	0.72614198	0.1564	0.4999	0.13555	0.0062	0.20195	0.79185	0.40305	0.09205	0.0223	0.00495
19	19	New Zealand	A	82.41742402	1.37154141	1.15029009	0.0	0.2723	0.034	0.0	0.6937	0.3063	0.13695	0.0206	0.0029	0.00035

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE "womens-world-cup-predictions/wwc-forecast-20150615-175745" (
"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
);