Fifa World Cup 2006 Soccer All Results
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Fifa World Cup 2006 Soccer All Results as PDF for free.
More details
- Words: 10,303
- Pages: 44
Match! All details for FIFA World Cup Soccer 2006 competition and related gambling-competition
12-7-2006 by: Eiger Software Inc. H: http://eigersoftware.tripod.com/match.htm E: [email protected]
1
CONTENTS 1. Introduction..............................................................................................................................................................................................................................................................3 2. Ranking Gamblers...................................................................................................................................................................................................................................................4 3. Gambler- Points Spec. Bar Graph...........................................................................................................................................................................................................................5 4. Gambler-Points Timeseries Graph...........................................................................................................................................................................................................................6 5. Toto Forecast Stats. ................................................................................................................................................................................................................................................7 6. End Ranking Teams ................................................................................................................................................................................................................................................9 7. Ranking Teams after Round 1................................................................................................................................................................................................................................10 8. Ranking Teams after Round 1- Detailed................................................................................................................................................................................................................13 9. Results Matches – ordered by date........................................................................................................................................................................................................................15 10. Results Matches – Detailed..................................................................................................................................................................................................................................19 11. Results Matches in Round 1 – ordered by Group................................................................................................................................................................................................33 12. Results Matches in Round 1- Matrix...................................................................................................................................................................................................................37 13. Topscorers............................................................................................................................................................................................................................................................38 14. Competition Stats.................................................................................................................................................................................................................................................39 15. All stars team NL.................................................................................................................................................................................................................................................39 16. All stars team spec. NL........................................................................................................................................................................................................................................40 17. Performance suplayers NL...................................................................................................................................................................................................................................41 18. Topscorers NL......................................................................................................................................................................................................................................................43 19. Goals Time specification NL...............................................................................................................................................................................................................................43 20. Yellow cards NL...................................................................................................................................................................................................................................................43 21. Red cards NL.......................................................................................................................................................................................................................................................44 22. Literature..............................................................................................................................................................................................................................................................44
2
1. Introduction This document contains all reports, figures and statistics produced by Match! for the FIFA World Cup 2006 (WC), both for the soccer-competition as the betting-competition (‘toto’). See [Match! user manual, on website] for an explanation of all the figures in this doc. In Match, the matches of round 1 (group-round) have ID’s 1-48. In the next (final-)rounds, the match-ID’s are 10.001-10.016. Paragraphs 12-20, so the output marked with ‘NL’, relate to statistics of the Dutch team. The performances (marks, ‘rapport-cijfers’) are from soccer-experts (Telegraaf). We registered almost all match-details (e.g. who made a goal and when), except: yellow/red-cards and lineups, this is only done for the Dutch-team. When a match in a final-round is equal at the end of the extra time (so a ‘draw’ after 120 min.), the result of the penalty-shoot-out is considered by Match as 1 goal for the winning team, and the result is a victory, not a draw. In Match this goal is registered as: sub-player: ‘NN’, time: 121 (min.). Own goals are in Match not assigned to a sub-player, but to ‘NN’ (anonymus). References to literature are noted as [Li]. On our website, you can find Match! (demo-version), with all data as you can see in this report. Because the WC is now over, the last round (round 5) is the actual round, and the matches you see will be filtered on this round. To see matches of another round, you have to make that round the actual round. On our website you can find also the original sources of the reports in this document, e.g. Excel-files with graphs.
3
2. Ranking Gamblers Ranking
Match!©
Gambler
Point#
Toto# Score# Player#End Rank#
1
15 Johan
132
82
12
34
4
2
10 Maarten
132
86
12
34
0
3
3 Sulma
128
86
9
33
0
4
2 Silvia
125
84
7
34
0
5
1 Azucena
124
82
6
36
0
6
4 Joaquin
118
78
4
32
4
7
5 Monce
116
74
5
35
2
8
7 Dennis
114
68
7
31
8
9
14 Wilson
111
72
10
29
0
10
13 Tieneke
109
76
3
30
0
11
12 Doris
109
68
5
32
4
12
9 Petra
108
72
7
29
0
13
8 Peter
103
70
6
27
0
14
6 Paul
96
62
5
29
0
15
16 Victor
76
50
4
22
0
dinsdag 11 juli 2006
Pagina 1 van 1
4
3. Gambler- Points Spec. Bar Graph X = Gambler Y = Points #
140 120 100 pnt_endrank_no
80
pnt_playr_no pnt_goal_no
60
pnt_toto_no
40 20
or ct Vi
ul Pa
r te Pe
tr a Pe
e ek en Ti
r is Do
ils o
n
is W
nn De
ce on M
ui n aq Jo
en
a
a
uc
n
a lm Su
ha Jo
Si lv i
Az
M
aa
r te
n
0
5
4. Gambler-Points Timeseries Graph X = Match-ID (time) Y = Points #
140
Azucena Silvia Sulma Joaquin Monce Paul Dennis Peter Petra Maarten Doris Tieneke Wilson Johan Victor
120 100 80 60 40 20
M 8 M 11 EN M 1 D -T 4 O TA L
4 M
M Ro 45 un d 2
M 41
37 M
M 33
29 M
M 25
21 M
M 17
9
13 M
M
5 M
M 1
0
6
5. Toto Forecast Stats.
7
8
6. End Ranking Teams
Ranking
Player
1
17 Italy
2
25 France
3 4
1 Germany 16 Portugal
9
7. Ranking Teams after Round 1
Group 1 A Ranking
Player
Match# Point#Score: Pos.Neg.Saldo
1
1 Germany
3
9
8
2
6
2
4 Ecuador
3
6
5
3
2
3
3 Poland
3
3
2
4
-2
4
2 Costa Rica
3
0
3
9
-6
Group 2 B Ranking
Player
Match# Point#Score: Pos.Neg.Saldo
1
5 England
3
7
5
2
3
2
8 Sweden
3
5
3
2
1
3
6 Paraguay
3
3
2
2
0
4
7 Trinidad &
3
1
0
4
-4
Group 3 C Ranking
Player
Match# Point#Score: Pos.Neg.Saldo
1
9 Argentina
3
7
8
1
7
2
12 Netherlands
3
7
3
1
2
Match!© zaterdag 24 juni 2006
Pagina 1 van 3
10
Ranking
Player
Match# Point#Score: Pos.Neg.Saldo
3
10 Côte d’Ivoir
3
3
5
6
-1
4
11 Serbia &
3
0
2
10
-8
Group 4 D Ranking
Player
Match# Point#Score: Pos.Neg.Saldo
1
16 Portugal
3
9
5
1
4
2
13 Mexico
3
4
4
3
1
3
15 Angola
3
2
1
2
-1
4
14 Iran
3
1
2
6
-4
Group 5 E Ranking
Player
Match# Point#Score: Pos.Neg.Saldo
1
17 Italy
3
7
5
1
4
2
18 Ghana
3
6
4
3
1
3
20 Czech Republic
3
3
3
4
-1
4
19 USA
3
1
2
6
-4
Group 6 F Ranking
Player
Match# Point#Score: Pos.Neg.Saldo
1
21 Brazil
3
9
7
1
6
2
23 Australia
3
4
5
5
0
3
22 Croatia
3
2
2
3
-1
4
24 Japan
3
1
2
7
-5
Match!© zaterdag 24 juni 2006
Pagina 2 van 3
11
Group 7 G Ranking
Player
Match# Point#Score: Pos.Neg.Saldo
1
26 Switzerland
3
7
4
0
4
2
25 France
3
5
3
1
2
3
27 South Korea
3
4
3
4
-1
4
28 Togo
3
0
1
6
-5
Group 8 H Ranking
Player
Match# Point#Score: Pos.Neg.Saldo
1
29 Spain
3
9
8
1
7
2
30 Ukraine
3
6
5
4
1
3
31 Tunisia
3
1
3
6
-3
4
32 Saudi Arabia
3
1
2
7
-5
Match!© zaterdag 24 juni 2006
Pagina 3 van 3
12
8. Ranking Teams after Round 1- Detailed Group
Ranking
PlayerMatch#Point#Vic.#Draw#Loss#Score: Pos. Neg. Saldo
1 A
1
1 Germany
3
9
3
0
0
8
2
6
1 A
2
4 Ecuador
3
6
2
0
1
5
3
2
1 A
3
3 Poland
3
3
1
0
2
2
4
-2
1 A
4
2 Costa Rica
3
0
0
0
3
3
9
-6
2 B
1
5 England
3
7
2
1
0
5
2
3
2 B
2
8 Sweden
3
5
1
2
0
3
2
1
2 B
3
6 Paraguay
3
3
1
0
2
2
2
0
2 B
4
7 Trinidad & Tobago
3
1
0
1
2
0
4
-4
3 C
1
9 Argentina
3
7
2
1
0
8
1
7
3 C
2
12 Netherlands
3
7
2
1
0
3
1
2
3 C
3
10 Côte d’Ivoir
3
3
1
0
2
5
6
-1
3 C
4
11 Serbia &
3
0
0
0
3
2
10
-8
4 D
1
16 Portugal
3
9
3
0
0
5
1
4
4 D
2
13 Mexico
3
4
1
1
1
4
3
1
4 D
3
15 Angola
3
2
0
2
1
1
2
-1
4 D
4
14 Iran
3
1
0
1
2
2
6
-4
5 E
1
17 Italy
3
7
2
1
0
5
1
4
Match!©
zaterdag 24 juni 2006
13
Group
Ranking
PlayerMatch#Point#Vic.#Draw#Loss#Score: Pos. Neg. Saldo
5 E
2
18 Ghana
3
6
2
0
1
4
3
1
5 E
3
20 Czech Republic
3
3
1
0
2
3
4
-1
5 E
4
19 USA
3
1
0
1
2
2
6
-4
6 F
1
21 Brazil
3
9
3
0
0
7
1
6
6 F
2
23 Australia
3
4
1
1
1
5
5
0
6 F
3
22 Croatia
3
2
0
2
1
2
3
-1
6 F
4
24 Japan
3
1
0
1
2
2
7
-5
7 G
1
26 Switzerland
3
7
2
1
0
4
0
4
7 G
2
25 France
3
5
1
2
0
3
1
2
7 G
3
27 South Korea
3
4
1
1
1
3
4
-1
7 G
4
28 Togo
3
0
0
0
3
1
6
-5
8 H
1
29 Spain
3
9
3
0
0
8
1
7
8 H
2
30 Ukraine
3
6
2
0
1
5
4
1
8 H
3
31 Tunisia
3
1
0
1
2
3
6
-3
8 H
4
32 Saudi Arabia
3
1
0
1
2
2
7
-5
Match!©
zaterdag 24 juni 2006
14
9. Results Matches – ordered by date
Match Date
Time
Location
GroupPlayer Home
Player Away
Score H-A
1
9-6-2006
18:00
Munchen
A
1
Germany
2
Costa Rica
4
2
2
9-6-2006
21:00
Gelsenkirchen
A
3
Poland
4
Ecuador
0
2
3
10-6-2006
15:00
Frankfurt
B
5
England
6
Paraguay
1
0
4
10-6-2006
18:00
Dortmund
B
7
Trinidad & Tobago
8
Sweden
0
0
5
10-6-2006
21:00
Hamburg
C
9
Argentina
10
Côte d’Ivoir
2
1
6
11-6-2006
15:00
Leipzig
C
11
Serbia & Montenegro
12
Netherlands
0
1
7
11-6-2006
18:00
Nurnberg
D
13
Mexico
14
Iran
3
1
8
11-6-2006
21:00
Koln
D
15
Angola
16
Portugal
0
1
9
12-6-2006
15:00
Kaiserslautern
F
23
Australia
24
Japan
3
1
10
12-6-2006
18:00
Gelsenkirchen
E
19
USA
20
Czech Republic
0
3
11
12-6-2006
21:00
Hannover
E
17
Italy
18
Ghana
2
0
12
13-6-2006
15:00
Frankfurt
G
27
South Korea
28
Togo
2
1
13
13-6-2006
18:00
Stuttgart
G
25
France
26
Switzerland
0
0
14
13-6-2006
21:00
Berlin
F
21
Brazil
22
Croatia
1
0
15
14-6-2006
15:00
Leipzig
H
29
Spain
30
Ukraine
4
0
16
14-6-2006
18:00
Munchen
H
31
Tunisia
32
Saudi Arabia
2
2
Match!©
dinsdag 11 juli 2006
Pagina 1 van 4
15
Match Date
Time
Location
GroupPlayer Home
Player Away
Score H-A
17
14-6-2006
21:00
Dortmund
A
1
Germany
3
Poland
1
0
18
15-6-2006
15:00
Hamburg
A
4
Ecuador
2
Costa Rica
3
0
19
15-6-2006
18:00
Nurnberg
B
5
England
7
Trinidad & Tobago
2
0
20
15-6-2006
21:00
Berlin
B
8
Sweden
6
Paraguay
1
0
21
16-6-2006
15:00
Gelsenkirchen
C
9
Argentina
11
Serbia & Montenegro
6
0
22
16-6-2006
18:00
Stuttgart
C
12
Netherlands
10
Côte d’Ivoir
2
1
23
16-6-2006
21:00
Hannover
D
13
Mexico
15
Angola
0
0
24
17-6-2006
15:00
Frankfurt
D
16
Portugal
14
Iran
2
0
25
17-6-2006
18:00
Koln
E
20
Czech Republic
18
Ghana
0
2
26
17-6-2006
21:00
Kaiserslautern
E
17
Italy
19
USA
1
1
27
18-6-2006
15:00
Nurnberg
F
24
Japan
22
Croatia
0
0
28
18-6-2006
18:00
Munchen
F
21
Brazil
23
Australia
2
0
29
18-6-2006
21:00
Leipzig
G
25
France
27
South Korea
1
1
30
19-6-2006
15:00
Dortmund
G
28
Togo
26
Switzerland
0
2
31
19-6-2006
18:00
Hamburg
H
32
Saudi Arabia
30
Ukraine
0
4
32
19-6-2006
21:00
Stuttgart
H
29
Spain
31
Tunisia
3
1
33
20-6-2006
16:00
Berlin
A
4
Ecuador
1
Germany
0
3
34
20-6-2006
16:00
Hannover
A
2
Costa Rica
3
Poland
1
2
35
20-6-2006
21:00
Kaiserslautern
B
6
Paraguay
7
Trinidad & Tobago
2
0
36
20-6-2006
21:00
Koln
B
8
Sweden
5
England
2
2
Match!©
dinsdag 11 juli 2006
Pagina 2 van 4
16
Match Date
Time
Location
GroupPlayer Home
Player Away
Score H-A
37
21-6-2006
16:00
Gelsenkirchen
D
16
Portugal
13
Mexico
2
1
38
21-6-2006
16:00
Leipzig
D
14
Iran
15
Angola
1
1
39
21-6-2006
21:00
Frankfurt
C
12
Netherlands
Argentina
0
0
40
21-6-2006
21:00
Munchen
C
10
Côte d’Ivoir
11
Serbia & Montenegro
3
2
41
22-6-2006
16:00
Hamburg
E
20
Czech Republic
17
Italy
0
2
42
22-6-2006
16:00
Nurnberg
E
18
Ghana
19
USA
2
1
43
22-6-2006
21:00
Dortmund
F
24
Japan
21
Brazil
1
4
44
22-6-2006
21:00
Stuttgart
F
22
Croatia
23
Australia
2
2
45
23-6-2006
16:00
Berlin
H
30
Ukraine
31
Tunisia
1
0
46
23-6-2006
16:00
Kaiserslautern
H
32
Saudi Arabia
29
Spain
0
1
47
23-6-2006
21:00
Hannover
G
26
Switzerland
27
South Korea
2
0
G
28
Togo
9
48
23-6-2006
21:00
Koln
25
France
0
2
10001
24-6-2006
17:00
Munchen
1
Germany
8
Sweden
2
0
10002
24-6-2006
21:00
Leipzig
9
Argentina
13
Mexico
2
1
10003
25-6-2006
17:00
Stuttgart
5
England
4
Ecuador
1
0
10004
25-6-2006
21:00
Nurnberg
16
Portugal
12
Netherlands
1
0
10005
26-6-2006
17:00
Kaiserslautern
17
Italy
23
Australia
1
0
10006
26-6-2006
21:00
Koln
26
Switzerland
30
Ukraine
0
1
10007
27-6-2006
17:00
Dortmund
21
Brazil
18
Ghana
3
0
10008
27-6-2006
21:00
Hannover
29
Spain
25
France
1
3
Match!©
dinsdag 11 juli 2006
Pagina 3 van 4
17
Match Date
Time
Location
GroupPlayer Home
10009
30-6-2006
17:00
Berlin
10010
30-6-2006
21:00
Hamburg
10011
1-7-2006
17:00
Gelsenkirchen
10012
1-7-2006
21:00
Frankfurt
21
10013
4-7-2006
21:00
Dortmund
1
10014
5-7-2006
21:00
Munchen
10015
8-7-2006
21:00
Stuttgart
10016
9-7-2006
20:00
Berlin
Match!©
dinsdag 11 juli 2006
1 17
Germany
Player Away 9
Score H-A
Argentina
2
1
Italy
30
Ukraine
3
0
England
16
Portugal
0
1
Brazil
25
France
0
1
Germany
17
Italy
0
2
16
Portugal
25
France
0
1
1
Germany
16
Portugal
3
1
Italy
25
France
2
1
5
17
Pagina 4 van 4
18
10.Results Matches – Detailed match (id, player_home - player_away, score): 1 , 1.Germany - 2.Costa Rica , 4 - 2 -location: Munchen , date: 9-6-2006 , referee: Merk --goal: | T5 , SP: 3.Lahm (P: 1.Germany) | T12 , SP: 1.Wanchope (P: 2.Costa Rica) | T17 , SP: 2.Klose (P: 1.Germany) | T61 , SP: 2.Klose (P: 1.Germany) | T72 , SP: 1.Wanchope (P: 2.Costa Rica) | T86 , SP: 4.Frings (P: 1.Germany) ---reprt_match: | T29 , SP: 2.Fonseca (P: 2.Costa Rica) , yellow_card ----lineup player_home : | SP: 4.Frings | SP: 3.Lahm | SP: 2.Klose | SP: 1.Ballack ----lineup player_away : | SP: 2.Fonseca | SP: 1.Wanchope ------------------------------------------------------match (id, player_home - player_away, score): 2 , 3.Poland - 4.Ecuador , 0 - 2 -location: Gelsenkirchen , date: 9-6-2006 , referee: --goal: | T23 , SP: 2.Tenorio (P: 4.Ecuador) | T80 , SP: 3.Delgado (P: 4.Ecuador) ---reprt_match: | T30 , SP: 1.Hurtado (P: 4.Ecuador) , yellow_card | T35 , SP: 2.Smolarek (P: 3.Poland) , yellow_card | T69 , SP: 4.Mendez (P: 4.Ecuador) , yellow_card ----lineup player_home : | SP: 2.Smolarek | SP: 1.Zurawski ----lineup player_away : | SP: 4.Mendez | SP: 3.Delgado | SP: 2.Tenorio | SP: 1.Hurtado ------------------------------------------------------match (id, player_home - player_away, score): 3 , 5.England - 6.Paraguay , 1 - 0 -location: Frankfurt , date: 10-6-2006 , referee: --goal: | T3 , SP: 5.NN (P: 5.England) ---reprt_match: | T18 , SP: 6.Gerard (P: 5.England) , yellow_card | T22 , SP: 2.Valdez (P: 6.Paraguay) , yellow_card | T63 , SP: 7.Crouch (P: 5.England) , yellow_card ----lineup player_home : | SP: 7.Crouch | SP: 6.Gerard | SP: 5.NN | SP: 4.Rooney | SP: 3.Owen | SP: 2.Beckham | SP: 1.Lampard ----lineup player_away : | SP: 2.Valdez | SP: 1.Cardozo ------------------------------------------------------match (id, player_home - player_away, score): 4 , 7.Trinidad & Tobago - 8.Sweden , 0 - 0 -location: Dortmund , date: 10-6-2006 , referee: ---reprt_match: | T15 , SP: 2.John (P: 7.Trinidad & Tobago) , yellow_card | T46 , SP: 2.John (P: 7.Trinidad & Tobago) , yellow_card | T74 , SP: 1.Yorke (P: 7.Trinidad & Tobago) , yellow_card ----lineup player_home : | SP: 2.John | SP: 1.Yorke ----lineup player_away : | SP: 2.Larsson | SP: 1.Ibrahimovic ------------------------------------------------------match (id, player_home - player_away, score): 5 , 9.Argentina - 10.Côte d’Ivoir , 2 - 1 -location: Hamburg , date: 10-6-2006 , referee: 19
--goal: | T24 , SP: 11.Crespo (P: 9.Argentina) | T40 , SP: 12.Saviola (P: 9.Argentina) | T81 , SP: 1.Drogba (P: 10.Côte d’Ivoir) ---reprt_match: | T40 , SP: 12.Saviola (P: 9.Argentina) , yellow_card | T49 , SP: 2.Heinze (P: 9.Argentina) , yellow_card | T61 , SP: 2.Eboué (P: 10.Côte d’Ivoir) , yellow_card | T81 , SP: 13.Gonzalez (P: 9.Argentina) , yellow_card ----lineup player_home : | SP: 1.Abbondanzieri ,POS: 1 | SP: 2.Heinze ,POS: 2 | SP: 3.Ayala ,POS: 3 | SP: 4.Zanetti ,POS: 4 | SP: 5.Samuel ,POS: 5 | SP: 6.Sorin ,POS: 6 | SP: 7.Riquelme (C) ,POS: 7 | SP: 8.Messi ,POS: 8 | SP: 13.Gonzalez ,POS: 9 | SP: 9.Tevez ,POS: 9 | SP: 12.Saviola ,POS: 10 | SP: 10.Cambiasso ,POS: 10 | SP: 11.Crespo ,POS: 11 ----lineup player_away : | SP: 2.Eboué ,POS: 2 | SP: 1.Drogba ,POS: 10 ------------------------------------------------------match (id, player_home - player_away, score): 6 , 11.Serbia & Montenegro - 12.Netherlands , 0 - 1 -location: Leipzig , date: 11-6-2006 , referee: --goal: | T17 , SP: 10.Robben (P: 12.Netherlands) ---reprt_match: | T33 , SP: 2.Stankovic (P: 11.Serbia & Montenegro) , yellow_card | T55 , SP: 2.Bronkhorst van (P: 12.Netherlands) , yellow_card | T63 , SP: 3.Koroman (P: 11.Serbia & Montenegro) , yellow_card | T80 , SP: 4.Dragutinovic (P: 11.Serbia & Montenegro) , yellow_card | T84 , SP: 14.Heitinga (P: 12.Netherlands) , yellow_card | T89 , SP: 5.Gavrancic (P: 11.Serbia & Montenegro) , yellow_card ----lineup player_home : | SP: 5.Gavrancic | SP: 4.Dragutinovic | SP: 3.Koroman | SP: 2.Stankovic | SP: 1.Kezman ----lineup player_away : | SP: 7.Landzaat Tin: 59 | SP: 9.Kuyt Tin: 68 | SP: 5.Boulahrouz Tin: 85 | SP: 1.Sar van der (C) ,POS: 1 , PER: 7 | SP: 2.Bronkhorst van ,POS: 2 , PER: 6,5 | SP: 3.Mathijsen ,POS: 3 , PER: 5,5 Tout: 85 | SP: 4.Ooijer ,POS: 4 , PER: 8 | SP: 14.Heitinga ,POS: 5 , PER: 6,5 | SP: 6.Cocu ,POS: 6 , PER: 6,5 | SP: 15.Bommel van ,POS: 7 , PER: 7 Tout: 59 | SP: 16.Sneijder ,POS: 8 , PER: 5 | SP: 13.Persie van ,POS: 9 , PER: 6,5 | SP: 10.Robben ,POS: 10 , PER: 8 | SP: 11.Nistelrooy van ,POS: 11 , PER: 5 Tout: 68 ------------------------------------------------------match (id, player_home - player_away, score): 7 , 13.Mexico - 14.Iran , 3 - 1 -location: Nurnberg , date: 11-6-2006 , referee: --goal: | T27 , SP: 3.Bravo (P: 13.Mexico) | T35 , SP: 2.Golmohammadi (P: 14.Iran) | T75 , SP: 3.Bravo (P: 13.Mexico) | T78 , SP: 2.Zinha (P: 13.Mexico) ---reprt_match: | T17 , SP: 4.Torrado (P: 13.Mexico) , yellow_card | T53 , SP: 3.Nekounam (P: 14.Iran) , yellow_card | T89 , SP: 5.Salcido (P: 13.Mexico) , yellow_card ----lineup player_home : | SP: 5.Salcido | SP: 4.Torrado | SP: 3.Bravo | SP: 2.Zinha | SP: 1.Borgetti ----lineup player_away : | SP: 3.Nekounam | SP: 2.Golmohammadi | SP: 1.Daei ------------------------------------------------------match (id, player_home - player_away, score): 8 , 15.Angola - 16.Portugal , 0 - 1 -location: Koln , date: 11-6-2006 , referee: --goal: | T3 , SP: 3.Pauleta (P: 16.Portugal) ---reprt_match: | T24 , SP: 1.Ronaldo (P: 16.Portugal) , yellow_card | T25 , SP: 2.Jamba (P: 15.Angola) , yellow_card | T44 , SP: 3.Loco (P: 15.Angola) , yellow_card | T52 , SP: 4.Andre (P: 15.Angola) , yellow_card | T79 , SP: 4.Valente (P: 16.Portugal) , yellow_card
20
----lineup player_home : | SP: 4.Andre | SP: 3.Loco | SP: 2.Jamba | SP: 1.Manuel ----lineup player_away : | SP: 4.Valente | SP: 3.Pauleta | SP: 2.Figo | SP: 1.Ronaldo ------------------------------------------------------match (id, player_home - player_away, score): 9 , 23.Australia - 24.Japan , 3 - 1 -location: Kaiserslautern , date: 12-6-2006 , referee: --goal: | T26 , SP: 2.Nakamura (P: 24.Japan) | T84 , SP: 3.Cahill (P: 23.Australia) | T89 , SP: 3.Cahill (P: 23.Australia) | T90 , SP: 2.Aloisi (P: 23.Australia) ---reprt_match: | T31 , SP: 3.Miyamoto (P: 24.Japan) , yellow_card | T33 , SP: 4.Grella (P: 23.Australia) , yellow_card | T40 , SP: 4.Takahara (P: 24.Japan) , yellow_card | T57 , SP: 5.Moore (P: 23.Australia) , yellow_card | T68 , SP: 5.Moniwa (P: 24.Japan) , yellow_card | T69 , SP: 3.Cahill (P: 23.Australia) , yellow_card | T77 , SP: 2.Aloisi (P: 23.Australia) , yellow_card ----lineup player_home : | SP: 5.Moore | SP: 4.Grella | SP: 3.Cahill | SP: 2.Aloisi | SP: 1.Viduka ----lineup player_away : | SP: 5.Moniwa | SP: 4.Takahara | SP: 3.Miyamoto | SP: 2.Nakamura | SP: 1.Ono ------------------------------------------------------match (id, player_home - player_away, score): 10 , 19.USA - 20.Czech Republic , 0 - 3 -location: Gelsenkirchen , date: 12-6-2006 , referee: --goal: | T5 , SP: 4.Koller (P: 20.Czech Republic) | T36 , SP: 3.Rosicky (P: 20.Czech Republic) | T76 , SP: 3.Rosicky (P: 20.Czech Republic) ---reprt_match: | T4 , SP: 2.Onyewu (P: 19.USA) , yellow_card | T16 , SP: 5.Rozehnal (P: 20.Czech Republic) , yellow_card | T59 , SP: 6.Lokvenc (P: 20.Czech Republic) , yellow_card | T60 , SP: 1.Reyna (P: 19.USA) , yellow_card | T81 , SP: 3.Rosicky (P: 20.Czech Republic) , yellow_card | T88 , SP: 7.Grygera (P: 20.Czech Republic) , yellow_card ----lineup player_home : | SP: 2.Onyewu | SP: 1.Reyna ----lineup player_away : | SP: 7.Grygera | SP: 6.Lokvenc | SP: 5.Rozehnal | SP: 4.Koller | SP: 3.Rosicky | SP: 2.Baros | SP: 1.Nedved ------------------------------------------------------match (id, player_home - player_away, score): 11 , 17.Italy - 18.Ghana , 2 - 0 -location: Hannover , date: 12-6-2006 , referee: --goal: | T39 , SP: 3.Pirlo (P: 17.Italy) | T82 , SP: 4.Iaquinta (P: 17.Italy) ---reprt_match: | T10 , SP: 5.De Rossi (P: 17.Italy) , yellow_card | T41 , SP: 2.Muntari (P: 18.Ghana) , yellow_card | T62 , SP: 6.Camoranesi (P: 17.Italy) , yellow_card | T65 , SP: 3.Gyan (P: 18.Ghana) , yellow_card | T88 , SP: 4.Iaquinta (P: 17.Italy) , yellow_card ----lineup player_home : | SP: 6.Camoranesi | SP: 5.De Rossi | SP: 4.Iaquinta | SP: 3.Pirlo | SP: 2.Vieri | SP: 1.Totti ----lineup player_away : | SP: 3.Gyan | SP: 2.Muntari | SP: 1.Essien ------------------------------------------------------match (id, player_home - player_away, score): 12 , 27.South Korea - 28.Togo , 2 - 1 -location: Frankfurt , date: 13-6-2006 , referee: --goal: | T29 , SP: 2.Mohamed (P: 28.Togo) | T53 , SP: 3.Soo Lee (P: 27.South Korea) | T71 , SP: 2.Hwan Ahn (P: 27.South Korea) ---reprt_match: | T21 , SP: 3.Abalo (P: 28.Togo) , yellow_card | T22 , SP: 4.Romao (P: 28.Togo) , yellow_card | T38 , SP: 4.Chul Kim (P:
21
27.South Korea) , yellow_card | T50 , SP: 3.Soo Lee (P: 27.South Korea) , yellow_card | T52 , SP: 3.Abalo (P: 28.Togo) , yellow_card | T89 , SP: 5.Tchangai (P: 28.Togo) , yellow_card ----lineup player_home : | SP: 4.Chul Kim | SP: 3.Soo Lee | SP: 2.Hwan Ahn | SP: 1.Park ----lineup player_away : | SP: 5.Tchangai | SP: 4.Romao | SP: 3.Abalo | SP: 2.Mohamed | SP: 1.Adebayor ------------------------------------------------------match (id, player_home - player_away, score): 13 , 25.France - 26.Switzerland , 0 - 0 -location: Stuttgart , date: 13-6-2006 , referee: ---reprt_match: | T42 , SP: 2.Magnin (P: 26.Switzerland) , yellow_card | T45 , SP: 3.Streller (P: 26.Switzerland) , yellow_card | T56 , SP: 4.Degen (P: 26.Switzerland) , yellow_card | T64 , SP: 4.Abidal (P: 25.France) , yellow_card | T72 , SP: 2.Zidane (P: 25.France) , yellow_card | T72 , SP: 5.Cabanas (P: 26.Switzerland) , yellow_card | T90 , SP: 1.Frei (P: 26.Switzerland) , yellow_card | T90 , SP: 5.Sagnol (P: 25.France) , yellow_card ----lineup player_home : | SP: 5.Sagnol | SP: 4.Abidal | SP: 3.Trezeguet | SP: 2.Zidane | SP: 1.Henry ----lineup player_away : | SP: 5.Cabanas | SP: 4.Degen | SP: 3.Streller | SP: 2.Magnin | SP: 1.Frei ------------------------------------------------------match (id, player_home - player_away, score): 14 , 21.Brazil - 22.Croatia , 1 - 0 -location: Berlin , date: 13-6-2006 , referee: --goal: | T44 , SP: 5.Kaka (P: 21.Brazil) ----lineup player_home : | SP: 5.Kaka | SP: 4.Emerson | SP: 3.Carlos | SP: 2.Ronaldo | SP: 1.Ronaldinho ----lineup player_away : | SP: 1.Srna ------------------------------------------------------match (id, player_home - player_away, score): 15 , 29.Spain - 30.Ukraine , 4 - 0 -location: Leipzig , date: 14-6-2006 , referee: --goal: | T12 , SP: 1.Alonso (P: 29.Spain) | T15 , SP: 3.Villa (P: 29.Spain) | T47 , SP: 3.Villa (P: 29.Spain) (PNL) | T80 , SP: 4.Torres (P: 29.Spain) ----lineup player_home : | SP: 4.Torres | SP: 3.Villa | SP: 2.Raul | SP: 1.Alonso ----lineup player_away : | SP: 1.Sjevtsjenko ------------------------------------------------------match (id, player_home - player_away, score): 16 , 31.Tunisia - 32.Saudi Arabia , 2 - 2 -location: Munchen , date: 14-6-2006 , referee: --goal: | T23 , SP: 2.Jaziri (P: 31.Tunisia) | T57 , SP: 2.Kahtani (P: 32.Saudi Arabia) | T84 , SP: 3.Al Jaber (P: 32.Saudi Arabia) | T90 , SP: 3.Jaidi (P: 31.Tunisia) ----lineup player_home : | SP: 3.Jaidi | SP: 2.Jaziri | SP: 1.Trabelsi ----lineup player_away : | SP: 3.Al Jaber | SP: 2.Kahtani | SP: 1.Montashari ------------------------------------------------------match (id, player_home - player_away, score): 17 , 1.Germany - 3.Poland , 1 - 0 -location: Dortmund , date: 14-6-2006 , referee:
22
--goal: | T89 , SP: 5.Neuville (P: 1.Germany) ----lineup player_home : | SP: 5.Neuville | SP: 4.Frings | SP: 3.Lahm | SP: 2.Klose | SP: 1.Ballack ----lineup player_away : | SP: 2.Smolarek | SP: 1.Zurawski ------------------------------------------------------match (id, player_home - player_away, score): 18 , 4.Ecuador - 2.Costa Rica , 3 - 0 -location: Hamburg , date: 15-6-2006 , referee: --goal: | T7 , SP: 2.Tenorio (P: 4.Ecuador) | T53 , SP: 3.Delgado (P: 4.Ecuador) | T89 , SP: 5.Kaviedes (P: 4.Ecuador) ----lineup player_home : | SP: 5.Kaviedes | SP: 4.Mendez | SP: 3.Delgado | SP: 2.Tenorio | SP: 1.Hurtado ----lineup player_away : | SP: 2.Fonseca | SP: 1.Wanchope ------------------------------------------------------match (id, player_home - player_away, score): 19 , 5.England - 7.Trinidad & Tobago , 2 - 0 -location: Nurnberg , date: 15-6-2006 , referee: --goal: | T83 , SP: 7.Crouch (P: 5.England) | T90 , SP: 6.Gerard (P: 5.England) ----lineup player_home : | SP: 7.Crouch | SP: 6.Gerard | SP: 5.NN | SP: 4.Rooney | SP: 3.Owen | SP: 2.Beckham | SP: 1.Lampard ----lineup player_away : | SP: 2.John | SP: 1.Yorke ------------------------------------------------------match (id, player_home - player_away, score): 20 , 8.Sweden - 6.Paraguay , 1 - 0 -location: Berlin , date: 15-6-2006 , referee: --goal: | T89 , SP: 3.Ljungberg (P: 8.Sweden) ----lineup player_home : | SP: 3.Ljungberg | SP: 2.Larsson | SP: 1.Ibrahimovic ----lineup player_away : | SP: 2.Valdez | SP: 1.Cardozo ------------------------------------------------------match (id, player_home - player_away, score): 21 , 9.Argentina - 11.Serbia & Montenegro , 6 - 0 -location: Gelsenkirchen , date: 16-6-2006 , referee: --goal: | T5 , SP: 14.Rodriguez (P: 9.Argentina) | T31 , SP: 10.Cambiasso (P: 9.Argentina) | T41 , SP: 14.Rodriguez (P: 9.Argentina) | T78 , SP: 11.Crespo (P: 9.Argentina) | T84 , SP: 9.Tevez (P: 9.Argentina) | T88 , SP: 8.Messi (P: 9.Argentina) ----lineup player_home : | SP: 14.Rodriguez | SP: 13.Gonzalez | SP: 12.Saviola | SP: 1.Abbondanzieri ,POS: 1 | SP: 2.Heinze ,POS: 2 | SP: 3.Ayala ,POS: 3 | SP: 4.Zanetti ,POS: 4 | SP: 5.Samuel ,POS: 5 | SP: 6.Sorin ,POS: 6 | SP: 7.Riquelme (C) ,POS: 7 | SP: 8.Messi ,POS: 8 | SP: 9.Tevez ,POS: 9 | SP: 10.Cambiasso ,POS: 10 | SP: 11.Crespo ,POS: 11 ----lineup player_away : | SP: 5.Gavrancic | SP: 4.Dragutinovic | SP: 3.Koroman | SP: 2.Stankovic | SP: 1.Kezman ------------------------------------------------------match (id, player_home - player_away, score): 22 , 12.Netherlands - 10.Côte d’Ivoir , 2 - 1 -location: Stuttgart , date: 16-6-2006 , referee: --goal: | T22 , SP: 13.Persie van (P: 12.Netherlands) | T27 , SP: 11.Nistelrooy van (P: 12.Netherlands) | T37 , SP: 3.Kone (P: 10.Côte d’Ivoir) ---reprt_match: | T34 , SP: 10.Robben (P: 12.Netherlands) , yellow_card | T35 , SP: 3.Mathijsen (P: 12.Netherlands) , yellow_card | T57 , SP: 15.Bommel van (P: 12.Netherlands) , yellow_card | T89 , SP: 5.Boulahrouz (P: 12.Netherlands) , yellow_card
23
----lineup player_home : | SP: 8.Vaart van der Tin: 49 | SP: 7.Landzaat Tin: 73 | SP: 1.Sar van der (C) ,POS: 1 , PER: 7 | SP: 2.Bronkhorst van ,POS: 2 , PER: 6,5 | SP: 3.Mathijsen ,POS: 3 , PER: 6,5 | SP: 4.Ooijer ,POS: 4 , PER: 5 | SP: 14.Heitinga ,POS: 5 , PER: 5,5 Tout: 46 | SP: 5.Boulahrouz ,POS: 5 , PER: 7 Tin: 46 | SP: 6.Cocu ,POS: 6 , PER: 6 | SP: 15.Bommel van ,POS: 7 , PER: 6 | SP: 16.Sneijder ,POS: 8 , PER: 6 Tout: 49 | SP: 13.Persie van ,POS: 9 , PER: 7,5 | SP: 10.Robben ,POS: 10 , PER: 6,5 | SP: 11.Nistelrooy van ,POS: 11 , PER: 6 Tout: 73 ----lineup player_away : | SP: 3.Kone | SP: 2.Eboué ,POS: 2 | SP: 1.Drogba ,POS: 10 ------------------------------------------------------match (id, player_home - player_away, score): 23 , 13.Mexico - 15.Angola , 0 - 0 -location: Hannover , date: 16-6-2006 , referee: ----lineup player_home : | SP: 5.Salcido | SP: 4.Torrado | SP: 3.Bravo | SP: 2.Zinha | SP: 1.Borgetti ----lineup player_away : | SP: 4.Andre | SP: 3.Loco | SP: 2.Jamba | SP: 1.Manuel ------------------------------------------------------match (id, player_home - player_away, score): 24 , 16.Portugal - 14.Iran , 2 - 0 -location: Frankfurt , date: 17-6-2006 , referee: --goal: | T63 , SP: 5.Deco (P: 16.Portugal) | T78 , SP: 1.Ronaldo (P: 16.Portugal) ----lineup player_home : | SP: 5.Deco | SP: 4.Valente | SP: 3.Pauleta | SP: 2.Figo | SP: 1.Ronaldo ----lineup player_away : | SP: 3.Nekounam | SP: 2.Golmohammadi | SP: 1.Daei ------------------------------------------------------match (id, player_home - player_away, score): 25 , 20.Czech Republic - 18.Ghana , 0 - 2 -location: Koln , date: 17-6-2006 , referee: --goal: | T1 , SP: 3.Gyan (P: 18.Ghana) | T81 , SP: 2.Muntari (P: 18.Ghana) ----lineup player_home : | SP: 7.Grygera | SP: 6.Lokvenc | SP: 5.Rozehnal | SP: 4.Koller | SP: 3.Rosicky | SP: 2.Baros | SP: 1.Nedved ----lineup player_away : | SP: 3.Gyan | SP: 2.Muntari | SP: 1.Essien ------------------------------------------------------match (id, player_home - player_away, score): 26 , 17.Italy - 19.USA , 1 - 1 -location: Kaiserslautern , date: 17-6-2006 , referee: --goal: | T22 , SP: 7.Gilardino (P: 17.Italy) | T27 , SP: 3.NN (P: 19.USA) ----lineup player_home : | SP: 8.NN | SP: 7.Gilardino | SP: 6.Camoranesi | SP: 5.De Rossi | SP: 4.Iaquinta | SP: 3.Pirlo | SP: 2.Vieri | SP: 1.Totti ----lineup player_away : | SP: 3.NN | SP: 2.Onyewu | SP: 1.Reyna ------------------------------------------------------match (id, player_home - player_away, score): 27 , 24.Japan - 22.Croatia , 0 - 0 -location: Nurnberg , date: 18-6-2006 , referee: ----lineup player_home : | SP: 5.Moniwa | SP: 4.Takahara | SP: 3.Miyamoto | SP: 2.Nakamura | SP: 1.Ono ----lineup player_away : | SP: 1.Srna ------------------------------------------------------match (id, player_home - player_away, score): 28 , 21.Brazil - 23.Australia , 2 - 0 -location: Munchen , date: 18-6-2006 , referee: --goal: | T49 , SP: 6.Adriano (P: 21.Brazil) | T89 , SP: 7.Fred (P: 21.Brazil) ----lineup player_home : | SP: 7.Fred | SP: 6.Adriano | SP: 5.Kaka | SP: 4.Emerson | SP: 3.Carlos | SP: 2.Ronaldo | SP: 1.Ronaldinho
24
----lineup player_away : | SP: 5.Moore | SP: 4.Grella | SP: 3.Cahill | SP: 2.Aloisi | SP: 1.Viduka ------------------------------------------------------match (id, player_home - player_away, score): 29 , 25.France - 27.South Korea , 1 - 1 -location: Leipzig , date: 18-6-2006 , referee: --goal: | T8 , SP: 1.Henry (P: 25.France) | T80 , SP: 1.Park (P: 27.South Korea) ----lineup player_home : | SP: 5.Sagnol | SP: 4.Abidal | SP: 3.Trezeguet | SP: 2.Zidane | SP: 1.Henry ----lineup player_away : | SP: 4.Chul Kim | SP: 3.Soo Lee | SP: 2.Hwan Ahn | SP: 1.Park ------------------------------------------------------match (id, player_home - player_away, score): 30 , 28.Togo - 26.Switzerland , 0 - 2 -location: Dortmund , date: 19-6-2006 , referee: --goal: | T15 , SP: 1.Frei (P: 26.Switzerland) | T87 , SP: 6.Barnetta (P: 26.Switzerland) ----lineup player_home : | SP: 5.Tchangai | SP: 4.Romao | SP: 3.Abalo | SP: 2.Mohamed | SP: 1.Adebayor ----lineup player_away : | SP: 6.Barnetta | SP: 5.Cabanas | SP: 4.Degen | SP: 3.Streller | SP: 2.Magnin | SP: 1.Frei ------------------------------------------------------match (id, player_home - player_away, score): 31 , 32.Saudi Arabia - 30.Ukraine , 0 - 4 -location: Hamburg , date: 19-6-2006 , referee: --goal: | T3 , SP: 2.Rusol (P: 30.Ukraine) | T36 , SP: 3.Rebrov (P: 30.Ukraine) | T46 , SP: 1.Sjevtsjenko (P: 30.Ukraine) | T82 , SP: 4.Kalinichenko (P: 30.Ukraine) ----lineup player_home : | SP: 3.Al Jaber | SP: 2.Kahtani | SP: 1.Montashari ----lineup player_away : | SP: 4.Kalinichenko | SP: 3.Rebrov | SP: 2.Rusol | SP: 1.Sjevtsjenko ------------------------------------------------------match (id, player_home - player_away, score): 32 , 29.Spain - 31.Tunisia , 3 - 1 -location: Stuttgart , date: 19-6-2006 , referee: --goal: | T7 , SP: 4.Mnari (P: 31.Tunisia) | T70 , SP: 2.Raul (P: 29.Spain) | T75 , SP: 4.Torres (P: 29.Spain) | T88 , SP: 4.Torres (P: 29.Spain) (PNL) ----lineup player_home : | SP: 4.Torres | SP: 3.Villa | SP: 2.Raul | SP: 1.Alonso ----lineup player_away : | SP: 4.Mnari | SP: 3.Jaidi | SP: 2.Jaziri | SP: 1.Trabelsi ------------------------------------------------------match (id, player_home - player_away, score): 33 , 4.Ecuador - 1.Germany , 0 - 3 -location: Berlin , date: 20-6-2006 , referee: --goal: | T4 , SP: 2.Klose (P: 1.Germany) | T44 , SP: 2.Klose (P: 1.Germany) | T57 , SP: 6.Podolski (P: 1.Germany) ----lineup player_home : | SP: 6.Valencia | SP: 5.Kaviedes | SP: 4.Mendez | SP: 3.Delgado | SP: 2.Tenorio | SP: 1.Hurtado ----lineup player_away : | SP: 6.Podolski | SP: 5.Neuville | SP: 4.Frings | SP: 3.Lahm | SP: 2.Klose | SP: 1.Ballack ------------------------------------------------------match (id, player_home - player_away, score): 34 , 2.Costa Rica - 3.Poland , 1 - 2 -location: Hannover , date: 20-6-2006 , referee:
25
--goal: | T25 , SP: 3.Gomez (P: 2.Costa Rica) | T33 , SP: 3.Bosacki (P: 3.Poland) | T67 , SP: 3.Bosacki (P: 3.Poland) ----lineup player_home : | SP: 3.Gomez | SP: 2.Fonseca | SP: 1.Wanchope ----lineup player_away : | SP: 3.Bosacki | SP: 2.Smolarek | SP: 1.Zurawski ------------------------------------------------------match (id, player_home - player_away, score): 35 , 6.Paraguay - 7.Trinidad & Tobago , 2 - 0 -location: Kaiserslautern , date: 20-6-2006 , referee: --goal: | T25 , SP: 3.NN (P: 6.Paraguay) | T86 , SP: 4.Cuevas (P: 6.Paraguay) ----lineup player_home : | SP: 4.Cuevas | SP: 3.NN | SP: 2.Valdez | SP: 1.Cardozo ----lineup player_away : | SP: 2.John | SP: 1.Yorke ------------------------------------------------------match (id, player_home - player_away, score): 36 , 8.Sweden - 5.England , 2 - 2 -location: Koln , date: 20-6-2006 , referee: --goal: | T33 , SP: 8.Cole (P: 5.England) | T50 , SP: 4.Allback (P: 8.Sweden) | T84 , SP: 6.Gerard (P: 5.England) | T89 , SP: 2.Larsson (P: 8.Sweden) ----lineup player_home : | SP: 4.Allback | SP: 3.Ljungberg | SP: 2.Larsson | SP: 1.Ibrahimovic ----lineup player_away : | SP: 8.Cole | SP: 7.Crouch | SP: 6.Gerard | SP: 5.NN | SP: 4.Rooney | SP: 3.Owen | SP: 2.Beckham | SP: 1.Lampard ------------------------------------------------------match (id, player_home - player_away, score): 37 , 16.Portugal - 13.Mexico , 2 - 1 -location: Gelsenkirchen , date: 21-6-2006 , referee: --goal: | T5 , SP: 6.Maniche (P: 16.Portugal) | T23 , SP: 7.Simao (P: 16.Portugal) (PNL) | T31 , SP: 6.Fonseca (P: 13.Mexico) ----lineup player_home : | SP: 7.Simao | SP: 6.Maniche | SP: 5.Deco | SP: 4.Valente | SP: 3.Pauleta | SP: 2.Figo | SP: 1.Ronaldo ----lineup player_away : | SP: 6.Fonseca | SP: 5.Salcido | SP: 4.Torrado | SP: 3.Bravo | SP: 2.Zinha | SP: 1.Borgetti ------------------------------------------------------match (id, player_home - player_away, score): 38 , 14.Iran - 15.Angola , 1 - 1 -location: Leipzig , date: 21-6-2006 , referee: --goal: | T60 , SP: 5.Flavio (P: 15.Angola) | T75 , SP: 4.Bakhtiarizadeh (P: 14.Iran) ----lineup player_home : | SP: 4.Bakhtiarizadeh | SP: 3.Nekounam | SP: 2.Golmohammadi | SP: 1.Daei ----lineup player_away : | SP: 5.Flavio | SP: 4.Andre | SP: 3.Loco | SP: 2.Jamba | SP: 1.Manuel ------------------------------------------------------match (id, player_home - player_away, score): 39 , 12.Netherlands - 9.Argentina , 0 - 0 -location: Frankfurt , date: 21-6-2006 , referee: ---reprt_match: | T27 , SP: 9.Kuyt (P: 12.Netherlands) , yellow_card | T42 , SP: 4.Ooijer (P: 12.Netherlands) , yellow_card | T48 , SP: 18.Cler de (P: 12.Netherlands) , yellow_card ----lineup player_home : | SP: 19.Babel Tin: 55 | SP: 7.Landzaat Tin: 66 | SP: 12.Maduro Tin: 85 | SP: 1.Sar van der (C) ,POS: 1 , PER: 7,5 | SP: 17.Jaliens ,POS: 2 , PER: 5,5 | SP: 18.Cler de ,POS: 3 , PER: 7 | SP: 4.Ooijer ,POS: 4 , PER: 7 | SP: 5.Boulahrouz ,POS: 5 , PER: 8 | SP: 6.Cocu
26
,POS: 6 , PER: 5 | SP: 8.Vaart van der ,POS: 8 , PER: 6,5 | SP: 13.Persie van ,POS: 9 , PER: 6 Tout: 66 | SP: 9.Kuyt ,POS: 9 , PER: 5,5 | SP: 16.Sneijder ,POS: 10 , PER: 7 Tout: 85 | SP: 11.Nistelrooy van ,POS: 11 , PER: 5,5 Tout: 55 ----lineup player_away : | SP: 14.Rodriguez | SP: 13.Gonzalez | SP: 12.Saviola | SP: 1.Abbondanzieri ,POS: 1 | SP: 2.Heinze ,POS: 2 | SP: 3.Ayala ,POS: 3 | SP: 4.Zanetti ,POS: 4 | SP: 5.Samuel ,POS: 5 | SP: 6.Sorin ,POS: 6 | SP: 7.Riquelme (C) ,POS: 7 | SP: 8.Messi ,POS: 8 | SP: 9.Tevez ,POS: 9 | SP: 10.Cambiasso ,POS: 10 | SP: 11.Crespo ,POS: 11 ------------------------------------------------------match (id, player_home - player_away, score): 40 , 10.Côte d’Ivoir - 11.Serbia & Montenegro , 3 - 2 -location: Munchen , date: 21-6-2006 , referee: --goal: | T10 , SP: 6.Zigic (P: 11.Serbia & Montenegro) | T22 , SP: 7.Ilic (P: 11.Serbia & Montenegro) | T37 , SP: 4.Dindane (P: 10.Côte d’Ivoir) (PNL) | T67 , SP: 4.Dindane (P: 10.Côte d’Ivoir) | T86 , SP: 5.Kalou (P: 10.Côte d’Ivoir) (PNL) ----lineup player_home : | SP: 5.Kalou | SP: 4.Dindane | SP: 3.Kone | SP: 2.Eboué ,POS: 2 | SP: 1.Drogba ,POS: 10 ----lineup player_away : | SP: 7.Ilic | SP: 6.Zigic | SP: 5.Gavrancic | SP: 4.Dragutinovic | SP: 3.Koroman | SP: 2.Stankovic | SP: 1.Kezman ------------------------------------------------------match (id, player_home - player_away, score): 41 , 20.Czech Republic - 17.Italy , 0 - 2 -location: Hamburg , date: 22-6-2006 , referee: --goal: | T25 , SP: 9.Materazzi (P: 17.Italy) | T87 , SP: 10.Inzaghi (P: 17.Italy) ----lineup player_home : | SP: 7.Grygera | SP: 6.Lokvenc | SP: 5.Rozehnal | SP: 4.Koller | SP: 3.Rosicky | SP: 2.Baros | SP: 1.Nedved ----lineup player_away : | SP: 10.Inzaghi | SP: 9.Materazzi | SP: 8.NN | SP: 7.Gilardino | SP: 6.Camoranesi | SP: 5.De Rossi | SP: 4.Iaquinta | SP: 3.Pirlo | SP: 2.Vieri | SP: 1.Totti ------------------------------------------------------match (id, player_home - player_away, score): 42 , 18.Ghana - 19.USA , 2 - 1 -location: Nurnberg , date: 22-6-2006 , referee: --goal: | T23 , SP: 4.Dramani (P: 18.Ghana) | T43 , SP: 4.Dempsey (P: 19.USA) | T45 , SP: 5.Appiah (P: 18.Ghana) (PNL) ----lineup player_home : | SP: 5.Appiah | SP: 4.Dramani | SP: 3.Gyan | SP: 2.Muntari | SP: 1.Essien ----lineup player_away : | SP: 4.Dempsey | SP: 3.NN | SP: 2.Onyewu | SP: 1.Reyna ------------------------------------------------------match (id, player_home - player_away, score): 43 , 24.Japan - 21.Brazil , 1 - 4 -location: Dortmund , date: 22-6-2006 , referee: --goal: | T32 , SP: 6.Tamada (P: 24.Japan) | T45 , SP: 2.Ronaldo (P: 21.Brazil) | T52 , SP: 8.Pernambucano (P: 21.Brazil) | T57 , SP: 9.Gilberto (P: 21.Brazil) | T77 , SP: 2.Ronaldo (P: 21.Brazil) ----lineup player_home : | SP: 6.Tamada | SP: 5.Moniwa | SP: 4.Takahara | SP: 3.Miyamoto | SP: 2.Nakamura | SP: 1.Ono ----lineup player_away : | SP: 9.Gilberto | SP: 8.Pernambucano | SP: 7.Fred | SP: 6.Adriano | SP: 5.Kaka | SP: 4.Emerson | SP: 3.Carlos | SP: 2.Ronaldo | SP: 1.Ronaldinho ------------------------------------------------------match (id, player_home - player_away, score): 44 , 22.Croatia - 23.Australia , 2 - 2 -location: Stuttgart , date: 22-6-2006 , referee:
27
--goal: | T2 , SP: 1.Srna (P: 22.Croatia) | T38 , SP: 5.Moore (P: 23.Australia) (PNL) | T56 , SP: 2.Kovac (P: 22.Croatia) | T78 , SP: 6.Kewell (P: 23.Australia) ----lineup player_home : | SP: 2.Kovac | SP: 1.Srna ----lineup player_away : | SP: 6.Kewell | SP: 5.Moore | SP: 4.Grella | SP: 3.Cahill | SP: 2.Aloisi | SP: 1.Viduka ------------------------------------------------------match (id, player_home - player_away, score): 45 , 30.Ukraine - 31.Tunisia , 1 - 0 -location: Berlin , date: 23-6-2006 , referee: --goal: | T69 , SP: 1.Sjevtsjenko (P: 30.Ukraine) (PNL) ----lineup player_home : | SP: 4.Kalinichenko | SP: 3.Rebrov | SP: 2.Rusol | SP: 1.Sjevtsjenko ----lineup player_away : | SP: 4.Mnari | SP: 3.Jaidi | SP: 2.Jaziri | SP: 1.Trabelsi ------------------------------------------------------match (id, player_home - player_away, score): 46 , 32.Saudi Arabia - 29.Spain , 0 - 1 -location: Kaiserslautern , date: 23-6-2006 , referee: --goal: | T36 , SP: 5.Juanito (P: 29.Spain) ----lineup player_home : | SP: 3.Al Jaber | SP: 2.Kahtani | SP: 1.Montashari ----lineup player_away : | SP: 5.Juanito | SP: 4.Torres | SP: 3.Villa | SP: 2.Raul | SP: 1.Alonso ------------------------------------------------------match (id, player_home - player_away, score): 47 , 26.Switzerland - 27.South Korea , 2 - 0 -location: Hannover , date: 23-6-2006 , referee: --goal: | T23 , SP: 7.Senderos (P: 26.Switzerland) | T77 , SP: 1.Frei (P: 26.Switzerland) ----lineup player_home : | SP: 7.Senderos | SP: 6.Barnetta | SP: 5.Cabanas | SP: 4.Degen | SP: 3.Streller | SP: 2.Magnin | SP: 1.Frei ----lineup player_away : | SP: 4.Chul Kim | SP: 3.Soo Lee | SP: 2.Hwan Ahn | SP: 1.Park ------------------------------------------------------match (id, player_home - player_away, score): 48 , 28.Togo - 25.France , 0 - 2 -location: Koln , date: 23-6-2006 , referee: --goal: | T54 , SP: 6.Vieira (P: 25.France) | T60 , SP: 1.Henry (P: 25.France) ----lineup player_home : | SP: 5.Tchangai | SP: 4.Romao | SP: 3.Abalo | SP: 2.Mohamed | SP: 1.Adebayor ----lineup player_away : | SP: 6.Vieira | SP: 5.Sagnol | SP: 4.Abidal | SP: 3.Trezeguet | SP: 2.Zidane | SP: 1.Henry ------------------------------------------------------match (id, player_home - player_away, score): 10001 , 1.Germany - 8.Sweden , 2 - 0 -location: Munchen , date: 24-6-2006 , referee: --goal: | T4 , SP: 6.Podolski (P: 1.Germany) | T12 , SP: 6.Podolski (P: 1.Germany) ----lineup player_home : | SP: 6.Podolski | SP: 5.Neuville | SP: 4.Frings | SP: 3.Lahm | SP: 2.Klose | SP: 1.Ballack ----lineup player_away : | SP: 4.Allback | SP: 3.Ljungberg | SP: 2.Larsson | SP: 1.Ibrahimovic ------------------------------------------------------match (id, player_home - player_away, score): 10002 , 9.Argentina - 13.Mexico , 2 - 1
28
-location: Leipzig , date: 24-6-2006 , referee: Merk --goal: | T6 , SP: 7.Marquez (P: 13.Mexico) | T10 , SP: 15.NN (P: 9.Argentina) | T98 , SP: 14.Rodriguez (P: 9.Argentina) ----lineup player_home : | SP: 15.NN | SP: 14.Rodriguez | SP: 13.Gonzalez | SP: 12.Saviola | SP: 1.Abbondanzieri ,POS: 1 | SP: 2.Heinze ,POS: 2 | SP: 3.Ayala ,POS: 3 | SP: 4.Zanetti ,POS: 4 | SP: 5.Samuel ,POS: 5 | SP: 6.Sorin ,POS: 6 | SP: 7.Riquelme (C) ,POS: 7 | SP: 8.Messi ,POS: 8 | SP: 9.Tevez ,POS: 9 | SP: 10.Cambiasso ,POS: 10 | SP: 11.Crespo ,POS: 11 ----lineup player_away : | SP: 7.Marquez | SP: 6.Fonseca | SP: 5.Salcido | SP: 4.Torrado | SP: 3.Bravo | SP: 2.Zinha | SP: 1.Borgetti ------------------------------------------------------match (id, player_home - player_away, score): 10003 , 5.England - 4.Ecuador , 1 - 0 -location: Stuttgart , date: 25-6-2006 , referee: --goal: | T59 , SP: 2.Beckham (P: 5.England) ----lineup player_home : | SP: 8.Cole | SP: 7.Crouch | SP: 6.Gerard | SP: 5.NN | SP: 4.Rooney | SP: 3.Owen | SP: 2.Beckham | SP: 1.Lampard ----lineup player_away : | SP: 6.Valencia | SP: 5.Kaviedes | SP: 4.Mendez | SP: 3.Delgado | SP: 2.Tenorio | SP: 1.Hurtado ------------------------------------------------------match (id, player_home - player_away, score): 10004 , 16.Portugal - 12.Netherlands , 1 - 0 -location: Nurnberg , date: 25-6-2006 , referee: --goal: | T22 , SP: 6.Maniche (P: 16.Portugal) ---reprt_match: | T2 , SP: 15.Bommel van (P: 12.Netherlands) , yellow_card | T7 , SP: 5.Boulahrouz (P: 12.Netherlands) , yellow_card | T19 , SP: 6.Maniche (P: 16.Portugal) , yellow_card | T30 , SP: 9.Costinha (P: 16.Portugal) , yellow_card | T44 , SP: 9.Costinha (P: 16.Portugal) , red_card | T49 , SP: 10.Petit (P: 16.Portugal) , yellow_card | T58 , SP: 2.Figo (P: 16.Portugal) , yellow_card | T58 , SP: 2.Bronkhorst van (P: 12.Netherlands) , yellow_card | T62 , SP: 5.Boulahrouz (P: 12.Netherlands) , red_card | T72 , SP: 5.Deco (P: 16.Portugal) , yellow_card | T73 , SP: 8.Vaart van der (P: 12.Netherlands) , yellow_card | T73 , SP: 16.Sneijder (P: 12.Netherlands) , yellow_card | T74 , SP: 11.Ricardo (P: 16.Portugal) , yellow_card | T75 , SP: 4.Valente (P: 16.Portugal) , yellow_card | T77 , SP: 5.Deco (P: 16.Portugal) , red_card | T89 , SP: 2.Bronkhorst van (P: 12.Netherlands) , red_card ----lineup player_home : | SP: 10.Petit | SP: 1.Ronaldo | SP: 4.Valente | SP: 8.NN | SP: 11.Ricardo | SP: 6.Maniche | SP: 5.Deco | SP: 7.Simao | SP: 3.Pauleta | SP: 9.Costinha | SP: 2.Figo ----lineup player_away : | SP: 16.Sneijder , PER: 6 | SP: 15.Bommel van , PER: 6 Tout: 66 | SP: 13.Persie van , PER: 7 | SP: 14.Heitinga Tin: 66 | SP: 20.Vennegoor of Hesselink Tin: 83 | SP: 1.Sar van der (C) ,POS: 1 , PER: 8 | SP: 2.Bronkhorst van ,POS: 2 , PER: 6 | SP: 3.Mathijsen ,POS: 3 , PER: 6 Tout: 52 | SP: 4.Ooijer ,POS: 4 , PER: 7 | SP: 5.Boulahrouz ,POS: 5 , PER: 5 | SP: 6.Cocu ,POS: 6 , PER: 5,5 Tout: 83 | SP: 8.Vaart van der ,POS: 8 Tin: 52 | SP: 9.Kuyt ,POS: 9 , PER: 6,5 | SP: 10.Robben ,POS: 10 , PER: 5 ------------------------------------------------------match (id, player_home - player_away, score): 10005 , 17.Italy - 23.Australia , 1 - 0 -location: Kaiserslautern , date: 26-6-2006 , referee: --goal: | T90 , SP: 1.Totti (P: 17.Italy) (PNL)
29
----lineup player_home : | SP: 10.Inzaghi | SP: 9.Materazzi | SP: 8.NN | SP: 7.Gilardino | SP: 6.Camoranesi | SP: 5.De Rossi | SP: 4.Iaquinta | SP: 3.Pirlo | SP: 2.Vieri | SP: 1.Totti ----lineup player_away : | SP: 6.Kewell | SP: 5.Moore | SP: 4.Grella | SP: 3.Cahill | SP: 2.Aloisi | SP: 1.Viduka ------------------------------------------------------match (id, player_home - player_away, score): 10006 , 26.Switzerland - 30.Ukraine , 0 - 1 -location: Koln , date: 26-6-2006 , referee: --goal: | T121 , SP: 5.NN (P: 30.Ukraine) (PNL) ----lineup player_home : | SP: 7.Senderos | SP: 6.Barnetta | SP: 5.Cabanas | SP: 4.Degen | SP: 3.Streller | SP: 2.Magnin | SP: 1.Frei ----lineup player_away : | SP: 5.NN | SP: 4.Kalinichenko | SP: 3.Rebrov | SP: 2.Rusol | SP: 1.Sjevtsjenko ------------------------------------------------------match (id, player_home - player_away, score): 10007 , 21.Brazil - 18.Ghana , 3 - 0 -location: Dortmund , date: 27-6-2006 , referee: --goal: | T4 , SP: 2.Ronaldo (P: 21.Brazil) | T44 , SP: 6.Adriano (P: 21.Brazil) | T83 , SP: 10.Ze Roberto (P: 21.Brazil) ----lineup player_home : | SP: 10.Ze Roberto | SP: 9.Gilberto | SP: 8.Pernambucano | SP: 7.Fred | SP: 6.Adriano | SP: 5.Kaka | SP: 4.Emerson | SP: 3.Carlos | SP: 2.Ronaldo | SP: 1.Ronaldinho ----lineup player_away : | SP: 5.Appiah | SP: 4.Dramani | SP: 3.Gyan | SP: 2.Muntari | SP: 1.Essien ------------------------------------------------------match (id, player_home - player_away, score): 10008 , 29.Spain - 25.France , 1 - 3 -location: Hannover , date: 27-6-2006 , referee: --goal: | T26 , SP: 3.Villa (P: 29.Spain) (PNL) | T41 , SP: 7.Ribery (P: 25.France) | T82 , SP: 6.Vieira (P: 25.France) | T90 , SP: 2.Zidane (P: 25.France) ----lineup player_home : | SP: 1.Alonso | SP: 2.Raul | SP: 3.Villa | SP: 4.Torres | SP: 5.Juanito ----lineup player_away : | SP: 1.Henry | SP: 2.Zidane | SP: 3.Trezeguet | SP: 4.Abidal | SP: 5.Sagnol | SP: 6.Vieira | SP: 7.Ribery ------------------------------------------------------match (id, player_home - player_away, score): 10009 , 1.Germany - 9.Argentina , 2 - 1 -location: Berlin , date: 30-6-2006 , referee: --goal: | T49 , SP: 3.Ayala (P: 9.Argentina) | T80 , SP: 2.Klose (P: 1.Germany) | T121 , SP: 7.NN (P: 1.Germany) (PNL) ----lineup player_home : | SP: 7.NN | SP: 6.Podolski | SP: 5.Neuville | SP: 4.Frings | SP: 3.Lahm | SP: 2.Klose | SP: 1.Ballack ----lineup player_away : | SP: 15.NN | SP: 14.Rodriguez | SP: 13.Gonzalez | SP: 12.Saviola | SP: 1.Abbondanzieri ,POS: 1 | SP: 2.Heinze ,POS: 2 | SP: 3.Ayala ,POS: 3 | SP: 4.Zanetti ,POS: 4 | SP: 5.Samuel ,POS: 5 | SP: 6.Sorin ,POS: 6 | SP: 7.Riquelme (C) ,POS: 7 | SP: 8.Messi ,POS: 8 | SP: 9.Tevez ,POS: 9 | SP: 10.Cambiasso ,POS: 10 | SP: 11.Crespo ,POS: 11 ------------------------------------------------------match (id, player_home - player_away, score): 10010 , 17.Italy - 30.Ukraine , 3 - 0
30
-location: Hamburg , date: 30-6-2006 , referee: --goal: | T5 , SP: 12.Zambrotta (P: 17.Italy) | T58 , SP: 11.Toni (P: 17.Italy) | T68 , SP: 11.Toni (P: 17.Italy) ----lineup player_home : | SP: 12.Zambrotta | SP: 11.Toni | SP: 10.Inzaghi | SP: 9.Materazzi | SP: 8.NN | SP: 7.Gilardino | SP: 6.Camoranesi | SP: 5.De Rossi | SP: 4.Iaquinta | SP: 3.Pirlo | SP: 2.Vieri | SP: 1.Totti ----lineup player_away : | SP: 5.NN | SP: 4.Kalinichenko | SP: 3.Rebrov | SP: 2.Rusol | SP: 1.Sjevtsjenko ------------------------------------------------------match (id, player_home - player_away, score): 10011 , 5.England - 16.Portugal , 0 - 1 -location: Gelsenkirchen , date: 1-7-2006 , referee: --goal: | T121 , SP: 8.NN (P: 16.Portugal) (PNL) ----lineup player_home : | SP: 8.Cole | SP: 7.Crouch | SP: 6.Gerard | SP: 5.NN | SP: 4.Rooney | SP: 3.Owen | SP: 2.Beckham | SP: 1.Lampard ----lineup player_away : | SP: 8.NN | SP: 7.Simao | SP: 6.Maniche | SP: 5.Deco | SP: 4.Valente | SP: 3.Pauleta | SP: 2.Figo | SP: 1.Ronaldo ------------------------------------------------------match (id, player_home - player_away, score): 10012 , 21.Brazil - 25.France , 0 - 1 -location: Frankfurt , date: 1-7-2006 , referee: --goal: | T56 , SP: 1.Henry (P: 25.France) ----lineup player_home : | SP: 10.Ze Roberto | SP: 9.Gilberto | SP: 8.Pernambucano | SP: 7.Fred | SP: 6.Adriano | SP: 5.Kaka | SP: 4.Emerson | SP: 3.Carlos | SP: 2.Ronaldo | SP: 1.Ronaldinho ----lineup player_away : | SP: 6.Vieira | SP: 5.Sagnol | SP: 4.Abidal | SP: 3.Trezeguet | SP: 2.Zidane | SP: 1.Henry ------------------------------------------------------match (id, player_home - player_away, score): 10013 , 1.Germany - 17.Italy , 0 - 2 -location: Dortmund , date: 4-7-2006 , referee: --goal: | T119 , SP: 13.Grosso (P: 17.Italy) | T120 , SP: 14.Del Piero (P: 17.Italy) ----lineup player_home : | SP: 1.Ballack | SP: 5.Neuville | SP: 7.NN | SP: 4.Frings | SP: 3.Lahm | SP: 2.Klose | SP: 6.Podolski ----lineup player_away : | SP: 5.De Rossi | SP: 13.Grosso | SP: 12.Zambrotta | SP: 11.Toni | SP: 10.Inzaghi | SP: 9.Materazzi | SP: 8.NN | SP: 7.Gilardino | SP: 14.Del Piero | SP: 6.Camoranesi | SP: 4.Iaquinta | SP: 3.Pirlo | SP: 2.Vieri | SP: 1.Totti ------------------------------------------------------match (id, player_home - player_away, score): 10014 , 16.Portugal - 25.France , 0 - 1 -location: Munchen , date: 5-7-2006 , referee: --goal: | T33 , SP: 2.Zidane (P: 25.France) (PNL) ----lineup player_home : | SP: 3.Pauleta | SP: 4.Valente | SP: 1.Ronaldo | SP: 2.Figo | SP: 6.Maniche | SP: 7.Simao | SP: 8.NN | SP: 9.Costinha | SP: 10.Petit | SP: 11.Ricardo | SP: 5.Deco ----lineup player_away : | SP: 4.Abidal | SP: 6.Vieira | SP: 7.Ribery | SP: 5.Sagnol | SP: 3.Trezeguet | SP: 2.Zidane | SP: 1.Henry
31
------------------------------------------------------match (id, player_home - player_away, score): 10015 , 1.Germany - 16.Portugal , 3 - 1 -location: Stuttgart , date: 8-7-2006 , referee: --goal: | T56 , SP: 8.Schweinsteiger (P: 1.Germany) | T61 , SP: 7.NN (P: 1.Germany) | T78 , SP: 8.Schweinsteiger (P: 1.Germany) | T88 , SP: 12.Gomes (P: 16.Portugal) ----lineup player_home : | SP: 8.Schweinsteiger | SP: 7.NN | SP: 5.Neuville | SP: 1.Ballack | SP: 4.Frings | SP: 3.Lahm | SP: 2.Klose | SP: 6.Podolski ----lineup player_away : | SP: 5.Deco | SP: 1.Ronaldo | SP: 2.Figo | SP: 11.Ricardo | SP: 3.Pauleta | SP: 10.Petit | SP: 4.Valente | SP: 9.Costinha | SP: 8.NN | SP: 12.Gomes | SP: 6.Maniche | SP: 7.Simao ------------------------------------------------------match (id, player_home - player_away, score): 10016 , 17.Italy - 25.France , 2 - 1 -location: Berlin , date: 9-7-2006 , referee: --goal: | T5 , SP: 2.Zidane (P: 25.France) (PNL) | T18 , SP: 9.Materazzi (P: 17.Italy) | T121 , SP: 8.NN (P: 17.Italy) (PNL) ----lineup player_home : | SP: 14.Del Piero | SP: 13.Grosso | SP: 12.Zambrotta | SP: 11.Toni | SP: 10.Inzaghi | SP: 9.Materazzi | SP: 6.Camoranesi | SP: 7.Gilardino | SP: 3.Pirlo | SP: 2.Vieri | SP: 1.Totti | SP: 5.De Rossi | SP: 4.Iaquinta | SP: 8.NN ----lineup player_away : | SP: 5.Sagnol | SP: 7.Ribery | SP: 6.Vieira | SP: 4.Abidal | SP: 3.Trezeguet | SP: 2.Zidane | SP: 1.Henry -------------------------------------------------------
32
11.Results Matches in Round 1 – ordered by Group
Group Round Group
1
Qualifications, 9/6-23/6
1 A
Match Date
Time
Location
Player Home
Player Away
Score H-A
1
9-6-2006
18:00
Munchen
1
Germany
2
Costa Rica
4
2
2
9-6-2006
21:00
Gelsenkirchen
3
Poland
4
Ecuador
0
2
17
14-6-2006
21:00
Dortmund
1
Germany
3
Poland
1
0
18
15-6-2006
15:00
Hamburg
4
Ecuador
2
Costa Rica
3
0
33
20-6-2006
16:00
Berlin
4
Ecuador
1
Germany
0
3
34
20-6-2006
16:00
Hannover
2
Costa Rica
3
Poland
1
2
Group
2 B
Match Date
Time
Location
Player Home
Player Away
Score H-A
3
10-6-2006
15:00
Frankfurt
5
England
6
Paraguay
1
0
4
10-6-2006
18:00
Dortmund
7
Trinidad & Tobago
8
Sweden
0
0
19
15-6-2006
18:00
Nurnberg
5
England
7
Trinidad & Tobago
2
0
20
15-6-2006
21:00
Berlin
8
Sweden
6
Paraguay
1
0
35
20-6-2006
21:00
Kaiserslautern
6
Paraguay
7
Trinidad & Tobago
2
0
36
20-6-2006
21:00
Koln
8
Sweden
5
England
2
2
Match!©
zaterdag 24 juni 2006
Pagina 1 van 4
33
Group
3 C
Match Date
Time
Location
5
10-6-2006
21:00
Hamburg
6
11-6-2006
15:00
Leipzig
21
16-6-2006
15:00
Gelsenkirchen
22
16-6-2006
18:00
Stuttgart
39
21-6-2006
21:00
40
21-6-2006
21:00
Group
Player Home 9
Player Away
Score H-A
Argentina
10
Côte d’Ivoir
2
1
Serbia & Montenegro
12
Netherlands
0
1
Argentina
11
Serbia & Montenegro
6
0
12
Netherlands
10
Côte d’Ivoir
2
1
Frankfurt
12
Netherlands
9
Argentina
0
0
Munchen
10
Côte d’Ivoir
11
Serbia & Montenegro
3
2
11 9
4 D
Match Date
Time
Location
Player Home
Player Away
Score H-A
7
11-6-2006
18:00
Nurnberg
13
Mexico
14
Iran
3
1
8
11-6-2006
21:00
Koln
15
Angola
16
Portugal
0
1
23
16-6-2006
21:00
Hannover
13
Mexico
15
Angola
0
0
24
17-6-2006
15:00
Frankfurt
16
Portugal
14
Iran
2
0
37
21-6-2006
16:00
Gelsenkirchen
16
Portugal
13
Mexico
2
1
38
21-6-2006
16:00
Leipzig
14
Iran
15
Angola
1
1
Group
5 E
Match Date
Time
Location
Player Home
Player Away
Score H-A
10
12-6-2006
18:00
Gelsenkirchen
19
USA
20
Czech Republic
0
3
11
12-6-2006
21:00
Hannover
17
Italy
18
Ghana
2
0
Match!©
zaterdag 24 juni 2006
Pagina 2 van 4
34
Match Date
Time
Location
Player Home
Player Away
Score H-A
25
17-6-2006
18:00
Koln
20
Czech Republic
18
Ghana
0
2
26
17-6-2006
21:00
Kaiserslautern
17
Italy
19
USA
1
1
41
22-6-2006
16:00
Hamburg
20
Czech Republic
17
Italy
0
2
42
22-6-2006
16:00
Nurnberg
18
Ghana
19
USA
2
1
Group
6 F
Match Date
Time
Location
Player Home
Player Away
Score H-A
9
12-6-2006
15:00
Kaiserslautern
23
Australia
24
Japan
3
1
14
13-6-2006
21:00
Berlin
21
Brazil
22
Croatia
1
0
27
18-6-2006
15:00
Nurnberg
24
Japan
22
Croatia
0
0
28
18-6-2006
18:00
Munchen
21
Brazil
23
Australia
2
0
43
22-6-2006
21:00
Dortmund
24
Japan
21
Brazil
1
4
44
22-6-2006
21:00
Stuttgart
22
Croatia
23
Australia
2
2
Group
7 G
Match Date
Time
Location
Player Home
Player Away
Score H-A
12
13-6-2006
15:00
Frankfurt
27
South Korea
28
Togo
2
1
13
13-6-2006
18:00
Stuttgart
25
France
26
Switzerland
0
0
29
18-6-2006
21:00
Leipzig
25
France
27
South Korea
1
1
30
19-6-2006
15:00
Dortmund
28
Togo
26
Switzerland
0
2
47
23-6-2006
21:00
Hannover
26
Switzerland
27
South Korea
2
0
48
23-6-2006
21:00
Koln
28
Togo
25
France
0
2
Match!©
zaterdag 24 juni 2006
Pagina 3 van 4
35
Group
8 H
Match Date
Time
Location
Player Home
Player Away
Score H-A
15
14-6-2006
15:00
Leipzig
29
Spain
30
Ukraine
4
0
16
14-6-2006
18:00
Munchen
31
Tunisia
32
Saudi Arabia
2
2
31
19-6-2006
18:00
Hamburg
32
Saudi Arabia
30
Ukraine
0
4
32
19-6-2006
21:00
Stuttgart
29
Spain
31
Tunisia
3
1
45
23-6-2006
16:00
Berlin
30
Ukraine
31
Tunisia
1
0
46
23-6-2006
16:00
Kaiserslautern
32
Saudi Arabia
29
Spain
0
1
Match!©
zaterdag 24 juni 2006
Pagina 4 van 4
36
12.Results Matches in Round 1- Matrix
37
13.Topscorers RankingSubplayer 1
2 Klose
2
1 Henry
3
Player
5
7
0,71
25 France
3
7
0,43
2 Ronaldo
21 Brazil
3
5
0,60
4
3 Villa
29 Spain
3
4
0,75
5
6 Podolski
3
5
0,60
6
2 Zidane
3
7
0,43
3
4
0,75
7
1 Germany
Goal# Match#Average
1 Germany 25 France
14 Rodriguez
9 Argentina
8
4 Torres
29 Spain
3
4
0,75
9
9 Materazzi
17 Italy
2
5
0,40
10
3 Bravo
13 Mexico
2
4
0,50
11
7 NN
2
3
0,67
12
6 Vieira
25 France
2
5
0,40
13
3 Rosicky
20 Czech Republic
2
3
0,67
14
3 Cahill
23 Australia
2
4
0,50
15
3 Delgado
4 Ecuador
2
4
0,50
16
6 Gerard
5 England
2
5
0,40
1 Germany
Match!© dinsdag 11 juli 2006
Pagina 1 van 6
38
14.Competition Stats period
match_no 2006
64
goal_sum 151
goal_average 2,359375
NB: 4 goals were made in a penalty-shoot-out in a final-round.
15.All stars team NL pos_nr
playr_id 1 2 3 4 5 6 7 8 9 10 11
12 12 12 12 12 12 12 12 12 12 12
playr_nm Netherlands Netherlands Netherlands Netherlands Netherlands Netherlands Netherlands Netherlands Netherlands Netherlands Netherlands
subplayr_id 1 2 18 4 5 6 15 8 13 10 9
subplayr_nm Sar van der Bronkhorst van Cler de Ooijer Boulahrouz Cocu Bommel van Vaart van der Persie van Robben Kuyt
39
16.All stars team spec. NL pos_nr
playr_id 1 2 2 3 3 4 5 5 6 7 8 8 9 9 10 10 11 11
12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12
playr_nm Netherlands Netherlands Netherlands Netherlands Netherlands Netherlands Netherlands Netherlands Netherlands Netherlands Netherlands Netherlands Netherlands Netherlands Netherlands Netherlands Netherlands Netherlands
subplayr_id 1 2 17 18 3 4 5 14 6 15 8 16 13 9 16 10 9 11
subplayr_nm Sar van der Bronkhorst van Jaliens Cler de Mathijsen Ooijer Boulahrouz Heitinga Cocu Bommel van Vaart van der Sneijder Persie van Kuyt Sneijder Robben Kuyt Nistelrooy van
avg_perf_nr 7,375 6,333333333333 33 5,5 7 6 6,75 6,666666666666 67 6 5,75 6,333333333333 33 6,5 5,666666666666 67 6,75 5,5 7 6,5 6,5 5,5
match_no 4 3 1 1 3 4 3 2 4 3 1 3 4 1 1 3 1 3
played_time 360 270 90 90 227 360 224 136 353 215 90 229 336 90 85 270 90 196
40
17.Performance suplayers NL subplayr_nm Sar van der Bronkhorst van Mathijsen Ooijer Boulahrouz Cocu Landzaat Vaart van der Kuyt Robben Nistelrooy van Maduro Persie van Heitinga Bommel van Sneijder Jaliens Cler de Babel Vennegoor of Hesselink
avg_perf_nr 7,375 6,333333333333 33 6 6,75 6,666666666666 67 5,75
min_perf_nr
max_perf_nr
7 6 5,5 5 5 5
8 6,5 6,5 8 8 6,5
6,5 6 6,5 5,5
6,5 5,5 5 5
6,5 6,5 8 6
6,75 6 6,333333333333 33 6 5,5 7
6 5,5 6 5 5,5 7
7,5 6,5 7 7 5,5 7
match_no 4 3 3 4 4 4 3 3 3 3 3 1 4 3 3 4 1 1 1 1
played_time 360 270 227 360 229 353 72 169 202 270 196 5 336 160 215 314 90 90 35 7
min_date 11-6-2006 11-6-2006 11-6-2006 11-6-2006 11-6-2006 11-6-2006 11-6-2006 16-6-2006 11-6-2006 11-6-2006 11-6-2006 21-6-2006 11-6-2006 11-6-2006 11-6-2006 11-6-2006 21-6-2006 21-6-2006 21-6-2006 25-6-2006
max_date 25-6-2006 25-6-2006 25-6-2006 25-6-2006 25-6-2006 25-6-2006 21-6-2006 25-6-2006 25-6-2006 25-6-2006 21-6-2006 21-6-2006 25-6-2006 25-6-2006 25-6-2006 25-6-2006 21-6-2006 21-6-2006 21-6-2006 25-6-2006
41
42
18.Topscorers NL playr_id
Playr_nm 12 Netherlands 12 Netherlands 12 Netherlands
subplayr_id subplayr_nm 13 Persie van 11 Nistelrooy van 10 Robben
perd_id 2006 2006 2006
goal_no 1 1 1
19.Goals Time specification NL playr_id
goal_no_25_po goal_no_25_ne goal_no_50_po goal_no_50_ne goal_no_75_po goal_no_75_ne goal_no_100_p goal_no_100_ne s g s g s g os g 12 2 0 3 1 3 1 3 1
20.Yellow cards NL playr_id 12 12 12 12 12 12 12 12 12 12 12
playr_nm Netherlands Netherlands Netherlands Netherlands Netherlands Netherlands Netherlands Netherlands Netherlands Netherlands Netherlands
subplayr_id 15 5 2 18 16 14 10 9 8 4 3
subplayr_nm Bommel van Boulahrouz Bronkhorst van Cler de Sneijder Heitinga Robben Kuyt Vaart van der Ooijer Mathijsen
perd_id 2006 2006 2006 2006 2006 2006 2006 2006 2006 2006 2006
yel_card_no 2 2 2 1 1 1 1 1 1 1 1
43
21.Red cards NL
playr_id
playr_nm 12 Netherlands 12 Netherlands
subplayr_id
subplayr_nm 5 Boulahrouz 2 Bronkhorst van
perd_id 2006 2006
red_card_no 1 1
22.Literature [L1]
http://fifaworldcup.yahoo.com/06/en/index.html
[L2]
http://www.sport.be/nl/
[L3]
http://wm2006.deutschland.de/EN/Navigation/Home/home.html
[L4]
http://msn.foxsports.com/soccer/worldcup
[L5]
http://edition.cnn.com/SPECIALS/2006/worldcup/
44
12-7-2006 by: Eiger Software Inc. H: http://eigersoftware.tripod.com/match.htm E: [email protected]
1
CONTENTS 1. Introduction..............................................................................................................................................................................................................................................................3 2. Ranking Gamblers...................................................................................................................................................................................................................................................4 3. Gambler- Points Spec. Bar Graph...........................................................................................................................................................................................................................5 4. Gambler-Points Timeseries Graph...........................................................................................................................................................................................................................6 5. Toto Forecast Stats. ................................................................................................................................................................................................................................................7 6. End Ranking Teams ................................................................................................................................................................................................................................................9 7. Ranking Teams after Round 1................................................................................................................................................................................................................................10 8. Ranking Teams after Round 1- Detailed................................................................................................................................................................................................................13 9. Results Matches – ordered by date........................................................................................................................................................................................................................15 10. Results Matches – Detailed..................................................................................................................................................................................................................................19 11. Results Matches in Round 1 – ordered by Group................................................................................................................................................................................................33 12. Results Matches in Round 1- Matrix...................................................................................................................................................................................................................37 13. Topscorers............................................................................................................................................................................................................................................................38 14. Competition Stats.................................................................................................................................................................................................................................................39 15. All stars team NL.................................................................................................................................................................................................................................................39 16. All stars team spec. NL........................................................................................................................................................................................................................................40 17. Performance suplayers NL...................................................................................................................................................................................................................................41 18. Topscorers NL......................................................................................................................................................................................................................................................43 19. Goals Time specification NL...............................................................................................................................................................................................................................43 20. Yellow cards NL...................................................................................................................................................................................................................................................43 21. Red cards NL.......................................................................................................................................................................................................................................................44 22. Literature..............................................................................................................................................................................................................................................................44
2
1. Introduction This document contains all reports, figures and statistics produced by Match! for the FIFA World Cup 2006 (WC), both for the soccer-competition as the betting-competition (‘toto’). See [Match! user manual, on website] for an explanation of all the figures in this doc. In Match, the matches of round 1 (group-round) have ID’s 1-48. In the next (final-)rounds, the match-ID’s are 10.001-10.016. Paragraphs 12-20, so the output marked with ‘NL’, relate to statistics of the Dutch team. The performances (marks, ‘rapport-cijfers’) are from soccer-experts (Telegraaf). We registered almost all match-details (e.g. who made a goal and when), except: yellow/red-cards and lineups, this is only done for the Dutch-team. When a match in a final-round is equal at the end of the extra time (so a ‘draw’ after 120 min.), the result of the penalty-shoot-out is considered by Match as 1 goal for the winning team, and the result is a victory, not a draw. In Match this goal is registered as: sub-player: ‘NN’, time: 121 (min.). Own goals are in Match not assigned to a sub-player, but to ‘NN’ (anonymus). References to literature are noted as [Li]. On our website, you can find Match! (demo-version), with all data as you can see in this report. Because the WC is now over, the last round (round 5) is the actual round, and the matches you see will be filtered on this round. To see matches of another round, you have to make that round the actual round. On our website you can find also the original sources of the reports in this document, e.g. Excel-files with graphs.
3
2. Ranking Gamblers Ranking
Match!©
Gambler
Point#
Toto# Score# Player#End Rank#
1
15 Johan
132
82
12
34
4
2
10 Maarten
132
86
12
34
0
3
3 Sulma
128
86
9
33
0
4
2 Silvia
125
84
7
34
0
5
1 Azucena
124
82
6
36
0
6
4 Joaquin
118
78
4
32
4
7
5 Monce
116
74
5
35
2
8
7 Dennis
114
68
7
31
8
9
14 Wilson
111
72
10
29
0
10
13 Tieneke
109
76
3
30
0
11
12 Doris
109
68
5
32
4
12
9 Petra
108
72
7
29
0
13
8 Peter
103
70
6
27
0
14
6 Paul
96
62
5
29
0
15
16 Victor
76
50
4
22
0
dinsdag 11 juli 2006
Pagina 1 van 1
4
3. Gambler- Points Spec. Bar Graph X = Gambler Y = Points #
140 120 100 pnt_endrank_no
80
pnt_playr_no pnt_goal_no
60
pnt_toto_no
40 20
or ct Vi
ul Pa
r te Pe
tr a Pe
e ek en Ti
r is Do
ils o
n
is W
nn De
ce on M
ui n aq Jo
en
a
a
uc
n
a lm Su
ha Jo
Si lv i
Az
M
aa
r te
n
0
5
4. Gambler-Points Timeseries Graph X = Match-ID (time) Y = Points #
140
Azucena Silvia Sulma Joaquin Monce Paul Dennis Peter Petra Maarten Doris Tieneke Wilson Johan Victor
120 100 80 60 40 20
M 8 M 11 EN M 1 D -T 4 O TA L
4 M
M Ro 45 un d 2
M 41
37 M
M 33
29 M
M 25
21 M
M 17
9
13 M
M
5 M
M 1
0
6
5. Toto Forecast Stats.
7
8
6. End Ranking Teams
Ranking
Player
1
17 Italy
2
25 France
3 4
1 Germany 16 Portugal
9
7. Ranking Teams after Round 1
Group 1 A Ranking
Player
Match# Point#Score: Pos.Neg.Saldo
1
1 Germany
3
9
8
2
6
2
4 Ecuador
3
6
5
3
2
3
3 Poland
3
3
2
4
-2
4
2 Costa Rica
3
0
3
9
-6
Group 2 B Ranking
Player
Match# Point#Score: Pos.Neg.Saldo
1
5 England
3
7
5
2
3
2
8 Sweden
3
5
3
2
1
3
6 Paraguay
3
3
2
2
0
4
7 Trinidad &
3
1
0
4
-4
Group 3 C Ranking
Player
Match# Point#Score: Pos.Neg.Saldo
1
9 Argentina
3
7
8
1
7
2
12 Netherlands
3
7
3
1
2
Match!© zaterdag 24 juni 2006
Pagina 1 van 3
10
Ranking
Player
Match# Point#Score: Pos.Neg.Saldo
3
10 Côte d’Ivoir
3
3
5
6
-1
4
11 Serbia &
3
0
2
10
-8
Group 4 D Ranking
Player
Match# Point#Score: Pos.Neg.Saldo
1
16 Portugal
3
9
5
1
4
2
13 Mexico
3
4
4
3
1
3
15 Angola
3
2
1
2
-1
4
14 Iran
3
1
2
6
-4
Group 5 E Ranking
Player
Match# Point#Score: Pos.Neg.Saldo
1
17 Italy
3
7
5
1
4
2
18 Ghana
3
6
4
3
1
3
20 Czech Republic
3
3
3
4
-1
4
19 USA
3
1
2
6
-4
Group 6 F Ranking
Player
Match# Point#Score: Pos.Neg.Saldo
1
21 Brazil
3
9
7
1
6
2
23 Australia
3
4
5
5
0
3
22 Croatia
3
2
2
3
-1
4
24 Japan
3
1
2
7
-5
Match!© zaterdag 24 juni 2006
Pagina 2 van 3
11
Group 7 G Ranking
Player
Match# Point#Score: Pos.Neg.Saldo
1
26 Switzerland
3
7
4
0
4
2
25 France
3
5
3
1
2
3
27 South Korea
3
4
3
4
-1
4
28 Togo
3
0
1
6
-5
Group 8 H Ranking
Player
Match# Point#Score: Pos.Neg.Saldo
1
29 Spain
3
9
8
1
7
2
30 Ukraine
3
6
5
4
1
3
31 Tunisia
3
1
3
6
-3
4
32 Saudi Arabia
3
1
2
7
-5
Match!© zaterdag 24 juni 2006
Pagina 3 van 3
12
8. Ranking Teams after Round 1- Detailed Group
Ranking
PlayerMatch#Point#Vic.#Draw#Loss#Score: Pos. Neg. Saldo
1 A
1
1 Germany
3
9
3
0
0
8
2
6
1 A
2
4 Ecuador
3
6
2
0
1
5
3
2
1 A
3
3 Poland
3
3
1
0
2
2
4
-2
1 A
4
2 Costa Rica
3
0
0
0
3
3
9
-6
2 B
1
5 England
3
7
2
1
0
5
2
3
2 B
2
8 Sweden
3
5
1
2
0
3
2
1
2 B
3
6 Paraguay
3
3
1
0
2
2
2
0
2 B
4
7 Trinidad & Tobago
3
1
0
1
2
0
4
-4
3 C
1
9 Argentina
3
7
2
1
0
8
1
7
3 C
2
12 Netherlands
3
7
2
1
0
3
1
2
3 C
3
10 Côte d’Ivoir
3
3
1
0
2
5
6
-1
3 C
4
11 Serbia &
3
0
0
0
3
2
10
-8
4 D
1
16 Portugal
3
9
3
0
0
5
1
4
4 D
2
13 Mexico
3
4
1
1
1
4
3
1
4 D
3
15 Angola
3
2
0
2
1
1
2
-1
4 D
4
14 Iran
3
1
0
1
2
2
6
-4
5 E
1
17 Italy
3
7
2
1
0
5
1
4
Match!©
zaterdag 24 juni 2006
13
Group
Ranking
PlayerMatch#Point#Vic.#Draw#Loss#Score: Pos. Neg. Saldo
5 E
2
18 Ghana
3
6
2
0
1
4
3
1
5 E
3
20 Czech Republic
3
3
1
0
2
3
4
-1
5 E
4
19 USA
3
1
0
1
2
2
6
-4
6 F
1
21 Brazil
3
9
3
0
0
7
1
6
6 F
2
23 Australia
3
4
1
1
1
5
5
0
6 F
3
22 Croatia
3
2
0
2
1
2
3
-1
6 F
4
24 Japan
3
1
0
1
2
2
7
-5
7 G
1
26 Switzerland
3
7
2
1
0
4
0
4
7 G
2
25 France
3
5
1
2
0
3
1
2
7 G
3
27 South Korea
3
4
1
1
1
3
4
-1
7 G
4
28 Togo
3
0
0
0
3
1
6
-5
8 H
1
29 Spain
3
9
3
0
0
8
1
7
8 H
2
30 Ukraine
3
6
2
0
1
5
4
1
8 H
3
31 Tunisia
3
1
0
1
2
3
6
-3
8 H
4
32 Saudi Arabia
3
1
0
1
2
2
7
-5
Match!©
zaterdag 24 juni 2006
14
9. Results Matches – ordered by date
Match Date
Time
Location
GroupPlayer Home
Player Away
Score H-A
1
9-6-2006
18:00
Munchen
A
1
Germany
2
Costa Rica
4
2
2
9-6-2006
21:00
Gelsenkirchen
A
3
Poland
4
Ecuador
0
2
3
10-6-2006
15:00
Frankfurt
B
5
England
6
Paraguay
1
0
4
10-6-2006
18:00
Dortmund
B
7
Trinidad & Tobago
8
Sweden
0
0
5
10-6-2006
21:00
Hamburg
C
9
Argentina
10
Côte d’Ivoir
2
1
6
11-6-2006
15:00
Leipzig
C
11
Serbia & Montenegro
12
Netherlands
0
1
7
11-6-2006
18:00
Nurnberg
D
13
Mexico
14
Iran
3
1
8
11-6-2006
21:00
Koln
D
15
Angola
16
Portugal
0
1
9
12-6-2006
15:00
Kaiserslautern
F
23
Australia
24
Japan
3
1
10
12-6-2006
18:00
Gelsenkirchen
E
19
USA
20
Czech Republic
0
3
11
12-6-2006
21:00
Hannover
E
17
Italy
18
Ghana
2
0
12
13-6-2006
15:00
Frankfurt
G
27
South Korea
28
Togo
2
1
13
13-6-2006
18:00
Stuttgart
G
25
France
26
Switzerland
0
0
14
13-6-2006
21:00
Berlin
F
21
Brazil
22
Croatia
1
0
15
14-6-2006
15:00
Leipzig
H
29
Spain
30
Ukraine
4
0
16
14-6-2006
18:00
Munchen
H
31
Tunisia
32
Saudi Arabia
2
2
Match!©
dinsdag 11 juli 2006
Pagina 1 van 4
15
Match Date
Time
Location
GroupPlayer Home
Player Away
Score H-A
17
14-6-2006
21:00
Dortmund
A
1
Germany
3
Poland
1
0
18
15-6-2006
15:00
Hamburg
A
4
Ecuador
2
Costa Rica
3
0
19
15-6-2006
18:00
Nurnberg
B
5
England
7
Trinidad & Tobago
2
0
20
15-6-2006
21:00
Berlin
B
8
Sweden
6
Paraguay
1
0
21
16-6-2006
15:00
Gelsenkirchen
C
9
Argentina
11
Serbia & Montenegro
6
0
22
16-6-2006
18:00
Stuttgart
C
12
Netherlands
10
Côte d’Ivoir
2
1
23
16-6-2006
21:00
Hannover
D
13
Mexico
15
Angola
0
0
24
17-6-2006
15:00
Frankfurt
D
16
Portugal
14
Iran
2
0
25
17-6-2006
18:00
Koln
E
20
Czech Republic
18
Ghana
0
2
26
17-6-2006
21:00
Kaiserslautern
E
17
Italy
19
USA
1
1
27
18-6-2006
15:00
Nurnberg
F
24
Japan
22
Croatia
0
0
28
18-6-2006
18:00
Munchen
F
21
Brazil
23
Australia
2
0
29
18-6-2006
21:00
Leipzig
G
25
France
27
South Korea
1
1
30
19-6-2006
15:00
Dortmund
G
28
Togo
26
Switzerland
0
2
31
19-6-2006
18:00
Hamburg
H
32
Saudi Arabia
30
Ukraine
0
4
32
19-6-2006
21:00
Stuttgart
H
29
Spain
31
Tunisia
3
1
33
20-6-2006
16:00
Berlin
A
4
Ecuador
1
Germany
0
3
34
20-6-2006
16:00
Hannover
A
2
Costa Rica
3
Poland
1
2
35
20-6-2006
21:00
Kaiserslautern
B
6
Paraguay
7
Trinidad & Tobago
2
0
36
20-6-2006
21:00
Koln
B
8
Sweden
5
England
2
2
Match!©
dinsdag 11 juli 2006
Pagina 2 van 4
16
Match Date
Time
Location
GroupPlayer Home
Player Away
Score H-A
37
21-6-2006
16:00
Gelsenkirchen
D
16
Portugal
13
Mexico
2
1
38
21-6-2006
16:00
Leipzig
D
14
Iran
15
Angola
1
1
39
21-6-2006
21:00
Frankfurt
C
12
Netherlands
Argentina
0
0
40
21-6-2006
21:00
Munchen
C
10
Côte d’Ivoir
11
Serbia & Montenegro
3
2
41
22-6-2006
16:00
Hamburg
E
20
Czech Republic
17
Italy
0
2
42
22-6-2006
16:00
Nurnberg
E
18
Ghana
19
USA
2
1
43
22-6-2006
21:00
Dortmund
F
24
Japan
21
Brazil
1
4
44
22-6-2006
21:00
Stuttgart
F
22
Croatia
23
Australia
2
2
45
23-6-2006
16:00
Berlin
H
30
Ukraine
31
Tunisia
1
0
46
23-6-2006
16:00
Kaiserslautern
H
32
Saudi Arabia
29
Spain
0
1
47
23-6-2006
21:00
Hannover
G
26
Switzerland
27
South Korea
2
0
G
28
Togo
9
48
23-6-2006
21:00
Koln
25
France
0
2
10001
24-6-2006
17:00
Munchen
1
Germany
8
Sweden
2
0
10002
24-6-2006
21:00
Leipzig
9
Argentina
13
Mexico
2
1
10003
25-6-2006
17:00
Stuttgart
5
England
4
Ecuador
1
0
10004
25-6-2006
21:00
Nurnberg
16
Portugal
12
Netherlands
1
0
10005
26-6-2006
17:00
Kaiserslautern
17
Italy
23
Australia
1
0
10006
26-6-2006
21:00
Koln
26
Switzerland
30
Ukraine
0
1
10007
27-6-2006
17:00
Dortmund
21
Brazil
18
Ghana
3
0
10008
27-6-2006
21:00
Hannover
29
Spain
25
France
1
3
Match!©
dinsdag 11 juli 2006
Pagina 3 van 4
17
Match Date
Time
Location
GroupPlayer Home
10009
30-6-2006
17:00
Berlin
10010
30-6-2006
21:00
Hamburg
10011
1-7-2006
17:00
Gelsenkirchen
10012
1-7-2006
21:00
Frankfurt
21
10013
4-7-2006
21:00
Dortmund
1
10014
5-7-2006
21:00
Munchen
10015
8-7-2006
21:00
Stuttgart
10016
9-7-2006
20:00
Berlin
Match!©
dinsdag 11 juli 2006
1 17
Germany
Player Away 9
Score H-A
Argentina
2
1
Italy
30
Ukraine
3
0
England
16
Portugal
0
1
Brazil
25
France
0
1
Germany
17
Italy
0
2
16
Portugal
25
France
0
1
1
Germany
16
Portugal
3
1
Italy
25
France
2
1
5
17
Pagina 4 van 4
18
10.Results Matches – Detailed match (id, player_home - player_away, score): 1 , 1.Germany - 2.Costa Rica , 4 - 2 -location: Munchen , date: 9-6-2006 , referee: Merk --goal: | T5 , SP: 3.Lahm (P: 1.Germany) | T12 , SP: 1.Wanchope (P: 2.Costa Rica) | T17 , SP: 2.Klose (P: 1.Germany) | T61 , SP: 2.Klose (P: 1.Germany) | T72 , SP: 1.Wanchope (P: 2.Costa Rica) | T86 , SP: 4.Frings (P: 1.Germany) ---reprt_match: | T29 , SP: 2.Fonseca (P: 2.Costa Rica) , yellow_card ----lineup player_home : | SP: 4.Frings | SP: 3.Lahm | SP: 2.Klose | SP: 1.Ballack ----lineup player_away : | SP: 2.Fonseca | SP: 1.Wanchope ------------------------------------------------------match (id, player_home - player_away, score): 2 , 3.Poland - 4.Ecuador , 0 - 2 -location: Gelsenkirchen , date: 9-6-2006 , referee: --goal: | T23 , SP: 2.Tenorio (P: 4.Ecuador) | T80 , SP: 3.Delgado (P: 4.Ecuador) ---reprt_match: | T30 , SP: 1.Hurtado (P: 4.Ecuador) , yellow_card | T35 , SP: 2.Smolarek (P: 3.Poland) , yellow_card | T69 , SP: 4.Mendez (P: 4.Ecuador) , yellow_card ----lineup player_home : | SP: 2.Smolarek | SP: 1.Zurawski ----lineup player_away : | SP: 4.Mendez | SP: 3.Delgado | SP: 2.Tenorio | SP: 1.Hurtado ------------------------------------------------------match (id, player_home - player_away, score): 3 , 5.England - 6.Paraguay , 1 - 0 -location: Frankfurt , date: 10-6-2006 , referee: --goal: | T3 , SP: 5.NN (P: 5.England) ---reprt_match: | T18 , SP: 6.Gerard (P: 5.England) , yellow_card | T22 , SP: 2.Valdez (P: 6.Paraguay) , yellow_card | T63 , SP: 7.Crouch (P: 5.England) , yellow_card ----lineup player_home : | SP: 7.Crouch | SP: 6.Gerard | SP: 5.NN | SP: 4.Rooney | SP: 3.Owen | SP: 2.Beckham | SP: 1.Lampard ----lineup player_away : | SP: 2.Valdez | SP: 1.Cardozo ------------------------------------------------------match (id, player_home - player_away, score): 4 , 7.Trinidad & Tobago - 8.Sweden , 0 - 0 -location: Dortmund , date: 10-6-2006 , referee: ---reprt_match: | T15 , SP: 2.John (P: 7.Trinidad & Tobago) , yellow_card | T46 , SP: 2.John (P: 7.Trinidad & Tobago) , yellow_card | T74 , SP: 1.Yorke (P: 7.Trinidad & Tobago) , yellow_card ----lineup player_home : | SP: 2.John | SP: 1.Yorke ----lineup player_away : | SP: 2.Larsson | SP: 1.Ibrahimovic ------------------------------------------------------match (id, player_home - player_away, score): 5 , 9.Argentina - 10.Côte d’Ivoir , 2 - 1 -location: Hamburg , date: 10-6-2006 , referee: 19
--goal: | T24 , SP: 11.Crespo (P: 9.Argentina) | T40 , SP: 12.Saviola (P: 9.Argentina) | T81 , SP: 1.Drogba (P: 10.Côte d’Ivoir) ---reprt_match: | T40 , SP: 12.Saviola (P: 9.Argentina) , yellow_card | T49 , SP: 2.Heinze (P: 9.Argentina) , yellow_card | T61 , SP: 2.Eboué (P: 10.Côte d’Ivoir) , yellow_card | T81 , SP: 13.Gonzalez (P: 9.Argentina) , yellow_card ----lineup player_home : | SP: 1.Abbondanzieri ,POS: 1 | SP: 2.Heinze ,POS: 2 | SP: 3.Ayala ,POS: 3 | SP: 4.Zanetti ,POS: 4 | SP: 5.Samuel ,POS: 5 | SP: 6.Sorin ,POS: 6 | SP: 7.Riquelme (C) ,POS: 7 | SP: 8.Messi ,POS: 8 | SP: 13.Gonzalez ,POS: 9 | SP: 9.Tevez ,POS: 9 | SP: 12.Saviola ,POS: 10 | SP: 10.Cambiasso ,POS: 10 | SP: 11.Crespo ,POS: 11 ----lineup player_away : | SP: 2.Eboué ,POS: 2 | SP: 1.Drogba ,POS: 10 ------------------------------------------------------match (id, player_home - player_away, score): 6 , 11.Serbia & Montenegro - 12.Netherlands , 0 - 1 -location: Leipzig , date: 11-6-2006 , referee: --goal: | T17 , SP: 10.Robben (P: 12.Netherlands) ---reprt_match: | T33 , SP: 2.Stankovic (P: 11.Serbia & Montenegro) , yellow_card | T55 , SP: 2.Bronkhorst van (P: 12.Netherlands) , yellow_card | T63 , SP: 3.Koroman (P: 11.Serbia & Montenegro) , yellow_card | T80 , SP: 4.Dragutinovic (P: 11.Serbia & Montenegro) , yellow_card | T84 , SP: 14.Heitinga (P: 12.Netherlands) , yellow_card | T89 , SP: 5.Gavrancic (P: 11.Serbia & Montenegro) , yellow_card ----lineup player_home : | SP: 5.Gavrancic | SP: 4.Dragutinovic | SP: 3.Koroman | SP: 2.Stankovic | SP: 1.Kezman ----lineup player_away : | SP: 7.Landzaat Tin: 59 | SP: 9.Kuyt Tin: 68 | SP: 5.Boulahrouz Tin: 85 | SP: 1.Sar van der (C) ,POS: 1 , PER: 7 | SP: 2.Bronkhorst van ,POS: 2 , PER: 6,5 | SP: 3.Mathijsen ,POS: 3 , PER: 5,5 Tout: 85 | SP: 4.Ooijer ,POS: 4 , PER: 8 | SP: 14.Heitinga ,POS: 5 , PER: 6,5 | SP: 6.Cocu ,POS: 6 , PER: 6,5 | SP: 15.Bommel van ,POS: 7 , PER: 7 Tout: 59 | SP: 16.Sneijder ,POS: 8 , PER: 5 | SP: 13.Persie van ,POS: 9 , PER: 6,5 | SP: 10.Robben ,POS: 10 , PER: 8 | SP: 11.Nistelrooy van ,POS: 11 , PER: 5 Tout: 68 ------------------------------------------------------match (id, player_home - player_away, score): 7 , 13.Mexico - 14.Iran , 3 - 1 -location: Nurnberg , date: 11-6-2006 , referee: --goal: | T27 , SP: 3.Bravo (P: 13.Mexico) | T35 , SP: 2.Golmohammadi (P: 14.Iran) | T75 , SP: 3.Bravo (P: 13.Mexico) | T78 , SP: 2.Zinha (P: 13.Mexico) ---reprt_match: | T17 , SP: 4.Torrado (P: 13.Mexico) , yellow_card | T53 , SP: 3.Nekounam (P: 14.Iran) , yellow_card | T89 , SP: 5.Salcido (P: 13.Mexico) , yellow_card ----lineup player_home : | SP: 5.Salcido | SP: 4.Torrado | SP: 3.Bravo | SP: 2.Zinha | SP: 1.Borgetti ----lineup player_away : | SP: 3.Nekounam | SP: 2.Golmohammadi | SP: 1.Daei ------------------------------------------------------match (id, player_home - player_away, score): 8 , 15.Angola - 16.Portugal , 0 - 1 -location: Koln , date: 11-6-2006 , referee: --goal: | T3 , SP: 3.Pauleta (P: 16.Portugal) ---reprt_match: | T24 , SP: 1.Ronaldo (P: 16.Portugal) , yellow_card | T25 , SP: 2.Jamba (P: 15.Angola) , yellow_card | T44 , SP: 3.Loco (P: 15.Angola) , yellow_card | T52 , SP: 4.Andre (P: 15.Angola) , yellow_card | T79 , SP: 4.Valente (P: 16.Portugal) , yellow_card
20
----lineup player_home : | SP: 4.Andre | SP: 3.Loco | SP: 2.Jamba | SP: 1.Manuel ----lineup player_away : | SP: 4.Valente | SP: 3.Pauleta | SP: 2.Figo | SP: 1.Ronaldo ------------------------------------------------------match (id, player_home - player_away, score): 9 , 23.Australia - 24.Japan , 3 - 1 -location: Kaiserslautern , date: 12-6-2006 , referee: --goal: | T26 , SP: 2.Nakamura (P: 24.Japan) | T84 , SP: 3.Cahill (P: 23.Australia) | T89 , SP: 3.Cahill (P: 23.Australia) | T90 , SP: 2.Aloisi (P: 23.Australia) ---reprt_match: | T31 , SP: 3.Miyamoto (P: 24.Japan) , yellow_card | T33 , SP: 4.Grella (P: 23.Australia) , yellow_card | T40 , SP: 4.Takahara (P: 24.Japan) , yellow_card | T57 , SP: 5.Moore (P: 23.Australia) , yellow_card | T68 , SP: 5.Moniwa (P: 24.Japan) , yellow_card | T69 , SP: 3.Cahill (P: 23.Australia) , yellow_card | T77 , SP: 2.Aloisi (P: 23.Australia) , yellow_card ----lineup player_home : | SP: 5.Moore | SP: 4.Grella | SP: 3.Cahill | SP: 2.Aloisi | SP: 1.Viduka ----lineup player_away : | SP: 5.Moniwa | SP: 4.Takahara | SP: 3.Miyamoto | SP: 2.Nakamura | SP: 1.Ono ------------------------------------------------------match (id, player_home - player_away, score): 10 , 19.USA - 20.Czech Republic , 0 - 3 -location: Gelsenkirchen , date: 12-6-2006 , referee: --goal: | T5 , SP: 4.Koller (P: 20.Czech Republic) | T36 , SP: 3.Rosicky (P: 20.Czech Republic) | T76 , SP: 3.Rosicky (P: 20.Czech Republic) ---reprt_match: | T4 , SP: 2.Onyewu (P: 19.USA) , yellow_card | T16 , SP: 5.Rozehnal (P: 20.Czech Republic) , yellow_card | T59 , SP: 6.Lokvenc (P: 20.Czech Republic) , yellow_card | T60 , SP: 1.Reyna (P: 19.USA) , yellow_card | T81 , SP: 3.Rosicky (P: 20.Czech Republic) , yellow_card | T88 , SP: 7.Grygera (P: 20.Czech Republic) , yellow_card ----lineup player_home : | SP: 2.Onyewu | SP: 1.Reyna ----lineup player_away : | SP: 7.Grygera | SP: 6.Lokvenc | SP: 5.Rozehnal | SP: 4.Koller | SP: 3.Rosicky | SP: 2.Baros | SP: 1.Nedved ------------------------------------------------------match (id, player_home - player_away, score): 11 , 17.Italy - 18.Ghana , 2 - 0 -location: Hannover , date: 12-6-2006 , referee: --goal: | T39 , SP: 3.Pirlo (P: 17.Italy) | T82 , SP: 4.Iaquinta (P: 17.Italy) ---reprt_match: | T10 , SP: 5.De Rossi (P: 17.Italy) , yellow_card | T41 , SP: 2.Muntari (P: 18.Ghana) , yellow_card | T62 , SP: 6.Camoranesi (P: 17.Italy) , yellow_card | T65 , SP: 3.Gyan (P: 18.Ghana) , yellow_card | T88 , SP: 4.Iaquinta (P: 17.Italy) , yellow_card ----lineup player_home : | SP: 6.Camoranesi | SP: 5.De Rossi | SP: 4.Iaquinta | SP: 3.Pirlo | SP: 2.Vieri | SP: 1.Totti ----lineup player_away : | SP: 3.Gyan | SP: 2.Muntari | SP: 1.Essien ------------------------------------------------------match (id, player_home - player_away, score): 12 , 27.South Korea - 28.Togo , 2 - 1 -location: Frankfurt , date: 13-6-2006 , referee: --goal: | T29 , SP: 2.Mohamed (P: 28.Togo) | T53 , SP: 3.Soo Lee (P: 27.South Korea) | T71 , SP: 2.Hwan Ahn (P: 27.South Korea) ---reprt_match: | T21 , SP: 3.Abalo (P: 28.Togo) , yellow_card | T22 , SP: 4.Romao (P: 28.Togo) , yellow_card | T38 , SP: 4.Chul Kim (P:
21
27.South Korea) , yellow_card | T50 , SP: 3.Soo Lee (P: 27.South Korea) , yellow_card | T52 , SP: 3.Abalo (P: 28.Togo) , yellow_card | T89 , SP: 5.Tchangai (P: 28.Togo) , yellow_card ----lineup player_home : | SP: 4.Chul Kim | SP: 3.Soo Lee | SP: 2.Hwan Ahn | SP: 1.Park ----lineup player_away : | SP: 5.Tchangai | SP: 4.Romao | SP: 3.Abalo | SP: 2.Mohamed | SP: 1.Adebayor ------------------------------------------------------match (id, player_home - player_away, score): 13 , 25.France - 26.Switzerland , 0 - 0 -location: Stuttgart , date: 13-6-2006 , referee: ---reprt_match: | T42 , SP: 2.Magnin (P: 26.Switzerland) , yellow_card | T45 , SP: 3.Streller (P: 26.Switzerland) , yellow_card | T56 , SP: 4.Degen (P: 26.Switzerland) , yellow_card | T64 , SP: 4.Abidal (P: 25.France) , yellow_card | T72 , SP: 2.Zidane (P: 25.France) , yellow_card | T72 , SP: 5.Cabanas (P: 26.Switzerland) , yellow_card | T90 , SP: 1.Frei (P: 26.Switzerland) , yellow_card | T90 , SP: 5.Sagnol (P: 25.France) , yellow_card ----lineup player_home : | SP: 5.Sagnol | SP: 4.Abidal | SP: 3.Trezeguet | SP: 2.Zidane | SP: 1.Henry ----lineup player_away : | SP: 5.Cabanas | SP: 4.Degen | SP: 3.Streller | SP: 2.Magnin | SP: 1.Frei ------------------------------------------------------match (id, player_home - player_away, score): 14 , 21.Brazil - 22.Croatia , 1 - 0 -location: Berlin , date: 13-6-2006 , referee: --goal: | T44 , SP: 5.Kaka (P: 21.Brazil) ----lineup player_home : | SP: 5.Kaka | SP: 4.Emerson | SP: 3.Carlos | SP: 2.Ronaldo | SP: 1.Ronaldinho ----lineup player_away : | SP: 1.Srna ------------------------------------------------------match (id, player_home - player_away, score): 15 , 29.Spain - 30.Ukraine , 4 - 0 -location: Leipzig , date: 14-6-2006 , referee: --goal: | T12 , SP: 1.Alonso (P: 29.Spain) | T15 , SP: 3.Villa (P: 29.Spain) | T47 , SP: 3.Villa (P: 29.Spain) (PNL) | T80 , SP: 4.Torres (P: 29.Spain) ----lineup player_home : | SP: 4.Torres | SP: 3.Villa | SP: 2.Raul | SP: 1.Alonso ----lineup player_away : | SP: 1.Sjevtsjenko ------------------------------------------------------match (id, player_home - player_away, score): 16 , 31.Tunisia - 32.Saudi Arabia , 2 - 2 -location: Munchen , date: 14-6-2006 , referee: --goal: | T23 , SP: 2.Jaziri (P: 31.Tunisia) | T57 , SP: 2.Kahtani (P: 32.Saudi Arabia) | T84 , SP: 3.Al Jaber (P: 32.Saudi Arabia) | T90 , SP: 3.Jaidi (P: 31.Tunisia) ----lineup player_home : | SP: 3.Jaidi | SP: 2.Jaziri | SP: 1.Trabelsi ----lineup player_away : | SP: 3.Al Jaber | SP: 2.Kahtani | SP: 1.Montashari ------------------------------------------------------match (id, player_home - player_away, score): 17 , 1.Germany - 3.Poland , 1 - 0 -location: Dortmund , date: 14-6-2006 , referee:
22
--goal: | T89 , SP: 5.Neuville (P: 1.Germany) ----lineup player_home : | SP: 5.Neuville | SP: 4.Frings | SP: 3.Lahm | SP: 2.Klose | SP: 1.Ballack ----lineup player_away : | SP: 2.Smolarek | SP: 1.Zurawski ------------------------------------------------------match (id, player_home - player_away, score): 18 , 4.Ecuador - 2.Costa Rica , 3 - 0 -location: Hamburg , date: 15-6-2006 , referee: --goal: | T7 , SP: 2.Tenorio (P: 4.Ecuador) | T53 , SP: 3.Delgado (P: 4.Ecuador) | T89 , SP: 5.Kaviedes (P: 4.Ecuador) ----lineup player_home : | SP: 5.Kaviedes | SP: 4.Mendez | SP: 3.Delgado | SP: 2.Tenorio | SP: 1.Hurtado ----lineup player_away : | SP: 2.Fonseca | SP: 1.Wanchope ------------------------------------------------------match (id, player_home - player_away, score): 19 , 5.England - 7.Trinidad & Tobago , 2 - 0 -location: Nurnberg , date: 15-6-2006 , referee: --goal: | T83 , SP: 7.Crouch (P: 5.England) | T90 , SP: 6.Gerard (P: 5.England) ----lineup player_home : | SP: 7.Crouch | SP: 6.Gerard | SP: 5.NN | SP: 4.Rooney | SP: 3.Owen | SP: 2.Beckham | SP: 1.Lampard ----lineup player_away : | SP: 2.John | SP: 1.Yorke ------------------------------------------------------match (id, player_home - player_away, score): 20 , 8.Sweden - 6.Paraguay , 1 - 0 -location: Berlin , date: 15-6-2006 , referee: --goal: | T89 , SP: 3.Ljungberg (P: 8.Sweden) ----lineup player_home : | SP: 3.Ljungberg | SP: 2.Larsson | SP: 1.Ibrahimovic ----lineup player_away : | SP: 2.Valdez | SP: 1.Cardozo ------------------------------------------------------match (id, player_home - player_away, score): 21 , 9.Argentina - 11.Serbia & Montenegro , 6 - 0 -location: Gelsenkirchen , date: 16-6-2006 , referee: --goal: | T5 , SP: 14.Rodriguez (P: 9.Argentina) | T31 , SP: 10.Cambiasso (P: 9.Argentina) | T41 , SP: 14.Rodriguez (P: 9.Argentina) | T78 , SP: 11.Crespo (P: 9.Argentina) | T84 , SP: 9.Tevez (P: 9.Argentina) | T88 , SP: 8.Messi (P: 9.Argentina) ----lineup player_home : | SP: 14.Rodriguez | SP: 13.Gonzalez | SP: 12.Saviola | SP: 1.Abbondanzieri ,POS: 1 | SP: 2.Heinze ,POS: 2 | SP: 3.Ayala ,POS: 3 | SP: 4.Zanetti ,POS: 4 | SP: 5.Samuel ,POS: 5 | SP: 6.Sorin ,POS: 6 | SP: 7.Riquelme (C) ,POS: 7 | SP: 8.Messi ,POS: 8 | SP: 9.Tevez ,POS: 9 | SP: 10.Cambiasso ,POS: 10 | SP: 11.Crespo ,POS: 11 ----lineup player_away : | SP: 5.Gavrancic | SP: 4.Dragutinovic | SP: 3.Koroman | SP: 2.Stankovic | SP: 1.Kezman ------------------------------------------------------match (id, player_home - player_away, score): 22 , 12.Netherlands - 10.Côte d’Ivoir , 2 - 1 -location: Stuttgart , date: 16-6-2006 , referee: --goal: | T22 , SP: 13.Persie van (P: 12.Netherlands) | T27 , SP: 11.Nistelrooy van (P: 12.Netherlands) | T37 , SP: 3.Kone (P: 10.Côte d’Ivoir) ---reprt_match: | T34 , SP: 10.Robben (P: 12.Netherlands) , yellow_card | T35 , SP: 3.Mathijsen (P: 12.Netherlands) , yellow_card | T57 , SP: 15.Bommel van (P: 12.Netherlands) , yellow_card | T89 , SP: 5.Boulahrouz (P: 12.Netherlands) , yellow_card
23
----lineup player_home : | SP: 8.Vaart van der Tin: 49 | SP: 7.Landzaat Tin: 73 | SP: 1.Sar van der (C) ,POS: 1 , PER: 7 | SP: 2.Bronkhorst van ,POS: 2 , PER: 6,5 | SP: 3.Mathijsen ,POS: 3 , PER: 6,5 | SP: 4.Ooijer ,POS: 4 , PER: 5 | SP: 14.Heitinga ,POS: 5 , PER: 5,5 Tout: 46 | SP: 5.Boulahrouz ,POS: 5 , PER: 7 Tin: 46 | SP: 6.Cocu ,POS: 6 , PER: 6 | SP: 15.Bommel van ,POS: 7 , PER: 6 | SP: 16.Sneijder ,POS: 8 , PER: 6 Tout: 49 | SP: 13.Persie van ,POS: 9 , PER: 7,5 | SP: 10.Robben ,POS: 10 , PER: 6,5 | SP: 11.Nistelrooy van ,POS: 11 , PER: 6 Tout: 73 ----lineup player_away : | SP: 3.Kone | SP: 2.Eboué ,POS: 2 | SP: 1.Drogba ,POS: 10 ------------------------------------------------------match (id, player_home - player_away, score): 23 , 13.Mexico - 15.Angola , 0 - 0 -location: Hannover , date: 16-6-2006 , referee: ----lineup player_home : | SP: 5.Salcido | SP: 4.Torrado | SP: 3.Bravo | SP: 2.Zinha | SP: 1.Borgetti ----lineup player_away : | SP: 4.Andre | SP: 3.Loco | SP: 2.Jamba | SP: 1.Manuel ------------------------------------------------------match (id, player_home - player_away, score): 24 , 16.Portugal - 14.Iran , 2 - 0 -location: Frankfurt , date: 17-6-2006 , referee: --goal: | T63 , SP: 5.Deco (P: 16.Portugal) | T78 , SP: 1.Ronaldo (P: 16.Portugal) ----lineup player_home : | SP: 5.Deco | SP: 4.Valente | SP: 3.Pauleta | SP: 2.Figo | SP: 1.Ronaldo ----lineup player_away : | SP: 3.Nekounam | SP: 2.Golmohammadi | SP: 1.Daei ------------------------------------------------------match (id, player_home - player_away, score): 25 , 20.Czech Republic - 18.Ghana , 0 - 2 -location: Koln , date: 17-6-2006 , referee: --goal: | T1 , SP: 3.Gyan (P: 18.Ghana) | T81 , SP: 2.Muntari (P: 18.Ghana) ----lineup player_home : | SP: 7.Grygera | SP: 6.Lokvenc | SP: 5.Rozehnal | SP: 4.Koller | SP: 3.Rosicky | SP: 2.Baros | SP: 1.Nedved ----lineup player_away : | SP: 3.Gyan | SP: 2.Muntari | SP: 1.Essien ------------------------------------------------------match (id, player_home - player_away, score): 26 , 17.Italy - 19.USA , 1 - 1 -location: Kaiserslautern , date: 17-6-2006 , referee: --goal: | T22 , SP: 7.Gilardino (P: 17.Italy) | T27 , SP: 3.NN (P: 19.USA) ----lineup player_home : | SP: 8.NN | SP: 7.Gilardino | SP: 6.Camoranesi | SP: 5.De Rossi | SP: 4.Iaquinta | SP: 3.Pirlo | SP: 2.Vieri | SP: 1.Totti ----lineup player_away : | SP: 3.NN | SP: 2.Onyewu | SP: 1.Reyna ------------------------------------------------------match (id, player_home - player_away, score): 27 , 24.Japan - 22.Croatia , 0 - 0 -location: Nurnberg , date: 18-6-2006 , referee: ----lineup player_home : | SP: 5.Moniwa | SP: 4.Takahara | SP: 3.Miyamoto | SP: 2.Nakamura | SP: 1.Ono ----lineup player_away : | SP: 1.Srna ------------------------------------------------------match (id, player_home - player_away, score): 28 , 21.Brazil - 23.Australia , 2 - 0 -location: Munchen , date: 18-6-2006 , referee: --goal: | T49 , SP: 6.Adriano (P: 21.Brazil) | T89 , SP: 7.Fred (P: 21.Brazil) ----lineup player_home : | SP: 7.Fred | SP: 6.Adriano | SP: 5.Kaka | SP: 4.Emerson | SP: 3.Carlos | SP: 2.Ronaldo | SP: 1.Ronaldinho
24
----lineup player_away : | SP: 5.Moore | SP: 4.Grella | SP: 3.Cahill | SP: 2.Aloisi | SP: 1.Viduka ------------------------------------------------------match (id, player_home - player_away, score): 29 , 25.France - 27.South Korea , 1 - 1 -location: Leipzig , date: 18-6-2006 , referee: --goal: | T8 , SP: 1.Henry (P: 25.France) | T80 , SP: 1.Park (P: 27.South Korea) ----lineup player_home : | SP: 5.Sagnol | SP: 4.Abidal | SP: 3.Trezeguet | SP: 2.Zidane | SP: 1.Henry ----lineup player_away : | SP: 4.Chul Kim | SP: 3.Soo Lee | SP: 2.Hwan Ahn | SP: 1.Park ------------------------------------------------------match (id, player_home - player_away, score): 30 , 28.Togo - 26.Switzerland , 0 - 2 -location: Dortmund , date: 19-6-2006 , referee: --goal: | T15 , SP: 1.Frei (P: 26.Switzerland) | T87 , SP: 6.Barnetta (P: 26.Switzerland) ----lineup player_home : | SP: 5.Tchangai | SP: 4.Romao | SP: 3.Abalo | SP: 2.Mohamed | SP: 1.Adebayor ----lineup player_away : | SP: 6.Barnetta | SP: 5.Cabanas | SP: 4.Degen | SP: 3.Streller | SP: 2.Magnin | SP: 1.Frei ------------------------------------------------------match (id, player_home - player_away, score): 31 , 32.Saudi Arabia - 30.Ukraine , 0 - 4 -location: Hamburg , date: 19-6-2006 , referee: --goal: | T3 , SP: 2.Rusol (P: 30.Ukraine) | T36 , SP: 3.Rebrov (P: 30.Ukraine) | T46 , SP: 1.Sjevtsjenko (P: 30.Ukraine) | T82 , SP: 4.Kalinichenko (P: 30.Ukraine) ----lineup player_home : | SP: 3.Al Jaber | SP: 2.Kahtani | SP: 1.Montashari ----lineup player_away : | SP: 4.Kalinichenko | SP: 3.Rebrov | SP: 2.Rusol | SP: 1.Sjevtsjenko ------------------------------------------------------match (id, player_home - player_away, score): 32 , 29.Spain - 31.Tunisia , 3 - 1 -location: Stuttgart , date: 19-6-2006 , referee: --goal: | T7 , SP: 4.Mnari (P: 31.Tunisia) | T70 , SP: 2.Raul (P: 29.Spain) | T75 , SP: 4.Torres (P: 29.Spain) | T88 , SP: 4.Torres (P: 29.Spain) (PNL) ----lineup player_home : | SP: 4.Torres | SP: 3.Villa | SP: 2.Raul | SP: 1.Alonso ----lineup player_away : | SP: 4.Mnari | SP: 3.Jaidi | SP: 2.Jaziri | SP: 1.Trabelsi ------------------------------------------------------match (id, player_home - player_away, score): 33 , 4.Ecuador - 1.Germany , 0 - 3 -location: Berlin , date: 20-6-2006 , referee: --goal: | T4 , SP: 2.Klose (P: 1.Germany) | T44 , SP: 2.Klose (P: 1.Germany) | T57 , SP: 6.Podolski (P: 1.Germany) ----lineup player_home : | SP: 6.Valencia | SP: 5.Kaviedes | SP: 4.Mendez | SP: 3.Delgado | SP: 2.Tenorio | SP: 1.Hurtado ----lineup player_away : | SP: 6.Podolski | SP: 5.Neuville | SP: 4.Frings | SP: 3.Lahm | SP: 2.Klose | SP: 1.Ballack ------------------------------------------------------match (id, player_home - player_away, score): 34 , 2.Costa Rica - 3.Poland , 1 - 2 -location: Hannover , date: 20-6-2006 , referee:
25
--goal: | T25 , SP: 3.Gomez (P: 2.Costa Rica) | T33 , SP: 3.Bosacki (P: 3.Poland) | T67 , SP: 3.Bosacki (P: 3.Poland) ----lineup player_home : | SP: 3.Gomez | SP: 2.Fonseca | SP: 1.Wanchope ----lineup player_away : | SP: 3.Bosacki | SP: 2.Smolarek | SP: 1.Zurawski ------------------------------------------------------match (id, player_home - player_away, score): 35 , 6.Paraguay - 7.Trinidad & Tobago , 2 - 0 -location: Kaiserslautern , date: 20-6-2006 , referee: --goal: | T25 , SP: 3.NN (P: 6.Paraguay) | T86 , SP: 4.Cuevas (P: 6.Paraguay) ----lineup player_home : | SP: 4.Cuevas | SP: 3.NN | SP: 2.Valdez | SP: 1.Cardozo ----lineup player_away : | SP: 2.John | SP: 1.Yorke ------------------------------------------------------match (id, player_home - player_away, score): 36 , 8.Sweden - 5.England , 2 - 2 -location: Koln , date: 20-6-2006 , referee: --goal: | T33 , SP: 8.Cole (P: 5.England) | T50 , SP: 4.Allback (P: 8.Sweden) | T84 , SP: 6.Gerard (P: 5.England) | T89 , SP: 2.Larsson (P: 8.Sweden) ----lineup player_home : | SP: 4.Allback | SP: 3.Ljungberg | SP: 2.Larsson | SP: 1.Ibrahimovic ----lineup player_away : | SP: 8.Cole | SP: 7.Crouch | SP: 6.Gerard | SP: 5.NN | SP: 4.Rooney | SP: 3.Owen | SP: 2.Beckham | SP: 1.Lampard ------------------------------------------------------match (id, player_home - player_away, score): 37 , 16.Portugal - 13.Mexico , 2 - 1 -location: Gelsenkirchen , date: 21-6-2006 , referee: --goal: | T5 , SP: 6.Maniche (P: 16.Portugal) | T23 , SP: 7.Simao (P: 16.Portugal) (PNL) | T31 , SP: 6.Fonseca (P: 13.Mexico) ----lineup player_home : | SP: 7.Simao | SP: 6.Maniche | SP: 5.Deco | SP: 4.Valente | SP: 3.Pauleta | SP: 2.Figo | SP: 1.Ronaldo ----lineup player_away : | SP: 6.Fonseca | SP: 5.Salcido | SP: 4.Torrado | SP: 3.Bravo | SP: 2.Zinha | SP: 1.Borgetti ------------------------------------------------------match (id, player_home - player_away, score): 38 , 14.Iran - 15.Angola , 1 - 1 -location: Leipzig , date: 21-6-2006 , referee: --goal: | T60 , SP: 5.Flavio (P: 15.Angola) | T75 , SP: 4.Bakhtiarizadeh (P: 14.Iran) ----lineup player_home : | SP: 4.Bakhtiarizadeh | SP: 3.Nekounam | SP: 2.Golmohammadi | SP: 1.Daei ----lineup player_away : | SP: 5.Flavio | SP: 4.Andre | SP: 3.Loco | SP: 2.Jamba | SP: 1.Manuel ------------------------------------------------------match (id, player_home - player_away, score): 39 , 12.Netherlands - 9.Argentina , 0 - 0 -location: Frankfurt , date: 21-6-2006 , referee: ---reprt_match: | T27 , SP: 9.Kuyt (P: 12.Netherlands) , yellow_card | T42 , SP: 4.Ooijer (P: 12.Netherlands) , yellow_card | T48 , SP: 18.Cler de (P: 12.Netherlands) , yellow_card ----lineup player_home : | SP: 19.Babel Tin: 55 | SP: 7.Landzaat Tin: 66 | SP: 12.Maduro Tin: 85 | SP: 1.Sar van der (C) ,POS: 1 , PER: 7,5 | SP: 17.Jaliens ,POS: 2 , PER: 5,5 | SP: 18.Cler de ,POS: 3 , PER: 7 | SP: 4.Ooijer ,POS: 4 , PER: 7 | SP: 5.Boulahrouz ,POS: 5 , PER: 8 | SP: 6.Cocu
26
,POS: 6 , PER: 5 | SP: 8.Vaart van der ,POS: 8 , PER: 6,5 | SP: 13.Persie van ,POS: 9 , PER: 6 Tout: 66 | SP: 9.Kuyt ,POS: 9 , PER: 5,5 | SP: 16.Sneijder ,POS: 10 , PER: 7 Tout: 85 | SP: 11.Nistelrooy van ,POS: 11 , PER: 5,5 Tout: 55 ----lineup player_away : | SP: 14.Rodriguez | SP: 13.Gonzalez | SP: 12.Saviola | SP: 1.Abbondanzieri ,POS: 1 | SP: 2.Heinze ,POS: 2 | SP: 3.Ayala ,POS: 3 | SP: 4.Zanetti ,POS: 4 | SP: 5.Samuel ,POS: 5 | SP: 6.Sorin ,POS: 6 | SP: 7.Riquelme (C) ,POS: 7 | SP: 8.Messi ,POS: 8 | SP: 9.Tevez ,POS: 9 | SP: 10.Cambiasso ,POS: 10 | SP: 11.Crespo ,POS: 11 ------------------------------------------------------match (id, player_home - player_away, score): 40 , 10.Côte d’Ivoir - 11.Serbia & Montenegro , 3 - 2 -location: Munchen , date: 21-6-2006 , referee: --goal: | T10 , SP: 6.Zigic (P: 11.Serbia & Montenegro) | T22 , SP: 7.Ilic (P: 11.Serbia & Montenegro) | T37 , SP: 4.Dindane (P: 10.Côte d’Ivoir) (PNL) | T67 , SP: 4.Dindane (P: 10.Côte d’Ivoir) | T86 , SP: 5.Kalou (P: 10.Côte d’Ivoir) (PNL) ----lineup player_home : | SP: 5.Kalou | SP: 4.Dindane | SP: 3.Kone | SP: 2.Eboué ,POS: 2 | SP: 1.Drogba ,POS: 10 ----lineup player_away : | SP: 7.Ilic | SP: 6.Zigic | SP: 5.Gavrancic | SP: 4.Dragutinovic | SP: 3.Koroman | SP: 2.Stankovic | SP: 1.Kezman ------------------------------------------------------match (id, player_home - player_away, score): 41 , 20.Czech Republic - 17.Italy , 0 - 2 -location: Hamburg , date: 22-6-2006 , referee: --goal: | T25 , SP: 9.Materazzi (P: 17.Italy) | T87 , SP: 10.Inzaghi (P: 17.Italy) ----lineup player_home : | SP: 7.Grygera | SP: 6.Lokvenc | SP: 5.Rozehnal | SP: 4.Koller | SP: 3.Rosicky | SP: 2.Baros | SP: 1.Nedved ----lineup player_away : | SP: 10.Inzaghi | SP: 9.Materazzi | SP: 8.NN | SP: 7.Gilardino | SP: 6.Camoranesi | SP: 5.De Rossi | SP: 4.Iaquinta | SP: 3.Pirlo | SP: 2.Vieri | SP: 1.Totti ------------------------------------------------------match (id, player_home - player_away, score): 42 , 18.Ghana - 19.USA , 2 - 1 -location: Nurnberg , date: 22-6-2006 , referee: --goal: | T23 , SP: 4.Dramani (P: 18.Ghana) | T43 , SP: 4.Dempsey (P: 19.USA) | T45 , SP: 5.Appiah (P: 18.Ghana) (PNL) ----lineup player_home : | SP: 5.Appiah | SP: 4.Dramani | SP: 3.Gyan | SP: 2.Muntari | SP: 1.Essien ----lineup player_away : | SP: 4.Dempsey | SP: 3.NN | SP: 2.Onyewu | SP: 1.Reyna ------------------------------------------------------match (id, player_home - player_away, score): 43 , 24.Japan - 21.Brazil , 1 - 4 -location: Dortmund , date: 22-6-2006 , referee: --goal: | T32 , SP: 6.Tamada (P: 24.Japan) | T45 , SP: 2.Ronaldo (P: 21.Brazil) | T52 , SP: 8.Pernambucano (P: 21.Brazil) | T57 , SP: 9.Gilberto (P: 21.Brazil) | T77 , SP: 2.Ronaldo (P: 21.Brazil) ----lineup player_home : | SP: 6.Tamada | SP: 5.Moniwa | SP: 4.Takahara | SP: 3.Miyamoto | SP: 2.Nakamura | SP: 1.Ono ----lineup player_away : | SP: 9.Gilberto | SP: 8.Pernambucano | SP: 7.Fred | SP: 6.Adriano | SP: 5.Kaka | SP: 4.Emerson | SP: 3.Carlos | SP: 2.Ronaldo | SP: 1.Ronaldinho ------------------------------------------------------match (id, player_home - player_away, score): 44 , 22.Croatia - 23.Australia , 2 - 2 -location: Stuttgart , date: 22-6-2006 , referee:
27
--goal: | T2 , SP: 1.Srna (P: 22.Croatia) | T38 , SP: 5.Moore (P: 23.Australia) (PNL) | T56 , SP: 2.Kovac (P: 22.Croatia) | T78 , SP: 6.Kewell (P: 23.Australia) ----lineup player_home : | SP: 2.Kovac | SP: 1.Srna ----lineup player_away : | SP: 6.Kewell | SP: 5.Moore | SP: 4.Grella | SP: 3.Cahill | SP: 2.Aloisi | SP: 1.Viduka ------------------------------------------------------match (id, player_home - player_away, score): 45 , 30.Ukraine - 31.Tunisia , 1 - 0 -location: Berlin , date: 23-6-2006 , referee: --goal: | T69 , SP: 1.Sjevtsjenko (P: 30.Ukraine) (PNL) ----lineup player_home : | SP: 4.Kalinichenko | SP: 3.Rebrov | SP: 2.Rusol | SP: 1.Sjevtsjenko ----lineup player_away : | SP: 4.Mnari | SP: 3.Jaidi | SP: 2.Jaziri | SP: 1.Trabelsi ------------------------------------------------------match (id, player_home - player_away, score): 46 , 32.Saudi Arabia - 29.Spain , 0 - 1 -location: Kaiserslautern , date: 23-6-2006 , referee: --goal: | T36 , SP: 5.Juanito (P: 29.Spain) ----lineup player_home : | SP: 3.Al Jaber | SP: 2.Kahtani | SP: 1.Montashari ----lineup player_away : | SP: 5.Juanito | SP: 4.Torres | SP: 3.Villa | SP: 2.Raul | SP: 1.Alonso ------------------------------------------------------match (id, player_home - player_away, score): 47 , 26.Switzerland - 27.South Korea , 2 - 0 -location: Hannover , date: 23-6-2006 , referee: --goal: | T23 , SP: 7.Senderos (P: 26.Switzerland) | T77 , SP: 1.Frei (P: 26.Switzerland) ----lineup player_home : | SP: 7.Senderos | SP: 6.Barnetta | SP: 5.Cabanas | SP: 4.Degen | SP: 3.Streller | SP: 2.Magnin | SP: 1.Frei ----lineup player_away : | SP: 4.Chul Kim | SP: 3.Soo Lee | SP: 2.Hwan Ahn | SP: 1.Park ------------------------------------------------------match (id, player_home - player_away, score): 48 , 28.Togo - 25.France , 0 - 2 -location: Koln , date: 23-6-2006 , referee: --goal: | T54 , SP: 6.Vieira (P: 25.France) | T60 , SP: 1.Henry (P: 25.France) ----lineup player_home : | SP: 5.Tchangai | SP: 4.Romao | SP: 3.Abalo | SP: 2.Mohamed | SP: 1.Adebayor ----lineup player_away : | SP: 6.Vieira | SP: 5.Sagnol | SP: 4.Abidal | SP: 3.Trezeguet | SP: 2.Zidane | SP: 1.Henry ------------------------------------------------------match (id, player_home - player_away, score): 10001 , 1.Germany - 8.Sweden , 2 - 0 -location: Munchen , date: 24-6-2006 , referee: --goal: | T4 , SP: 6.Podolski (P: 1.Germany) | T12 , SP: 6.Podolski (P: 1.Germany) ----lineup player_home : | SP: 6.Podolski | SP: 5.Neuville | SP: 4.Frings | SP: 3.Lahm | SP: 2.Klose | SP: 1.Ballack ----lineup player_away : | SP: 4.Allback | SP: 3.Ljungberg | SP: 2.Larsson | SP: 1.Ibrahimovic ------------------------------------------------------match (id, player_home - player_away, score): 10002 , 9.Argentina - 13.Mexico , 2 - 1
28
-location: Leipzig , date: 24-6-2006 , referee: Merk --goal: | T6 , SP: 7.Marquez (P: 13.Mexico) | T10 , SP: 15.NN (P: 9.Argentina) | T98 , SP: 14.Rodriguez (P: 9.Argentina) ----lineup player_home : | SP: 15.NN | SP: 14.Rodriguez | SP: 13.Gonzalez | SP: 12.Saviola | SP: 1.Abbondanzieri ,POS: 1 | SP: 2.Heinze ,POS: 2 | SP: 3.Ayala ,POS: 3 | SP: 4.Zanetti ,POS: 4 | SP: 5.Samuel ,POS: 5 | SP: 6.Sorin ,POS: 6 | SP: 7.Riquelme (C) ,POS: 7 | SP: 8.Messi ,POS: 8 | SP: 9.Tevez ,POS: 9 | SP: 10.Cambiasso ,POS: 10 | SP: 11.Crespo ,POS: 11 ----lineup player_away : | SP: 7.Marquez | SP: 6.Fonseca | SP: 5.Salcido | SP: 4.Torrado | SP: 3.Bravo | SP: 2.Zinha | SP: 1.Borgetti ------------------------------------------------------match (id, player_home - player_away, score): 10003 , 5.England - 4.Ecuador , 1 - 0 -location: Stuttgart , date: 25-6-2006 , referee: --goal: | T59 , SP: 2.Beckham (P: 5.England) ----lineup player_home : | SP: 8.Cole | SP: 7.Crouch | SP: 6.Gerard | SP: 5.NN | SP: 4.Rooney | SP: 3.Owen | SP: 2.Beckham | SP: 1.Lampard ----lineup player_away : | SP: 6.Valencia | SP: 5.Kaviedes | SP: 4.Mendez | SP: 3.Delgado | SP: 2.Tenorio | SP: 1.Hurtado ------------------------------------------------------match (id, player_home - player_away, score): 10004 , 16.Portugal - 12.Netherlands , 1 - 0 -location: Nurnberg , date: 25-6-2006 , referee: --goal: | T22 , SP: 6.Maniche (P: 16.Portugal) ---reprt_match: | T2 , SP: 15.Bommel van (P: 12.Netherlands) , yellow_card | T7 , SP: 5.Boulahrouz (P: 12.Netherlands) , yellow_card | T19 , SP: 6.Maniche (P: 16.Portugal) , yellow_card | T30 , SP: 9.Costinha (P: 16.Portugal) , yellow_card | T44 , SP: 9.Costinha (P: 16.Portugal) , red_card | T49 , SP: 10.Petit (P: 16.Portugal) , yellow_card | T58 , SP: 2.Figo (P: 16.Portugal) , yellow_card | T58 , SP: 2.Bronkhorst van (P: 12.Netherlands) , yellow_card | T62 , SP: 5.Boulahrouz (P: 12.Netherlands) , red_card | T72 , SP: 5.Deco (P: 16.Portugal) , yellow_card | T73 , SP: 8.Vaart van der (P: 12.Netherlands) , yellow_card | T73 , SP: 16.Sneijder (P: 12.Netherlands) , yellow_card | T74 , SP: 11.Ricardo (P: 16.Portugal) , yellow_card | T75 , SP: 4.Valente (P: 16.Portugal) , yellow_card | T77 , SP: 5.Deco (P: 16.Portugal) , red_card | T89 , SP: 2.Bronkhorst van (P: 12.Netherlands) , red_card ----lineup player_home : | SP: 10.Petit | SP: 1.Ronaldo | SP: 4.Valente | SP: 8.NN | SP: 11.Ricardo | SP: 6.Maniche | SP: 5.Deco | SP: 7.Simao | SP: 3.Pauleta | SP: 9.Costinha | SP: 2.Figo ----lineup player_away : | SP: 16.Sneijder , PER: 6 | SP: 15.Bommel van , PER: 6 Tout: 66 | SP: 13.Persie van , PER: 7 | SP: 14.Heitinga Tin: 66 | SP: 20.Vennegoor of Hesselink Tin: 83 | SP: 1.Sar van der (C) ,POS: 1 , PER: 8 | SP: 2.Bronkhorst van ,POS: 2 , PER: 6 | SP: 3.Mathijsen ,POS: 3 , PER: 6 Tout: 52 | SP: 4.Ooijer ,POS: 4 , PER: 7 | SP: 5.Boulahrouz ,POS: 5 , PER: 5 | SP: 6.Cocu ,POS: 6 , PER: 5,5 Tout: 83 | SP: 8.Vaart van der ,POS: 8 Tin: 52 | SP: 9.Kuyt ,POS: 9 , PER: 6,5 | SP: 10.Robben ,POS: 10 , PER: 5 ------------------------------------------------------match (id, player_home - player_away, score): 10005 , 17.Italy - 23.Australia , 1 - 0 -location: Kaiserslautern , date: 26-6-2006 , referee: --goal: | T90 , SP: 1.Totti (P: 17.Italy) (PNL)
29
----lineup player_home : | SP: 10.Inzaghi | SP: 9.Materazzi | SP: 8.NN | SP: 7.Gilardino | SP: 6.Camoranesi | SP: 5.De Rossi | SP: 4.Iaquinta | SP: 3.Pirlo | SP: 2.Vieri | SP: 1.Totti ----lineup player_away : | SP: 6.Kewell | SP: 5.Moore | SP: 4.Grella | SP: 3.Cahill | SP: 2.Aloisi | SP: 1.Viduka ------------------------------------------------------match (id, player_home - player_away, score): 10006 , 26.Switzerland - 30.Ukraine , 0 - 1 -location: Koln , date: 26-6-2006 , referee: --goal: | T121 , SP: 5.NN (P: 30.Ukraine) (PNL) ----lineup player_home : | SP: 7.Senderos | SP: 6.Barnetta | SP: 5.Cabanas | SP: 4.Degen | SP: 3.Streller | SP: 2.Magnin | SP: 1.Frei ----lineup player_away : | SP: 5.NN | SP: 4.Kalinichenko | SP: 3.Rebrov | SP: 2.Rusol | SP: 1.Sjevtsjenko ------------------------------------------------------match (id, player_home - player_away, score): 10007 , 21.Brazil - 18.Ghana , 3 - 0 -location: Dortmund , date: 27-6-2006 , referee: --goal: | T4 , SP: 2.Ronaldo (P: 21.Brazil) | T44 , SP: 6.Adriano (P: 21.Brazil) | T83 , SP: 10.Ze Roberto (P: 21.Brazil) ----lineup player_home : | SP: 10.Ze Roberto | SP: 9.Gilberto | SP: 8.Pernambucano | SP: 7.Fred | SP: 6.Adriano | SP: 5.Kaka | SP: 4.Emerson | SP: 3.Carlos | SP: 2.Ronaldo | SP: 1.Ronaldinho ----lineup player_away : | SP: 5.Appiah | SP: 4.Dramani | SP: 3.Gyan | SP: 2.Muntari | SP: 1.Essien ------------------------------------------------------match (id, player_home - player_away, score): 10008 , 29.Spain - 25.France , 1 - 3 -location: Hannover , date: 27-6-2006 , referee: --goal: | T26 , SP: 3.Villa (P: 29.Spain) (PNL) | T41 , SP: 7.Ribery (P: 25.France) | T82 , SP: 6.Vieira (P: 25.France) | T90 , SP: 2.Zidane (P: 25.France) ----lineup player_home : | SP: 1.Alonso | SP: 2.Raul | SP: 3.Villa | SP: 4.Torres | SP: 5.Juanito ----lineup player_away : | SP: 1.Henry | SP: 2.Zidane | SP: 3.Trezeguet | SP: 4.Abidal | SP: 5.Sagnol | SP: 6.Vieira | SP: 7.Ribery ------------------------------------------------------match (id, player_home - player_away, score): 10009 , 1.Germany - 9.Argentina , 2 - 1 -location: Berlin , date: 30-6-2006 , referee: --goal: | T49 , SP: 3.Ayala (P: 9.Argentina) | T80 , SP: 2.Klose (P: 1.Germany) | T121 , SP: 7.NN (P: 1.Germany) (PNL) ----lineup player_home : | SP: 7.NN | SP: 6.Podolski | SP: 5.Neuville | SP: 4.Frings | SP: 3.Lahm | SP: 2.Klose | SP: 1.Ballack ----lineup player_away : | SP: 15.NN | SP: 14.Rodriguez | SP: 13.Gonzalez | SP: 12.Saviola | SP: 1.Abbondanzieri ,POS: 1 | SP: 2.Heinze ,POS: 2 | SP: 3.Ayala ,POS: 3 | SP: 4.Zanetti ,POS: 4 | SP: 5.Samuel ,POS: 5 | SP: 6.Sorin ,POS: 6 | SP: 7.Riquelme (C) ,POS: 7 | SP: 8.Messi ,POS: 8 | SP: 9.Tevez ,POS: 9 | SP: 10.Cambiasso ,POS: 10 | SP: 11.Crespo ,POS: 11 ------------------------------------------------------match (id, player_home - player_away, score): 10010 , 17.Italy - 30.Ukraine , 3 - 0
30
-location: Hamburg , date: 30-6-2006 , referee: --goal: | T5 , SP: 12.Zambrotta (P: 17.Italy) | T58 , SP: 11.Toni (P: 17.Italy) | T68 , SP: 11.Toni (P: 17.Italy) ----lineup player_home : | SP: 12.Zambrotta | SP: 11.Toni | SP: 10.Inzaghi | SP: 9.Materazzi | SP: 8.NN | SP: 7.Gilardino | SP: 6.Camoranesi | SP: 5.De Rossi | SP: 4.Iaquinta | SP: 3.Pirlo | SP: 2.Vieri | SP: 1.Totti ----lineup player_away : | SP: 5.NN | SP: 4.Kalinichenko | SP: 3.Rebrov | SP: 2.Rusol | SP: 1.Sjevtsjenko ------------------------------------------------------match (id, player_home - player_away, score): 10011 , 5.England - 16.Portugal , 0 - 1 -location: Gelsenkirchen , date: 1-7-2006 , referee: --goal: | T121 , SP: 8.NN (P: 16.Portugal) (PNL) ----lineup player_home : | SP: 8.Cole | SP: 7.Crouch | SP: 6.Gerard | SP: 5.NN | SP: 4.Rooney | SP: 3.Owen | SP: 2.Beckham | SP: 1.Lampard ----lineup player_away : | SP: 8.NN | SP: 7.Simao | SP: 6.Maniche | SP: 5.Deco | SP: 4.Valente | SP: 3.Pauleta | SP: 2.Figo | SP: 1.Ronaldo ------------------------------------------------------match (id, player_home - player_away, score): 10012 , 21.Brazil - 25.France , 0 - 1 -location: Frankfurt , date: 1-7-2006 , referee: --goal: | T56 , SP: 1.Henry (P: 25.France) ----lineup player_home : | SP: 10.Ze Roberto | SP: 9.Gilberto | SP: 8.Pernambucano | SP: 7.Fred | SP: 6.Adriano | SP: 5.Kaka | SP: 4.Emerson | SP: 3.Carlos | SP: 2.Ronaldo | SP: 1.Ronaldinho ----lineup player_away : | SP: 6.Vieira | SP: 5.Sagnol | SP: 4.Abidal | SP: 3.Trezeguet | SP: 2.Zidane | SP: 1.Henry ------------------------------------------------------match (id, player_home - player_away, score): 10013 , 1.Germany - 17.Italy , 0 - 2 -location: Dortmund , date: 4-7-2006 , referee: --goal: | T119 , SP: 13.Grosso (P: 17.Italy) | T120 , SP: 14.Del Piero (P: 17.Italy) ----lineup player_home : | SP: 1.Ballack | SP: 5.Neuville | SP: 7.NN | SP: 4.Frings | SP: 3.Lahm | SP: 2.Klose | SP: 6.Podolski ----lineup player_away : | SP: 5.De Rossi | SP: 13.Grosso | SP: 12.Zambrotta | SP: 11.Toni | SP: 10.Inzaghi | SP: 9.Materazzi | SP: 8.NN | SP: 7.Gilardino | SP: 14.Del Piero | SP: 6.Camoranesi | SP: 4.Iaquinta | SP: 3.Pirlo | SP: 2.Vieri | SP: 1.Totti ------------------------------------------------------match (id, player_home - player_away, score): 10014 , 16.Portugal - 25.France , 0 - 1 -location: Munchen , date: 5-7-2006 , referee: --goal: | T33 , SP: 2.Zidane (P: 25.France) (PNL) ----lineup player_home : | SP: 3.Pauleta | SP: 4.Valente | SP: 1.Ronaldo | SP: 2.Figo | SP: 6.Maniche | SP: 7.Simao | SP: 8.NN | SP: 9.Costinha | SP: 10.Petit | SP: 11.Ricardo | SP: 5.Deco ----lineup player_away : | SP: 4.Abidal | SP: 6.Vieira | SP: 7.Ribery | SP: 5.Sagnol | SP: 3.Trezeguet | SP: 2.Zidane | SP: 1.Henry
31
------------------------------------------------------match (id, player_home - player_away, score): 10015 , 1.Germany - 16.Portugal , 3 - 1 -location: Stuttgart , date: 8-7-2006 , referee: --goal: | T56 , SP: 8.Schweinsteiger (P: 1.Germany) | T61 , SP: 7.NN (P: 1.Germany) | T78 , SP: 8.Schweinsteiger (P: 1.Germany) | T88 , SP: 12.Gomes (P: 16.Portugal) ----lineup player_home : | SP: 8.Schweinsteiger | SP: 7.NN | SP: 5.Neuville | SP: 1.Ballack | SP: 4.Frings | SP: 3.Lahm | SP: 2.Klose | SP: 6.Podolski ----lineup player_away : | SP: 5.Deco | SP: 1.Ronaldo | SP: 2.Figo | SP: 11.Ricardo | SP: 3.Pauleta | SP: 10.Petit | SP: 4.Valente | SP: 9.Costinha | SP: 8.NN | SP: 12.Gomes | SP: 6.Maniche | SP: 7.Simao ------------------------------------------------------match (id, player_home - player_away, score): 10016 , 17.Italy - 25.France , 2 - 1 -location: Berlin , date: 9-7-2006 , referee: --goal: | T5 , SP: 2.Zidane (P: 25.France) (PNL) | T18 , SP: 9.Materazzi (P: 17.Italy) | T121 , SP: 8.NN (P: 17.Italy) (PNL) ----lineup player_home : | SP: 14.Del Piero | SP: 13.Grosso | SP: 12.Zambrotta | SP: 11.Toni | SP: 10.Inzaghi | SP: 9.Materazzi | SP: 6.Camoranesi | SP: 7.Gilardino | SP: 3.Pirlo | SP: 2.Vieri | SP: 1.Totti | SP: 5.De Rossi | SP: 4.Iaquinta | SP: 8.NN ----lineup player_away : | SP: 5.Sagnol | SP: 7.Ribery | SP: 6.Vieira | SP: 4.Abidal | SP: 3.Trezeguet | SP: 2.Zidane | SP: 1.Henry -------------------------------------------------------
32
11.Results Matches in Round 1 – ordered by Group
Group Round Group
1
Qualifications, 9/6-23/6
1 A
Match Date
Time
Location
Player Home
Player Away
Score H-A
1
9-6-2006
18:00
Munchen
1
Germany
2
Costa Rica
4
2
2
9-6-2006
21:00
Gelsenkirchen
3
Poland
4
Ecuador
0
2
17
14-6-2006
21:00
Dortmund
1
Germany
3
Poland
1
0
18
15-6-2006
15:00
Hamburg
4
Ecuador
2
Costa Rica
3
0
33
20-6-2006
16:00
Berlin
4
Ecuador
1
Germany
0
3
34
20-6-2006
16:00
Hannover
2
Costa Rica
3
Poland
1
2
Group
2 B
Match Date
Time
Location
Player Home
Player Away
Score H-A
3
10-6-2006
15:00
Frankfurt
5
England
6
Paraguay
1
0
4
10-6-2006
18:00
Dortmund
7
Trinidad & Tobago
8
Sweden
0
0
19
15-6-2006
18:00
Nurnberg
5
England
7
Trinidad & Tobago
2
0
20
15-6-2006
21:00
Berlin
8
Sweden
6
Paraguay
1
0
35
20-6-2006
21:00
Kaiserslautern
6
Paraguay
7
Trinidad & Tobago
2
0
36
20-6-2006
21:00
Koln
8
Sweden
5
England
2
2
Match!©
zaterdag 24 juni 2006
Pagina 1 van 4
33
Group
3 C
Match Date
Time
Location
5
10-6-2006
21:00
Hamburg
6
11-6-2006
15:00
Leipzig
21
16-6-2006
15:00
Gelsenkirchen
22
16-6-2006
18:00
Stuttgart
39
21-6-2006
21:00
40
21-6-2006
21:00
Group
Player Home 9
Player Away
Score H-A
Argentina
10
Côte d’Ivoir
2
1
Serbia & Montenegro
12
Netherlands
0
1
Argentina
11
Serbia & Montenegro
6
0
12
Netherlands
10
Côte d’Ivoir
2
1
Frankfurt
12
Netherlands
9
Argentina
0
0
Munchen
10
Côte d’Ivoir
11
Serbia & Montenegro
3
2
11 9
4 D
Match Date
Time
Location
Player Home
Player Away
Score H-A
7
11-6-2006
18:00
Nurnberg
13
Mexico
14
Iran
3
1
8
11-6-2006
21:00
Koln
15
Angola
16
Portugal
0
1
23
16-6-2006
21:00
Hannover
13
Mexico
15
Angola
0
0
24
17-6-2006
15:00
Frankfurt
16
Portugal
14
Iran
2
0
37
21-6-2006
16:00
Gelsenkirchen
16
Portugal
13
Mexico
2
1
38
21-6-2006
16:00
Leipzig
14
Iran
15
Angola
1
1
Group
5 E
Match Date
Time
Location
Player Home
Player Away
Score H-A
10
12-6-2006
18:00
Gelsenkirchen
19
USA
20
Czech Republic
0
3
11
12-6-2006
21:00
Hannover
17
Italy
18
Ghana
2
0
Match!©
zaterdag 24 juni 2006
Pagina 2 van 4
34
Match Date
Time
Location
Player Home
Player Away
Score H-A
25
17-6-2006
18:00
Koln
20
Czech Republic
18
Ghana
0
2
26
17-6-2006
21:00
Kaiserslautern
17
Italy
19
USA
1
1
41
22-6-2006
16:00
Hamburg
20
Czech Republic
17
Italy
0
2
42
22-6-2006
16:00
Nurnberg
18
Ghana
19
USA
2
1
Group
6 F
Match Date
Time
Location
Player Home
Player Away
Score H-A
9
12-6-2006
15:00
Kaiserslautern
23
Australia
24
Japan
3
1
14
13-6-2006
21:00
Berlin
21
Brazil
22
Croatia
1
0
27
18-6-2006
15:00
Nurnberg
24
Japan
22
Croatia
0
0
28
18-6-2006
18:00
Munchen
21
Brazil
23
Australia
2
0
43
22-6-2006
21:00
Dortmund
24
Japan
21
Brazil
1
4
44
22-6-2006
21:00
Stuttgart
22
Croatia
23
Australia
2
2
Group
7 G
Match Date
Time
Location
Player Home
Player Away
Score H-A
12
13-6-2006
15:00
Frankfurt
27
South Korea
28
Togo
2
1
13
13-6-2006
18:00
Stuttgart
25
France
26
Switzerland
0
0
29
18-6-2006
21:00
Leipzig
25
France
27
South Korea
1
1
30
19-6-2006
15:00
Dortmund
28
Togo
26
Switzerland
0
2
47
23-6-2006
21:00
Hannover
26
Switzerland
27
South Korea
2
0
48
23-6-2006
21:00
Koln
28
Togo
25
France
0
2
Match!©
zaterdag 24 juni 2006
Pagina 3 van 4
35
Group
8 H
Match Date
Time
Location
Player Home
Player Away
Score H-A
15
14-6-2006
15:00
Leipzig
29
Spain
30
Ukraine
4
0
16
14-6-2006
18:00
Munchen
31
Tunisia
32
Saudi Arabia
2
2
31
19-6-2006
18:00
Hamburg
32
Saudi Arabia
30
Ukraine
0
4
32
19-6-2006
21:00
Stuttgart
29
Spain
31
Tunisia
3
1
45
23-6-2006
16:00
Berlin
30
Ukraine
31
Tunisia
1
0
46
23-6-2006
16:00
Kaiserslautern
32
Saudi Arabia
29
Spain
0
1
Match!©
zaterdag 24 juni 2006
Pagina 4 van 4
36
12.Results Matches in Round 1- Matrix
37
13.Topscorers RankingSubplayer 1
2 Klose
2
1 Henry
3
Player
5
7
0,71
25 France
3
7
0,43
2 Ronaldo
21 Brazil
3
5
0,60
4
3 Villa
29 Spain
3
4
0,75
5
6 Podolski
3
5
0,60
6
2 Zidane
3
7
0,43
3
4
0,75
7
1 Germany
Goal# Match#Average
1 Germany 25 France
14 Rodriguez
9 Argentina
8
4 Torres
29 Spain
3
4
0,75
9
9 Materazzi
17 Italy
2
5
0,40
10
3 Bravo
13 Mexico
2
4
0,50
11
7 NN
2
3
0,67
12
6 Vieira
25 France
2
5
0,40
13
3 Rosicky
20 Czech Republic
2
3
0,67
14
3 Cahill
23 Australia
2
4
0,50
15
3 Delgado
4 Ecuador
2
4
0,50
16
6 Gerard
5 England
2
5
0,40
1 Germany
Match!© dinsdag 11 juli 2006
Pagina 1 van 6
38
14.Competition Stats period
match_no 2006
64
goal_sum 151
goal_average 2,359375
NB: 4 goals were made in a penalty-shoot-out in a final-round.
15.All stars team NL pos_nr
playr_id 1 2 3 4 5 6 7 8 9 10 11
12 12 12 12 12 12 12 12 12 12 12
playr_nm Netherlands Netherlands Netherlands Netherlands Netherlands Netherlands Netherlands Netherlands Netherlands Netherlands Netherlands
subplayr_id 1 2 18 4 5 6 15 8 13 10 9
subplayr_nm Sar van der Bronkhorst van Cler de Ooijer Boulahrouz Cocu Bommel van Vaart van der Persie van Robben Kuyt
39
16.All stars team spec. NL pos_nr
playr_id 1 2 2 3 3 4 5 5 6 7 8 8 9 9 10 10 11 11
12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12
playr_nm Netherlands Netherlands Netherlands Netherlands Netherlands Netherlands Netherlands Netherlands Netherlands Netherlands Netherlands Netherlands Netherlands Netherlands Netherlands Netherlands Netherlands Netherlands
subplayr_id 1 2 17 18 3 4 5 14 6 15 8 16 13 9 16 10 9 11
subplayr_nm Sar van der Bronkhorst van Jaliens Cler de Mathijsen Ooijer Boulahrouz Heitinga Cocu Bommel van Vaart van der Sneijder Persie van Kuyt Sneijder Robben Kuyt Nistelrooy van
avg_perf_nr 7,375 6,333333333333 33 5,5 7 6 6,75 6,666666666666 67 6 5,75 6,333333333333 33 6,5 5,666666666666 67 6,75 5,5 7 6,5 6,5 5,5
match_no 4 3 1 1 3 4 3 2 4 3 1 3 4 1 1 3 1 3
played_time 360 270 90 90 227 360 224 136 353 215 90 229 336 90 85 270 90 196
40
17.Performance suplayers NL subplayr_nm Sar van der Bronkhorst van Mathijsen Ooijer Boulahrouz Cocu Landzaat Vaart van der Kuyt Robben Nistelrooy van Maduro Persie van Heitinga Bommel van Sneijder Jaliens Cler de Babel Vennegoor of Hesselink
avg_perf_nr 7,375 6,333333333333 33 6 6,75 6,666666666666 67 5,75
min_perf_nr
max_perf_nr
7 6 5,5 5 5 5
8 6,5 6,5 8 8 6,5
6,5 6 6,5 5,5
6,5 5,5 5 5
6,5 6,5 8 6
6,75 6 6,333333333333 33 6 5,5 7
6 5,5 6 5 5,5 7
7,5 6,5 7 7 5,5 7
match_no 4 3 3 4 4 4 3 3 3 3 3 1 4 3 3 4 1 1 1 1
played_time 360 270 227 360 229 353 72 169 202 270 196 5 336 160 215 314 90 90 35 7
min_date 11-6-2006 11-6-2006 11-6-2006 11-6-2006 11-6-2006 11-6-2006 11-6-2006 16-6-2006 11-6-2006 11-6-2006 11-6-2006 21-6-2006 11-6-2006 11-6-2006 11-6-2006 11-6-2006 21-6-2006 21-6-2006 21-6-2006 25-6-2006
max_date 25-6-2006 25-6-2006 25-6-2006 25-6-2006 25-6-2006 25-6-2006 21-6-2006 25-6-2006 25-6-2006 25-6-2006 21-6-2006 21-6-2006 25-6-2006 25-6-2006 25-6-2006 25-6-2006 21-6-2006 21-6-2006 21-6-2006 25-6-2006
41
42
18.Topscorers NL playr_id
Playr_nm 12 Netherlands 12 Netherlands 12 Netherlands
subplayr_id subplayr_nm 13 Persie van 11 Nistelrooy van 10 Robben
perd_id 2006 2006 2006
goal_no 1 1 1
19.Goals Time specification NL playr_id
goal_no_25_po goal_no_25_ne goal_no_50_po goal_no_50_ne goal_no_75_po goal_no_75_ne goal_no_100_p goal_no_100_ne s g s g s g os g 12 2 0 3 1 3 1 3 1
20.Yellow cards NL playr_id 12 12 12 12 12 12 12 12 12 12 12
playr_nm Netherlands Netherlands Netherlands Netherlands Netherlands Netherlands Netherlands Netherlands Netherlands Netherlands Netherlands
subplayr_id 15 5 2 18 16 14 10 9 8 4 3
subplayr_nm Bommel van Boulahrouz Bronkhorst van Cler de Sneijder Heitinga Robben Kuyt Vaart van der Ooijer Mathijsen
perd_id 2006 2006 2006 2006 2006 2006 2006 2006 2006 2006 2006
yel_card_no 2 2 2 1 1 1 1 1 1 1 1
43
21.Red cards NL
playr_id
playr_nm 12 Netherlands 12 Netherlands
subplayr_id
subplayr_nm 5 Boulahrouz 2 Bronkhorst van
perd_id 2006 2006
red_card_no 1 1
22.Literature [L1]
http://fifaworldcup.yahoo.com/06/en/index.html
[L2]
http://www.sport.be/nl/
[L3]
http://wm2006.deutschland.de/EN/Navigation/Home/home.html
[L4]
http://msn.foxsports.com/soccer/worldcup
[L5]
http://edition.cnn.com/SPECIALS/2006/worldcup/
44
Related Documents
Fifa World Cup 2006 Soccer All Results
December 2019 13
Fifa World Cup Germany 2006
November 2019 19
2010 Fifa World Cup
April 2020 14
World Cup 2006 Final Results
November 2019 11
Fussball Fifa World Cup 2006 2
November 2019 14