I am looking for data containing the average amount of sunny days in particular cities.

The NOAA NCEP CPC Weather Station Data include sunshine, so you can see monthly average hours of sunshine over the last twenty years for any of 8000 or so stations.