The last song on the album S.F. Sorrow by the Pretty Things from 1968. The album is considered to be the first rock opera with some challengers. Also a possible inspiration for Tommy by the Who. See what you think of it.
The song apparently has it’s origin around or before 1924 and is possibly based on more than one song. There have certainly been many local variations. This is just one.