Table # Values
chargemasters_dirs 1 pk: 4204
full_name: 2022/College Medical Center Hawthorne Campus
oshpd_id: 106190523
year: 2022

chargemasters_files 1 pk: 10508
dir_pk: 4204
year: 2022
full_name: 2022/College Medical Center Hawthorne Campus/106190523_CDM_All.xlsx
oshpd_id: 106190523
file_type: CDM All
file_ext: xlsx
common25: 54

licensed_facility_listing_01 1 oshpd_id: 106190523
perm_id: 11845
facility_name: COLLEGE MEDICAL CENTER HAWTHORNE CAMPUS
license_num: 930000117
facility_level_desc: General Acute Care Hospital
dba_address1: 13300 HAWTHORNE BOULEVARD
dba_city: HAWTHORNE
dba_zip_code: 90250
county_code: 19
county_name: Los Angeles
er_service_level_desc: None
total_number_beds: 64
facility_status_desc: Open
facility_status_date: 2014-10-09
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 33.91160180
longitude: -118.35194760

licensed_facility_listing_02 1 oshpd_id: 106190523
facility_name: COLLEGE MEDICAL CENTER HAWTHORNE CAMPUS
license_num: 930000117
facility_level_desc: Distinct Part Facility
dba_address1: 13300 HAWTHORNE BOULEVARD
dba_city: HAWTHORNE
dba_zip_code: 90250
county_code: 19
county_name: LOS ANGELES
er_service_level_desc: None
total_number_beds: 64
facility_status_desc: Open
facility_status_date: 10/09/2014
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
longitude: -118.35238
latitude: 33.91145

licensed_facility_listing_03 1 oshpd_id: 106190523
facility_name: COLLEGE MEDICAL CENTER HAWTHORNE CAMPUS
license_num: 930000117
facility_level_desc: Distinct Part Facility
dba_address1: 13300 HAWTHORNE BOULEVARD
dba_city: HAWTHORNE
dba_zip_code: 90250
county_code: 19
county_name: LOS ANGELES
er_service_level_desc: None
total_number_beds: 64
facility_status_desc: Open
facility_status_date: 10/9/2014
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 33.91145
longitude: -118.35238

licensed_facility_listing_04 1 oshpd_id: 106190523
facility_name: COLLEGE MEDICAL CENTER HAWTHORNE CAMPUS
license_num: 930000117
facility_level_desc: Distinct Part Facility
dba_address1: 13300 HAWTHORNE BOULEVARD
dba_city: HAWTHORNE
dba_zip_code: 90250
county_code: 19
county_name: LOS ANGELES
er_service_level_desc: None
total_number_beds: 64
facility_status_desc: Open
facility_status_date: 2014-10-09
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 33.91145000
longitude: -118.35238000

licensed_facility_listing_05 1 oshpd_id: 106190523
facility_name: COLLEGE MEDICAL CENTER HAWTHORNE CAMPUS
license_num: 930000117
facility_level_desc: Distinct Part Facility
dba_address1: 13300 HAWTHORNE BOULEVARD
dba_city: HAWTHORNE
dba_zip_code: 90250
county_code: 19
county_name: LOS ANGELES
er_service_level_desc: None
total_number_beds: 64
facility_status_desc: Open
facility_status_date: 2014-10-09
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 33.91145000
longitude: -118.35238000

licensed_facility_listing_06 1 oshpd_id: 106190523
facility_name: COLLEGE MEDICAL CENTER HAWTHORNE CAMPUS
license_num: 930000117
facility_level_desc: Distinct Part Facility
dba_address1: 13300 Hawthorne Blvd
dba_city: Hawthorne
dba_zip_code: 90250
county_code: 19
county_name: Los Angeles
er_service_level_desc: None
total_number_beds: 64
facility_status_desc: Open
facility_status_date: 2014-10-09
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 33.91145000
longitude: -118.35238000

licensed_facility_listing_07 1 oshpd_id: 106190523
facility_name: COLLEGE MEDICAL CENTER HAWTHORNE CAMPUS
license_num: 930000117
facility_level_desc: Distinct Part Facility
dba_address1: 13300 Hawthorne Blvd
dba_city: Hawthorne
dba_zip_code: 90250
county_code: 19
county_name: Los Angeles
er_service_level_desc: None
total_number_beds: 64
facility_status_desc: Open
facility_status_date: 2014-10-09
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 33.91145000
longitude: -118.35238000

licensed_facility_listing_08 1 oshpd_id: 106190523
facility_name: COLLEGE MEDICAL CENTER HAWTHORNE CAMPUS
license_num: 930000117
facility_level_desc: Distinct Part Facility
dba_address1: 13300 Hawthorne Blvd
dba_city: Hawthorne
dba_zip_code: 90250
county_code: 19
county_name: Los Angeles
er_service_level_desc: None
total_number_beds: 64
facility_status_desc: Open
facility_status_date: 2014-10-09
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 33.91145000
longitude: -118.35238000

