world-cup-predictions/wc-20140620-175706

4 rows where group = "h" sorted by win

descending

Link	rowid	country	country_id	group	spi	spi_offense	spi_defense	win_group	sixteen	quarter	semi	cup	win ▼
1	1	Algeria	ALG	h	64.25	1.1759	1.1674	0.0232	0.1543	0.022835907167855	0.00476904973308	0.000602637972346	8.7679587371e-05
24	24	South Korea	KOR	h	72.53	1.6905	1.0807	0.1249	0.4103	0.09596297673232303	0.025390392562109	0.005196489898874001	0.0009646285409910001
29	29	Russia	RUS	h	78.34	1.6128	0.6409	0.2091	0.5672	0.18358201110368103	0.063003102207562	0.017739585016368	0.004456106612665999
4	4	Belgium	BEL	h	81.82	2.1461	0.7596	0.6428	0.8682	0.41287535507201095	0.15862981312280403	0.06526115970912201	0.018441197075277003

Advanced export

JSON shape: default, array, newline-delimited

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