Scottish Second Division

FM11 Release

Competition
53Reputation
—League games
10Clubs
—Total squad value

Competition

Code
SD2
Nation
Scotland
Confederation
Europe
Type
Standard division
Level
3
Reputation
53
Status
Active
Season
— – —
Colours
#F5AD03 #0030A0
Short name
Second Division
Parent competition
—
Crowd tendencies
—

Format

Partial export
Teams
10
League games
—
Promoted in
—
Relegated
—
Champions League
—
Europa League
—
Conference League
—
Play-offs
—
Maximum games
—

Squad rules

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

Most titles

35 recorded titlesFMDB calculation
4Stirling Albion2010, 1996, 1991, 1977
4Clyde2000, 1993, 1982, 1978
3Brechin City2005, 1990, 1983
2Raith Rovers2009, 2003
2Greenock Morton2007, 1995
2Stranraer1998, 1994
2Ayr United1997, 1988
1Gretna2006
1Falkirk1980

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. Every recorded season in this version. It records no cancelled, abandoned or joint-winner flags, so none are excluded.

Season table

In the export
Pos Team P W D L GF GA GD Points
1 Stirling Albion 36 18 11 7 68 48 20 65
2 Alloa Athletic 36 19 8 9 49 35 14 65
3 Cowdenbeath 36 16 11 9 60 41 19 65
4 Brechin City 36 15 9 12 50 45 5 54
5 Peterhead 36 15 6 15 45 49 -4 51
6 Dumbarton 36 14 6 16 49 58 -9 48
7 East Fife 36 10 11 15 46 53 -7 41
8 Stenhousemuir 36 9 13 14 38 42 -4 40
9 Arbroath 36 10 10 16 41 55 -14 40
10 Clyde 36 8 7 21 37 57 -20 31

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.

2009–10 — full season table. Showing 10 of 10 recorded rows. Points are shown as stored.

League strength

FMDB calculation
Member clubs with the figures that size them up
Airdrie United56———————101711000
Alloa Athletic60———————3142660
Ayr United65———————80001783
Brechin City60———————3060500
Dumbarton53———————2100700
East Fife53———————1995650
Forfar Athletic56———————5117490
Livingston74———————100051500
Peterhead54———————3700580
Stenhousemuir53———————3776400

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. 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
—————

Roll of honour

Placings point at teams, not clubs

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
Scottish Second Division reputation across versions050100 CM0102 RFM06 RFM10 RFM13 RFM16 RFM19 RFM22 RFM26 UReputation, CM0102 Release: 4 Reputation, CM0203 Release: 4 Reputation, CM0304 Release: 4 Reputation, CM0304 Update: 4 Reputation, FM05 Release: 40 Reputation, FM05 Update: 40 Reputation, FM06 Release: 40 Reputation, FM07 Release: 40 Reputation, FM07 Update: 40 Reputation, FM08 Release: 40 Reputation, FM09 Release: 40 Reputation, FM09 Update: 40 Reputation, FM10 Release: 53 Reputation, FM10 Update: 53 Reputation, FM11 Release: 53 Reputation, FM11 Update: 53 Reputation, FM12 Release: 53 Reputation, FM12 Update: 53 Reputation, FM13 Release: 53 Reputation, FM13 Update: 53 Reputation, FM14 Release: 60 Reputation, FM14 Update: 64 Reputation, FM15 Release: 64 Reputation, FM15 Update: 64 Reputation, FM16 Release: 64 Reputation, FM16 Update: 64 Reputation, FM17 Release: 62 Reputation, FM17 Update: 62 Reputation, FM18 Release: 61 Reputation, FM18 Update: 61 Reputation, FM19 Release: 62 Reputation, FM19 Update: 62 Reputation, FM20 Release: 65 Reputation, FM20 Update: 65 Reputation, FM21 Release: 65 Reputation, FM21 Update: 68 Reputation, FM22 Release: 70 Reputation, FM23 Release: 71 Reputation, FM24 Release: 70 Reputation, FM26 Release: 70 Reputation, FM26 Update: 70
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 ReleaseScottish Second Division
CM0203 ReleaseScottish Second Division
CM0304 ReleaseScottish Second Division
CM0304 UpdateScottish Second Division
FM05 ReleaseScottish Second Division
FM05 UpdateScottish Second Division
FM06 ReleaseScottish Second Division
FM07 ReleaseScottish Second Division
FM07 UpdateScottish Second Division
FM08 ReleaseScottish Second Division
FM09 ReleaseScottish Second Division
FM09 UpdateScottish Second Division
FM10 ReleaseScottish Second Division
FM10 UpdateScottish Second Division
FM11 ReleaseScottish Second Division
FM11 UpdateScottish Second Division
FM12 ReleaseScottish Second Division
FM12 UpdateScottish Second Division
FM13 ReleaseScottish Second Division
FM13 UpdateScottish Second Division
FM14 ReleaseScottish League 1
FM14 UpdateScottish League 1
FM15 ReleaseScottish League 1
FM15 UpdateScottish League 1
FM16 ReleaseLadbrokes League 1
FM16 UpdateLadbrokes League 1
FM17 ReleaseLadbrokes League 1
FM17 UpdateLadbrokes League 1
FM18 ReleaseLadbrokes League 1
FM18 UpdateLadbrokes League 1
FM19 ReleaseLadbrokes League 1
FM19 UpdateLadbrokes League 1
FM20 ReleaseLadbrokes League 1
FM20 UpdateLadbrokes League 1
FM21 ReleaseLadbrokes League 1
FM21 UpdateScottish League 1
FM22 Releasecinch League 1
FM23 Releasecinch League 1
FM24 Releasecinch League 1
FM26 ReleaseWilliam Hill League 1
FM26 UpdateWilliam Hill League 1

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

Awards

Not in this export

No award scope in this export

Only the modern exports record which competition an award belongs to (award_scope). Sharing a nation with a competition does not make an award that competition's, so none is listed.

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

Not in this export

No media predictions in this export

club_media_expectation is part of the modern exports only.

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

0 between member clubs
Derbies whose two clubs both name this competition as their division
Derby Clubs W–D–L National reputation
No derby in this version is between two of this competition's clubs.

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

Current members from club.division_uid; no comp_membership rows are recorded.

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.

Teams recorded as members of this competition
Team Membership Last position Manager
Airdrie UnitedCurrent division9James Thomson Boyle
Alloa AthleticCurrent division2Hugh McCann
Ayr UnitedCurrent division10—
Brechin CityCurrent division4—
DumbartonCurrent division5Jim Chapman
East FifeCurrent division6Stephen Crawford
Forfar AthleticCurrent division2Richard Menzies Campbell
LivingstonCurrent division1Gary Bollan
PeterheadCurrent division5Neale Cooper
StenhousemuirCurrent division8Kevin McGoldrick

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.