world-cup-predictions/wc-20140629-225940

4 rows where group = "f" sorted by win_group descending

descending

Link	rowid	country	country_id	group	spi	spi_offense	spi_defense	win_group ▲	sixteen	quarter	semi	cup	win
2	2	Argentina	ARG	f	89.97	2.9269	0.498	1	1	0.7777060693576171	0.589400239690089	0.381476782574728	0.164163630603246
5	5	Bosnia and Herzegovina	BIH	f	80.42	2.2764	0.9622	0	0	0.0	0.0	0.0	0.0
21	21	Iran	IRN	f	69.42	1.1062	0.8143	0	0	0.0	0.0	0.0	0.0
27	27	Nigeria	NGA	f	77.12	1.6969	0.7906	0	1	0.24253547085823	0.061192116585356	0.007065955468055999	0.0018133927226020002

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE "world-cup-predictions/wc-20140629-225940" (
"country" TEXT,
  "country_id" TEXT,
  "group" TEXT,
  "spi" REAL,
  "spi_offense" REAL,
  "spi_defense" REAL,
  "win_group" INTEGER,
  "sixteen" INTEGER,
  "quarter" REAL,
  "semi" REAL,
  "cup" REAL,
  "win" REAL
);