Table # Values
chargemasters_dirs 2 pk: 5003
full_name: 2023/UCSF Medical Center at Mission Bay
oshpd_id: 106384200
year: 2023

pk: 5308
full_name: 2024/UCSF MEDICAL CENTER AT MISSION BAY
oshpd_id: 106384200
year: 2024

chargemasters_files 2 pk: 11390
dir_pk: 5003
year: 2023
full_name: 2023/UCSF Medical Center at Mission Bay/106384200_CDM_ALL.xlsx
oshpd_id: 106384200
file_type: CDM All
file_ext: xlsx
common25: 52

pk: 12500
dir_pk: 5308
year: 2024
full_name: 2024/UCSF MEDICAL CENTER AT MISSION BAY/106384200_CDM_ALL.xlsx
oshpd_id: 106384200
file_type: CDM All
file_ext: xlsx
common25: None

licensed_healthcare_facility_listing 15 period: current
oshpd_id: 106384200
facility_name: UCSF MEDICAL CENTER AT MISSION BAY
license_num: 220000091
facility_level_desc: Consolidated Facility
dba_address1: 1975 4TH STREET
dba_city: SAN FRANCISCO
dba_zip_code: 94158
county_code: 38
county_name: San Francisco
er_service_level_desc: Emergency - Basic
total_number_beds: 289
facility_status_desc: Open
facility_status_date: 2014-12-17
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 37.76553120
longitude: -122.38991300

period: 2016-12-31
oshpd_id: 106384200
facility_name: UCSF MEDICAL CENTER AT MISSION BAY
license_num: 220000091
facility_level_desc: Consolidated Facility
dba_address1: 1975 4TH STREET
dba_city: SAN FRANCISCO
dba_zip_code: 94158
county_code: 38
county_name: SAN FRANCISCO
er_service_level_desc: Emergency - Basic
total_number_beds: 289
facility_status_desc: Open
facility_status_date: 2014-12-17
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 37.77189000
longitude: -122.39129000

period: 2017-12-31
oshpd_id: 106384200
facility_name: UCSF MEDICAL CENTER AT MISSION BAY
license_num: 220000091
facility_level_desc: Consolidated Facility
dba_address1: 1975 4TH STREET
dba_city: SAN FRANCISCO
dba_zip_code: 94158
county_code: 38
county_name: SAN FRANCISCO
er_service_level_desc: Emergency - Basic
total_number_beds: 289
facility_status_desc: Open
facility_status_date: 2014-12-17
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 37.77189000
longitude: -122.39129000

period: 2018-12-31
oshpd_id: 106384200
facility_name: UCSF MEDICAL CENTER AT MISSION BAY
license_num: 220000091
facility_level_desc: Consolidated Facility
dba_address1: 1975 4TH STREET
dba_city: SAN FRANCISCO
dba_zip_code: 94158
county_code: 38
county_name: SAN FRANCISCO
er_service_level_desc: Emergency - Basic
total_number_beds: 289
facility_status_desc: Open
facility_status_date: 2014-12-17
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 37.77189000
longitude: -122.39129000

period: 2019-12-31
oshpd_id: 106384200
facility_name: UCSF MEDICAL CENTER AT MISSION BAY
license_num: 220000091
facility_level_desc: Consolidated Facility
dba_address1: 1975 4TH STREET
dba_city: SAN FRANCISCO
dba_zip_code: 94158
county_code: 38
county_name: SAN FRANCISCO
er_service_level_desc: Emergency - Basic
total_number_beds: 289
facility_status_desc: Open
facility_status_date: 2014-12-17
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 37.77189000
longitude: -122.39129000

period: 2020-12-31
oshpd_id: 106384200
facility_name: UCSF MEDICAL CENTER AT MISSION BAY
license_num: 220000091
facility_level_desc: Consolidated Facility
dba_address1: 4th St
dba_city: San Francisco
dba_zip_code: 94158
county_code: 38
county_name: San Francisco
er_service_level_desc: Emergency - Basic
total_number_beds: 289
facility_status_desc: Open
facility_status_date: 2014-12-17
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 37.77189000
longitude: -122.39129000

period: 2021-12-31
oshpd_id: 106384200
facility_name: UCSF MEDICAL CENTER AT MISSION BAY
license_num: 220000091
facility_level_desc: Consolidated Facility
dba_address1: 4th St
dba_city: San Francisco
dba_zip_code: 94158
county_code: 38
county_name: San Francisco
er_service_level_desc: Emergency - Basic
total_number_beds: 289
facility_status_desc: Open
facility_status_date: 2014-12-17
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 37.77189000
longitude: -122.39129000

