In the course of a five-month inquiry , the AP discovered that drugs have been detected in the drinking water supplies of 24 major metropolitan areas -- from Southern California to Northern New Jersey , from Detroit to Louisville , Ky .