Data Dictionary

This is a list of some of the most relevant tables and columns from our data sources. Aggregate counts of these fields is available through ACT-i2b2, and more detailed information from patient records can be provided upon request. (with appropriate IRB approval)

Patient counts last updated: 2022-01-12

Demographics - Total number of records (4979349)

ColumnUnique ValuesTop 5 Most Common Values

Race

 11
 Caucasian (1477425, 29%)
Other (1379896, 27%)
African american (776497, 15%)
Latin american (432767, 8%)
Unknown (394370, 7%)

Sex

 4
 F (2752275, 55%)
M (2217574, 44%)
U (4785, 0%)
I (4601, 0%)
Null (114, 0%)

Is Deceased

 2
 N (4942522, 99%)
Y (36818, 0%)
Null (9, 0%)

Marital Status

 9
 Unknown (1699403, 34%)
Single (1379456, 27%)
Married (1117045, 22%)
Null (536932, 10%)
Divorced (134540, 2%)

Appointments - Total number of records (14751928)

ColumnUnique ValuesTop 5 Most Common Values

Status

 8
 Arrived (8648274, 58%)
Canceled (3927560, 26%)
No show (1330910, 9%)
Bumped (634443, 4%)
Pending (174774, 1%)

Type

 1590
 Est (3338124, 22%)
New (1792863, 12%)
Fup (1623866, 11%)
Pop (547167, 3%)
Ecl (422592, 2%)

Department

 163
 Orthopaedic surgery (3189569, 21%)
Family & community medicine (1375985, 9%)
General ob/gyn (819604, 5%)
Im general medicine (494350, 3%)
Dermatology (487471, 3%)

Location

 286
 Hermann professional building (4370478, 29%)
Memorial hermann medical plaza (761237, 5%)
Houston medical center (460957, 3%)
Utp bayshore clinic (452773, 3%)
Bellaire clinic (389765, 2%)

Billing Location

 58
 Blank (12638990, 85%)
Utp sports medicine institute (356332, 2%)
Utp mhh medical plaza (338159, 2%)
Utp bellaire multi specialty clinic (163146, 1%)
Utp katy clinic (133294, 0%)

Immunizations - Total number of records (3026214)

ColumnUnique ValuesTop 5 Most Common Values

Body Site - Site of injection

 35
 Blank (2332584, 77%)
Left thigh (170648, 5%)
Left deltoid (149728, 4%)
Right thigh (130773, 4%)
Right deltoid (90292, 2%)

Dose

 1485
 0 (1514348, 50%)
Blank (804918, 26%)
0.5 (303597, 10%)
0.5ml (128132, 4%)
0.5 ml (72302, 2%)

Name

 326
 Pneumo (7val) (172582, 5%)
Dtap, unspecified formulation (166546, 5%)
Ipol injection injectable (116924, 3%)
Hepatitis b, pediatric/adolescent dosage (115624, 3%)
Hib, haemophilus influenzae type b vaccine, prp-t conjugate (95517, 3%)

Labs - Total number of records (55316173)

ColumnUnique ValuesTop 5 Most Common Values

Where Performed

 233
 Memorial hermann labs (27345859, 49%)
Quest diagnostics - houston (12368901, 22%)
Memorial hermann lab (5953276, 10%)
Labcorp houston (4666050, 8%)
In office (1895649, 3%)

Name

 18170
 Bun/creatinine ratio (760777, 1%)
Mcv (739162, 1%)
Mch (739136, 1%)
Rdw (739109, 1%)
Mchc (735488, 1%)

Panel Name

 10175
 Comprehensive metabolic panel (11049348, 19%)
Cbc (includes diff/plt) (8043489, 14%)
Differential (4887943, 8%)
Urinalysis, complete (2216250, 4%)
Lipid panel (2142880, 3%)

Medications - Total number of records (23919343)

ColumnUnique ValuesTop 5 Most Common Values

Status

 11
 Filled rx (20538371, 85%)
