Table: emergency_department_volume_and_capacity_2021 , countyname like F*

A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  X  Y  Z  *

oshpd_id	facilityname2	countyname	system_name	licensed_bed_size	hospitalownership	urbanruraldesi	teachingdesignation	category	tot_ed_nmbvsts	edstations	eddxcount	latitude	longitude	primarycareshortagearea	mentalhealthshortagearea
106100005	Clovis Community Medical Center	Fresno	N/A	300-499	Nonprofit	Rural	Non-Teaching	Pneumonia	46564	59	1020	36.83745	-119.66072	Yes	Yes
106100005	Clovis Community Medical Center	Fresno	N/A	300-499	Nonprofit	Rural	Non-Teaching	Cardiac	46564	59	66	36.83745	-119.66072	Yes	Yes
106100005	Clovis Community Medical Center	Fresno	N/A	300-499	Nonprofit	Rural	Non-Teaching	Cancer	46564	59	418	36.83745	-119.66072	Yes	Yes
106100005	Clovis Community Medical Center	Fresno	N/A	300-499	Nonprofit	Rural	Non-Teaching	Respiratory	46564	59	37	36.83745	-119.66072	Yes	Yes
106100005	Clovis Community Medical Center	Fresno	N/A	300-499	Nonprofit	Rural	Non-Teaching	Mental Health	46564	59	3073	36.83745	-119.66072	Yes	Yes
106100005	Clovis Community Medical Center	Fresno	N/A	300-499	Nonprofit	Rural	Non-Teaching	Hypertension	46564	59	12262	36.83745	-119.66072	Yes	Yes
106100005	Clovis Community Medical Center	Fresno	N/A	300-499	Nonprofit	Rural	Non-Teaching	COPD	46564	59	683	36.83745	-119.66072	Yes	Yes
106100005	Clovis Community Medical Center	Fresno	N/A	300-499	Nonprofit	Rural	Non-Teaching	Substance Abuse	46564	59	4019	36.83745	-119.66072	Yes	Yes
106100005	Clovis Community Medical Center	Fresno	N/A	300-499	Nonprofit	Rural	Non-Teaching	Sepsis	46564	59	38	36.83745	-119.66072	Yes	Yes
106100005	Clovis Community Medical Center	Fresno	N/A	300-499	Nonprofit	Rural	Non-Teaching	Diabetes	46564	59	6181	36.83745	-119.66072	Yes	Yes
106100005	Clovis Community Medical Center	Fresno	N/A	300-499	Nonprofit	Rural	Non-Teaching	Obesity	46564	59	680	36.83745	-119.66072	Yes	Yes
106100005	Clovis Community Medical Center	Fresno	N/A	300-499	Nonprofit	Rural	Non-Teaching	Stroke	46564	59	48	36.83745	-119.66072	Yes	Yes
106100005	Clovis Community Medical Center	Fresno	N/A	300-499	Nonprofit	Rural	Non-Teaching	Active COVID-19	46564	59	2262	36.83745	-119.66072	Yes	Yes
106100005	Clovis Community Medical Center	Fresno	N/A	300-499	Nonprofit	Rural	Non-Teaching	COVID-19 History	46564	59	391	36.83745	-119.66072	Yes	Yes
106100005	Clovis Community Medical Center	Fresno	N/A	300-499	Nonprofit	Rural	Non-Teaching	Asthma	46564	59	4030	36.83745	-119.66072	Yes	Yes
106100005	Clovis Community Medical Center	Fresno	N/A	300-499	Nonprofit	Rural	Non-Teaching	Homeless	46564	59	919	36.83745	-119.66072	Yes	Yes
106100005	Clovis Community Medical Center	Fresno	N/A	300-499	Nonprofit	Rural	Non-Teaching	All ED Visits	46564	59	46564	36.83745	-119.66072	Yes	Yes
106100697	Coalinga Regional Medical Center	Fresno	N/A	100-149	Investor Owned	Rural	Non-Teaching	Mental Health	6307	9	175	36.15152	-120.34035	Yes	Yes
106100697	Coalinga Regional Medical Center	Fresno	N/A	100-149	Investor Owned	Rural	Non-Teaching	Substance Abuse	6307	9	150	36.15152	-120.34035	Yes	Yes
106100697	Coalinga Regional Medical Center	Fresno	N/A	100-149	Investor Owned	Rural	Non-Teaching	Respiratory	6307	9	8	36.15152	-120.34035	Yes	Yes
106100697	Coalinga Regional Medical Center	Fresno	N/A	100-149	Investor Owned	Rural	Non-Teaching	Pneumonia	6307	9	72	36.15152	-120.34035	Yes	Yes
106100697	Coalinga Regional Medical Center	Fresno	N/A	100-149	Investor Owned	Rural	Non-Teaching	Obesity	6307	9	12	36.15152	-120.34035	Yes	Yes
106100697	Coalinga Regional Medical Center	Fresno	N/A	100-149	Investor Owned	Rural	Non-Teaching	Sepsis	6307	9	7	36.15152	-120.34035	Yes	Yes
106100697	Coalinga Regional Medical Center	Fresno	N/A	100-149	Investor Owned	Rural	Non-Teaching	Cancer	6307	9	12	36.15152	-120.34035	Yes	Yes
106100697	Coalinga Regional Medical Center	Fresno	N/A	100-149	Investor Owned	Rural	Non-Teaching	COPD	6307	9	16	36.15152	-120.34035	Yes	Yes
106100697	Coalinga Regional Medical Center	Fresno	N/A	100-149	Investor Owned	Rural	Non-Teaching	Cardiac	6307	9	11	36.15152	-120.34035	Yes	Yes
106100697	Coalinga Regional Medical Center	Fresno	N/A	100-149	Investor Owned	Rural	Non-Teaching	Homeless	6307	9	6	36.15152	-120.34035	Yes	Yes
106100697	Coalinga Regional Medical Center	Fresno	N/A	100-149	Investor Owned	Rural	Non-Teaching	Hypertension	6307	9	105	36.15152	-120.34035	Yes	Yes
106100697	Coalinga Regional Medical Center	Fresno	N/A	100-149	Investor Owned	Rural	Non-Teaching	Stroke	6307	9	7	36.15152	-120.34035	Yes	Yes
106100697	Coalinga Regional Medical Center	Fresno	N/A	100-149	Investor Owned	Rural	Non-Teaching	Diabetes	6307	9	78	36.15152	-120.34035	Yes	Yes
106100697	Coalinga Regional Medical Center	Fresno	N/A	100-149	Investor Owned	Rural	Non-Teaching	Asthma	6307	9	65	36.15152	-120.34035	Yes	Yes
106100697	Coalinga Regional Medical Center	Fresno	N/A	100-149	Investor Owned	Rural	Non-Teaching	Active COVID-19	6307	9	171	36.15152	-120.34035	Yes	Yes
106100697	Coalinga Regional Medical Center	Fresno	N/A	100-149	Investor Owned	Rural	Non-Teaching	All ED Visits	6307	9	6307	36.15152	-120.34035	Yes	Yes
106100697	Coalinga Regional Medical Center	Fresno	N/A	100-149	Investor Owned	Rural	Non-Teaching	COVID-19 History	6307	9	8	36.15152	-120.34035	Yes	Yes
106100717	Community Regional Medical Center – Fresno	Fresno	N/A	500+	Nonprofit	Urban	Teaching	All ED Visits	74382	73	74382	36.74252	-119.784071	Yes	No
106100717	Community Regional Medical Center – Fresno	Fresno	N/A	500+	Nonprofit	Urban	Teaching	Obesity	74382	73	1509	36.74252	-119.784071	Yes	No
106100717	Community Regional Medical Center – Fresno	Fresno	N/A	500+	Nonprofit	Urban	Teaching	COVID-19 History	74382	73	631	36.74252	-119.784071	Yes	No
106100717	Community Regional Medical Center – Fresno	Fresno	N/A	500+	Nonprofit	Urban	Teaching	Stroke	74382	73	48	36.74252	-119.784071	Yes	No
106100717	Community Regional Medical Center – Fresno	Fresno	N/A	500+	Nonprofit	Urban	Teaching	Asthma	74382	73	4889	36.74252	-119.784071	Yes	No
106100717	Community Regional Medical Center – Fresno	Fresno	N/A	500+	Nonprofit	Urban	Teaching	Respiratory	74382	73	39	36.74252	-119.784071	Yes	No
106100717	Community Regional Medical Center – Fresno	Fresno	N/A	500+	Nonprofit	Urban	Teaching	Cardiac	74382	73	361	36.74252	-119.784071	Yes	No
106100717	Community Regional Medical Center – Fresno	Fresno	N/A	500+	Nonprofit	Urban	Teaching	Cancer	74382	73	289	36.74252	-119.784071	Yes	No
106100717	Community Regional Medical Center – Fresno	Fresno	N/A	500+	Nonprofit	Urban	Teaching	Hypertension	74382	73	13354	36.74252	-119.784071	Yes	No
106100717	Community Regional Medical Center – Fresno	Fresno	N/A	500+	Nonprofit	Urban	Teaching	Substance Abuse	74382	73	7765	36.74252	-119.784071	Yes	No
106100717	Community Regional Medical Center – Fresno	Fresno	N/A	500+	Nonprofit	Urban	Teaching	Homeless	74382	73	7173	36.74252	-119.784071	Yes	No
106100717	Community Regional Medical Center – Fresno	Fresno	N/A	500+	Nonprofit	Urban	Teaching	Active COVID-19	74382	73	2773	36.74252	-119.784071	Yes	No
106100717	Community Regional Medical Center – Fresno	Fresno	N/A	500+	Nonprofit	Urban	Teaching	COPD	74382	73	1310	36.74252	-119.784071	Yes	No
106100717	Community Regional Medical Center – Fresno	Fresno	N/A	500+	Nonprofit	Urban	Teaching	Diabetes	74382	73	8310	36.74252	-119.784071	Yes	No
106100717	Community Regional Medical Center – Fresno	Fresno	N/A	500+	Nonprofit	Urban	Teaching	Sepsis	74382	73	34	36.74252	-119.784071	Yes	No
106100717	Community Regional Medical Center – Fresno	Fresno	N/A	500+	Nonprofit	Urban	Teaching	Pneumonia	74382	73	606	36.74252	-119.784071	Yes	No
106100717	Community Regional Medical Center – Fresno	Fresno	N/A	500+	Nonprofit	Urban	Teaching	Mental Health	74382	73	6395	36.74252	-119.784071	Yes	No
106100797	Adventist Health Reedley	Fresno	Adventist Health Systems	Jan-49	Nonprofit	Rural	Non-Teaching	Mental Health	32277	10	1882	36.60789	-119.45145	Yes	Yes
106100797	Adventist Health Reedley	Fresno	Adventist Health Systems	Jan-49	Nonprofit	Rural	Non-Teaching	Substance Abuse	32277	10	2069	36.60789	-119.45145	Yes	Yes
106100797	Adventist Health Reedley	Fresno	Adventist Health Systems	Jan-49	Nonprofit	Rural	Non-Teaching	Cancer	32277	10	83	36.60789	-119.45145	Yes	Yes
106100797	Adventist Health Reedley	Fresno	Adventist Health Systems	Jan-49	Nonprofit	Rural	Non-Teaching	Obesity	32277	10	753	36.60789	-119.45145	Yes	Yes
106100797	Adventist Health Reedley	Fresno	Adventist Health Systems	Jan-49	Nonprofit	Rural	Non-Teaching	Respiratory	32277	10	40	36.60789	-119.45145	Yes	Yes
106100797	Adventist Health Reedley	Fresno	Adventist Health Systems	Jan-49	Nonprofit	Rural	Non-Teaching	Cardiac	32277	10	56	36.60789	-119.45145	Yes	Yes
106100797	Adventist Health Reedley	Fresno	Adventist Health Systems	Jan-49	Nonprofit	Rural	Non-Teaching	Stroke	32277	10	21	36.60789	-119.45145	Yes	Yes
106100797	Adventist Health Reedley	Fresno	Adventist Health Systems	Jan-49	Nonprofit	Rural	Non-Teaching	Diabetes	32277	10	2906	36.60789	-119.45145	Yes	Yes
106100797	Adventist Health Reedley	Fresno	Adventist Health Systems	Jan-49	Nonprofit	Rural	Non-Teaching	Homeless	32277	10	32	36.60789	-119.45145	Yes	Yes
106100797	Adventist Health Reedley	Fresno	Adventist Health Systems	Jan-49	Nonprofit	Rural	Non-Teaching	Sepsis	32277	10	52	36.60789	-119.45145	Yes	Yes
106100797	Adventist Health Reedley	Fresno	Adventist Health Systems	Jan-49	Nonprofit	Rural	Non-Teaching	Active COVID-19	32277	10	1684	36.60789	-119.45145	Yes	Yes
106100797	Adventist Health Reedley	Fresno	Adventist Health Systems	Jan-49	Nonprofit	Rural	Non-Teaching	Hypertension	32277	10	3825	36.60789	-119.45145	Yes	Yes
106100797	Adventist Health Reedley	Fresno	Adventist Health Systems	Jan-49	Nonprofit	Rural	Non-Teaching	COPD	32277	10	160	36.60789	-119.45145	Yes	Yes
106100797	Adventist Health Reedley	Fresno	Adventist Health Systems	Jan-49	Nonprofit	Rural	Non-Teaching	Asthma	32277	10	950	36.60789	-119.45145	Yes	Yes
106100797	Adventist Health Reedley	Fresno	Adventist Health Systems	Jan-49	Nonprofit	Rural	Non-Teaching	COVID-19 History	32277	10	606	36.60789	-119.45145	Yes	Yes
106100797	Adventist Health Reedley	Fresno	Adventist Health Systems	Jan-49	Nonprofit	Rural	Non-Teaching	All ED Visits	32277	10	32277	36.60789	-119.45145	Yes	Yes
106100797	Adventist Health Reedley	Fresno	Adventist Health Systems	Jan-49	Nonprofit	Rural	Non-Teaching	Pneumonia	32277	10	351	36.60789	-119.45145	Yes	Yes
106100899	Saint Agnes Medical Center	Fresno	N/A	300-499	Nonprofit	Urban	Non-Teaching	Pneumonia	56514	48	805	36.8370782	-119.7649963	No	Yes
106100899	Saint Agnes Medical Center	Fresno	N/A	300-499	Nonprofit	Urban	Non-Teaching	Mental Health	56514	48	5743	36.8370782	-119.7649963	No	Yes
106100899	Saint Agnes Medical Center	Fresno	N/A	300-499	Nonprofit	Urban	Non-Teaching	Cancer	56514	48	395	36.8370782	-119.7649963	No	Yes
106100899	Saint Agnes Medical Center	Fresno	N/A	300-499	Nonprofit	Urban	Non-Teaching	Hypertension	56514	48	16506	36.8370782	-119.7649963	No	Yes
106100899	Saint Agnes Medical Center	Fresno	N/A	300-499	Nonprofit	Urban	Non-Teaching	COPD	56514	48	1826	36.8370782	-119.7649963	No	Yes
106100899	Saint Agnes Medical Center	Fresno	N/A	300-499	Nonprofit	Urban	Non-Teaching	Substance Abuse	56514	48	5626	36.8370782	-119.7649963	No	Yes
106100899	Saint Agnes Medical Center	Fresno	N/A	300-499	Nonprofit	Urban	Non-Teaching	Diabetes	56514	48	8902	36.8370782	-119.7649963	No	Yes
106100899	Saint Agnes Medical Center	Fresno	N/A	300-499	Nonprofit	Urban	Non-Teaching	All ED Visits	56514	48	56514	36.8370782	-119.7649963	No	Yes
106100899	Saint Agnes Medical Center	Fresno	N/A	300-499	Nonprofit	Urban	Non-Teaching	Asthma	56514	48	8070	36.8370782	-119.7649963	No	Yes
106100899	Saint Agnes Medical Center	Fresno	N/A	300-499	Nonprofit	Urban	Non-Teaching	Active COVID-19	56514	48	2481	36.8370782	-119.7649963	No	Yes
106100899	Saint Agnes Medical Center	Fresno	N/A	300-499	Nonprofit	Urban	Non-Teaching	Obesity	56514	48	876	36.8370782	-119.7649963	No	Yes
106100899	Saint Agnes Medical Center	Fresno	N/A	300-499	Nonprofit	Urban	Non-Teaching	Homeless	56514	48	1450	36.8370782	-119.7649963	No	Yes
106100899	Saint Agnes Medical Center	Fresno	N/A	300-499	Nonprofit	Urban	Non-Teaching	Cardiac	56514	48	70	36.8370782	-119.7649963	No	Yes
106100899	Saint Agnes Medical Center	Fresno	N/A	300-499	Nonprofit	Urban	Non-Teaching	Respiratory	56514	48	69	36.8370782	-119.7649963	No	Yes
106100899	Saint Agnes Medical Center	Fresno	N/A	300-499	Nonprofit	Urban	Non-Teaching	Stroke	56514	48	62	36.8370782	-119.7649963	No	Yes
106100899	Saint Agnes Medical Center	Fresno	N/A	300-499	Nonprofit	Urban	Non-Teaching	COVID-19 History	56514	48	1087	36.8370782	-119.7649963	No	Yes
106100899	Saint Agnes Medical Center	Fresno	N/A	300-499	Nonprofit	Urban	Non-Teaching	Sepsis	56514	48	53	36.8370782	-119.7649963	No	Yes
106104062	Kaiser Foundation Hospital – Fresno	Fresno	Kaiser Foundation Hospitals	150-199	Nonprofit	Urban	Non-Teaching	Substance Abuse	41406	21	3574	36.84246	-119.7832	No	Yes
106104062	Kaiser Foundation Hospital – Fresno	Fresno	Kaiser Foundation Hospitals	150-199	Nonprofit	Urban	Non-Teaching	Cardiac	41406	21	26	36.84246	-119.7832	No	Yes
106104062	Kaiser Foundation Hospital – Fresno	Fresno	Kaiser Foundation Hospitals	150-199	Nonprofit	Urban	Non-Teaching	Cancer	41406	21	1385	36.84246	-119.7832	No	Yes
106104062	Kaiser Foundation Hospital – Fresno	Fresno	Kaiser Foundation Hospitals	150-199	Nonprofit	Urban	Non-Teaching	Hypertension	41406	21	12467	36.84246	-119.7832	No	Yes
106104062	Kaiser Foundation Hospital – Fresno	Fresno	Kaiser Foundation Hospitals	150-199	Nonprofit	Urban	Non-Teaching	Mental Health	41406	21	8620	36.84246	-119.7832	No	Yes
106104062	Kaiser Foundation Hospital – Fresno	Fresno	Kaiser Foundation Hospitals	150-199	Nonprofit	Urban	Non-Teaching	Sepsis	41406	21	178	36.84246	-119.7832	No	Yes
106104062	Kaiser Foundation Hospital – Fresno	Fresno	Kaiser Foundation Hospitals	150-199	Nonprofit	Urban	Non-Teaching	COVID-19 History	41406	21	808	36.84246	-119.7832	No	Yes
106104062	Kaiser Foundation Hospital – Fresno	Fresno	Kaiser Foundation Hospitals	150-199	Nonprofit	Urban	Non-Teaching	Obesity	41406	21	4338	36.84246	-119.7832	No	Yes
106104062	Kaiser Foundation Hospital – Fresno	Fresno	Kaiser Foundation Hospitals	150-199	Nonprofit	Urban	Non-Teaching	COPD	41406	21	1642	36.84246	-119.7832	No	Yes
106104062	Kaiser Foundation Hospital – Fresno	Fresno	Kaiser Foundation Hospitals	150-199	Nonprofit	Urban	Non-Teaching	Stroke	41406	21	167	36.84246	-119.7832	No	Yes
106104062	Kaiser Foundation Hospital – Fresno	Fresno	Kaiser Foundation Hospitals	150-199	Nonprofit	Urban	Non-Teaching	Pneumonia	41406	21	1049	36.84246	-119.7832	No	Yes
106104062	Kaiser Foundation Hospital – Fresno	Fresno	Kaiser Foundation Hospitals	150-199	Nonprofit	Urban	Non-Teaching	Diabetes	41406	21	6568	36.84246	-119.7832	No	Yes
106104062	Kaiser Foundation Hospital – Fresno	Fresno	Kaiser Foundation Hospitals	150-199	Nonprofit	Urban	Non-Teaching	All ED Visits	41406	21	41406	36.84246	-119.7832	No	Yes
106104062	Kaiser Foundation Hospital – Fresno	Fresno	Kaiser Foundation Hospitals	150-199	Nonprofit	Urban	Non-Teaching	Active COVID-19	41406	21	1788	36.84246	-119.7832	No	Yes
106104062	Kaiser Foundation Hospital – Fresno	Fresno	Kaiser Foundation Hospitals	150-199	Nonprofit	Urban	Non-Teaching	Respiratory	41406	21	671	36.84246	-119.7832	No	Yes
106104062	Kaiser Foundation Hospital – Fresno	Fresno	Kaiser Foundation Hospitals	150-199	Nonprofit	Urban	Non-Teaching	Homeless	41406	21	237	36.84246	-119.7832	No	Yes
106104062	Kaiser Foundation Hospital – Fresno	Fresno	Kaiser Foundation Hospitals	150-199	Nonprofit	Urban	Non-Teaching	Asthma	41406	21	5782	36.84246	-119.7832	No	Yes