world-cup-predictions/wc-20140619-180248

4 rows where group = "g" sorted by spi_offense

View and edit SQL

group

Link rowid country country_id group spi spi_offense ▼ spi_defense win_group sixteen quarter semi cup win
18 Ghana GHA g 76.29 1.8443 0.9469 0.0054 0.1097 0.049071473614957 0.013893835428782001 0.004814252316489001 0.0009468069274839999
28 Portugal POR g 79.1 2.0823 0.9194 0.0095 0.2323 0.116348622441769 0.038237260516336 0.015027729578667 0.003484604055855
32 USA USA g 78.46 2.1014 0.9798 0.121 0.6774 0.337476976714631 0.112622778780821 0.039385200777318996 0.009103957658877
17 Germany GER g 89.42 3.2403 0.7437 0.8641 0.9806 0.7832861066812751 0.525303287797791 0.247148618559332 0.146608029053207

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