Cover

This file is intended to summarize the data within your recent i2b2 data pull.
The data in this file was prepared for and solely intended for user ‘insert username’. Data current as of ‘insert date and time of file generation’
For questions or comments, please contact
[email protected]
For details on Data Puller fields see website:
CTSI-clopedia Data Dictionary

Patients

General Summary Table: excludes missing (NA) data for each variable
                          
                           Overall      
  n                          762        
  AGE_NOW (mean (sd))      73.03 (16.88)
  AGE_AT_DEATH (mean (sd)) 72.34 (13.14)
  GENDER = M (%)             495 (65.0) 
  RACE (%)                              
     B                        92 (12.1) 
     I                         1 ( 0.1) 
     R                         1 ( 0.1) 
     U                         5 ( 0.7) 
     W                       655 (86.0) 
     X                         8 ( 1.0) 
  MIXED_RACE (%)                        
     U-W                       1 ( 7.1) 
     W-I                      12 (85.7) 
     W-W                       1 ( 7.1) 
  ETHNICITY (%)                         
     H                         8 ( 1.6) 
     N                       487 (97.4) 
     P                         3 ( 0.6) 
     U                         2 ( 0.4)

NIH Demographic Variable Breakdown
_________ _________ _________ _________ _________ _________
Ethnicity Hisp Hisp Non-Hisp Non-Hisp Unkn Unkn
Gender_Long Female Male Female Male Female Male
Amer_Indian_Alask_Natv 0 0 1 0 0 0
Black_AA 0 0 24 42 17 9
Multi 0 0 1 1 5 7
Other 2 4 1 1 0 0
Unkn 0 0 0 0 0 5
White_Caucasian 0 2 142 274 74 150

Visits

Observations: 153086
Unique Patients: 762
Unique Visits: 153086
Unique Visits per PAT_NUM:
  Mean Median Min  Max    SD
 200.9    105   1 2269 265.4
                 
Date Variable Summary:
   START_DATE      END_DATE    
 Min.   :1983   Min.   :1900   
 1st Qu.:2008   1st Qu.:2011   
 Median :2014   Median :2014   
 Mean   :2012   Mean   :2012   
 3rd Qu.:2016   3rd Qu.:2016   
 Max.   :2019   Max.   :2019   
 NA's   :4745   NA's   :73759  
                 
                 
                 
General Summary Table: excludes missing (NA) data for each variable
                            
                             Overall        
  n                           153086        
  START_DATE (mean (sd))     2011.67 (6.00) 
  END_DATE (mean (sd))       2012.08 (6.28) 
  LENGTH_OF_STAY (mean (sd))    5.61 (38.18)

Procedures

Observations: 107904
Unique Patients: 485
Unique Visits: 31046
Unique Visits per PAT_NUM:
 Mean Median Min Max   SD
   64     38   1 407 72.1
                 
Date Variable Summary:
      DATE     
 Min.   :2013  
 1st Qu.:2014  
 Median :2015  
 Mean   :2015  
 3rd Qu.:2017  
 Max.   :2019  
                 
                 
                 
General Summary Table: excludes missing (NA) data for each variable
                   
                    Overall        
  n                  107904        
  DATE (mean (sd))  2015.40 (1.67) 
  MODIFIER (%)                     
     @               105855 (98.1) 
     Admission           11 ( 0.0) 
     Primary            490 ( 0.5) 
     PROBLEM:ACTIVE      55 ( 0.1) 
     Secondary         1493 ( 1.4) 

Top 10 Frequent Procedure Codes
PROC_CODE n Unique_Patients PROC_DESC
99213 4754 385 99213
99214 3905 366 99214
99212 3850 348 99212
85610 3243 362 CHG PROTHROMBIN TIME
85025 2718 404 CHG COMPLETE CBC and AUTO DIFF WBC
93010 2691 433 PR ELECTROCARDIOGRAM REPORT
80048 2687 428 CHG BASIC METABOLIC PANEL CALCIUM TOTAL
93005 2663 434 PR ELECTROCARDIOGRAM, TRACING
36415 2441 379 36415
80053 2260 386 CHG METABOLIC PANEL,COMPREHENSIVE

Diagnoses

ICD10 went live on Oct 1, 2015. Epic uses a dx id so that ICD9 and ICD10 codes will be reported for most codes. For this summary report, ICD10 is reported post Oct 1, 2015 and ICD9 is reported prior to that date.

Observations: 251398
Unique Patients: 483
Unique Visits: 43628
Unique Visits per PAT_NUM:
 Mean Median Min Max    SD
 90.3     48   1 692 108.7
                 
Date Variable Summary:
      DATE     
 Min.   :2013  
 1st Qu.:2014  
 Median :2016  
 Mean   :2016  
 3rd Qu.:2017  
 Max.   :2019  
                 
                 
                 
General Summary Table: excludes missing (NA) data for each variable
                      
                       Overall        
  n                     251398        
  DATE (mean (sd))     2015.65 (1.78) 
  MODIFIER (%)                        
     @                     128 ( 0.1) 
     Admission           26237 (10.4) 
     Complication         3211 ( 1.3) 
     E                    5407 ( 2.2) 
     EXTCAUSE            10155 ( 4.0) 
     Primary             78622 (31.3) 
     PROBLEM:ACTIVE      29219 (11.6) 
     Secondary           98419 (39.1) 
  CODE_TYPE = ICD9 (%)  139385 (55.4) 

