world-cup-predictions/wc-20140626-180150

4 rows where group = "h"

View and edit SQL

Suggested facets: win_group

group

Link rowid country country_id group spi spi_offense spi_defense win_group sixteen quarter semi cup win
1 Algeria ALG h 74.34 2.0441 1.2336 0.0355 0.6293 0.13082048120270098 0.038845541900482 0.006649939095973001 0.001722958825806
4 Belgium BEL h 83.12 2.1376 0.6547 0.9645 1.0 0.564153886672896 0.205345152396897 0.09918464239898199 0.027647579736209
24 South Korea KOR h 64.88 1.6581 1.5493 0.0 0.0073 0.00073001259109 0.00013512252081099998 1.1113726472e-05 1.8484745409999998e-06
29 Russia RUS h 76.98 1.464 0.6271 0.0 0.3634 0.079148829371719 0.025894299435286 0.004453016588217 0.0013394547408900003

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