world-cup-predictions/wc-20140613-205820

32 rows

descending

Link	rowid	country	country_id	group	spi	spi_offense	spi_defense	win_group	sixteen	quarter	semi	cup	win
1	1	Algeria	ALG	h	63.41	1.1202	1.1642	0.0597	0.2005	0.037301180400736995	0.007881988823233	0.001067161837844	0.000135769777558
2	2	Argentina	ARG	f	90.0	2.8542	0.4498	0.7388	0.9272	0.668713937819563	0.466599787953553	0.296976578940205	0.135408018458966
3	3	Australia	AUS	b	69.47	1.6380000000000001	1.232	0.0173	0.0773	0.009794100277979001	0.0029451235652359995	0.000681988148104	9.7078492072e-05
4	4	Belgium	BEL	h	82.0	2.1387	0.7397	0.5013	0.7761	0.35651430220047603	0.150086978970677	0.059504485501492003	0.016437193838850003
5	5	Bosnia and Herzegovina	BIH	f	80.32	2.3119	0.9862	0.1539	0.5693	0.26662727575892603	0.114355078652623	0.033461590374632005	0.009779456636491
6	6	Brazil	BRA	a	91.64	3.3933	0.5589999999999999	0.9685	0.998	0.811585755733071	0.702057442719976	0.567927284680543	0.46077934339980603
7	7	Chile	CHI	b	86.71	2.7085	0.7041	0.3422	0.6731	0.31535963106162296	0.19973670277058703	0.106995629300709	0.040915440812598
8	8	Ivory Coast	CIV	c	78.89	2.2468	1.0484	0.24	0.5373	0.24796388138863698	0.07610660057262798	0.028097061603523	0.006847573882168
9	9	Cameroon	CMR	a	71.33	1.4802	0.9908	0.0006	0.0377	0.01029469621852	0.0035173273704559994	0.0009111135740199999	0.000124632540462
10	10	Colombia	COL	c	85.82	2.1806	0.4532	0.5182	0.7715	0.452637593504761	0.15520759066188597	0.075850589140938	0.029607128833703
11	11	Costa Rica	CRC	d	74.07	1.3226	0.6996	0.0913	0.2643	0.101252924333626	0.020281131222523997	0.005865184487386999	0.001182347216197
12	12	Croatia	CRO	a	76.13	1.7849	0.9129	0.0031	0.3744	0.12558064981013903	0.051286261121084996	0.016253970480313	0.0028151978796550005
13	13	Ecuador	ECU	e	80.64	2.0295	0.7689	0.2371	0.5583	0.230319727240792	0.10192571365126699	0.034726975687361	0.009394358242509001
14	14	England	ENG	d	83.2	2.2051	0.6890000000000001	0.34	0.6254	0.347224180485326	0.129937193591605	0.057344387669769	0.017515842688136
15	15	Spain	ESP	b	89.13	2.6874	0.4467	0.0665	0.3433	0.12388940223764099	0.08391148816431901	0.049498243025725	0.024889387616931
16	16	France	FRA	e	86.13	2.4862	0.6189	0.531	0.7965	0.450210150196081	0.24391221865023602	0.093303063215531	0.039210580867639
17	17	Germany	GER	g	88.88	3.194	0.7751	0.6714	0.88	0.6829572100422511	0.44795477032740205	0.200658538568837	0.11181845303981901
18	18	Ghana	GHA	g	77.22	1.9080000000000001	0.9282	0.0886	0.3159	0.15436110862531302	0.052745572285596995	0.016893030669476002	0.003512161757027
19	19	Greece	GRE	c	76.79	1.3365	0.5396	0.1366	0.3928	0.157587441181275	0.045820067373437995	0.014714531503237	0.002905194853383
20	20	Honduras	HON	e	69.6	1.5609	1.162	0.0626	0.1996	0.049068021518944	0.014385111147681002	0.003250616693303	0.00046355088868300004
21	21	Iran	IRN	f	70.63	1.2971	0.8882	0.0378	0.1878	0.05761711462904599	0.015660930761356	0.0026713413293630002	0.00047552473797800006
22	22	Italy	ITA	d	79.51	1.9842	0.8202	0.2033	0.4555	0.21777290433253602	0.06310621307171099	0.023482905916919	0.005938870936489001
23	23	Japan	JPN	c	73.48	2.1293	1.3485	0.1052	0.2984	0.10581478705745301	0.026264897254865003	0.007207944991191999	0.001167811974438
24	24	South Korea	KOR	h	72.41	1.69	1.0862	0.145	0.3941	0.105703392619309	0.029660670742175	0.006032788844164001	0.001065607738595
25	25	Mexico	MEX	a	76.93	1.5518	0.6892	0.0278	0.5899	0.201970033872541	0.08372299320967799	0.027244123384172994	0.004880469710752
26	26	Netherlands	NED	b	82.5	2.3138	0.8173	0.574	0.9063	0.40152573078853704	0.21277277589759902	0.09171181186359599	0.025345096042773997
27	27	Nigeria	NGA	f	75.23	1.6678	0.8866	0.0695	0.3157	0.11663494467901699	0.038704500866015	0.008290675219124001	0.0018809295398459999
28	28	Portugal	POR	g	81.0	2.1386	0.8161	0.151	0.4767	0.26745965442008396	0.109368457694661	0.040900450843571995	0.010725981755746
29	29	Russia	RUS	h	79.01	1.6554	0.6238	0.294	0.6293	0.23337566227343898	0.08586240355498402	0.025503577622019	0.0061902991724790005
30	30	Switzerland	SUI	e	78.09	1.9841	0.9216	0.1693	0.4456	0.160808828157593	0.06441825676899	0.020266456723686998	0.004677910469004001
31	31	Uruguay	URU	d	83.33	2.2379	0.6999	0.3654	0.6548	0.369746287716351	0.14332619143240302	0.064185891324436	0.019904384141462
32	32	USA	USA	g	77.42	2.0473	1.0141	0.089	0.3274	0.16232748941839997	0.05647755914954099	0.018520006834803003	0.003908402057784001

Advanced export

JSON shape: default, array, newline-delimited

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