Set up

Install packages and load Eunomia and test that it works

library(magrittr)
# library(devtools)
# options(devtools.install.args = "--no-multiarch")
# install_github('OHDSI/DatabaseConnector')
# install_github('OHDSI/SqlRender')
# 
# install_github('OHDSI/FeatureExtraction')
# install_github('OHDSI/OhdsiRTools')
# install_github('OHDSI/OhdsiSharing')
# devtools::install_github('OHDSI/Eunomia')
# devtools::install_github('OHDSI/DataQualityDashboard')
# devtools::install_github('OHDSI/PatientLevelPrediction')
#remove.packages('Eunomia')

library(Eunomia)
## Loading required package: DatabaseConnector
connectionDetails <- Eunomia::getEunomiaConnectionDetails()
connection <- connect(connectionDetails)
## Connecting using SQLite driver
querySql(connection, "SELECT COUNT(*) FROM person;")
##   COUNT(*)
## 1     2694
DatabaseConnector::disconnect(connection)

Run DQD

on Eunomia

library(DataQualityDashboard)
cdmDatabaseSchema<-'main'
resultsDatabaseSchema<-cdmDatabaseSchema
cdmSourceName='eunomia'
outputFolder='c:/temp'

#we can run just one check to make it fast
checkNames=c('plausibleValueLow')

#all checks are here
dashChecks<-read.csv(system.file("csv","OMOP_CDMv5.3.1_Check_Descriptions.csv",package="DataQualityDashboard"),as.is=T)
dashChecks$checkName
##  [1] "measurePersonCompleteness"        
##  [2] "cdmField"                         
##  [3] "isRequired"                       
##  [4] "cdmDatatype"                      
##  [5] "isPrimaryKey"                     
##  [6] "isForeignKey"                     
##  [7] "fkDomain"                         
##  [8] "fkClass"                          
##  [9] "isStandardValidConcept"           
## [10] "measureValueCompleteness"         
## [11] "standardConceptRecordCompleteness"
## [12] "sourceConceptRecordCompleteness"  
## [13] "sourceValueCompleteness"          
## [14] "plausibleValueLow"                
## [15] "plausibleValueHigh"               
## [16] "plausibleTemporalAfter"           
## [17] "plausibleDuringLife"              
## [18] "plausibleValueLow"                
## [19] "plausibleValueHigh"               
## [20] "plausibleGender"
#actual execution
result<-executeDqChecks(connectionDetails,cdmDatabaseSchema
                        ,resultsDatabaseSchema = resultsDatabaseSchema
                        ,cdmSourceName = cdmSourceName
                        ,verboseMode = TRUE
                        ,outputFolder = outputFolder
                        ,checkNames = checkNames)
## Connecting using SQLite driver
## Processing check description: plausibleValueLow
## Processing check description: plausibleValueLow
## Connecting using SQLite driver
## Execution Complete
## Connecting using SQLite driver

inspecting the results

jsonFile<-file.path(outputFolder,cdmSourceName,paste0('results_',cdmSourceName,'.json'))
#DataQualityDashboard::viewDqDashboard(jsonFile)

jresult<-jsonlite::fromJSON(jsonFile)
overview<-jresult$CheckResults
#value of 1 indicates failed
table(overview$FAILED)
## 
##   0   1 
## 883  26

Create Cohorts

library(Eunomia)
cohorts<-Eunomia:::createCohorts(connectionDetails)
## Connecting using SQLite driver
## Creating cohort: Celecoxib
## 
  |                                                                       
  |                                                                 |   0%
  |                                                                       
  |=================================================================| 100%
## Executing SQL took 0.02 secs
## Creating cohort: Diclofenac
## 
  |                                                                       
  |                                                                 |   0%
  |                                                                       
  |=================================================================| 100%
## Executing SQL took 0.022 secs
## Creating cohort: GiBleed
## 
  |                                                                       
  |                                                                 |   0%
  |                                                                       
  |=================================================================| 100%
## Executing SQL took 0.03 secs
## Creating cohort: NSAIDs
## 
  |                                                                       
  |                                                                 |   0%
  |                                                                       
  |=================================================================| 100%
## Executing SQL took 0.147 secs
## Cohorts created in table main.cohort
#list them nicely
knitr::kable(cohorts)
cohortId name description count
1 Celecoxib A simplified cohort definition for new users of celecoxib, designed specifically for Eunomia. 1844
2 Diclofenac A simplified cohort definition for new users ofdiclofenac, designed specifically for Eunomia. 850
3 GiBleed A simplified cohort definition for gastrointestinal bleeding, designed specifically for Eunomia. 479
4 NSAIDs A simplified cohort definition for new users of NSAIDs, designed specifically for Eunomia. 2694

Cohort Characterization

Link https://ohdsi.github.io/TheBookOfOhdsi/Characterization.html#cohort-characterization-in-r

We can use cohorts created earlier.

library(FeatureExtraction)
#basic settings
settings<-createCovariateSettings(useDemographicsGender = TRUE
                                  ,useDemographicsAgeGroup = TRUE
                                  ,useConditionOccurrenceAnyTimePrior = TRUE)
str(settings)
## List of 13
##  $ temporal                       : logi FALSE
##  $ DemographicsGender             : logi TRUE
##  $ DemographicsAgeGroup           : logi TRUE
##  $ ConditionOccurrenceAnyTimePrior: logi TRUE
##  $ longTermStartDays              : num -365
##  $ mediumTermStartDays            : num -180
##  $ shortTermStartDays             : num -30
##  $ endDays                        : num 0
##  $ includedCovariateConceptIds    : logi(0) 
##  $ addDescendantsToInclude        : logi FALSE
##  $ excludedCovariateConceptIds    : logi(0) 
##  $ addDescendantsToExclude        : logi FALSE
##  $ includedCovariateIds           : logi(0) 
##  - attr(*, "fun")= chr "getDbDefaultCovariateData"
##  - attr(*, "class")= chr "covariateSettings"
#default settings
covariateSettings<-createDefaultCovariateSettings()
str(covariateSettings)
## List of 34
##  $ temporal                     : logi FALSE
##  $ DemographicsGender           : logi TRUE
##  $ DemographicsAgeGroup         : logi TRUE
##  $ DemographicsRace             : logi TRUE
##  $ DemographicsEthnicity        : logi TRUE
##  $ DemographicsIndexYear        : logi TRUE
##  $ DemographicsIndexMonth       : logi TRUE
##  $ ConditionGroupEraLongTerm    : logi TRUE
##  $ ConditionGroupEraShortTerm   : logi TRUE
##  $ DrugGroupEraLongTerm         : logi TRUE
##  $ DrugGroupEraShortTerm        : logi TRUE
##  $ DrugGroupEraOverlapping      : logi TRUE
##  $ ProcedureOccurrenceLongTerm  : logi TRUE
##  $ ProcedureOccurrenceShortTerm : logi TRUE
##  $ DeviceExposureLongTerm       : logi TRUE
##  $ DeviceExposureShortTerm      : logi TRUE
##  $ MeasurementLongTerm          : logi TRUE
##  $ MeasurementShortTerm         : logi TRUE
##  $ MeasurementRangeGroupLongTerm: logi TRUE
##  $ ObservationLongTerm          : logi TRUE
##  $ ObservationShortTerm         : logi TRUE
##  $ CharlsonIndex                : logi TRUE
##  $ Dcsi                         : logi TRUE
##  $ Chads2                       : logi TRUE
##  $ Chads2Vasc                   : logi TRUE
##  $ includedCovariateConceptIds  : logi(0) 
##  $ includedCovariateIds         : logi(0) 
##  $ addDescendantsToInclude      : logi FALSE
##  $ excludedCovariateConceptIds  : logi(0) 
##  $ addDescendantsToExclude      : logi FALSE
##  $ shortTermStartDays           : int -30
##  $ mediumTermStartDays          : int -180
##  $ endDays                      : int 0
##  $ longTermStartDays            : int -365
##  - attr(*, "fun")= chr "getDbDefaultCovariateData"
##  - attr(*, "class")= chr "covariateSettings"
#cohort 1 is celecoxib

covariateData2 <- getDbCovariateData(
  connectionDetails = connectionDetails, 
  cdmDatabaseSchema = cdmDatabaseSchema, 
  cohortDatabaseSchema = resultsDatabaseSchema, 
  #cohortTable = "cohorts_of_interest", 
  cohortId = 1, 
  covariateSettings = covariateSettings, 
  aggregated = TRUE) 
## Connecting using SQLite driver
## Constructing features on server
## 
  |                                                                       
  |                                                                 |   0%
  |                                                                       
  |                                                                 |   1%
  |                                                                       
  |=                                                                |   1%
  |                                                                       
  |=                                                                |   2%
  |                                                                       
  |==                                                               |   2%
  |                                                                       
  |==                                                               |   3%
  |                                                                       
  |==                                                               |   4%
  |                                                                       
  |===                                                              |   4%
  |                                                                       
  |===                                                              |   5%
  |                                                                       
  |====                                                             |   5%
  |                                                                       
  |====                                                             |   6%
  |                                                                       
  |====                                                             |   7%
  |                                                                       
  |=====                                                            |   7%
  |                                                                       
  |=====                                                            |   8%
  |                                                                       
  |======                                                           |   9%
  |                                                                       
  |======                                                           |  10%
  |                                                                       
  |=======                                                          |  10%
  |                                                                       
  |=======                                                          |  11%
  |                                                                       
  |========                                                         |  12%
  |                                                                       
  |========                                                         |  13%
  |                                                                       
  |=========                                                        |  13%
  |                                                                       
  |=========                                                        |  14%
  |                                                                       
  |==========                                                       |  15%
  |                                                                       
  |==========                                                       |  16%
  |                                                                       
  |===========                                                      |  16%
  |                                                                       
  |===========                                                      |  17%
  |                                                                       
  |===========                                                      |  18%
  |                                                                       
  |============                                                     |  18%
  |                                                                       
  |============                                                     |  19%
  |                                                                       
  |=============                                                    |  20%
  |                                                                       
  |=============                                                    |  21%
  |                                                                       
  |==============                                                   |  21%
  |                                                                       
  |==============                                                   |  22%
  |                                                                       
  |===============                                                  |  23%
  |                                                                       
  |===============                                                  |  24%
  |                                                                       
  |================                                                 |  24%
  |                                                                       
  |================                                                 |  25%
  |                                                                       
  |=================                                                |  26%
  |                                                                       
  |=================                                                |  27%
  |                                                                       
  |==================                                               |  27%
  |                                                                       
  |==================                                               |  28%
  |                                                                       
  |===================                                              |  29%
  |                                                                       
  |===================                                              |  30%
  |                                                                       
  |====================                                             |  30%
  |                                                                       
  |====================                                             |  31%
  |                                                                       
  |=====================                                            |  32%
  |                                                                       
  |=====================                                            |  33%
  |                                                                       
  |======================                                           |  33%
  |                                                                       
  |======================                                           |  34%
  |                                                                       
  |=======================                                          |  35%
  |                                                                       
  |=======================                                          |  36%
  |                                                                       
  |========================                                         |  36%
  |                                                                       
  |========================                                         |  37%
  |                                                                       
  |=========================                                        |  38%
  |                                                                       
  |=========================                                        |  39%
  |                                                                       
  |==========================                                       |  39%
  |                                                                       
  |==========================                                       |  40%
  |                                                                       
  |==========================                                       |  41%
  |                                                                       
  |===========================                                      |  41%
  |                                                                       
  |===========================                                      |  42%
  |                                                                       
  |============================                                     |  42%
  |                                                                       
  |============================                                     |  43%
  |                                                                       
  |============================                                     |  44%
  |                                                                       
  |=============================                                    |  44%
  |                                                                       
  |=============================                                    |  45%
  |                                                                       
  |==============================                                   |  45%
  |                                                                       
  |==============================                                   |  46%
  |                                                                       
  |==============================                                   |  47%
  |                                                                       
  |===============================                                  |  47%
  |                                                                       
  |===============================                                  |  48%
  |                                                                       
  |================================                                 |  48%
  |                                                                       
  |================================                                 |  49%
  |                                                                       
  |================================                                 |  50%
  |                                                                       
  |=================================                                |  50%
  |                                                                       
  |=================================                                |  51%
  |                                                                       
  |=================================                                |  52%
  |                                                                       
  |==================================                               |  52%
  |                                                                       
  |==================================                               |  53%
  |                                                                       
  |===================================                              |  53%
  |                                                                       
  |===================================                              |  54%
  |                                                                       
  |===================================                              |  55%
  |                                                                       
  |====================================                             |  55%
  |                                                                       
  |====================================                             |  56%
  |                                                                       
  |=====================================                            |  56%
  |                                                                       
  |=====================================                            |  57%
  |                                                                       
  |=====================================                            |  58%
  |                                                                       
  |======================================                           |  58%
  |                                                                       
  |======================================                           |  59%
  |                                                                       
  |=======================================                          |  59%
  |                                                                       
  |=======================================                          |  60%
  |                                                                       
  |=======================================                          |  61%
  |                                                                       
  |========================================                         |  61%
  |                                                                       
  |========================================                         |  62%
  |                                                                       
  |=========================================                        |  63%
  |                                                                       
  |=========================================                        |  64%
  |                                                                       
  |==========================================                       |  64%
  |                                                                       
  |==========================================                       |  65%
  |                                                                       
  |===========================================                      |  66%
  |                                                                       
  |===========================================                      |  67%
  |                                                                       
  |============================================                     |  67%
  |                                                                       
  |============================================                     |  68%
  |                                                                       
  |=============================================                    |  69%
  |                                                                       
  |=============================================                    |  70%
  |                                                                       
  |==============================================                   |  70%
  |                                                                       
  |==============================================                   |  71%
  |                                                                       
  |===============================================                  |  72%
  |                                                                       
  |===============================================                  |  73%
  |                                                                       
  |================================================                 |  73%
  |                                                                       
  |================================================                 |  74%
  |                                                                       
  |=================================================                |  75%
  |                                                                       
  |=================================================                |  76%
  |                                                                       
  |==================================================               |  76%
  |                                                                       
  |==================================================               |  77%
  |                                                                       
  |===================================================              |  78%
  |                                                                       
  |===================================================              |  79%
  |                                                                       
  |====================================================             |  79%
  |                                                                       
  |====================================================             |  80%
  |                                                                       
  |=====================================================            |  81%
  |                                                                       
  |=====================================================            |  82%
  |                                                                       
  |======================================================           |  82%
  |                                                                       
  |======================================================           |  83%
  |                                                                       
  |======================================================           |  84%
  |                                                                       
  |=======================================================          |  84%
  |                                                                       
  |=======================================================          |  85%
  |                                                                       
  |========================================================         |  86%
  |                                                                       
  |========================================================         |  87%
  |                                                                       
  |=========================================================        |  87%
  |                                                                       
  |=========================================================        |  88%
  |                                                                       
  |==========================================================       |  89%
  |                                                                       
  |==========================================================       |  90%
  |                                                                       
  |===========================================================      |  90%
  |                                                                       
  |===========================================================      |  91%
  |                                                                       
  |============================================================     |  92%
  |                                                                       
  |============================================================     |  93%
  |                                                                       
  |=============================================================    |  93%
  |                                                                       
  |=============================================================    |  94%
  |                                                                       
  |=============================================================    |  95%
  |                                                                       
  |==============================================================   |  95%
  |                                                                       
  |==============================================================   |  96%
  |                                                                       
  |===============================================================  |  96%
  |                                                                       
  |===============================================================  |  97%
  |                                                                       
  |===============================================================  |  98%
  |                                                                       
  |================================================================ |  98%
  |                                                                       
  |================================================================ |  99%
  |                                                                       
  |=================================================================|  99%
  |                                                                       
  |=================================================================| 100%
