world-cup-predictions/wc-20140620-175706

4 rows where group = "h" sorted by cup

View and edit SQL

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.25 1.1759 1.1674 0.0232 0.1543 0.022835907167855 0.00476904973308 0.000602637972346 8.7679587371e-05
24 South Korea KOR h 72.53 1.6905 1.0807 0.1249 0.4103 0.09596297673232303 0.025390392562109 0.005196489898874001 0.0009646285409910001
29 Russia RUS h 78.34 1.6128 0.6409 0.2091 0.5672 0.18358201110368103 0.063003102207562 0.017739585016368 0.004456106612665999
4 Belgium BEL h 81.82 2.1461 0.7596 0.6428 0.8682 0.41287535507201095 0.15862981312280403 0.06526115970912201 0.018441197075277003

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