world-cup-predictions/wc-20140629-225940

4 rows where group = "h" sorted by win_group

descending

Link	rowid	country	country_id	group	spi	spi_offense	spi_defense	win_group ▼	sixteen	quarter	semi	cup	win
1	1	Algeria	ALG	h	74.96	2.0782	1.2191	0	1	0.17450573305892497	0.049331154021298	0.004967118245624001	0.001168368233128
24	24	South Korea	KOR	h	64.79	1.5064	1.4285	0	0	0.0	0.0	0.0	0.0
29	29	Russia	RUS	h	76.4	1.4348	0.6451	0	0	0.0	0.0	0.0	0.0
4	4	Belgium	BEL	h	83.04	2.0537	0.607	1	1	0.5884185326784179	0.197178373764613	0.082236536598584	0.01866371468384

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