Peter Walker
gone but not forgotten
Progress Report
The results of 10 days' work are that I have transcribed on to an EXCEL database the names and addresses of pubs and names of publicans for the years 1857, 1862, 1868, 1873, 1878 and am now on 1883. Not allowing for double-counting because of the frequent street renaming and renumbering, I have now have 1146 pub names and addresses, and at the moment, don't have a clue how many publicans' names I have - probably about three times as many.
Fairly soon, I intend to shuffle the list around, sorting by address rather than by pub name. That should help identify changes of pub name and to a certain extent street names. To ease this operation, where pubs were named or renamed Old ... or New ... , I have entered these amendments after the main pub name. I think I will do the same with street names, putting Upper ... , Lower, Old ... and New ... after the main name. This will I hope show up duplications and anomalies more clearly.
My broad intention is to continue with the years 1890, 1895, 1900, 1908, 1913, 1940, 1943, 1956 - I have classified trade lists and street directories for those years, of which I have copies here. If anyone has any lists for the 1920s and 30s, and after 1956, and would like to send me a copy, I should be very grateful, as I would like to extend the database. It does not include beerhouses, which were always treated separately from fully-licensed pubs in the dirstectories, with no distinction between on- and off-licences, although there was a big difference in reality. Moreover the directories hardly ever included the names of on-licensed beerhouses, so they can only be identified by address and licensee. I started off putting beer retailers in the main list with pubs, but there were more of them than fully-licensed houses, so I separated them and Have done 1857 and part of 1862. This is much more tedious, and there is vast bulk of data to go through. Perhaps later.
Peter
The results of 10 days' work are that I have transcribed on to an EXCEL database the names and addresses of pubs and names of publicans for the years 1857, 1862, 1868, 1873, 1878 and am now on 1883. Not allowing for double-counting because of the frequent street renaming and renumbering, I have now have 1146 pub names and addresses, and at the moment, don't have a clue how many publicans' names I have - probably about three times as many.
Fairly soon, I intend to shuffle the list around, sorting by address rather than by pub name. That should help identify changes of pub name and to a certain extent street names. To ease this operation, where pubs were named or renamed Old ... or New ... , I have entered these amendments after the main pub name. I think I will do the same with street names, putting Upper ... , Lower, Old ... and New ... after the main name. This will I hope show up duplications and anomalies more clearly.
My broad intention is to continue with the years 1890, 1895, 1900, 1908, 1913, 1940, 1943, 1956 - I have classified trade lists and street directories for those years, of which I have copies here. If anyone has any lists for the 1920s and 30s, and after 1956, and would like to send me a copy, I should be very grateful, as I would like to extend the database. It does not include beerhouses, which were always treated separately from fully-licensed pubs in the dirstectories, with no distinction between on- and off-licences, although there was a big difference in reality. Moreover the directories hardly ever included the names of on-licensed beerhouses, so they can only be identified by address and licensee. I started off putting beer retailers in the main list with pubs, but there were more of them than fully-licensed houses, so I separated them and Have done 1857 and part of 1862. This is much more tedious, and there is vast bulk of data to go through. Perhaps later.
Peter
