world-cup-predictions/wc-20140622-235721

4 rows where group = "c" sorted by quarter

View and edit SQL

Suggested facets: 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.0437 0.017963847062391996 0.00489668294841 0.001339939154951 0.00020604838238199997
19 Greece GRE c 74.14 1.1789 0.5861 0.0 0.2069 0.08753979619936299 0.024876364478044997 0.0071128991372149996 0.001205453257524
8 Ivory Coast CIV c 79.49 2.2641 1.0166 0.0132 0.7494 0.398683271972443 0.148708687680844 0.05646335695471 0.013467524017466998
10 Colombia COL c 87.48 2.4192 0.4511 0.9868 1.0 0.657785949589661 0.21287510598478698 0.10464576439145802 0.05360363697890401

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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