TheFMDB
VersionFM20 Update
Light

Spanish Second Division

FM20 Update

  • Spain
  • Europe
  • Level 1
  • Active
  • —
  • —
Competition
122 / 200Reputation
—League games
22Clubs
£552,515,108Total squad value

Competition

Code
SD2
Nation
Spain
Confederation
Europe
Type
Standard division
Level
1
Reputation
122 / 200
Status
Active
Season
— – —
Colours
—
Short name
Second Division
Parent competition
—
Crowd tendencies
0

Format

Partial export
Teams
22
League games
—
Promoted in
—
Relegated
—
Champions League
—
Europa League
—
Conference League
—
Play-offs
—
Maximum games
42
Joined since 2018–19
Fuenlabrada from Spanish Second Division B1, Girona from Spanish First Division, Huesca from Spanish First Division, Mirandés from Spanish Second Division B2, Ponferrada from Spanish Second Division B1, R. Santander from Spanish Second Division B2, Vallecano from Spanish First Division
Left since 2018–19
Atlético Pamplona now in Spanish First Division, Córdoba now in Spanish Second Division B4, Granada now in Spanish First Division, Mallorca now in Spanish First Division, R. Majadahonda now in Spanish Second Division B1, Reus, Tarragona now in Spanish Second Division B3

Squad rules

Partial export
Registered squad
—
Home-grown
—
Club-trained
—
Foreign players
—
Under-21
—
Loans
—

Most titles

88 recorded titlesFMDB calculation
6Real Hispalis2015, 2011, 1974, 1971, 1942, 1932
6Murcia2003, 1986, 1983, 1980, 1973, 1940
5Coruña2012, 1968, 1966, 1964, 1962
5S. Gijón1977, 1970, 1957, 1951, 1944
5Oviedo1975, 1972, 1958, 1952, 1933
4Atlético Pamplona2019, 1961, 1956, 1953
4Alavés2016, 1998, 1954, 1930
4Sevilla2001, 1969, 1934, 1929
3Real San Sebastián2010, 1967, 1949
3Valladolid2007, 1959, 1948
3Vigo1992, 1982, 1936
2Levante2017, 2004
2Las Palmas2000, 1985
2Málaga1999, 1988
2C.P. Mérida1997, 1995
2H. Alicante1996, 1935
2Burgos1990, 1976
2Castellón1989, 1981
2Valencia1987, 1931
2Pontevedra1965, 1963
2R. Santander1960, 1950
2Alcoyano1947, 1945
2Sabadell1946, 1943
1Vallecano2018
1Eibar2014
1Elche2013
1Xerez2009
1Numantia2008
1Huelva2006
1Cádiz2005
1A. Madrid2002
1Espanyol1994
1U.E. Lleida1993
1Albacete1991
1Castilla C.F.1984
1A.D. Almería1979
1Zaragoza1978
1Leonesa1955
1Granada1941

Counted over every recorded season of this competition, not the page of the roll of honour below. Placings point at teams rather than clubs, because international tournaments are won by national teams. Confirmed overall winners in every recorded season; abandoned, cancelled and no-data seasons are excluded and stage placings are counted separately.

Season table

In the export
Pos Team P W D L GF GA GD Points
1 Atlético Pamplona 42 26 9 7 59 35 24 87
2 Granada 42 22 13 7 52 28 24 79
3 Málaga 42 21 11 10 51 31 20 74
4 Albacete 42 19 14 9 54 38 16 71
5 Mallorca 42 19 12 11 53 37 16 69
6 Coruña 42 17 17 8 50 32 18 68
7 Cádiz 42 16 16 10 53 36 17 64
8 Oviedo 42 17 12 13 48 48 0 63
9 S. Gijón 42 16 13 13 43 38 5 61
10 Almería 42 15 15 12 51 39 12 60
11 Elche 42 13 16 13 50 53 -3 55
12 Las Palmas 42 12 18 12 48 48 0 54
13 Extremadura 42 14 11 17 43 47 -4 53
14 Alcorcón 42 14 10 18 36 42 -6 52
15 Zaragoza 42 13 12 17 49 52 -3 51
16 Tenerife 42 11 17 14 40 50 -10 50
17 Numantia 42 11 16 15 44 50 -6 49
18 Lugo 42 10 17 15 43 51 -8 47
19 R. Majadahonda 42 12 9 21 46 6 40 45
20 Tarragona 42 9 9 24 30 53 -23 36
21 Córdoba 42 7 13 55 49 79 -30 34
22 Reus 42 5 6 31 16 48 -32 0

Points are shown as the database stores them, including deductions, so they will not always match a total derived from wins and draws — and wins, draws and losses need not add up to games played. A blank cell is a figure the source does not record; it is never a zero.

2018–19 — full season table. Showing 22 of 22 recorded rows. Points are shown as stored.

