EUROPEAN CHAMPIONSHIP SEARCHABLE DATABASE
(Next update: 2020 edition)
I present here a very powerful and complete searchable database containing
all the 2,626 games played in the European Championship
for National Squads (not only final stages, but also preliminary rounds),
from its inception in 1960 to France 2016 edition.
You will be able to make queries about editions, years, cities, rounds, national
squads, and scores, either specifically or by combining different fields.
National squads are listed with their international English name, together
with their original local name (if necessary) in parentheses. 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. 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.
INSTRUCTIONS AND TIPS
Following is a brief introduction and explanation of the different searchable
1) EDITION. Select the desired European Championship edition.
By default, the database will retrieve ALL the games played in the tournament,
from the Qualifying Round to the Final Stage. If you only want to retrieve
the matches of this final round in the host country (European Championship
proper), you should select YES in "Only Final Stage." It's also
possible to use the option "Only Final Stage" as a filter combined
with each of the fields VENUE and ROUND below.
2) YEAR. Select the first and the last year for the period
containing your search. If you only select "year from" or "year
to," the search will include, respectively, all the European Championship
games beginning or ending in that year. You should also keep in mind that
these natural years don't match the editions above, since normally the Qualifying
Round is played 1-2 years before the Final Stage.
3) GAME DETAILS. You can further refine your search by selecting
VENUE (the place where a game is played, written in its original spelling
or a transcription into Latin alphabet) and ROUND (Qualifying Stage and the
different rounds of the Final Stage). You will notice in the field ROUND an
index of different phases, corresponding to the changes in the competition
format of the European Championship, but only the ones with the abbreviation
FS- in front are Final Stage rounds. [NOTE: Due
to database requirements, some complex city names are linked by a lower hyphen
(_) to avoid mismatches (like Reggio_Calabria and Reggio_Emilia), and the
apostrophe (') is missing in the following city names: Donets'k, L'vïv,
Tiraspol', Simferopol', Ta'Qali.]
4) MATCH. There are two search options to retrieve games
between national teams: a) Data input:
The search box will accept almost any combination of plain text, truncated
forms, or localized names (English, Spanish, and even the original
spelling in the native language/-s and alphabet/-s,
which in time can be truncated), as long as it uniquelly identifies
a specific team; by default, the query under this option is reversible,
so the match "Country A" vs. "Country B" will generate
games "Country A-Country B" (Country A plays home in home-and-away
preliminary rounds or comes first in the official competition calendar of
the Final Stage) and "Country B-Country A" (Country A plays away).
If you want to restrict the search to "home" or "away"
games (only meaningful for preliminary rounds, as explained before), mark
the checkbox "Fixed order of games." It should be obvious now that
you should never mark this checkbox if you select a Final Stage edition or
round, with single-game matches, since this won't retrieve all the games of
a specific national squad. Another advantage of this search method is that
it generates the full historical record of a national team, including name
changes (like USSR > Russia). b) Select menu:
The English name of the country can be selected in this drop down index; please,
note that this option, although very quick and easy to use, can only generate
the fixed order of games specified in the search criteria (that is, "Country
A" vs. "Country B," but not the corresponding "Country
B" vs. "Country A") and doesn't show the name changes of the
selected teams. Because this option is context sensitive to the calendar order
of games, in order to make sure you retrieve all the matches of a specific
team you have to select it in both the first and second menus.
5) SCORE. This field lists the basic scores in all the games
of the European Championship. The retrieved games also show the score at halftime
(in parentheses). Please, note the following abbreviations attached to some
scores, containing additional information on the games: a.e.t. (after
extra time), rep. (replay), t.b. (tie break),
w.o. (walkover or forfeit), p.k. (penalty kicks).
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 round;
3) by specific date (the games
follow a strict chronological order, although the database doesn't show the
exact dates, only the year).
Finally, you will notice a link in every single score of the generated list
of games, which will take you to the game details.
All the matches of the Qualifying Stage contain partial
game details: venues, stadiums, dates, referees, and scorers. All the
Final Stage matches, together with all the Qualifying Stage games of Spain,
contain full game details: line-ups, venues,
stadiums, dates, kick-off times, referees, scorers, and relevant incidents.
Because the links have targets to the specific positions of the game details
document, please be patient until the data is fully loaded.