Table: emergency_department_volume_and_capacity_2021 , countyname like H*

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
106121031 Jerold Phelps Community Hospital Humboldt N/A Jan-49 Government Frontier Non-Teaching Mental Health 2837 2 123 40.10195 -123.79286 Yes Yes
106121031 Jerold Phelps Community Hospital Humboldt N/A Jan-49 Government Frontier Non-Teaching Substance Abuse 2837 2 462 40.10195 -123.79286 Yes Yes
106121031 Jerold Phelps Community Hospital Humboldt N/A Jan-49 Government Frontier Non-Teaching COVID-19 History 2837 2 3 40.10195 -123.79286 Yes Yes
106121031 Jerold Phelps Community Hospital Humboldt N/A Jan-49 Government Frontier Non-Teaching Cancer 2837 2 15 40.10195 -123.79286 Yes Yes
106121031 Jerold Phelps Community Hospital Humboldt N/A Jan-49 Government Frontier Non-Teaching Obesity 2837 2 12 40.10195 -123.79286 Yes Yes
106121031 Jerold Phelps Community Hospital Humboldt N/A Jan-49 Government Frontier Non-Teaching Pneumonia 2837 2 38 40.10195 -123.79286 Yes Yes
106121031 Jerold Phelps Community Hospital Humboldt N/A Jan-49 Government Frontier Non-Teaching Cardiac 2837 2 2 40.10195 -123.79286 Yes Yes
106121031 Jerold Phelps Community Hospital Humboldt N/A Jan-49 Government Frontier Non-Teaching COPD 2837 2 22 40.10195 -123.79286 Yes Yes
106121031 Jerold Phelps Community Hospital Humboldt N/A Jan-49 Government Frontier Non-Teaching Homeless 2837 2 117 40.10195 -123.79286 Yes Yes
106121031 Jerold Phelps Community Hospital Humboldt N/A Jan-49 Government Frontier Non-Teaching Hypertension 2837 2 157 40.10195 -123.79286 Yes Yes
106121031 Jerold Phelps Community Hospital Humboldt N/A Jan-49 Government Frontier Non-Teaching Respiratory 2837 2 6 40.10195 -123.79286 Yes Yes
106121031 Jerold Phelps Community Hospital Humboldt N/A Jan-49 Government Frontier Non-Teaching Stroke 2837 2 4 40.10195 -123.79286 Yes Yes
106121031 Jerold Phelps Community Hospital Humboldt N/A Jan-49 Government Frontier Non-Teaching Diabetes 2837 2 77 40.10195 -123.79286 Yes Yes
106121031 Jerold Phelps Community Hospital Humboldt N/A Jan-49 Government Frontier Non-Teaching Active COVID-19 2837 2 47 40.10195 -123.79286 Yes Yes
106121031 Jerold Phelps Community Hospital Humboldt N/A Jan-49 Government Frontier Non-Teaching All ED Visits 2837 2 2837 40.10195 -123.79286 Yes Yes
106121031 Jerold Phelps Community Hospital Humboldt N/A Jan-49 Government Frontier Non-Teaching Sepsis 2837 2 6 40.10195 -123.79286 Yes Yes
106121031 Jerold Phelps Community Hospital Humboldt N/A Jan-49 Government Frontier Non-Teaching Asthma 2837 2 54 40.10195 -123.79286 Yes Yes
106121051 Providence Redwood Memorial Hospital Humboldt Providence St. Joseph Health Jan-49 Investor Owned Rural Non-Teaching Pneumonia 9741 8 181 40.58267 -124.13549 Yes Yes
106121051 Providence Redwood Memorial Hospital Humboldt Providence St. Joseph Health Jan-49 Investor Owned Rural Non-Teaching COPD 9741 8 726 40.58267 -124.13549 Yes Yes
106121051 Providence Redwood Memorial Hospital Humboldt Providence St. Joseph Health Jan-49 Investor Owned Rural Non-Teaching Cancer 9741 8 82 40.58267 -124.13549 Yes Yes
106121051 Providence Redwood Memorial Hospital Humboldt Providence St. Joseph Health Jan-49 Investor Owned Rural Non-Teaching Substance Abuse 9741 8 2181 40.58267 -124.13549 Yes Yes
106121051 Providence Redwood Memorial Hospital Humboldt Providence St. Joseph Health Jan-49 Investor Owned Rural Non-Teaching Respiratory 9741 8 47 40.58267 -124.13549 Yes Yes
106121051 Providence Redwood Memorial Hospital Humboldt Providence St. Joseph Health Jan-49 Investor Owned Rural Non-Teaching Cardiac 9741 8 30 40.58267 -124.13549 Yes Yes
106121051 Providence Redwood Memorial Hospital Humboldt Providence St. Joseph Health Jan-49 Investor Owned Rural Non-Teaching Mental Health 9741 8 2596 40.58267 -124.13549 Yes Yes
106121051 Providence Redwood Memorial Hospital Humboldt Providence St. Joseph Health Jan-49 Investor Owned Rural Non-Teaching Hypertension 9741 8 2794 40.58267 -124.13549 Yes Yes
106121051 Providence Redwood Memorial Hospital Humboldt Providence St. Joseph Health Jan-49 Investor Owned Rural Non-Teaching Sepsis 9741 8 66 40.58267 -124.13549 Yes Yes
106121051 Providence Redwood Memorial Hospital Humboldt Providence St. Joseph Health Jan-49 Investor Owned Rural Non-Teaching COVID-19 History 9741 8 51 40.58267 -124.13549 Yes Yes
106121051 Providence Redwood Memorial Hospital Humboldt Providence St. Joseph Health Jan-49 Investor Owned Rural Non-Teaching Obesity 9741 8 138 40.58267 -124.13549 Yes Yes
106121051 Providence Redwood Memorial Hospital Humboldt Providence St. Joseph Health Jan-49 Investor Owned Rural Non-Teaching Asthma 9741 8 1051 40.58267 -124.13549 Yes Yes
106121051 Providence Redwood Memorial Hospital Humboldt Providence St. Joseph Health Jan-49 Investor Owned Rural Non-Teaching Active COVID-19 9741 8 303 40.58267 -124.13549 Yes Yes
106121051 Providence Redwood Memorial Hospital Humboldt Providence St. Joseph Health Jan-49 Investor Owned Rural Non-Teaching Stroke 9741 8 36 40.58267 -124.13549 Yes Yes
106121051 Providence Redwood Memorial Hospital Humboldt Providence St. Joseph Health Jan-49 Investor Owned Rural Non-Teaching Homeless 9741 8 313 40.58267 -124.13549 Yes Yes
106121051 Providence Redwood Memorial Hospital Humboldt Providence St. Joseph Health Jan-49 Investor Owned Rural Non-Teaching Diabetes 9741 8 1171 40.58267 -124.13549 Yes Yes
106121051 Providence Redwood Memorial Hospital Humboldt Providence St. Joseph Health Jan-49 Investor Owned Rural Non-Teaching All ED Visits 9741 8 9741 40.58267 -124.13549 Yes Yes