world-cup-predictions/wc-20140623-220333

8 rows where sixteen = "1.0" sorted by country

View and edit SQL

Suggested facets: group, win_group

sixteen

Link rowid country ▼ country_id group spi spi_offense spi_defense win_group sixteen quarter semi cup win
2 Argentina ARG f 89.64 2.7388 0.425 0.8918 1.0 0.722724804816972 0.4883566894700229 0.319090571268164 0.145020450032203
4 Belgium BEL h 83.29 2.1563 0.6524 0.9622 1.0 0.5377500979965371 0.224037585169874 0.11148121237422802 0.032158557420669
6 Brazil BRA a 91.1 3.1656 0.5023 1.0 1.0 0.741521344736627 0.592219877112427 0.44487318402248904 0.34975412676014306
7 Chile CHI b 87.76 2.7339 0.6197 0.0 1.0 0.258478655263344 0.15056684335656 0.077973631319431 0.044177780747179
10 Colombia COL c 87.41 2.4118 0.4555 0.9847 1.0 0.6563419710929561 0.19931602881331398 0.09796021422002801 0.052282567455219996
11 Costa Rica CRC d 78.47 1.5821 0.6114 0.89 1.0 0.466069644041325 0.16654844501035398 0.057173674952878 0.012439015223775001
25 Mexico MEX a 78.39 1.4714 0.5366 0.0 1.0 0.30827385391661 0.147635251928042 0.050063488298717 0.010502822960020001
26 Netherlands NED b 86.2 2.7928 0.8062 1.0 1.0 0.6917261460832711 0.466789520407035 0.24476922646146498 0.08881470584351199

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