world-cup-predictions/wc-20140619-180248

4 rows where group = "f" sorted by spi_offense

descending

Link	rowid	country	country_id	group	spi	spi_offense ▼	spi_defense	win_group	sixteen	quarter	semi	cup	win
21	21	Iran	IRN	f	70.82	1.1909	0.7937	0.0203	0.1942	0.05188773969651401	0.012017366560864	0.001979845400079	0.00038277103352800005
27	27	Nigeria	NGA	f	74.86	1.548	0.8220000000000001	0.0354	0.2671	0.087161106153095	0.024914596419859	0.00514089879352	0.001209250443553
5	5	Bosnia and Herzegovina	BIH	f	80.62	2.3309	0.9766	0.0424	0.5563	0.23638342105420398	0.08737784933785099	0.023416650051767	0.007958896088182
2	2	Argentina	ARG	f	89.89	2.8248	0.4457	0.9019	0.9824	0.6966222944581071	0.496672680486628	0.31859067521478696	0.148768716520945

Advanced export

JSON shape: default, array, newline-delimited

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