world-cup-predictions/wc-20140615-180820

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.36	1.1191	1.1659	0.0579	0.1952	0.036424351061179	0.007688083870116999	0.000967940717098	0.00012199650442799998
2	2	Argentina	ARG	f	90.0	2.8521	0.4498	0.7378	0.9231	0.669153690629989	0.467292392203027	0.286948436964425	0.132452016586516
3	3	Australia	AUS	b	69.04	1.6546	1.2727	0.0014	0.0188	0.001502132461494	0.000418420190164	9.813162268100001e-05	1.4951622330999999e-05
4	4	Belgium	BEL	h	82.06	2.1405	0.7355	0.494	0.7702	0.35398084149785103	0.15070395681582802	0.056957054477554	0.016005868555175
5	5	Bosnia and Herzegovina	BIH	f	80.23	2.3098	0.9905	0.1563	0.5714	0.27072813174750304	0.11390081529067698	0.032274104408168004	0.009366052204904
6	6	Brazil	BRA	a	91.63	3.3847	0.5572	0.9649	0.9985	0.7909921292326378	0.662648723237825	0.535476505970793	0.4293919820454051
7	7	Chile	CHI	b	86.79	2.7203	0.7033	0.3089	0.7775	0.32517361030001696	0.20564290993294299	0.11069674968555801	0.044253875021353
8	8	Ivory Coast	CIV	c	79.17	2.2141	1.0043	0.223	0.7856	0.396564882481183	0.12667741025675802	0.047280661787377	0.011073432141097
9	9	Cameroon	CMR	a	70.05	1.3531	0.9672	0.0005	0.0298	0.0059167607399	0.002030898321476	0.00050165328915	6.601124729999999e-05
10	10	Colombia	COL	c	87.69	2.3949	0.4158	0.7583	0.9634	0.639789688891305	0.21912853950966102	0.11844176260523699	0.0548567708995
11	11	Costa Rica	CRC	d	77.48	1.5852	0.6767	0.4086	0.7207	0.28570992191835	0.07687720348953599	0.025730341431614	0.005516542951911
12	12	Croatia	CRO	a	76.22	1.8052	0.9215	0.0024	0.369	0.10030995231990701	0.0430733997738	0.013852461825283002	0.002455447825178
13	13	Ecuador	ECU	e	80.8	2.0274	0.7549	0.0652	0.2608	0.10069729502680098	0.046322113969542	0.016973577804599	0.004362080146484999
14	14	England	ENG	d	82.21	2.1617	0.7381	0.0878	0.3271	0.14868249793796098	0.040202561241898	0.016992790784497	0.005524393194063001
15	15	Spain	ESP	b	86.78	2.6112	0.6368	0.0262	0.2454	0.06664887448261	0.03947419375794001	0.021011159056281998	0.009582440515954001
16	16	France	FRA	e	86.13	2.4866	0.6193	0.5314	0.7922	0.449212657839562	0.242839747796284	0.091540208359797	0.038233900902204
17	17	Germany	GER	g	88.87	3.1972	0.7786	0.6787	0.8802	0.683404028823731	0.451317131423418	0.20090516412446902	0.11109809187912598
18	18	Ghana	GHA	g	77.38	1.9044	0.9135	0.0816	0.3018	0.14859687808906197	0.05105417713117201	0.015596910942501001	0.003310390848815
19	19	Greece	GRE	c	74.29	1.2891	0.6597	0.0083	0.1502	0.061322198355181004	0.017558966033765	0.005117412276015001	0.0008303044895650001
20	20	Honduras	HON	e	70.01	1.5756	1.1482	0.0549	0.1848	0.045816356116653	0.013458570307540002	0.002951913875717	0.000430151355833
21	21	Iran	IRN	f	70.6	1.2971	0.8897	0.0345	0.1929	0.059689398843650994	0.016234538670981	0.0025638858085879996	0.00046172922947800005
22	22	Italy	ITA	d	80.14	2.036	0.8097	0.4459	0.7385	0.334496436088353	0.10502096966347599	0.040179384711787995	0.009978772877724001
23	23	Japan	JPN	c	73.13	2.0751	1.3309	0.0104	0.1008	0.039641256080509	0.010286802933411998	0.002769566700282	0.000408562163335
24	24	South Korea	KOR	h	72.42	1.6883	1.0835	0.1431	0.3966	0.10396660712500999	0.029566665341363995	0.005646879534984	0.001004713517251
25	25	Mexico	MEX	a	77.77	1.5407	0.6249	0.0322	0.6027	0.174543629923365	0.076994412010963	0.025790269987319	0.00492105493235
26	26	Netherlands	NED	b	86.92	2.8119	0.747	0.6635	0.9583	0.53491291054009	0.349869734758104	0.19037104847514602	0.071277713224981
27	27	Nigeria	NGA	f	75.07	1.6598	0.8902	0.0714	0.3126	0.11735989567325501	0.038948328996699	0.008048709304947	0.0017935287350929999
28	28	Portugal	POR	g	80.99	2.1415	0.8184	0.148	0.4785	0.266863465738583	0.109921489140741	0.039100858787321995	0.010385546391939001
29	29	Russia	RUS	h	78.98	1.6544	0.625	0.305	0.638	0.23666097320387602	0.087296861700774	0.024848188953014997	0.006036021482872
30	30	Switzerland	SUI	e	78.03	1.9791	0.9216	0.3485	0.7622	0.287342574122598	0.113168414197827	0.031614075193615004	0.007625838605459999
31	31	Uruguay	URU	d	80.89	2.194	0.8617	0.0577	0.2137	0.093793118247137	0.024094854888292997	0.009821768968795	0.003035806838738
32	32	USA	USA	g	77.76	2.0627	1.0004	0.0917	0.3395	0.17010285446074097	0.060286713144002	0.018930421565380003	0.004124011063638

Advanced export

JSON shape: default, array, newline-delimited

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