This man lived in New Harmony, Indiana and at some unknown point in time this man became a police officer. This man ended up getting possessed by a demon who worked for Lilith. The demon kept a lookout for Sam and Dean Winchester who were trying to kill Lilith and get Dean out of his crossroads deal.
The cop and demon were both killed by Dean with the Demon-Killing Knife when the demon pulled Dean over and Dean saw the demon's real face. The boys and Bobby Singer later hide the body and cop car.