world-cup-predictions/wc-20140623-220333

1 row where sixteen = "0.9972" sorted by spi

descending

Link	rowid	country	country_id	group	spi ▼	spi_offense	spi_defense	win_group	sixteen	quarter	semi	cup	win
17	17	Germany	GER	g	88.74	3.1773	0.7828	0.8631	0.9972	0.777012913096136	0.466395277947485	0.207825363658416	0.12296294293647198

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE "world-cup-predictions/wc-20140623-220333" (
"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
);