## Executing SQL took 3.17 secs
## Fetching data from server
## Fetching data took 0.339 secs
summary(covariateData2)
## CovariateData object summary
## 
## Number of covariates: 373
## Number of non-zero covariate values: 373

Inspecting covariate data

#I think it  goes to a temp table, but temp tables are not visible in sqlLite
#DatabaseConnector::getTableNames(connection)

#there are two types of covariates
names(covariateData2)
## [1] "covariates"           "covariatesContinuous" "covariateRef"        
## [4] "analysisRef"          "metaData"
#reference
#sql fo each analysis is here https://github.com/OHDSI/FeatureExtraction/tree/master/inst/sql/sql_server
ana<-covariateData2$analysisRef %>% as.data.frame()
knitr::kable(ana)
analysisId analysisName domainId startDay endDay isBinary missingMeansZero
212 ConditionGroupEraShortTerm Condition -30 0 Y NA
804 ObservationShortTerm Observation -30 0 Y NA
602 DeviceExposureLongTerm Device -365 0 Y NA
4 DemographicsRace Demographics NA NA Y NA
901 CharlsonIndex Condition NA 0 N Y
904 Chads2Vasc Condition NA 0 N Y
704 MeasurementShortTerm Measurement -30 0 Y NA
902 Dcsi Condition NA 0 N Y
410 DrugGroupEraLongTerm Drug -365 0 Y NA
412 DrugGroupEraShortTerm Drug -30 0 Y NA
702 MeasurementLongTerm Measurement -365 0 Y NA
6 DemographicsIndexYear Demographics NA NA Y NA
7 DemographicsIndexMonth Demographics NA NA Y NA
210 ConditionGroupEraLongTerm Condition -365 0 Y NA
5 DemographicsEthnicity Demographics NA NA Y NA
1 DemographicsGender Demographics NA NA Y NA
604 DeviceExposureShortTerm Device -30 0 Y NA
802 ObservationLongTerm Observation -365 0 Y NA
502 ProcedureOccurrenceLongTerm Procedure -365 0 Y NA
3 DemographicsAgeGroup Demographics NA NA Y NA
710 MeasurementRangeGroupLongTerm -365 0 Y NA
413 DrugGroupEraOverlapping Drug 0 0 Y NA
504 ProcedureOccurrenceShortTerm Procedure -30 0 Y NA
903 Chads2 Condition NA 0 N Y
#next we look at covariates (listing just few)
cov<-covariateData2$covariateRef %>% as.data.frame()
nrow(cov)
## [1] 373
knitr::kable(cov %>% head(10))
covariateId covariateName analysisId conceptId
28060212 condition_era group during day -30 through 0 days relative to index: Streptococcal sore throat 212 28060
78272212 condition_era group during day -30 through 0 days relative to index: Sprain of wrist 212 78272
80180212 condition_era group during day -30 through 0 days relative to index: Osteoarthritis 212 80180
80809212 condition_era group during day -30 through 0 days relative to index: Rheumatoid arthritis 212 80809
134438212 condition_era group during day -30 through 0 days relative to index: Contact dermatitis 212 134438
195588212 condition_era group during day -30 through 0 days relative to index: Cystitis 212 195588
257012212 condition_era group during day -30 through 0 days relative to index: Chronic sinusitis 212 257012
260139212 condition_era group during day -30 through 0 days relative to index: Acute bronchitis 212 260139
317576212 condition_era group during day -30 through 0 days relative to index: Coronary arteriosclerosis 212 317576
372328212 condition_era group during day -30 through 0 days relative to index: Otitis media 212 372328
#each analysis underpins several covariates
table(cov$analysisId)
## 
##   1   3   6   7 210 212 410 412 413 502 504 702 704 802 901 903 904 
##   2   4  78  12  51  31  46  24  11  27  12  48  22   2   1   1   1
#we can merget them to both (not done)

PLP

library(PatientLevelPrediction)
## Loading required package: Cyclops
## Registered S3 methods overwritten by 'ffbase':
##   method   from
##   [.ff     ff  
##   [.ffdf   ff  
##   [<-.ff   ff  
##   [<-.ffdf ff
## 
## Attaching package: 'PatientLevelPrediction'
## The following object is masked from 'package:FeatureExtraction':
## 
##     bySumFf
cohorts<-Eunomia:::createCohorts(connectionDetails)
## Connecting using SQLite driver
## Creating cohort: Celecoxib
## 
  |                                                                       
  |                                                                 |   0%
  |                                                                       
  |=================================================================| 100%
## Executing SQL took 0.015 secs
## Creating cohort: Diclofenac
## 
  |                                                                       
  |                                                                 |   0%
  |                                                                       
  |=================================================================| 100%
## Executing SQL took 0.021 secs
## Creating cohort: GiBleed
## 
  |                                                                       
  |                                                                 |   0%
  |                                                                       
  |=================================================================| 100%
## Executing SQL took 0.028 secs
## Creating cohort: NSAIDs
## 
  |                                                                       
  |                                                                 |   0%
  |                                                                       
  |=================================================================| 100%
## Executing SQL took 0.126 secs
## Cohorts created in table main.cohort
covSettings <- createCovariateSettings(
  useDemographicsGender = TRUE,
  useDemographicsAge = TRUE,
  useConditionGroupEraLongTerm = TRUE,
  useConditionGroupEraAnyTimePrior = TRUE,
  useDrugGroupEraLongTerm = TRUE,
  useDrugGroupEraAnyTimePrior = TRUE,
  useVisitConceptCountLongTerm = TRUE,
  longTermStartDays = -365,
  endDays = -1)

plpData <- getPlpData(connectionDetails = connectionDetails,
                      cdmDatabaseSchema = "main",
                      cohortDatabaseSchema = "main",
                      cohortTable = "cohort",
                      cohortId = 4,
                      covariateSettings = covSettings,
                      outcomeDatabaseSchema = "main",
                      outcomeTable = "cohort",
                      outcomeIds = 3)
## Connecting using SQLite driver
## 
## Constructing the at risk cohort
## 
  |                                                                       
  |                                                                 |   0%
  |                                                                       
  |======================                                           |  33%
  |                                                                       
  |===========================================                      |  67%
  |                                                                       
  |=================================================================| 100%
## Executing SQL took 0.016 secs
## Fetching cohorts from server
## Loading cohorts took 0.057 secs
## Constructing features on server
## 
  |                                                                       
  |                                                                 |   0%
  |                                                                       
  |=                                                                |   2%
  |                                                                       
  |==                                                               |   4%
  |                                                                       
  |====                                                             |   6%
  |                                                                       
  |=====                                                            |   8%
  |                                                                       
  |======                                                           |  10%
  |                                                                       
  |========                                                         |  12%
  |                                                                       
  |=========                                                        |  13%
  |                                                                       
  |==========                                                       |  15%
  |                                                                       
  |===========                                                      |  17%
  |                                                                       
  |============                                                     |  19%
  |                                                                       
  |==============                                                   |  21%
  |                                                                       
  |===============                                                  |  23%
  |                                                                       
  |================                                                 |  25%
  |                                                                       
  |==================                                               |  27%
  |                                                                       
  |===================                                              |  29%
  |                                                                       
  |====================                                             |  31%
  |                                                                       
  |=====================                                            |  33%
  |                                                                       
  |======================                                           |  35%
  |                                                                       
  |========================                                         |  37%
  |                                                                       
  |=========================                                        |  38%
  |                                                                       
  |==========================                                       |  40%
  |                                                                       
  |============================                                     |  42%
  |                                                                       
  |=============================                                    |  44%
  |                                                                       
  |==============================                                   |  46%
  |                                                                       
  |===============================                                  |  48%
  |                                                                       
  |================================                                 |  50%
  |                                                                       
  |==================================                               |  52%
  |                                                                       
  |===================================                              |  54%
  |                                                                       
  |====================================                             |  56%
  |                                                                       
  |======================================                           |  58%
  |                                                                       
  |=======================================                          |  60%
  |                                                                       
  |========================================                         |  62%
  |                                                                       
  |=========================================                        |  63%
  |                                                                       
  |==========================================                       |  65%
  |                                                                       
  |============================================                     |  67%
  |                                                                       
  |=============================================                    |  69%
  |                                                                       
  |==============================================                   |  71%
  |                                                                       
  |================================================                 |  73%
  |                                                                       
  |=================================================                |  75%
  |                                                                       
  |==================================================               |  77%
  |                                                                       
  |===================================================              |  79%
  |                                                                       
  |====================================================             |  81%
  |                                                                       
  |======================================================           |  83%
  |                                                                       
  |=======================================================          |  85%
  |                                                                       
  |========================================================         |  87%
  |                                                                       
  |==========================================================       |  88%
  |                                                                       
  |===========================================================      |  90%
  |                                                                       
  |============================================================     |  92%
  |                                                                       
  |=============================================================    |  94%
  |                                                                       
  |==============================================================   |  96%
  |                                                                       
  |================================================================ |  98%
  |                                                                       
  |=================================================================| 100%
## Executing SQL took 1.89 secs
## Fetching data from server
## Fetching data took 0.375 secs
## Fetching outcomes from server
## Loading outcomes took 0.064 secs
summary(plpData)
## plpData object summary
## 
## At risk cohort concept ID: -1
## Outcome concept ID(s): 3
## 
## People: 2630
## 
## Outcome counts:
##   Event count Person count
## 3         479          479
## 
## Covariates:
## Number of covariates: 245
## Number of non-zero covariate values: 54079
#str(plpData)
#feature extraction does analyses. OVerview of them is here
aref<-as.data.frame(plpData$analysisRef )
knitr::kable(aref)
analysisId analysisName domainId startDay endDay isBinary missingMeansZero
210 ConditionGroupEraLongTerm Condition -365 -1 Y NA
1 DemographicsGender Demographics NA NA Y NA
923 VisitConceptCountLongTerm Visit NA NA N Y
2 DemographicsAge Demographics NA NA N Y
409 DrugGroupEraAnyTimePrior Drug NA -1 Y NA
410 DrugGroupEraLongTerm Drug -365 -1 Y NA
209 ConditionGroupEraAnyTimePrior Condition NA -1 Y NA
population <- createStudyPopulation(plpData = plpData,
                                    outcomeId = 3,
                                    washoutPeriod = 364,
                                    firstExposureOnly = FALSE,
                                    removeSubjectsWithPriorOutcome = TRUE,
                                    priorOutcomeLookback = 9999,
                                    riskWindowStart = 1,
                                    riskWindowEnd = 365,
                                    addExposureDaysToStart = FALSE,
                                    addExposureDaysToEnd = FALSE,
                                    minTimeAtRisk = 364,
                                    requireTimeAtRisk = TRUE,
                                    includeAllOutcomes = TRUE)
## 2019-11-15 09:17:39  Outcome is 0 or 1
nrow(population)
## [1] 2578
lassoModel <- setLassoLogisticRegression(seed = 0)

lassoResults <- runPlp(population = population, 
                       plpData = plpData, 
                       modelSettings = lassoModel, 
                       testSplit = 'person',
                       testFraction = 0.25, 
                       nfold = 2, 
                       splitSeed = 0)
