Is there data available for substate areas, cities, or counties?

SAMHSA has published substate estimates available, the latest being 2012-2014. From the SAMHSA data page, https://www.samhsa.gov/data/, click on the “Substate” tab.