League strength

FMDB calculation
Columns

Columns
Albacete565011411712827.7£16,653,190£306,815—173009000
Alcorcón570010611112227.8£11,058,010£132,744—51002800
Almería605011611813125.2£20,431,970£617,335—152007200
Cádiz630010412113224.7£27,312,989£1,046,657—2503315000
Coruña670012112413628.0£38,772,270£214,427—3266016750
Elche560011311913027.7£26,412,900£127,808—337329500
Extremadura570010211012326.4£10,119,568£484,692—115809500
Fuenlabrada545010611312826.6£9,408,611£357,725—25002000
Girona630012512913727.7£78,551,940£144,111—135009500
Huesca625011712313626.3£39,071,800£117,156—76383600
Las Palmas630011611913427.3£24,153,340£64,725—3200011000
Lugo590010911312626.8£13,219,990£204,864—70703700
Málaga655010912413723.6£48,898,500£361,741—30044—
Mirandés550010510511526.6£5,887,690£343,590—57593600
Numantia600010511112425.7£10,505,360£195,350—87273500
Oviedo625011411813127.3£21,475,410£216,207—3050013500
Ponferrada555010811012226.1£10,919,060£399,557—88003000
R. Santander555010611012428.4£9,391,520£234,551—2212412000
S. Gijón635011712113326.7£27,959,820£243,437—3000018505
Tenerife630011211913325.2£22,959,400£168,904—2170011000
Vallecano640011812613926.2£47,001,440£409,594—147088000
Zaragoza635011712213326.2£32,350,330£282,292—3360822430

Every club naming this competition as its current division, with the squad of the team that shares the club uid. Average ability, CA16, PA16, average age, squad value and wage bill are the FMDB's own figures over each club's whole squad; hover one for the population it was computed from. CA16 and PA16 are the means of the sixteen highest abilities and potentials, a coded potential counted at its band midpoint as on the club page. Ages are taken at 1 July 2019, the start of the 2019–20 season. Balance is the club's authored club_finance_detail.cash; reputation, capacity and attendance are stored club figures.

Best in the league

FMDB calculation
# Player Club Pos CA
1Cristhian Ricardo Stuani CurbeloGironaFC145
2Shinji KagawaZaragoza—140
3Cristian Darío Álvarez AzadZaragozaGK136
4Yassine BounouGirona—136
5Diego Alejandro Rolan SilvaCoruñaFC136
6Pedro Mosquera ParadaHuescaMC135
7Luis Hernández RodríguezMálagaDC135
8Borja García FreireGironaAMC135
9Adrián González MoralesMálagaMC133
10Alejandro Arribas GarridoOviedoDC133

Roll of honour

Placings point at teams, not clubs
Season Winner Runner-up Third Top scorer Ambiguous Player of the season See awards
2019Atlético PamplonaGranadaMálaga——
2018Play-off winner: ValladolidVallecanoHuescaZaragoza——
2017Play-off winner: GetafeLevanteGironaGetafe——
2016Play-off winner: Atlético PamplonaAlavésLeganésTarragona——
2015Play-off winner: Las PalmasReal HispalisS. GijónGirona——
2014Play-off winner: CórdobaEibarCoruñaBarcelona B——
2013Play-off winner: AlmeríaElcheVillarrealAlmería——
2012Play-off winner: ValladolidCoruñaVigoValladolid——
2011Play-off winner: GranadaReal HispalisVallecanoBarcelona B——
2010Real San SebastiánH. AlicanteLevante——
2009XerezZaragozaTenerife——
2008NumantiaS. GijónMálaga——
2007ValladolidAlmeríaMurcia——
2006HuelvaTarragonaLevante——
2005CádizVigoAlavés——
2004LevanteGetafeNumantia——
2003MurciaZaragozaAlbacete——
2002A. MadridR. SantanderHuelva——
2001SevillaReal HispalisTenerife——
2000Las PalmasVillarrealAtlético Pamplona——
1999MálagaA. Madrid BNumantia——
1998AlavésExtremadura C.F.Las Palmas——
1997C.P. MéridaU.D. Salamanca S.A.D.Mallorca——
1996H. AlicanteC.D. Logroñés SADMallorca——
1995C.P. MéridaVallecanoU.E. Lleida——

A season links to its league table only where team_league_history records one. The top scorer is the rank-1 winner of the one award of type “Most goals scored” scoped to this competition, with the goals it records; no single award can be identified as the player of the season, so that column points to the Awards panel.

Across versions