licensed_facility_listing_09 1 oshpd_id: 106190523
facility_name: COLLEGE MEDICAL CENTER HAWTHORNE CAMPUS
license_num: 930000117
facility_level_desc: Distinct Part Facility
dba_address1: 13300 HAWTHORNE BOULEVARD
dba_city: HAWTHORNE
dba_zip_code: 90250
county_code: 19
county_name: Los Angeles
er_service_level_desc: None
total_number_beds: 64
facility_status_desc: Open
facility_status_date: 2014-10-09
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 33.91160180
longitude: -118.35194760

licensed_facility_listing_10 1 oshpd_id: 106190523
facility_name: COLLEGE MEDICAL CENTER HAWTHORNE CAMPUS
license_num: 930000117
facility_level_desc: Distinct Part Facility
dba_address1: 13300 HAWTHORNE BOULEVARD
dba_city: HAWTHORNE
dba_zip_code: 90250
county_code: 19
county_name: Los Angeles
er_service_level_desc: None
total_number_beds: 64
facility_status_desc: Open
facility_status_date: 2014-10-09
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 33.91160180
longitude: -118.35194760

licensed_facility_listing_11 1 oshpd_id: 106190523
facility_name: COLLEGE MEDICAL CENTER HAWTHORNE CAMPUS
license_num: 930000117
facility_level_desc: Distinct Part Facility
dba_address1: 13300 HAWTHORNE BOULEVARD
dba_city: HAWTHORNE
dba_zip_code: 90250
county_code: 19
county_name: LOS ANGELES
er_service_level_desc: None
total_number_beds: 64
facility_status_desc: Open
facility_status_date: 2014-10-09
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 33.91145000
longitude: -118.35238000

licensed_facility_listing_12 1 oshpd_id: 106190523
facility_name: COLLEGE MEDICAL CENTER HAWTHORNE CAMPUS
license_num: 930000117
facility_level_desc: Distinct Part Facility
dba_address1: 13300 HAWTHORNE BOULEVARD
dba_city: HAWTHORNE
dba_zip_code: 90250
county_code: 19
county_name: LOS ANGELES
er_service_level_desc: None
total_number_beds: 64
facility_status_desc: Open
facility_status_date: 2014-10-09
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 33.91145000
longitude: -118.35238000

licensed_facility_listing_13 1 oshpd_id: 106190523
facility_name: COLLEGE MEDICAL CENTER HAWTHORNE CAMPUS
license_num: 930000117
facility_level_desc: Distinct Part Facility
dba_address1: 13300 HAWTHORNE BOULEVARD
dba_city: HAWTHORNE
dba_zip_code: 90250
county_code: 19
county_name: LOS ANGELES
er_service_level_desc: None
total_number_beds: 64
facility_status_desc: Open
facility_status_date: 2014-10-09
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 33.91145000
longitude: -118.35238000

licensed_facility_listing_14 1 oshpd_id: 106190523
facility_name: COLLEGE MEDICAL CENTER HAWTHORNE CAMPUS
license_num: 930000117
facility_level_desc: Distinct Part Facility
dba_address1: 13300 Hawthorne Blvd
dba_city: Hawthorne
dba_zip_code: 90250
county_code: 19
county_name: Los Angeles
er_service_level_desc: None
total_number_beds: 64
facility_status_desc: Open
facility_status_date: 2014-10-09
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 33.91145000
longitude: -118.35238000

licensed_facility_listing_15 1 oshpd_id: 106190523
facility_name: COLLEGE MEDICAL CENTER HAWTHORNE CAMPUS
license_num: 930000117
facility_level_desc: Distinct Part Facility
dba_address1: 13300 Hawthorne Blvd
dba_city: Hawthorne
dba_zip_code: 90250
county_code: 19
county_name: Los Angeles
er_service_level_desc: None
total_number_beds: 64
facility_status_desc: Open
facility_status_date: 2014-10-09
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 33.91145000
longitude: -118.35238000

licensed_facility_listing_16 1 oshpd_id: 106190523
facility_name: COLLEGE MEDICAL CENTER HAWTHORNE CAMPUS
license_num: 930000117
facility_level_desc: Distinct Part Facility
dba_address1: 13300 Hawthorne Blvd
dba_city: Hawthorne
dba_zip_code: 90250
county_code: 19
county_name: Los Angeles
er_service_level_desc: None
total_number_beds: 64
facility_status_desc: Open
facility_status_date: 2014-10-09
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 33.91145000
longitude: -118.35238000

