SPANISH LEAGUE SEARCHABLE DATABASE (1957-2017)
(Next update: 3-04-2017)
I'm presenting here a very powerful and complete searchable database containing
all the 15,279 games played in the Spanish Basketball
League (present ACB or Asociación de Clubes de Baloncesto) from
its inception in 1957 to season 2016-17 (in progress).
You will be able to make queries about seasons, years, competition days, teams,
and point difference, 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) SEASON. Select the first and the last season for the
period containing your search. If you only select "season from"
or "season to," the search will include, respectively, all the competitions
beginning or ending in that year.
2) YEAR. The use of this field is similar to that of SEASON
above, and it further specifies the year in which a game was played (remember
that a season will normally span over two years).
3) COMPETITION DAY. If you want to refine your search even
more, select the competition day you wish to retrieve. If you are looking
for a specific day, you should select the same number in "From"
and "To." Please, note that there are two different kinds of competition
days you can select: normal league days (before the creation of ACB League)
and Liga Regular (LR) days (introduced under the new ACB formar of
Regular Season and Playoffs). Additionally, it is also possible to select
the promotion games (PROMOCIÓN) played after the regular league
before the creation of ACB, in order to decide the divisional changes between
Spanish Primera División (First Division) and Segunda División
(Second Division). Another option in this menu is the ACB League's PLAYOFFS,
games played after the Regular Season to decide the champion. Please note
the following abbreviations in this respect: POT (Playoffs por el Título
or Championship Playoffs), POC (Playoffs de Clasificación or
Classification Playoffs), POP (Playoffs por la Permanencia or Relegation
Playoffs). If you don't want to be too specific about competition days, you
can also refer to the field STAGE to select the broad terms LR (Liga Regular),
PO (Playoffs) or PR (Promoción).
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 official name of the teams can be selected in this drop
down menu; 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"), but it shows the name changes of the selected teams.
5) POINT DIFFERENCE. This field lists all the basket average
points in the Spanish League. Because the program can't attach individual
scores to specific teams, it can't decide who's the winner and who's the loser
in a match-up, just the final difference. After the list of games is generated,
please note the following additional abbreviations attached to some scores,
which don't alter them in any way: v.t. (victoria técnica
or forfeit), A.L. (Alirón Local, shows the game of Regular
Season in which the local team becomes champion), A.V. (Alirón
Visitante, shows the game of Regular Season in which the away team becomes
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
season; 2) by year; 3) by
competition day; 4) by playoff sequence.