world-cup-predictions/wc-20140625-180355

2 rows where group = "h" and win_group = "0.0" sorted by group

descending

Link	rowid	country	country_id	group ▼	spi	spi_offense	spi_defense	win_group	sixteen	quarter	semi	cup	win
24	24	South Korea	KOR	h	64.85	1.6567	1.551	0.0	0.0082	0.000996769198589	0.00018189467219	1.4912083186e-05	2.5210672569999996e-06
29	29	Russia	RUS	h	76.95	1.4615	0.6284	0.0	0.3637	0.09231143478667998	0.029662855048925	0.005084279719995999	0.0015531709429329997

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