world-cup-predictions/wc-20140619-180248

4 rows where group = "d" sorted by win_group

View and edit SQL

group

Link rowid country country_id group spi spi_offense spi_defense win_group ▼ sixteen quarter semi cup win
31 Uruguay URU d 80.9 2.1952 0.8632 0.0605 0.2211 0.09331419121432301 0.026126351199909 0.010011584435671 0.0031423270654040007
14 England ENG d 82.23 2.1691 0.7432 0.0867 0.3193 0.13974952975399602 0.041190751352993 0.016450595093543 0.005433570984972
11 Costa Rica CRC d 77.52 1.5925 0.6815 0.4082 0.7129 0.286986427532969 0.079699679202261 0.025642379375656 0.00573865929366
22 Italy ITA d 80.15 2.0347 0.8101 0.4446 0.7467 0.34116651554610306 0.11041958757751899 0.040418054994999 0.010490584082115

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