world-cup-predictions/wc-20140617-091836

4 rows where group = "g"

View and edit SQL

group

Link rowid country country_id group spi spi_offense spi_defense win_group sixteen quarter semi cup win
17 Germany GER g 90.09 3.2869 0.6908 0.8802 0.9836 0.7946925294403221 0.54886610051546 0.248877532827742 0.15245874088623498
18 Ghana GHA g 76.4 1.849 0.9419 0.0053 0.1097 0.051151950034122 0.014663478379021003 0.005013448399902001 0.000881000671053
28 Portugal POR g 78.86 2.0356 0.9034 0.01 0.2343 0.11926536208652601 0.038808141626959995 0.015007474741001002 0.003034035510272
32 USA USA g 78.43 2.0989 0.9785 0.1045 0.6724 0.34231372778942304 0.11310791429200999 0.039528646484813995 0.008094615025864

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