world-cup-predictions/wc-20140617-091836

4 rows where group = "c"

View and edit SQL

group

Link rowid country country_id group spi spi_offense spi_defense win_group sixteen quarter semi cup win
8 Ivory Coast CIV c 79.15 2.2139 1.0064 0.2228 0.7895 0.39816058965572 0.127399567760031 0.045530351199531 0.010126890376656
10 Colombia COL c 87.63 2.3896 0.4174 0.7559 0.965 0.639744602628343 0.21864500331415698 0.10947325031231901 0.04933568477451099
19 Greece GRE c 74.21 1.2976 0.672 0.0105 0.1463 0.05960243661081599 0.016831430658611 0.00469046491155 0.000718671874963
23 Japan JPN c 73.13 2.073 1.3309 0.0108 0.0992 0.03884033350999 0.010075661430172 0.0026232291787660006 0.00036191547767000005

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "world-cup-predictions/wc-20140617-091836" (
"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 52.718ms