world-cup-predictions/wc-20140622-091255

32 rows sorted by sixteen

descending

Link	rowid	country	country_id	group	spi	spi_offense	spi_defense	win_group	sixteen ▼	quarter	semi	cup	win
3	3	Australia	AUS	b	70.31	1.7889	1.3002	0.0	0.0	0.0	0.0	0.0	0.0
5	5	Bosnia and Herzegovina	BIH	f	79.44	2.199	0.9753	0.0	0.0	0.0	0.0	0.0	0.0
9	9	Cameroon	CMR	a	69.29	1.4838	1.1217	0.0	0.0	0.0	0.0	0.0	0.0
14	14	England	ENG	d	81.41	2.1295	0.7794	0.0	0.0	0.0	0.0	0.0	0.0
15	15	Spain	ESP	b	85.74	2.4827	0.6531	0.0	0.0	0.0	0.0	0.0	0.0
20	20	Honduras	HON	e	68.3	1.5104	1.2044	0.0	0.0194	0.003377192781918	0.001011737811057	0.00026324593426800004	3.291729391199999e-05
23	23	Japan	JPN	c	73.36	1.97	1.2383	0.0	0.0382	0.015726924522942	0.004248267155743	0.001151440675256	0.00018060530004400003
21	21	Iran	IRN	f	71.13	1.1454	0.7389	0.0	0.1224	0.023829166636012998	0.006160991193304001	0.000869161380262	0.0001955722733
18	18	Ghana	GHA	g	77.45	1.9154	0.9179999999999999	0.0	0.1529	0.07064955765565101	0.022542526894455003	0.008414722897007	0.001742811910816
1	1	Algeria	ALG	h	64.24	1.1759	1.1673	0.0216	0.16	0.026948096360467997	0.0049553346483929995	0.000622437095689	9.170127026299999e-05
19	19	Greece	GRE	c	74.14	1.1789	0.5861	0.0	0.2097	0.08878340402334699	0.025194997958954	0.007161940099923999	0.0012331809403839998
28	28	Portugal	POR	g	78.95	2.077	0.9259999999999999	0.0318	0.2226	0.112668489481634	0.039413594455236	0.014722561161588002	0.0035204551769109998
13	13	Ecuador	ECU	e	79.96	1.9882	0.7909999999999999	0.0038	0.3737	0.116422819050223	0.054323093436618	0.02240556532423	0.005457063533308
12	12	Croatia	CRO	a	79.49	2.0251	0.8508	0.0399	0.3903	0.12611717848929999	0.06326071921773001	0.023146241794	0.0053757790403570005
31	31	Uruguay	URU	d	81.49	2.2409	0.8485	0.056	0.4044	0.16401965946839497	0.04251430771135299	0.016651526828724	0.005860669555407
24	24	South Korea	KOR	h	72.56	1.6908	1.0781	0.1276	0.4052	0.10290788866619802	0.025799718393131	0.005312776482636	0.0009944382642680001
29	29	Russia	RUS	h	78.29	1.6109	0.6422	0.2038	0.567	0.19200798549103898	0.062793390814563	0.017461754792606	0.004445271424003
22	22	Italy	ITA	d	79.23	1.9415	0.8109	0.0563	0.5956	0.20531199507778802	0.043050042150643	0.014542864831556002	0.004530784222928999
30	30	Switzerland	SUI	e	78.26	2.1701	1.0416	0.0003	0.6069	0.17231067626810503	0.07697713593991	0.030239420876718	0.006709168671236
25	25	Mexico	MEX	a	78.43	1.4776	0.5368	0.0469	0.617	0.18323695767892997	0.08641199438745098	0.02924380262186	0.006205733813293
32	32	USA	USA	g	78.67	2.1221	0.9784	0.2199	0.6475	0.33280862476661405	0.11531878717481801	0.038024248323018	0.009384612828284001
8	8	Ivory Coast	CIV	c	79.49	2.2641	1.0166	0.0144	0.7521	0.400218204548308	0.14893963530499899	0.056121638270891	0.013536842104447
4	4	Belgium	BEL	h	81.79	2.1428	0.759	0.647	0.8678	0.40388687471539	0.15884973943697697	0.06528016605017	0.018559904806788003
27	27	Nigeria	NGA	f	76.01	1.5294	0.7335	0.1152	0.8776	0.242838874951047	0.08070085426083501	0.018162918990107	0.004473260676872
17	17	Germany	GER	g	88.69	3.1804	0.7879	0.7483	0.977	0.758122482863046	0.451895103922509	0.215996840687853	0.12001307128391901
6	6	Brazil	BRA	a	91.07	3.1860000000000004	0.5158	0.9132	0.9927	0.7493369644151979	0.6029990064505749	0.458843244389478	0.35718675433178904
2	2	Argentina	ARG	f	89.66	2.7413	0.4218	0.8848	1.0	0.7211716424319521	0.49534845846131	0.31067115563165304	0.14378945640542098
7	7	Chile	CHI	b	87.77	2.7354	0.6178	0.4017	1.0	0.446458409235807	0.293160841710755	0.160514738412286	0.07159147840317301
10	10	Colombia	COL	c	87.48	2.4192	0.4511	0.9856	1.0	0.6581812261391851	0.214190688291034	0.10763457203355803	0.054708848533477995
11	11	Costa Rica	CRC	d	78.52	1.5889	0.6109	0.8877	1.0	0.467758586220153	0.15554419856071697	0.05370825623781599	0.011976164952528998
16	16	France	FRA	e	87.81	2.7464	0.6204	0.9959	1.0	0.720049627880766	0.403909533156877	0.15670496181220497	0.08372175169469
26	26	Netherlands	NED	b	86.19	2.7961	0.8076	0.5983	1.0	0.49485049018069	0.320485301099972	0.166127796364639	0.064481701288183

Advanced export

JSON shape: default, array, newline-delimited

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