world-cup-predictions/wc-20140626-180150

4 rows where group = "e"

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
13 Ecuador ECU e 80.22 1.8419 0.6747 0.0 0.0 0.0 0.0 0.0 0.0
16 France FRA e 87.68 2.6496 0.5759 1.0 1.0 0.7241824165320792 0.36560925820361895 0.12935266540053 0.068547533100018
20 Honduras HON e 65.81 1.4244 1.2921 0.0 0.0 0.0 0.0 0.0 0.0
30 Switzerland SUI e 79.87 2.2727 0.9986 0.0 1.0 0.250000869998355 0.12031437978420699 0.052707787188047 0.012292188281926

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 22.345ms