world-cup-predictions/wc-20140710-164509

4 rows where group = "c" sorted by country

descending

Link	rowid	country ▼	country_id	group	spi	spi_offense	spi_defense	win_group	sixteen	quarter
10	10	Colombia	COL	c	89.06	2.5988	0.3986	1	1	1
19	19	Greece	GRE	c	74.85	1.194	0.5597	0	1	0
8	8	Ivory Coast	CIV	c	78.33	2.246	1.0959	0	0	0
23	23	Japan	JPN	c	72.81	2.0375	1.3349	0	0	0

Advanced export

JSON shape: default, array, newline-delimited

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