world-cup-predictions/wc-20140622-091255

4 rows where group = "a" sorted by sixteen

View and edit SQL

win_group

group

Link rowid country country_id group spi spi_offense spi_defense win_group sixteen ▼ quarter semi cup win
9 Cameroon CMR a 69.29 1.4838 1.1217 0.0 0.0 0.0 0.0 0.0 0.0
12 Croatia CRO a 79.49 2.0251 0.8508 0.0399 0.3903 0.12611717848929999 0.06326071921773001 0.023146241794 0.0053757790403570005
25 Mexico MEX a 78.43 1.4776 0.5368 0.0469 0.617 0.18323695767892997 0.08641199438745098 0.02924380262186 0.006205733813293
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

CSV options:

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
);
Powered by Datasette · Query took 36.508ms