licensed_facility_listing_17 1 oshpd_id: 106190523
facility_name: COLLEGE MEDICAL CENTER HAWTHORNE CAMPUS
license_num: 930000117
facility_level_desc: Distinct Part Facility
dba_address1: 13300 Hawthorne Blvd
dba_city: Hawthorne
dba_zip_code: 90250
county_code: 19
county_name: Los Angeles
er_service_level_desc: None
total_number_beds: 64
facility_status_desc: Open
facility_status_date: 2014-10-09
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 33.91145000
longitude: -118.35238000

licensed_facility_listing_18 1 oshpd_id: 106190523
facility_name: COLLEGE MEDICAL CENTER HAWTHORNE CAMPUS
license_num: 930000117
facility_level_desc: Distinct Part Facility
dba_address1: 13300 HAWTHORNE BOULEVARD
dba_city: HAWTHORNE
dba_zip_code: 90250
county_code: 19
county_name: Los Angeles
er_service_level_desc: None
total_number_beds: 64
facility_status_desc: Open
facility_status_date: 2014-10-09
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 33.91160180
longitude: -118.35194760

licensed_healthcare_facility_listing 15 period: current
oshpd_id: 106190523
facility_name: COLLEGE MEDICAL CENTER HAWTHORNE CAMPUS
license_num: 930000117
facility_level_desc: Distinct Part Facility
dba_address1: 13300 HAWTHORNE BOULEVARD
dba_city: HAWTHORNE
dba_zip_code: 90250
county_code: 19
county_name: Los Angeles
er_service_level_desc: None
total_number_beds: 64
facility_status_desc: Open
facility_status_date: 2014-10-09
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 33.91160180
longitude: -118.35194760

period: 2016-12-31
oshpd_id: 106190523
facility_name: COLLEGE MEDICAL CENTER HAWTHORNE CAMPUS
license_num: 930000117
facility_level_desc: Distinct Part Facility
dba_address1: 13300 HAWTHORNE BOULEVARD
dba_city: HAWTHORNE
dba_zip_code: 90250
county_code: 19
county_name: LOS ANGELES
er_service_level_desc: None
total_number_beds: 64
facility_status_desc: Open
facility_status_date: 2014-10-09
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 33.91145000
longitude: -118.35238000

period: 2017-12-31
oshpd_id: 106190523
facility_name: COLLEGE MEDICAL CENTER HAWTHORNE CAMPUS
license_num: 930000117
facility_level_desc: Distinct Part Facility
dba_address1: 13300 HAWTHORNE BOULEVARD
dba_city: HAWTHORNE
dba_zip_code: 90250
county_code: 19
county_name: LOS ANGELES
er_service_level_desc: None
total_number_beds: 64
facility_status_desc: Open
facility_status_date: 2014-10-09
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 33.91145000
longitude: -118.35238000

period: 2018-12-31
oshpd_id: 106190523
facility_name: COLLEGE MEDICAL CENTER HAWTHORNE CAMPUS
license_num: 930000117
facility_level_desc: Distinct Part Facility
dba_address1: 13300 HAWTHORNE BOULEVARD
dba_city: HAWTHORNE
dba_zip_code: 90250
county_code: 19
county_name: LOS ANGELES
er_service_level_desc: None
total_number_beds: 64
facility_status_desc: Open
facility_status_date: 2014-10-09
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 33.91145000
longitude: -118.35238000

period: 2019-12-31
oshpd_id: 106190523
facility_name: COLLEGE MEDICAL CENTER HAWTHORNE CAMPUS
license_num: 930000117
facility_level_desc: Distinct Part Facility
dba_address1: 13300 HAWTHORNE BOULEVARD
dba_city: HAWTHORNE
dba_zip_code: 90250
county_code: 19
county_name: LOS ANGELES
er_service_level_desc: None
total_number_beds: 64
facility_status_desc: Open
facility_status_date: 2014-10-09
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 33.91145000
longitude: -118.35238000

period: 2020-12-31
oshpd_id: 106190523
facility_name: COLLEGE MEDICAL CENTER HAWTHORNE CAMPUS
license_num: 930000117
facility_level_desc: Distinct Part Facility
dba_address1: 13300 Hawthorne Blvd
dba_city: Hawthorne
dba_zip_code: 90250
county_code: 19
county_name: Los Angeles
er_service_level_desc: None
total_number_beds: 64
facility_status_desc: Open
facility_status_date: 2014-10-09
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 33.91145000
longitude: -118.35238000

