world-cup-predictions/wc-20140625-180355

4 rows where group = "g" sorted by country_id

descending

Link	rowid	country	country_id ▼	group	spi	spi_offense	spi_defense	win_group	sixteen	quarter	semi	cup	win
17	17	Germany	GER	g	88.62	3.1686	0.7927	0.8501	0.9972	0.7737881655782379	0.46625701523970703	0.200872798004813	0.11476723371539199
18	18	Ghana	GHA	g	79.02	1.9875	0.8654	0.0	0.2028	0.08721389061189	0.027797573102947004	0.011552249990618999	0.002503491756845
28	28	Portugal	POR	g	79.15	2.1062	0.9394	0.0	0.045	0.019675357725675	0.006402858412215999	0.0027101669285739998	0.0006001819572209999
32	32	USA	USA	g	78.85	2.1632	1.0015	0.1499	0.755	0.346038682392769	0.114805388292729	0.041261282105918	0.0096303786185

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