world-cup-predictions/wc-20140629-225940

4 rows where group = "e" sorted by spi_defense

descending

Link	rowid	country	country_id	group	spi	spi_offense	spi_defense ▼	win_group	sixteen	quarter	semi	cup	win
16	16	France	FRA	e	87.62	2.6444	0.5791	1	1	0.75746452914177	0.377900471238731	0.112755582565703	0.057091509499679005
13	13	Ecuador	ECU	e	80.11	1.7828	0.6434	0	0	0.0	0.0	0.0	0.0
30	30	Switzerland	SUI	e	79.74	2.2656	1.0062	0	1	0.22229393064238298	0.106742391683657	0.038716157219240994	0.0071386992422479995
20	20	Honduras	HON	e	65.76	1.4288	1.3019	0	0	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
);