world-cup-predictions/wc-20140625-180355

4 rows where group = "d" sorted by country_id

descending

Link	rowid	country	country_id ▼	group	spi	spi_offense	spi_defense	win_group	sixteen	quarter	semi	cup	win
11	11	Costa Rica	CRC	d	78.59	1.5038	0.5506	1.0	1.0	0.5667303385298721	0.19735065645726002	0.065478896732768	0.013690168003456002
14	14	England	ENG	d	81.19	2.0524	0.75	0.0	0.0	0.0	0.0	0.0	0.0
22	22	Italy	ITA	d	78.54	1.8199	0.7809999999999999	0.0	0.0	0.0	0.0	0.0	0.0
31	31	Uruguay	URU	d	82.21	2.209	0.7769	0.0	1.0	0.3682805295966621	0.07596083825963901	0.029672703189684	0.012347323448554999

Advanced export

JSON shape: default, array, newline-delimited

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