I did a lexical search and ranked the returned concept id based on their descendant record count/record count in the OHDSI Concept Prevalence study.
The top two concept id that accounts for ~70,000 records (25,464,398 + 44,293,234) of about 90,000 records total - are non specific to the various major sub-types of cardiomyopathy. This is an indication that it is most probably not possible, in observational data - to discern between the major subtypes of dilated cardiomyopathy, hypertrophic cardiomyopathy and restrictive cardiomyopathy.
Then there are items in the search - that sound like Cardiomyopathy - but are not? e.g. is
Takotsubo cardiomyopathy a type of cardiomyopathy? Or is it a misnomer for a temporary condition.