Other (2107560, 8%)
Active (1025076, 4%)
Refill denied (104765, 0%)
Administered (92706, 0%)

Units

 22
 Blank (12950957, 54%)
Daily (5753537, 24%)
Twice daily (2354081, 9%)
Bedtime (1038090, 4%)
3 times daily (707221, 2%)

Dose

 631
 0 (14024196, 58%)
1 (5003108, 20%)
Blank (2808810, 11%)
2 (1046028, 4%)
3 (292240, 1%)

Refill

 73
 0 (12870409, 53%)
1 (3419366, 14%)
3 (3279766, 13%)
2 (1738736, 7%)
5 (977863, 4%)

Route of Admin

 38
 Oral (19139892, 80%)
External (735644, 3%)
Inhalation (661086, 2%)
Subcutaneous (635028, 2%)
Blank (441081, 1%)

Disposition

 4
 R (19057629, 79%)
Rt (4538717, 18%)
Doca (223283, 0%)
Reqa (99714, 0%)

Pharmacy

 10049
 Wal-mart pharmacy 1364 (6531296, 27%)
Express scripts home delivery (419716, 1%)
Optumrx mail service (217326, 0%)
Cvs caremark mailservice pharmacy (215408, 0%)
Cvs/pharmacy #3699 (212369, 0%)

Prescribe Action

 11
 Send to retail (15746050, 65%)
Record (4585236, 19%)
Print rx (1635480, 6%)
Send to mail order (1300629, 5%)
Request administration (321192, 1%)

Name

 38654
 No reported medications (310141, 1%)
Tramadol hcl - 50 mg oral tablet (217755, 0%)
Fluticasone propionate 50 mcg/act nasal suspension (213856, 0%)
Meloxicam 15 mg oral tablet (165451, 0%)
Azithromycin 250 mg oral tablet (163759, 0%)

Site

 207
 Family practice - bellaire (1641221, 6%)
Family practice - bayshore (1225914, 5%)
Family medicine - texas medical center (1160908, 4%)
Multispecialty - bellaire (1140192, 4%)
Neurology - texas medical center (1046729, 4%)

Vitals - Total number of records (39094514)

ColumnUnique ValuesTop 5 Most Common Values

Class Name

 74
 Height weight bmi bsa (17614748, 45%)
Blood pressure (8085788, 20%)
Pulse (4245667, 10%)
Temperature (2715162, 6%)
Respiration (1721741, 4%)

Name

 355
 Weight (4306423, 11%)
Systolic (4042899, 10%)
Diastolic (4042893, 10%)
Height (3878539, 9%)
Bmi calculated (3774385, 9%)

Mod1 - Extra information for the test

 32
 Blank (29317393, 74%)
Lue (3579789, 9%)
Rue (2031133, 5%)
Oral (1151959, 2%)
Tympanic (636492, 1%)

Mod2 - Extra information for the test

 4
 Blank (33325805, 85%)
Sitting (5579756, 14%)
Supine (109886, 0%)
Standing (79067, 0%)

Invoices - Total number of records (35662696)

ColumnUnique ValuesTop 5 Most Common Values

FSC

 362
 Medicare (2809242, 7%)
Blue cross blue shield blue cho (2212635, 6%)
Indigent care (1937506, 5%)
Cmd collection agency (1779666, 4%)
Hchd pilot indigent 100% (1767398, 4%)

Original FSC - FSC provided at registration

 403
 Medicare (4887869, 13%)
Blue cross blue shield blue cho (2772859, 7%)
Self pay (2075308, 5%)
Indigent care (1944682, 5%)
Hchd pilot indigent 100% (1673268, 4%)

Provider Location - UT physicians are under MSRDP

 5
 Msrdp (24011183, 67%)
Hchd (11650685, 32%)
Internal medicine (613, 0%)
Administrative unapp account (120, 0%)
Null (93, 0%)

Division

 26
 Radiology (7979565, 22%)