period: 2022-12-31
oshpd_id: 106384200
facility_name: UCSF MEDICAL CENTER AT MISSION BAY
license_num: 220000091
facility_level_desc: Consolidated Facility
dba_address1: 4th St
dba_city: San Francisco
dba_zip_code: 94158
county_code: 38
county_name: San Francisco
er_service_level_desc: Emergency - Basic
total_number_beds: 289
facility_status_desc: Open
facility_status_date: 2014-12-17
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 37.77189000
longitude: -122.39129000

period: 2017-06-30
oshpd_id: 106384200
facility_name: UCSF MEDICAL CENTER AT MISSION BAY
license_num: 220000091
facility_level_desc: Consolidated Facility
dba_address1: 1975 4TH STREET
dba_city: SAN FRANCISCO
dba_zip_code: 94158
county_code: 38
county_name: SAN FRANCISCO
er_service_level_desc: Emergency - Basic
total_number_beds: 289
facility_status_desc: Open
facility_status_date: 2014-12-17
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 37.77189000
longitude: -122.39129000

period: 2018-06-30
oshpd_id: 106384200
facility_name: UCSF MEDICAL CENTER AT MISSION BAY
license_num: 220000091
facility_level_desc: Consolidated Facility
dba_address1: 1975 4TH STREET
dba_city: SAN FRANCISCO
dba_zip_code: 94158
county_code: 38
county_name: SAN FRANCISCO
er_service_level_desc: Emergency - Basic
total_number_beds: 289
facility_status_desc: Open
facility_status_date: 2014-12-17
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 37.77189000
longitude: -122.39129000

period: 2019-06-30
oshpd_id: 106384200
facility_name: UCSF MEDICAL CENTER AT MISSION BAY
license_num: 220000091
facility_level_desc: Consolidated Facility
dba_address1: 1975 4TH STREET
dba_city: SAN FRANCISCO
dba_zip_code: 94158
county_code: 38
county_name: SAN FRANCISCO
er_service_level_desc: Emergency - Basic
total_number_beds: 289
facility_status_desc: Open
facility_status_date: 2014-12-17
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 37.77189000
longitude: -122.39129000

period: 2020-06-30
oshpd_id: 106384200
facility_name: UCSF MEDICAL CENTER AT MISSION BAY
license_num: 220000091
facility_level_desc: Consolidated Facility
dba_address1: 4th St
dba_city: San Francisco
dba_zip_code: 94158
county_code: 38
county_name: San Francisco
er_service_level_desc: Emergency - Basic
total_number_beds: 289
facility_status_desc: Open
facility_status_date: 2014-12-17
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 37.77189000
longitude: -122.39129000

period: 2021-06-30
oshpd_id: 106384200
facility_name: UCSF MEDICAL CENTER AT MISSION BAY
license_num: 220000091
facility_level_desc: Consolidated Facility
dba_address1: 4th St
dba_city: San Francisco
dba_zip_code: 94158
county_code: 38
county_name: San Francisco
er_service_level_desc: Emergency - Basic
total_number_beds: 289
facility_status_desc: Open
facility_status_date: 2014-12-17
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 37.77189000
longitude: -122.39129000

period: 2022-06-30
oshpd_id: 106384200
facility_name: UCSF MEDICAL CENTER AT MISSION BAY
license_num: 220000091
facility_level_desc: Consolidated Facility
dba_address1: 4th St
dba_city: San Francisco
dba_zip_code: 94158
county_code: 38
county_name: San Francisco
er_service_level_desc: Emergency - Basic
total_number_beds: 289
facility_status_desc: Open
facility_status_date: 2014-12-17
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 37.77189000
longitude: -122.39129000

period: 2023-06-30
oshpd_id: 106384200
facility_name: UCSF MEDICAL CENTER AT MISSION BAY
license_num: 220000091
facility_level_desc: Consolidated Facility
dba_address1: 1975 4th St
dba_city: San Francisco
dba_zip_code: 94158
county_code: 38
county_name: San Francisco
er_service_level_desc: Emergency - Basic
total_number_beds: 289
facility_status_desc: Open
facility_status_date: 2014-12-17
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 37.76515000
longitude: -122.39041000