world-cup-predictions/wc-20140617-091836

4 rows where group = "b"

View and edit SQL

group

Link rowid country country_id group spi spi_offense spi_defense win_group sixteen quarter semi cup win
3 Australia AUS b 69.13 1.6537 1.2677 0.0022 0.0214 0.00172897196142 0.000501773721131 9.987412192299999e-05 1.4657278829000001e-05
7 Chile CHI b 86.83 2.7238 0.7007 0.3112 0.7756 0.325087830993393 0.206102077025248 0.106600638710091 0.041478195862186006
15 Spain ESP b 86.77 2.6136 0.6381 0.0251 0.2464 0.065941828931493 0.039199643716856004 0.01918474493084 0.008625523022142999
26 Netherlands NED b 86.88 2.8083 0.7476 0.6615 0.9566 0.5364804937077721 0.350210907482806 0.18447061102512 0.066790555909356

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "world-cup-predictions/wc-20140617-091836" (
"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 23.604ms