Oh goodness....I didn’t realize it included the US as well! I had searched specifically for Canada. LOL
This is the one I normally use: it has not just CSAs, but also farmers markets, pick your own locations, and just local farms in general. https://www.localharvest.org (it keeps defaulting to my location; if it still does, just change the default!)
We have that here. When I lived in California we actually had some pretty good farmers market, complete with music and dancing.
Where I live is mostly known as an agricultural area, though we do have some businesses here. People here don’t want oilfield workers, and I don’t blame them. Don’t want illegals either.
https://en.wikipedia.org/wiki/San_Angelo,_Texas