world-cup-predictions/wc-20140626-180150

4 rows where group = "f"

View and edit SQL

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

group

Link rowid country country_id group spi spi_offense spi_defense win_group sixteen quarter semi cup win
2 Argentina ARG f 90.14 2.9531 0.4932 1.0 1.0 0.7499991300017349 0.54826419693304 0.375030802961636 0.172833038158762
5 Bosnia and Herzegovina BIH f 80.46 2.2777 0.9573 0.0 0.0 0.0 0.0 0.0 0.0
21 Iran IRN f 69.34 1.1127 0.8220000000000001 0.0 0.0 0.0 0.0 0.0 0.0
27 Nigeria NGA f 77.2 1.6936 0.7807 0.0 1.0 0.275817583468004 0.078978409949777 0.014058796832283999 0.004367390293846

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "world-cup-predictions/wc-20140626-180150" (
"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 115.923ms