world-cup-predictions/wc-20140622-235721

4 rows where group = "d" sorted by quarter

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.41 2.1295 0.7794 0.0 0.0 0.0 0.0 0.0 0.0
31 Uruguay URU d 81.49 2.2409 0.8485 0.0593 0.415 0.168442582321392 0.043542308992254995 0.01672228970847 0.005905241722939999
22 Italy ITA d 79.23 1.9415 0.8109 0.0587 0.585 0.202336845132142 0.042522904242662 0.014087461376772 0.004371558998233
11 Costa Rica CRC d 78.52 1.5889 0.6109 0.882 1.0 0.467247707722724 0.155415624236794 0.05399231936858401 0.011904578784718001

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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