world-cup-predictions/wc-20140705-093245

4 rows where group = "e" sorted by group

descending

Link	rowid	country	country_id	group ▼	spi	spi_offense	spi_defense	win_group	sixteen	quarter
13	13	Ecuador	ECU	e	80.2	1.7948	0.6429	0	0	0
16	16	France	FRA	e	87.74	2.5758	0.5206	1	1	1
20	20	Honduras	HON	e	65.77	1.4471	1.3155	0	0	0
30	30	Switzerland	SUI	e	79.64	2.1847	0.9552	0	1	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
);