world-cup-predictions/wc-20140622-235721

4 rows where group = "g" sorted by quarter descending

View and edit SQL

Suggested facets: win_group

group

Link rowid country country_id group spi spi_offense spi_defense win_group sixteen quarter ▲ semi cup win
17 Germany GER g 88.69 3.1804 0.7879 0.857 0.9971 0.800094865950399 0.479228604266649 0.21824040728640198 0.125055075404015
32 USA USA g 78.67 2.1221 0.9784 0.143 0.7577 0.366222250933069 0.125520539547468 0.044625105923579 0.010532717706092
18 Ghana GHA g 77.45 1.9154 0.9179999999999999 0.0 0.1909 0.081848861745763 0.025937851212773998 0.009726001148096 0.0020014917809200003
28 Portugal POR g 78.95 2.077 0.9259999999999999 0.0 0.0543 0.024928263672772004 0.008613348553097 0.003509027536227 0.000793124844545

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "world-cup-predictions/wc-20140622-235721" (
"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 23.667ms