world-cup-predictions/wc-20140625-180355

4 rows where group = "a" sorted by semi

descending

Link	rowid	country	country_id	group	spi	spi_offense	spi_defense	win_group	sixteen	quarter	semi ▼	cup	win
9	9	Cameroon	CMR	a	68.13	1.4479	1.1705	0.0	0.0	0.0	0.0	0.0	0.0
12	12	Croatia	CRO	a	77.85	2.0359	0.9836	0.0	0.0	0.0	0.0	0.0	0.0
25	25	Mexico	MEX	a	80.16	1.6322	0.534	0.0	1.0	0.31217149437875896	0.17264691044528196	0.061067943811914	0.013807862036034
6	6	Brazil	BRA	a	91.27	3.2346	0.521	1.0	1.0	0.7788352855777251	0.6131344427431209	0.46984994117035406	0.367345188258079

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
);