world-cup-predictions/wc-20140625-180355

3 rows where group = "b" and win_group = "0.0" sorted by spi_defense

descending

Link	rowid	country	country_id	group	spi	spi_offense	spi_defense ▼	sixteen	quarter	semi	cup	win
15	15	Spain	ESP	b	86.3	2.5034	0.6205	0.0	0.0	0.0	0.0	0.0
7	7	Chile	CHI	b	86.6	2.5703	0.6345	1.0	0.22116471442239102	0.11445388465744599	0.056072846588905996	0.028876111930049003
3	3	Australia	AUS	b	67.52	1.6824	1.4017	0.0	0.0	0.0	0.0	0.0

Advanced export

JSON shape: default, array, newline-delimited

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