world-cup-predictions/wc-20140619-180248

4 rows where group = "f" sorted by win

View and edit SQL

group

Link rowid country country_id group spi spi_offense spi_defense win_group sixteen quarter semi cup win ▼
21 Iran IRN f 70.82 1.1909 0.7937 0.0203 0.1942 0.05188773969651401 0.012017366560864 0.001979845400079 0.00038277103352800005
27 Nigeria NGA f 74.86 1.548 0.8220000000000001 0.0354 0.2671 0.087161106153095 0.024914596419859 0.00514089879352 0.001209250443553
5 Bosnia and Herzegovina BIH f 80.62 2.3309 0.9766 0.0424 0.5563 0.23638342105420398 0.08737784933785099 0.023416650051767 0.007958896088182
2 Argentina ARG f 89.89 2.8248 0.4457 0.9019 0.9824 0.6966222944581071 0.496672680486628 0.31859067521478696 0.148768716520945

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "world-cup-predictions/wc-20140619-180248" (
"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 21.493ms