world-cup-predictions/wc-20140625-091929

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	74.32	2.0416	1.2344	0.0358	0.6224	0.148461572317145	0.042984803930455	0.007357112949829	0.001957883594863
2	2	Argentina	ARG	f	89.65	2.7396	0.4256	0.8865	1.0	0.722491901536268	0.48897223705565296	0.31263971527347	0.13947364117596303
3	3	Australia	AUS	b	67.52	1.6824	1.4017	0.0	0.0	0.0	0.0	0.0	0.0
4	4	Belgium	BEL	h	83.12	2.134	0.6552	0.9642	1.0	0.53156089321126	0.21946235351072502	0.105918050115718	0.029396590262436
5	5	Bosnia and Herzegovina	BIH	f	79.4	2.19	0.9789	0.0	0.0	0.0	0.0	0.0	0.0
6	6	Brazil	BRA	a	91.27	3.2346	0.521	1.0	1.0	0.7788352855777251	0.6131344427431209	0.467506006272548	0.36807059463035596
7	7	Chile	CHI	b	86.6	2.5703	0.6345	0.0	1.0	0.22116471442239102	0.11445388465744599	0.055470276815465	0.028978421290169996
8	8	Ivory Coast	CIV	c	78.11	2.2383	1.1081	0.0	0.0	0.0	0.0	0.0	0.0
9	9	Cameroon	CMR	a	68.13	1.4479	1.1705	0.0	0.0	0.0	0.0	0.0	0.0
10	10	Colombia	COL	c	88.18	2.5068	0.4405	1.0	1.0	0.6317194704033511	0.19645083433970603	0.10137675230824601	0.056047840774125994
11	11	Costa Rica	CRC	d	78.59	1.5038	0.5506	1.0	1.0	0.5667303385298721	0.19735065645726002	0.06810151698151	0.014168058084376
12	12	Croatia	CRO	a	77.85	2.0359	0.9836	0.0	0.0	0.0	0.0	0.0	0.0
13	13	Ecuador	ECU	e	80.11	1.9817	0.7822	0.0031	0.3816	0.119069538808334	0.054106173907510005	0.023355610858311	0.00542457466489
14	14	England	ENG	d	81.19	2.0524	0.75	0.0	0.0	0.0	0.0	0.0	0.0
15	15	Spain	ESP	b	86.3	2.5034	0.6205	0.0	0.0	0.0	0.0	0.0	0.0
16	16	France	FRA	e	87.8	2.7439999999999998	0.6238	0.9966	0.9998	0.719506557420595	0.39173992701170707	0.14125583715473097	0.077989527000286
17	17	Germany	GER	g	88.62	3.1686	0.7927	0.8525	0.997	0.773819947328885	0.46128926973933704	0.19919774723514103	0.11474397073485301
18	18	Ghana	GHA	g	79.02	1.9875	0.8654	0.0	0.1992	0.085643613613634	0.029273292985237002	0.01216553680286	0.002624087360269
19	19	Greece	GRE	c	74.37	1.1835	0.5811	0.0	1.0	0.433269661470122	0.12495398178020699	0.035763883676903	0.005887533700401
20	20	Honduras	HON	e	68.45	1.5159	1.2065	0.0	0.0223	0.003985506847744001	0.0011375444493	0.000310980059111	3.7145148349e-05
21	21	Iran	IRN	f	70.91	1.1286	0.7440000000000001	0.0	0.1228	0.023588330854041	0.005563106639374001	0.0006942247001219999	0.000164824453086
22	22	Italy	ITA	d	78.54	1.8199	0.7809999999999999	0.0	0.0	0.0	0.0	0.0	0.0
23	23	Japan	JPN	c	72.56	2.0187	1.3374	0.0	0.0	0.0	0.0	0.0	0.0
24	24	South Korea	KOR	h	64.85	1.6567	1.551	0.0	0.0076	0.0009894608243	0.000171140647355	1.4030447067e-05	2.393327773e-06
25	25	Mexico	MEX	a	80.16	1.6322	0.534	0.0	1.0	0.31217149437875896	0.17264691044528196	0.06340915822293	0.014271191027258
26	26	Netherlands	NED	b	87.4	2.8013	0.6993	1.0	1.0	0.6878285056211341	0.505048451317339	0.278617357214773	0.105807485252636
27	27	Nigeria	NGA	f	76.16	1.5231	0.7259	0.1135	0.8772	0.24417098493878	0.077537819857588	0.016760307399622	0.0041799514964379995
28	28	Portugal	POR	g	79.15	2.1062	0.9394	0.0	0.0465	0.020368031774674	0.007105125679891999	0.0030074187810029997	0.0006631332574700001
29	29	Russia	RUS	h	76.95	1.4615	0.6284	0.0	0.37	0.09257744300220198	0.028887864607788	0.004951444624501	0.001541036599196
30	30	Switzerland	SUI	e	78.11	2.1503	1.0465	0.0003	0.5963	0.167187179594208	0.07132027199738099	0.028949355718242996	0.006021083407581999
31	31	Uruguay	URU	d	82.21	2.209	0.7769	0.0	1.0	0.3682805295966621	0.07596083825963901	0.029279305883267	0.012395657529746001
32	32	USA	USA	g	78.85	2.1632	1.0015	0.1475	0.7573	0.34657903792788697	0.12044906798072699	0.043898370504618	0.010153375227495001

Advanced export

JSON shape: default, array, newline-delimited

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