Microsoft Access

mt19941i24

EM-E2_New.accdb

Home >Computer Science homework help >Microsoft Access

BulbCatID	BulbCat	Description
1	Diagnostic	testing and instrumentational replacement lamps
2	Indoor	non-weather resistant artificial and subdued lighting
3	Outdoor	weather resistant artificial and subdued lighting
4	Surgical	medical and cosmetic treatment illumination lamps

ShapeID	BulbShape	Icon
1	A-line
2	Bare-Circuline
3	Bare-Mini-Spiral
4	Bare-Quadruple Tube
5	Bare-Spiral
6	Bare-Triple Tube
7	Bare-Twin Tube
8	Bayonet
9	Canister
10	Covered Bullet
11	Covered Globe
12	Covered Reflector
13	Covered-Candle
14	Dish
15	Double-Ended Tube
16	Single-Ended Tube

BulbTypeID	BulbType
1	CFL
2	Halogen
3	Incandescent
4	Mercury
5	Xenon

FacID	MgtID	FacName	FacTypeID	MgtTypeID	Address	City	State	ZIP	Region	PhoneNum	WebSite	MedicareNum	Beds	Revenue	ContactFirstName	ContactLastName	Discount
2	12	Cedars-Sinai Medical Center	7	11	8700 Beverly Boulevard	Los Angeles	ca	90048	4	(310) 423-3277	www.cedars-sinai.edu	050625	947	¤ 6,431,119,155.00	Bobby	Rankin	0.025
3	12	Takoma Regional Hospital	7	10	401 Takoma Avenue	Greeneville	tn	37743	6	(423) 639-3151	www.takoma.org	440050	108	¤ 113,273,388.00	Javier	Cleary	0.02
4	12	Littleton Adventist Hospital	7	11	7700 South Broadway	Littleton	co	80122	2	(303) 730-8900	www.littletonhosp.org	060113	172	¤ 634,967,733.00	Margaret	Warren	0.025
5	12	Shawnee Mission Medical Center	7	7	9100 West 74th Street	Shawnee Mission	ks	66204	1	(913) 676-2000	www.shawneemission.org	170104	319	¤ 1,136,859,930.00	Joan	Melzer	0.0
6	12	Florida Hospital Lake Placid	7	6	1210 U.S. Highway 27 North	Lake Placid	fl	33852	6	(863) 465-3777	www.fhhd.org			¤ 0.00	Anne	Morgan	0.0
7	12	Florida Hospital Apopka	7	6	201 North Park Avenue	Apopka	fl	32703	6	(407) 889-1000	www.floridahospital.com/AboutUs/Abo			¤ 0.00	Travis	Nelson	0.0
8	12	Florida Hospital Oceanside	7	10	264 South Atlantic Avenue	Ormond Beach	fl	32176	6	(386) 672-4146	www.floridahospitalormond.org/Conta	100068	337	¤ 523,738,207.00	Joanne	Roman	0.02
9	12	Florida Hospital East Orlando	7	6	7727 Lake Underhill Road	Orlando	fl	32822	6	(407) 303-8110	www.floridahospitaleast.com			¤ 0.00	Nicole	Lujan	0.0
10	12	Florida Hospital DeLand	7	10	701 West Plymouth Avenue	DeLand	fl	32720	6	(386) 943-4522	www.fhdeland.org	100045	156	¤ 352,336,310.00	Ronald	Ryan	0.02
11	12	Adventist Hinsdale Hospital	7	10	120 North Oak Street	Hinsdale	il	60521	5		www.keepingyouwell.com/ahh	140122	338	¤ 861,611,687.00	Hansuk	Sohn	0.02
12	12	Avista Adventist Hospital	7	11	100 Health Park Drive	Louisville	co	80027	2	(303) 673-1000	www.avistahosp.org	060103	114	¤ 217,035,117.00	Steven	Dunn	0.025
13	13	Christiana Hospital	7	11	4755 Ogletown-Stanton Road	Newark	de	19718	7	(302) 733-1000	www.christianacare.org	080001	1079	¤ 1,709,954,082.00	Dennis	Clason	0.025
14	14	Coler-Goldwater Specialty Hospital & Nursing Facility	3	2	One Main Street	Roosevelt Island	ny	10044	7	(212) 848-6000	www.nyc.gov/html/hhc/coler-goldwater/	332016	1025	¤ 191,683,002.00	Gerald	Flachs	0.0
15	15	Columbia Saint Mary's Hospital Milwaukee	7	11	2323 North Lake Drive	Milwaukee	wi	53211	5	(414) 291-1000	www.columbia-stmarys.com	520051	450	¤ 1,028,328,976.00	Melchor	Ortiz	0.025
16	16	Duke University Hospital	7	11	2301 Erwin Road	Durham	nc	27710	6	(919) 684-8111	www.dukehealth.org	340030	798	¤ 3,094,176,990.00	Conrad	Keyes	0.025
17	17	Emory University Hospital	7	11	1364 Clifton Road	Atlanta	ga	30322	6	(404) 712-2000	www.emoryhealthcare.org/emory-university-hospital-atlanta/index.html	110010	517	¤ 1,291,888,300.00	Henry	Saastamoinen	0.025
18	17	Doctors Hospital	7	10	5100 West Broad Street	Columbus	oh	43228	5	(614) 544-1000	www.ohiohealth.com/homedoctors.cfm?	360152	181	¤ 445,563,164.00	Yosikazu	DeRoos	0.02
19	17	Grant Medical Center	7	10	111 South Grant	Columbus	oh	43215	5	(614) 566-9000	www.ohiohealth.com/homegrant.cfm?id	360017	354	¤ 1,102,377,530.00	Susan	Wright	0.02
20	18	Emory University Hospital Midtown	7	11	550 Peachtree Street Northeast	Atlanta	ga	30308	6	(404) 686-4411	www.emoryhealthcare.org	110078	457	¤ 1,066,757,621.00	Owaissa	Heimann	0.025
21	19	Florida Hospital East Orlando	7	6	7727 Lake Underhill Road	Orlando	fl	32822	6	(407) 303-8110	www.floridahospitaleast.com			¤ 0.00	Heejung	Chun	0.0
22	20	Florida Hospital Orlando	7	11	601 East Rollins Street	Orlando	fl	32803	6	(407) 303-6611	www.flhosp.org	100007	1972	¤ 6,126,535,614.00	Tom	Heydman	0.025
23	21	Jackson South Community Hospital	7	6	9333 Southwest 152nd Street	Miami	fl	33157	6	(305) 251-2500	www.jhsmiami.org/landing.cfm?id=49			¤ 0.00	Leon	Williamson	0.0
24	21	Jackson Memorial Hospital	7	3	1611 Northwest 12th Avenue	Miami	fl	33136	6	(305) 585-1111	www.jhsmiami.org/landing.cfm?id=7	100022	1857	¤ 3,910,529,911.00	Shannon	Franklin	0.0
25	21	Jackson North Medical Center	7	6	160 Northwest 170th Street	North Miami Beach	fl	33169	6	(305) 651-1100	www.jhsmiami.org/landing.cfm?id=920			¤ 0.00	Sharon	Niemann	0.0
26	21	Forsyth Medical Center	7	11	3333 Silas Creek Parkway	Winston-Salem	nc	27103	6	(336) 718-5000	www.forsythmedicalcenter.org	340014	902	¤ 1,329,599,393.00	Joan	Felts	0.025
27	22	Gateway Rehabilitation Hospital	6	7	315 East Broadway	Louisville	ky	40202	6	(502) 315-8300	www.gatewayflorence.com	183031	40	¤ 7,554,043.00	Derek	Fisher	0.0
28	23	Fort Hamilton Hospital	7	11	630 Eaton Avenue	Hamilton	oh	45013	5	(513) 867-2000	www.forthamiltonhospital.com	360132	176	¤ 309,756,151.00	Kathleen	Barrett	0.025
29	23	Georgetown University Hospital	7	11	3800 Reservoir Road, Northwest	Washington	dc	20007	7	(202) 444-2000	www.georgetownuniversityhospital.org	090004	391	¤ 1,339,922,641.00	Connie	Watson	0.025
30	23	University Hospital	7	5	234 Goodman Street	Cincinnati	oh	45219	5	(513) 584-1000	www.universityhospitalcincinnati.co	360003	434	¤ 1,276,876,261.00	Andrew	Wiget	0.0
31	23	West Chester Medical Center	7	6	7700 University Drive	West Chester	oh	45069	5	(513) 298-3000	www.westchestermedcenter.com			¤ 0.00	John	Vogt	0.0
32	24	Grady Memorial Hospital	7	3	2220 Iowa Avenue	Chickasha	ok	73018	3	(405) 224-2300	www.gradymem.org	370054	99	¤ 101,617,790.00	Gerald	Vest	0.0
33	25	Grady Memorial Hospital	7	3	80 Jesse Hill Jr. Drive Southeast	Atlanta	ga	30303	6	(404) 616-1000	www.gradyhealthsystem.org	110079	937	¤ 1,275,321,274.00	Desh	Ranjan	0.0
34	26	Grady Memorial Hospital	7	10	561 West Central Avenue	Delaware	oh	43015	5	(740) 369-8711	www.ohiohealth.com	360210	61	¤ 144,660,445.00	David	Shubert	0.02
35	27	Greenville Memorial Hospital	7	5	701 Grove Road	Greenville	sc	29605	6	(864) 455-7000	www.ghs.org	420078	840	¤ 1,879,133,881.00	Joan	Purkey	0.0
37	29	Hahnemann University Hospital	7	7	Broad and Vine	Philadelphia	pa	19102	7	(215) 762-7000	www.hahnemannhospital.com	390290	478	¤ 3,042,361,457.00	Mihai	Niculescu	0.0
38	29	Memorial Hermann Memorial City Medical Center	7	11	921 Gessner Road	Houston	tx	77024	3	(713) 242-3000	www.memorialhermann.org/locations/M	450610	644	¤ 696,732,916.00	Robert	McElroy	0.025
39	29	Memorial Hermann Hospital - Texas Medical Center	7	11	6411 Fannin	Houston	tx	77030	3	(713) 704-4000	www.memorialhermann.org/locations/H	450068	789	¤ 2,258,540,888.00	Eddie Joe	Gregory	0.025
40	29	Memorial Hermann Northeast Hospital	7	11	18951 Memorial North	Humble	tx	77338	3	(281) 540-7700	www.memorialhermann.org/locations/n	450684	255	¤ 420,037,944.00	Gregory	Maltby	0.025
41	29	Memorial Hermann Northwest Hospital	7	6	1635 North Loop West	Houston	tx	77008	3	(713) 867-2000	www.memorialhermann.org/locations/N			¤ 0.00	Ernest	Barany	0.0
42	29	Memorial Hermann TIRR	6	11	1333 Moursund Street	Houston	tx	77030	3	(713) 799-5000	www.memorialhermann.org/locations/T	453025	116	¤ 126,129,510.00	Paul	Hay	0.025
43	30	Bedford Regional Medical Center	2	11	2900 West 16th Street	Bedford	in	47421	5	(812) 275-1200	www.brmchealthcare.com	151328	25	¤ 135,607,775.00	Sergio	Soto-Navarro	0.025
44	30	Ball Memorial Hospital	7	11	2401 West University Avenue	Muncie	in	47303	5	(765) 747-3111	www.accesschs.org/ball_memorial_hospital	150089	344	¤ 817,649,682.00	Cynthia	Bejarano	0.025
45	30	Hoag Memorial Hospital Presbyterian	7	11	One Hoag Drive	Newport Beach	ca	92663	4	(949) 764-4624	www.hoaghospital.org	050224	394	¤ 1,524,858,135.00	Jack	Jordan	0.025
46	30	Clarian North Medical Center	7	7	11700 North Meridian Street	Carmel	in	46032	5	(317) 688-2000	www.clariannorth.com	150161	149	¤ 339,964,498.00	Alfonso	Romero	0.0
47	30	Indiana University Hospital	4	9	550 North University Boulevard	Indianapolis	in	46202	5	(317) 274-5000	www.clarian.org/portal/Clarian/indi			¤ 0.00	Margaret	Trumpp	0.0
48	30	Blackford Community Hospital	2	8	410 Pilgrim Boulevard	Hartford City	in	47348	5	(765) 348-0300	www.accesschs.org/blackford_community_hospital	151302	15	¤ 39,104,625.00	Soumaila	Sanogo	0.0
49	30	Riley Hospital for Children	1	6	702 Barnhill Drive	Indianapolis	in	46202	5	(317) 274-2060	www.rileyhospital.org			¤ 0.00	William	Sailer	0.0
50	30	Clarian Arnett Hospital	7	11	5165 McCarty Lane	Lafayette	in	47905	5	(765) 448-8000	www.clarianarnett.com	150173	116	¤ 667,948,358.00	Joseph	Tatro	0.025
51	30	Clarian West Medical Center	7	7	1111 North Ronald Reagan Parkway	Avon	in	46123	5	(317) 217-3000	www.clarian.org/portal/ClarianWest	150158	85	¤ 251,694,567.00	Kenneth	Sabo	0.0
52	30	Methodist Hospital	7	4	Interstate 65 at 21st Street	Indianapolis	in	46206	5	(317) 962-2000	www.clarian.org	150056	1440	¤ 3,586,443,001.00	John	Kemp	0.0
53	31	Hospital of the University of Pennsylvania	7	11	3400 Spruce Street	Philadelphia	pa	19104	7	(215) 662-4000	www.pennhealth.com/upmc	390111	684	¤ 4,785,073,560.00	Sergei	Smirnov	0.025
54	32	Inova Fairfax Hospital	7	11	3300 Gallows Road	Falls Church	va	22042	7	(703) 776-4001	www.inova.org	490063	904	¤ 2,202,570,731.00	Rosa Maria	Hernandez	0.025
55	33	Jackson County Memorial Hospital	7	2	1200 East Pecan	Altus	ok	73521	3	(580) 482-4781	www.jcmh.com	370022	101	¤ 147,704,040.00	Carole	Pracht	0.0
58	36	Franklin Hospital	7	11	900 Franklin Avenue	Valley Stream	ny	11580	7	(516) 256-6000	www.northshorelij.com/body.cfm?ID=5	330372	405	¤ 499,947,024.00	Jeanne	Cardenas	0.025
59	36	Forest Hills Hospital	7	11	102-01 66th Road	Forest Hills	ny	11375	7	(718) 830-4000	www.northshorelij.com/body.cfm?ID=6	330353	227	¤ 396,571,010.00	Norma	Richards	0.025
60	36	Jewish Hospital	7	11	4777 East Galbraith Road	Cincinnati	oh	45236	5	(513) 686-3000	www.jewishhospitalcincinnati.com	360016	209	¤ 584,306,317.00	Lonnie	Jarrett	0.025
61	37	Jewish Memorial Hospital and Rehabilitation Center	3	7	59 Townsend Street	Boston	ma	2119	8	(617) 989-8315	www.jmhrc.com	222010	207	¤ 71,814,528.00	Jim	Walker	0.0
62	38	Johnson County Community Hospital	2	11	1901 South Shady Street	Mountain City	tn	37683	6	(423) 727-1100	www.msha.com/facility.cfm?id=49	441304	2	¤ 21,347,520.00	George	Abernathy	0.025
63	38	Sycamore Shoals Hospital	7	11	1501 West Elk Avenue	Elizabethton	tn	37643	6	(423) 542-1300	www.msha.com/facility.cfm?id=54	440018	121	¤ 157,326,244.00	David	Pengelley	0.025
64	38	Woodridge Hospital	5	6	403 State of Franklin Road	Johnson City	tn	37604	6	(423) 431-7111	www.msha.com/Facility.cfm?id=479			¤ 0.00	Terrie	Cox-Pauly	0.0
65	38	Indian Path Medical Center	7	11	2000 Brookside Drive	Kingsport	tn	37660	6	(423) 857-7000	www.msha.com/Facility.cfm?id=50	440176	189	¤ 317,788,141.00	Michael	Hornsby	0.025
66	38	Johnson City Medical Center	7	11	400 North State of Franklin Road	Johnson City	tn	37604	6	(423) 431-6111	www.msha.com	440063	595	¤ 1,379,746,352.00	Jeff	Lilley	0.025
67	38	Johnston Memorial Hospital	7	11	351 Court Street Northeast	Abingdon	va	24210	7	(276) 676-7000	www.jmh.org	490053	135	¤ 203,213,533.00	Graciela	Unguez	0.025
68	38	North Side Hospital	7	11	401 Princeton Road	Johnson City	tn	37601	6	(423) 854-5600	www.msha.com/facility.cfm?id=52	440184	126	¤ 102,037,033.00	Victoria	Audley	0.025
69	38	Dickenson Community Hospital	2	11	312 Hospital Drive	Clintwood	va	24228	7	(276) 926-0300	www.msha.com	491303	25	¤ 17,900,319.00	Bealquin	Gomez	0.025
70	38	Russell County Medical Center	7	7	58 Carroll Street	Lebanon	va	24266	7	(276) 883-8000	www.rcmc.net	490002	78	¤ 100,630,023.00	Irene	Lutz	0.0
72	1	Advocate Lutheran General Hospital	7	10	1775 Dempster Street	Park Ridge	il	60068	5	(847) 723-2210	www.advocatehealth.com/lutheran	140223	579	¤ 1,438,132,780.00	Elizabeth	Zogleman	0.02
75	3	Avera McKennan Hospital & University Health Center	7	11	800 East 21st Street	Sioux Falls	sd	57117	2		www.mckennan.org	430016	537	¤ 726,504,890.00	Wendy	Munday	0.025
76	4	Barnes-Jewish West County Hospital	7	11	12634 Olive Boulevard	Saint Louis	mo	63141	1	(314) 996-8410	www.barnesjewishwestcounty.org	260162	77	¤ 187,067,238.00	Gary	Roemer	0.025
77	4	Barnes-Jewish Saint Peters Hospital	7	11	10 Hospital Drive	Saint Peters	mo	63376	1	(636) 916-9000	www.bjsph.org	260191	103	¤ 272,202,733.00	Richard	Oliver	0.025
78	4	Barnes-Jewish Hospital	7	11	1 Barnes-Jewish Hospital Plaza	Saint Louis	mo	63110	1	(314) 747-3000	www.barnesjewish.org	260032	1283	¤ 2,872,902,618.00	Carol	Walker	0.025
79	4	Barnes-Kasson Hospital	2	11	2872 Turnpike Street	Susquehanna	pa	18847	7	(570) 853-3135	www.barnes-kasson.org	391309	83	¤ 35,620,067.00	Gary	Donart	0.025
80	5	Beaumont Hospital - Grosse Pointe	7	11	468 Cadieux Road	Grosse Pointe	mi	48230	5	(313) 343-1000	www.beaumonthospitals.com/Locations	230089	253	¤ 391,890,306.00	Sonja	Bontrager	0.025
81	5	Beaumont Hospital - Troy	7	11	44201 Dequindre Road	Troy	mi	48085	5	(248) 964-5000	www.beaumonthospitals.com/Locations	230269	356	¤ 1,463,287,709.00	Jerald	Metzger	0.025
82	7	Beth Israel Medical Center - Petrie Division	7	11	First Avenue at 16th Street	New York	ny	10003	7	(212) 420-2000	wehealny.org/patients/BI_home/Bi_in	330169	1004	¤ 2,440,841,265.00	Garrey	Carruthers	0.025
83	7	Saint Luke's-Roosevelt Hospital Center	7	6	1000 Tenth Avenue at 59th Street	New York	ny	10019	7	(212) 523-4000	www.wehealny.org/patients/slr_descr			¤ 0.00	John	Moragues	0.0
84	7	Saint Luke's-Roosevelt Hospital Center	7	11	1111 Amsterdam Avenue	New York	ny	10025	7	(212) 523-4000	www.wehealny.org/patients/slr_descr	330046	842	¤ 2,363,519,452.00	Tarcisia	Roths	0.025
85	8	Beaumont Hospital, Royal Oak	7	11	3601 West Thirteen Mile Road	Royal Oak	mi	48073	5	(248) 898-5000	www.beaumonthospitals.com	230130	1061	¤ 3,477,348,926.00	Ronald	Parker	0.025
87	10	Beth Israel Medical Center - Petrie Division	7	11	First Avenue at 16th Street	New York	ny	10003	7		www.wehealny.org/patients/BI_home/BI_Petrie.html	330169	1004	¤ 2,440,841,265.00	Viola	Fuentes	0.025
89	12	Florida Hospital Waterman	7	10	1000 Waterman Way	Tavares	fl	32778	6	(352) 253-3333	www.fhwat.org	100057	204	¤ 622,022,824.00	Thomasine	Stoecklein	0.02
90	12	Manchester Memorial Hospital	7	10	210 Marie Langdon Drive	Manchester	ky	40962	6	(606) 598-5104	www.manchestermemorial.com	180043	63	¤ 113,070,374.00	Nancy	Dahlinger	0.02
91	12	Porter Adventist Hospital	7	11	2525 South Downing Street	Denver	co	80210	2	(303) 778-1955	www.porterhosp.org	060064	224	¤ 760,469,486.00	John	Ellington	0.025
92	12	Florida Hospital Flagler	7	10	60 Memorial Medical Parkway	Palm Coast	fl	32164	6	(386) 586-2000	www.floridahospitalflagler.com	100118	81	¤ 300,496,459.00	Uma	Krishnan	0.02
93	12	Emory-Adventist Hospital at Smyrna	7	10	3949 South Cobb Drive	Smyrna	ga	30080	6	(770) 436-3162	www.emoryadventist.org	110183	73	¤ 134,206,398.00	Robert	Roberson	0.02
94	12	Parker Adventist Hospital	7	11	9395 Crown Crest Boulevard	Parker	co	80138	2	(303) 269-4000	www.parkerhospital.org	060114	95	¤ 342,843,942.00	Andrew	Anderson	0.025
95	12	Adventist La Grange Memorial Hospital	7	10	5101 South Willow Springs Road	La Grange	il	60525	5	(708) 245-9000	www.keepingyouwell.com/almh	140065	176	¤ 516,991,514.00	Guy	Glidden	0.02
96	12	Adventist GlenOaks Hospital	7	10	701 North Winthrop Avenue	Glendale Heights	il	60139	5	(630) 545-8000	www.keepingyouwell.com/agh	140292	138	¤ 172,124,425.00	Elliott	Willman	0.02
97	12	Central Texas Medical Center	7	10	1301 Wonder World Drive	San Marcos	tx	78666	3	(512) 353-8979	www.ctmc.org	450272	113	¤ 227,045,945.00	Ronald	Shipley	0.02
98	12	Florida Hospital Fish Memorial	7	10	1055 Saxon Boulevard	Orange City	fl	32763	6	(386) 917-5000	www.fhfishmemorial.org	100072	139	¤ 396,458,249.00	Billy	Dictson	0.02
99	12	Jellico Community Hospital	7	10	188 Hospital Lane	Jellico	tn	37762	6	(423) 784-1187	www.jellicohospital.com	440180	54	¤ 62,643,003.00	Michael	Bradley	0.02
100	12	Gordon Hospital	7	10	1035 Red Bud Road	Calhoun	ga	30701	6	(706) 629-2895	www.gordonhospital.com	110023	69	¤ 192,961,380.00	Gary	Eiceman	0.02
101	12	Florida Hospital Kissimmee	7	6	2450 North Orange Blossom Trail	Kissimmee	fl	34744	6	(407) 846-4343	www.fhkissimmee.com			¤ 0.00	Darlene	Dickson	0.0
103	40	Lawrence Memorial Hospital	7	1	325 Maine Street	Lawrence	ks	66044	1	(785) 505-5000	www.lmh.org	170137	152	¤ 331,047,026.00	Max	Frazier	0.0
104	41	Lehigh Valley Hospital - Cedar Crest	7	11	1200 Cedar Crest Boulevard	Allentown	pa	18105	7	(610) 402-8001	www.lvh.org/lvh/Locations/Cedar_Cre	390133	873	¤ 2,762,936,784.00	Igor	Sevostianov	0.025
105	42	Massachusetts General Hospital	7	11	55 Fruit Street	Boston	ma	2114	8	(617) 726-2000	www.massgeneral.org	220071	907	¤ 4,445,399,695.00	Austin	Hoover	0.025
106	43	Mayo Clinic Hospital	7	11	5777 East Mayo Boulevard	Phoenix	az	85054	4	(480) 515-6296	www.mayoclinic.org/mchospital-sct	030103	244	¤ 1,205,977,961.00	Leah	Stevenson	0.025
107	43	Mayo Clinic	7	11	1216 Second Street Southwest	Rochester	mn	55902	5	(507) 255-5123	www.mayoclinic.org/rochester/	240010	879	¤ 1,171,957,718.00	Duane	Taylor	0.025
108	43	Mayo Clinic Hospital	7	6	4500 San Pablo Road	Jacksonville	fl	32224	6	(904) 953-2000	www.mayoclinic.org/mayo-clinic-hosp			¤ 0.00	Marc	Pruyn	0.0
109	44	Medical University of South Carolina	7	5	171 Ashley Avenue	Charleston	sc	29425	6	(843) 792-2300	www.muschealth.com/medical_services	420004	632	¤ 1,610,786,719.00	Douglas	Roby	0.0
110	45	Memorial Hermann Southwest Hospital	7	11	7600 Beechnut	Houston	tx	77074	3	(713) 456-5000	www.memorialhermann.org	450184	1170	¤ 2,385,214,262.00	Marilyn	Mignery	0.025
111	46	Methodist University Hospital	7	11	1265 Union Avenue	Memphis	tn	38104	6	(901) 516-7000	www.methodisthealth.org	440049	1273	¤ 3,198,414,459.00	Leslie	Jensby	0.025
112	47	Metropolitan State Hospital	5	5	11401 Bloomfield Avenue	Norwalk	ca	90650	4	(562) 863-7011	www.dmh.ca.gov/services_and_programs/state_hospitals/Metropolitan/default.asp	054133	952	¤ 148,058,246.00	Randy	McFerrin	0.0
113	48	Miami Jewish Home & Hospital	7	11	5200 Northeast Second Avenue	Miami	fl	33137	6	(305) 751-8626	www.douglasgardens.com	100277	494	¤ 63,714,980.00	Fern	Dahlgren	0.025
114	49	Mount Sinai Hospital	7	11	California Avenue at Fifthteenth Street	Chicago	il	60608	5	(773) 542-2000	www.sinai.org	140018	291	¤ 782,262,000.00	Cheryl	Golden	0.025
115	50	New York Methodist Hospital	7	11	506 Sixth Street	Brooklyn	ny	11215	7	(718) 780-3000	www.nym.org	330236	591	¤ 1,026,072,078.00	Joanne	Hess	0.025
116	51	New York-Presbyterian Hospital	7	11	525 East 68th Street	New York	ny	10065	7	(212) 746-5454	www.nyp.org	330101	2236	¤ 6,808,801,000.00	Tony	Salinas	0.025
117	52	North Shore University Hospital	7	11	300 Community Drive	Manhasset	ny	11030	7	(516) 562-0100	www.northshorelij.com	330106	1082	¤ 3,523,532,124.00	Edward	Farris	0.025
118	53	Northwestern Memorial Hospital	7	11	251 East Huron	Chicago	il	60611	5	(312) 926-2000	www.nmh.org	140281	874	¤ 3,274,706,411.00	Jacklyn	St. Aubyn	0.025
119	54	Norton Audubon Hospital	7	6	One Audubon Plaza Drive	Louisville	ky	40217	6	(502) 636-7111	www.nortonhealthcare.com			¤ 0.00	Stephen	Poulter	0.0
120	55	Kosair Children's Hospital	1	6	231 East Chestnut Street	Louisville	ky	40202	6	(502) 629-6000	www.nortonhealthcare.com/home_kosair.cfm?id=628			¤ 0.00	Karen	Stabler	0.0
121	55	Norton Hospital	7	11	200 East Chestnut Street	Louisville	ky	40202	6	(502) 629-8000	www.nortonhealthcare.com	180088	1150	¤ 3,565,696,826.00	Andrew	Kramer	0.025
122	55	Norton Brownsboro Hospital	7	6	4960 Norton Healthcare Boulevard	Louisville	ky	40241	6	(502) 446-8000	www.nortonhealthcare.com/body.cfm?id=633			¤ 0.00	Charles	Glover	0.0
123	55	Norton Suburban Hospital	7	6	4001 Dutchmans Lane	Louisville	ky	40207	6	(502) 893-1000	www.nortonhealthcare.com			¤ 0.00	H. G.	Kinzer	0.0
124	56	Ohio State University Hospital	7	5	410 West Tenth Avenue	Columbus	oh	43210	5	(614) 293-8000	www.medicalcenter.osu.edu	360085	918	¤ 3,883,747,129.00	Connie	Stout	0.0
126	58	Parkview Community Hospital Medical Center	7	11	3865 Jackson Street	Riverside	ca	92503	4	(951) 688-2211	www.pchmc.org	050102	193	¤ 428,010,155.00	Dorothea	Riemann	0.025
127	59	Parkview Whitley Hospital	7	11	353 North Oak Street	Columbia City	in	46725	5	(260) 248-9000	www.parkview.com	150101	122	¤ 71,826,986.00	Kulbhushan	Grover	0.025
128	60	Presbyterian Hospital	7	11	200 Hawthorne Lane	Charlotte	nc	28204	6	(704) 384-4000	www.presbyterian.org/site/home/	340053	518	¤ 1,181,018,825.00	Thomas	Cyrs	0.025
129	61	Presbyterian Hospital	7	11	1100 Central Avenue Southeast	Albuquerque	nm	87106	3	(505) 841-1234	www.phs.org/phs/hospitals/hospitals...	320021	709	¤ 2,033,911,864.00	Roger	Johns	0.025
130	62	Presbyterian Intercommunity Hospital	7	10	12401 Washington Boulevard	Whittier	ca	90602	4	(562) 698-0811	www.whittierpres.com	050169	444	¤ 1,749,335,452.00	Mohammed	Hussain	0.02
132	64	Robert Wood Johnson University Hospital	7	11	One Robert Wood Johnson Place	New Brunswick	nj	08903	7	(732) 828-3000	www.rwjuh.edu	310038	601	¤ 2,951,250,139.00	Brenda	Seevers	0.025
133	65	Robert Wood Johnson University Hospital at Rahway	7	11	865 Stone Street	Rahway	nj	07065	7	(732) 381-4200	www.rwjuhr.com	310024	165	¤ 695,014,743.00	Andrea	Conners	0.025
134	66	Robert Wood Johnson University Hospital Hamilton	7	11	One Hamilton Health Place	Hamilton	nj	08690	7	(609) 586-7900	www.rwjhamilton.org	310110	276	¤ 1,585,291,000.00	Ted	Anders	0.025
135	67	Ryder Memorial Hospital	7	10	355 Font Martelo Street	Humacao	pr	00791	9	(787) 852-0768		400007	227	¤ 76,732,108.00	David	Trafimow	0.02
136	68	Sacred Heart Medical Center	7	10	101 West Eighth Avenue	Spokane	wa	99204	2	(509) 474-3131	www.shmc.org	500054	623	¤ 1,600,539,519.00	Ramon	Dominguez	0.02
137	69	Sacred Heart Medical Center	7	10	1255 Hilyard Street	Eugene	or	97401	2	(541) 686-7300	www.peacehealth.org	380033	448	¤ 914,733,033.00	Lowell	Catlett	0.02
138	70	Saint Dominic-Jackson Memorial Hospital	7	10	969 Lakeland Drive	Jackson	ms	39216	6	(601) 200-2000	www.stdom.com	250048	523	¤ 829,714,789.00	Betty	Seiler	0.02
139	71	Saint John's Episcopal Hospital	7	11	327 Beach 19th Street	Far Rockaway	ny	11691	7	(718) 869-7000	www.ehs.org/stjohnshospital/index.html	330395	415	¤ 287,510,865.00	Delbert	Wells	0.025
140	72	Saint John's Hospital	7	10	1235 East Cherokee Street	Springfield	mo	65804	1	(417) 820-2000	www.stjohns.com/aboutus/sjh.aspx	260065	812	¤ 1,535,183,502.00	Mary	Werner	0.02
141	73	Saint John's Hospital	7	10	800 East Carpenter Street	Springfield	il	62769	5	(217) 544-6464	www.st-johns.org	140053	453	¤ 914,471,665.00	Azadeh	Osanloo	0.02
142	74	Saint John's Mercy Medical Center	7	10	615 South New Ballas Road	Saint Louis	mo	63141	1	(314) 251-6000	www.stjohnsmercy.org/sjmmc	260020	887	¤ 2,107,428,686.00	Teresa	Raehpour	0.02
143	75	Saint John's Riverside Hospital - Andrus Pavilion	7	11	967 North Broadway	Yonkers	ny	10701	7	(914) 964-4444	www.riversidehealth.org	330208	403	¤ 358,885,615.00	Alisa	Gonzales	0.025
144	76	Saint Luke's Memorial Hospital	7	10	Ave. Tito Castro 917	Ponce	pr	00733	9	(787) 844-2080	www.ssepr.com	400044	368	¤ 202,057,448.00	Christopher	Fox	0.02
145	77	Saint Mary's Hospital	7	10	1601 West Saint Mary's Road	Tucson	az	85745	4	(520) 872-3000	www.carondelet.org/home/hospitals-locations/st.-marys-hospital.aspx	030010	402	¤ 722,632,676.00	Susan	Orsbon	0.02
146	78	Saint Mary's Hospital	7	10	350 Boulevard	Passaic	nj	07055	7	(973) 365-4300	www.smh-nj.org	310006	302	¤ 542,320,148.00	Karen	Rogers	0.02
147	79	Saint Mary's Hospital	7	10	5801 Bremo Road	Richmond	va	23226	7	(804) 285-2011	www.bonsecours.com/hospitals/stmarys/	490059	370	¤ 1,339,585,063.00	Leigh Anne	Marez	0.02
148	80	Saint Mary's Hospital & Regional Medical Center	7	10	2635 North Seventh Street	Grand Junction	co	81502	2	(970) 244-2273	www.stmarygj.com	060023	283	¤ 660,942,985.00	John	Patton	0.02
149	81	Saint Mary's Hospital at Amsterdam	7	11	4988 State Highway 30	Amsterdam	ny	12010	7	(518) 842-3100	www.amsterdammemorial.org	330010	199	¤ 45,119,260.00	Charlotte	Mathews	0.025
150	82	Scripps Mercy Hospital	7	11	4077 Fifth Avenue	San Diego	ca	92103	4	(619) 294-8111	www.scrippshealth.org	050077	555	¤ 1,771,153,858.00	Fred	Richman	0.025
152	84	Sparrow Hospital	7	4	1215 East Michigan Avenue	Lansing	mi	48912	5	(517) 364-1000	www.sparrow.org	230230	571	¤ 1,730,287,041.00	Ronald	Walser	0.0
153	85	Sparrow Specialty Hospital	3	11	1210 West Saginaw Street	Lansing	mi	48908	5	(517) 364-6800	www.sparrowspecialty.org	232037	36	¤ 31,332,127.00	Lorraine	Steiner	0.025
154	86	Stonewall Jackson Memorial Hospital	7	11	230 Hospital Plaza	Weston	wv	26452	7	(304) 269-8000	www.stonewallhospital.com	510038	60	¤ 66,703,333.00	Ivelisse	Fernandez	0.025
155	87	Temple University Hospital	7	11	3401 North Broad Street	Philadelphia	pa	19140	7	(215) 707-2000	tuh.templehealth.org	390027	713	¤ 5,586,651,000.00	William	Zellefrow	0.025
156	88	Texas Health Harris Methodist Hospital Fort Worth	7	10	1301 Pennsylvania Avenue	Fort Worth	tx	76104	3	(817) 250-2000	www.texashealth.org	450135	608	¤ 1,588,834,101.00	Nancy	Gonzalez	0.02
157	89	Texas Health Presbyterian Hospital Dallas	7	11	8200 Walnut Hill Lane	Dallas	tx	75231	3	(214) 345-6789	www.texashealth.org	450462	690	¤ 1,402,410,774.00	Desaree	Jimenez	0.025
158	90	Texas Health Presbyterian Hospital Plano	7	10	6200 West Parker Road	Plano	tx	75093	3	(972) 981-8000	www.texashealth.org	450771	354	¤ 652,862,510.00	Marcel	Montanez	0.02
159	91	The Johns Hopkins Hospital	7	11	600 North Wolfe Street	Baltimore	md	21287	7	(410) 955-5000	www.hopkinshospital.org	210009	923	¤ 1,553,865,023.00	Javin	Taylor	0.025
160	92	The Methodist Hospital	7	11	6565 Fannin Street	Houston	tx	77030	3	(713) 790-3311	www.methodisthealth.com	450358	934	¤ 3,869,904,938.00	Rudolfo	Chavez	0.025
161	93	The Moses H. Cone Memorial Hospital	7	11	1200 North Elm Street	Greensboro	nc	27401	6	(336) 832-7000	www.mosescone.com	340091	898	¤ 1,423,820,502.00	Mack	Adams	0.025
162	94	The Mount Sinai Hospital	7	11	One Gustave L. Levy Place	New York	ny	10029	7	(212) 241-6500	www.mountsinai.org	330024	1223	¤ 2,899,656,827.00	Averett	Tombes	0.025
163	95	Thomas Jefferson University Hospital	7	11	111 South 11th Street	Philadelphia	pa	19107	7	(215) 955-6000	www.jeffersonhospital.org	390174	918	¤ 4,004,409,443.00	Daniel	Matthew	0.025
164	96	University Hospital	7	5	234 Goodman Street	Cincinnati	oh	45219	5	(513) 584-1000	www.universityhospitalcincinnati.com	360003	434	¤ 1,276,876,261.00	Debbie	Strickert	0.0
165	97	University Hospital	7	2	1350 Walton Way	Augusta	ga	30901	6	(706) 722-9011	www.universityhealth.org	110028	482	¤ 1,075,841,822.00	J. T.	McGuckin	0.0
166	98	University Hospitals Case Medical Center	7	11	11100 Euclid Avenue	Cleveland	oh	44106	5	(216) 844-1000	www.uhhospitals.org	360137	623	¤ 2,335,513,948.00	Mary Jo	Billiot	0.025
167	99	University of Colorado Hospital	7	4	12605 East 16th Avenue	Aurora	co	80045	2	(720) 848-0000	www.uch.edu	060024	371	¤ 1,977,794,796.00	Patricia	Wojahn	0.0
168	100	University of Kentucky Hospital	7	11	800 Rose Street	Lexington	ky	40536	6	(859) 323-5000	www.ukhealthcare.uky.edu	180067	511	¤ 1,446,680,966.00	Cynthia	Houser	0.025
169	101	University of Louisville Hospital	7	11	530 South Jackson Street	Louisville	ky	40202	6	(502) 562-3000	www.uoflhealthcare.org	180141	347	¤ 1,251,962,194.00	Ingrid	Schneider	0.025
170	102	University of New Mexico Hospital	7	5	2211 Lomas Boulevard Northeast	Albuquerque	nm	87106	3	(505) 272-2111	hospitals.unm.edu	320001	544	¤ 1,019,446,114.00	Javier	Vargas	0.0
171	103	University of Pittsburgh Medical Center Presbyterian	7	11	200 Lothrop Street	Pittsburgh	pa	15213	7	(412) 647-2345	www.upmc.com	390164	1602	¤ 9,293,788,259.00	Michael	Perrow	0.025
172	104	Valley Presbyterian Hospital	7	11	15107 Vanowen Street	Van Nuys	ca	91405	4	(818) 782-6600	www.valleypres.org	050126	348	¤ 807,518,873.00	Renee	Hein	0.025
173	105	Washington Hospital Center	7	11	110 Irving Street, Northwest	Washington	dc	20010	7	(202) 877-7000	www.whcenter.org	090011	812	¤ 2,666,301,728.00	Kevin	Brown	0.025
174	106	Wesley Medical Center	7	7	5001 Hardy Street	Hattiesburg	ms	39402	6	(601) 268-8000	www.wesley.com	250094	211	¤ 537,965,751.00	Sue	Gardner	0.0
175	107	Wesley Medical Center	7	7	550 North Hillside	Wichita	ks	67214	1	(316) 962-2000	www.wesleymc.com	170123	594	¤ 1,434,679,803.00	Rebecca	Verser	0.0
176	35	Jewish Hospital	7	11	200 Abraham Flexner Way	Louisville	ky	40202	6	(502) 587-4011	www.jewishhospital.org	180040	1025	¤ 2,351,013,134.00	Michael	Duxler	0.025

