world-cup-predictions/wc-20140623-220333

4 rows where group = "g" sorted by country

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
17 Germany GER g 88.74 3.1773 0.7828 0.8631 0.9972 0.777012913096136 0.466395277947485 0.207825363658416 0.12296294293647198
18 Ghana GHA g 78.98 1.9887 0.8644 0.0 0.2052 0.087246893860638 0.029710371957821 0.012610760106253999 0.002796400740812
28 Portugal POR g 78.88 2.0901 0.9426 0.0 0.0506 0.021580937002348997 0.007462311317862 0.003196972757545 0.000714078271133
32 USA USA g 78.74 2.1609 1.0022 0.1369 0.747 0.33806532939604306 0.116877131581675 0.043818439605138 0.010337861039941

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "world-cup-predictions/wc-20140623-220333" (
"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 28.0ms