world-cup-predictions/wc-20140622-091255

1 row where win_group = "0.1152" sorted by spi

descending

Link	rowid	country	country_id	group	spi ▼	spi_offense	spi_defense	win_group	sixteen	quarter	semi	cup	win
27	27	Nigeria	NGA	f	76.01	1.5294	0.7335	0.1152	0.8776	0.242838874951047	0.08070085426083501	0.018162918990107	0.004473260676872

Advanced export

JSON shape: default, array, newline-delimited

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