world-cup-predictions/wc-20140705-093245

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

descending

Link	rowid	country	country_id	group	spi	spi_offense	spi_defense	win_group ▲	sixteen	quarter
10	10	Colombia	COL	c	89.29	2.6309	0.39299999999999996	1	1	1
8	8	Ivory Coast	CIV	c	78.36	2.2481	1.0948	0	0	0
19	19	Greece	GRE	c	74.83	1.1857	0.5541	0	1	0
23	23	Japan	JPN	c	72.87	2.029	1.3238	0	0	0

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