Table: emergency_department_volume_and_capacity_2021 , countyname like P*

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
106310791	Sutter Auburn Faith Hospital	Placer	Sutter Health	50-99	Nonprofit	Urban	Non-Teaching	Mental Health	24386	14	1694	38.94432	-121.09943	No	Yes
106310791	Sutter Auburn Faith Hospital	Placer	Sutter Health	50-99	Nonprofit	Urban	Non-Teaching	Respiratory	24386	14	47	38.94432	-121.09943	No	Yes
106310791	Sutter Auburn Faith Hospital	Placer	Sutter Health	50-99	Nonprofit	Urban	Non-Teaching	Pneumonia	24386	14	475	38.94432	-121.09943	No	Yes
106310791	Sutter Auburn Faith Hospital	Placer	Sutter Health	50-99	Nonprofit	Urban	Non-Teaching	Cardiac	24386	14	45	38.94432	-121.09943	No	Yes
106310791	Sutter Auburn Faith Hospital	Placer	Sutter Health	50-99	Nonprofit	Urban	Non-Teaching	Cancer	24386	14	277	38.94432	-121.09943	No	Yes
106310791	Sutter Auburn Faith Hospital	Placer	Sutter Health	50-99	Nonprofit	Urban	Non-Teaching	Obesity	24386	14	114	38.94432	-121.09943	No	Yes
106310791	Sutter Auburn Faith Hospital	Placer	Sutter Health	50-99	Nonprofit	Urban	Non-Teaching	Hypertension	24386	14	1818	38.94432	-121.09943	No	Yes
106310791	Sutter Auburn Faith Hospital	Placer	Sutter Health	50-99	Nonprofit	Urban	Non-Teaching	Substance Abuse	24386	14	2971	38.94432	-121.09943	No	Yes
106310791	Sutter Auburn Faith Hospital	Placer	Sutter Health	50-99	Nonprofit	Urban	Non-Teaching	Sepsis	24386	14	50	38.94432	-121.09943	No	Yes
106310791	Sutter Auburn Faith Hospital	Placer	Sutter Health	50-99	Nonprofit	Urban	Non-Teaching	COPD	24386	14	197	38.94432	-121.09943	No	Yes
106310791	Sutter Auburn Faith Hospital	Placer	Sutter Health	50-99	Nonprofit	Urban	Non-Teaching	Asthma	24386	14	389	38.94432	-121.09943	No	Yes
106310791	Sutter Auburn Faith Hospital	Placer	Sutter Health	50-99	Nonprofit	Urban	Non-Teaching	Diabetes	24386	14	833	38.94432	-121.09943	No	Yes
106310791	Sutter Auburn Faith Hospital	Placer	Sutter Health	50-99	Nonprofit	Urban	Non-Teaching	Homeless	24386	14	899	38.94432	-121.09943	No	Yes
106310791	Sutter Auburn Faith Hospital	Placer	Sutter Health	50-99	Nonprofit	Urban	Non-Teaching	Stroke	24386	14	38	38.94432	-121.09943	No	Yes
106310791	Sutter Auburn Faith Hospital	Placer	Sutter Health	50-99	Nonprofit	Urban	Non-Teaching	COVID-19 History	24386	14	88	38.94432	-121.09943	No	Yes
106310791	Sutter Auburn Faith Hospital	Placer	Sutter Health	50-99	Nonprofit	Urban	Non-Teaching	Active COVID-19	24386	14	1234	38.94432	-121.09943	No	Yes
106310791	Sutter Auburn Faith Hospital	Placer	Sutter Health	50-99	Nonprofit	Urban	Non-Teaching	All ED Visits	24386	14	24386	38.94432	-121.09943	No	Yes
106311000	Sutter Roseville Medical Center	Placer	Sutter Health	300-499	Nonprofit	Urban	Non-Teaching	Substance Abuse	65472	69	5835	38.76515	-121.24922	No	No
106311000	Sutter Roseville Medical Center	Placer	Sutter Health	300-499	Nonprofit	Urban	Non-Teaching	Respiratory	65472	69	109	38.76515	-121.24922	No	No
106311000	Sutter Roseville Medical Center	Placer	Sutter Health	300-499	Nonprofit	Urban	Non-Teaching	Pneumonia	65472	69	975	38.76515	-121.24922	No	No
106311000	Sutter Roseville Medical Center	Placer	Sutter Health	300-499	Nonprofit	Urban	Non-Teaching	Cardiac	65472	69	100	38.76515	-121.24922	No	No
106311000	Sutter Roseville Medical Center	Placer	Sutter Health	300-499	Nonprofit	Urban	Non-Teaching	Cancer	65472	69	564	38.76515	-121.24922	No	No
106311000	Sutter Roseville Medical Center	Placer	Sutter Health	300-499	Nonprofit	Urban	Non-Teaching	Obesity	65472	69	368	38.76515	-121.24922	No	No
106311000	Sutter Roseville Medical Center	Placer	Sutter Health	300-499	Nonprofit	Urban	Non-Teaching	Hypertension	65472	69	5228	38.76515	-121.24922	No	No
106311000	Sutter Roseville Medical Center	Placer	Sutter Health	300-499	Nonprofit	Urban	Non-Teaching	Sepsis	65472	69	113	38.76515	-121.24922	No	No
106311000	Sutter Roseville Medical Center	Placer	Sutter Health	300-499	Nonprofit	Urban	Non-Teaching	Mental Health	65472	69	4868	38.76515	-121.24922	No	No
106311000	Sutter Roseville Medical Center	Placer	Sutter Health	300-499	Nonprofit	Urban	Non-Teaching	COPD	65472	69	373	38.76515	-121.24922	No	No
106311000	Sutter Roseville Medical Center	Placer	Sutter Health	300-499	Nonprofit	Urban	Non-Teaching	Asthma	65472	69	1194	38.76515	-121.24922	No	No
106311000	Sutter Roseville Medical Center	Placer	Sutter Health	300-499	Nonprofit	Urban	Non-Teaching	Diabetes	65472	69	2432	38.76515	-121.24922	No	No
106311000	Sutter Roseville Medical Center	Placer	Sutter Health	300-499	Nonprofit	Urban	Non-Teaching	Homeless	65472	69	1092	38.76515	-121.24922	No	No
106311000	Sutter Roseville Medical Center	Placer	Sutter Health	300-499	Nonprofit	Urban	Non-Teaching	Stroke	65472	69	32	38.76515	-121.24922	No	No
106311000	Sutter Roseville Medical Center	Placer	Sutter Health	300-499	Nonprofit	Urban	Non-Teaching	COVID-19 History	65472	69	256	38.76515	-121.24922	No	No
106311000	Sutter Roseville Medical Center	Placer	Sutter Health	300-499	Nonprofit	Urban	Non-Teaching	Active COVID-19	65472	69	3827	38.76515	-121.24922	No	No
106311000	Sutter Roseville Medical Center	Placer	Sutter Health	300-499	Nonprofit	Urban	Non-Teaching	All ED Visits	65472	69	65472	38.76515	-121.24922	No	No
106314024	Kaiser Foundation Hospital – Roseville	Placer	Kaiser Foundation Hospitals	300-499	Nonprofit	Urban	Non-Teaching	Substance Abuse	112736	61	12261	38.74636	-121.25107	No	No
106314024	Kaiser Foundation Hospital – Roseville	Placer	Kaiser Foundation Hospitals	300-499	Nonprofit	Urban	Non-Teaching	Mental Health	112736	61	16319	38.74636	-121.25107	No	No
106314024	Kaiser Foundation Hospital – Roseville	Placer	Kaiser Foundation Hospitals	300-499	Nonprofit	Urban	Non-Teaching	Pneumonia	112736	61	2640	38.74636	-121.25107	No	No
106314024	Kaiser Foundation Hospital – Roseville	Placer	Kaiser Foundation Hospitals	300-499	Nonprofit	Urban	Non-Teaching	Respiratory	112736	61	1239	38.74636	-121.25107	No	No
106314024	Kaiser Foundation Hospital – Roseville	Placer	Kaiser Foundation Hospitals	300-499	Nonprofit	Urban	Non-Teaching	Cardiac	112736	61	57	38.74636	-121.25107	No	No
106314024	Kaiser Foundation Hospital – Roseville	Placer	Kaiser Foundation Hospitals	300-499	Nonprofit	Urban	Non-Teaching	Cancer	112736	61	2530	38.74636	-121.25107	No	No
106314024	Kaiser Foundation Hospital – Roseville	Placer	Kaiser Foundation Hospitals	300-499	Nonprofit	Urban	Non-Teaching	Obesity	112736	61	6427	38.74636	-121.25107	No	No
106314024	Kaiser Foundation Hospital – Roseville	Placer	Kaiser Foundation Hospitals	300-499	Nonprofit	Urban	Non-Teaching	Hypertension	112736	61	20390	38.74636	-121.25107	No	No
106314024	Kaiser Foundation Hospital – Roseville	Placer	Kaiser Foundation Hospitals	300-499	Nonprofit	Urban	Non-Teaching	Sepsis	112736	61	933	38.74636	-121.25107	No	No
106314024	Kaiser Foundation Hospital – Roseville	Placer	Kaiser Foundation Hospitals	300-499	Nonprofit	Urban	Non-Teaching	COPD	112736	61	2713	38.74636	-121.25107	No	No
106314024	Kaiser Foundation Hospital – Roseville	Placer	Kaiser Foundation Hospitals	300-499	Nonprofit	Urban	Non-Teaching	Asthma	112736	61	9126	38.74636	-121.25107	No	No
106314024	Kaiser Foundation Hospital – Roseville	Placer	Kaiser Foundation Hospitals	300-499	Nonprofit	Urban	Non-Teaching	Diabetes	112736	61	9787	38.74636	-121.25107	No	No
106314024	Kaiser Foundation Hospital – Roseville	Placer	Kaiser Foundation Hospitals	300-499	Nonprofit	Urban	Non-Teaching	Homeless	112736	61	568	38.74636	-121.25107	No	No
106314024	Kaiser Foundation Hospital – Roseville	Placer	Kaiser Foundation Hospitals	300-499	Nonprofit	Urban	Non-Teaching	Stroke	112736	61	293	38.74636	-121.25107	No	No
106314024	Kaiser Foundation Hospital – Roseville	Placer	Kaiser Foundation Hospitals	300-499	Nonprofit	Urban	Non-Teaching	COVID-19 History	112736	61	1791	38.74636	-121.25107	No	No
106314024	Kaiser Foundation Hospital – Roseville	Placer	Kaiser Foundation Hospitals	300-499	Nonprofit	Urban	Non-Teaching	Active COVID-19	112736	61	4487	38.74636	-121.25107	No	No
106314024	Kaiser Foundation Hospital – Roseville	Placer	Kaiser Foundation Hospitals	300-499	Nonprofit	Urban	Non-Teaching	All ED Visits	112736	61	112736	38.74636	-121.25107	No	No
106320859	Eastern Plumas Hospital – Portola Campus	Plumas	N/A	Jan-49	Government	Frontier	Non-Teaching	Substance Abuse	3306	3	166	39.80517	-120.462591	Yes	Yes
106320859	Eastern Plumas Hospital – Portola Campus	Plumas	N/A	Jan-49	Government	Frontier	Non-Teaching	Mental Health	3306	3	150	39.80517	-120.462591	Yes	Yes
106320859	Eastern Plumas Hospital – Portola Campus	Plumas	N/A	Jan-49	Government	Frontier	Non-Teaching	Respiratory	3306	3	7	39.80517	-120.462591	Yes	Yes
106320859	Eastern Plumas Hospital – Portola Campus	Plumas	N/A	Jan-49	Government	Frontier	Non-Teaching	Pneumonia	3306	3	105	39.80517	-120.462591	Yes	Yes
106320859	Eastern Plumas Hospital – Portola Campus	Plumas	N/A	Jan-49	Government	Frontier	Non-Teaching	Cardiac	3306	3	6	39.80517	-120.462591	Yes	Yes
106320859	Eastern Plumas Hospital – Portola Campus	Plumas	N/A	Jan-49	Government	Frontier	Non-Teaching	Cancer	3306	3	32	39.80517	-120.462591	Yes	Yes
106320859	Eastern Plumas Hospital – Portola Campus	Plumas	N/A	Jan-49	Government	Frontier	Non-Teaching	Obesity	3306	3	18	39.80517	-120.462591	Yes	Yes
106320859	Eastern Plumas Hospital – Portola Campus	Plumas	N/A	Jan-49	Government	Frontier	Non-Teaching	Hypertension	3306	3	239	39.80517	-120.462591	Yes	Yes
106320859	Eastern Plumas Hospital – Portola Campus	Plumas	N/A	Jan-49	Government	Frontier	Non-Teaching	Sepsis	3306	3	9	39.80517	-120.462591	Yes	Yes
106320859	Eastern Plumas Hospital – Portola Campus	Plumas	N/A	Jan-49	Government	Frontier	Non-Teaching	COPD	3306	3	51	39.80517	-120.462591	Yes	Yes
106320859	Eastern Plumas Hospital – Portola Campus	Plumas	N/A	Jan-49	Government	Frontier	Non-Teaching	Asthma	3306	3	38	39.80517	-120.462591	Yes	Yes
106320859	Eastern Plumas Hospital – Portola Campus	Plumas	N/A	Jan-49	Government	Frontier	Non-Teaching	Diabetes	3306	3	114	39.80517	-120.462591	Yes	Yes
106320859	Eastern Plumas Hospital – Portola Campus	Plumas	N/A	Jan-49	Government	Frontier	Non-Teaching	Homeless	3306	3	3	39.80517	-120.462591	Yes	Yes
106320859	Eastern Plumas Hospital – Portola Campus	Plumas	N/A	Jan-49	Government	Frontier	Non-Teaching	Stroke	3306	3	7	39.80517	-120.462591	Yes	Yes
106320859	Eastern Plumas Hospital – Portola Campus	Plumas	N/A	Jan-49	Government	Frontier	Non-Teaching	COVID-19 History	3306	3	12	39.80517	-120.462591	Yes	Yes
106320859	Eastern Plumas Hospital – Portola Campus	Plumas	N/A	Jan-49	Government	Frontier	Non-Teaching	Active COVID-19	3306	3	149	39.80517	-120.462591	Yes	Yes
106320859	Eastern Plumas Hospital – Portola Campus	Plumas	N/A	Jan-49	Government	Frontier	Non-Teaching	All ED Visits	3306	3	3306	39.80517	-120.462591	Yes	Yes
106321016	Seneca District Hospital	Plumas	N/A	Jan-49	Government	Frontier	Non-Teaching	Mental Health	2315	2	103	40.30547	-121.23396	Yes	Yes
106321016	Seneca District Hospital	Plumas	N/A	Jan-49	Government	Frontier	Non-Teaching	Respiratory	2315	2	4	40.30547	-121.23396	Yes	Yes
106321016	Seneca District Hospital	Plumas	N/A	Jan-49	Government	Frontier	Non-Teaching	Pneumonia	2315	2	42	40.30547	-121.23396	Yes	Yes
106321016	Seneca District Hospital	Plumas	N/A	Jan-49	Government	Frontier	Non-Teaching	Cardiac	2315	2	2	40.30547	-121.23396	Yes	Yes
106321016	Seneca District Hospital	Plumas	N/A	Jan-49	Government	Frontier	Non-Teaching	Cancer	2315	2	23	40.30547	-121.23396	Yes	Yes
106321016	Seneca District Hospital	Plumas	N/A	Jan-49	Government	Frontier	Non-Teaching	Substance Abuse	2315	2	160	40.30547	-121.23396	Yes	Yes
106321016	Seneca District Hospital	Plumas	N/A	Jan-49	Government	Frontier	Non-Teaching	Obesity	2315	2	16	40.30547	-121.23396	Yes	Yes
106321016	Seneca District Hospital	Plumas	N/A	Jan-49	Government	Frontier	Non-Teaching	Hypertension	2315	2	286	40.30547	-121.23396	Yes	Yes
106321016	Seneca District Hospital	Plumas	N/A	Jan-49	Government	Frontier	Non-Teaching	Sepsis	2315	2	2	40.30547	-121.23396	Yes	Yes
106321016	Seneca District Hospital	Plumas	N/A	Jan-49	Government	Frontier	Non-Teaching	COPD	2315	2	49	40.30547	-121.23396	Yes	Yes
106321016	Seneca District Hospital	Plumas	N/A	Jan-49	Government	Frontier	Non-Teaching	Asthma	2315	2	17	40.30547	-121.23396	Yes	Yes
106321016	Seneca District Hospital	Plumas	N/A	Jan-49	Government	Frontier	Non-Teaching	Diabetes	2315	2	140	40.30547	-121.23396	Yes	Yes
106321016	Seneca District Hospital	Plumas	N/A	Jan-49	Government	Frontier	Non-Teaching	Homeless	2315	2	5	40.30547	-121.23396	Yes	Yes
106321016	Seneca District Hospital	Plumas	N/A	Jan-49	Government	Frontier	Non-Teaching	Stroke	2315	2	5	40.30547	-121.23396	Yes	Yes
106321016	Seneca District Hospital	Plumas	N/A	Jan-49	Government	Frontier	Non-Teaching	COVID-19 History	2315	2	9	40.30547	-121.23396	Yes	Yes
106321016	Seneca District Hospital	Plumas	N/A	Jan-49	Government	Frontier	Non-Teaching	Active COVID-19	2315	2	95	40.30547	-121.23396	Yes	Yes
106321016	Seneca District Hospital	Plumas	N/A	Jan-49	Government	Frontier	Non-Teaching	All ED Visits	2315	2	2315	40.30547	-121.23396	Yes	Yes