Top 10 Frequent ICD10 codes post Oct 1, 2015 if full date
Top 10 Frequent ICD10 codes post 2015 if year only
DIAG_CODE n Unique_Patients DIAG_DESC
Z94.1 3548 26 Heart transplant status
I50.22 3222 150 Chronic systolic (congestive) heart failure
I10 1863 201 Essential (primary) hypertension
Y83.1 1334 90 Surgical operation with implant of artificial internal device as the cause of abnormal reaction of the patient, or of later complication, without mention of misadventure at the time of the procedure
Y83.8 1306 94 Other surgical procedures as the cause of abnormal reaction of the patient, or of later complication, without mention of misadventure at the time of the procedure
Z79.899 1235 92 Other long term (current) drug therapy
Z95.811 1045 10 Presence of heart assist device
Z95.810 902 153 Presence of automatic (implantable) cardiac defibrillator
Z95.0 865 144 Presence of cardiac pacemaker
I25.10 727 104 Atherosclerotic heart disease of native coronary artery without angina pectoris 
Top 10 Frequent ICD9 codes prior to Oct 1, 2015 if full date
Top 10 Frequent ICD9 codes prior to 2016 if year only
DIAG_CODE n Unique_Patients DIAG_DESC
Z94.1 3548 26 Heart transplant status
I50.22 3222 150 Chronic systolic (congestive) heart failure
I10 1863 201 Essential (primary) hypertension
Y83.1 1334 90 Surgical operation with implant of artificial internal device as the cause of abnormal reaction of the patient, or of later complication, without mention of misadventure at the time of the procedure
Y83.8 1306 94 Other surgical procedures as the cause of abnormal reaction of the patient, or of later complication, without mention of misadventure at the time of the procedure
Z79.899 1235 92 Other long term (current) drug therapy
Z95.811 1045 10 Presence of heart assist device
Z95.810 902 153 Presence of automatic (implantable) cardiac defibrillator
Z95.0 865 144 Presence of cardiac pacemaker
I25.10 727 104 Atherosclerotic heart disease of native coronary artery without angina pectoris

Labs

Observations: 597666
Unique Patients: 477
Unique Visits: 14463
Unique Visits per PAT_NUM:
 Mean Median Min Max   SD
 30.3     11   1 410 50.8
                 
Date Variable Summary:
   DATE_TIME   
 Min.   :2013  
 1st Qu.:2014  
 Median :2016  
 Mean   :2016  
 3rd Qu.:2017  
 Max.   :2019  
                 
                 
                 
General Summary Table: excludes missing (NA) data for each variable
                           
                            Overall                    
  n                              597666                
  DATE_TIME (mean (sd))         2015.61 (1.75)         
  NUMERIC_VALUE (mean (sd)) 45164737.32 (3016393611.71)

Top 10 Frequent Lab Codes - Numeric
LAB_CODE n Unique_Patients Mean Median Max Min SD LAB_DESC UNITS
LGLUB:POCGLU 11226 266 168.31 154.00 500.00 0.0 70.73 NA mg/dL,mg/dl
BMEP:GLU 8193 420 127.54 110.00 983.00 16.0 57.04 NA MG/DL,mg/dL,mg/dl
BMEP:CREATININE 8085 420 1.55 1.20 14.25 0.2 1.15 NA MG/DL,mg/dL,mg/dl
BMEP:BUN 6969 420 28.57 23.00 150.00 2.0 18.93 NA MG/DL,mg/dL,mg/dl
BMEP:K 6613 420 4.24 4.20 10.00 1.8 0.67 NA MMOL/L,mmol/L,mEq/L
BMEP:CALCIUM 6380 420 8.83 8.90 12.70 0.0 0.92 NA MG/DL,mg/dL,mg/dl
CBC:RBC 6224 396 3.71 3.68 6.48 0.0 0.78 NA X 10^6/uL,X 106/uL,x 106/uL,X1,000,000,10*12/L,NA,M/uL,x10E6/uL,M/UL,10^6/uL
CBC:HCT 6172 396 33.51 33.20 55.10 0.0 6.89 NA %,NA
CBC:PLT 6159 395 198.42 184.00 897.00 0.0 90.99 NA X 10^3/uL,X 103/uL,X1000,109/L,NA,K/UL,10^3/uL
BMEP:CL 6055 420 101.96 102.00 125.00 77.0 5.13 NA MMOL/L,mmol/L,mEq/L

Meds

Observations: 272190
Unique Patients: 475
Unique Visits: 16165
Unique Visits per PAT_NUM:
 Mean Median Min Max   SD
   34     16   1 276 42.9
                 
Date Variable Summary:
   DATE_TIME   
 Min.   :2013  
 1st Qu.:2014  
 Median :2016  
 Mean   :2016  
 3rd Qu.:2017  
 Max.   :2019  
                 
                 
                 
