SPANISH CUP SEARCHABLE DATABASE (1902-2017)
(Next update: 9-02-2017)
I present here a very powerful and complete searchable database containing
all the 13,083 games played in the Spanish Cup
(present Copa del Rey or King's Cup) from its inception in 1902 to
edition 2016-17 (coming soon). You will be able
to make queries about editions, years, rounds, teams, categories, and scores,
either specifically or by combining different fields. As everywhere in this
website, clubs are presented in their original official name. 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) EDITION. Select the first and the last editions for the
period containing your search. Normally, a Cup edition spans over two consecutive
years, although in the early history of the tournament it was just one year.
If you only select "edition from" or "edition to," the
search will include, respectively, all the tournaments beginning or ending
in that year.
2) YEAR. The use of this field is similar to that of EDITION
above, and it further specifies the year in which a game was played (remember
that an edition will normally span over two years).
3) ROUND. If you want to refine your search even more, select
the round you wish to retrieve. Because not all the editions of the Spanish
Cup had the same competition format, the menu simply lists all the different
4) MATCH. There are two search options to retrieve games
between teams: a) Data input: The search
box will accept almost any combination of plain text, truncated forms, or
localized spellings, as long as it uniquelly identifies a specific team; by
default, the query under this option is reversible,
so the match "Team A" vs. "Team B" will generate games
"Team A-Team B" (Team A plays home) and "Team B-Team A"
(Team A plays away). If you want to restrict the search to "home"
or "away" games only, please mark the checkbox "Fixed order
of games." Another advantage of this search method is that it generates
the full historical record of a team (including its name changes). b) Select
menu: The common (unofficial) name of the teams can be selected
in this drop down menu, which lists all the participants in the history of
the Spanish Cup under their present (or last) name; although it's simple,
this option can only generate the fixed order of games specified in the search
criteria (that is, "Team A" vs. "Team B," but not the
corresponding "Team B" vs. "Team A") and doesn't show
the name changes of the selected teams (only the present common name). If
you use this option, in order to retrieve the full history of a team you have
to select it both in "Home Team" and "Away Team."
[NOTE: Due to database requirements, the apostrophe (') in "Cala
d'Or," "O'Donnell," and "Vall d'Uxó" is missing,
so you should search these teams as "Cala dOr," "ODonnell,"
and "Vall dUxo" (or truncated).] Additionally, it is possible
to search match-ups between different divisions: PRIMERA (Level 1),
SEGUNDA (Level 2), SEGUNDA_B (Level 3), TERCERA (Level
4), REGIONAL (Level 5), AFICIONADOS (Level 6), and C._REGIONAL
(Regional Championship, the early local tournaments played in Spain until
1940, before the creation of the National League and lower divisions). You
can also make cross-searches between the fields TEAM (Option 1 or Option 2)
and DIVISION, always keeping in mind the restraints of the Select Menu.
5) SCORE. This field lists all the scores in Spanish Cup
games. Please, note the following additional abbreviations attached to some
scores in the generated match list: des. (desempate or replay),
v.t. (victoria técnica or forfeit, games not actually
played but awarded a symbolic 3-0 score in modern Cup editions), pro.
(prórroga or extra time, attached only to finals), p.
By combining these basic fields, you can make countless queries according
to your specific interest. After you complete your query, the resulting match
list is displayed in the following ascendent order: 1) by
edition; 2) by year; 3) by
round; 4) by match-up sequence
(first leg-second leg).