Table: emergency_department_volume_and_capacity_2021 , countyname like N*

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
106281047 Providence Queen of the Valley Medical Center Napa Providence St. Joseph Health 150-199 Investor Owned Urban Non-Teaching Substance Abuse 21616 18 2178 38.32363 -122.296 No No
106281047 Providence Queen of the Valley Medical Center Napa Providence St. Joseph Health 150-199 Investor Owned Urban Non-Teaching Mental Health 21616 18 3602 38.32363 -122.296 No No
106281047 Providence Queen of the Valley Medical Center Napa Providence St. Joseph Health 150-199 Investor Owned Urban Non-Teaching Respiratory 21616 18 101 38.32363 -122.296 No No
106281047 Providence Queen of the Valley Medical Center Napa Providence St. Joseph Health 150-199 Investor Owned Urban Non-Teaching Cardiac 21616 18 45 38.32363 -122.296 No No
106281047 Providence Queen of the Valley Medical Center Napa Providence St. Joseph Health 150-199 Investor Owned Urban Non-Teaching Cancer 21616 18 236 38.32363 -122.296 No No
106281047 Providence Queen of the Valley Medical Center Napa Providence St. Joseph Health 150-199 Investor Owned Urban Non-Teaching Obesity 21616 18 903 38.32363 -122.296 No No
106281047 Providence Queen of the Valley Medical Center Napa Providence St. Joseph Health 150-199 Investor Owned Urban Non-Teaching Hypertension 21616 18 6247 38.32363 -122.296 No No
106281047 Providence Queen of the Valley Medical Center Napa Providence St. Joseph Health 150-199 Investor Owned Urban Non-Teaching Pneumonia 21616 18 252 38.32363 -122.296 No No
106281047 Providence Queen of the Valley Medical Center Napa Providence St. Joseph Health 150-199 Investor Owned Urban Non-Teaching Sepsis 21616 18 65 38.32363 -122.296 No No
106281047 Providence Queen of the Valley Medical Center Napa Providence St. Joseph Health 150-199 Investor Owned Urban Non-Teaching COPD 21616 18 883 38.32363 -122.296 No No
106281047 Providence Queen of the Valley Medical Center Napa Providence St. Joseph Health 150-199 Investor Owned Urban Non-Teaching Asthma 21616 18 1986 38.32363 -122.296 No No
106281047 Providence Queen of the Valley Medical Center Napa Providence St. Joseph Health 150-199 Investor Owned Urban Non-Teaching Diabetes 21616 18 2635 38.32363 -122.296 No No
106281047 Providence Queen of the Valley Medical Center Napa Providence St. Joseph Health 150-199 Investor Owned Urban Non-Teaching Stroke 21616 18 38 38.32363 -122.296 No No
106281047 Providence Queen of the Valley Medical Center Napa Providence St. Joseph Health 150-199 Investor Owned Urban Non-Teaching COVID-19 History 21616 18 167 38.32363 -122.296 No No
106281047 Providence Queen of the Valley Medical Center Napa Providence St. Joseph Health 150-199 Investor Owned Urban Non-Teaching Homeless 21616 18 489 38.32363 -122.296 No No
106281047 Providence Queen of the Valley Medical Center Napa Providence St. Joseph Health 150-199 Investor Owned Urban Non-Teaching Active COVID-19 21616 18 447 38.32363 -122.296 No No
106281047 Providence Queen of the Valley Medical Center Napa Providence St. Joseph Health 150-199 Investor Owned Urban Non-Teaching All ED Visits 21616 18 21616 38.32363 -122.296 No No
106281078 Adventist Health St. Helena Napa Adventist Health Systems 100-149 Nonprofit Rural Non-Teaching Mental Health 5566 8 499 38.53937349 -122.473003 No No
106281078 Adventist Health St. Helena Napa Adventist Health Systems 100-149 Nonprofit Rural Non-Teaching Respiratory 5566 8 11 38.53937349 -122.473003 No No
106281078 Adventist Health St. Helena Napa Adventist Health Systems 100-149 Nonprofit Rural Non-Teaching Pneumonia 5566 8 55 38.53937349 -122.473003 No No
106281078 Adventist Health St. Helena Napa Adventist Health Systems 100-149 Nonprofit Rural Non-Teaching Cancer 5566 8 127 38.53937349 -122.473003 No No
106281078 Adventist Health St. Helena Napa Adventist Health Systems 100-149 Nonprofit Rural Non-Teaching Obesity 5566 8 469 38.53937349 -122.473003 No No
106281078 Adventist Health St. Helena Napa Adventist Health Systems 100-149 Nonprofit Rural Non-Teaching Cardiac 5566 8 3 38.53937349 -122.473003 No No
106281078 Adventist Health St. Helena Napa Adventist Health Systems 100-149 Nonprofit Rural Non-Teaching Hypertension 5566 8 1141 38.53937349 -122.473003 No No
106281078 Adventist Health St. Helena Napa Adventist Health Systems 100-149 Nonprofit Rural Non-Teaching Substance Abuse 5566 8 566 38.53937349 -122.473003 No No
106281078 Adventist Health St. Helena Napa Adventist Health Systems 100-149 Nonprofit Rural Non-Teaching Sepsis 5566 8 10 38.53937349 -122.473003 No No
106281078 Adventist Health St. Helena Napa Adventist Health Systems 100-149 Nonprofit Rural Non-Teaching COPD 5566 8 86 38.53937349 -122.473003 No No
106281078 Adventist Health St. Helena Napa Adventist Health Systems 100-149 Nonprofit Rural Non-Teaching Asthma 5566 8 163 38.53937349 -122.473003 No No
106281078 Adventist Health St. Helena Napa Adventist Health Systems 100-149 Nonprofit Rural Non-Teaching Diabetes 5566 8 509 38.53937349 -122.473003 No No
106281078 Adventist Health St. Helena Napa Adventist Health Systems 100-149 Nonprofit Rural Non-Teaching Stroke 5566 8 6 38.53937349 -122.473003 No No
106281078 Adventist Health St. Helena Napa Adventist Health Systems 100-149 Nonprofit Rural Non-Teaching COVID-19 History 5566 8 32 38.53937349 -122.473003 No No
106281078 Adventist Health St. Helena Napa Adventist Health Systems 100-149 Nonprofit Rural Non-Teaching Active COVID-19 5566 8 138 38.53937349 -122.473003 No No
106281078 Adventist Health St. Helena Napa Adventist Health Systems 100-149 Nonprofit Rural Non-Teaching All ED Visits 5566 8 5566 38.53937349 -122.473003 No No
106281078 Adventist Health St. Helena Napa Adventist Health Systems 100-149 Nonprofit Rural Non-Teaching Homeless 5566 8 9 38.53937349 -122.473003 No No
106291023 Sierra Nevada Memorial Hospital Nevada Dignity Health 100-149 Nonprofit Rural Non-Teaching Substance Abuse 21800 18 4895 39.22808 -121.047201 Yes Yes
106291023 Sierra Nevada Memorial Hospital Nevada Dignity Health 100-149 Nonprofit Rural Non-Teaching Respiratory 21800 18 109 39.22808 -121.047201 Yes Yes
106291023 Sierra Nevada Memorial Hospital Nevada Dignity Health 100-149 Nonprofit Rural Non-Teaching Cardiac 21800 18 24 39.22808 -121.047201 Yes Yes
106291023 Sierra Nevada Memorial Hospital Nevada Dignity Health 100-149 Nonprofit Rural Non-Teaching Mental Health 21800 18 1834 39.22808 -121.047201 Yes Yes
106291023 Sierra Nevada Memorial Hospital Nevada Dignity Health 100-149 Nonprofit Rural Non-Teaching Cancer 21800 18 227 39.22808 -121.047201 Yes Yes
106291023 Sierra Nevada Memorial Hospital Nevada Dignity Health 100-149 Nonprofit Rural Non-Teaching Obesity 21800 18 315 39.22808 -121.047201 Yes Yes
106291023 Sierra Nevada Memorial Hospital Nevada Dignity Health 100-149 Nonprofit Rural Non-Teaching Hypertension 21800 18 4879 39.22808 -121.047201 Yes Yes
106291023 Sierra Nevada Memorial Hospital Nevada Dignity Health 100-149 Nonprofit Rural Non-Teaching Pneumonia 21800 18 142 39.22808 -121.047201 Yes Yes
106291023 Sierra Nevada Memorial Hospital Nevada Dignity Health 100-149 Nonprofit Rural Non-Teaching Sepsis 21800 18 21 39.22808 -121.047201 Yes Yes
106291023 Sierra Nevada Memorial Hospital Nevada Dignity Health 100-149 Nonprofit Rural Non-Teaching COPD 21800 18 220 39.22808 -121.047201 Yes Yes
106291023 Sierra Nevada Memorial Hospital Nevada Dignity Health 100-149 Nonprofit Rural Non-Teaching Asthma 21800 18 370 39.22808 -121.047201 Yes Yes
106291023 Sierra Nevada Memorial Hospital Nevada Dignity Health 100-149 Nonprofit Rural Non-Teaching Diabetes 21800 18 1451 39.22808 -121.047201 Yes Yes
106291023 Sierra Nevada Memorial Hospital Nevada Dignity Health 100-149 Nonprofit Rural Non-Teaching Homeless 21800 18 590 39.22808 -121.047201 Yes Yes
106291023 Sierra Nevada Memorial Hospital Nevada Dignity Health 100-149 Nonprofit Rural Non-Teaching Stroke 21800 18 67 39.22808 -121.047201 Yes Yes
106291023 Sierra Nevada Memorial Hospital Nevada Dignity Health 100-149 Nonprofit Rural Non-Teaching COVID-19 History 21800 18 202 39.22808 -121.047201 Yes Yes
106291023 Sierra Nevada Memorial Hospital Nevada Dignity Health 100-149 Nonprofit Rural Non-Teaching Active COVID-19 21800 18 782 39.22808 -121.047201 Yes Yes
106291023 Sierra Nevada Memorial Hospital Nevada Dignity Health 100-149 Nonprofit Rural Non-Teaching All ED Visits 21800 18 21800 39.22808 -121.047201 Yes Yes
106291053 Tahoe Forest Hospital Nevada N/A 50-99 Government Rural Non-Teaching Substance Abuse 11799 15 1416 39.324536 -120.201516 Yes Yes
106291053 Tahoe Forest Hospital Nevada N/A 50-99 Government Rural Non-Teaching Mental Health 11799 15 629 39.324536 -120.201516 Yes Yes
106291053 Tahoe Forest Hospital Nevada N/A 50-99 Government Rural Non-Teaching Pneumonia 11799 15 94 39.324536 -120.201516 Yes Yes
106291053 Tahoe Forest Hospital Nevada N/A 50-99 Government Rural Non-Teaching Cancer 11799 15 77 39.324536 -120.201516 Yes Yes
106291053 Tahoe Forest Hospital Nevada N/A 50-99 Government Rural Non-Teaching Respiratory 11799 15 29 39.324536 -120.201516 Yes Yes
106291053 Tahoe Forest Hospital Nevada N/A 50-99 Government Rural Non-Teaching Obesity 11799 15 216 39.324536 -120.201516 Yes Yes
106291053 Tahoe Forest Hospital Nevada N/A 50-99 Government Rural Non-Teaching Cardiac 11799 15 17 39.324536 -120.201516 Yes Yes
106291053 Tahoe Forest Hospital Nevada N/A 50-99 Government Rural Non-Teaching Hypertension 11799 15 1293 39.324536 -120.201516 Yes Yes
106291053 Tahoe Forest Hospital Nevada N/A 50-99 Government Rural Non-Teaching Sepsis 11799 15 22 39.324536 -120.201516 Yes Yes
106291053 Tahoe Forest Hospital Nevada N/A 50-99 Government Rural Non-Teaching COPD 11799 15 91 39.324536 -120.201516 Yes Yes
106291053 Tahoe Forest Hospital Nevada N/A 50-99 Government Rural Non-Teaching Asthma 11799 15 393 39.324536 -120.201516 Yes Yes
106291053 Tahoe Forest Hospital Nevada N/A 50-99 Government Rural Non-Teaching Diabetes 11799 15 340 39.324536 -120.201516 Yes Yes
106291053 Tahoe Forest Hospital Nevada N/A 50-99 Government Rural Non-Teaching Stroke 11799 15 23 39.324536 -120.201516 Yes Yes
106291053 Tahoe Forest Hospital Nevada N/A 50-99 Government Rural Non-Teaching COVID-19 History 11799 15 35 39.324536 -120.201516 Yes Yes
106291053 Tahoe Forest Hospital Nevada N/A 50-99 Government Rural Non-Teaching Active COVID-19 11799 15 241 39.324536 -120.201516 Yes Yes
106291053 Tahoe Forest Hospital Nevada N/A 50-99 Government Rural Non-Teaching Homeless 11799 15 17 39.324536 -120.201516 Yes Yes
106291053 Tahoe Forest Hospital Nevada N/A 50-99 Government Rural Non-Teaching All ED Visits 11799 15 11799 39.324536 -120.201516 Yes Yes