womens-world-cup-predictions/wwc-forecast-20150630-210243

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub

24 rows

View and edit SQL

Suggested facets: group, group_first, group_second, group_third_advance, group_third_no_advance, group_fourth, sixteen, quarter, semi, final, win

Link rowid ▼ team group wspi wspi_offense wspi_defense group_first group_second group_third_advance group_third_no_advance group_fourth sixteen quarter semi final win
1 USA D 95.26637066 3.55085065 0.3672448 1 0 0 0 0 1 1 1 1.0 0.6988
2 Japan C 92.25279964 2.73551176 0.53191162 1 0 0 0 0 1 1 1 0.6051 0.20295
3 England F 89.83796771 2.34365926 0.74762104 1 0 0 0 0 1 1 1 0.3949 0.09825
4 Germany B 95.63867702 3.7322227 0.40039977 1 0 0 0 0 1 1 1 0.0 0.0
5 France F 92.4200333 2.85073238 0.60818856 0 1 0 0 0 1 1 0 0.0 0.0
6 Australia D 89.23175836 2.33519795 0.88174895 0 1 0 0 0 1 1 0 0.0 0.0
7 China A 85.31040358 1.45317375 0.73150416 0 1 0 0 0 1 1 0 0.0 0.0
8 Canada A 89.22334764 2.14503231 0.67549957 1 0 0 0 0 1 1 0 0.0 0.0
9 Cameroon C 81.18242344 1.29277293 1.26918818 0 1 0 0 0 1 0 0 0.0 0.0
10 Norway B 88.92048069 2.21021609 0.81644913 0 1 0 0 0 1 0 0 0.0 0.0
11 Sweden D 91.32526592 2.68016938 0.73389311 0 0 1 0 0 1 0 0 0.0 0.0
12 Colombia F 80.31237789 1.08356692 1.18028907 0 0 1 0 0 1 0 0 0.0 0.0
13 Netherlands A 86.34353247 1.87737017 0.99797911 0 0 1 0 0 1 0 0 0.0 0.0
14 Brazil E 91.70171895 2.59745197 0.53911375 1 0 0 0 0 1 0 0 0.0 0.0
15 South Korea E 83.1853329 1.68154913 1.36199792 0 1 0 0 0 1 0 0 0.0 0.0
16 Switzerland C 83.70026735 1.87680999 1.48684674 0 0 1 0 0 1 0 0 0.0 0.0
17 Spain E 83.45818075 1.46252083 1.07521586 0 0 0 0 1 0 0 0 0.0 0.0
18 Thailand B 68.3100234 0.89717987 2.71081367 0 0 0 1 0 0 0 0 0.0 0.0
19 New Zealand A 82.82502131 1.48169978 1.20435935 0 0 0 0 1 0 0 0 0.0 0.0
20 Ivory Coast B 71.7668654 1.37849918 2.77045679 0 0 0 0 1 0 0 0 0.0 0.0
21 Costa Rica E 74.74668878 0.93593183 1.86404094 0 0 0 1 0 0 0 0 0.0 0.0
22 Mexico F 80.47467464 1.4898295 1.59911713 0 0 0 0 1 0 0 0 0.0 0.0
23 Nigeria D 85.8748763 1.71978574 0.91667137 0 0 0 0 1 0 0 0 0.0 0.0
24 Ecuador C 57.70348565 0.48781304 3.60637323 0 0 0 0 1 0 0 0 0.0 0.0

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "womens-world-cup-predictions/wwc-forecast-20150630-210243" (
"team" TEXT,
  "group" TEXT,
  "wspi" REAL,
  "wspi_offense" REAL,
  "wspi_defense" REAL,
  "group_first" INTEGER,
  "group_second" INTEGER,
  "group_third_advance" INTEGER,
  "group_third_no_advance" INTEGER,
  "group_fourth" INTEGER,
  "sixteen" INTEGER,
  "quarter" INTEGER,
  "semi" INTEGER,
  "final" REAL,
  "win" REAL
);
Powered by Datasette · Query took 29.089ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub