Jump to content

scottish football archive


still_game

Recommended Posts

hi, im in the middle of inputting data to an excel database i have created that gathers all the info from scottish seasons gone past, and collates the info to create a database of information.

matches are viewed on a week to week basis, and may be from various competitions (drybrough cup, league, scottish cup, scot league cup, anglo scottish cup, u21, international)

as you click on each match it shows a multitude of information for that specific match. the images below are taken from 1979/80, and 1980/81

1979.thumb.png.750aa2b2167fe1721e4f975a572c13f9.png1980.thumb.png.c0e5a92e58b25ccb4b1470f1260ebda8.png

as you can see, there is goal times, lineups, referee, yellow cards/red cards, substitutions, venue, attendance, as well s ht score and goalscorers.

each match for a particular week is clickable, and displays the relevant info for that match, the info is collated into a table, and shows the players details as well as total matches played for that season in various columns,

pdb.thumb.png.332f65ed35065ee3a8e9e968c641d409.png

Im not looking for help (although if anyone wants to help then feel free to message me) im looking for stories, thoughts, feedback etc. id like to add small snippets of details for the matches if i can, eg who missed a sitter, who got away with a dirty tackle and so forth. manager sacked after game would be another. so im looking for like minded footy fans (thats you) to fill me in on details i may not have or have missed, or possibly made an error.

currently im working on 1979/80, but 1980/81 is complete, and 1979/80 is 80% complete, the idea obviously is to add as much as i can in regards seasons (i have all the info just need to input to the excel sheet)

at the moment i have only input top division matches, and cup matches involving top division clubs, as gathering lower league info can be troublesome. the 1980/81 file contains details of over 300 matches, as does the 79/80 file, so a fair amount of info for all you statto's.

feel free to offer feedback, constructive crtique, or feel free to mail me/message me regards more info.

Link to comment
Share on other sites

  • 3 months later...
 
probably a long stretch asking this, but im hoping some members might have programmes for the following matches, and can tell me who the referee was?

12/03/1978 30 east fife Queen of South
15/03/1978 31 Kilmarnock FC Montrose FC
15/03/1978 31 Queen of South Arbroath FC
02/01/1978 23 Hamilton Accies Airdrieonians FC
02/01/1978 23 Kilmarnock FC Queen of South
02/01/1978 23 Montrose FC Arbroath FC
02/01/1978 23 Alloa Athletic Stirling Albion
02/01/1978 23 Dumbarton FC Greenock Morton
02/01/1978 23 Dundee FC St Johnstone FC
19/10/1977 12 Airdrieonians FC Alloa Athletic
19/10/1977 12 Dundee FC Arbroath FC
19/10/1977 12 Greenock Morton Queen of South
19/10/1977 12 Hamilton Accies East Fife
19/10/1977 12 Kilmarnock FC St Johnstone FC
19/10/1977 12 Stirling Albion Dumbarton FC
28/09/1977 8 Airdrieonians FC Arbroath FC
28/09/1977 8 east fife Dumbarton FC
28/09/1977 8 Greenock Morton Hamilton Accies
28/09/1977 8 Montrose FC Kilmarnock FC
28/09/1977 8 Queen of South Dundee Fc
28/09/1977 8 St Johnstone FC Stirling Albion
14/09/1977 5 Alloa Athletic Dundee Fc
14/09/1977 5 Arbroath FC St Johnstone FC
14/09/1977 5 Dumbarton FC Airdrieonians FC
14/09/1977 5 Greenock Morton Stirling Albion
14/09/1977 5 Hamilton Accies Kilmarnock FC
03/09/1977 4 east fife Montrose FC
Link to comment
Share on other sites

On 20/10/2018 at 18:31, still_game said:
 
probably a long stretch asking this, but im hoping some members might have programmes for the following matches, and can tell me who the referee was?

12/03/1978 30 east fife Queen of South
15/03/1978 31 Kilmarnock FC Montrose FC
15/03/1978 31 Queen of South Arbroath FC
02/01/1978 23 Hamilton Accies Airdrieonians FC
02/01/1978 23 Kilmarnock FC Queen of South
02/01/1978 23 Montrose FC Arbroath FC
02/01/1978 23 Alloa Athletic Stirling Albion
02/01/1978 23 Dumbarton FC Greenock Morton
02/01/1978 23 Dundee FC St Johnstone FC
19/10/1977 12 Airdrieonians FC Alloa Athletic
19/10/1977 12 Dundee FC Arbroath FC
19/10/1977 12 Greenock Morton Queen of South
19/10/1977 12 Hamilton Accies East Fife
19/10/1977 12 Kilmarnock FC St Johnstone FC
19/10/1977 12 Stirling Albion Dumbarton FC
28/09/1977 8 Airdrieonians FC Arbroath FC
28/09/1977 8 east fife Dumbarton FC
28/09/1977 8 Greenock Morton Hamilton Accies
28/09/1977 8 Montrose FC Kilmarnock FC
28/09/1977 8 Queen of South Dundee Fc
28/09/1977 8 St Johnstone FC Stirling Albion
14/09/1977 5 Alloa Athletic Dundee Fc
14/09/1977 5 Arbroath FC St Johnstone FC
14/09/1977 5 Dumbarton FC Airdrieonians FC
14/09/1977 5 Greenock Morton Stirling Albion
14/09/1977 5 Hamilton Accies Kilmarnock FC
03/09/1977 4 east fife Montrose FC

I have a good few home QoS programmes from 77 and 78 although its well before I started going myself. Sadly dont have any of the ones you list. Annoyingly I have the home games either side of that Dundee game in 77 but not that one.

Link to comment
Share on other sites

12/03/1978 30 East fife Queen of South: K. Stewart (Glasgow)   

19/10/1977 12 Hamilton Accies East Fife: Eddie Pringle (Edinburgh) 

28/09/1977 8 East fife Dumbarton FC: Eddie Pringle (Edinburgh)  

03/09/1977 4 East fife Montrose FC: E. Thomson (Edinburgh) 

Link to comment
Share on other sites

On 10/24/2018 at 11:04, Ranaldo Bairn said:

Good luck with this, although it looks similar to something the guys at http://www.fitbastats.com/ have already completed?

fitbastats has the results, what they dont have is lineups, referees, half times etc for a lot of matches, that being the case i wouldnt be on asking for people to look out their old programmes for the ref lol.

@angusfifer, superb mate many thanks, for those referees.

Link to comment
Share on other sites

im working on division one 78/79 and 79/80 next, so if you have programmes for east fife, QoS for those seasons, they will be a great help.

regards 77/78 ive got every match lineup, attendance, and goalscorer. currently working through goal times,

ive completed scot premier 77/78, 78/79,79/80 and 80/81

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...