FacTypeID	FacType
1	Childrens
2	Critical Access
3	Long Term
4	Other
5	Psychiatric
6	Rehabilitation
7	Short Term Acute Care

InvID	EnergyStar	ModelNum	ShapeID	BulbCatID	VenderID	BulbTypeID	Wattage	BulbLife	LightOutput	ColorTemp	Feature	Cost
1	false	684-20-E26	1	2	27	3	20	600	900	1250		¤ 3.45
2	false	TT74-150-G	1	4	27	2	150	30	2400	3350		¤ 42.90
3	false	TT74-75-G	1	4	27	2	75	30	2000	3000		¤ 38.50
4	false	13297	2	2	15	1	30	6000	2000	2700		¤ 5.80
5	true	CL/10WL	3	2	18	1	10	15000	600	2700		¤ 6.85
6	true	BE10T3/D	3	2	15	1	10	8000	490	6500		¤ 5.95
7	true	BE10T3/SW	3	2	15	1	10	8000	520	2700		¤ 6.25
8	false	11W-S-CFL-27KYN	3	2	20	1	11	10000	650	2700		¤ 4.65
9	true	EST-11W	3	2	1	1	11	10000	660	2700		¤ 4.85
10	true	SDM11MSL	3	2	10	1	11	10000	700	2700		¤ 17.65
11	true	11W-S-MCFL-27KTP	3	2	20	1	11	12000	700	2700		¤ 22.50
12	true	109546	3	2	5	1	13	10000	800	4100		¤ 2.41
13	true	112978	3	2	5	1	13	10000	800	4100		¤ 2.41
14	true	CSM13BW-N	3	2	26	1	13	10000	800	4100		¤ 8.54
15	true	CSM13UB-N	3	2	26	1	13	10000	800	5000		¤ 6.55
16	true	109554	3	2	5	1	13	10000	830	2700		¤ 6.70
17	true	111132	3	2	5	1	13	10000	830	2700		¤ 6.34
18	true	CMTL-13w	3	2	8	1	13	10000	850	2700		¤ 3.25
19	true	MS/1350	3	2	23	1	13	10000	880	5000		¤ 5.85
20	true	13W-S-CFL-27KYN	3	2	20	1	13	10000	900	2700		¤ 3.95
21	true	BPCE123/PGE	3	2	28	1	13	10000	900	2700		¤ 5.85
22	true	SEM-13W	3	2	6	1	13	10000	900	2700		¤ 3.85
23	true	BSK13W/4100K	3	2	6	1	13	10000	900	4100		¤ 4.85
24	true	T2BSK13W/4100K	3	2	6	1	13	10000	900	4100		¤ 5.10
25	true	BSK13W/5000K	3	2	6	1	13	10000	900	5000		¤ 5.23
26	true	T2BSK13W/5000K	3	2	6	1	13	10000	900	5000		¤ 5.60
27	true	13W-S-MCFL-27KTP	3	2	20	1	13	12000	900	2700		¤ 5.50
28	true	SDM13MSLT2	3	2	10	1	13	12000	900	2700		¤ 4.25
29	true	MS/1327	3	2	23	1	13	12000	900	2700		¤ 5.70
30	false	CF13-BL1	3	2	14	1	13	6000	800	2700		¤ 5.50
31	true	CF13EL33	3	2	14	1	13	6000	800	3000		¤ 2.85
32	true	CF13EL44	3	2	14	1	13	6000	800	3000		¤ 3.32
33	true	135653	3	2	15	1	13	8000	800	2700		¤ 5.80
34	true	CF13EL	3	2	14	1	13	8000	800	2700		¤ 5.35
35	true	46427	3	2	15	1	13	8000	800	2700		¤ 3.65
36	true	46428	3	2	15	1	13	8000	800	2700		¤ 3.99
37	true	80201	3	2	15	1	13	8000	800	2700		¤ 2.75
38	true	CF13EL55	3	2	14	1	13	8000	800	2700		¤ 3.50
39	false	CF13EL2	3	2	14	1	13	8000	800	3000		¤ 3.85
40	true	296889/LB13T/65K	3	2	15	1	13	8000	800	6500		¤ 5.65
41	true	BE13T3/SW	3	2	15	1	13	8000	825	2700		¤ 4.10
42	true	SP133080	3	2	17	1	13	8000	900	3000		¤ 2.25
43	true	LBP13T/35K€	3	2	15	1	13	8000	900	3500		¤ 4.55
44	true	SDM3W25S	3	2	10	1	13	8000	1800	2700	3 Way	¤ 12.55
45	true	BCS-14	3	2	7	1	14	10000	820	2700		¤ 4.65
46	true	2214	3	2	4	1	14	10000	900	2700		¤ 3.18
47	false	423-599	3	2	16	1	14	10000	900	2700		¤ 3.18
48	true	292-460	3	2	16	1	14	10000	900	2700		¤ 3.85
49	false	491-062	3	2	16	1	14	10000	900	2700		¤ 4.10
50	true	AM14PERM	3	2	2	1	14	10000	900	2700		¤ 4.55
51	false	164-121	3	2	16	1	14	6000	800	2700		¤ 4.75
52	true	EST-14W	3	2	1	1	14	8000	945	2700		¤ 4.85
53	false	15W-S-CFL-27KYN	3	2	20	1	15	10000	900	2700		¤ 3.95
54	true	2315	3	2	4	1	15	10000	900	2700		¤ 3.85
55	true	MS-1527	14	3	23	1	15	10000	950	2700		¤ 9.80
56	true	CSM15BW-N	14	3	26	1	15	10000	950	4100		¤ 10.50
57	true	CSM15UB-N	14	3	26	1	15	10000	950	5000		¤ 11.20
58	true	CMTL-15w	3	2	8	1	15	10000	960	2700		¤ 3.65
59	true	15W-S-CFL-27KTP	3	3	20	1	15	10000	990	2700		¤ 3.75
60	true	CF15/MS/27/ES	3	2	21	1	15	10000	990	2700		¤ 3.60
61	true	BE15T3/D	14	3	15	1	15	8000	900	6500		¤ 12.95
62	true	MS/1827	3	2	23	1	18	12000	1140	2700		¤ 4.70
63	true	LBP18TM2/27K(N)	3	2	15	1	18	8000	1100	2700		¤ 4.75
64	true	LBP18TM2/280589	3	2	15	1	18	8000	1100	2700		¤ 4.65
65	true	BPCE18TM/D/6	3	2	28	1	18	8000	1100	6500		¤ 4.55
66	true	CE18TM/D/6	3	2	28	1	18	8000	1100	6500		¤ 4.50
67	true	772-739	3	2	16	1	19	10000	1200	2700		¤ 2.75
68	true	19W-S-CFL-27KYN	3	2	20	1	19	10000	1300	2700		¤ 2.50
69	true	SP193080	3	2	17	1	19	8000	1200	2700		¤ 2.35
70	true	20W-S-CFL-27KTP	3	3	20	1	20	10000	1200	2700		¤ 5.20
71	true	2320	3	2	4	1	20	10000	1200	2700		¤ 4.30
72	true	AM20PERM	3	2	2	1	20	10000	1200	2700		¤ 4.75
73	true	BSK20W/2700K	3	3	6	1	20	10000	1200	2700		¤ 4.85
74	true	CF20/MS/27/ES	3	2	21	1	20	10000	1200	2700		¤ 4.60
75	true	CSM20SW-N	3	3	26	1	20	10000	1200	2700		¤ 2.85
76	true	BSK20W/4100K	3	3	6	1	20	10000	1200	4100		¤ 3.85
77	true	BSK20W/5000K	3	3	6	1	20	10000	1200	5000		¤ 4.10
78	false	ESS-20W	3	2	1	1	20	10000	1280	2800		¤ 9.95
79	true	BDS-20	3	3	7	1	20	10000	1350	2700		¤ 9.20
80	true	BE20T3/D	3	3	15	1	20	8000	1150	6500		¤ 13.22
81	true	BE20T3/SW	3	3	15	1	20	8000	1200	2700		¤ 5.33
82	true	109550	3	2	5	1	23	10000	1600	2700		¤ 4.35
83	true	AM23PERM	3	2	2	1	23	10000	1600	2700		¤ 4.28
84	true	BSK23W/2700K	3	3	6	1	23	10000	1600	2700		¤ 3.85
85	true	CSM23SW-N	3	3	26	1	23	10000	1600	2700		¤ 4.35
86	true	ESP-23W/2700K	3	3	6	1	23	10000	1600	2700		¤ 5.10
87	true	T2BSK23W/2700K	3	3	6	1	23	10000	1600	2700		¤ 3.98
88	false	591-830	3	3	16	1	23	10000	1600	2750		¤ 4.55
89	true	738-704	3	3	16	1	23	10000	1600	2750		¤ 4.65
90	true	BSK23W/4100K	3	3	6	1	23	10000	1600	4100		¤ 4.75
91	true	CSM23BW-N	3	3	26	1	23	10000	1600	4100		¤ 4.67
92	true	T2BSK23W/4100K	3	3	6	1	23	10000	1600	4100		¤ 5.10
93	true	BSK23W/5000K	3	3	6	1	23	10000	1600	5000		¤ 6.55
94	true	CSM23UB-N	3	3	26	1	23	10000	1600	5000		¤ 6.89
95	true	T2BSK23W/5000K	3	3	6	1	23	10000	1600	5000		¤ 6.95
96	true	2323	3	2	4	1	23	10000	1650	2800		¤ 4.20
97	true	23W-S-CFL-27KTP	3	3	20	1	23	12000	1600	2700		¤ 3.54
98	true	23W-27KTP	3	2	20	1	23	12000	1600	2700		¤ 4.70
99	true	CF23/MS/27/ES	3	2	21	1	23	12000	1600	2700		¤ 4.90
100	true	MS/2327	3	2	23	1	23	12000	1600	2700		¤ 4.80
101	true	153972/L23TM4	3	2	15	1	23	8000	1600	2700		¤ 4.35
102	false	167-187	3	2	16	1	23	8000	1600	2750		¤ 4.25
103	true	LBP23TM/35K€	3	2	15	1	23	8000	1600	3500		¤ 4.45
104	true	CMTL-25w	3	2	8	1	25	10000	1600	2700		¤ 8.95
105	true	CL/25WL	3	2	18	1	25	12000	1700	2800		¤ 8.80
106	true	CSM26SW-N	3	3	26	1	26	10000	1650	2700		¤ 7.85
107	true	CSM26UB-N	3	3	26	1	26	10000	1650	5000		¤ 6.32
108	true	2326	3	2	4	1	26	10000	1750	2700		¤ 6.95
109	true	BE26T3/D	3	3	15	1	26	8000	1600	6500		¤ 8.20
110	true	BE26T3/SW	3	3	15	1	26	8000	1750	2700		¤ 5.23
111	true	CF27/MS/27/ES	3	2	21	1	27	10000	1650	2700		¤ 6.80
112	true	AM27PERM	3	2	2	1	27	10000	1750	2700		¤ 6.60
113	true	SDM27MSL	3	2	10	1	27	10000	1823	2700		¤ 6.70
114	true	CMTL 30W	3	2	8	1	30	10000	2000	2700		¤ 7.70
115	true	SDM32MSL	3	2	10	1	32	8000	1920	2700		¤ 8.95
116	true	SDM42MSL	3	2	10	1	42	10000	2800	2700		¤ 10.20
117	true	SEM-9W	3	2	6	1	9	10000	450	2700		¤ 1.99
118	true	MS/0927	3	3	23	1	9	10000	500	2700		¤ 2.55
119	true	109544	3	2	5	1	9	10000	500	4100		¤ 3.95
120	true	109552	3	3	5	1	9	10000	520	2700		¤ 3.54
121	true	AM09PERM	3	2	2	1	9	10000	540	2700		¤ 2.10
122	true	2209	3	2	4	1	9	10000	550	2700		¤ 1.90
123	true	EST-9W	3	2	1	1	9	10000	550	2700		¤ 3.95
124	true	BCS-9	3	3	7	1	9	10000	550	2700		¤ 4.55
125	true	BSK9W/2700K	3	3	6	1	9	10000	550	2700		¤ 4.65
126	true	CSM09SW-N	3	3	26	1	9	10000	550	2700		¤ 4.65
127	true	BSK9W/4100K	3	3	6	1	9	10000	550	4100		¤ 4.85
128	true	BSK9W/5000K	3	3	6	1	9	10000	550	5000		¤ 5.12
129	true	MS/0950	3	2	23	1	9	10000	570	5000		¤ 3.95
130	false	237-525	3	3	16	1	9	6000	540	2700		¤ 4.55
131	true	0020928	3	2	15	1	9	8000	600	2700		¤ 3.50
132	true	CMTL-9w	3	2	8	1	9	8000	600	2700		¤ 3.45
133	false	1415	4	2	4	1	14	10000	700	2800		¤ 10.88
134	false	DEM 271-4U/ES	4	2	9	1	27	8000	1700	2700		¤ 11.23
135	true	YPZ12-10	5	2	12	1	10	8000	640	4100		¤ 9.50
136	true	YPZ120/10	5	2	12	1	10	8000	590	6500		¤ 8.75
137	true	YPZ120/10-827	5	2	12	1	10	8000	570	2700		¤ 8.75
138	false	SS/23/3W	5	2	19	1	10	6000	1380	2750	3 Way	¤ 10.95
139	false	11W-S-MCFL-27K	5	3	20	1	11	12000	615	2700		¤ 12.35
140	false	11W-S-MCFL-29K	5	3	20	1	11	10000	650	2700		¤ 13.10
141	true	DEM 111M/es	5	2	9	1	11	10000	600	2700		¤ 7.60
142	false	DEF/M-111	5	2	24	1	11	8000	680	2800		¤ 7.50
143	false	SS/26/3W	5	2	19	1	11	6000	1560	2750	3 Way	¤ 17.22
144	true	LBP 50/150T€	5	2	15	1	12	6000	1750	3500	3 Way	¤ 17.18
145	true	CF28EL56	5	2	14	1	12	8000	1800	2700	3 Way	¤ 16.85
146	true	CF12-26/S/3W/27-46	5	2	21	1	12	10000	1550	2700	3 Way	¤ 11.65
147	true	LBP50/150T (E1)	5	2	15	1	12	8000	2200	2700	3 Way	¤ 14.65
148	true	330501	5	2	2	1	12	10000	2225	2700	3 Way	¤ 16.98
149	false	SS/30/3W	5	2	19	1	12	6000	1800	2700	3 Way	¤ 17.20
150	false	13W-S-MCFL-29K	5	2	20	1	13	10000	800	2900		¤ 5.44
151	false	13W-S-MCFL-27K	5	3	20	1	13	12000	720	2700		¤ 11.55
152	true	BPESL13T/2	5	2	22	1	13	10000	900	2700		¤ 5.60
153	true	CF13/MS/50-43	5	2	21	1	13	10000	800	4100		¤ 3.40
154	true	CF13/SMS/41-43	5	2	21	1	13	10000	900	4100		¤ 3.45
155	true	YPZ120/13-865	5	2	12	1	13	8000	830	6500		¤ 4.95
156	true	13/20/25W-27KTP	5	2	20	1	13	8000	1600	2700	3 Way	¤ 8.95
157	true	DEM-251-3way	5	2	9	1	13	8000	1580	2700	3 Way	¤ 9.00
158	false	1014 SF	5	3	4	1	14	8000	845	2800		¤ 9.98
159	false	283-924	5	2	16	1	14	10000	1950	2700	3 Way	¤ 16.85
160	false	575-717	5	2	16	1	14	10000	1950	2700	3 Way	¤ 17.55
161	false	15W-S-CFL-26K	5	2	20	1	15	10000	900	2600		¤ 6.15
162	false	DEM 151M/es	5	2	9	1	15	10000	900	2700		¤ 6.50
163	false	CTL15	5	2	19	1	15	6000	800	2600		¤ 6.35
164	false	CTU/15W	5	2	19	1	15	6000	750	2900		¤ 6.42
165	true	CF15-40/S/3W/27-46	5	2	21	1	15	10000	2450	2700	3 Way	¤ 18.65
166	true	23582	5	2	15	1	18	8000	1170	2700		¤ 6.35
167	true	296884/LBP18TM/65K	5	2	15	1	18	8000	1170	6500		¤ 6.08
168	false	20W-S-CFL-26K	5	2	20	1	20	10000	1100	2600		¤ 4.52
169	false	CTL20	5	2	19	1	20	6000	1200	2850		¤ 4.63
170	true	YPZ120/20-865	5	2	12	1	20	8000	1250	6500		¤ 4.08
171	false	FE35-22W	5	2	25	1	22	10000	1460	2550		¤ 10.25
172	false	FE45-22W	5	2	25	1	22	6000	1320	2700		¤ 10.32
173	true	MS/2350	5	2	23	1	23	10000	1600	5000		¤ 10.98
174	false	CF23/S	5	2	21	1	23	6000	1380	3000		¤ 10.75
175	true	153972	5	2	15	1	23	8000	1600	2700		¤ 10.15
176	true	210691	5	2	15	1	23	8000	1600	2700		¤ 10.10
177	false	SDF24W	5	2	7	1	24	10000	1600	2700		¤ 5.36
178	false	25W-S-CFL-26K	5	2	20	1	25	10000	1300	2600		¤ 6.65
179	false	FE35-25W	5	2	25	1	25	6000	1500	2700		¤ 6.85
180	false	AMS26252A126	5	2	29	1	25	8000	1600	2750		¤ 6.98
181	false	DEM/N-261	5	2	24	1	26	6000	1560	2800		¤ 6.55
182	true	YPZ120/26-827	5	2	12	1	26	8000	1610	2700		¤ 6.55
183	true	YPZ120/26-841	5	2	12	1	26	8000	1530	4100		¤ 3.54
184	true	YPZ120/26-S	5	2	12	1	26	8000	1630	6500		¤ 10.10
185	false	DEP/M-271	5	2	24	1	27	6000	1600	2850		¤ 6.80
186	true	124990	5	2	15	1	30	6000	2000	2700		¤ 8.52
187	true	BPCE30T3	5	2	28	1	30	8000	2000	2700		¤ 7.88
188	false	CF30/S	5	2	21	1	30	8000	1800	2750		¤ 8.98
189	true	32W-S-CFL-27KTP	5	2	20	1	32	8000	1920	2700		¤ 6.90
190	false	167-190	5	2	16	1	42	10000	2600	2900		¤ 10.45
191	true	42W-S-CFL-27KTP	5	2	20	1	42	10000	2800	2700		¤ 15.50
192	true	772-720	5	2	16	1	42	10000	2997	2700		¤ 16.20
193	true	BSK05W/2700K	5	2	6	1	5	10000	250	2700		¤ 3.25
194	true	115323	5	2	5	1	9	10000	500	4100		¤ 3.98
195	true	115324	5	2	5	1	9	10000	520	2700		¤ 3.56
196	false	DEF/M-91	5	2	24	1	9	8000	500	2800		¤ 3.68
197	true	CMTU-13w	6	2	8	1	13	10000	780	2700		¤ 9.95
198	false	CTU15/3U	6	2	19	1	15	6000	900	2550		¤ 6.98
199	false	CF20-3U	6	2	21	1	20	8000	1200	2650		¤ 9.87
200	false	DEM 251-3U/es	6	2	9	1	25	10000	1500	2700		¤ 9.58
201	false	CF25/3U	6	2	21	1	25	8000	1500	2800		¤ 9.78
202	true	CMDU-10W	6	2	8	1	10	10000	620	2700		¤ 65.85
203	false	c2u	6	2	19	1	13	6000	650	2600		¤ 63.45
204	false	14w c2u	6	2	21	1	14	8000	630	2650		¤ 64.25
205	false	c2u-15w	6	2	21	1	15	8000	900	2700		¤ 62.55
206	false	4427-100-Bayonet	8	1	27	2	100	1000	1900	3000		¤ 9.89
207	false	SX258-300-Tri	9	4	27	5	300	700	5500	3800		¤ 550.00
208	false	002854-150-Tri	9	4	27	5	150	600	5000	3500		¤ 425.00
209	false	CL259-300-BF	9	4	27	5	300	700	5600	5900		¤ 480.00
210	false	CL259-500-BF	9	4	27	5	500	700	5600	5900		¤ 558.00
211	false	FL450-175-BF	9	4	27	5	175	500	2200	5600		¤ 247.00
212	false	FL450-300-BF	9	4	27	5	300	500	5000	5600		¤ 287.00
213	false	CF13/A19/27/ES	1	2	21	1	13	8000	650	2700		¤ 7.99
214	false	CF13/MS	1	2	21	1	13	8000	650	2850		¤ 7.99
215	true	114-016	1	2	16	1	14	6000	800	2800		¤ 9.80
216	true	14W-A19-27KTP	1	2	20	1	14	8000	800	2700		¤ 9.80
217	true	771-428	1	3	16	1	14	8000	800	2700		¤ 10.33
218	true	AB-CAM14BW-1N	1	3	26	1	14	10000	800	4100		¤ 10.45
219	true	AB-CAM14SW-1N	1	3	26	1	14	10000	800	2700		¤ 10.55
220	true	AB-CAM14SW-2N	1	3	26	1	14	10000	800	2700		¤ 10.60
221	true	CF15/A21/27-46	1	2	21	1	15	10000	800	2700		¤ 7.95
222	false	A152760	1	3	17	1	15	6000	800	2600		¤ 8.65
223	false	A156460	1	3	17	1	15	6000	800	2600		¤ 8.99
224	true	BPCE15A/4	1	3	28	1	15	6000	800	2700		¤ 8.75
225	false	CF15/T19	1	2	21	1	15	8000	672	2700		¤ 7.95
226	true	835-427	1	2	16	1	16	6000	700	2750		¤ 8.60
227	false	CF20/T19	1	2	21	1	19	8000	1000	2700		¤ 8.96
228	false	CF20/A21/27/ES	1	2	21	1	20	8000	1030	3100		¤ 9.71
229	false	296-151	1	3	16	1	9	6000	450	2700		¤ 6.00
230	true	AB-CAM09SW-1N	1	2	26	1	9	10000	500	2700		¤ 7.80
231	true	AB-CAM09SW-2N	1	2	26	1	9	10000	500	2700		¤ 7.65
232	true	AB-CAM09BW-1N	1	3	26	1	9	10000	500	4100		¤ 5.68
233	true	AB-CAM09BW-2N	1	3	26	1	9	10000	500	4100		¤ 5.78
234	true	9W-A16-27KTP	1	2	20	1	9	8000	470	2700		¤ 6.38
235	true	9W-G25-27KTP	1	2	20	1	9	8000	470	2700		¤ 6.15
236	true	BAC-9	1	3	7	1	9	10000	535	2700		¤ 8.96
237	true	BALP-14	1	2	7	1	9	8000	470	2700		¤ 5.15
238	true	T3BSA09W/2700K	1	3	6	1	9	10000	500	2700		¤ 7.68
239	true	T3BSA09W/4100K	1	3	6	1	9	10000	500	4100		¤ 10.58
240	false	843-682	10	2	16	1	13	10000	800	2700		¤ 6.54
241	false	6314	10	2	4	1	14	8000	800	2800		¤ 7.10
242	true	774-707	10	3	16	1	14	8000	700	2700		¤ 6.99
243	true	BPCE11G-3	11	2	28	1	11	8000	550	2700		¤ 7.49
244	true	275632/LBP12GTM2	11	2	15	1	12	8000	640	2700		¤ 16.75
245	true	14W-G25-27KTP	11	2	20	1	14	8000	800	2700		¤ 12.50
246	true	T3BSG14W-4100K	11	3	6	1	14	10000	800	4100		¤ 13.65
247	false	9316	11	2	4	1	16	8000	650	2700		¤ 6.00
248	false	9332	11	2	4	1	32	8000	1750	3850		¤ 16.54
249	false	51007	11	2	3	1	7	6000	360	2800		¤ 20.25
250	false	164-596	11	2	16	1	9	8000	495	2700		¤ 12.49
251	false	9309	11	3	4	1	9	8000	500	2800		¤ 6.90
252	true	T3BSG09W-2700K	11	3	6	1	9	10000	500	2700		¤ 14.74
253	true	T3BSG09W-4100K	11	3	6	1	9	10000	500	4100		¤ 15.60
254	true	275665-LBP11R20TM2	12	2	15	1	11	6000	400	2700		¤ 4.56
255	true	21727	12	2	15	1	11	8000	400	2700		¤ 7.25
256	true	296873	12	2	15	1	11	8000	400	3500		¤ 6.88
257	true	296875	12	2	15	1	11	8000	400	6500		¤ 5.70
258	false	113-982	12	3	16	1	14	6000	640	2800		¤ 9.93
259	true	T3BSR14W/2700K	12	2	6	1	14	10000	700	2700		¤ 9.50
260	true	CE15BR30-4	12	2	28	1	15	10000	750	2700		¤ 4.50
261	false	3416	12	3	4	1	16	8000	700	2580		¤ 11.36
262	false	773-972	12	3	16	1	16	8000	750	2700		¤ 9.93
263	true	65874	12	2	10	1	16	10000	750	2700		¤ 9.99
264	false	168725	12	2	15	1	18	8000	950	2780		¤ 13.99
265	true	22519	12	2	15	1	18	8000	950	2700		¤ 14.25
266	true	296863	12	2	15	1	18	8000	950	3500		¤ 15.54
267	false	3420	12	3	4	1	18	6000	820	2700		¤ 85.64
268	true	75316	12	3	15	1	18	8000	950	2700		¤ 76.50
269	false	114-002	12	3	16	1	19	6000	875	2800		¤ 65.95
270	false	164-676	12	3	16	1	19	8000	875	2700		¤ 25.60
271	false	CF19-PAR30-27ES	12	2	21	1	19	6000	785	2850		¤ 13.60
272	false	9P919	12	2	16	1	19	8000	950	2700		¤ 14.50
273	false	4420	12	3	4	1	20	8000	1000	2715		¤ 35.66
274	false	CF20-PAR38-27ES	12	2	21	1	20	6000	945	2750		¤ 13.65
275	true	207-810	12	3	16	1	23	8000	1200	2700		¤ 18.88
276	true	236707	12	3	15	1	23	8000	1300	2700		¤ 14.56
277	true	23W-PAR38-27KTP	12	2	20	1	23	10000	1300	2700		¤ 6.55
278	false	SER24W	12	2	7	1	24	10000	900	2700		¤ 8.89
279	true	CF7-ETW27-46	13	2	21	1	7	10000	340	2700		¤ 15.45
280	true	084878	13	2	15	1	7	8000	280	2700		¤ 4.98
281	true	CE7C	13	2	28	1	7	8000	280	2700		¤ 15.27
282	true	CE7C-6	13	2	28	1	7	8000	280	2700		¤ 9.87
283	true	9W-CAN12-27KTP	13	2	20	1	9	8000	420	2700		¤ 11.98
284	true	CF9-CTW27-33	13	2	21	1	9	8000	420	2700		¤ 17.87
285	true	CF9-ETW27-33	13	2	21	1	9	8000	420	2700		¤ 15.55
286	false	HG-150-GX5.3	14	1	4	2	150	500	1800	3150		¤ 15.39
287	false	HG-30-GX5.3	14	1	4	2	30	800	2000	3000		¤ 6.49
288	false	HG-40-GX5.3	14	1	4	2	40	800	4500	3000		¤ 9.79
289	false	HG-50-GX5.3	14	1	4	2	50	1000	4200	3150		¤ 10.45
290	false	DNF	14	4	27	2	150	25	2500	3400		¤ 31.35
291	false	EFP	14	4	27	2	100	300	2400	2850		¤ 40.19
292	false	38554-50	15	1	27	4	50	700	2900	5200		¤ 165.98
293	false	XBO-150-OFR	15	1	27	5	150	300	2200	6000		¤ 344.00
294	false	XBO-1000-OFR	15	1	27	5	1000	300	32000	6200		¤ 416.00
295	false	XBO-450-OFR	15	1	27	5	450	300	13000	6100		¤ 389.00
296	false	SH58-50-AC	15	1	27	4	50	200	2700	5000		¤ 185.00
297	false	SH58-100-AC	15	1	27	4	100	200	2600	5200		¤ 205.00
298	false	BBL-7400	16	4	4	2	120	500	4500	3200		¤ 9.35
299	false	ISO-30-G6.35	16	1	4	2	30	4000	2200	3000		¤ 31.88
300	false	ISO-20-G6.35	16	1	4	2	150	50	5000	3400		¤ 31.88
301	false	ISO-50-G6.35	16	1	4	2	50	700	5000	3800		¤ 31.88
302	false	SK-D-220	16	4	4	2	220	500	4000	3000		¤ 32.84
303	false	XP-D-100S	16	4	4	2	100	100	1650	1820		¤ 36.19
304	false	66528H-G8	16	4	4	2	100	500	2700	2400		¤ 27.48
305	false	A4366-40-E11	16	4	4	2	40	600	800	2100		¤ 36.24
306	false	A4366-60-E11	16	4	4	2	60	500	800	2200		¤ 36.24
307	false	A4366-60-E10	16	4	4	2	60	500	800	2200		¤ 39.55
308	false	5588-Bi-Pin	16	4	4	2	75	500	1100	1350		¤ 32.98
309	false	HIP-1452-GX7.9	16	4	27	2	150	25	950	1588		¤ 15.35
310	false	55874-30-G6.35	16	1	27	2	30	1000	2200	3200		¤ 18.70

