world-cup-predictions/wc-20140620-175706

4 rows where group = "f" 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
21 Iran IRN f 70.83 1.1912 0.7941 0.023 0.1952 0.052593960205750995 0.012357571717040999 0.00208598523878 0.00040005950373
27 Nigeria NGA f 74.87 1.5464 0.8209 0.0356 0.2789 0.09008878084566198 0.025725508078951003 0.005368811319056 0.001262649390868
5 Bosnia and Herzegovina BIH f 80.59 2.331 0.9799 0.0353 0.5451 0.230277902130814 0.08466073728894001 0.022481683239052003 0.007695674154236
2 Argentina ARG f 89.91 2.8255 0.4452 0.9061 0.9808 0.69659633088281 0.497148248736334 0.320315610539402 0.149828002006455

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