world-cup-predictions/wc-20140629-225940

1 row where semi = "0.10667899486164" sorted by win

descending

Link	rowid	country	country_id	group	spi	spi_offense	spi_defense	win_group	sixteen	quarter	semi	cup	win ▼
32	32	USA	USA	g	78.62	2.0268	0.9228	0	1	0.4115814673215821	0.10667899486164	0.035678568118811003	0.005908958684436999

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE "world-cup-predictions/wc-20140629-225940" (
"country" TEXT,
  "country_id" TEXT,
  "group" TEXT,
  "spi" REAL,
  "spi_offense" REAL,
  "spi_defense" REAL,
  "win_group" INTEGER,
  "sixteen" INTEGER,
  "quarter" REAL,
  "semi" REAL,
  "cup" REAL,
  "win" REAL
);