Table: ambulatory_surgery_char_by_faclty_2020 , 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 acute_care not_defined_elsewhere routine sn_ic_care cah home_health_service psychiatric_care
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 3261 2419 None 1 0 Hospital 384 207 393 602 905 1153 1121 631 237 47 None 9 611 343 73 32 546 161 3905 None 799 4722 159 None 25 3 5476 70 None 81 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 2235 2836 None 1 0 Hospital 30 132 252 411 839 1426 1288 693 None None None 19 536 354 43 53 415 82 3569 None 727 4281 63 None 12 1 4932 30 None 82 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 32 18 None 1 0 Hospital None 2 4 5 11 19 9 None None None None 1 None None 1 None None 6 42 None 1 44 5 None None None 50 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 1581 1267 None 1 0 Hospital 65 183 348 400 732 576 381 147 16 None None 5 20 61 13 2 18 34 2695 None 1713 1120 15 None 1 None 2819 17 None 6 None