OMOP CDM Queries
Search this site
Introduction
Introduction
Person
Observation Period
Care Site
Payer Plan Period
Condition Occurrence
Condition Occurrence Combinations
CONDITION ERA
Drug Exposure
Drug Era
Drug Cost
Observation
Procedure Occurrence
Procedure Combinations
Procedure Cost
Visit Occurrence
Provider
Location
Death
Drug Exposure
DEX01: Counts of persons with any number of exposures to a certain drug
DEX02: Counts of persons taking a drug, by age, gender, and year of exposure
DEX03: Distribution of age, stratified by drug
DEX04: Distribution of gender in persons taking a drug
DEX05: Counts of drug records for a particular drug
DEX06: Counts of distinct drugs in the database
DEX07: Maximum number of drug exposure events per person over some time period
DEX08: Maximum number of distinct drugs per person over some time period
DEX09: Average number of distinct drugs per person over some time period
DEX10: Other drugs (conmeds) patients exposed to a certain drug take over some time period
DEX11: Distribution of brands used for a given generic drug
DEX12: Distribution of forms used for a given ingredient
DEX13: Distribution of provider specialities prescribing a given drug
DEX14: Number of persons who take drug A also taking drug B
DEX15: Counts of persons taking a given drug having a 180 day clean period prior and a 365 day follow-up period
DEX16: Adherence rate for given drug
DEX17: Stop reasons for drug treatment
DEX18: Distribution of drug type (modes of distribution) for a given drug
DEX19: Number of persons taking a drug for a given indication
DEX20: Number of persons taking a drug with the indication condition recorded prior to exposure
DEX21: Number of persons with a contraindication for the drug they are taking
DEX22: Number of persons taking a drug in a given class
DEX23: Distribution of days supply
DEX24: Counts of days supply
DEX25: Counts of drug records
DEX26: Distribution of drug exposure end dates
DEX27: Distribution of drug exposure start dates
DEX28: Counts of drug types
DEX29: Distribution of number of distinct drugs persons take
DEX30: Counts of number of distinct drugs persons take
DEX31: Distribution of drug exposure records per person
DEX32: Counts of drug exposure records per person
DEX33: Counts of drug exposure records stratified by observation month
DEX34: Distribution of drug quantity
DEX35: Counts of drug quantity
DEX36: Distribution of drug refills
DEX37: Counts of drug refills
DEX38: Counts of stop reasons
DEX39: Counts of drugs, stratified by drug type
DEX40: Counts of drugs, stratified by relevant condition
DEX41: Distribution of drug exposure start date, stratified by drug
DEX42: Counts of genders, stratified by drug
DEX43: Counts of drug exposure records per person, stratified by drug
Comments
