world-cup-predictions/wc-20140625-180355

4 rows where group = "f" sorted by sixteen

descending

Link	rowid	country	country_id	group	spi	spi_offense	spi_defense	win_group	sixteen ▼	quarter	semi	cup	win
5	5	Bosnia and Herzegovina	BIH	f	79.4	2.19	0.9789	0.0	0.0	0.0	0.0	0.0	0.0
21	21	Iran	IRN	f	70.91	1.1286	0.7440000000000001	0.0	0.0	0.0	0.0	0.0	0.0
2	2	Argentina	ARG	f	89.65	2.7396	0.4256	1.0	1.0	0.744083608474386	0.5094867521324149	0.335470576150356	0.14601267533759898
27	27	Nigeria	NGA	f	76.16	1.5231	0.7259	0.0	1.0	0.253639632557626	0.076258142441911	0.01275288685387	0.0038470842841359996

Advanced export

JSON shape: default, array, newline-delimited

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