world-cup-predictions/wc-20140622-091255

4 rows where group = "c" sorted by sixteen

descending

Link	rowid	country	country_id	group	spi	spi_offense	spi_defense	win_group	sixteen ▼	quarter	semi	cup	win
23	23	Japan	JPN	c	73.36	1.97	1.2383	0.0	0.0382	0.015726924522942	0.004248267155743	0.001151440675256	0.00018060530004400003
19	19	Greece	GRE	c	74.14	1.1789	0.5861	0.0	0.2097	0.08878340402334699	0.025194997958954	0.007161940099923999	0.0012331809403839998
8	8	Ivory Coast	CIV	c	79.49	2.2641	1.0166	0.0144	0.7521	0.400218204548308	0.14893963530499899	0.056121638270891	0.013536842104447
10	10	Colombia	COL	c	87.48	2.4192	0.4511	0.9856	1.0	0.6581812261391851	0.214190688291034	0.10763457203355803	0.054708848533477995

Advanced export

JSON shape: default, array, newline-delimited

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