Suggest you see thread 52843, especialy a post by Malcolm Douglas, 30 Oct 02, which discusses "The Unfortunate Rake," and also read the other posts in this thread. Seemingly the tune can be traced back to about 1800, English. Buck's Elegy

Bard of Armagh and Streets of Laredo belong in this group of songs with the same or very similar melody.