world-cup-predictions/wc-20140617-091836

4 rows where group = "a"

View and edit SQL

group

Link rowid country country_id group spi spi_offense spi_defense win_group sixteen quarter semi cup win
6 Brazil BRA a 91.6 3.3842 0.5578 0.968 0.9985 0.790926300946913 0.6630996662055461 0.510543832936704 0.40667088880421604
9 Cameroon CMR a 70.12 1.3559999999999999 0.9670000000000001 0.0005 0.0302 0.0060120927082890005 0.002062342050852 0.000496950152126 6.0659787349e-05
12 Croatia CRO a 76.38 1.8123 0.9164 0.002 0.3851 0.10578805721857801 0.045607893683955 0.014275952810349 0.002419913264329
25 Mexico MEX a 77.57 1.5338 0.6336 0.0295 0.5862 0.168034423532056 0.073581674092714 0.023667511892912 0.004251829159479001

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