world-cup-predictions/wc-20140620-175706

4 rows where group = "d" sorted by cup

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
14 England ENG d 81.52 2.1296 0.7722 0.0 0.0 0.0 0.0 0.0 0.0
31 Uruguay URU d 81.42 2.231 0.8484 0.0596 0.3916 0.159247302998357 0.041556897552906 0.016157161354577 0.005560221524622
22 Italy ITA d 80.06 2.0297 0.813 0.0627 0.6084 0.219303080240191 0.04846544344107401 0.017122653411957 0.005486093908576999
11 Costa Rica CRC d 77.52 1.5984 0.6861 0.8777 1.0 0.45324521510871 0.14485268259300801 0.046959530031219006 0.009867884554179002

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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