womens-world-cup-predictions/wwc-forecast-20150621-175918

4 rows where group_third_advance = 1 sorted by semi

descending

Link	rowid	team	group	wspi	wspi_offense	wspi_defense	group_third_advance	sixteen	quarter	semi ▼	final	win
16	16	Sweden	D	91.31747939	2.67575705	0.72694534	1	1	0.0	0.0	0.0	0.0
12	12	Colombia	F	80.32349361	1.10940758	1.20507423	1	1	0.05145	0.01805	0.00175	0.0003
11	11	Switzerland	C	83.80700518	1.93623276	1.53110109	1	1	0.24055	0.07735	0.0233	0.00265
9	9	Netherlands	A	86.26855756	1.85744459	0.98829936	1	1	0.2715	0.11125	0.04355	0.0073

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE "womens-world-cup-predictions/wwc-forecast-20150621-175918" (
"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" REAL,
  "semi" REAL,
  "final" REAL,
  "win" REAL
);