world-cup-predictions/wc-20140704-180211

4 rows where group = "g" sorted by sixteen

descending

Link	rowid	country	country_id	group	spi	spi_offense	spi_defense	win_group	sixteen ▼	quarter	semi	cup	win
18	18	Ghana	GHA	g	78.28	1.9921	0.9192	0	0	0	0.0	0.0	0.0
28	28	Portugal	POR	g	79.78	2.1732	0.9364	0	0	0	0.0	0.0	0.0
17	17	Germany	GER	g	88.28	2.9655	0.7021	1	1	1	1.0	0.331864391335693	0.17717678350047197
32	32	USA	USA	g	78.19	1.9978	0.9297	0	1	0	0.0	0.0	0.0

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE "world-cup-predictions/wc-20140704-180211" (
"country" TEXT,
  "country_id" TEXT,
  "group" TEXT,
  "spi" REAL,
  "spi_offense" REAL,
  "spi_defense" REAL,
  "win_group" INTEGER,
  "sixteen" INTEGER,
  "quarter" INTEGER,
  "semi" REAL,
  "cup" REAL,
  "win" REAL
);