MgtID	ManageName	Address	City	State	ZIP	PhoneNum	ContactFirstName	ContactLastName	ContractEnds
1	Advocate Lutheran General Hospital	1775 Dempster Street	Park Ridge	IL	60068	(847) 723-2210	Paola	Bandini	4/30/16
2	Albert Einstein Healthcare Network	5501 Old York Road	Philadelphia	PA	19141	(215) 456-7890	Antonio	Lara	11/30/15
3	Avera McKennan Hospital & University Health Center	800 East 21st Street	Sioux Falls	SD	57117	(605) 322-8000	Deanna	Zitterkopf	5/31/16
4	BJC Healthcare	12634 Olive Boulevard	St. Louis	MO	63141	(314) 996-8000	John	Loveland	1/31/16
5	Beaumont Hospitals	3601 W. Thirteen Mile Road	Royal Oak	MI	48073		Sharon	MacKendrick	10/31/15
6	Barnes-Jewish West County Hospital	12634 Olive Boulevard	Saint Louis	MO	63141	(314) 996-8410	Janie	Ward	1/31/16
7	Beth Israel Medical Group	First Avenue at 16th Street	New York	NY	10002	(212) 420-2000	Joydeep	Mitra	4/30/16
8	Cedars-Sinai Health System	8700 Beverly Blvd.	Los Angeles	CA	90048		Sandra	Hambrick	11/30/15
9	Christiana Health Care System	PO Box 1668	Wilmington	DE	19899		Robert	Czerniak	7/31/16
10	Beth Israel Medical Center - Petrie Division	First Avenue at 16th Street	New York	NY	10003	(212) 420-2000	John	Leyba	8/31/16
11	Broughton Hospital	1000 South Sterling Street	Morganton	NC	28655	(828) 433-2111	Mildred	Latini	12/31/15
12	Adventist Health System	730 Courtland Street	Orlando	FL	32804		Roberta	Himebrook	4/30/16
13	Christiana Hospital	4755 Ogletown-Stanton Road	Newark	DE	19718	(302) 733-1000	Roberto	Apodaca	7/31/16
14	Coler-Goldwater Specialty Hospital & Nursing Facililty	One Main Street	Roosevelt Island	NY	10044	(212) 848-6000	Anil	Rupashingha	11/30/15
15	Columbia Saint Mary's Hospital Milwaukee	2323 North Lake Drive	Milwaukee	WI	53211	(414) 291-1000	Jack	Ruttle	6/30/16
16	Grady Memorial Hospital Authority	80 Jesse Hill Jr Drive SE	Atlanta	GA	30303	(404) 616-1000	Judith	Franzak	5/31/16
17	Ohio Health Corporate Offices	180 East Broad Street	Columbus	OH	43215		Vernal	Gledhill	6/30/15
18	Emory University Hospital Midtown	550 Peachtree Street Northeast	Atlanta	GA	30308	(404) 686-4411	Mai	Gehrke	12/31/15
19	Inova Health System	8110 Gatehouse Road	Falls Church	VA	22042		Cindy	Seipel	5/31/16
20	Florida Hospital Orlando	601 East Rollins Street	Orlando	FL	32803	(407) 303-6611	Susan	Crane	9/30/16
21	Forsyth Medical Center	3333 Silas Creek Parkway	Winston-Salem	NC	27103	(336) 718-5000	Margaret-Ann	Hazlewood	8/31/15
22	Gateway Rehabilitation Hospital	315 East Broadway	Louisville	KY	40202	(502) 315-8300	Judy	Maese	7/31/16
23	Health Alliance	3200 Burnet Ave.	Cincinnati	OH	45219		Kelly	McFall	6/30/16
24	Grady Memorial Hospital	2220 Iowa Avenue	Chickasha	OK	73018	(405) 224-2300	William	Dick-Peddie	5/31/16
25	Grady Memorial Hospital	80 Jesse Hill Jr. Drive Southeast	Atlanta	GA	30303	(404) 616-1000	Allie-Sue	Gottwald	4/30/15
26	Grady Memorial Hospital	561 West Central Avenue	Delaware	OH	43015	(740) 369-8711	Surendra	Singh	5/31/16
27	Greenville Memorial Hospital	701 Grove Road	Greenville	SC	29605	(864) 455-7000	Jacob	Urquidi	1/31/16
28	Mayo Foundation for Medical Education and Research	1216 Second Street Southwest	Rochester	MN	55902	(507) 255-5123	Jo Ann	Hill	10/31/15
29	Hahnemann University Hospital	Broad and Vine	Philadelphia	PA	19102	(215) 762-7000	Danny	Scoccia	12/31/15
30	Clarian Health - Administration Offices	P.O. Box 1367	Indianapolis	IN	46206	317-916-3525	Windell	Hambrick	9/30/16
31	Hospital of the University of Pennsylvania	3400 Spruce Street	Philadelphia	PA	19104	(215) 662-4000	Nirmala	Gunapala	1/31/16
32	Inova Fairfax Hospital	3300 Gallows Road	Falls Church	VA	22042	(703) 776-4001	Yu-Li	Huang	6/30/16
33	Miami Jewish Health Systems	1200 East Pecan	Altus	OK	73521	(580) 482-4781	Carl	Hall	4/30/16
34	Jackson Memorial Hospital	1611 Northwest 12th Avenue	Miami	FL	33136	(305) 585-1111	Roger	Lord	9/30/15
35	NewYork-Presbyterian Health Care System	200 Abraham Flexner Way	Louisville	KY	40202	(502) 587-4011	Teresa	Bazil	3/31/16
36	North Shore-Long Island Jewish Health System	900 Franklin Avenue	Valley Stream	NY	11580	(516) 256-6000	Budh	Ram	9/30/16
37	Jewish Memorial Hospital and Rehabilitation Center	59 Townsend Street	Boston	MA	2119	(617) 989-8315	Jamey	Findling	12/31/15
38	Mountain States Health Alliance	2335 Knob Creek Road, Suite 10	Johnson City	TN	37604	(423) 952-3110	Ahmad	Shouman	1/31/16
39	Laguna Honda Hospital	375 Laguna Honda Boulevard	San Francisco	CA	94116	(415) 759-2300	Jack	Ruttle	3/31/16
40	Lawrence Memorial Hospital	325 Maine Street	Lawrence	KS	66044	(785) 505-5000	Gregory	Blanch	5/31/16
41	Lehigh Valley Hospital - Cedar Crest	1200 Cedar Crest Boulevard	Allentown	PA	18105	(610) 402-8001	Joshua	Papsdorf	9/30/15
42	Massachusetts General Hospital	55 Fruit Street	Boston	MA	2114	(617) 726-2000	Sergei	Nirenburg	10/31/15
43	Mayo Clinic	1216 Second Street Southwest	Rochester	MN	55902	(507) 255-5123	Harvey	White	1/31/16
44	Medical University of South Carolina	171 Ashley Avenue	Charleston	SC	29425	(843) 792-2300	Stephen	Palubicki	8/31/16
45	Memorial Hermann Southwest Hospital	7600 Beechnut	Houston	TX	77074	(713) 456-5000	William	Neish	1/31/16
46	Methodist University Hospital	1265 Union Avenue	Memphis	TN	38104	(901) 516-7000	Mingjun	Wei	11/30/15
47	Metropolitan State Hospital	11401 Bloomfield Avenue	Norwalk	CA	90650	(562) 863-7011	Joseph	Goetze	1/31/16
48	Miami Jewish Home & Hospital	5200 Northeast Second Avenue	Miami	FL	33137	(305) 751-8626	Jennifer	Sheppard	6/30/16
49	Mount Sinai Hospital	California Avenue at Fifthteen	Chicago	IL	60608	(773) 542-2000	Gregory	Blanch	2/29/16
50	New York Methodist Hospital	506 Sixth Street	Brooklyn	NY	11215	(718) 780-3000	Bryan	Dietrich	1/31/15
51	New York-Presbyterian Hospital/Weill Cornell Medical Center	525 East 68th Street	New York	NY	10065	(212) 746-5454	Patricia	MacGregor-Mendoza	4/30/15
52	North Shore University Hospital	300 Community Drive	Manhasset	NY	11030	(516) 562-0100	John	Monagle	2/29/16
53	Northwestern Memorial Hospital	251 East Huron	Chicago	IL	60611	(312) 926-2000	Charles	Merrifield	11/30/15
54	Norton Audubon Hospital	One Audubon Plaza Drive	Louisville	KY	40217	(502) 636-7111	Heather	Boyce-Broddle	6/30/16
55	Norton Healthcare	200 East Chestnut Street	Louisville	KY	40202	(502) 629-8000	Leo	LaFrance	2/29/16
56	Ohio State University Hospital	410 West Tenth Avenue	Columbus	OH	43210	(614) 293-8000	Ruinan	Jiang	6/30/16
57	Orlando Regional Medical Center	1414 Kuhl Avenue	Orlando	FL	32806	(321) 841-5111	Lewis	Holland	8/31/16
58	Parkview Community Hospital Medical Center	3865 Jackson Street	Riverside	CA	92503	(951) 688-2211	Laurence	Heck	3/31/16
59	Parkview Whitley Hospital	353 North Oak Street	Columbia City	IN	46725	(260) 248-9000	Jose	Arreola	9/30/15
60	Presbyterian Hospital	200 Hawthorne Lane	Charlotte	NC	28204	(704) 384-4000	Debra	Gowing	3/31/16
61	Presbyterian Hospital	1100 Central Avenue Southeast	Albuquerque	NM	87106	(505) 841-1234	Shelley	Lee	4/30/16
62	Presbyterian Intercommunity Hospital	12401 Washington Boulevard	Whittier	CA	90602	(562) 698-0811	Joseph	Gile	5/31/16
64	Robert Wood Johnson University Hospital	One Robert Wood Johnson Place	New Brunswick	NJ	08903	(732) 828-3000	Billie	Kissiah	9/30/15
65	Robert Wood Johnson University Hospital at Rahway	865 Stone Street	Rahway	NJ	07065	(732) 381-4200	Jamshid	Ashigh	5/31/16
66	Robert Wood Johnson University Hospital Hamilton	One Hamilton Health Place	Hamilton	NJ	08690	(609) 586-7900	Bernadette	Fetterolf	9/30/15
67	Ryder Memorial Hospital	355 Font Martelo Street	Humacao	PR	00791	(787) 852-0768	Gregory	Smith	5/31/16
68	Sacred Heart Medical Center	101 West Eighth Avenue	Spokane	WA	99204	(509) 474-3131	Helga	DeLisle	3/31/16
69	Sacred Heart Medical Center	1255 Hilyard Street	Eugene	OR	97401	(541) 686-7300	Yu-Feng	Lee	8/31/15
70	Saint Dominic-Jackson Memorial Hospital	969 Lakeland Drive	Jackson	MS	39216	(601) 200-2000	Barbara	Sponse	12/31/15
71	Saint John's Episcopal Hospital	327 Beach 19th Street	Far Rockaway	NY	11691	(718) 869-7000	Kathleen	Smith	11/30/15
72	Saint John's Hospital	1235 East Cherokee Street	Springfield	MO	65804	(417) 820-2000	Linda	Rhone	9/30/15
73	Saint John's Hospital	800 East Carpenter Street	Springfield	IL	62769	(217) 544-6464	Richard	Heerema	11/30/15
74	Saint John's Mercy Medical Center	615 South New Ballas Road	Saint Louis	MO	63141	(314) 251-6000	Volney	Howard	4/30/16
75	Saint John's Riverside Hospital - Andrus Pavilion	967 North Broadway	Yonkers	NY	10701	(914) 964-4444	Jonathan	Cook	12/31/15
76	Saint Luke's Memorial Hospital	Ave. Tito Castro 917	Ponce	PR	00733	(787) 844-2080	Barry	Koch	10/31/15
77	Saint Mary's Hospital	1601 West Saint Mary's Road	Tucson	AZ	85745	(520) 872-3000	Lana	Schulte	7/31/16
78	Saint Mary's Hospital	350 Boulevard	Passaic	NJ	07055	(973) 365-4300	Louis	Ocepek	6/30/16
79	Saint Mary's Hospital	5801 Bremo Road	Richmond	VA	23226	(804) 285-2011	Charlotte	Rohrbach	5/31/15
80	Saint Mary's Hospital & Regional Medical Center	2635 North Seventh Street	Grand Junction	CO	81502	(970) 244-2273	Reed	Dasenbrock	10/31/15
81	Saint Mary's Hospital at Amsterdam	4988 State Highway 30	Amsterdam	NY	12010	(518) 842-3100	Amy	Siple	7/31/16
82	Scripps Mercy Hospital	4077 Fifth Avenue	San Diego	CA	92103	(619) 294-8111	Haobin	Wang	9/30/16
83	Shands at the University of Florida	1600 Southwest Archer Road	Gainesville	FL	32608	(352) 265-8000	Barry	Herd	6/30/16
84	Sparrow Hospital	1215 East Michigan Avenue	Lansing	MI	48912	(517) 364-1000	Gloria	Hegge	12/31/15
85	Sparrow Specialty Hospital	1210 West Saginaw Street	Lansing	MI	48908	(517) 364-6800	Satishkuma	Ranade	8/31/16
86	Stonewall Jackson Memorial Hospital	230 Hospital Plaza	Weston	WV	26452	(304) 269-8000	Amiya	Bhattacharya	12/31/15
87	Temple University Hospital	3401 North Broad Street	Philadelphia	PA	19140	(215) 707-2000	Susana	Salamanca-Riba	10/31/15
88	Texas Health Harris Methodist Hospital Fort Worth	1301 Pennsylvania Avenue	Fort Worth	TX	76104	(817) 250-2000	Deva	Borah	5/31/16
89	Texas Health Presbyterian Hospital Dallas	8200 Walnut Hill Lane	Dallas	TX	75231	(214) 345-6789	Cecilio	Barrera	5/31/16
90	Texas Health Presbyterian Hospital Plano	6200 West Parker Road	Plano	TX	75093	(972) 981-8000	John	McCormick	4/30/16
91	The Johns Hopkins Hospital	600 North Wolfe Street	Baltimore	MD	21287	(410) 955-5000	Duncan	Rose	12/31/15
92	The Methodist Hospital	6565 Fannin Street	Houston	TX	77030	(713) 790-3311	William	Smith	3/31/16
93	The Moses H. Cone Memorial Hospital	1200 North Elm Street	Greensboro	NC	27401	(336) 832-7000	Don	Hufford	2/29/16
94	The Mount Sinai Hospital	One Gustave L. Levy Place	New York	NY	10029	(212) 241-6500	Rebecca	Astorga	12/31/15
95	Thomas Jefferson University Hospital	111 South 11th Street	Philadelphia	PA	19107	(215) 955-6000	Manoj	Shukla	1/31/16
96	University Hospital	234 Goodman Street	Cincinnati	OH	45219	(513) 584-1000	John	Conlee	2/29/16
97	University Hospital	1350 Walton Way	Augusta	GA	30901	(706) 722-9011	Carolyn	Muehring	8/31/16
98	University Hospitals Case Medical Center	11100 Euclid Avenue	Cleveland	OH	44106	(216) 844-1000	Felipe	Peralta	12/31/15
99	University of Colorado Hospital	12605 East 16th Avenue	Aurora	CO	80045	(720) 848-0000	Heather	Oesterrich	2/29/16
100	University of Kentucky Hospital	800 Rose Street	Lexington	KY	40536	(859) 323-5000	Tiziana	Giorgi	3/31/16
101	University of Louisville Hospital	530 South Jackson Street	Louisville	KY	40202	(502) 562-3000	Boyden	Lee	10/31/15
102	University of New Mexico Hospital	2211 Lomas Boulevard Northeast	Albuquerque	NM	87106	(505) 272-2111	Audrey	Hane	2/29/16
103	University of Pittsburgh Medical Center Presbyterian	200 Lothrop Street	Pittsburgh	PA	15213	(412) 647-2345	Thomas	Gale	8/31/16
104	Valley Presbyterian Hospital	15107 Vanowen Street	Van Nuys	CA	91405	(818) 782-6600	Enrico	Pontelli	11/30/15
105	Washington Hospital Center	110 Irving Street, Northwest	Washington	DC	20010	(202) 877-7000	Sukumar	Brahma	10/31/16
106	Wesley Medical Center	5001 Hardy Street	Hattiesburg	MS	39402	(601) 268-8000	Mark	Waltermire	12/31/15
107	Wesley Medical Center	550 North Hillside	Wichita	KS	67214	(316) 962-2000	Dennis	Hallford	8/31/16
111	High Country Hospital	2 Main Street	Rochester	MN	55902-	(507) 658-9548	Bob	Mahoney	9/30/15

