TheFMDB
VersionFM13 Release
Light

Scottish First Division

FM13 Release

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

Competition

Code
SD1
Nation
Scotland
Confederation
Europe
Type
Standard division
Level
2
Reputation
80
Status
Active
Season
— – —
Colours
#F5AD03 #0030A0
Short name
First 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
—
Joined since 2011–12
Airdrie United from Scottish Second Division, Cowdenbeath from Scottish Second Division, Dumbarton from Scottish Second Division, Dunfermline Athletic from Clydesdale Bank Premier League
Left since 2011–12
Ayr United now in Scottish Second Division, Dundee now in Clydesdale Bank Premier League, Queen Of The South now in Scottish Second Division, Ross County now in Clydesdale Bank Premier League

Squad rules

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

Most titles

106 recorded titlesFMDB calculation
7St. Johnstone2009, 1997, 1990, 1983, 1963, 1960, 1924
7Falkirk2005, 2003, 1994, 1991, 1975, 1970, 1936
6Greenock Morton1987, 1984, 1978, 1967, 1964, 1950
6Ayr United1966, 1959, 1937, 1928, 1913, 1912
5Partick Thistle2002, 1976, 1971, 1900, 1897
5Hibernian1999, 1981, 1933, 1895, 1894
5Raith Rovers1995, 1993, 1949, 1938, 1908
5Clyde1973, 1962, 1957, 1952, 1905
4Dunfermline Athletic2011, 1996, 1989, 1926
4Hamilton Academical2008, 1988, 1986, 1904
4St. Mirren2006, 2000, 1977, 1968
4Dundee1998, 1992, 1979, 1947
4Motherwell1985, 1982, 1969, 1954
4Stirling Albion1965, 1961, 1958, 1953
3Airdrieonians1974, 1955, 1903
3Cowdenbeath1939, 1915, 1914
3Leith Athletic1930, 1910, 1906
2Inverness Caledonian Thistle2010, 2004
2Dumbarton1972, 1911
2Queen's Park1956, 1923
2Third Lanark1935, 1931
2Dundee United1929, 1925
2Abercorn1909, 1896
2St. Bernard's1907, 1901
2Kilmarnock1899, 1898
1Ross County2012
1Gretna2007
1Livingston2001
1Heart Of Midlothian1980
1Queen Of The South1951
1East Fife1948
1Albion Rovers1934
1East Stirlingshire1932
1Bo'ness1927
1Alloa Athletic1922
1Port Glasgow1902

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 Ross County 36 22 13 1 72 32 40 79
2 Dundee 36 15 10 11 53 43 10 55
3 Falkirk 36 13 13 10 53 48 5 52
4 Hamilton Academical 36 14 7 15 55 56 -1 49
5 Livingston 36 13 9 14 56 54 2 48
6 Partick Thistle 36 12 11 13 50 39 11 47
7 Raith Rovers 36 11 11 14 46 49 -3 44
8 Greenock Morton 36 10 12 14 40 55 -15 42
9 Ayr United 36 9 11 16 44 67 -23 38
10 Queen Of The South 36 7 11 18 38 64 -26 32

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.

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

League strength

FMDB calculation
Columns

Columns
Airdrie United63———————10171856
Cowdenbeath65———————4370800
Dumbarton62838391——£250—2025800
Dunfermline Athletic86637189——£6,644—119844000
Falkirk86———————79793188
Greenock Morton739494102——£1,199—116121992
Hamilton Academical867272102——£600—60781954
Livingston829292105——£300—101221810
Partick Thistle778686109——£800—136622507
Raith Rovers77828288——£599—101042067

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
1Paul GallacherDunfermline AthleticGK105
2David GrahamGreenock MortonAMR99
3Joe CardleDunfermline AthleticML98
4Jordan McMillanDunfermline AthleticDR95
5Jordan MortonLivingstonML92
6Andrew BarrowmanDunfermline AthleticFC90
7Andy KirkDunfermline AthleticFC89
8Peter MacDonaldGreenock MortonFC88
9Ross ForbesPartick ThistleAMC86
10Andy DowieDunfermline AthleticDR85

Roll of honour

