world-cup-predictions/wc-20140620-175706

4 rows where group = "e" sorted by win

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 ▼
20 Honduras HON e 68.14 1.506 1.2117 0.006 0.0672 0.011635235553049999 0.0034137551627070003 0.0008286649792350001 0.000105957304965
13 Ecuador ECU e 79.93 1.9872 0.7934 0.0365 0.2089 0.068355499565024 0.030453448411651002 0.011559482647284 0.00293541632814
30 Switzerland SUI e 79.55 2.0841 0.8886 0.2767 0.8069 0.29438772222527 0.12105681543262599 0.04112396530264 0.010802845164376998
16 France FRA e 86.89 2.5361 0.5808 0.6808 0.917 0.5560645685915151 0.284882826031245 0.115400707298756 0.05286387326794099

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