world-cup-predictions/wc-20140617-235154

32 rows sorted by semi

descending

Link	rowid	country	country_id	group	spi	spi_offense	spi_defense	win_group	sixteen	quarter	semi ▼	cup	win
3	3	Australia	AUS	b	69.13	1.6537	1.2677	0.001	0.0173	0.001449205083239	0.00039637670661700003	7.6517564387e-05	1.1283605282e-05
9	9	Cameroon	CMR	a	70.12	1.3559999999999999	0.9670000000000001	0.0024	0.0113	0.0022592730205420004	0.000758713836702	0.000177122756153	2.5392448075999996e-05
20	20	Honduras	HON	e	68.2	1.5045	1.2049	0.0062	0.0692	0.011858391305094	0.0033887017178149998	0.0007900590592239999	8.9961239214e-05
1	1	Algeria	ALG	h	63.35	1.1178	1.1668	0.0199	0.1464	0.019456804399171003	0.0038580734450740007	0.0004411096269740001	5.7627244668e-05
23	23	Japan	JPN	c	73.13	2.073	1.3309	0.0112	0.1044	0.04106968972813299	0.010416074760619	0.0026753350270349997	0.00037281480563899997
21	21	Iran	IRN	f	70.83	1.1909	0.7921	0.022	0.1915	0.051561355813633	0.011295545834824	0.00178089171704	0.000321944841931
18	18	Ghana	GHA	g	76.4	1.849	0.9419	0.0052	0.1038	0.04640362383445299	0.013323382934131	0.004466937473535999	0.0007932665845989999
19	19	Greece	GRE	c	74.21	1.2976	0.672	0.0082	0.1416	0.057992299372482	0.016227396494636004	0.004498694272851	0.0006916459680650001
12	12	Croatia	CRO	a	76.38	1.8123	0.9164	0.0143	0.1922	0.052868927484972995	0.022513793542897998	0.006945270960729	0.0011800815164719999
24	24	South Korea	KOR	h	72.42	1.6881	1.0845	0.1225	0.4028	0.089962151805625	0.023617762138257004	0.0046119991804	0.000776845024106
27	27	Nigeria	NGA	f	74.89	1.5476	0.8186	0.0336	0.2792	0.09026592353546198	0.024162100056541	0.004677923340174	0.001049051550102
31	31	Uruguay	URU	d	80.88	2.1937	0.8626	0.0584	0.2156	0.094688441425265	0.024646125294709997	0.009255661062548999	0.00273928731271
13	13	Ecuador	ECU	e	79.85	1.9826	0.7945	0.034	0.206	0.066871356348045	0.029462159882102996	0.010903301190379	0.002472045824491
28	28	Portugal	POR	g	78.86	2.0356	0.9034	0.009	0.2224	0.10873193304486099	0.03529837723821799	0.013489160640286999	0.0027497502476149997
14	14	England	ENG	d	82.21	2.1664	0.7412	0.082	0.3206	0.14451838968660402	0.039072978897956	0.015256470205756	0.004801762389458
15	15	Spain	ESP	b	86.77	2.6136	0.6381	0.0258	0.2444	0.06898069145766901	0.040909265739596995	0.020088765100509	0.008878639944985
29	29	Russia	RUS	h	78.86	1.6526	0.6319	0.2185	0.5832	0.187902684519332	0.065393778317047	0.018174121503509	0.00431284635072
11	11	Costa Rica	CRC	d	77.45	1.5906	0.6828	0.4073	0.7152	0.285934936793189	0.07653576563146201	0.024187888070948998	0.004934916001466
5	5	Bosnia and Herzegovina	BIH	f	80.57	2.326	0.9764	0.0371	0.5455	0.22969214605342803	0.079770161356694	0.019745509772951	0.006490033411676999
25	25	Mexico	MEX	a	77.57	1.5338	0.6336	0.0463	0.8002	0.229276905243071	0.100658616720836	0.032254235624392995	0.005796607992615
22	22	Italy	ITA	d	80.19	2.0385	0.8083	0.4523	0.7486	0.34020445194056304	0.10646474559931401	0.038761930298013	0.009239670959644002
32	32	USA	USA	g	78.43	2.0989	0.9785	0.1056	0.6891	0.33872219993238695	0.111495925164214	0.038654579785077005	0.007972532290712
30	30	Switzerland	SUI	e	79.35	2.0756	0.8953	0.2701	0.8053	0.29078177860528304	0.115498563238548	0.037679221669598	0.008922698466158
8	8	Ivory Coast	CIV	c	79.15	2.2139	1.0064	0.2233	0.7961	0.401562657818698	0.12763628028913301	0.045423107854717	0.010144812486952
4	4	Belgium	BEL	h	82.09	2.1425	0.7344	0.6391	0.8676	0.410813837768897	0.15943573847898998	0.06463298514011301	0.016781018344888002
7	7	Chile	CHI	b	86.83	2.7238	0.7007	0.3102	0.7779	0.32658361975637895	0.206951114199511	0.106457582173094	0.041492410678287
10	10	Colombia	COL	c	87.63	2.3896	0.4174	0.7573	0.9579	0.634029133235105	0.21871801264668397	0.10917437855307002	0.049054706790559004
16	16	France	FRA	e	86.93	2.5422	0.5791	0.6897	0.9195	0.559224099039604	0.2753931613413789	0.10540689006336301	0.046526256432293
26	26	Netherlands	NED	b	86.88	2.8083	0.7476	0.663	0.9604	0.530100079301954	0.34615002871267603	0.181824595298952	0.066078886359195
2	2	Argentina	ARG	f	89.87	2.8242	0.4467	0.9073	0.9838	0.699744949299442	0.49674666257399996	0.314562818164205	0.135568246976336
17	17	Germany	GER	g	90.09	3.2869	0.6908	0.8802	0.9847	0.7980067646951892	0.551859906282169	0.253109760107228	0.15377012364040102
6	6	Brazil	BRA	a	91.6	3.3842	0.5578	0.937	0.9963	0.788481298652098	0.6619447109266651	0.509815176742791	0.405902832270686

Advanced export

JSON shape: default, array, newline-delimited

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