Placings point at teams, not clubs
Season Winner Runner-up Third Top scorer Not in this export Player of the season See awards
2012Ross CountyDundeeFalkirk——
2011Dunfermline AthleticRaith RoversFalkirk——
2010Inverness Caledonian ThistleDundeeDunfermline Athletic——
2009St. JohnstonePartick ThistleDunfermline Athletic——
2008Hamilton AcademicalDundeeSt. Johnstone——
2007GretnaSt. JohnstoneDundee——
2006St. MirrenSt. JohnstoneHamilton Academical——
2005FalkirkSt. MirrenClyde——
2004Inverness Caledonian ThistleClydeSt. Johnstone——
2003FalkirkClydeSt. Johnstone——
2002Partick ThistleAirdrieoniansAyr United——
2001LivingstonAyr UnitedFalkirk——
2000St. MirrenDunfermline AthleticFalkirk——
1999HibernianFalkirkAyr United——
1998DundeeFalkirkRaith Rovers——
1997St. JohnstoneAirdrieoniansDundee——
1996Dunfermline AthleticDundeeGreenock Morton——
1995Raith RoversDunfermline AthleticDundee——
1994FalkirkDunfermline AthleticAirdrieonians——
1993Raith RoversKilmarnockDunfermline Athletic——
1992DundeePartick ThistleHamilton Academical——
1991FalkirkAirdrieoniansDundee——
1990St. JohnstoneAirdrieoniansClydebank——
1989Dunfermline AthleticFalkirkClydebank——
1988Hamilton AcademicalMeadowbankClydebank——

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 First Division reputation across versions050100 CM0102 RFM06 RFM10 RFM13 RFM16 RFM19 RFM22 RFM26 UReputation, CM0102 Release: 8 Reputation, CM0203 Release: 8 Reputation, CM0304 Release: 8 Reputation, CM0304 Update: 8 Reputation, FM05 Release: 80 Reputation, FM05 Update: 80 Reputation, FM06 Release: 80 Reputation, FM07 Release: 80 Reputation, FM07 Update: 80 Reputation, FM08 Release: 80 Reputation, FM09 Release: 80 Reputation, FM09 Update: 80 Reputation, FM10 Release: 80 Reputation, FM10 Update: 80 Reputation, FM11 Release: 80 Reputation, FM11 Update: 80 Reputation, FM12 Release: 80 Reputation, FM12 Update: 80 Reputation, FM13 Release: 80 Reputation, FM13 Update: 80 Reputation, FM14 Release: 80 Reputation, FM14 Update: 85 Reputation, FM15 Release: 85 Reputation, FM15 Update: 85 Reputation, FM16 Release: 85 Reputation, FM16 Update: 85 Reputation, FM17 Release: 82 Reputation, FM17 Update: 82 Reputation, FM18 Release: 81 Reputation, FM18 Update: 81 Reputation, FM19 Release: 82 Reputation, FM19 Update: 82 Reputation, FM20 Release: 85 Reputation, FM20 Update: 85 Reputation, FM21 Release: 85 Reputation, FM21 Update: 90 Reputation, FM22 Release: 93 Reputation, FM23 Release: 95 Reputation, FM24 Release: 94 Reputation, FM26 Release: 94 Reputation, FM26 Update: 94
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 First Division
CM0203 ReleaseScottish First Division
CM0304 ReleaseScottish First Division
CM0304 UpdateScottish First Division
FM05 ReleaseScottish First Division
FM05 UpdateScottish First Division
FM06 ReleaseScottish First Division
FM07 ReleaseScottish First Division
FM07 UpdateScottish First Division
FM08 ReleaseScottish First Division
FM09 ReleaseScottish First Division
FM09 UpdateScottish First Division
FM10 ReleaseScottish First Division
FM10 UpdateScottish First Division
FM11 ReleaseScottish First Division
FM11 UpdateScottish First Division
FM12 ReleaseScottish First Division
FM12 UpdateScottish First Division
FM13 ReleaseScottish First Division
FM13 UpdateScottish First Division
FM14 ReleaseScottish Championship
FM14 UpdateScottish Championship
FM15 ReleaseScottish Championship
FM15 UpdateScottish Championship
FM16 ReleaseLadbrokes Championship
FM16 UpdateLadbrokes Championship
FM17 ReleaseLadbrokes Championship
FM17 UpdateLadbrokes Championship
FM18 ReleaseLadbrokes Championship
FM18 UpdateLadbrokes Championship
FM19 ReleaseLadbrokes Championship
FM19 UpdateLadbrokes Championship
FM20 ReleaseLadbrokes Championship
FM20 UpdateLadbrokes Championship
FM21 ReleaseLadbrokes Championship
FM21 UpdateScottish Championship
FM22 Releasecinch Championship
FM23 Releasecinch Championship
FM24 Releasecinch Championship
FM26 ReleaseWilliam Hill Championship
FM26 UpdateWilliam Hill Championship

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

1 between member clubs
Derby Clubs W–D–L National reputation
FifeRaith Rovers v Dunfermline Athletic35–23–3880

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

10 clubs name this as their division

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.

Team Membership Last position Manager
Airdrie UnitedCurrent division4James Thomson Boyle
CowdenbeathCurrent division1Colin Cameron
DumbartonCurrent division3Alan Adamson
Dunfermline AthleticCurrent division12—
FalkirkCurrent division3—
Greenock MortonCurrent division8Allan Moore
Hamilton AcademicalCurrent division4—
LivingstonCurrent division5John Hughes
Partick ThistleCurrent division6Jackie McNamara
Raith RoversCurrent division7John McGlynn

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.