Table: ambulatory_surgery_char_by_faclty_2018 , 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 county_code 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 asian_pacific_islander black other_race unknown_race white american_indian_alaska_native invalid_blank_race eth_hispanicl eth_nonhispanicl eth_unknown eth_invalid_blank against_medical_advice routine sn_ic_care acute_care cah home_health_service hospice_care not_defined_elsewhere
106070988 070988 JOHN MUIR MEDICAL CENTER-WALNUT CREEK CAMPUS 07 Hospital CONTRA COSTA 1601 YGNACIO VALLEY ROAD WALNUT CREEK 94598 Non-profit Corporation (incl. Church-related) 500+ District 7 District 16 CLAYTON/CONCORD SOUTH/WALNUT CREEK CENTRAL AND EAST Urban NA 2888 2356 None 1 0 Hospital 359 180 358 514 771 1044 1095 656 234 33 None 526 277 406 152 3875 8 None 648 4459 137 None 3 5112 62 9 None 46 6 None
106071018 071018 JOHN MUIR MEDICAL CENTER-CONCORD CAMPUS 07 Hospital CONTRA COSTA 2540 EAST STREET CONCORD 94520 Non-profit Corporation (incl. Church-related) 200-299 District 7 District 14 AVON/CLYDE/CONCORD CENTRAL/PITTSBURG SOUTHWEST Urban NA 2685 3225 None 1 0 Hospital 30 164 357 485 1021 1504 1531 818 None None None 620 416 422 118 4309 25 None 787 5042 81 None 2 5822 41 13 None 18 4 2
106220733 220733 JOHN C FREMONT HEALTHCARE DISTRICT 22 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 106 52 None 1 0 Hospital 1 3 3 11 42 67 26 4 None 1 None 2 None None 2 151 3 None 5 140 13 None None 157 1 None None None None None
106331216 331216 JOHN F. KENNEDY MEMORIAL HOSPITAL 33 Hospital RIVERSIDE 47111 MONROE STREET 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 1779 1602 None 1 0 Hospital 68 225 427 503 925 729 362 117 24 1 None 19 91 37 32 3201 1 None 2112 1232 37 None None 3348 7 2 None 23 None None