MS Office Integration Project

ParticipantID	PatientID	ProviderID	StudyID
T370	47	P114	S2057
T371	54	P131	S2057
T380	11	P114	S2079
T381	12	P102	S2079
T382	31	P119	S2079
T384	55	P124	S2079
T385	41	P119	S2079
T386	64	P124	S2079
T387	38	P124	S2079
T388	61	P131	S2079
T390	9	P138	S2079
T391	32	P107	S2079
T392	57	P124	S2079
T400	56	P102	S2091
T401	3	P114	S2091
T403	21	P131	S2091
T404	8	P124	S2091
T405	12	P102	S2091
T406	19	P119	S2091
T407	59	P131	S2091
T408	26	P102	S2091
T409	44	P145	S2091
T411	18	P138	S2091
T420	27	P102	S2104
T421	30	P119	S2104
T422	52	P131	S2104
T423	28	P124	S2104
T424	4	P107	S2104
T426	50	P114	S2104
T429	48	P145	S2104
T431	1	P102	S2104
T432	29	P131	S2104
T433	49	P138	S2104
T434	55	P124	S2104
T435	18	P138	S2104
T436	39	P119	S2104
T440	34	P107	S2116
T441	16	P131	S2116
T442	7	P145	S2116
T444	40	P102	S2116
T445	2	P140	S2116
T446	63	P102	S2116
T448	13	P145	S2116
T450	6	P138	S2116
T451	22	P124	S2116
T453	41	P119	S2116
T454	23	P119	S2116
T455	17	P145	S2116
T456	57	P124	S2116
T457	26	P102	S2116
T458	65	P102	S2116
T459	44	P145	S2116
T460	14	P107	S2116
T461	24	P140	S2116
T470	61	P145	S2127
T471	4	P107	S2127
T472	62	P114	S2127
T473	64	P124	S2127
T475	59	P131	S2127
T476	18	P138	S2127
T477	46	P119	S2127
T478	21	P131	S2127
T480	40	P102	S2127
T481	51	P124	S2127
T490	5	P131	S2131
T491	22	P114	S2131
T492	53	P138	S2131
T494	25	P119	S2131
T495	47	P114	S2131
T497	54	P131	S2131
T498	11	P114	S2131
T499	12	P102	S2131
T500	31	P119	S2131
T501	55	P124	S2131
T503	38	P124	S2131
T504	9	P138	S2131
T506	32	P107	S2131
T508	56	P102	S2131
T509	8	P124	S2131
T510	19	P119	S2131
T511	42	P114	S2131
T512	20	P107	S2131
T515	58	P102	S2131
T516	10	P124	S2131
T302	42	P102	S2011
T303	20	P107	S2011
T305	41	P119	S2011
T306	58	P102	S2011
T307	50	P114	S2011
T309	57	P124	S2011
T310	61	P131	S2011
T312	3	P114	S2011
T313	36	P102	S2011
T315	35	P131	S2011
T316	64	P124	S2011
T318	59	P131	S2011
T319	63	P102	S2011
T320	45	P107	S2011
T321	21	P131	S2011
T322	27	P102	S2011
T323	22	P114	S2011
T330	43	P145	S2024
T331	7	P145	S2024
T332	33	P140	S2024
T334	30	P119	S2024
T335	13	P145	S2024
T337	37	P119	S2024
T338	24	P140	S2024
T339	14	P145	S2024
T341	17	P145	S2024
T342	23	P119	S2024
T350	50	P114	S2057
T351	4	P107	S2057
T353	35	P131	S2057
T354	59	P131	S2057
T356	18	P138	S2057
T357	63	P102	S2057
T358	45	P107	S2057
T360	46	P119	S2057
T361	21	P131	S2057
T362	40	P102	S2057
T364	51	P124	S2057
T365	5	P131	S2057
T366	22	P124	S2057
T367	53	P138	S2057
T369	25	P119	S2057

