womens-world-cup-predictions/wwc-forecast-20150626-184421

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 Germany B 95.90262448 3.83583948 0.38574662 1 0 0 0 0 1 1 1.0 0.5941 0.4456
2 USA D 95.16692363 3.54303547 0.39614129 1 0 0 0 0 1 1 0.88085 0.3936 0.2812
3 Japan C 92.30291546 2.77264893 0.55466902 1 0 0 0 0 1 1 0.6248 0.3599 0.11565
4 Canada A 89.37313338 2.15570625 0.6499464 1 0 0 0 0 1 1 0.5659 0.28065 0.07575
5 Australia D 89.48586625 2.40620512 0.897621 0 1 0 0 0 1 1 0.3752 0.17605 0.03985
6 England F 89.46667375 2.27365874 0.75703674 0 1 0 0 0 1 1 0.4341 0.1834 0.03825
7 China A 85.39312901 1.48348768 0.74778628 0 1 0 0 0 1 1 0.11915 0.0123 0.0037
8 France F 92.45116427 2.86003449 0.60576144 1 0 0 0 0 1 1 0.0 0.0 0.0
9 Brazil E 91.68974466 2.5937366 0.53549108 1 0 0 0 0 1 0 0.0 0.0 0.0
10 Netherlands A 86.35205314 1.87835095 0.9957436 0 0 1 0 0 1 0 0.0 0.0 0.0
11 Cameroon C 81.15770062 1.28944049 1.26855833 0 1 0 0 0 1 0 0.0 0.0 0.0
12 Colombia F 80.23792179 1.07933369 1.18658269 0 0 1 0 0 1 0 0.0 0.0 0.0
13 Norway B 88.89702352 2.20602725 0.81504964 0 1 0 0 0 1 0 0.0 0.0 0.0
14 Sweden D 91.33216868 2.68035071 0.72938569 0 0 1 0 0 1 0 0.0 0.0 0.0
15 South Korea E 83.18386455 1.68057257 1.35998767 0 1 0 0 0 1 0 0.0 0.0 0.0
16 Switzerland C 83.69289643 1.87657968 1.48663322 0 0 1 0 0 1 0 0.0 0.0 0.0
17 Spain E 83.4563809 1.46412094 1.07605978 0 0 0 0 1 0 0 0.0 0.0 0.0
18 Thailand B 68.34465847 0.89781204 2.70667886 0 0 0 1 0 0 0 0.0 0.0 0.0
19 New Zealand A 82.8177714 1.48014893 1.20273585 0 0 0 0 1 0 0 0.0 0.0 0.0
20 Ivory Coast B 71.86376106 1.38089876 2.75934875 0 0 0 0 1 0 0 0.0 0.0 0.0
21 Costa Rica E 74.73420122 0.93499261 1.86439691 0 0 0 1 0 0 0 0.0 0.0 0.0
22 Mexico F 80.39728269 1.48459434 1.60483429 0 0 0 0 1 0 0 0.0 0.0 0.0
23 Nigeria D 85.86716548 1.71625315 0.91274326 0 0 0 0 1 0 0 0.0 0.0 0.0
24 Ecuador C 57.67669771 0.48593473 3.60753731 0 0 0 0 1 0 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-20150626-184421" (
"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" REAL,
  "final" REAL,
  "win" REAL
);
Powered by Datasette · Query took 37.903ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub