What are some helpful online tools (databases, etc..) for economic analysts?
St. Louis Fed:
https://fred.stlouisfed.org/

Has very good US data. 

I am not aware of a database that systematically aggregates city-level data. I recommend state government sites and, for larger cities, city government sites.