world-cup-predictions/wc-20140626-180150

4 rows where group = "d"

View and edit SQL

Suggested facets: win_group, sixteen, quarter, semi, cup, win

group

Link rowid country country_id group spi spi_offense spi_defense win_group sixteen quarter semi cup win
11 Costa Rica CRC d 78.46 1.4994 0.5545 1.0 1.0 0.563656080705206 0.19517910328294102 0.062167189520556 0.012867903659916
14 England ENG d 81.15 2.0557 0.7531 0.0 0.0 0.0 0.0 0.0 0.0
22 Italy ITA d 78.52 1.818 0.7794 0.0 0.0 0.0 0.0 0.0 0.0
31 Uruguay URU d 82.11 2.1995 0.7766 0.0 1.0 0.366111453558818 0.075152702436533 0.028424684030317005 0.01149794434967

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "world-cup-predictions/wc-20140626-180150" (
"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 28.611ms