world-cup-predictions/wc-20140622-091255

4 rows where group = "a" sorted by sixteen

descending

Link	rowid	country	country_id	group	spi	spi_offense	spi_defense	win_group	sixteen ▼	quarter	semi	cup	win
9	9	Cameroon	CMR	a	69.29	1.4838	1.1217	0.0	0.0	0.0	0.0	0.0	0.0
12	12	Croatia	CRO	a	79.49	2.0251	0.8508	0.0399	0.3903	0.12611717848929999	0.06326071921773001	0.023146241794	0.0053757790403570005
25	25	Mexico	MEX	a	78.43	1.4776	0.5368	0.0469	0.617	0.18323695767892997	0.08641199438745098	0.02924380262186	0.006205733813293
6	6	Brazil	BRA	a	91.07	3.1860000000000004	0.5158	0.9132	0.9927	0.7493369644151979	0.6029990064505749	0.458843244389478	0.35718675433178904

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