EUROPEAN CHAMPIONSHIP SEARCHABLE DATABASE (1960-2016)
(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.

EDITION
Only Final Stage
YEAR
From

 

To
GAME DETAILS
Venue

 

Round
MATCH
OPTION 1 (recommended): DATA INPUT
Free Text. Broad search
(non-context sensitive)
.
vs.
Fixed order of games
OPTION 2: SELECT MENU
English names. Narrow search (
context sensitive)
.

vs.

SCORE

INSTRUCTIONS AND TIPS

Following is a brief introduction and explanation of the different searchable fields:

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.

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