Recorded
Spanish Second Division reputation across versions0100200 CM0102 RFM06 RFM10 RFM13 RFM16 RFM19 RFM22 RFM26 UReputation, CM0102 Release: 12 Reputation, CM0203 Release: 12 Reputation, CM0304 Release: 12 Reputation, CM0304 Update: 12 Reputation, FM05 Release: 120 Reputation, FM05 Update: 120 Reputation, FM06 Release: 115 Reputation, FM07 Release: 115 Reputation, FM07 Update: 115 Reputation, FM08 Release: 115 Reputation, FM09 Release: 115 Reputation, FM09 Update: 115 Reputation, FM10 Release: 115 Reputation, FM10 Update: 115 Reputation, FM11 Release: 115 Reputation, FM11 Update: 115 Reputation, FM12 Release: 115 Reputation, FM12 Update: 115 Reputation, FM13 Release: 115 Reputation, FM13 Update: 115 Reputation, FM14 Release: 115 Reputation, FM14 Update: 115 Reputation, FM15 Release: 115 Reputation, FM15 Update: 115 Reputation, FM16 Release: 115 Reputation, FM16 Update: 115 Reputation, FM17 Release: 115 Reputation, FM17 Update: 115 Reputation, FM18 Release: 115 Reputation, FM18 Update: 120 Reputation, FM19 Release: 123 Reputation, FM19 Update: 123 Reputation, FM20 Release: 122 Reputation, FM20 Update: 122 Reputation, FM21 Release: 122 Reputation, FM21 Update: 120 Reputation, FM22 Release: 118 Reputation, FM23 Release: 117 Reputation, FM24 Release: 116 Reputation, FM26 Release: 127 Reputation, FM26 Update: 127
Recorded reputation in each database where this uid resolves. Missing values remain gaps. Raw export scales may differ between versions.
Version Name as recorded
CM0102 ReleaseSpanish Second Division
CM0203 ReleaseSpanish Second Division
CM0304 ReleaseSpanish Second Division
CM0304 UpdateSpanish Second Division
FM05 ReleaseSpanish Second Division
FM05 UpdateSpanish Second Division
FM06 ReleaseSpanish Second Division
FM07 ReleaseLIGA BBVA
FM07 UpdateLIGA BBVA
FM08 ReleaseLIGA BBVA
FM09 ReleaseLIGA adelante
FM09 UpdateLIGA adelante
FM10 ReleaseLIGA adelante
FM10 UpdateLIGA adelante
FM11 ReleaseLIGA adelante
FM11 UpdateLIGA adelante
FM12 ReleaseLIGA adelante
FM12 UpdateLIGA adelante
FM13 ReleaseLIGA adelante
FM13 UpdateLIGA adelante
FM14 ReleaseLIGA adelante
FM14 UpdateLIGA adelante
FM15 ReleaseLIGA adelante
FM15 UpdateLIGA adelante
FM16 ReleaseLIGA adelante
FM16 UpdateLIGA adelante
FM17 ReleaseSpanish Second Division
FM17 UpdateSpanish Second Division
FM18 ReleaseSpanish Second Division
FM18 UpdateSpanish Second Division
FM19 ReleaseSpanish Second Division
FM19 UpdateSpanish Second Division
FM20 ReleaseSpanish Second Division
FM20 UpdateSpanish Second Division
FM21 ReleaseSpanish Second Division
FM21 UpdateSpanish Second Division
FM22 ReleaseSpanish Second Division
FM23 ReleaseSpanish Second Division
FM24 ReleaseSpanish Second Division
FM26 ReleaseSpanish Second Division
FM26 UpdateSpanish Second Division

Recorded competition names are shown for each version where the identity resolves.

Awards

6 scoped to this competitionRecorded
Award Type Editions Latest Latest winner Value
Spanish Second Division Goalkeeper of the YearLeast goals conceded412019Rui Tiago Dantas da SilvaGranada27
Spanish Second Division Top GoalscorerMost goals scored722019Álvaro Giménez CandelaAlmería20
Spanish Second Division Top Spanish GoalscorerMost goals scored142019Álvaro Giménez CandelaAlmería20
Spanish Second Division Manager of the MonthBest manager0———
Spanish Second Division Player of the MonthHighest average rating0———
Spanish Second Division Team of the WeekHighest average rating0———

Awards whose award_scope names this competition. Editions flagged as having no data or not taking place are not counted. “Latest” is the award's stored season year; where that season has several editions — one per slot of a team of the year — the award page lists them.

Media prediction

Recorded
Predicted Club Last position
—No member club carries a recorded prediction.—

The predicted finish is the authored club_media_expectation.expected_league_finish. Last position is club_team.last_position as stored, in whatever competition the team last played, so for a club that has just joined it is not a place in this division.

Derbies in this division

1 between member clubs
Derby Clubs W–D–L National reputation
AsturianoS. Gijón v Oviedo-1–-1–-1130

Derbies between two clubs that both name this competition as their current division. derby.competition_uid is empty in every loaded export, so this is the only way a derby belongs to a league. W–D–L is the first-named club's record as stored.