period: 2021-12-31
oshpd_id: 106190523
facility_name: COLLEGE MEDICAL CENTER HAWTHORNE CAMPUS
license_num: 930000117
facility_level_desc: Distinct Part Facility
dba_address1: 13300 Hawthorne Blvd
dba_city: Hawthorne
dba_zip_code: 90250
county_code: 19
county_name: Los Angeles
er_service_level_desc: None
total_number_beds: 64
facility_status_desc: Open
facility_status_date: 2014-10-09
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 33.91145000
longitude: -118.35238000

period: 2022-12-31
oshpd_id: 106190523
facility_name: COLLEGE MEDICAL CENTER HAWTHORNE CAMPUS
license_num: 930000117
facility_level_desc: Distinct Part Facility
dba_address1: 13300 Hawthorne Blvd
dba_city: Hawthorne
dba_zip_code: 90250
county_code: 19
county_name: Los Angeles
er_service_level_desc: None
total_number_beds: 64
facility_status_desc: Open
facility_status_date: 2014-10-09
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 33.91145000
longitude: -118.35238000

period: 2017-06-30
oshpd_id: 106190523
facility_name: COLLEGE MEDICAL CENTER HAWTHORNE CAMPUS
license_num: 930000117
facility_level_desc: Distinct Part Facility
dba_address1: 13300 HAWTHORNE BOULEVARD
dba_city: HAWTHORNE
dba_zip_code: 90250
county_code: 19
county_name: LOS ANGELES
er_service_level_desc: None
total_number_beds: 64
facility_status_desc: Open
facility_status_date: 2014-10-09
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 33.91145000
longitude: -118.35238000

period: 2018-06-30
oshpd_id: 106190523
facility_name: COLLEGE MEDICAL CENTER HAWTHORNE CAMPUS
license_num: 930000117
facility_level_desc: Distinct Part Facility
dba_address1: 13300 HAWTHORNE BOULEVARD
dba_city: HAWTHORNE
dba_zip_code: 90250
county_code: 19
county_name: LOS ANGELES
er_service_level_desc: None
total_number_beds: 64
facility_status_desc: Open
facility_status_date: 2014-10-09
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 33.91145000
longitude: -118.35238000

period: 2019-06-30
oshpd_id: 106190523
facility_name: COLLEGE MEDICAL CENTER HAWTHORNE CAMPUS
license_num: 930000117
facility_level_desc: Distinct Part Facility
dba_address1: 13300 HAWTHORNE BOULEVARD
dba_city: HAWTHORNE
dba_zip_code: 90250
county_code: 19
county_name: LOS ANGELES
er_service_level_desc: None
total_number_beds: 64
facility_status_desc: Open
facility_status_date: 2014-10-09
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 33.91145000
longitude: -118.35238000

period: 2020-06-30
oshpd_id: 106190523
facility_name: COLLEGE MEDICAL CENTER HAWTHORNE CAMPUS
license_num: 930000117
facility_level_desc: Distinct Part Facility
dba_address1: 13300 Hawthorne Blvd
dba_city: Hawthorne
dba_zip_code: 90250
county_code: 19
county_name: Los Angeles
er_service_level_desc: None
total_number_beds: 64
facility_status_desc: Open
facility_status_date: 2014-10-09
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 33.91145000
longitude: -118.35238000

period: 2021-06-30
oshpd_id: 106190523
facility_name: COLLEGE MEDICAL CENTER HAWTHORNE CAMPUS
license_num: 930000117
facility_level_desc: Distinct Part Facility
dba_address1: 13300 Hawthorne Blvd
dba_city: Hawthorne
dba_zip_code: 90250
county_code: 19
county_name: Los Angeles
er_service_level_desc: None
total_number_beds: 64
facility_status_desc: Open
facility_status_date: 2014-10-09
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 33.91145000
longitude: -118.35238000

period: 2022-06-30
oshpd_id: 106190523
facility_name: COLLEGE MEDICAL CENTER HAWTHORNE CAMPUS
license_num: 930000117
facility_level_desc: Distinct Part Facility
dba_address1: 13300 Hawthorne Blvd
dba_city: Hawthorne
dba_zip_code: 90250
county_code: 19
county_name: Los Angeles
er_service_level_desc: None
total_number_beds: 64
facility_status_desc: Open
facility_status_date: 2014-10-09
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 33.91145000
longitude: -118.35238000

period: 2023-06-30
oshpd_id: 106190523
facility_name: COLLEGE MEDICAL CENTER HAWTHORNE CAMPUS
license_num: 930000117
facility_level_desc: Distinct Part Facility
dba_address1: 13300 Hawthorne Blvd
dba_city: Hawthorne
dba_zip_code: 90250
county_code: 19
county_name: Los Angeles
er_service_level_desc: None
total_number_beds: 64
facility_status_desc: Open
facility_status_date: 2014-10-09
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 33.91145000
longitude: -118.35238000