This novelty single actually reached #20 on the charts, according to Wikipedia. I remember hearing it on AM radio very often when it was first released, so it might have charted higher in some areas. It was taken out of rotation after his assassination.
I’d never heard of comedian Bill Minkin, but it’s a safe bet that he influenced Mayor Quimby.
Vaughn Meader did it better, the poor bastard.