OMOP CDM Concept Metadata Distribution Functions

[meerapatelmd]

1. Assess the distribution of target concepts in all the OMOP CDM tables by first reducing the fields down to the concept level (removing person and observation information). For example, only getting the target drug concept and source drug concept information in the Drug Exposures Table.
2. While the scope of the main concept of the OMOP CDM Tables (ie drug_concept_id) may be to wide in breadth, ancillary fields for certain OMOP CDM Tables such as route_concept_id in Drug Exposures can be returned as a factor for quick assessment of distribution as well as easy filtering. For example, I would be able to see what the routes are in the Drug Exposures table to filter out certain routes that are not relevant to strength calculations (such as transdermal routes):

SELECT DISTINCT c.* 
FROM omop_cdm_2.drug_exposure de 
INNER JOIN omop_vocabulary.concept c 
ON c.concept_id = de.route_concept_id