Many many cafes, restaurants, bars, etc will have the WiFi password published in the comments of FourSquare.  And most of the passwords are kept updated as long as the post is from the past year or two.  If this doesn’t work, try using that establishment’s phone-number as the password.