All-time records

FMDB calculation

Most goals and appearances in this division, summed from the playing history of every person this database records.

It counts only the people the export carries, it can include seasons the source files under this competition from before it took its current form, and some players are listed by uid because their person record is missing. The page states each of these.

See the all-time records

Member teams

22 clubs name this as their division

Last position is club_team.last_position as stored. The manager is the current staff_history spell at the club — the one whose end date is absent or in the future, most recent join first — never club_team.manager_index, which is a raw internal index that joins to nothing.

Team Membership Last position Manager
AlbacetePrevious season4Luis Miguel Ramis Monfort
AlmeríaPrevious season10Guti
AlmeríaNext season10Guti
Barcelona BPrevious season20Francisco Javier García Pimienta
TenerifePrevious season16Rubén Baraja Vegas
CádizPrevious season7Juan Antonio Rosano Mariño
Atlético PamplonaPrevious season1Jagoba Arrasate Elustondo
LugoPrevious season18Cristóbal Emilio Torres Ruiz
NumantiaPrevious season17Luis Miguel Carrión Delgado
CórdobaPrevious season21Raúl Agné Montull
CórdobaNext season21Raúl Agné Montull
CoruñaPrevious season6Fernando Vázquez Pena
ElchePrevious season11José Rojo Martín
GranadaPrevious season2Rubén Torrecilla Gonzalez
MallorcaPrevious season5Vicente Moreno Peris
OviedoPrevious season8Javier Fernández-Rozada Álvarez
S. GijónPrevious season9Miroslav Djukic
ZaragozaPrevious season15Víctor Fernández Braulio
Las PalmasPrevious season12José Mel Pérez
LeonesaPrevious season19José Manuel Aira Lindoso
MálagaPrevious season3Sergio Pellicer García
AlcorcónPrevious season14Francisco Javier Fernández Díaz
Sevilla BPrevious season22Francisco Gallardo León
TarragonaPrevious season20José Antonio Seligrat Bernal

Data wishlist for this page

13 data pointsWhole site
  • club_media_expectation, club_finance_detail Media prediction and club balances across the division Now liveThe predicted finish of every member club and each club's authored cash balance, where the version exports them.
  • player_history.division_uid All-time goals and appearances in the division Now liveAn FMDB sum over the people this database records, on its own page. Players with no person record are listed by uid; seasons the source files under this competition before it took its current form are included and dated.
  • derby, club.division_uid Derbies between member clubs Now livederby.competition_uid is empty in every export, so a derby belongs to a division when both its clubs name that division.
  • comps_competition, comps_stage and stage promotion, relegation and play-off tables Format, promotion, relegation, play-offs and qualification Needs source dataThe comps.dbc archive tables are empty in every loaded export. The format panel shows the clubs that joined and left since the latest recorded season table as an FMDB comparison, which is not a count of promotion places.
  • competition rules, nation_foreign_rule, nation_agreement Registration size, home-grown quotas, foreign-player limits and age rules Partial exportNation foreign/non-foreign definitions and agreements are exported, but do not supply the complete competition registration rules.
  • competition income and prize schedules Prize money, television distributions and sponsor Needs source dataThe current catalog does not provide these competition-level schedules and contracts.
  • competition.champions_club_uid, parent_division_uid, league_body_club_uid Current champions, parent division and organising body Needs source dataThe parent division is displayed. The champions and organising-body columns are empty in all 41 loaded databases.
  • team_league_history Recorded season tables Now liveSeason links are offered only where rows exist; stored points and missing results are preserved.
  • club.division_uid, stadium and primary-team squads League strength and leading players Now liveStrength and ability rankings use clubs naming this division, with a 100-club cap. League totals are withheld on overflow.
  • person.date_of_birth, export_meta.game_start_year Best young players in the league Now liveUnder-21s at 1 July of the exported game start year, ranked on recorded potential. Versions without a start year say so; coded potential bands are not ranked.
  • award_scope, award_type, award_history_winner Top scorer and player-of-season awards by season Now liveScoped awards are listed with their latest winner and the top scorer fills the roll of honour where exactly one most-goals award is scoped. No award type identifies a single player of the season, so that column stays empty. CSV-era exports have no award scope.
  • comp_history and Honours Titles per team over recorded history Now liveCounts use the bounded history query, not just the displayed page, and apply available edition and stage flags. Coverage is stated.
  • competition across versions, export_value_scale Recorded names and reputation across versions Now liveThese are real version records. Reputation is shown against its stated 1–200 scale where the export records one; the cross-version chart still plots raw values.

Reviewed 30 September 2026 against the current schema and page implementation. “Now live” means implemented where data is recorded; “Exported; UI pending” means the schema has data this page does not yet use. Tables and coverage vary by version. Missing values stay blank.