Internal medicine (5917592, 16%)
Family practice (4318419, 12%)
Pediatrics (3336334, 9%)
Orthopaedic surgery (2602912, 7%)

Billing Area

 509
 Rad-routine-4 (3060833, 8%)
Fam-fam prac ambulatory-lbj-4 (2185023, 6%)
Ortho-general services-4 (2009520, 5%)
Pedi-general-4 (1247592, 3%)
Rad-ct-4 (1013031, 2%)

Category

 7
 Outpatient (20997841, 58%)
Inpatient (9892677, 27%)
Emergency room (4501313, 12%)
Null (268753, 0%)
Msrdp (1235, 0%)

Location

 795
 Ip mhh (6218237, 17%)
Utp hpb clinic (3109885, 8%)
Op lyndon b johnson (2460201, 6%)
Er mhh (2362701, 6%)
Er lbj (2016845, 5%)

Provider

 4596
 Robinson md,lawrence h (312753, 0%)
Jarolimek md,amanda (304850, 0%)
Ferguson md,emma c (244773, 0%)
West md,o clark (243789, 0%)
Taegtmeyer md,heinrich (236171, 0%)

Referring Provider

 43580
 Null (13128703, 36%)
Safi md ut,hazim jawad (144683, 0%)
Kar md ut,biswajit (120296, 0%)
Robinson md ut,david j (111477, 0%)
Mcgarvey md ut,william c (106322, 0%)

Diagnosis 1 - The primary diagnosis

 47267
 786.50 (580420, 1%)
V20.2 (454353, 1%)
401.9 (397026, 1%)
V22.1 (285663, 0%)
I10 (281380, 0%)

Diagnosis 2

 44748
 Null (16079332, 45%)
401.9 (436614, 1%)
I10 (363424, 1%)
Z23 (195634, 0%)
272.4 (194583, 0%)

Diagnosis 3

 38431
 Null (24971571, 70%)
401.9 (255688, 0%)
I10 (226013, 0%)
272.4 (172592, 0%)
250.00 (129071, 0%)

Diagnosis 4

 31809
 Null (30761112, 86%)
I10 (124535, 0%)
401.9 (75297, 0%)
E78.5 (58867, 0%)
Z23 (50942, 0%)

Diagnosis 5

 23940
 Null (33604560, 94%)
I10 (63489, 0%)
Z23 (35461, 0%)
E78.5 (31385, 0%)
E11.9 (27633, 0%)

Diagnosis 6

 19454
 Null (34483513, 96%)
I10 (32163, 0%)
Z23 (22649, 0%)
E78.5 (16142, 0%)
E11.9 (13724, 0%)

Diagnosis 7

 15345
 Null (34973042, 98%)
I10 (16105, 0%)
Z23 (13615, 0%)
G89.29 (10114, 0%)
E78.5 (8490, 0%)

Diagnosis 8

 12205
 Null (35258223, 98%)
I10 (7963, 0%)
Z23 (7843, 0%)
G89.29 (7388, 0%)
Z79.4 (6438, 0%)

Diagnosis 9

 8332
 Null (35474633, 99%)
G89.29 (4961, 0%)
Z23 (4724, 0%)
Z79.4 (4051, 0%)
I10 (3154, 0%)

Diagnosis 10

 6252
 Null (35552128, 99%)
Z23 (3946, 0%)
G89.29 (3302, 0%)
Z79.4 (2771, 0%)
E11.65 (1525, 0%)

Transactions - Total number of records (48733470)

ColumnUnique ValuesTop 5 Most Common Values

CPT Code

 8847
 99213 (4889329, 10%)
99214 (2643537, 5%)
99232 (1692660, 3%)
71010 (1670191, 3%)
Null (1618521, 3%)

Transaction Type

 28
 Evaluation and management (21248640, 43%)
Radiology (9938523, 20%)
Medicine (7182476, 14%)
Surgery (3784142, 7%)
Anesthesia (1128955, 2%)