A request was made by someone on Twitter which teams had won their first games and how many points they got in the group. It was pretty tricky to write the queries to get this from the database but always up for a challenge and a push.
In the table below you can see every team that won their opening match and their final group stage points and the phase that they got knocked out in.
Year | Team | First match | Group points | Last match |
---|---|---|---|---|
2010 | Argentina | bt Nigeria 1-0 | 9 | Quarter-finals |
2010 | Korea Republic | bt Greece 2-0 | 4 | Round of 16 |
2010 | Slovenia | bt Algeria 1-0 | 4 | Group matches |
2010 | Germany | bt Australia 4-0 | 6 | Third place |
2010 | Ghana | bt Serbia and Montenegro 1-0 | 4 | Quarter-finals |
2010 | Netherlands | bt Denmark 2-0 | 9 | Final |
2010 | Japan | bt Cameroon 1-0 | 6 | Round of 16 |
2010 | Brazil | bt Korea DPR 2-1 | 7 | Quarter-finals |
2010 | Chile | bt Honduras 1-0 | 6 | Round of 16 |
2010 | Switzerland | bt Spain 1-0 | 4 | Group matches |
2006 | Germany | bt Costa Rica 4-2 | 9 | Third place |
2006 | Ecuador | bt Poland 2-0 | 6 | Round of 16 |
2006 | England | bt Paraguay 1-0 | 7 | Quarter-finals |
2006 | Argentina | bt Ivory Coast 2-1 | 7 | Quarter-finals |
2006 | Netherlands | bt Serbia and Montenegro 1-0 | 7 | Round of 16 |
2006 | Mexico | bt Iran 3-1 | 4 | Round of 16 |
2006 | Portugal | bt Angola 1-0 | 9 | Third place |
2006 | Italy | bt Ghana 2-0 | 7 | Final |
2006 | Czech Republic | bt USA 3-0 | 3 | Group matches |
2006 | Brazil | bt Croatia 1-0 | 9 | Quarter-finals |
2006 | Australia | bt Japan 3-1 | 4 | Round of 16 |
2006 | Korea Republic | bt Togo 2-1 | 4 | Group matches |
2006 | Spain | bt Ukraine 4-0 | 9 | Round of 16 |
2002 | Senegal | bt France 1-0 | 5 | Quarter-finals |
2002 | Denmark | bt Uruguay 2-1 | 7 | Round of 16 |
2002 | Spain | bt Slovenia 3-1 | 9 | Quarter-finals |
2002 | Brazil | bt Turkey 2-1 | 9 | Final |
2002 | Costa Rica | bt China PR 2-0 | 4 | Group matches |
2002 | Korea Republic | bt Poland 2-0 | 7 | Third place |
2002 | USA | bt Portugal 3-2 | 4 | Quarter-finals |
2002 | Germany | bt Saudi Arabia 8-0 | 7 | Final |
2002 | Argentina | bt Nigeria 1-0 | 4 | Group matches |
2002 | Mexico | bt Croatia 1-0 | 7 | Round of 16 |
2002 | Italy | bt Ecuador 2-0 | 4 | Round of 16 |
2002 | Russia | bt Tunisia 2-0 | 3 | Group matches |
1998 | Brazil | bt Scotland 2-1 | 6 | Final |
1998 | Denmark | bt Saudi Arabia 1-0 | 4 | Quarter-finals |
1998 | France | bt South Africa 3-0 | 9 | Final |
1998 | Nigeria | bt Spain 3-2 | 6 | Round of 16 |
1998 | Mexico | bt Korea Republic 3-1 | 5 | Round of 16 |
1998 | Yugoslavia | bt Iran 1-0 | 7 | Round of 16 |
1998 | Germany | bt USA 2-0 | 7 | Quarter-finals |
1998 | Romania | bt Colombia 1-0 | 7 | Round of 16 |
1998 | England | bt Tunisia 2-0 | 6 | Round of 16 |
1998 | Croatia | bt Jamaica 3-1 | 6 | Third place |
1998 | Argentina | bt Japan 1-0 | 9 | Quarter-finals |