It was written by Thomas Lanfiere, who churned out a lot of moralizing 'alehouse ballads', allegedly inspired by his own familiarity with such places. I found it easier to see how the song we know might have descended from 'The Good Fellow's Resolution' blackletter broadside, than to imagine Lanfiere having dressed up a simpler song already in existence.