world-cup-predictions/wc-20140622-091255

4 rows where group = "c" sorted by sixteen

View and edit SQL

win_group

group

Link rowid country country_id group spi spi_offense spi_defense win_group sixteen ▼ quarter semi cup win
23 Japan JPN c 73.36 1.97 1.2383 0.0 0.0382 0.015726924522942 0.004248267155743 0.001151440675256 0.00018060530004400003
19 Greece GRE c 74.14 1.1789 0.5861 0.0 0.2097 0.08878340402334699 0.025194997958954 0.007161940099923999 0.0012331809403839998
8 Ivory Coast CIV c 79.49 2.2641 1.0166 0.0144 0.7521 0.400218204548308 0.14893963530499899 0.056121638270891 0.013536842104447
10 Colombia COL c 87.48 2.4192 0.4511 0.9856 1.0 0.6581812261391851 0.214190688291034 0.10763457203355803 0.054708848533477995

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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