world-cup-predictions/wc-20140623-220333

16 rows where win_group = "0.0" sorted by spi

View and edit SQL

Suggested facets: group, sixteen, quarter, semi, cup, win

win_group

  • 0.0 · 16
Link rowid country country_id group spi ▼ spi_offense spi_defense win_group sixteen quarter semi cup win
24 South Korea KOR h 64.44 1.6461 1.5618 0.0 0.0078 0.001015272842881 0.000178824311598 1.5277408618e-05 2.5479589060000002e-06
20 Honduras HON e 68.27 1.5098 1.2066 0.0 0.0182 0.003005401838997 0.00085586336887 0.00023583478825799998 2.895910891e-05
9 Cameroon CMR a 69.34 1.4876 1.1228 0.0 0.0 0.0 0.0 0.0 0.0
3 Australia AUS b 70.26 1.7863 1.3032 0.0 0.0 0.0 0.0 0.0 0.0
21 Iran IRN f 70.87 1.1287 0.742 0.0 0.1248 0.023993685278145 0.005554717609752 0.0007287547830780001 0.00017671681982400002
19 Greece GRE c 72.85 1.1093 0.6108 0.0 0.1934 0.07890091367176501 0.02320409562603 0.0062432258126430005 0.0009833450826880002
23 Japan JPN c 73.34 1.972 1.2427 0.0 0.0375 0.015544546222818 0.0045725161731429995 0.001225001193414 0.000187634192634
29 Russia RUS h 76.91 1.4624 0.6276 0.0 0.3545 0.08730751594867199 0.027255829691962996 0.004887602887864001 0.0015505091502449999
25 Mexico MEX a 78.39 1.4714 0.5366 0.0 1.0 0.30827385391661 0.147635251928042 0.050063488298717 0.010502822960020001
28 Portugal POR g 78.88 2.0901 0.9426 0.0 0.0506 0.021580937002348997 0.007462311317862 0.003196972757545 0.000714078271133
18 Ghana GHA g 78.98 1.9887 0.8644 0.0 0.2052 0.087246893860638 0.029710371957821 0.012610760106253999 0.002796400740812
5 Bosnia and Herzegovina BIH f 79.34 2.1914 0.9794 0.0 0.0 0.0 0.0 0.0 0.0
12 Croatia CRO a 79.81 2.0425 0.8417 0.0 0.0 0.0 0.0 0.0 0.0
14 England ENG d 81.42 2.1295 0.7809 0.0 0.0 0.0 0.0 0.0 0.0
15 Spain ESP b 85.74 2.4815 0.6539 0.0 0.0 0.0 0.0 0.0 0.0
7 Chile CHI b 87.76 2.7339 0.6197 0.0 1.0 0.258478655263344 0.15056684335656 0.077973631319431 0.044177780747179

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