I wanted to know how can I get list of cities in US whose crime data is available Socrata dataset.
Socrata has the Open Data Network where you can search across all Socrata portals. It has an underlying API so you can do it programmatically as well.