world-cup-predictions/wc-20140617-091836

4 rows where group = "h"

View and edit SQL

group

Link rowid country country_id group spi spi_offense spi_defense win_group sixteen quarter semi cup win
1 Algeria ALG h 63.35 1.1178 1.1668 0.0593 0.1967 0.031353687201243 0.005870039959300999 0.0008047678183410001 9.1435486616e-05
4 Belgium BEL h 82.09 2.1425 0.7344 0.4971 0.7777 0.35097574308073803 0.13906867494802203 0.054326875647939005 0.014457777268047
24 South Korea KOR h 72.42 1.6881 1.0845 0.1447 0.3885 0.09247288884401401 0.023780648532222 0.004909493965441001 0.0007914678952599999
29 Russia RUS h 78.86 1.6526 0.6319 0.2989 0.6371 0.21777411152353102 0.073742947078261 0.021873568191321 0.004949967947784

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.934ms