## 2019-11-15 09:17:39  Patient-Level Prediction Package version 3.0.8
## 2019-11-15 09:17:39  AnalysisID:         20191115091739
## 2019-11-15 09:17:39  CohortID:           4
## 2019-11-15 09:17:39  OutcomeID:          3
## 2019-11-15 09:17:39  Cohort size:        2630
## 2019-11-15 09:17:39  Covariates:         245
## 2019-11-15 09:17:39  Population size:    2578
## 2019-11-15 09:17:39  Cases:              479
## 2019-11-15 09:17:39  Saving plpData to   O:/r/sandohdsi/20191115091739/plpData
## Warning: 'personSplitter' is deprecated.
## Use 'randomSplitter' instead.
## See help("Deprecated")
## 2019-11-15 09:17:40  Creating a 25% test and 75% train (into 2 folds) random stratified split by class
## 2019-11-15 09:17:40  Data split into 645 test cases and 1933 train cases (967, 966)
## 2019-11-15 09:17:40  Training Lasso Logistic Regression model
## Removing redundant covariates
## Removing redundant covariates took 0.02 secs
## Removing infrequent covariates
## Removing infrequent covariates took 0.13 secs
## Normalizing covariates
## Normalizing covariates took 0.266 secs
## 2019-11-15 09:17:41  Running Cyclops
## 2019-11-15 09:17:42  Done.
## 2019-11-15 09:17:42  GLM fit status:  OK
## 2019-11-15 09:17:42  Fitting model took 0.638 secs
## 2019-11-15 09:17:42  Creating variable importance data frame
## 2019-11-15 09:17:42  Getting predictions on train set
## 2019-11-15 09:17:42  Prediction took 0.112 secs
## Removing infrequent covariates
## Removing infrequent covariates took 0.078 secs
## Normalizing covariates
## Normalizing covariates took 0.109 secs
## Removing redundant covariates
## Removing redundant covariates took 0.301 secs
## 2019-11-15 09:17:43  Prediction took 0.108 secs
## 2019-11-15 09:17:43  Train set evaluation
## 2019-11-15 09:17:43  AUC:                71.12
## 2019-11-15 09:17:43  95% lower AUC:      68.15
## 2019-11-15 09:17:43  95% upper AUC:      74.09
## 2019-11-15 09:17:43  AUPRC:              36.15
## 2019-11-15 09:17:43  Brier:              0.14
## 2019-11-15 09:17:44  Calibration gradient: 1.14 intercept:         -0.03
## 2019-11-15 09:17:44  Average Precision:  0.36
## 2019-11-15 09:17:44  Test set evaluation
## 2019-11-15 09:17:44  AUC:                64.45
## 2019-11-15 09:17:44  95% lower AUC:      58.90
## 2019-11-15 09:17:44  95% upper AUC:      70.01
## 2019-11-15 09:17:44  AUPRC:              28.63
## 2019-11-15 09:17:44  Brier:              0.14
## 2019-11-15 09:17:45  Calibration gradient: 0.79 intercept:         0.04
## 2019-11-15 09:17:45  Average Precision:  0.29
## 2019-11-15 09:17:45  Calculating covariate summary @ 2019-11-15 09:17:45
## 2019-11-15 09:17:45  This can take a while...
## 2019-11-15 09:17:46  Finished covariate summary @ 2019-11-15 09:17:46
## Warning: Removed 4 rows containing missing values (geom_point).

## 2019-11-15 09:17:52  Saving PlpResult
## 2019-11-15 09:17:52  plpResult saved to ..\O:/r/sandohdsi/20191115091739\plpResult
## 2019-11-15 09:17:52  Log saved to O:/r/sandohdsi/20191115091739/plplog.txt
## 2019-11-15 09:17:52  Run finished successfully.
#viewPlp(lassoResults)

