access help

profileivyleague
20201102185645fall_2020_access_1__doc_n_the_box___data__1_.xlsx
Home>Computer Science homework help>access help

Patients

Patient ID First Name Last Name Phone Date of Birth Gender Health Plan Allergies
19 Dusty Springfield (435) 693-1212 4/5/1990 F H0971 Codeine derivatives, merperidine
10 Jonathan Cardenas (928) 551-5547 8/22/94 M H1695 Peanuts
23 Jennifer Holiday (928) 888-3545 11/21/1989 F H1205
18 Anders Kroll (505) 499-6541 9/11/94 M H10119 Penicillin
14 Mary Ambrose (435) 444-1233 4/15/90 F H10119 Shellfish
15 Gina Mercado (970) 514-3212 6/17/89 F H0971 Morphine
4 Steven Nuggent (435) 122-4545 10/12/1986 M H1941 Penicillin
11 Paula Hargus (505) 744-1889 6/11/90 F H1205
22 Jose Hargus (505) 498-6478 6/30/1987 M H1695 Morphine, morphine derivatives
24 Kimberley Smith (928) 647-2477 1/16/1989 F H10119
20 Kevin Bacon (435) 477-8989 6/22/1990 M H1941
21 Cesar Romero (970) 631-2222 1/14/1987 M H3410 Peanuts
1 Ted Williams (970) 644-1214 12/11/94 M H0971 Pine Tar
17 Maria Gabel (970) 223-4157 8/12/90 F H1205 Penicillin
8 Sonia Cardenas (928) 551-5547 4/12/1988 F H3410 Penicillin, cephalosporins
25 Anton Scallia (515) 246-4579 6/22/84 M H4567 Heart Medication
26 John Hopkins (202) 456-7891 6/13/92 M H4567 Chicken
27 Amy Wolf (212) 789-1456 9/13/92 F H9785 Codeine derivatives, merperidine
28 Diane Keaton (456) 789-1456 12/12/90 F H4567

Doctors

Doctor ID First Name Last Name Phone
D1 David Warric (435) 321-4789
D3 Patricia Loke (435) 189-9874
D5 Gene Allen (435) 887-1818
D12 Lawrence Small (435) 821-1263
D2 Roxanna Freitag (505) 884-0542
D13 Samual Earnest (515) 735-4563
D4 Robert Gramann (928) 449-4174
D9 Sara Jurski (505) 884-0542
D11 James Trehass (928) 888-4178
D6 Antonio Westenberg (928) 488-1741
D8 Joshua Wilson (435) 887-1818
D7 Gunther Zamarron (970) 429-7475

Drugs

UPN Name Generic? Description Unit Dosage Dosage Form Price/Volume
102 Ampicillin TRUE Antibiotic Pill 250 mg $1.45
121 Tolbutamide FALSE Bacterial infections Pill 2 mg $0.90
224 Avatocin FALSE Allergies Pill 100 mg $1.40
247 Acebutolol hydrochloride FALSE Arthritis Pill 400 mg $1.10
256 Dseurton TRUE High blood pressure Pill 175 mg $1.20
289 Levothyroxine TRUE Thyroid disorders Pill 25 mg $1.40
311 Dyotex FALSE Tonsillitis Bottle 2 tsp $1.05
366 Phalastat FALSE Allergies Bottle 1 tsp $1.60
398 Clonazepam FALSE Epiliepsy Pill 4 mg $1.20
412 Epronix FALSE Pain Pill 500 mg $1.50
444 Syocil TRUE Diabetes Pill 120 mg $1.10
452 Diazapam TRUE Anxiety Pill 5 mg $1.12
467 Glimepiride TRUE Diabetes Pill 2 mg $0.90
523 Xeroflarol TRUE Acid reflux Bottle 1 tsp $1.05
524 Cefixime TRUE Antihistamine Pill 400 mg $1.60
566 Quentix TRUE High blood pressure Pill 50 mg $1.25
587 Haloperidol FALSE Diuretic Pill 6 mg $1.30
622 Tiron FALSE Beta blocker Pill 150 mg $1.30
642 Montelukast sodium TRUE Acne Pill 10 mg $0.90
644 Hyometadol FALSE Asthma Bottle 2 tsp $1.35
654 Warfarin Sodium TRUE Bronchitis Pill 4 mg $1.40
711 Nvalax TRUE Depression Pill 200 mg $0.90
732 Albuterol Sulfate TRUE Asthma Pill 2 mg $0.95
741 Almotriptan TRUE Conjunctivitis Pill 6.25 mg $0.87
828 Myobuterol TRUE Antibiotic Bottle 1 tsp $1.60
852 Oxaprozin TRUE Anti-inflammatory Pill 1200 mg $1.25
878 Didanosine TRUE Sinus infection Pill 200 mg $1.12
932 Tvalaxec TRUE Antihistamine Bottle 2 tsp $1.00
972 Rivastigmine tartrate TRUE ADHD Pill 4.4 mg $1.05
987 Rizatriptan Benzoate FALSE Pain Pill 6 mg $1.10

Health Plans

