womens-world-cup-predictions/wwc-matches-20150705-205539

15 rows where team2_win = 1 sorted by team1_win

View and edit SQL

Suggested facets: date, group, team1, team2, date (date)

team2_win

Link rowid date group team1 team2 team1_win ▼ team2_win tie
2 2015-06-06 A New Zealand Netherlands 0 1 0
15 2015-06-11 B Ivory Coast Thailand 0 1 0
21 2015-06-13 F France Colombia 0 1 0
25 2015-06-15 B Thailand Germany 0 1 0
26 2015-06-15 B Ivory Coast Norway 0 1 0
29 2015-06-16 C Ecuador Japan 0 1 0
30 2015-06-16 C Switzerland Cameroon 0 1 0
31 2015-06-16 D Nigeria USA 0 1 0
33 2015-06-17 F Mexico France 0 1 0
35 2015-06-17 E Costa Rica Brazil 0 1 0
41 2015-06-21   Brazil Australia 0 1 0
43 2015-06-22   Norway England 0 1 0
45 2015-06-26   China USA 0 1 0
47 2015-06-27   Australia Japan 0 1 0
51 2015-07-04   Germany England 0 1 0

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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