world-cup-predictions/wc-20140622-235721

4 rows where group = "e" sorted by group

descending

Link	rowid	country	country_id	group ▼	spi	spi_offense	spi_defense	win_group	sixteen	quarter	semi	cup	win
13	13	Ecuador	ECU	e	79.96	1.9882	0.7909999999999999	0.004	0.3817	0.116818702034929	0.054680919287623996	0.022638974029945	0.005452737062725
16	16	France	FRA	e	87.81	2.7464	0.6204	0.9958	0.9999	0.723170665338056	0.388481442603796	0.150376355812594	0.080984726890582
20	20	Honduras	HON	e	68.3	1.5104	1.2044	0.0	0.0194	0.003377192781918	0.001004634876889	0.000263510059423	3.2393988118e-05
30	30	Switzerland	SUI	e	78.26	2.1701	1.0416	0.0002	0.599	0.169239158817287	0.075619400704539	0.029829137234777002	0.006538869634991999

Advanced export

JSON shape: default, array, newline-delimited

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