EUROCUPS SEARCHABLE DATABASE (1955-2017)
(Next update: 5-05-2017)

I'm presenting here a very powerful and complete searchable database containing all the 22,777 games played in European Club Competitions from their inception in 1955 to season 2016-17 (in progress). You will be able to make queries about the four seasonal UEFA tournaments (Champions League, Europa League and the late Cup Winners' Cup and Intertoto Cup), seasons, years, rounds, teams, countries, and scores, either specifically or by combining different fields.

As everywhere in this website, clubs are presented in their original official name and spelling (or a transcription into Latin alphabet). But don't worry: as input for the search box, you can also use plain text (with no accents or especial diacritics), truncated forms (first, middle, or last letters of the team's name), or localized spellings (the common name of the team in English or Spanish), and the database will generate the desired results in most cases. However, due to the large amount of teams and some similarities between their names, the more accurate your search input is, the better.

SEASON
From

 

To
YEAR
From

 

To
COMPETITION
Name

 

Round
COUNTRY
vs.
Fixed order of games
vs.
vs.
Fixed order of games
SCORE

INSTRUCTIONS AND TIPS

The use of this database is very easy and intuitive: simply specify or combine the desired data, and the program will generate the list of games that matches those criteria. Remember that you don't have to fill all the fields and also that your query should be logical. Following is a brief introduction and explanation of the different searchable fields:

1) SEASON. Select the first and the last season for the period containing your search. If you only select "season from" or "season to," the search will include, respectively, all the competitions beginning or ending in that year. Note: Although the first two seasons of Fairs Cup spanned over a period of three and two years, respectively (Fairs Cup 1955-1958 and Fairs Cup 1958-1960), for the sake of clarity they are indexed in this database only by their ending season: 1957-1958 and 1959-1960.

2) YEAR. The use of this field is similar to that of SEASON above, and it further specifies the year in which a game was played (remember that a season will normally span over two years).

3) COMPETITION. Select the desired competition name and/or round. Note that there are four basic UEFA tournaments, specified here as C1, C2, C3, and C4. C1 is the traditional Champions Cup, renamed Champions League after 1992. Although their name and competition format is different, these two tournaments should be considered from the historical point of view as a single one. The same applies to the original Fairs Cup, called UEFA Cup after 1971 and Europa League after 2009, and therefore the three of them are gathered as C3. Cup Winners' Cup (C2) merged with UEFA Cup in 1999 and disappeared. Finally, Intertoto Cup (C4), although created in the early 60s, was first organized by UEFA as an official competition in 1995. Note: In the ROUND field, "Champions League" refers to the Group Stage round of C1 introduced in 1991, with all qualified teams playing a round-robin.

4) COUNTRY. Select from the list menu the country you'd like to include in your query. Please note that, by default, the query is reversible, so the match "Country A" vs. "Country B" will generate games "Country A-Country B" (Country A plays home) and "Country B-Country A" (Country A plays away). If you want to restrict the search to "home" or "away" games only, please mark the checkbox "Fixed order of games." This index displays all the states whose teams participated in European competitions throughout history. A cross (Ἷsignals countries that disappeared or were renamed. To avoid confusion, please note the main four trends involving the football federations of these territories:

a) Splitting USSR (Soviet Union) divided into CIS (Commonwealth of Independent States) (1991), Russia (1992), Ukraine (1992), Lithuania (1992), Belarus (1993), Georgia (1993), Armenia (1994), and Azerbaijan (1994).
The Former Yugoslavia divided into Slovenia (1992), Croatia (1993), Macedonia (1994), the New Yugoslavia (1995), and Bosnia-Herzegovina (1998).
Czechoslovakia divided in 1993 into Czech Repubic and Slovakia.
b) Merging FRG (West Germany) and GDR (East Germany) merged in 1991 into Germany.
c) Annexation The independent state of Saarland incorporated into FRG in 1957.
d) Change of name The New Yugoslavia was renamed Serbia-Montenegro in 2003.

Because the tag "country" is dependant on the team, you should not expect a modern country to include the former territories when only this field is selected. However, if your search is by team, the name of the country will change according to every season. For example. the search "Russia" will start in 1992, but the search of the present Russian team Spartak Moscow will begin in year 1966 and include all their participations as a club of the late Soviet Union, as well as later Russia.

5) TEAM. As in the field COUNTRY above, the query is also reversible by default, so "Team A" vs. "Team B" covers all the matches between these two teams, with both home and away games (once again, unless the checkbox "Fixed order of games" is marked). Because the list of participant teams in Eurocups is so large (more than one thousand), instead of a menu list there is a text box to input data. As explained above, almost anything goes here: original spelling, localized variants, plain text, or truncated forms. Try to make you query as specific and significant as possible to avoid confusion and ambiguity. For example, if you type "Milan" you won't only get "AC Milan" as the result, but also "Internazionale FC" (because the program also accepts "Inter Milan" instead of the latter). You can avoid this problem by typing a more specific form "AC Milan." In other cases, different teams share the same basic name (like "Dynamo," "CSKA," "AEK," "Lokomotiv," etc.), and to distinguish them the name of the city is attached in parentheses. Note: In case of doubt, visit the link in the head title TEAM and you will access the alphabetical list of all the participants in Eurocups, so that you can copy and paste the official name of the club.

6) SCORE. This field lists all the scores in Eurocups games. Please, note the following additional abbreviations attached to some scores, which don't alter them in any way: rep (replay), wo (walk-over or forfeit), ict (Intertoto Cup Trophy). You can also click the score link to access the specific game details for every match (please, note that every score is linked to its game details, so be patient until the file containing all the the game details is fully uploaded to target to the specific position of the game). Advice: The game details will show up in a new window, so it's better if you adjust it to make it smaller (about a quarter of the full window, the best size to visualize game details) and move it to the upper left corner in order to make new queries. After you close it, next time you make a query, the small window will show up in the same position. Note: For some unknown reason, some links don't seem to work properly, so you have to scroll down the document until you find the desired game. Please, let me know when you find such particular cases.

By combining these basic fields, you can make countless queries according to your specific interest. Particularly interesting is the cross search between countries and teams. After you complete your query, the resulting match list is displayed in the following ascendent order: 1) by season; 2) by round; 3) by chronological order of games (first leg and then second leg).

© www.linguasport.com
Website designed and maintained by Santiago Velasco