world-cup-predictions/wc-20140622-235721

4 rows where group = "h" sorted by rowid

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
1 Algeria ALG h 64.24 1.1759 1.1673 0.0371 0.4605 0.06736675099453299 0.012486139961757 0.0014877055389839998 0.000230418601247
4 Belgium BEL h 81.79 2.1428 0.759 0.9629 1.0 0.516714413251126 0.20116703803936198 0.089710835061231 0.024110177563804
24 South Korea KOR h 72.56 1.6908 1.0781 0.0 0.0208 0.003936992979788 0.001003424561725 0.000143025658397 3.5220462707e-05
29 Russia RUS h 78.29 1.6109 0.6422 0.0 0.5187 0.138887600472553 0.046181961609447 0.009441361020152 0.003008947454078

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "world-cup-predictions/wc-20140622-235721" (
"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 19.819ms