Individual cities, yes, but Oregon is the only state. I've gotten my shrooms in Oakland for instance (since Oakland has decrimmed psychedelics for a while).
I feel so clueless on how people obtain these things. As someone in the bay area, it seems like everyone has the hookup but me.
My wife and I tried mushrooms (well, the non-fruiting-body things they had) in Amsterdam and I didn't notice much. She, on the other hand, stopped her OCD ticking for maybe 9 months afterward. It was so life-changing for her that I've been planning a trip to Amsterdam just so she can take another dose.