world-cup-predictions/wc-20140710-164509

4 rows where group = "d" sorted by group

descending

Link	rowid	country	country_id	group ▼	spi	spi_offense	spi_defense	win_group	sixteen	quarter
11	11	Costa Rica	CRC	d	78.41	1.4314	0.5085	1	1	1
14	14	England	ENG	d	81.04	2.0514	0.7581	0	0	0
22	22	Italy	ITA	d	78.42	1.8216	0.7891	0	0	0
31	31	Uruguay	URU	d	80.82	2.102	0.8095	0	1	0

Advanced export

JSON shape: default, array, newline-delimited

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