world-cup-predictions/wc-20140620-175706

4 rows where group = "b" sorted by cup

View and edit SQL

Suggested facets: sixteen, quarter, semi, cup, win

win_group

group

Link rowid country country_id group spi spi_offense spi_defense win_group sixteen quarter semi cup ▼ win
3 Australia AUS b 70.13 1.7862 1.3112 0.0 0.0 0.0 0.0 0.0 0.0
15 Spain ESP b 85.72 2.4782 0.653 0.0 0.0 0.0 0.0 0.0 0.0
7 Chile CHI b 87.77 2.7346 0.6173 0.4 1.0 0.44436071430237895 0.293034407765183 0.158846734523431 0.070287490757
26 Netherlands NED b 86.13 2.7973 0.8149 0.6 1.0 0.49401392366111607 0.32178839582544 0.16401886295576998 0.062846972493163

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "world-cup-predictions/wc-20140620-175706" (
"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 21.353ms