world-cup-predictions/wc-20140620-175706

32 rows sorted by cup

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.13	1.7862	1.3112	0.0	0.0	0.0	0.0	0.0	0.0
9	9	Cameroon	CMR	a	69.44	1.4899	1.1181	0.0	0.0	0.0	0.0	0.0	0.0
14	14	England	ENG	d	81.52	2.1296	0.7722	0.0	0.0	0.0	0.0	0.0	0.0
15	15	Spain	ESP	b	85.72	2.4782	0.653	0.0	0.0	0.0	0.0	0.0	0.0
1	1	Algeria	ALG	h	64.25	1.1759	1.1674	0.0232	0.1543	0.022835907167855	0.00476904973308	0.000602637972346	8.7679587371e-05
20	20	Honduras	HON	e	68.14	1.506	1.2117	0.006	0.0672	0.011635235553049999	0.0034137551627070003	0.0008286649792350001	0.000105957304965
23	23	Japan	JPN	c	73.26	1.9584	1.2372	0.0	0.0395	0.016644800542748	0.004520828153212	0.001187025245443	0.000182559298926
21	21	Iran	IRN	f	70.83	1.1912	0.7941	0.023	0.1952	0.052593960205750995	0.012357571717040999	0.00208598523878	0.00040005950373
18	18	Ghana	GHA	g	76.28	1.8448	0.9487	0.0074	0.105	0.047158915296495005	0.013596674956109	0.004613237309204001	0.0009203658808839999
24	24	South Korea	KOR	h	72.53	1.6905	1.0807	0.1249	0.4103	0.09596297673232303	0.025390392562109	0.005196489898874001	0.0009646285409910001
27	27	Nigeria	NGA	f	74.87	1.5464	0.8209	0.0356	0.2789	0.09008878084566198	0.025725508078951003	0.005368811319056	0.001262649390868
19	19	Greece	GRE	c	74.23	1.183	0.5846	0.0	0.2233	0.097054073891253	0.027821489702482997	0.0077226467997649996	0.0013159748674330001
13	13	Ecuador	ECU	e	79.93	1.9872	0.7934	0.0365	0.2089	0.068355499565024	0.030453448411651002	0.011559482647284	0.00293541632814
28	28	Portugal	POR	g	79.07	2.0819	0.9218	0.0087	0.2234	0.111907770973041	0.036955895436088994	0.014610645608030002	0.003390986903728
31	31	Uruguay	URU	d	81.42	2.231	0.8484	0.0596	0.3916	0.159247302998357	0.041556897552906	0.016157161354577	0.005560221524622
22	22	Italy	ITA	d	80.06	2.0297	0.813	0.0627	0.6084	0.219303080240191	0.04846544344107401	0.017122653411957	0.005486093908576999
29	29	Russia	RUS	h	78.34	1.6128	0.6409	0.2091	0.5672	0.18358201110368103	0.063003102207562	0.017739585016368	0.004456106612665999
5	5	Bosnia and Herzegovina	BIH	f	80.59	2.331	0.9799	0.0353	0.5451	0.230277902130814	0.08466073728894001	0.022481683239052003	0.007695674154236
12	12	Croatia	CRO	a	79.63	2.0389	0.8511	0.0377	0.3894	0.127151931937598	0.064963246255238	0.023454511687896	0.005434334595609
25	25	Mexico	MEX	a	78.38	1.4687	0.5347	0.0452	0.6166	0.18295244729516197	0.087119179724082	0.028767746772281	0.006024091855846
32	32	USA	USA	g	78.44	2.1002	0.9802	0.1175	0.6919	0.3436066842758089	0.113713854063873	0.040346925272739	0.009312155588988
30	30	Switzerland	SUI	e	79.55	2.0841	0.8886	0.2767	0.8069	0.29438772222527	0.12105681543262599	0.04112396530264	0.010802845164376998
11	11	Costa Rica	CRC	d	77.52	1.5984	0.6861	0.8777	1.0	0.45324521510871	0.14485268259300801	0.046959530031219006	0.009867884554179002
8	8	Ivory Coast	CIV	c	79.49	2.2615	1.0159	0.0108	0.7372	0.4006169234014779	0.149401721258041	0.05500548455523599	0.013142660705766
4	4	Belgium	BEL	h	81.82	2.1461	0.7596	0.6428	0.8682	0.41287535507201095	0.15862981312280403	0.06526115970912201	0.018441197075277003
10	10	Colombia	COL	c	87.5	2.4207	0.4508	0.9892	1.0	0.6538886038173339	0.21171215526762802	0.106617842780913	0.05379390891246799
16	16	France	FRA	e	86.89	2.5361	0.5808	0.6808	0.917	0.5560645685915151	0.284882826031245	0.115400707298756	0.05286387326794099
7	7	Chile	CHI	b	87.77	2.7346	0.6173	0.4	1.0	0.44436071430237895	0.293034407765183	0.158846734523431	0.070287490757
26	26	Netherlands	NED	b	86.13	2.7973	0.8149	0.6	1.0	0.49401392366111607	0.32178839582544	0.16401886295576998	0.062846972493163
17	17	Germany	GER	g	89.41	3.2374	0.7435	0.8664	0.9797	0.782070379378853	0.524242307058875	0.24707708328226605	0.14644758805849803
2	2	Argentina	ARG	f	89.91	2.8255	0.4452	0.9061	0.9808	0.69659633088281	0.497148248736334	0.320315610539402	0.149828002006455
6	6	Brazil	BRA	a	91.09	3.1914	0.5169	0.9171	0.994	0.7515209828037309	0.604763552461688	0.45952712524834	0.35614262115729795

Advanced export

JSON shape: default, array, newline-delimited

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