Table: ambulatory_surgery_char_by_faclty_2019 , facility_name like J*

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_id2 facility_num facility_name license_type_desc county_name dba_address1 dba_city dba_zip_code control_type_desc licensed_bed_size senate_district_desc assembly_district_desc mssa_name mssa_designation teach_rural sex_female sex_male sex_unknown_invalid hcount ccount license_type age_10_19 age_20_29 age_30_39 age_40_49 age_50_59 age_60_69 age_70_79 age_80_ age_01_09 age_under_1 age_unknown racegrp_aman racegrp_asian racegrp_black racegrp_multirace racegrp_nhpi racegrp_other racegrp_unknown racegrp_white racegrp_inv_blank eth_hispanic eth_nonhispanic eth_unknown eth_blank_invalid other_disp psychiatric_care routine sn_ic_care acute_care against_medical_advice cah
106070988 070988 JOHN MUIR MEDICAL CENTER-WALNUT CREEK CAMPUS Hospital Contra Costa 1601 Ygnacio Valley Rd Walnut Creek 94598 Non-profit Corporation (incl. Church-related) 500+ District 7 District 16 Clayton/Concord South/Walnut Creek Central and East Urban NA 3460 2638 None 1 0 Hospital 460 197 403 573 863 1206 1303 720 319 54 None 15 594 295 52 30 501 227 4384 None 743 5158 197 None 2 1 5916 79 22 4 None
106071018 071018 JOHN MUIR MEDICAL CENTER-CONCORD CAMPUS Hospital Contra Costa 2540 EAST ST CONCORD 94520 Non-profit Corporation (incl. Church-related) 200-299 District 7 District 14 Avon/Clyde/Concord Central/Pittsburg Southwest Urban NA 2497 3163 1 1 0 Hospital 54 143 325 518 991 1468 1419 743 None None None 20 590 396 54 54 486 95 3966 None 793 4800 68 None 2 None 5552 42 9 5 None
106220733 220733 JOHN C FREMONT HEALTHCARE DISTRICT Hospital Mariposa 5189 Hospital Rd Mariposa 95338 District 1-49 District 8 District 5 Bootjack/Cathey’s Valley/Coulterville/Don Pedro/El Portal/Fish Camp/Mariposa Rural Small/Rural 75 61 None 1 0 Hospital None 5 4 13 48 50 15 1 None None None 2 1 None 1 None None 6 126 None 10 114 12 None None None 136 None None None None
106331216 331216 JOHN F. KENNEDY MEMORIAL HOSPITAL Hospital Riverside 47111 Monroe St Indio 92201 Investor - Corporation 100-149 District 28 District 56 Arabia/Coachella/Desert Beach/Flowing Wells/Indio South/La Quinta East/Mecca/Oasis/Thermal Urban NA 2006 1885 None 1 0 Hospital 88 270 417 548 1134 814 427 150 42 1 None 11 41 101 1 8 49 106 3574 None 2470 1318 103 None None None 3877 4 2 1 None