EUROCUPS SEARCHABLE DATABASE (1955-2017)
(Next update: 14-04-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.
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
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).