world-cup-predictions/wc-20140619-091907

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	64.3	1.1801	1.1672	0.0213	0.1551	0.02289718137931	0.0048125175522469995	0.000606574822335	8.7761049676e-05
2	2	Argentina	ARG	f	89.89	2.8248	0.4457	0.9077	0.982	0.6980664727656861	0.498308410009224	0.31573291643178003	0.147045175096821
3	3	Australia	AUS	b	70.15	1.7855	1.3089	0.0	0.0	0.0	0.0	0.0	0.0
4	4	Belgium	BEL	h	81.88	2.1496	0.7576	0.645	0.8752	0.415061966177896	0.16001755168267903	0.064443965649051	0.018203871101105
5	5	Bosnia and Herzegovina	BIH	f	80.62	2.3309	0.9766	0.0373	0.5482	0.23076809111597799	0.084929121074034	0.022536861006334997	0.007691923723247
6	6	Brazil	BRA	a	91.09	3.1909	0.516	0.9184	0.9942	0.750983637426015	0.6143701497552719	0.46667625734253004	0.36034362425520705
7	7	Chile	CHI	b	87.82	2.7509	0.6228	0.4083	1.0	0.450714468720522	0.29419187738245894	0.159837742060596	0.070837190600748
8	8	Ivory Coast	CIV	c	79.13	2.2127	1.0084	0.2217	0.7835	0.395110534128104	0.12519647849178	0.044669921029462004	0.011038775455406
9	9	Cameroon	CMR	a	69.44	1.4901	1.1177	0.0	0.0	0.0	0.0	0.0	0.0
10	10	Colombia	COL	c	87.7	2.3934	0.4145	0.7565	0.9624	0.6388828411663061	0.236075172228686	0.12096031147577001	0.056475224299102005
11	11	Costa Rica	CRC	d	77.52	1.5925	0.6815	0.4145	0.7242	0.289290823284294	0.07854423055694901	0.025116179727055002	0.005668932783028
12	12	Croatia	CRO	a	79.64	2.0406	0.8511	0.0379	0.3965	0.128803344625078	0.06211872758957599	0.022327738830618997	0.005163697267239999
13	13	Ecuador	ECU	e	79.95	1.9863	0.7908	0.0349	0.2053	0.066810142787674	0.03001093910261	0.011067811450983999	0.002809467818958
14	14	England	ENG	d	82.23	2.1691	0.7432	0.0854	0.3255	0.148346486245995	0.04236322609261899	0.016869159902312	0.005641615455972
15	15	Spain	ESP	b	85.72	2.478	0.6526	0.0	0.0	0.0	0.0	0.0	0.0
16	16	France	FRA	e	86.9	2.5366	0.5805	0.6872	0.9207	0.5602932895315289	0.286614203459529	0.11555336361731698	0.05263929610102099
17	17	Germany	GER	g	89.42	3.2403	0.7437	0.8636	0.9786	0.78062604724335	0.523398343368317	0.24641683029731304	0.145389856339719
18	18	Ghana	GHA	g	76.29	1.8443	0.9469	0.0075	0.1082	0.048587109114401	0.013978018845738	0.0045957231013319996	0.0009129058135319999
19	19	Greece	GRE	c	74.26	1.2973	0.6702	0.0099	0.1466	0.059911277294605	0.016677296395938002	0.004638655208063	0.000800020753152
20	20	Honduras	HON	e	68.18	1.5087	1.2107	0.0043	0.0666	0.011137790868098999	0.0032736698464509995	0.0007612538293449999	9.744236313100001e-05
21	21	Iran	IRN	f	70.82	1.1909	0.7937	0.0218	0.2058	0.054616293108937994	0.012678688727279	0.002090088932781	0.000402124669716
22	22	Italy	ITA	d	80.15	2.0347	0.8101	0.4454	0.7418	0.33547716527390803	0.105893280261314	0.038707828409129	0.010116356730368
23	23	Japan	JPN	c	73.09	2.068	1.3316	0.0119	0.1075	0.04205620101042	0.010617361648174001	0.002745452462651	0.000428775512745
24	24	South Korea	KOR	h	72.49	1.6878	1.0807	0.1343	0.411	0.09721105700744699	0.025480515475722998	0.005150478983421	0.000947856737684
25	25	Mexico	MEX	a	78.41	1.4717	0.5341	0.0437	0.6093	0.180352364487865	0.08080080061455701	0.026710405349487	0.005590470898629001
26	26	Netherlands	NED	b	86.15	2.7997	0.8136	0.5917	1.0	0.489146184740499	0.30825427636951397	0.15702078142341	0.060433922502395
27	27	Nigeria	NGA	f	74.86	1.548	0.8220000000000001	0.0332	0.264	0.08542378187149001	0.024248043480689	0.0050033637332690005	0.001170790258106
28	28	Portugal	POR	g	79.1	2.0823	0.9194	0.0107	0.23	0.11443337536179699	0.03763816765555	0.014455605538406	0.0033571382449919997
29	29	Russia	RUS	h	78.33	1.6132	0.6413	0.1994	0.5587	0.18065639460134902	0.06166567502845299	0.016923101805247	0.0042556324412620005
30	30	Switzerland	SUI	e	79.54	2.0858	0.8897	0.2736	0.8074	0.29288413795058305	0.120339613759888	0.040063792553876994	0.010492229342433
31	31	Uruguay	URU	d	80.9	2.1952	0.8632	0.0547	0.2085	0.090924671596358	0.024897122613203	0.009504629888786	0.0030025784417640005
32	32	USA	USA	g	78.46	2.1014	0.9798	0.1182	0.6832	0.340526869114531	0.112606520931546	0.038813205137332	0.008955343942840999

Advanced export

JSON shape: default, array, newline-delimited

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