#look at data manually
#str(lassoResults)
names(lassoResults)
## [1] "inputSetting"          "executionSummary"      "model"                
## [4] "prediction"            "performanceEvaluation" "covariateSummary"     
## [7] "analysisRef"
#lassoResults$analysisRef
knitr::kable(lassoResults$covariateSummary)
covariateId analysisId conceptId covariateValue covariateName CovariateCount CovariateCountWithOutcome CovariateMeanWithOutcome CovariateStDevWithOutcome CovariateCountWithNoOutcome CovariateMeanWithNoOutcome CovariateStDevWithNoOutcome TrainCovariateCount TrainCovariateCountWithOutcome TrainCovariateMeanWithOutcome TrainCovariateStDevWithOutcome TrainCovariateCountWithNoOutcome TrainCovariateMeanWithNoOutcome TrainCovariateStDevWithNoOutcome TestCovariateCount TestCovariateCountWithOutcome TestCovariateMeanWithOutcome TestCovariateStDevWithOutcome TestCovariateCountWithNoOutcome TestCovariateMeanWithNoOutcome TestCovariateStDevWithNoOutcome
1002 2 0 0.0000000 age in years 2578 479 38.7995825 3.3042257 2099 38.5712244 3.3074217 1933 359 38.7604457 3.2782499 1574 38.5902160 3.2964071 645 120 38.9166667 3.3919909 525 38.5142857 3.3427439
8507001 1 8507 0.0000000 gender = Unknown concept 1262 237 0.4947808 0.5004955 1025 0.4883278 0.4999829 947 176 0.4902507 0.5006026 771 0.4898348 0.5000555 315 61 0.5083333 0.5020267 254 0.4838095 0.5002144
8532001 1 8532 0.0000000 gender = Unknown concept 1316 242 0.5052192 0.5004955 1074 0.5116722 0.4999829 986 183 0.5097493 0.5006026 803 0.5101652 0.5000555 330 59 0.4916667 0.5020267 271 0.5161905 0.5002144
9201923 923 0 0.0000000 visit_occurrence concept count during day -365 through -1 concept_count relative to index: Inpatient Visit 4 0 0.0000000 0.0000000 4 0.0019057 0.0436228 4 0 0.0000000 0.0000000 4 0.0025413 0.0503632 NA NA NA NA NA NA NA
28060209 209 28060 0.0000000 condition_era group any time prior through -1 days relative to index: Streptococcal sore throat 1367 265 0.5532359 0.4976776 1102 0.5250119 0.4994930 1020 199 0.5543175 0.4977346 821 0.5216010 0.4996919 347 66 0.5500000 0.4995797 281 0.5352381 0.4992324
28060210 210 28060 0.0000000 condition_era group during day -365 through -1 days relative to index: Streptococcal sore throat 22 7 0.0146138 0.1201264 15 0.0071463 0.0842530 21 7 0.0194986 0.1384623 14 0.0088945 0.0939203 1 0 0.0000000 0.0000000 1 0.0019048 0.0436436
30753209 209 30753 0.1290896 condition_era group any time prior through -1 days relative to index: Esophagitis 397 134 0.2797495 0.4493453 263 0.1252978 0.3311351 289 110 0.3064067 0.4616441 179 0.1137230 0.3175754 108 24 0.2000000 0.4016772 84 0.1600000 0.3669557
30753210 210 30753 0.0000000 condition_era group during day -365 through -1 days relative to index: Esophagitis 216 66 0.1377871 0.3450367 150 0.0714626 0.2576574 153 52 0.1448468 0.3524375 101 0.0641677 0.2451294 63 14 0.1166667 0.3223687 49 0.0933333 0.2911764
78272209 209 78272 0.1126913 condition_era group any time prior through -1 days relative to index: Sprain of wrist 502 105 0.2192067 0.4141415 397 0.1891377 0.3917113 380 84 0.2339833 0.4239526 296 0.1880559 0.3908810 122 21 0.1750000 0.3815603 101 0.1923810 0.3945466
78272210 210 78272 0.0000000 condition_era group during day -365 through -1 days relative to index: Sprain of wrist 14 4 0.0083507 0.0910951 10 0.0047642 0.0688748 14 4 0.0111421 0.1051128 10 0.0063532 0.0794789 NA NA NA NA NA NA NA
80809209 209 80809 0.0000000 condition_era group any time prior through -1 days relative to index: Rheumatoid arthritis 6 2 0.0041754 0.0645494 4 0.0019057 0.0436228 4 1 0.0027855 0.0527780 3 0.0019060 0.0436297 2 1 0.0083333 0.0912871 1 0.0019048 0.0436436
80809210 NA NA 0.0000000 condition_era group during day -365 through -1 days relative to index: Rheumatoid arthritis 1 0 0.0000000 0.0000000 1 0.0004764 0.0218270 NA NA NA NA NA NA NA 1 0 0.0000000 0.0000000 1 0.0019048 0.0436436
81151209 209 81151 -0.0107679 condition_era group any time prior through -1 days relative to index: Sprain of ankle 1033 180 0.3757829 0.4848307 853 0.4063840 0.4912749 777 134 0.3732591 0.4843451 643 0.4085133 0.4917152 256 46 0.3833333 0.4882370 210 0.4000000 0.4903652
81151210 210 81151 0.0000000 condition_era group during day -365 through -1 days relative to index: Sprain of ankle 26 6 0.0125261 0.1113331 20 0.0095283 0.0971702 20 5 0.0139276 0.1173540 15 0.0095299 0.0971856 6 1 0.0083333 0.0912871 5 0.0095238 0.0972168
81893209 209 81893 0.0000000 condition_era group any time prior through -1 days relative to index: Ulcerative colitis 402 130 0.2713987 0.4451462 272 0.1295855 0.3359269 299 99 0.2757660 0.4475232 200 0.1270648 0.3331514 103 31 0.2583333 0.4395535 72 0.1371429 0.3443262
81893210 210 81893 0.0000000 condition_era group during day -365 through -1 days relative to index: Ulcerative colitis 65 20 0.0417537 0.2002348 45 0.0214388 0.1448764 53 17 0.0473538 0.2126908 36 0.0228717 0.1495418 12 3 0.0250000 0.1567796 9 0.0171429 0.1299274
133834209 209 133834 0.0000000 condition_era group any time prior through -1 days relative to index: Atopic dermatitis 50 5 0.0104384 0.1017402 45 0.0214388 0.1448764 34 3 0.0083565 0.0911584 31 0.0196950 0.1389943 16 2 0.0166667 0.1285559 14 0.0266667 0.1612609
134438209 209 134438 0.0000000 condition_era group any time prior through -1 days relative to index: Contact dermatitis 107 15 0.0313152 0.1743504 92 0.0438304 0.2047664 74 12 0.0334262 0.1799976 62 0.0393901 0.1945831 33 3 0.0250000 0.1567796 30 0.0571429 0.2323368
134438210 210 134438 0.0000000 condition_era group during day -365 through -1 days relative to index: Contact dermatitis 3 1 0.0020877 0.0456912 2 0.0009528 0.0308607 2 0 0.0000000 0.0000000 2 0.0012706 0.0356348 1 1 0.0083333 0.0912871 0 0.0000000 0.0000000
195588209 209 195588 0.0000000 condition_era group any time prior through -1 days relative to index: Cystitis 169 38 0.0793319 0.2705387 131 0.0624107 0.2419576 127 31 0.0863510 0.2812736 96 0.0609911 0.2393901 42 7 0.0583333 0.2353554 35 0.0666667 0.2496817
195588210 210 195588 0.0000000 condition_era group during day -365 through -1 days relative to index: Cystitis 13 3 0.0062630 0.0789737 10 0.0047642 0.0688748 9 2 0.0055710 0.0745350 7 0.0044473 0.0665605 4 1 0.0083333 0.0912871 3 0.0057143 0.0754485
196456209 209 196456 0.0000000 condition_era group any time prior through -1 days relative to index: Gallstone 24 5 0.0104384 0.1017402 19 0.0090519 0.0947326 20 5 0.0139276 0.1173540 15 0.0095299 0.0971856 4 0 0.0000000 0.0000000 4 0.0076190 0.0870369
196456210 NA NA 0.0000000 condition_era group during day -365 through -1 days relative to index: Gallstone 1 0 0.0000000 0.0000000 1 0.0004764 0.0218270 1 0 0.0000000 0.0000000 1 0.0006353 0.0252056 NA NA NA NA NA NA NA
198199209 209 198199 0.0000000 condition_era group any time prior through -1 days relative to index: Pyelonephritis 4 2 0.0041754 0.0645494 2 0.0009528 0.0308607 3 2 0.0055710 0.0745350 1 0.0006353 0.0252056 1 0 0.0000000 0.0000000 1 0.0019048 0.0436436
198199210 NA NA 0.0000000 condition_era group during day -365 through -1 days relative to index: Pyelonephritis 1 1 0.0020877 0.0456912 0 0.0000000 0.0000000 1 1 0.0027855 0.0527780 0 0.0000000 0.0000000 NA NA NA NA NA NA NA
198809209 209 198809 0.0000000 condition_era group any time prior through -1 days relative to index: Acute cholecystitis 24 5 0.0104384 0.1017402 19 0.0090519 0.0947326 20 5 0.0139276 0.1173540 15 0.0095299 0.0971856 4 0 0.0000000 0.0000000 4 0.0076190 0.0870369
198809210 NA NA 0.0000000 condition_era group during day -365 through -1 days relative to index: Acute cholecystitis 1 0 0.0000000 0.0000000 1 0.0004764 0.0218270 1 0 0.0000000 0.0000000 1 0.0006353 0.0252056 NA NA NA NA NA NA NA
257012209 209 257012 0.0000000 condition_era group any time prior through -1 days relative to index: Chronic sinusitis 540 101 0.2108559 0.4083428 439 0.2091472 0.4067966 415 76 0.2116992 0.4090829 339 0.2153748 0.4112128 125 25 0.2083333 0.4078192 100 0.1904762 0.3930512
257012210 210 257012 0.0000000 condition_era group during day -365 through -1 days relative to index: Chronic sinusitis 23 2 0.0041754 0.0645494 21 0.0100048 0.0995459 18 2 0.0055710 0.0745350 16 0.0101652 0.1003407 5 0 0.0000000 0.0000000 5 0.0095238 0.0972168
258780209 209 258780 0.0000000 condition_era group any time prior through -1 days relative to index: Emphysematous bronchitis 22 3 0.0062630 0.0789737 19 0.0090519 0.0947326 16 2 0.0055710 0.0745350 14 0.0088945 0.0939203 6 1 0.0083333 0.0912871 5 0.0095238 0.0972168
258780210 NA NA 0.0000000 condition_era group during day -365 through -1 days relative to index: Emphysematous bronchitis 1 1 0.0020877 0.0456912 0 0.0000000 0.0000000 1 1 0.0027855 0.0527780 0 0.0000000 0.0000000 NA NA NA NA NA NA NA
260139209 209 260139 0.0000000 condition_era group any time prior through -1 days relative to index: Acute bronchitis 2248 411 0.8580376 0.3493765 1837 0.8751787 0.3305950 1689 308 0.8579387 0.3496002 1381 0.8773825 0.3281019 559 103 0.8583333 0.3501700 456 0.8685714 0.3381907
260139210 210 260139 0.0000000 condition_era group during day -365 through -1 days relative to index: Acute bronchitis 122 17 0.0354906 0.1852097 105 0.0500238 0.2180461 86 11 0.0306407 0.1725827 75 0.0476493 0.2130908 36 6 0.0500000 0.2188588 30 0.0571429 0.2323368
261325209 209 261325 0.0000000 condition_era group any time prior through -1 days relative to index: Pulmonary emphysema 33 9 0.0187891 0.1359216 24 0.0114340 0.1063422 26 7 0.0194986 0.1384623 19 0.0120712 0.1092384 7 2 0.0166667 0.1285559 5 0.0095238 0.0972168
261325210 NA NA 0.0000000 condition_era group during day -365 through -1 days relative to index: Pulmonary emphysema 1 0 0.0000000 0.0000000 1 0.0004764 0.0218270 1 0 0.0000000 0.0000000 1 0.0006353 0.0252056 NA NA NA NA NA NA NA
317009209 209 317009 0.0000000 condition_era group any time prior through -1 days relative to index: Asthma 93 13 0.0271399 0.1626608 80 0.0381134 0.1915156 66 11 0.0306407 0.1725827 55 0.0349428 0.1836934 27 2 0.0166667 0.1285559 25 0.0476190 0.2131620
317576209 209 317576 0.0000000 condition_era group any time prior through -1 days relative to index: Coronary arteriosclerosis 55 10 0.0208768 0.1431214 45 0.0214388 0.1448764 44 8 0.0222841 0.1478120 36 0.0228717 0.1495418 11 2 0.0166667 0.1285559 9 0.0171429 0.1299274
317576210 210 317576 0.0000000 condition_era group during day -365 through -1 days relative to index: Coronary arteriosclerosis 4 0 0.0000000 0.0000000 4 0.0019057 0.0436228 3 0 0.0000000 0.0000000 3 0.0019060 0.0436297 1 0 0.0000000 0.0000000 1 0.0019048 0.0436436
321042209 209 321042 0.0000000 condition_era group any time prior through -1 days relative to index: Cardiac arrest 66 11 0.0229645 0.1499469 55 0.0262030 0.1597765 51 11 0.0306407 0.1725827 40 0.0254130 0.1574258 15 0 0.0000000 0.0000000 15 0.0285714 0.1667575
321042210 210 321042 0.0000000 condition_era group during day -365 through -1 days relative to index: Cardiac arrest 2 0 0.0000000 0.0000000 2 0.0009528 0.0308607 2 0 0.0000000 0.0000000 2 0.0012706 0.0356348 NA NA NA NA NA NA NA
372328209 209 372328 0.0000000 condition_era group any time prior through -1 days relative to index: Otitis media 1897 342 0.7139875 0.4523677 1555 0.7408290 0.4382841 1429 257 0.7158774 0.4516249 1172 0.7445997 0.4362246 468 85 0.7083333 0.4564355 383 0.7295238 0.4446295
372328210 210 372328 0.0000000 condition_era group during day -365 through -1 days relative to index: Otitis media 12 1 0.0020877 0.0456912 11 0.0052406 0.0722192 7 0 0.0000000 0.0000000 7 0.0044473 0.0665605 5 1 0.0083333 0.0912871 4 0.0076190 0.0870369
375671209 209 375671 0.0000000 condition_era group any time prior through -1 days relative to index: Concussion with loss of consciousness 166 37 0.0772443 0.2672577 129 0.0614578 0.2402254 116 27 0.0752089 0.2640962 89 0.0565438 0.2310423 50 10 0.0833333 0.2775443 40 0.0761905 0.2655557
375671210 210 375671 0.0000000 condition_era group during day -365 through -1 days relative to index: Concussion with loss of consciousness 6 0 0.0000000 0.0000000 6 0.0028585 0.0534012 5 0 0.0000000 0.0000000 5 0.0031766 0.0562898 1 0 0.0000000 0.0000000 1 0.0019048 0.0436436
378001209 209 378001 -0.0280880 condition_era group any time prior through -1 days relative to index: Concussion with no loss of consciousness 617 103 0.2150313 0.4112736 514 0.2448785 0.4301176 482 82 0.2284123 0.4203955 400 0.2541296 0.4355092 135 21 0.1750000 0.3815603 114 0.2171429 0.4126939
378001210 210 378001 0.0000000 condition_era group during day -365 through -1 days relative to index: Concussion with no loss of consciousness 20 3 0.0062630 0.0789737 17 0.0080991 0.0896511 13 1 0.0027855 0.0527780 12 0.0076239 0.0870090 7 2 0.0166667 0.1285559 5 0.0095238 0.0972168
380378209 209 380378 0.0000000 condition_era group any time prior through -1 days relative to index: Epilepsy 23 3 0.0062630 0.0789737 20 0.0095283 0.0971702 17 3 0.0083565 0.0911584 14 0.0088945 0.0939203 6 0 0.0000000 0.0000000 6 0.0114286 0.1063932
381316209 209 381316 0.0000000 condition_era group any time prior through -1 days relative to index: Cerebrovascular accident 21 9 0.0187891 0.1359216 12 0.0057170 0.0754124 12 5 0.0139276 0.1173540 7 0.0044473 0.0665605 9 4 0.0333333 0.1802581 5 0.0095238 0.0972168
381316210 210 381316 0.0000000 condition_era group during day -365 through -1 days relative to index: Cerebrovascular accident 3 1 0.0020877 0.0456912 2 0.0009528 0.0308607 3 1 0.0027855 0.0527780 2 0.0012706 0.0356348 NA NA NA NA NA NA NA
439777209 209 439777 0.0000000 condition_era group any time prior through -1 days relative to index: Anemia 59 15 0.0313152 0.1743504 44 0.0209624 0.1432924 40 9 0.0250696 0.1565549 31 0.0196950 0.1389943 19 6 0.0500000 0.2188588 13 0.0247619 0.1555469
439777210 210 439777 0.0000000 condition_era group during day -365 through -1 days relative to index: Anemia 5 2 0.0041754 0.0645494 3 0.0014293 0.0377874 3 1 0.0027855 0.0527780 2 0.0012706 0.0356348 2 1 0.0083333 0.0912871 1 0.0019048 0.0436436
440086209 209 440086 0.0000000 condition_era group any time prior through -1 days relative to index: Child attention deficit disorder 241 48 0.1002088 0.3005921 193 0.0919485 0.2890222 190 39 0.1086351 0.3116151 151 0.0959339 0.2945942 51 9 0.0750000 0.2644957 42 0.0800000 0.2715519
440448209 209 440448 0.0000000 condition_era group any time prior through -1 days relative to index: Appendicitis 116 23 0.0480167 0.2140251 93 0.0443068 0.2058249 83 12 0.0334262 0.1799976 71 0.0451080 0.2076070 33 11 0.0916667 0.2897647 22 0.0419048 0.2005626
705944409 409 705944 0.0000000 drug_era group any time prior through -1 days relative to index: Methylphenidate 62 12 0.0250522 0.1564470 50 0.0238209 0.1525271 52 9 0.0250696 0.1565549 43 0.0273189 0.1630629 10 3 0.0250000 0.1567796 7 0.0133333 0.1148071
708298409 409 708298 0.0000000 drug_era group any time prior through -1 days relative to index: Midazolam 23 5 0.0104384 0.1017402 18 0.0085755 0.0922281 20 5 0.0139276 0.1173540 15 0.0095299 0.0971856 3 0 0.0000000 0.0000000 3 0.0057143 0.0754485
708298410 NA NA 0.0000000 drug_era group during day -365 through -1 days relative to index: Midazolam 1 0 0.0000000 0.0000000 1 0.0004764 0.0218270 1 0 0.0000000 0.0000000 1 0.0006353 0.0252056 NA NA NA NA NA NA NA
723013409 409 723013 0.0000000 drug_era group any time prior through -1 days relative to index: Diazepam 49 6 0.0125261 0.1113331 43 0.0204859 0.1416892 38 6 0.0167131 0.1283732 32 0.0203304 0.1411726 11 0 0.0000000 0.0000000 11 0.0209524 0.1433615
723013410 NA NA 0.0000000 drug_era group during day -365 through -1 days relative to index: Diazepam 1 0 0.0000000 0.0000000 1 0.0004764 0.0218270 1 0 0.0000000 0.0000000 1 0.0006353 0.0252056 NA NA NA NA NA NA NA
738818409 409 738818 0.0000000 drug_era group any time prior through -1 days relative to index: Doxylamine 998 182 0.3799582 0.4858836 816 0.3887566 0.4875840 758 141 0.3927577 0.4890453 617 0.3919949 0.4883507 240 41 0.3416667 0.4762570 199 0.3790476 0.4856127
738818410 410 738818 0.0000000 drug_era group during day -365 through -1 days relative to index: Doxylamine 23 5 0.0104384 0.1017402 18 0.0085755 0.0922281 14 3 0.0083565 0.0911584 11 0.0069886 0.0833315 9 2 0.0166667 0.1285559 7 0.0133333 0.1148071
740275409 409 740275 0.0000000 drug_era group any time prior through -1 days relative to index: Carbamazepine 39 8 0.0167015 0.1282844 31 0.0147689 0.1206555 31 8 0.0222841 0.1478120 23 0.0146125 0.1200337 8 0 0.0000000 0.0000000 8 0.0152381 0.1226154
740275410 410 740275 0.0000000 drug_era group during day -365 through -1 days relative to index: Carbamazepine 2 1 0.0020877 0.0456912 1 0.0004764 0.0218270 2 1 0.0027855 0.0527780 1 0.0006353 0.0252056 NA NA NA NA NA NA NA
753626409 409 753626 0.0000000 drug_era group any time prior through -1 days relative to index: Propofol 24 5 0.0104384 0.1017402 19 0.0090519 0.0947326 20 5 0.0139276 0.1173540 15 0.0095299 0.0971856 4 0 0.0000000 0.0000000 4 0.0076190 0.0870369
753626410 NA NA 0.0000000 drug_era group during day -365 through -1 days relative to index: Propofol 1 0 0.0000000 0.0000000 1 0.0004764 0.0218270 1 0 0.0000000 0.0000000 1 0.0006353 0.0252056 NA NA NA NA NA NA NA
782043409 409 782043 0.0000000 drug_era group any time prior through -1 days relative to index: Isoflurane 17 4 0.0083507 0.0910951 13 0.0061934 0.0784729 14 4 0.0111421 0.1051128 10 0.0063532 0.0794789 3 0 0.0000000 0.0000000 3 0.0057143 0.0754485
782043410 NA NA 0.0000000 drug_era group during day -365 through -1 days relative to index: Isoflurane 1 0 0.0000000 0.0000000 1 0.0004764 0.0218270 1 0 0.0000000 0.0000000 1 0.0006353 0.0252056 NA NA NA NA NA NA NA
791967409 NA NA 0.0000000 drug_era group any time prior through -1 days relative to index: Lorazepam 1 0 0.0000000 0.0000000 1 0.0004764 0.0218270 NA NA NA NA NA NA NA 1 0 0.0000000 0.0000000 1 0.0019048 0.0436436
914335409 409 914335 0.0000000 drug_era group any time prior through -1 days relative to index: Atropine 66 11 0.0229645 0.1499469 55 0.0262030 0.1597765 51 11 0.0306407 0.1725827 40 0.0254130 0.1574258 15 0 0.0000000 0.0000000 15 0.0285714 0.1667575
914335410 410 914335 0.0000000 drug_era group during day -365 through -1 days relative to index: Atropine 2 0 0.0000000 0.0000000 2 0.0009528 0.0308607 2 0 0.0000000 0.0000000 2 0.0012706 0.0356348 NA NA NA NA NA NA NA
920293409 409 920293 0.0000000 drug_era group any time prior through -1 days relative to index: Nitrofurantoin 361 74 0.1544885 0.3617943 287 0.1367318 0.3436458 267 57 0.1587744 0.3659756 210 0.1334180 0.3401340 94 17 0.1416667 0.3501700 77 0.1466667 0.3541107
920293410 410 920293 0.0000000 drug_era group during day -365 through -1 days relative to index: Nitrofurantoin 21 7 0.0146138 0.1201264 14 0.0066698 0.0814157 17 6 0.0167131 0.1283732 11 0.0069886 0.0833315 4 1 0.0083333 0.0912871 3 0.0057143 0.0754485
933724409 409 933724 0.0000000 drug_era group any time prior through -1 days relative to index: Phenazopyridine 361 74 0.1544885 0.3617943 287 0.1367318 0.3436458 267 57 0.1587744 0.3659756 210 0.1334180 0.3401340 94 17 0.1416667 0.3501700 77 0.1466667 0.3541107
933724410 410 933724 0.0000000 drug_era group during day -365 through -1 days relative to index: Phenazopyridine 21 7 0.0146138 0.1201264 14 0.0066698 0.0814157 17 6 0.0167131 0.1283732 11 0.0069886 0.0833315 4 1 0.0083333 0.0912871 3 0.0057143 0.0754485
967823409 409 967823 0.0000000 drug_era group any time prior through -1 days relative to index: Sodium Chloride 24 5 0.0104384 0.1017402 19 0.0090519 0.0947326 20 5 0.0139276 0.1173540 15 0.0095299 0.0971856 4 0 0.0000000 0.0000000 4 0.0076190 0.0870369
967823410 NA NA 0.0000000 drug_era group during day -365 through -1 days relative to index: Sodium Chloride 1 0 0.0000000 0.0000000 1 0.0004764 0.0218270 1 0 0.0000000 0.0000000 1 0.0006353 0.0252056 NA NA NA NA NA NA NA
975125409 409 975125 0.0000000 drug_era group any time prior through -1 days relative to index: Hydrocortisone 98 11 0.0229645 0.1499469 87 0.0414483 0.1993722 69 6 0.0167131 0.1283732 63 0.0400254 0.1960811 29 5 0.0416667 0.2006642 24 0.0457143 0.2090640
975125410 410 975125 0.0000000 drug_era group during day -365 through -1 days relative to index: Hydrocortisone 3 1 0.0020877 0.0456912 2 0.0009528 0.0308607 2 0 0.0000000 0.0000000 2 0.0012706 0.0356348 1 1 0.0083333 0.0912871 0 0.0000000 0.0000000
1000560409 409 1000560 0.0000000 drug_era group any time prior through -1 days relative to index: Ondansetron 24 5 0.0104384 0.1017402 19 0.0090519 0.0947326 20 5 0.0139276 0.1173540 15 0.0095299 0.0971856 4 0 0.0000000 0.0000000 4 0.0076190 0.0870369
1000560410 NA NA 0.0000000 drug_era group during day -365 through -1 days relative to index: Ondansetron 1 0 0.0000000 0.0000000 1 0.0004764 0.0218270 1 0 0.0000000 0.0000000 1 0.0006353 0.0252056 NA NA NA NA NA NA NA
1102527409 409 1102527 0.0000000 drug_era group any time prior through -1 days relative to index: Meperidine 198 40 0.0835073 0.2769367 158 0.0752739 0.2638957 145 29 0.0807799 0.2728772 116 0.0736976 0.2613611 53 11 0.0916667 0.2897647 42 0.0800000 0.2715519
1102527410 410 1102527 0.0000000 drug_era group during day -365 through -1 days relative to index: Meperidine 11 0 0.0000000 0.0000000 11 0.0052406 0.0722192 10 0 0.0000000 0.0000000 10 0.0063532 0.0794789 1 0 0.0000000 0.0000000 1 0.0019048 0.0436436
1107830409 409 1107830 0.0000000 drug_era group any time prior through -1 days relative to index: Loratadine 8 1 0.0020877 0.0456912 7 0.0033349 0.0576661 4 0 0.0000000 0.0000000 4 0.0025413 0.0503632 4 1 0.0083333 0.0912871 3 0.0057143 0.0754485
1110410409 409 1110410 0.0000000 drug_era group any time prior through -1 days relative to index: Morphine 24 5 0.0104384 0.1017402 19 0.0090519 0.0947326 20 5 0.0139276 0.1173540 15 0.0095299 0.0971856 4 0 0.0000000 0.0000000 4 0.0076190 0.0870369
1110410410 NA NA 0.0000000 drug_era group during day -365 through -1 days relative to index: Morphine 1 0 0.0000000 0.0000000 1 0.0004764 0.0218270 1 0 0.0000000 0.0000000 1 0.0006353 0.0252056 NA NA NA NA NA NA NA
1112807409 409 1112807 -0.0382128 drug_era group any time prior through -1 days relative to index: Aspirin 1878 328 0.6847599 0.4650972 1550 0.7384469 0.4395852 1414 250 0.6963788 0.4604628 1164 0.7395172 0.4390376 464 78 0.6500000 0.4789695 386 0.7352381 0.4416271
1112807410 410 1112807 0.0000000 drug_era group during day -365 through -1 days relative to index: Aspirin 9 0 0.0000000 0.0000000 9 0.0042878 0.0653560 8 0 0.0000000 0.0000000 8 0.0050826 0.0711335 1 0 0.0000000 0.0000000 1 0.0019048 0.0436436
1115008409 409 1115008 0.0000000 drug_era group any time prior through -1 days relative to index: Naproxen 286 59 0.1231733 0.3289796 227 0.1081467 0.3106397 205 39 0.1086351 0.3116151 166 0.1054638 0.3072477 81 20 0.1666667 0.3742406 61 0.1161905 0.3207588
1115008410 410 1115008 0.0000000 drug_era group during day -365 through -1 days relative to index: Naproxen 27 4 0.0083507 0.0910951 23 0.0109576 0.1041283 22 3 0.0083565 0.0911584 19 0.0120712 0.1092384 5 1 0.0083333 0.0912871 4 0.0076190 0.0870369
1119510409 409 1119510 0.0000000 drug_era group any time prior through -1 days relative to index: Dextromethorphan 998 182 0.3799582 0.4858836 816 0.3887566 0.4875840 758 141 0.3927577 0.4890453 617 0.3919949 0.4883507 240 41 0.3416667 0.4762570 199 0.3790476 0.4856127
1119510410 410 1119510 0.0000000 drug_era group during day -365 through -1 days relative to index: Dextromethorphan 23 5 0.0104384 0.1017402 18 0.0085755 0.0922281 14 3 0.0083565 0.0911584 11 0.0069886 0.0833315 9 2 0.0166667 0.1285559 7 0.0133333 0.1148071
1124957409 409 1124957 0.0000000 drug_era group any time prior through -1 days relative to index: Oxycodone 193 38 0.0793319 0.2705387 155 0.0738447 0.2615803 142 32 0.0891365 0.2853383 110 0.0698856 0.2550352 51 6 0.0500000 0.2188588 45 0.0857143 0.2802087
1124957410 410 1124957 0.0000000 drug_era group during day -365 through -1 days relative to index: Oxycodone 5 0 0.0000000 0.0000000 5 0.0023821 0.0487601 3 0 0.0000000 0.0000000 3 0.0019060 0.0436297 2 0 0.0000000 0.0000000 2 0.0038095 0.0616624
1125315409 409 1125315 0.0000000 drug_era group any time prior through -1 days relative to index: Acetaminophen 2512 467 0.9749478 0.1564470 2045 0.9742735 0.1583560 1887 348 0.9693593 0.1725827 1539 0.9777637 0.1474982 625 119 0.9916667 0.0912871 506 0.9638095 0.1869419
1125315410 410 1125315 0.0000000 drug_era group during day -365 through -1 days relative to index: Acetaminophen 187 28 0.0584551 0.2348473 159 0.0757504 0.2646613 134 20 0.0557103 0.2296815 114 0.0724269 0.2592759 53 8 0.0666667 0.2504897 45 0.0857143 0.2802087
1129625409 409 1129625 0.0000000 drug_era group any time prior through -1 days relative to index: Diphenhydramine 102 16 0.0334029 0.1798742 86 0.0409719 0.1982723 72 13 0.0362117 0.1870773 59 0.0374841 0.1900052 30 3 0.0250000 0.1567796 27 0.0514286 0.2210809
1137529409 409 1137529 0.0000000 drug_era group any time prior through -1 days relative to index: salmeterol 45 11 0.0229645 0.1499469 34 0.0161982 0.1262672 33 8 0.0222841 0.1478120 25 0.0158831 0.1250630 12 3 0.0250000 0.1567796 9 0.0171429 0.1299274
1137529410 410 1137529 0.0000000 drug_era group during day -365 through -1 days relative to index: salmeterol 3 0 0.0000000 0.0000000 3 0.0014293 0.0377874 2 0 0.0000000 0.0000000 2 0.0012706 0.0356348 1 0 0.0000000 0.0000000 1 0.0019048 0.0436436
1149196409 409 1149196 0.0000000 drug_era group any time prior through -1 days relative to index: Cetirizine 3 1 0.0020877 0.0456912 2 0.0009528 0.0308607 3 1 0.0027855 0.0527780 2 0.0012706 0.0356348 NA NA NA NA NA NA NA
1149380409 409 1149380 0.0000000 drug_era group any time prior through -1 days relative to index: fluticasone 138 24 0.0501044 0.2183884 114 0.0543116 0.2266855 99 19 0.0529248 0.2241958 80 0.0508259 0.2197119 39 5 0.0416667 0.2006642 34 0.0647619 0.2463400
1149380410 410 1149380 0.0000000 drug_era group during day -365 through -1 days relative to index: fluticasone 3 0 0.0000000 0.0000000 3 0.0014293 0.0377874 2 0 0.0000000 0.0000000 2 0.0012706 0.0356348 1 0 0.0000000 0.0000000 1 0.0019048 0.0436436
1150770409 409 1150770 0.0000000 drug_era group any time prior through -1 days relative to index: Astemizole 21 2 0.0041754 0.0645494 19 0.0090519 0.0947326 13 0 0.0000000 0.0000000 13 0.0082592 0.0905329 8 2 0.0166667 0.1285559 6 0.0114286 0.1063932
1150770410 NA NA 0.0000000 drug_era group during day -365 through -1 days relative to index: Astemizole 1 1 0.0020877 0.0456912 0 0.0000000 0.0000000 NA NA NA NA NA NA NA 1 1 0.0083333 0.0912871 0 0.0000000 0.0000000
1150836409 409 1150836 0.0000000 drug_era group any time prior through -1 days relative to index: Terfenadine 7 1 0.0020877 0.0456912 6 0.0028585 0.0534012 6 1 0.0027855 0.0527780 5 0.0031766 0.0562898 1 0 0.0000000 0.0000000 1 0.0019048 0.0436436
1153428409 409 1153428 0.0000000 drug_era group any time prior through -1 days relative to index: fexofenadine 7 0 0.0000000 0.0000000 7 0.0033349 0.0576661 6 0 0.0000000 0.0000000 6 0.0038119 0.0616427 1 0 0.0000000 0.0000000 1 0.0019048 0.0436436
1154029409 409 1154029 0.0000000 drug_era group any time prior through -1 days relative to index: Fentanyl 4 1 0.0020877 0.0456912 3 0.0014293 0.0377874 3 1 0.0027855 0.0527780 2 0.0012706 0.0356348 1 0 0.0000000 0.0000000 1 0.0019048 0.0436436
1154029410 NA NA 0.0000000 drug_era group during day -365 through -1 days relative to index: Fentanyl 1 0 0.0000000 0.0000000 1 0.0004764 0.0218270 1 0 0.0000000 0.0000000 1 0.0006353 0.0252056 NA NA NA NA NA NA NA
1154343409 409 1154343 0.0000000 drug_era group any time prior through -1 days relative to index: Albuterol 93 13 0.0271399 0.1626608 80 0.0381134 0.1915156 66 11 0.0306407 0.1725827 55 0.0349428 0.1836934 27 2 0.0166667 0.1285559 25 0.0476190 0.2131620
1174888409 409 1174888 0.0000000 drug_era group any time prior through -1 days relative to index: Hydrocodone 175 26 0.0542797 0.2268058 149 0.0709862 0.2568630 138 21 0.0584958 0.2350062 117 0.0743329 0.2623953 37 5 0.0416667 0.2006642 32 0.0609524 0.2394711
1174888410 410 1174888 0.0000000 drug_era group during day -365 through -1 days relative to index: Hydrocodone 3 1 0.0020877 0.0456912 2 0.0009528 0.0308607 2 1 0.0027855 0.0527780 1 0.0006353 0.0252056 1 0 0.0000000 0.0000000 1 0.0019048 0.0436436
1177480409 409 1177480 0.0000000 drug_era group any time prior through -1 days relative to index: Ibuprofen 780 140 0.2922756 0.4552838 640 0.3049071 0.4604778 595 110 0.3064067 0.4616441 485 0.3081321 0.4618682 185 30 0.2500000 0.4348283 155 0.2952381 0.4565848
1177480410 410 1177480 0.0000000 drug_era group during day -365 through -1 days relative to index: Ibuprofen 35 7 0.0146138 0.1201264 28 0.0133397 0.1147520 24 4 0.0111421 0.1051128 20 0.0127065 0.1120402 11 3 0.0250000 0.1567796 8 0.0152381 0.1226154
1192710409 409 1192710 0.0000000 drug_era group any time prior through -1 days relative to index: Chlorpheniramine 67 12 0.0250522 0.1564470 55 0.0262030 0.1597765 53 9 0.0250696 0.1565549 44 0.0279543 0.1648942 14 3 0.0250000 0.1567796 11 0.0209524 0.1433615
1305058409 409 1305058 0.0000000 drug_era group any time prior through -1 days relative to index: Methotrexate 3 1 0.0020877 0.0456912 2 0.0009528 0.0308607 1 0 0.0000000 0.0000000 1 0.0006353 0.0252056 2 1 0.0083333 0.0912871 1 0.0019048 0.0436436
1305058410 NA NA 0.0000000 drug_era group during day -365 through -1 days relative to index: Methotrexate 1 0 0.0000000 0.0000000 1 0.0004764 0.0218270 NA NA NA NA NA NA NA 1 0 0.0000000 0.0000000 1 0.0019048 0.0436436
1308738409 409 1308738 0.0000000 drug_era group any time prior through -1 days relative to index: Vitamin B 12 10 1 0.0020877 0.0456912 9 0.0042878 0.0653560 6 0 0.0000000 0.0000000 6 0.0038119 0.0616427 4 1 0.0083333 0.0912871 3 0.0057143 0.0754485
1309944409 409 1309944 0.0000000 drug_era group any time prior through -1 days relative to index: Amiodarone 54 11 0.0229645 0.1499469 43 0.0204859 0.1416892 44 11 0.0306407 0.1725827 33 0.0209657 0.1433150 10 0 0.0000000 0.0000000 10 0.0190476 0.1368228
1309944410 410 1309944 0.0000000 drug_era group during day -365 through -1 days relative to index: Amiodarone 2 0 0.0000000 0.0000000 2 0.0009528 0.0308607 2 0 0.0000000 0.0000000 2 0.0012706 0.0356348 NA NA NA NA NA NA NA
1322184409 409 1322184 0.0000000 drug_era group any time prior through -1 days relative to index: clopidogrel 33 6 0.0125261 0.1113331 27 0.0128633 0.1127114 26 4 0.0111421 0.1051128 22 0.0139771 0.1174331 7 2 0.0166667 0.1285559 5 0.0095238 0.0972168
1322184410 410 1322184 0.0000000 drug_era group during day -365 through -1 days relative to index: clopidogrel 13 2 0.0041754 0.0645494 11 0.0052406 0.0722192 11 2 0.0055710 0.0745350 9 0.0057179 0.0754244 2 0 0.0000000 0.0000000 2 0.0038095 0.0616624
1332418409 409 1332418 0.0000000 drug_era group any time prior through -1 days relative to index: Amlodipine 29 6 0.0125261 0.1113331 23 0.0109576 0.1041283 25 5 0.0139276 0.1173540 20 0.0127065 0.1120402 4 1 0.0083333 0.0912871 3 0.0057143 0.0754485
1332418410 410 1332418 0.0000000 drug_era group during day -365 through -1 days relative to index: Amlodipine 5 1 0.0020877 0.0456912 4 0.0019057 0.0436228 4 1 0.0027855 0.0527780 3 0.0019060 0.0436297 1 0 0.0000000 0.0000000 1 0.0019048 0.0436436
1343916409 409 1343916 0.0000000 drug_era group any time prior through -1 days relative to index: Epinephrine 90 14 0.0292276 0.1686199 76 0.0362077 0.1868512 69 13 0.0362117 0.1870773 56 0.0355781 0.1852948 21 1 0.0083333 0.0912871 20 0.0380952 0.1916088
1343916410 410 1343916 0.0000000 drug_era group during day -365 through -1 days relative to index: Epinephrine 2 0 0.0000000 0.0000000 2 0.0009528 0.0308607 2 0 0.0000000 0.0000000 2 0.0012706 0.0356348 NA NA NA NA NA NA NA
1347450409 409 1347450 0.0000000 drug_era group any time prior through -1 days relative to index: alteplase 13 6 0.0125261 0.1113331 7 0.0033349 0.0576661 7 2 0.0055710 0.0745350 5 0.0031766 0.0562898 6 4 0.0333333 0.1802581 2 0.0038095 0.0616624
1347450410 410 1347450 0.0000000 drug_era group during day -365 through -1 days relative to index: alteplase 2 0 0.0000000 0.0000000 2 0.0009528 0.0308607 2 0 0.0000000 0.0000000 2 0.0012706 0.0356348 NA NA NA NA NA NA NA
1361711409 409 1361711 0.0000000 drug_era group any time prior through -1 days relative to index: Nitroglycerin 55 10 0.0208768 0.1431214 45 0.0214388 0.1448764 44 8 0.0222841 0.1478120 36 0.0228717 0.1495418 11 2 0.0166667 0.1285559 9 0.0171429 0.1299274
1361711410 410 1361711 0.0000000 drug_era group during day -365 through -1 days relative to index: Nitroglycerin 20 3 0.0062630 0.0789737 17 0.0080991 0.0896511 14 2 0.0055710 0.0745350 12 0.0076239 0.0870090 6 1 0.0083333 0.0912871 5 0.0095238 0.0972168
1367571409 409 1367571 0.0000000 drug_era group any time prior through -1 days relative to index: heparin 24 5 0.0104384 0.1017402 19 0.0090519 0.0947326 20 5 0.0139276 0.1173540 15 0.0095299 0.0971856 4 0 0.0000000 0.0000000 4 0.0076190 0.0870369
1367571410 NA NA 0.0000000 drug_era group during day -365 through -1 days relative to index: heparin 1 0 0.0000000 0.0000000 1 0.0004764 0.0218270 1 0 0.0000000 0.0000000 1 0.0006353 0.0252056 NA NA NA NA NA NA NA
1396131409 409 1396131 0.0000000 drug_era group any time prior through -1 days relative to index: ferrous sulfate 2 0 0.0000000 0.0000000 2 0.0009528 0.0308607 2 0 0.0000000 0.0000000 2 0.0012706 0.0356348 NA NA NA NA NA NA NA
1500211409 409 1500211 0.0000000 drug_era group any time prior through -1 days relative to index: Medroxyprogesterone 38 5 0.0104384 0.1017402 33 0.0157218 0.1244266 30 3 0.0083565 0.0911584 27 0.0171537 0.1298854 8 2 0.0166667 0.1285559 6 0.0114286 0.1063932
1503184409 409 1503184 0.0000000 drug_era group any time prior through -1 days relative to index: Mestranol 571 100 0.2087683 0.4068534 471 0.2243926 0.4172811 426 72 0.2005571 0.4009761 354 0.2249047 0.4176522 145 28 0.2333333 0.4247260 117 0.2228571 0.4165601
1512674409 409 1512674 0.0000000 drug_era group any time prior through -1 days relative to index: drospirenone 5 4 0.0083507 0.0910951 1 0.0004764 0.0218270 5 4 0.0111421 0.1051128 1 0.0006353 0.0252056 NA NA NA NA NA NA NA
1515774409 409 1515774 0.0000000 drug_era group any time prior through -1 days relative to index: norgestimate 227 39 0.0814196 0.2737644 188 0.0895665 0.2856277 171 29 0.0807799 0.2728772 142 0.0902160 0.2865820 56 10 0.0833333 0.2775443 46 0.0876190 0.2830097
1519936409 409 1519936 0.0000000 drug_era group any time prior through -1 days relative to index: Etonogestrel 2 0 0.0000000 0.0000000 2 0.0009528 0.0308607 1 0 0.0000000 0.0000000 1 0.0006353 0.0252056 1 0 0.0000000 0.0000000 1 0.0019048 0.0436436
1521369409 409 1521369 0.0000000 drug_era group any time prior through -1 days relative to index: Norethindrone 585 105 0.2192067 0.4141415 480 0.2286803 0.4200830 435 75 0.2089136 0.4071000 360 0.2287166 0.4201398 150 30 0.2500000 0.4348283 120 0.2285714 0.4203130
1521369410 NA NA 0.0000000 drug_era group during day -365 through -1 days relative to index: Norethindrone 1 0 0.0000000 0.0000000 1 0.0004764 0.0218270 1 0 0.0000000 0.0000000 1 0.0006353 0.0252056 NA NA NA NA NA NA NA
1539403409 409 1539403 0.0000000 drug_era group any time prior through -1 days relative to index: Simvastatin 37 7 0.0146138 0.1201264 30 0.0142925 0.1187222 30 6 0.0167131 0.1283732 24 0.0152478 0.1225758 7 1 0.0083333 0.0912871 6 0.0114286 0.1063932
1539403410 410 1539403 0.0000000 drug_era group during day -365 through -1 days relative to index: Simvastatin 5 1 0.0020877 0.0456912 4 0.0019057 0.0436228 4 1 0.0027855 0.0527780 3 0.0019060 0.0436297 1 0 0.0000000 0.0000000 1 0.0019048 0.0436436
1545958409 409 1545958 0.0000000 drug_era group any time prior through -1 days relative to index: atorvastatin 2 1 0.0020877 0.0456912 1 0.0004764 0.0218270 2 1 0.0027855 0.0527780 1 0.0006353 0.0252056 NA NA NA NA NA NA NA
1549786409 409 1549786 0.0000000 drug_era group any time prior through -1 days relative to index: Ethinyl Estradiol 236 42 0.0876827 0.2831285 194 0.0924250 0.2896939 178 31 0.0863510 0.2812736 147 0.0933926 0.2910743 58 11 0.0916667 0.2897647 47 0.0895238 0.2857706
1551099409 409 1551099 0.0000000 drug_era group any time prior through -1 days relative to index: Prednisone 110 16 0.0334029 0.1798742 94 0.0447832 0.2068770 84 13 0.0362117 0.1870773 71 0.0451080 0.2076070 26 3 0.0250000 0.1567796 23 0.0438095 0.2048663
1551099410 NA NA 0.0000000 drug_era group during day -365 through -1 days relative to index: Prednisone 1 0 0.0000000 0.0000000 1 0.0004764 0.0218270 1 0 0.0000000 0.0000000 1 0.0006353 0.0252056 NA NA NA NA NA NA NA
1589505409 409 1589505 0.0000000 drug_era group any time prior through -1 days relative to index: Levonorgestrel 28 7 0.0146138 0.1201264 21 0.0100048 0.0995459 18 4 0.0111421 0.1051128 14 0.0088945 0.0939203 10 3 0.0250000 0.1567796 7 0.0133333 0.1148071
1595799409 409 1595799 0.0000000 drug_era group any time prior through -1 days relative to index: Ferrous fumarate 43 15 0.0313152 0.1743504 28 0.0133397 0.1147520 31 11 0.0306407 0.1725827 20 0.0127065 0.1120402 12 4 0.0333333 0.1802581 8 0.0152381 0.1226154
1713332409 409 1713332 0.0000000 drug_era group any time prior through -1 days relative to index: Amoxicillin 1673 308 0.6430063 0.4796138 1365 0.6503097 0.4769857 1240 229 0.6378830 0.4812832 1011 0.6423126 0.4794718 433 79 0.6583333 0.4762570 354 0.6742857 0.4690881
1713332410 410 1713332 0.0000000 drug_era group during day -365 through -1 days relative to index: Amoxicillin 66 13 0.0271399 0.1626608 53 0.0252501 0.1569213 48 11 0.0306407 0.1725827 37 0.0235070 0.1515553 18 2 0.0166667 0.1285559 16 0.0304762 0.1720575
1717327409 409 1717327 -0.0484324 drug_era group any time prior through -1 days relative to index: Ampicillin 419 74 0.1544885 0.3617943 345 0.1643640 0.3706938 328 53 0.1476323 0.3552302 275 0.1747141 0.3798431 91 21 0.1750000 0.3815603 70 0.1333333 0.3402588
1728416409 409 1728416 -0.2160582 drug_era group any time prior through -1 days relative to index: Penicillin G 823 127 0.2651357 0.4418669 696 0.3315865 0.4708954 619 97 0.2701950 0.4446802 522 0.3316391 0.4709517 204 30 0.2500000 0.4348283 174 0.3314286 0.4711757
1728416410 NA NA 0.0000000 drug_era group during day -365 through -1 days relative to index: Penicillin G 1 0 0.0000000 0.0000000 1 0.0004764 0.0218270 1 0 0.0000000 0.0000000 1 0.0006353 0.0252056 NA NA NA NA NA NA NA
1729720409 409 1729720 0.0000000 drug_era group any time prior through -1 days relative to index: Penicillin V 1465 281 0.5866388 0.4929513 1184 0.5640781 0.4959952 1099 211 0.5877437 0.4929278 888 0.5641677 0.4960230 366 70 0.5833333 0.4950738 296 0.5638095 0.4963846
1729720410 410 1729720 0.0000000 drug_era group during day -365 through -1 days relative to index: Penicillin V 22 7 0.0146138 0.1201264 15 0.0071463 0.0842530 21 7 0.0194986 0.1384623 14 0.0088945 0.0939203 1 0 0.0000000 0.0000000 1 0.0019048 0.0436436
1738521409 409 1738521 0.0000000 drug_era group any time prior through -1 days relative to index: Doxycycline 433 84 0.1753653 0.3806769 349 0.1662697 0.3724112 327 60 0.1671309 0.3736134 267 0.1696315 0.3754280 106 24 0.2000000 0.4016772 82 0.1561905 0.3633821
1738521410 410 1738521 0.0000000 drug_era group during day -365 through -1 days relative to index: Doxycycline 2 0 0.0000000 0.0000000 2 0.0009528 0.0308607 2 0 0.0000000 0.0000000 2 0.0012706 0.0356348 NA NA NA NA NA NA NA
1741122409 409 1741122 0.0000000 drug_era group any time prior through -1 days relative to index: tazobactam 24 5 0.0104384 0.1017402 19 0.0090519 0.0947326 20 5 0.0139276 0.1173540 15 0.0095299 0.0971856 4 0 0.0000000 0.0000000 4 0.0076190 0.0870369
1741122410 NA NA 0.0000000 drug_era group during day -365 through -1 days relative to index: tazobactam 1 0 0.0000000 0.0000000 1 0.0004764 0.0218270 1 0 0.0000000 0.0000000 1 0.0006353 0.0252056 NA NA NA NA NA NA NA
1746114409 409 1746114 0.0000000 drug_era group any time prior through -1 days relative to index: Piperacillin 24 5 0.0104384 0.1017402 19 0.0090519 0.0947326 20 5 0.0139276 0.1173540 15 0.0095299 0.0971856 4 0 0.0000000 0.0000000 4 0.0076190 0.0870369
1746114410 NA NA 0.0000000 drug_era group during day -365 through -1 days relative to index: Piperacillin 1 0 0.0000000 0.0000000 1 0.0004764 0.0218270 1 0 0.0000000 0.0000000 1 0.0006353 0.0252056 NA NA NA NA NA NA NA
1759842409 409 1759842 0.0000000 drug_era group any time prior through -1 days relative to index: Clavulanate 1592 291 0.6075157 0.4888141 1301 0.6198190 0.4855468 1181 215 0.5988858 0.4908081 966 0.6137230 0.4870501 411 76 0.6333333 0.4839149 335 0.6380952 0.4810098
1759842410 410 1759842 0.0000000 drug_era group during day -365 through -1 days relative to index: Clavulanate 58 13 0.0271399 0.1626608 45 0.0214388 0.1448764 42 11 0.0306407 0.1725827 31 0.0196950 0.1389943 16 2 0.0166667 0.1285559 14 0.0266667 0.1612609
1768849409 409 1768849 0.0085804 drug_era group any time prior through -1 days relative to index: Cefaclor 105 28 0.0584551 0.2348473 77 0.0366841 0.1880299 82 24 0.0668524 0.2501147 58 0.0368488 0.1884503 23 4 0.0333333 0.1802581 19 0.0361905 0.1869419
1768849410 NA NA 0.0000000 drug_era group during day -365 through -1 days relative to index: Cefaclor 1 0 0.0000000 0.0000000 1 0.0004764 0.0218270 1 0 0.0000000 0.0000000 1 0.0006353 0.0252056 NA NA NA NA NA NA NA
1778162409 409 1778162 0.0000000 drug_era group any time prior through -1 days relative to index: Cefuroxime 55 12 0.0250522 0.1564470 43 0.0204859 0.1416892 38 9 0.0250696 0.1565549 29 0.0184244 0.1345230 17 3 0.0250000 0.1567796 14 0.0266667 0.1612609
1778162410 410 1778162 0.0000000 drug_era group during day -365 through -1 days relative to index: Cefuroxime 1 0 0.0000000 0.0000000 1 0.0004764 0.0218270 1 0 0.0000000 0.0000000 1 0.0006353 0.0252056 NA NA NA NA NA NA NA
4001336209 209 4001336 0.0000000 condition_era group any time prior through -1 days relative to index: Concussion injury of brain 776 145 0.3027140 0.4599128 631 0.3006193 0.4586366 600 115 0.3203343 0.4672562 485 0.3081321 0.4618682 176 30 0.2500000 0.4348283 146 0.2780952 0.4484879
4001336210 210 4001336 0.0000000 condition_era group during day -365 through -1 days relative to index: Concussion injury of brain 27 4 0.0083507 0.0910951 23 0.0109576 0.1041283 19 2 0.0055710 0.0745350 17 0.0108005 0.1033956 8 2 0.0166667 0.1285559 6 0.0114286 0.1063932
4027663209 209 4027663 1.2459687 condition_era group any time prior through -1 days relative to index: Peptic ulcer 780 266 0.5553236 0.4974494 514 0.2448785 0.4301176 576 202 0.5626741 0.4967487 374 0.2376112 0.4257549 204 64 0.5333333 0.5009794 140 0.2666667 0.4426384
4029498209 209 4029498 0.0000000 condition_era group any time prior through -1 days relative to index: Seizure disorder 65 13 0.0271399 0.1626608 52 0.0247737 0.1554718 54 13 0.0362117 0.1870773 41 0.0260483 0.1593295 11 0 0.0000000 0.0000000 11 0.0209524 0.1433615
4029498210 210 4029498 0.0000000 condition_era group during day -365 through -1 days relative to index: Seizure disorder 2 0 0.0000000 0.0000000 2 0.0009528 0.0308607 2 0 0.0000000 0.0000000 2 0.0012706 0.0356348 NA NA NA NA NA NA NA
4035415209 209 4035415 0.0000000 condition_era group any time prior through -1 days relative to index: Tear of meniscus of knee 54 8 0.0167015 0.1282844 46 0.0219152 0.1464416 41 6 0.0167131 0.1283732 35 0.0222363 0.1474982 13 2 0.0166667 0.1285559 11 0.0209524 0.1433615
4035415210 210 4035415 0.0000000 condition_era group during day -365 through -1 days relative to index: Tear of meniscus of knee 4 0 0.0000000 0.0000000 4 0.0019057 0.0436228 2 0 0.0000000 0.0000000 2 0.0012706 0.0356348 2 0 0.0000000 0.0000000 2 0.0038095 0.0616624
4048171209 209 4048171 0.0000000 condition_era group any time prior through -1 days relative to index: Perennial allergic rhinitis with seasonal variation 75 14 0.0292276 0.1686199 61 0.0290615 0.1680189 57 11 0.0306407 0.1725827 46 0.0292249 0.1684899 18 3 0.0250000 0.1567796 15 0.0285714 0.1667575
4048171210 210 4048171 0.0000000 condition_era group during day -365 through -1 days relative to index: Perennial allergic rhinitis with seasonal variation 3 1 0.0020877 0.0456912 2 0.0009528 0.0308607 3 1 0.0027855 0.0527780 2 0.0012706 0.0356348 NA NA NA NA NA NA NA
4048695209 209 4048695 0.0000000 condition_era group any time prior through -1 days relative to index: Fracture of vertebral column without spinal cord injury 11 3 0.0062630 0.0789737 8 0.0038113 0.0616330 9 3 0.0083565 0.0911584 6 0.0038119 0.0616427 2 0 0.0000000 0.0000000 2 0.0038095 0.0616624
4051466209 209 4051466 0.0000000 condition_era group any time prior through -1 days relative to index: Childhood asthma 88 13 0.0271399 0.1626608 75 0.0357313 0.1856637 61 11 0.0306407 0.1725827 50 0.0317662 0.1754328 27 2 0.0166667 0.1285559 25 0.0476190 0.2131620
4056621209 209 4056621 0.0000000 condition_era group any time prior through -1 days relative to index: Recurrent urinary tract infection 20 6 0.0125261 0.1113331 14 0.0066698 0.0814157 16 5 0.0139276 0.1173540 11 0.0069886 0.0833315 4 1 0.0083333 0.0912871 3 0.0057143 0.0754485
4056621210 210 4056621 0.0000000 condition_era group during day -365 through -1 days relative to index: Recurrent urinary tract infection 2 0 0.0000000 0.0000000 2 0.0009528 0.0308607 2 0 0.0000000 0.0000000 2 0.0012706 0.0356348 NA NA NA NA NA NA NA
4059173209 209 4059173 0.0000000 condition_era group any time prior through -1 days relative to index: Fracture of ankle 296 52 0.1085595 0.3114110 244 0.1162458 0.3205959 222 40 0.1114206 0.3150914 182 0.1156290 0.3198811 74 12 0.1000000 0.3012579 62 0.1180952 0.3230287
4059173210 210 4059173 0.0000000 condition_era group during day -365 through -1 days relative to index: Fracture of ankle 2 0 0.0000000 0.0000000 2 0.0009528 0.0308607 1 0 0.0000000 0.0000000 1 0.0006353 0.0252056 1 0 0.0000000 0.0000000 1 0.0019048 0.0436436
4066995209 209 4066995 0.0000000 condition_era group any time prior through -1 days relative to index: Fracture of vertebral column with spinal cord injury 3 0 0.0000000 0.0000000 3 0.0014293 0.0377874 2 0 0.0000000 0.0000000 2 0.0012706 0.0356348 1 0 0.0000000 0.0000000 1 0.0019048 0.0436436
4084167209 209 4084167 0.0000000 condition_era group any time prior through -1 days relative to index: Acute allergic reaction 107 15 0.0313152 0.1743504 92 0.0438304 0.2047664 81 12 0.0334262 0.1799976 69 0.0438374 0.2047982 26 3 0.0250000 0.1567796 23 0.0438095 0.2048663
4084167210 NA NA 0.0000000 condition_era group during day -365 through -1 days relative to index: Acute allergic reaction 1 0 0.0000000 0.0000000 1 0.0004764 0.0218270 1 0 0.0000000 0.0000000 1 0.0006353 0.0252056 NA NA NA NA NA NA NA
4094814209 209 4094814 0.0000000 condition_era group any time prior through -1 days relative to index: Bullet wound 26 6 0.0125261 0.1113331 20 0.0095283 0.0971702 14 3 0.0083565 0.0911584 11 0.0069886 0.0833315 12 3 0.0250000 0.1567796 9 0.0171429 0.1299274
4109685209 209 4109685 0.0000000 condition_era group any time prior through -1 days relative to index: Laceration of foot 311 59 0.1231733 0.3289796 252 0.1200572 0.3251058 236 44 0.1225627 0.3283922 192 0.1219822 0.3273693 75 15 0.1250000 0.3321056 60 0.1142857 0.3184614
4109685210 210 4109685 0.0000000 condition_era group during day -365 through -1 days relative to index: Laceration of foot 2 1 0.0020877 0.0456912 1 0.0004764 0.0218270 1 1 0.0027855 0.0527780 0 0.0000000 0.0000000 1 0 0.0000000 0.0000000 1 0.0019048 0.0436436
4112343209 209 4112343 0.0000000 condition_era group any time prior through -1 days relative to index: Acute viral pharyngitis 2359 443 0.9248434 0.2639195 1916 0.9128156 0.2821723 1756 329 0.9164345 0.2771213 1427 0.9066074 0.2910743 603 114 0.9500000 0.2188588 489 0.9314286 0.2529650
4112343210 210 4112343 0.0000000 condition_era group during day -365 through -1 days relative to index: Acute viral pharyngitis 173 31 0.0647182 0.2462851 142 0.0676513 0.2512064 130 21 0.0584958 0.2350062 109 0.0692503 0.2539600 43 10 0.0833333 0.2775443 33 0.0628571 0.2429373
4113008209 209 4113008 0.1200263 condition_era group any time prior through -1 days relative to index: Laceration of hand 287 63 0.1315240 0.3383259 224 0.1067175 0.3088273 224 53 0.1476323 0.3552302 171 0.1086404 0.3112864 63 10 0.0833333 0.2775443 53 0.1009524 0.3015530
4113008210 210 4113008 0.0000000 condition_era group during day -365 through -1 days relative to index: Laceration of hand 6 2 0.0041754 0.0645494 4 0.0019057 0.0436228 3 1 0.0027855 0.0527780 2 0.0012706 0.0356348 3 1 0.0083333 0.0912871 2 0.0038095 0.0616624
4116491209 209 4116491 0.0000000 condition_era group any time prior through -1 days relative to index: Escherichia coli urinary tract infection 231 45 0.0939457 0.2920582 186 0.0886136 0.2842530 170 34 0.0947075 0.2932192 136 0.0864041 0.2810491 61 11 0.0916667 0.2897647 50 0.0952381 0.2938235
4116491210 210 4116491 0.0000000 condition_era group during day -365 through -1 days relative to index: Escherichia coli urinary tract infection 11 3 0.0062630 0.0789737 8 0.0038113 0.0616330 10 3 0.0083565 0.0911584 7 0.0044473 0.0665605 1 0 0.0000000 0.0000000 1 0.0019048 0.0436436
4132546209 209 4132546 0.0000000 condition_era group any time prior through -1 days relative to index: Traumatic brain injury 776 145 0.3027140 0.4599128 631 0.3006193 0.4586366 600 115 0.3203343 0.4672562 485 0.3081321 0.4618682 176 30 0.2500000 0.4348283 146 0.2780952 0.4484879
4132546210 210 4132546 0.0000000 condition_era group during day -365 through -1 days relative to index: Traumatic brain injury 27 4 0.0083507 0.0910951 23 0.0109576 0.1041283 19 2 0.0055710 0.0745350 17 0.0108005 0.1033956 8 2 0.0166667 0.1285559 6 0.0114286 0.1063932
4134304209 209 4134304 0.0000000 condition_era group any time prior through -1 days relative to index: Fracture subluxation of wrist 315 59 0.1231733 0.3289796 256 0.1219628 0.3273209 241 48 0.1337047 0.3408098 193 0.1226175 0.3281019 74 11 0.0916667 0.2897647 63 0.1200000 0.3252715
4134304210 210 4134304 0.0000000 condition_era group during day -365 through -1 days relative to index: Fracture subluxation of wrist 6 1 0.0020877 0.0456912 5 0.0023821 0.0487601 5 1 0.0027855 0.0527780 4 0.0025413 0.0503632 1 0 0.0000000 0.0000000 1 0.0019048 0.0436436
4142905209 209 4142905 0.0000000 condition_era group any time prior through -1 days relative to index: Fracture of rib 168 40 0.0835073 0.2769367 128 0.0609814 0.2393533 136 33 0.0919220 0.2893191 103 0.0654384 0.2473764 32 7 0.0583333 0.2353554 25 0.0476190 0.2131620
4142905210 NA NA 0.0000000 condition_era group during day -365 through -1 days relative to index: Fracture of rib 1 0 0.0000000 0.0000000 1 0.0004764 0.0218270 1 0 0.0000000 0.0000000 1 0.0006353 0.0252056 NA NA NA NA NA NA NA
4149245209 209 4149245 0.0000000 condition_era group any time prior through -1 days relative to index: Rupture of patellar tendon 41 7 0.0146138 0.1201264 34 0.0161982 0.1262672 31 6 0.0167131 0.1283732 25 0.0158831 0.1250630 10 1 0.0083333 0.0912871 9 0.0171429 0.1299274
4149245210 210 4149245 0.0000000 condition_era group during day -365 through -1 days relative to index: Rupture of patellar tendon 2 0 0.0000000 0.0000000 2 0.0009528 0.0308607 2 0 0.0000000 0.0000000 2 0.0012706 0.0356348 NA NA NA NA NA NA NA
4152936209 209 4152936 -0.0292760 condition_era group any time prior through -1 days relative to index: Laceration of thigh 296 43 0.0897704 0.2861513 253 0.1205336 0.3256620 221 33 0.0919220 0.2893191 188 0.1194409 0.3244097 75 10 0.0833333 0.2775443 65 0.1238095 0.3296783
4152936210 210 4152936 0.0000000 condition_era group during day -365 through -1 days relative to index: Laceration of thigh 6 1 0.0020877 0.0456912 5 0.0023821 0.0487601 4 0 0.0000000 0.0000000 4 0.0025413 0.0503632 2 1 0.0083333 0.0912871 1 0.0019048 0.0436436
4155034209 209 4155034 0.0000000 condition_era group any time prior through -1 days relative to index: Laceration of forearm 297 50 0.1043841 0.3060779 247 0.1176751 0.3222998 225 38 0.1058496 0.3080744 187 0.1188056 0.3236624 72 12 0.1000000 0.3012579 60 0.1142857 0.3184614
4155034210 210 4155034 0.0000000 condition_era group during day -365 through -1 days relative to index: Laceration of forearm 7 3 0.0062630 0.0789737 4 0.0019057 0.0436228 4 1 0.0027855 0.0527780 3 0.0019060 0.0436297 3 2 0.0166667 0.1285559 1 0.0019048 0.0436436
4156265209 209 4156265 -0.0733670 condition_era group any time prior through -1 days relative to index: Facial laceration 303 43 0.0897704 0.2861513 260 0.1238685 0.3295100 216 29 0.0807799 0.2728772 187 0.1188056 0.3236624 87 14 0.1166667 0.3223687 73 0.1390476 0.3463262
4156265210 210 4156265 0.0000000 condition_era group during day -365 through -1 days relative to index: Facial laceration 7 1 0.0020877 0.0456912 6 0.0028585 0.0534012 6 1 0.0027855 0.0527780 5 0.0031766 0.0562898 1 0 0.0000000 0.0000000 1 0.0019048 0.0436436
4166224209 209 4166224 0.0000000 condition_era group any time prior through -1 days relative to index: Rupture of appendix 29 4 0.0083507 0.0910951 25 0.0119104 0.1085089 20 2 0.0055710 0.0745350 18 0.0114358 0.1063590 9 2 0.0166667 0.1285559 7 0.0133333 0.1148071
4218389209 209 4218389 0.0000000 condition_era group any time prior through -1 days relative to index: Whiplash injury to neck 459 91 0.1899791 0.3926945 368 0.1753216 0.3803325 351 70 0.1949861 0.3967429 281 0.1785260 0.3830767 108 21 0.1750000 0.3815603 87 0.1657143 0.3721786
4218389210 210 4218389 0.0000000 condition_era group during day -365 through -1 days relative to index: Whiplash injury to neck 14 2 0.0041754 0.0645494 12 0.0057170 0.0754124 11 1 0.0027855 0.0527780 10 0.0063532 0.0794789 3 1 0.0083333 0.0912871 2 0.0038095 0.0616624
4230399209 209 4230399 0.0000000 condition_era group any time prior through -1 days relative to index: Closed fracture of hip 61 12 0.0250522 0.1564470 49 0.0233444 0.1510310 43 9 0.0250696 0.1565549 34 0.0216010 0.1454230 18 3 0.0250000 0.1567796 15 0.0285714 0.1667575
4237458209 209 4237458 0.0000000 condition_era group any time prior through -1 days relative to index: Fracture of clavicle 310 52 0.1085595 0.3114110 258 0.1229157 0.3284186 235 40 0.1114206 0.3150914 195 0.1238882 0.3295586 75 12 0.1000000 0.3012579 63 0.1200000 0.3252715
4237458210 210 4237458 0.0000000 condition_era group during day -365 through -1 days relative to index: Fracture of clavicle 8 0 0.0000000 0.0000000 8 0.0038113 0.0616330 7 0 0.0000000 0.0000000 7 0.0044473 0.0665605 1 0 0.0000000 0.0000000 1 0.0019048 0.0436436
4278672209 209 4278672 0.0000000 condition_era group any time prior through -1 days relative to index: Fracture of forearm 356 59 0.1231733 0.3289796 297 0.1414960 0.3486155 268 48 0.1337047 0.3408098 220 0.1397713 0.3468598 88 11 0.0916667 0.2897647 77 0.1466667 0.3541107
4278672210 210 4278672 0.0000000 condition_era group during day -365 through -1 days relative to index: Fracture of forearm 6 0 0.0000000 0.0000000 6 0.0028585 0.0534012 3 0 0.0000000 0.0000000 3 0.0019060 0.0436297 3 0 0.0000000 0.0000000 3 0.0057143 0.0754485
4280726209 209 4280726 0.0000000 condition_era group any time prior through -1 days relative to index: Seasonal allergic rhinitis 23 2 0.0041754 0.0645494 21 0.0100048 0.0995459 17 2 0.0055710 0.0745350 15 0.0095299 0.0971856 6 0 0.0000000 0.0000000 6 0.0114286 0.1063932
4280726210 210 4280726 0.0000000 condition_era group during day -365 through -1 days relative to index: Seasonal allergic rhinitis 3 0 0.0000000 0.0000000 3 0.0014293 0.0377874 1 0 0.0000000 0.0000000 1 0.0006353 0.0252056 2 0 0.0000000 0.0000000 2 0.0038095 0.0616624
4283893209 209 4283893 0.0000000 condition_era group any time prior through -1 days relative to index: Sinusitis 2554 475 0.9916493 0.0910951 2079 0.9904717 0.0971702 1914 356 0.9916435 0.0911584 1558 0.9898348 0.1003407 640 119 0.9916667 0.0912871 521 0.9923810 0.0870369
4283893210 210 4283893 0.0000000 condition_era group during day -365 through -1 days relative to index: Sinusitis 319 65 0.1356994 0.3428271 254 0.1210100 0.3262166 239 49 0.1364903 0.3437876 190 0.1207116 0.3258953 80 16 0.1333333 0.3413599 64 0.1219048 0.3274878
4285898209 209 4285898 -0.0025791 condition_era group any time prior through -1 days relative to index: Polyp of colon 371 113 0.2359081 0.4250089 258 0.1229157 0.3284186 281 86 0.2395543 0.4274072 195 0.1238882 0.3295586 90 27 0.2250000 0.4193332 63 0.1200000 0.3252715
4285898210 210 4285898 -0.0000447 condition_era group during day -365 through -1 days relative to index: Polyp of colon 371 113 0.2359081 0.4250089 258 0.1229157 0.3284186 281 86 0.2395543 0.4274072 195 0.1238882 0.3295586 90 27 0.2250000 0.4193332 63 0.1200000 0.3252715
4294548209 209 4294548 -0.0823952 condition_era group any time prior through -1 days relative to index: Acute bacterial sinusitis 512 89 0.1858038 0.3893549 423 0.2015245 0.4012345 392 63 0.1754875 0.3809144 329 0.2090216 0.4067391 120 26 0.2166667 0.4137009 94 0.1790476 0.3837578
4294548210 210 4294548 0.0000000 condition_era group during day -365 through -1 days relative to index: Acute bacterial sinusitis 19 3 0.0062630 0.0789737 16 0.0076227 0.0869953 15 2 0.0055710 0.0745350 13 0.0082592 0.0905329 4 1 0.0083333 0.0912871 3 0.0057143 0.0754485
4296204209 209 4296204 0.0000000 condition_era group any time prior through -1 days relative to index: First degree burn 224 45 0.0939457 0.2920582 179 0.0852787 0.2793625 159 31 0.0863510 0.2812736 128 0.0813215 0.2734150 65 14 0.1166667 0.3223687 51 0.0971429 0.2964346
4296204210 210 4296204 0.0000000 condition_era group during day -365 through -1 days relative to index: First degree burn 4 0 0.0000000 0.0000000 4 0.0019057 0.0436228 2 0 0.0000000 0.0000000 2 0.0012706 0.0356348 2 0 0.0000000 0.0000000 2 0.0038095 0.0616624
4296205209 209 4296205 0.0000000 condition_era group any time prior through -1 days relative to index: Second degree burn 135 27 0.0563674 0.2308710 108 0.0514531 0.2209727 100 20 0.0557103 0.2296815 80 0.0508259 0.2197119 35 7 0.0583333 0.2353554 28 0.0533333 0.2249116
4296205210 210 4296205 0.0000000 condition_era group during day -365 through -1 days relative to index: Second degree burn 8 0 0.0000000 0.0000000 8 0.0038113 0.0616330 7 0 0.0000000 0.0000000 7 0.0044473 0.0665605 1 0 0.0000000 0.0000000 1 0.0019048 0.0436436
4299128209 209 4299128 0.0000000 condition_era group any time prior through -1 days relative to index: Third degree burn 14 2 0.0041754 0.0645494 12 0.0057170 0.0754124 12 2 0.0055710 0.0745350 10 0.0063532 0.0794789 2 0 0.0000000 0.0000000 2 0.0038095 0.0616624
4310024209 209 4310024 0.0000000 condition_era group any time prior through -1 days relative to index: Angiodysplasia of stomach 377 128 0.2672234 0.4429726 249 0.1186279 0.3234272 282 95 0.2646240 0.4417484 187 0.1188056 0.3236624 95 33 0.2750000 0.4483865 62 0.1180952 0.3230287
4310024210 210 4310024 0.0000000 condition_era group during day -365 through -1 days relative to index: Angiodysplasia of stomach 8 1 0.0020877 0.0456912 7 0.0033349 0.0576661 6 0 0.0000000 0.0000000 6 0.0038119 0.0616427 2 1 0.0083333 0.0912871 1 0.0019048 0.0436436
4329847209 209 4329847 0.0000000 condition_era group any time prior through -1 days relative to index: Myocardial infarction 5 2 0.0041754 0.0645494 3 0.0014293 0.0377874 5 2 0.0055710 0.0745350 3 0.0019060 0.0436297 NA NA NA NA NA NA NA
19002770409 409 19002770 0.0000000 drug_era group any time prior through -1 days relative to index: desflurane 5 1 0.0020877 0.0456912 4 0.0019057 0.0436228 4 1 0.0027855 0.0527780 3 0.0019060 0.0436297 1 0 0.0000000 0.0000000 1 0.0019048 0.0436436
19003953409 409 19003953 0.0000000 drug_era group any time prior through -1 days relative to index: Rocuronium 24 5 0.0104384 0.1017402 19 0.0090519 0.0947326 20 5 0.0139276 0.1173540 15 0.0095299 0.0971856 4 0 0.0000000 0.0000000 4 0.0076190 0.0870369
19003953410 NA NA 0.0000000 drug_era group during day -365 through -1 days relative to index: Rocuronium 1 0 0.0000000 0.0000000 1 0.0004764 0.0218270 1 0 0.0000000 0.0000000 1 0.0006353 0.0252056 NA NA NA NA NA NA NA
19010482409 409 19010482 0.0000000 drug_era group any time prior through -1 days relative to index: Cyclosporine 5 0 0.0000000 0.0000000 5 0.0023821 0.0487601 4 0 0.0000000 0.0000000 4 0.0025413 0.0503632 1 0 0.0000000 0.0000000 1 0.0019048 0.0436436
19010482410 410 19010482 0.0000000 drug_era group during day -365 through -1 days relative to index: Cyclosporine 2 0 0.0000000 0.0000000 2 0.0009528 0.0308607 2 0 0.0000000 0.0000000 2 0.0012706 0.0356348 NA NA NA NA NA NA NA
19016749409 409 19016749 0.0000000 drug_era group any time prior through -1 days relative to index: remifentanil 12 2 0.0041754 0.0645494 10 0.0047642 0.0688748 11 2 0.0055710 0.0745350 9 0.0057179 0.0754244 1 0 0.0000000 0.0000000 1 0.0019048 0.0436436
19039298409 409 19039298 0.0000000 drug_era group any time prior through -1 days relative to index: sevoflurane 2 0 0.0000000 0.0000000 2 0.0009528 0.0308607 2 0 0.0000000 0.0000000 2 0.0012706 0.0356348 NA NA NA NA NA NA NA
19059528409 409 19059528 0.0000000 drug_era group any time prior through -1 days relative to index: Alfentanil 4 1 0.0020877 0.0456912 3 0.0014293 0.0377874 3 1 0.0027855 0.0527780 2 0.0012706 0.0356348 1 0 0.0000000 0.0000000 1 0.0019048 0.0436436
19078219409 409 19078219 0.0000000 drug_era group any time prior through -1 days relative to index: Sufentanil 4 1 0.0020877 0.0456912 3 0.0014293 0.0377874 3 1 0.0027855 0.0527780 2 0.0012706 0.0356348 1 0 0.0000000 0.0000000 1 0.0019048 0.0436436
19127890409 409 19127890 0.0000000 drug_era group any time prior through -1 days relative to index: Inert Ingredients 636 112 0.2338205 0.4237018 524 0.2496427 0.4329093 472 81 0.2256267 0.4185778 391 0.2484117 0.4322291 164 31 0.2583333 0.4395535 133 0.2533333 0.4353350
40481087209 209 40481087 0.0000000 condition_era group any time prior through -1 days relative to index: Viral sinusitis 2544 472 0.9853862 0.1201264 2072 0.9871367 0.1127114 1905 353 0.9832869 0.1283732 1552 0.9860229 0.1174331 639 119 0.9916667 0.0912871 520 0.9904762 0.0972168
40481087210 210 40481087 0.0000000 condition_era group during day -365 through -1 days relative to index: Viral sinusitis 276 58 0.1210856 0.3265678 218 0.1038590 0.3051502 204 43 0.1197772 0.3251539 161 0.1022872 0.3031219 72 15 0.1250000 0.3321056 57 0.1085714 0.3113975
40486433209 209 40486433 0.0000000 condition_era group any time prior through -1 days relative to index: Perennial allergic rhinitis 135 23 0.0480167 0.2140251 112 0.0533587 0.2248014 103 17 0.0473538 0.2126908 86 0.0546379 0.2273442 32 6 0.0500000 0.2188588 26 0.0495238 0.2171659
40486433210 210 40486433 0.0000000 condition_era group during day -365 through -1 days relative to index: Perennial allergic rhinitis 4 1 0.0020877 0.0456912 3 0.0014293 0.0377874 4 1 0.0027855 0.0527780 3 0.0019060 0.0436297 NA NA NA NA NA NA NA
44782520209 209 44782520 0.0000000 condition_era group any time prior through -1 days relative to index: Chronic paralysis due to lesion of spinal cord 3 0 0.0000000 0.0000000 3 0.0014293 0.0377874 2 0 0.0000000 0.0000000 2 0.0012706 0.0356348 1 0 0.0000000 0.0000000 1 0.0019048 0.0436436