world-cup-predictions/wc-20140623-220333

2 rows where win_group = "1.0" sorted by spi

View and edit SQL

win_group

Link rowid country country_id group spi ▼ spi_offense spi_defense win_group sixteen quarter semi cup win
26 Netherlands NED b 86.2 2.7928 0.8062 1.0 1.0 0.6917261460832711 0.466789520407035 0.24476922646146498 0.08881470584351199
6 Brazil BRA a 91.1 3.1656 0.5023 1.0 1.0 0.741521344736627 0.592219877112427 0.44487318402248904 0.34975412676014306

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "world-cup-predictions/wc-20140623-220333" (
"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 47.04ms