world-cup-predictions/wc-20140619-180248

1 row where semi = "0.158502824698375" sorted by spi descending

descending

Link	rowid	country	country_id	group	spi ▲	spi_offense	spi_defense	win_group	sixteen	quarter	semi	cup	win
4	4	Belgium	BEL	h	81.88	2.1496	0.7576	0.6418	0.8652	0.410873517202829	0.158502824698375	0.06495372281408901	0.018375117635527

Advanced export

JSON shape: default, array, newline-delimited

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