Table: ccs_approved_hospitals , legal_name 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  *

npi legal_name business_name facility_type facility_status start_date end_date most_recent_review_date county address_line_1 address_line_2 city state zip_code phone
1821147786 Northbay Healthcare Group Northbay Medical Ctr Pediatric Community Provisional 12/27/2005 None 12/27/2005 Solano 1200 B Gale Wilson Boulevard None Fairfield CA 94533-3552 (707) 429-3600
1922198712 Northern Inyo Healthcare Northern Inyo Hospital Limited Full 8/23/1984 None None Inyo 150 Pioneer Lane None Bishop CA 93514-2599 (760) 873-5811