world-cup-predictions/wc-20140622-235721

4 rows where group = "h" sorted by quarter

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	72.56	1.6908	1.0781	0.0	0.0208	0.003936992979788	0.001003424561725	0.000143025658397	3.5220462707e-05
1	1	Algeria	ALG	h	64.24	1.1759	1.1673	0.0371	0.4605	0.06736675099453299	0.012486139961757	0.0014877055389839998	0.000230418601247
29	29	Russia	RUS	h	78.29	1.6109	0.6422	0.0	0.5187	0.138887600472553	0.046181961609447	0.009441361020152	0.003008947454078
4	4	Belgium	BEL	h	81.79	2.1428	0.759	0.9629	1.0	0.516714413251126	0.20116703803936198	0.089710835061231	0.024110177563804

Advanced export

JSON shape: default, array, newline-delimited

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