Plan ID# Plan Name Address City State Zip Phone
H1205 WeCare Health Management 269 Monument Ave Richmond VA 23223 (804) 477-9899
H10119 Claytor Lake Community Health 11112 W. University Dr. Radford VA 24141 (540) 741-4545
H0971 Medicare 7500 Security Blvd. Alexandria VA 22301 (703) 411-1414
H1941 Southern Appalachian Mountains Health Plan 99 Blue Ridge Parkway Front Royal VA 22630 (540) 540-8742
H3410 Great American Mid-Atlantic Health 4200 Hwy 123 S. Fairfax VA 22030 (703) 177-9184
H1695 Dismal Swamp Health 32111 Swamp Park Place Suffolk VA 23434 (757) 654-2425
H4567 Great Southern Health 1289 Okifinoki Way Dulles VA 22124 (757) 781-2431
H9785 Piedmont Medical Insurance Plan 456 Main Street Fairfax VA 22180 (703) 654-1234

Refills

Prescription ID Refill Date
12 1/3/11
5 1/12/11
20 1/16/11
26 2/1/11
16 2/14/11
21 2/14/11
24 2/15/11
17 2/21/11
5 3/11/11
10 3/11/11
27 3/14/11
8 3/18/11
2 4/14/11
9 4/14/11
7 5/14/11
21 5/16/11
2 6/1/11
8 6/1/11
6 6/3/11
23 6/11/11
4 6/21/11
10 6/21/11
3 7/1/11
6 8/25/11
23 9/18/11
9 10/11/11
1 12/11/11
15 4/22/12
14 6/10/12
13 6/23/12
17 8/1/12
24 9/1/12
19 9/12/12
13 9/29/12
11 11/1/12
15 11/13/12
16 11/16/12
13 11/30/12
19 12/14/12
18 12/23/12
21 12/23/12
26 12/31/12
28 9/14/12
31 12/1/12

Rx

Prescription ID UPN Quantity Unit Volume in prescription Date Expire Date Refills Authorized Auto Refill? Refills Used Instructions Patient ID Doctor
9 102 1 mg 20 6/29/12 6/14/13 4 TRUE 2 1 pill every 4 hours 10 D6
26 102 1 mg 15 5/2/12 10/30/13 3 TRUE 0 1 pill every 5 hours with food 1 D3
15 224 1 mg 40 9/10/11 6/10/13 2 TRUE 0 1 pill every 6 hours 11 D7
22 247 1 mg 50 1/16/12 12/18/13 0 TRUE 0 2 pills daily 14 D9
1 256 1 mg 24 1/10/11 10/24/12 2 TRUE 0 2 pills every 12 hours 22 D2
12 311 1 ml 15 7/17/11 3/9/13 3 TRUE 0 2 teaspoons full every 4 hours 8 D4
17 311 1 ml 15 9/24/11 11/25/13 4 TRUE 0 2 teaspoons full every 4 hours 1 D11
5 366 1 ml 20 4/15/11 10/3/13 3 TRUE 0 3 teaspoons full every 6 hours 1 D8
24 366 1 ml 30 5/2/12 12/15/13 3 FALSE 0 2 teaspoons full every 6 hours 19 D4
25 366 1 ml 10 2/2/12 12/15/13 0 FALSE 0 2 teaspoons full every 6 hours 19 D5
4 398 1 mg 100 4/15/11 6/11/13 4 TRUE 1 1 pill every 5 hours with food 18 D2
7 398 1 mg 70 5/16/11 7/11/13 4 TRUE 0 1 pill every 5 hours with food 17 D6
16 398 1 mg 12 9/10/11 9/12/13 3 TRUE 1 2 pills every 6 hours with food 4 D8
2 444 1 mg 18 2/24/11 11/20/13 4 TRUE 0 2 pills every 6 hours with food 21 D7
21 523 1 ml 20 1/14/12 8/19/13 3 TRUE 1 2 teaspoons full every 5 hours 4 D11
11 642 1 mg 80 7/8/12 1/6/14 4 TRUE 0 2 pills daily 21 D3
8 711 1 mg 80 6/21/11 7/30/13 5 FALSE 0 2 pills daily 22 D4
20 711 1 mg 80 10/6/12 8/9/13 3 FALSE 1 2 pills daily 24 D5
10 732 1 mg 24 7/6/11 6/24/13 4 TRUE 0 2 pills every 5 hours as needed 23 D8
14 732 1 mg 30 8/14/11 7/31/13 4 TRUE 0 2 pills every 6 hours 18 D9
3 828 1 ml 100 3/14/11 1/22/14 2 TRUE 0 1 teaspoon every 4 hours 11 D1
13 828 1 ml 75 8/13/11 7/14/13 5 TRUE 2 1 teaspoon every 4 hours 23 D4
19 828 1 ml 70 12/15/11 12/11/13 3 FALSE 1 1 teaspoon every 4 hours 15 D1
6 878 1 mg 24 5/1/11 9/18/13 4 TRUE 1 2 pills every 4 hours with food 20 D7
27 878 1 mg 24 6/13/12 12/12/13 2 TRUE 0 2 pills every 4 hours with food 14 D3
18 932 1 ml 70 9/24/12 7/16/13 3 TRUE 0 1 teaspoon every 6 hours 17 D3
23 932 1 ml 80 1/24/12 9/22/13 2 TRUE 1 1 teaspoon every 6 hours 11 D11
29 654 1 mg 40 6/12/12 9/11/13 0 TRUE 0 2 pills daily 27 D13
28 121 2 mg 10 8/12/12 1/31/14 6 FALSE 2 1 pill every 6 hours 25 D12
31 398 1 mg 20 10/1/12 6/15/13 2 TRUE 0 2 pills daily 26 D13
30 566 2 mg 30 3/7/12 6/15/14 0 FALSE 0 2 pills every 6 hours 28 D7