world-cup-predictions/wc-20140622-235721

4 rows where group = "c" sorted by semi

descending

Link	rowid	country	country_id	group	spi	spi_offense	spi_defense	win_group	sixteen	quarter	semi ▼	cup	win
23	23	Japan	JPN	c	73.36	1.97	1.2383	0.0	0.0437	0.017963847062391996	0.00489668294841	0.001339939154951	0.00020604838238199997
19	19	Greece	GRE	c	74.14	1.1789	0.5861	0.0	0.2069	0.08753979619936299	0.024876364478044997	0.0071128991372149996	0.001205453257524
8	8	Ivory Coast	CIV	c	79.49	2.2641	1.0166	0.0132	0.7494	0.398683271972443	0.148708687680844	0.05646335695471	0.013467524017466998
10	10	Colombia	COL	c	87.48	2.4192	0.4511	0.9868	1.0	0.657785949589661	0.21287510598478698	0.10464576439145802	0.05360363697890401

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