world-cup-predictions/wc-20140617-091836

4 rows where group = "e"

View and edit SQL

group

Link rowid country country_id group spi spi_offense spi_defense win_group sixteen quarter semi cup win
13 Ecuador ECU e 79.85 1.9826 0.7945 0.0335 0.2039 0.067107341534596 0.030311529037726 0.011377399276258 0.0025455469892059998
16 France FRA e 86.93 2.5422 0.5791 0.6886 0.9197 0.5591111183888829 0.276724786480106 0.104860955933899 0.04657664479921799
20 Honduras HON e 68.2 1.5045 1.2049 0.0053 0.0707 0.012094370988995 0.003611506131393 0.000861687049998 9.6284954975e-05
30 Switzerland SUI e 79.35 2.0756 0.8953 0.2726 0.8057 0.290649358596655 0.116159136047688 0.038147318926571 0.008989849527598

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "world-cup-predictions/wc-20140617-091836" (
"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 23.187ms