world-cup-predictions/wc-20140625-180355

4 rows where group = "h" sorted by spi

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
24 South Korea KOR h 64.85 1.6567 1.551 0.0 0.0082 0.000996769198589 0.00018189467219 1.4912083186e-05 2.5210672569999996e-06
1 Algeria ALG h 74.32 2.0416 1.2344 0.0382 0.6281 0.14941706744821098 0.044133505484483 0.007503462380132 0.001979343205008
29 Russia RUS h 76.95 1.4615 0.6284 0.0 0.3637 0.09231143478667998 0.029662855048925 0.005084279719995999 0.0015531709429329997
4 Belgium BEL h 83.12 2.134 0.6552 0.9618 1.0 0.530558632257932 0.206879439845749 0.09964595354124699 0.027786971705595003

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "world-cup-predictions/wc-20140625-180355" (
"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.239ms