world-cup-predictions/wc-20140620-175706

4 rows where group = "e" sorted by win

descending

Link	rowid	country	country_id	group	spi	spi_offense	spi_defense	win_group	sixteen	quarter	semi	cup	win ▼
20	20	Honduras	HON	e	68.14	1.506	1.2117	0.006	0.0672	0.011635235553049999	0.0034137551627070003	0.0008286649792350001	0.000105957304965
13	13	Ecuador	ECU	e	79.93	1.9872	0.7934	0.0365	0.2089	0.068355499565024	0.030453448411651002	0.011559482647284	0.00293541632814
30	30	Switzerland	SUI	e	79.55	2.0841	0.8886	0.2767	0.8069	0.29438772222527	0.12105681543262599	0.04112396530264	0.010802845164376998
16	16	France	FRA	e	86.89	2.5361	0.5808	0.6808	0.917	0.5560645685915151	0.284882826031245	0.115400707298756	0.05286387326794099

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
);