world-cup-predictions/wc-20140622-235721

13 rows where win_group = "0.0" sorted by spi_defense

descending

Link	rowid	country	country_id	group	spi	spi_offense	spi_defense ▼	sixteen	quarter	semi	cup	win
19	19	Greece	GRE	c	74.14	1.1789	0.5861	0.2069	0.08753979619936299	0.024876364478044997	0.0071128991372149996	0.001205453257524
29	29	Russia	RUS	h	78.29	1.6109	0.6422	0.5187	0.138887600472553	0.046181961609447	0.009441361020152	0.003008947454078
15	15	Spain	ESP	b	85.74	2.4827	0.6531	0.0	0.0	0.0	0.0	0.0
21	21	Iran	IRN	f	71.13	1.1454	0.7389	0.1279	0.024911380942276	0.005929007802883	0.0008328229613289999	0.000191279886615
14	14	England	ENG	d	81.41	2.1295	0.7794	0.0	0.0	0.0	0.0	0.0
18	18	Ghana	GHA	g	77.45	1.9154	0.9179999999999999	0.1909	0.081848861745763	0.025937851212773998	0.009726001148096	0.0020014917809200003
28	28	Portugal	POR	g	78.95	2.077	0.9259999999999999	0.0543	0.024928263672772004	0.008613348553097	0.003509027536227	0.000793124844545
5	5	Bosnia and Herzegovina	BIH	f	79.44	2.199	0.9753	0.0	0.0	0.0	0.0	0.0
24	24	South Korea	KOR	h	72.56	1.6908	1.0781	0.0208	0.003936992979788	0.001003424561725	0.000143025658397	3.5220462707e-05
9	9	Cameroon	CMR	a	69.29	1.4838	1.1217	0.0	0.0	0.0	0.0	0.0
20	20	Honduras	HON	e	68.3	1.5104	1.2044	0.0194	0.003377192781918	0.001004634876889	0.000263510059423	3.2393988118e-05
23	23	Japan	JPN	c	73.36	1.97	1.2383	0.0437	0.017963847062391996	0.00489668294841	0.001339939154951	0.00020604838238199997
3	3	Australia	AUS	b	70.31	1.7889	1.3002	0.0	0.0	0.0	0.0	0.0

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