MgtTypeID	ManageType
1	Governmental, City
2	Governmental, City-County
3	Governmental, County
4	Governmental, Other
5	Governmental, State
6	Other
7	Proprietary, Corporation
8	Proprietary, Other
9	Short Term Acute Care
10	Voluntary Nonprofit, Church
11	Voluntary Nonprofit, Other

StockID	CompanyName	Symbol	Percent	Contact	Phone	Fax
1	Central Z Investment	cgzst	0.312	Joseph Edwards	(555) 258-6485	(555) 258-6488
2	Hopcorp Industries	bvzst	0.154	Vera McLimans	(555) 715-4454	(555) 715-4444
3	Growth ChemTech	gjzst	0.0855	Erik Peterson	(555) 857-9154	(555) 857-9155
4	Zeon Investments	djzst	0.2435	Jiang Nuo	(555) 661-7545	(555) 661-7555
5	Ajendro Economy	azzst	0.205	Ivana Estrada	(555) 565-8878	(555) 565-8879

VenderID	VenderName	ContactName	Address	City	State	ZIP	PhoneNum	FAX
1	ALL, Inc.	Bob Riley	600 Dexter Street	Montgomery	AL	36130-2751	334-242-7100	334-242-0937
2	AM Lighting Group, Inc.	Bev Perdue	20301 Service Center	Raleigh	NC	27699-0301	919-733-5811	919-733-2120
3	American Pro Lighting	Bill Richardson	4671 Fourth Blvd.	Santa Fe	NM	87501	505-476-2200	505-476-2226
4	AnyBulb	Bobby Jindal	P. O. Box 94004	Baton Rouge	LA	70804-9004	225-342-7015	225-342-7099
5	Bob-Mathus Green	Brad Henry	2300 Lincoln Blvd.	Oklahoma City	OK	73105	405-521-2342	405-521-3353
6	Bulb Pro Star	Brian Schweitzer	P.O. Box 200801	Helena	MT	59620-0801	406-444-3111	406-444-5529
7	Cobra, Inc.	C.L. "Butch" Otter	P.O. Box 83720	Boise	ID	83720-0034	208-334-2100	208-334-2175
8	Corso Lighting, Inc.	Charlie Crist	311 Industrial Street	Tallahassee	FL	32399-0001	850-488-2272	850-922-4292
9	DiCad, Inc.	Chris Gregoire	P.O. Box 40002	Olympia	WA	98504-0002	360-902-4111	360-753-4110
10	EarthElectric, Inc.	Dave Freudenthal	124 James Ave.	Cheyenne	WY	82002	307-777-7434	307-632-3909
12	Gordon's Lighting Electrical	Don Carcieri	317 Brown Street	Providence	RI	02903-1196	401-222-2080	401-273-5729
14	Henderson's and Sons, Inc.	Haley Barbour	P.O. Box 139	Jackson	MS	39205	601-359-3150	601-359-3741
15	Highland Companies, Inc.	Jack Markell	955 William Penn Street	Dover	DE	19901	302-744-4101	302-739-2775
16	Home Supply Shop	Jan Brewer	1700 W. Washington	Phoenix	AZ	85007	602-542-4331	602-542-7601
17	Light Americana	Jennifer M. Granholm	P.O. Box 30013	Lansing	MI	48909	517-373-3400	517-335-6863
18	Locici Lighting Industrial Co.	Jim Doyle	P.O. Box 7863	Madison	WI	53707	608-266-1212	608-267-8983
19	Plarso Ltd.	John Baldacci	1 State House Station	Augusta	ME	4333	207-287-3531	207-287-1034
20	ProLife Electronics, Inc.	John Hoeven	600 East Avenue	Bismarck	ND	58505-0001	701-328-2200	701-328-2205
21	Rubi Lighting	Mark Sanford	P.O. Box 12267	Columbia	SC	29211	803-734-2100	803-734-5167
22	SafeEarth Inc.	Mike Beebe	250 Chelse Ave.	Little Rock	AR	72201	501-682-2345	501-682-1382
23	Sarco	Mike Rounds	500 East Capitol Ave.	Pierre	SD	57501	605-773-3212	605-773-5844
24	Shanghai Electric, Inc.	Pat Quinn	207 Statehouse	Springfield	IL	62706	217-782-6830	217-524-4049
25	Special Delivery	Phil Bredesen	6399 Harvard	Nashville	TN	37243-0001	615-741-2001	615-532-9711
26	TAB Industries, Inc.	Rick Perry	P.O. Box 12428	Austin	TX	78711	512-463-2000	512-463-5571
27	Unio Lighting	Steven Beshear	700 Capitol Ave.	Frankfort	KY	40601	502-564-2611	502-564-0437
28	Weit Electric	Ted Kulongoski	900 Court St., NE	Salem	OR	97301-4047	503-378-3111	503-378-8970
29	Yong Greenlight Technology	Tim Kaine	1111 East Broad Street	Richmond	VA	23219	804-786-2211	804-371-6351
31	Henderson's and Sons, Inc.	Haley Barbour	P.O. Box 139	Jackson	MS	39205	601-359-3150	601-359-3741

SELECT tblManageType.[MgtTypeID], [tblManageType].[ManageType] FROM tblManageType ORDER BY [ManageType];

SELECT tblFacilities.[FacID], tblFacilities.FacName, tblFacilities.ContactFirstName, tblFacilities.ContactLastName, tblFacilities.PhoneNum, tblFacilities.[Region] FROM tblFacilities;

SELECT DISTINCTROW * FROM tblFacilities;