SPANISH CUP SEARCHABLE DATABASE (1902-2018)
(Next update: 26-10-2017)

I'm presenting here a very powerful and complete searchable database containing all the 13,196 games played in the Spanish Cup (present Copa del Rey or King's Cup) from its inception in 1902 to edition 2017-18 (in progress). 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.

EDITION
From

 

To
YEAR
From

 

To
ROUND

MATCH
OPTION 1 (recommended): DATA INPUT
Free Text. Broad search
(includes change of names)
.
vs.
Fixed order of games
OPTION 2: SELECT MENU
Full index of teams with present common name. Narrow search (restricted to fixed order of games)
.
Home Team

vs.

Away Team
Home Division

vs.

Away Division
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) 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 rounds.

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. (penalty shots).

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).

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