world-cup-predictions/wc-20140629-225940

4 rows where group = "a" sorted by win_group

descending

Link	rowid	country	country_id	group	spi	spi_offense	spi_defense	win_group ▼	sixteen	quarter	semi	cup	win
9	9	Cameroon	CMR	a	68.12	1.4612	1.1840000000000002	0	0	0.0	0.0	0.0	0.0
12	12	Croatia	CRO	a	77.86	2.0413	0.9876	0	0	0.0	0.0	0.0	0.0
25	25	Mexico	MEX	a	80.03	1.621	0.5351	0	1	0.0	0.0	0.0	0.0
6	6	Brazil	BRA	a	90.61	3.0717	0.5063	1	1	1.0	0.715980738515893	0.5406567265416561	0.40984323824520097

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