General Summary Table: excludes missing (NA) data for each variable
                           
                            Overall          
  n                          272190          
  DATE_TIME (mean (sd))     2015.56 (1.76)   
  NUMERIC_VALUE (mean (sd))  370.13 (9358.70)

Top 10 Frequent Med Codes in Data Set
MED_CODE n Unique_Patients MED_DESC UNITS TEXT_VALUE
3037 4485 419 Fentanyl (Pf) 50 Mcg/Ml Injection Solution mcg,NA,mcg/kg,mL E,Every 30 min PRN,NA
34505 4023 337 Hydrocodone 5 Mg-Acetaminophen 325 Mg Tablet tablet,NA,partial tablet E,Every 6 hours PRN,NA,Every 4 hours PRN,4 times daily PRN,Every 8 hours PRN,2 times daily,Every 4 hours,Nightly PRN,As needed,2 times daily PRN,Daily after dinner,Every 6 hours,Once
27838 3557 342 Sodium Chloride 0.9 % Intravenous Solution NA,mL,mL/hr E
105614 3380 420 Ondansetron Hcl (Pf) 4 Mg/2 Ml Injection Solution mg,NA,mL E,Every 6 hours PRN,NA
26225 3305 250 Pantoprazole 40 Mg Tablet,Delayed Release mg,NA,tablet E,2 times daily,NA,Daily,2 times daily before meals,Daily as needed,Daily before breakfast,BID Three Days a week,Once,2 times daily with meals
17405 3130 150 Insulin Lispro 100 Unit/Ml Subcutaneous Solution Units,NA,mL E,3 times daily before meals,NA,Daily with breakfast,Daily with dinner,Daily with lunch,3 times daily with meals,4 times daily before meals and nightly,3 times daily after meals,4 times daily with meals and nightly,4 times daily after meals and nightly
430194 2951 176 Phenylephrine Infusion (Standard) 0.12 Mg/Ml Premix mcg/min,NA,mg,mcg E
3295 2903 168 Furosemide 40 Mg Tablet mg,NA,tablet E,Daily,NA,2 times daily,Daily after breakfast,Daily as needed,See admin instructions,3 times daily,Every morning,As needed,Once as needed
101 2811 377 Acetaminophen 325 Mg Tablet mg,NA,tablet E,Every 8 hours,NA,Every 6 hours PRN,Every 6 hours,Every 4 hours PRN
688 2778 256 Aspirin 81 Mg Tablet,Delayed Release mg,NA,tablet E,Daily,NA,2 times daily

Vitals

Observations: 618579
Unique Patients: 482
Unique Visits: 16048
Unique Visits per PAT_NUM:
 Mean Median Min Max   SD
 33.3     19   1 210 37.1
                 
Date Variable Summary:
   DATE_TIME   
 Min.   :2013  
 1st Qu.:2014  
 Median :2016  
 Mean   :2016  
 3rd Qu.:2017  
 Max.   :2019  
                 
                 
                 
General Summary Table: excludes missing (NA) data for each variable
                           
                            Overall         
  n                          618579         
  DATE_TIME (mean (sd))     2015.68 (1.76)  
  TEXT_VALUE = E (%)         618579 (100.0) 
  NUMERIC_VALUE (mean (sd))   86.89 (42.23) 
  UNITS (%)                                 
     BPM                     256044 ( 41.4) 
     F                        48798 (  7.9) 
     in                       13092 (  2.1) 
     kg/m^2                   12954 (  2.1) 
     m^2                      13308 (  2.2) 
     mmHg                    248155 ( 40.1) 
     pounds                   26228 (  4.2) 

Top 15 Frequent Vitals - Numeric
VITAL_CODE n Unique_Patients Mean Median Max Min SD VITAL_DESC TEXT_VALUE UNITS
PULSE 141440 481 80.59 78.00 232.00 20.00 18.78 Heart Rate,Pulse E BPM
BP_SYSTOLIC 98248 481 124.96 123.00 265.00 0.00 24.32 Systolic E mmHg
BP_DIASTOLIC 84296 481 71.58 71.00 245.00 0.00 17.24 Diastolic E mmHg
MAP 65611 449 86.30 85.00 227.00 0.00 17.89 Mean Arterial Pressure E mmHg
TMP 48798 476 98.13 98.10 107.50 56.40 1.77 Temperature E F
SPO2_PULSE 45259 438 80.24 77.00 6868.00 0.00 39.32 Heart Rate by pulse oximetry E BPM
RR 39954 474 18.58 18.00 75.00 0.00 6.30 Respiration Rate E BPM
SPO2 29391 443 95.47 96.00 101.00 0.00 5.10 SPO2 E BPM
WT 26228 482 195.10 189.20 1471.80 0.10 48.12 Weight E pounds
BSA 13308 478 2.02 2.02 3.14 0.04 0.27 Body Surface Area E m^2
HT 13092 479 67.34 67.01 83.50 2.05 4.35 Height E in
ORIGINAL_BMI 12954 472 29.67 28.64 241.60 0.01 7.54 BMI E kg/m^2

Smoking

Smoking sheet not included in the data extraction

Processing Time

Processing Time: 1.38 mins