world-cup-predictions/wc-20140622-235721

4 rows where group = "g" sorted by semi

descending

Link	rowid	country	country_id	group	spi	spi_offense	spi_defense	win_group	sixteen	quarter	semi ▼	cup	win
28	28	Portugal	POR	g	78.95	2.077	0.9259999999999999	0.0	0.0543	0.024928263672772004	0.008613348553097	0.003509027536227	0.000793124844545
18	18	Ghana	GHA	g	77.45	1.9154	0.9179999999999999	0.0	0.1909	0.081848861745763	0.025937851212773998	0.009726001148096	0.0020014917809200003
32	32	USA	USA	g	78.67	2.1221	0.9784	0.143	0.7577	0.366222250933069	0.125520539547468	0.044625105923579	0.010532717706092
17	17	Germany	GER	g	88.69	3.1804	0.7879	0.857	0.9971	0.800094865950399	0.479228604266649	0.21824040728640198	0.125055075404015

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
);