world-cup-predictions/wc-20140620-175706

1 row where win_group = "0.6808" sorted by spi_defense

descending

Link	rowid	country	country_id	group	spi	spi_offense	spi_defense ▼	win_group	sixteen	quarter	semi	cup	win
16	16	France	FRA	e	86.89	2.5361	0.5808	0.6808	0.917	0.5560645685915151	0.284882826031245	0.115400707298756	0.05286387326794099

Advanced export

JSON shape: default, array, newline-delimited

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