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.99134383	3.88003086	0.39057046	1	0	0	0	0	1	1.0	0.719	0.44735	0.3497
2	USA	D	95.20588303	3.5665402	0.40443394	1	0	0	0	0	1	0.95405	0.8391	0.4152	0.30005
3	Japan	C	92.27317461	2.75937386	0.54834334	1	0	0	0	0	1	0.73185	0.46145	0.26835	0.09075
4	Canada	A	89.39774464	2.16171268	0.65032637	1	0	0	0	0	1	1.0	0.5774	0.298	0.0845
5	France	F	92.46472353	2.87059197	0.61258886	1	0	0	0	0	1	1.0	0.281	0.11585	0.0685
6	Australia	D	89.47812011	2.40487837	0.89759282	0	1	0	0	0	1	1.0	0.43055	0.19865	0.0477
7	England	F	89.21829442	2.22353465	0.76003132	0	1	0	0	0	1	0.5088	0.21815	0.1044	0.0244
8	Norway	B	89.03188343	2.21406976	0.79279041	0	1	0	0	0	1	0.4912	0.20445	0.09035	0.0203
9	Netherlands	A	86.28242957	1.86003809	0.98914607	0	0	1	0	0	1	0.26815	0.108	0.04025	0.00715
10	China	A	85.39302408	1.48378622	0.74785799	0	1	0	0	0	1	1.0	0.14415	0.02055	0.00675
11	Colombia	F	80.32665865	1.10895025	1.20466353	0	0	1	0	0	1	0.04595	0.01675	0.00105	0.0002
12	Sweden	D	91.32029906	2.67609931	0.72745095	0	0	1	0	0	1	0.0	0.0	0.0	0.0
13	Cameroon	C	81.15984435	1.2903529	1.2690039	0	1	0	0	0	1	0.0	0.0	0.0	0.0
14	Brazil	E	91.68650667	2.59287632	0.53489354	1	0	0	0	0	1	0.0	0.0	0.0	0.0
15	South Korea	E	83.18060181	1.67997341	1.35966118	0	1	0	0	0	1	0.0	0.0	0.0	0.0
16	Switzerland	C	83.69523188	1.87705432	1.48650619	0	0	1	0	0	1	0.0	0.0	0.0	0.0
17	Spain	E	83.4267504	1.46396321	1.08077115	0	0	0	0	1	0	0.0	0.0	0.0	0.0
18	Thailand	B	68.37245736	0.89817463	2.70324769	0	0	0	1	0	0	0.0	0.0	0.0	0.0
19	New Zealand	A	82.825185	1.48165077	1.20290356	0	0	0	0	1	0	0.0	0.0	0.0	0.0
20	Ivory Coast	B	71.92524202	1.38402719	2.7541836	0	0	0	0	1	0	0.0	0.0	0.0	0.0
21	Costa Rica	E	74.73189246	0.93446957	1.86411389	0	0	0	1	0	0	0.0	0.0	0.0	0.0
22	Mexico	F	80.41834561	1.48390168	1.60050664	0	0	0	0	1	0	0.0	0.0	0.0	0.0
23	Nigeria	D	85.84140827	1.71052963	0.91113746	0	0	0	0	1	0	0.0	0.0	0.0	0.0
24	Ecuador	C	57.71958936	0.48521569	3.60126165	0	0	0	0	1	0	0.0	0.0	0.0	0.0