world-cup-predictions/wc-20140705-093245

4 rows where group = "b" sorted by spi_offense

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.48	1.6932	1.4136	0	0	0	0.0	0.0	0.0
15	15	Spain	ESP	b	86.26	2.4998	0.6155	0	0	0	0.0	0.0	0.0
7	7	Chile	CHI	b	86.41	2.5199	0.6144	0	1	0	0.0	0.0	0.0
26	26	Netherlands	NED	b	87.75	2.8653	0.6958	1	1	1	0.763080379103607	0.38973139900592496	0.11822229989208302

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