SEARCHABLE DATABASE (1935-2017)
(Next update: 2017 edition)
I present here a very powerful and complete searchable database containing
all the 4,734 games played in the European Basketball
Championship (also including qualifying rounds), from its inception in 1935
to İstanbul 2017 edition (coming soon). You will be able to make
queries about editions, host countries, venues, rounds, national squads, and
point difference, 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) GAME DETAILS. You can further refine your search by selecting
VENUE (the place where a Final Stage 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). In the field ROUND, a preceding
FS- refers to the Final
Stage rounds of the competition, played in the host countries and
cities. In a similar way, A- and B-
stand for Division A and Division B qualifiying rounds, from
edition 2005 on (because of the increasing number of rounds in Eurobasket
throughout the years, you should refer to the individual editions for specific
details of the competition system).
3) 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.
4) POINT DIFFERENCE. This field lists the global difference
of points in all the games of the European Championship.
The generated games include the score at halftime (in parentheses) and a
link to the particular edition. Only from edition 2005 on, the link of Final
Stage games includes full game details: venues,
pavilions, dates, tip-off times, attendance, referees, scorers, inicial line-up,
and relevant incidents. Because this Final Stage link targets to the specific
positions of the document, please be patient until the data is fully loaded.
Also, note the following abbreviations attached to some scores, containing
additional information on the games: ot (overtime), wo
(walkover or forfeit).
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 edition's year).