world-cup-predictions/wc-20140625-180355

4 rows where group = "b" sorted by group

descending

Link	rowid	country	country_id	group ▼	spi	spi_offense	spi_defense	win_group	sixteen	quarter	semi	cup	win
3	3	Australia	AUS	b	67.52	1.6824	1.4017	0.0	0.0	0.0	0.0	0.0	0.0
7	7	Chile	CHI	b	86.6	2.5703	0.6345	0.0	1.0	0.22116471442239102	0.11445388465744599	0.056072846588905996	0.028876111930049003
15	15	Spain	ESP	b	86.3	2.5034	0.6205	0.0	0.0	0.0	0.0	0.0	0.0
26	26	Netherlands	NED	b	87.4	2.8013	0.6993	1.0	1.0	0.6878285056211341	0.505048451317339	0.271380399329726	0.10332656840684101

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