world-cup-predictions/wc-20140705-093245

4 rows where group = "f" sorted by semi

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	80.27	2.28	0.9725	0	0	0	0.0	0.0	0.0
21	21	Iran	IRN	f	69.33	1.1118	0.823	0	0	0	0.0	0.0	0.0
27	27	Nigeria	NGA	f	76.13	1.6419	0.8144	0	1	0	0.0	0.0	0.0
2	2	Argentina	ARG	f	89.55	2.7778	0.4523	1	1	1	0.699678592179709	0.426755162921383	0.149205785287355

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE "world-cup-predictions/wc-20140705-093245" (
"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
);