world-cup-predictions/wc-20140619-180248

4 rows where group = "e" sorted by spi_defense

View and edit SQL

group

Link rowid country country_id group spi spi_offense spi_defense ▼ win_group sixteen quarter semi cup win
16 France FRA e 86.9 2.5366 0.5805 0.6772 0.913 0.550652069620778 0.28151342648209604 0.113470529409973 0.052051525302287
13 Ecuador ECU e 79.95 1.9863 0.7908 0.0351 0.2056 0.068099068504734 0.030496789113497003 0.011550460215982002 0.0029203857442950004
30 Switzerland SUI e 79.54 2.0858 0.8897 0.2834 0.8128 0.297613214964213 0.121955026575763 0.041026133807567 0.010774950763881002
20 Honduras HON e 68.18 1.5087 1.2107 0.0043 0.0686 0.011581085548336001 0.003521110713441 0.0008478512123589999 0.00010725287036299998

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "world-cup-predictions/wc-20140619-180248" (
"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 24.884ms