Table: ambulatory_surgery_char_by_faclty_2016 , 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_id facility_num facility_name county_code license_type_desc county_name dba_address1 dba_city dba_zip_code control_type_desc rural_hospital_desc teaching_hospital_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 hispanic other_race unknown_race white american_indian_alaska_native acute_care rehab routine sn_ic_care against_medical_advice cah childrens_or_cancer home_health_service hospice_care invalid_blank_disp
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) None None 500+ District 7 District 16 CLAYTON/CONCORD SOUTH/WALNUT CREEK CENTRAL AND EAST Urban NA 2284 1599 None 1 0 Hospital 245 156 330 479 620 734 681 456 169 13 None 386 207 463 131 84 2605 7 2 3 3756 55 None None None 51 11 None
106071018 071018 JOHN MUIR MEDICAL CENTER-CONCORD CAMPUS 07 Hospital CONTRA COSTA 2540 EAST STREET CONCORD 94520 Non-profit Corporation (incl. Church-related) None None 200-299 District 7 District 14 AVON/CLYDE/CONCORD CENTRAL/PITTSBURG SOUTHWEST Urban NA 3328 3715 None 1 0 Hospital 39 181 408 692 1481 1936 1492 814 None None None 677 494 927 169 122 4635 19 9 None 6942 48 4 None None 28 8 None
106220733 220733 JOHN C FREMONT HEALTHCARE DISTRICT 22 Hospital MARIPOSA 5189 HOSPITAL RD., PO BOX 216 MARIPOSA 95338 District SMALL/RURAL None 1-49 District 8 District 5 BOOTJACK/CATHEY¿S VALLEY/COULTERVILLE/DON PEDRO/EL PORTAL/FISH CAMP/MARIPOSA Rural Small/Rural 78 70 None 1 0 Hospital None 3 5 8 49 61 12 8 None 2 None 1 None 5 None 1 138 3 None None 148 None None None None None None None
106331216 331216 JOHN F KENNEDY MEMORIAL HOSPITAL 33 Hospital RIVERSIDE 47111 MONROE STREET INDIO 92201 Investor - Corporation None None 100-149 District 28 District 56 ARABIA/COACHELLA/DESERT BEACH/FLOWING WELLS/INDIO SOUTH/LA QUINTA EAST/MECCA/OASIS/THERMAL Urban NA 1411 1074 None 1 0 Hospital 89 210 388 498 473 437 260 108 22 None None 13 48 1464 10 9 934 7 None None 2462 14 1 None None 7 1 None