world-cup-predictions/wc-20140622-235721

1 row where sixteen = "0.3817" sorted by spi_offense

descending

Link	rowid	country	country_id	group	spi	spi_offense ▼	spi_defense	win_group	sixteen	quarter	semi	cup	win
13	13	Ecuador	ECU	e	79.96	1.9882	0.7909999999999999	0.004	0.3817	0.116818702034929	0.054680919287623996	0.022638974029945	0.005452737062725

Advanced export

JSON shape: default, array, newline-delimited

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