PatientID	LastName	FirstName	Gender	DOB	Street	City	State	Zip	Phone
1	Gomez	Manuel	M	1990-04-02	2119 W Dayton St	Columbia	MD	20588	2405554431
2	Duley	Rhoda	F	1993-07-17	3545 N Burke Rd	Columbia	MD	21044	3015555602
3	Levy	Andrew	M	1958-09-24	110 S Aspen Ct	Columbia	MD	21075	3015555108
4	Levy	Jennifer	F	1959-03-24	110 S Aspen Ct	Columbia	MD	21075	3015555110
5	Li	Deng	M	1975-01-16	1240 E Galway Dr	Columbia	MD	21150	4105556531
6	Engleberger	Todd	M	1994-06-14	3905 Meadow Dr	Columbia	MD	21044	4435557188
7	Suarez	Maria	F	2010-03-27	8530 Mayo Ave	Ellicott City	MD	21150	4435555734
8	Suarez	Liliana	F	1985-08-30	8530 Mayo Ave	Ellicott City	MD	21150	4435555734
9	Suarez	Omar	M	1983-07-05	8530 Mayo Ave	Ellicott City	MD	21150	4435551361
10	Curwick	Lawrence	M	1954-12-12	1324 E Upland Rd	Columbia	MD	20588	2405559284
11	La Haye	Janelle	F	1980-10-04	716 N Roblyn Pl	Columbia	MD	21075	3015554432
12	Wimmer	Daniel	M	1980-12-05	716 N Roblyn Pl	Columbia	MD	21075	3015552412
13	Torres	Luis	M	2000-04-13	3791 W Tuileen Rd	Columbia	MD	21150	3015555832
14	Severson	Renee	F	1998-10-24	1280 S Gils Way	Columbia	MD	21044	4105552125
15	Bohn	Warren	M	2006-11-16	24 High Woods Ln	Savage	MD	20794	3015551524
16	Bohn	Robin	F	1993-03-06	24 High Woods Ln	Savage	MD	20794	3015551524
17	Quam	Amanda	F	1997-05-24	1452 N Wickham Ave	Columbia	MD	21150	4105552450
18	Shen	Junjiang	M	1963-02-14	1433 S Baxter	Columbia	MD	21044	4435551761
19	Petri	Carrie	F	1986-10-05	117 S Aspen Ct	Columbia	MD	21075	3015552724
20	Windelborn	Mitchell	M	1950-01-10	2523 E Carrolltown Ln	Columbia	MD	20588	2405552901
21	Maradiagan	Sathsivam	M	1967-04-22	4904 W Gordon Dr	Columbia	MD	21075	3015552087
22	Hamdan	Kamal	M	1975-06-07	1860 N Chestnut Way	Columbia	MD	20794	4105551110
23	Jaworski	Maya	F	1994-11-01	410 E Lincoln Pl	Columbia	MD	21075	3015550788
24	Hulsey	Heather	F	1999-04-25	6971 W Glenway	Ellicott City	MD	21150	4435556973
25	Khoury	Sida	M	1978-12-23	8731 E Woodburn	Columbia	MD	21044	3015557005
26	Marquez	Gilberto	M	1987-06-11	1819 S Baxter	Columbia	MD	21044	4105550809
27	Johnson	Leanne	F	1969-01-26	545 W Monroe Ct	Columbia	MD	21075	3015553747
28	Purcell	Melissa	F	1988-08-14	1976 N Farrell Dr	Columbia	MD	20588	2405555525
29	Bowden	Anne	F	1990-09-20	1323 E Scott Ave	Columbia	MD	20588	3015559198
30	Calcari	April	F	2003-10-20	175 N Woods	Columbia	MD	21044	4435557253
31	McCormick	Patrick	M	1981-07-18	2113 N Henry St	Columbia	MD	21075	2405552749
32	McCormick	Theresa	F	1983-09-25	2113 N Henry St	Columbia	MD	21075	2405552749
33	McCormick	Kerry	M	2004-09-14	2113 N Henry St	Columbia	MD	21075	2405552749
34	Lin	Tien-Min	M	1992-11-07	1630 N Linden St	Columbia	MD	20794	3015551626
35	Wilfong	Tanya	F	1960-07-03	5524 W Fall Oaks	Columbia	MD	21150	4435550177
36	Blystone	Valerie	F	1958-10-09	973 E Grove Rd	Columbia	MD	21044	4105554879
37	Nikolai	Alex	M	2000-02-18	455 E Warbler Way	Columbia	MD	20588	3015555611
38	Samatar	Delia	F	1982-04-21	1624 W Sawyer Rd	Columbia	MD	21044	4435550257
39	Gutag	Arvid	M	1992-07-08	418 S Jason St	Ellicott City	MD	21150	4105557048
40	Tian	Linzhu	M	1970-11-14	1490 N Park St	Columbia	MD	21044	3015554498
41	Lamont	Bradley	M	1950-04-22	902 N Henry St	Columbia	MD	21075	3015551556
42	Andrews	John	M	1948-03-01	645 Valley Rd	Savage	MD	20794	3015551377
43	Gui	Mina	F	2010-12-16	5514 S Randall Dr	Columbia	MD	21075	2405559113
44	Gui	Sonja	F	1987-12-18	5514 S Randall Dr	Columbia	MD	21075	2405559113
45	Preidecker	Howard	M	1964-09-02	701 E Sky View Pl	Columbia	MD	20588	4435557140
46	Swain	David	M	1966-11-09	1655 N Plains Rd	Columbia	MD	20794	3015559797
47	Koratko	Keshena	F	1980-05-12	902 S Holliday Dr	Columbia	MD	21044	4105550520
48	Hoffman	Charity	F	1989-01-17	1417 E Erwood	Columbia	MD	20588	3015556724
49	Jackson	Verilee	F	1991-06-24	2823 W Glenwood	Columbia	MD	21044	3015551601
50	Jaimez	Nestor	M	1951-02-08	840 W Violet Ln	Columbia	MD	21150	4435553344
51	Shamji	Naveed	M	1971-11-02	3704 W Glenway	Ellicott City	MD	21150	3015552392
52	Thurow	Alice	F	1988-03-14	139 E Hollyhock Way	Columbia	MD	20588	3015557403
53	Hidalgo	Rocio	M	1978-07-19	109 S Maria Pl	Columbia	MD	21075	4435555617
54	Hidalgo	Irena	F	1980-08-03	109 S Maria Pl	Columbia	MD	21075	4435550344
55	Fullenkamp	Susan	F	1981-10-14	1584 W Lake Rd	Columbia	MD	21044	3015553186
56	Sallah	Diana	F	1984-09-10	214 S Pearl St	Columbia	MD	20588	3015550043
57	Amberson	Darlene	F	1953-04-20	1433 E Cypress St	Columbia	MD	21075	2405551343
58	Josephson	Herb	M	1950-06-13	1238 N Cardinal Dr	Columbia	MD	20794	3015556514
59	Stanton	James	M	1962-09-28	1433 W Ridge Rd	Columbia	MD	20588	3015551882
60	Renneburg	Debra	F	1956-07-10	2308 S Pine St	Columbia	MD	20588	3015554467
61	Harmon	Linda	F	1954-04-22	4415 E Shady Way	Columbia	MD	21150	4435551603
62	Gray	Sheila	F	1961-11-11	3011 S Shorewood Rd	Columbia	MD	21075	3015558466
63	Tham	Chee	F	1963-10-02	726 E Vernon Rd	Columbia	MD	20588	3015556173
64	Wanninger	Hilde	F	1962-01-16	6170 N Bayridge St	Columbia	MD	21044	2405550887
65	Ortega	Victor	M	1997-07-05	1381 S Pleasant St	Columbia	MD	20588	4435556264

ProviderID	ProviderFirst	ProviderLast	Degree	DepartmentID
P102	Elena	Ortiz	MD	D500
P107	Dale	Klug	MD
P114	Robert	Hatzinger	MD
P119	Tanesha	Shahidi	NP
P124	Ashley	Togstad	MD
P131	Gerard	Mero	MD
P138	Gloria	Hernandez	RN
P140	Antero	Garcia	RN
P145	Faye	Vancleave	PA

StudyID	StudyName	StartDate	EndDate	MinParticipants	MaxParticipants
S2011	Arthritis	2019-01-16	2019-07-16	15	50
S2024	Asthma	2019-03-01	2019-12-01	10	50
S2057	Cholesterol	2019-06-15	2019-12-15	15	35
S2079	Diabetes	2019-08-01	2019-02-01	10	25
S2091	Chronic Pain	2020-01-20	2020-06-20	10	50
S2104	Hearing Loss	2020-02-01	2020-08-01	10	25
S2116	Migraine	2020-02-15	2021-02-15	15	50
S2127	Thyroid	2020-03-01	2020-08-01	10	30
S2131	Hypertension	2020-06-01	2021-06-01	15	50