world-cup-predictions/wc-20140629-225940

4 rows where group = "d" sorted by win_group descending

descending

Link	rowid	country	country_id	group	spi	spi_offense	spi_defense	win_group ▲	sixteen	quarter	semi	cup	win
11	11	Costa Rica	CRC	d	78.18	1.479	0.5604	1	1	1.0	0.24952902938266397	0.070241804991627	0.010750394900933002
14	14	England	ENG	d	81.05	2.0535	0.7613	0	0	0.0	0.0	0.0	0.0
22	22	Italy	ITA	d	78.4	1.8135	0.7866	0	0	0.0	0.0	0.0	0.0
31	31	Uruguay	URU	d	80.86	2.0933	0.8031	0	1	0.0	0.0	0.0	0.0

Advanced export

JSON shape: default, array, newline-delimited

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