womens-world-cup-predictions/wwc-matches-20150623-235546

6 rows where group = "F" sorted by tie

View and edit SQL

Suggested facets: date, team1, team2, team1_win, team2_win, tie, date (date)

group

Link rowid date group team1 team2 team1_win team2_win tie ▼
9 2015-06-09 F France England 1.0 0.0 0
21 2015-06-13 F France Colombia 0.0 1.0 0
23 2015-06-13 F England Mexico 1.0 0.0 0
33 2015-06-17 F Mexico France 0.0 1.0 0
34 2015-06-17 F England Colombia 1.0 0.0 0
11 2015-06-09 F Colombia Mexico 0.0 0.0 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "womens-world-cup-predictions/wwc-matches-20150623-235546" (
"date" TEXT,
  "group" TEXT,
  "team1" TEXT,
  "team2" TEXT,
  "team1_win" REAL,
  "team2_win" REAL,
  "tie" INTEGER
);
Powered by Datasette · Query took 15.865ms