Table # Values
chargemasters_dirs 1 pk: 5354
full_name: 2024/STANFORD HEALTH CARE - CONSOLIDATED
oshpd_id: 106430035
year: 2024
chargemasters_files 1 pk: 12445
dir_pk: 5354
year: 2024
full_name: 2024/STANFORD HEALTH CARE - CONSOLIDATED/106430035_CDM_All.xlsx
oshpd_id: 106430035
file_type: CDM All
file_ext: xlsx
common25: None
facility_profile_attributes 1 facility_desc: STANFORD HEALTH CARE
site_address1: 500 PASTEUR DRIVE
site_address2: None
site_city: PALO ALTO
site_zip: 94304
site_x_coordinate: -122.176635
site_y_coordinate: 37.434514
oshpd_id: 106430035
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
license_number: 070000662
facility_level_desc: Consolidated Facility
er_service_level_desc: Basic
licensed_beds: 368
facility_status_desc: Open
financial_facility_count: 2
consolidated_facility_desc_pipe: STANFORD HEALTH CARE|STANFORD HEALTH CARE
consolidated_facility_desc_comma: STANFORD HEALTH CARE, STANFORD HEALTH CARE
period_begin_date: 2022-09-01
period_end_date: 2023-08-31
net_pat_rev_medicare_traditional_ip: 695120501
net_pat_rev_medicare_managed_ip: 226226101
net_pat_rev_medi_cal_traditional_ip: 136979056
net_pat_rev_medi_cal_managed_ip: 195837719
net_pat_rev_county_indigent_traditional_ip: 0
net_pat_rev_county_indigent_managed_ip: 0
net_pat_rev_third_party_traditional_ip: 78316768
net_pat_rev_third_party_managed_ip: 1612969649
net_pat_rev_other_indigent_ip: 0
net_pat_rev_other_payer_ip: 11463234
net_pat_rev_total_ip: 2956913029
net_pat_rev_medicare_traditional_op: 419760359
net_pat_rev_medicare_managed_op: 180470436
net_pat_rev_medi_cal_traditional_op: 64207117
net_pat_rev_medi_cal_managed_op: 168336940
net_pat_rev_county_indigent_traditional_op: 0
net_pat_rev_county_indigent_managed_op: 0
net_pat_rev_third_party_traditional_op: 304748355
net_pat_rev_third_party_managed_op: 2596124081
net_pat_rev_other_indigent_op: 0
net_pat_rev_other_payer_op: 28988538
net_pat_rev_total_op: 3762635825
payer_mix_medicare_traditional_ip: .365078427318
payer_mix_medicare_traditional_ip_state: .2319
payer_mix_medicare_managed_ip: .130771275810
payer_mix_medicare_managed_ip_state: .1787
payer_mix_medi_cal_traditional_ip: .037780994298
payer_mix_medi_cal_traditional_ip_state: .0995
payer_mix_medi_cal_managed_ip: .157445425811
payer_mix_medi_cal_managed_ip_state: .2287
payer_mix_county_indigent_traditional_ip: .000000000000
payer_mix_county_indigent_traditional_ip_state: .0097
payer_mix_county_indigent_managed_ip: .000000000000
payer_mix_county_indigent_managed_ip_state: .0002
payer_mix_third_party_traditional_ip: .021888754320
payer_mix_third_party_traditional_ip_state: .0365
payer_mix_third_party_managed_ip: .272354001122
payer_mix_third_party_managed_ip_state: .1991
payer_mix_other_indigent_ip: .003308421705
payer_mix_other_indigent_ip_state: .0050
payer_mix_other_payer_ip: .011372699613
payer_mix_other_payer_ip_state: .0107
payer_mix_medicare_traditional_op: .321869181250
payer_mix_medicare_traditional_op_state: .2267
payer_mix_medicare_managed_op: .093056697405
payer_mix_medicare_managed_op_state: .0967
payer_mix_medi_cal_traditional_op: .014894725069
payer_mix_medi_cal_traditional_op_state: .0584
payer_mix_medi_cal_managed_op: .100067103297
payer_mix_medi_cal_managed_op_state: .2641
payer_mix_county_indigent_traditional_op: .000000000000
payer_mix_county_indigent_traditional_op_state: .0109
payer_mix_county_indigent_managed_op: .000000000000
payer_mix_county_indigent_managed_op_state: .0018
payer_mix_third_party_traditional_op: .041053975923
payer_mix_third_party_traditional_op_state: .0490
payer_mix_third_party_managed_op: .419145194813
payer_mix_third_party_managed_op_state: .2667
payer_mix_other_indigent_op: .000643020217
payer_mix_other_indigent_op_state: .0074
payer_mix_other_payer_op: .009270102021
payer_mix_other_payer_op_state: .0182
avg_stay_medicare_traditional: 7.0119
avg_stay_medicare_managed: 7.3533
avg_stay_medi_cal_traditional: 8.0704
avg_stay_medi_cal_managed: 6.9308
avg_stay_county_indigent_traditional: .0000
avg_stay_county_indigent_managed: .0000
avg_stay_third_party_traditional: 11.1134
avg_stay_third_party_managed: 7.1597
avg_stay_other_indigent_total: 7.1429
avg_stay_other_payer_total: 3.3610
avg_stay_total: 7.1727
active_projects: None
active_project_costs: None
active_projects_state: 4279
active_project_costs_state: 18558539344
spc_1: None
spc_2: None
spc_3: None
spc_4: None
spc_5: None
spc_1_state: 33
spc_2_state: 655
spc_3_state: 385
spc_4_state: 781
spc_5_state: 1446
sysdate: None
licensed_facility_listing_01 1 oshpd_id: 106430035
facility_name: STANFORD HEALTH CARE
license_num: 070000662
facility_level_desc: Consolidated Facility
dba_address1: 500 PASTEUR DRIVE
dba_city: PALO ALTO
dba_zip_code: 94304
county_code: 43
county_name: Santa Clara
er_service_level_desc: Emergency - Basic
total_number_beds: 368
facility_status_desc: Open
facility_status_date: 2019-11-07
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 37.43451410
longitude: -122.17663490
licensed_facility_listing_06 1 oshpd_id: 106430035
facility_name: STANFORD HEALTH CARE
license_num: 070000662
facility_level_desc: Consolidated Facility
dba_address1: 500 Pasteur Dr
dba_city: Palo Alto
dba_zip_code: 94304
county_code: 43
county_name: Santa Clara
er_service_level_desc: Emergency - Comprehensive
total_number_beds: 368
facility_status_desc: Open
facility_status_date: 2019-11-07
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 37.43384000
longitude: -122.17657000
licensed_facility_listing_07 1 oshpd_id: 106430035
facility_name: STANFORD HEALTH CARE
license_num: 070000662
facility_level_desc: Consolidated Facility
dba_address1: 500 Pasteur Dr
dba_city: Palo Alto
dba_zip_code: 94304
county_code: 43
county_name: Santa Clara
er_service_level_desc: Emergency - Comprehensive
total_number_beds: 368
facility_status_desc: Open
facility_status_date: 2019-11-07
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 37.43384000
longitude: -122.17657000
licensed_facility_listing_08 1 oshpd_id: 106430035
facility_name: STANFORD HEALTH CARE
license_num: 070000662
facility_level_desc: Consolidated Facility
dba_address1: 500 Pasteur Dr
dba_city: Palo Alto
dba_zip_code: 94304
county_code: 43
county_name: Santa Clara
er_service_level_desc: Emergency - Comprehensive
total_number_beds: 368
facility_status_desc: Open
facility_status_date: 2019-11-07
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 37.43384000
longitude: -122.17657000
licensed_facility_listing_09 1 oshpd_id: 106430035
facility_name: STANFORD HEALTH CARE
license_num: 070000662
facility_level_desc: Consolidated Facility
dba_address1: 500 PASTEUR DRIVE
dba_city: PALO ALTO
dba_zip_code: 94304
county_code: 43
county_name: Santa Clara
er_service_level_desc: None
total_number_beds: 368
facility_status_desc: Open
facility_status_date: 2019-11-07
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 37.43451410
longitude: -122.17663490
licensed_facility_listing_10 1 oshpd_id: 106430035
facility_name: STANFORD HEALTH CARE
license_num: 070000662
facility_level_desc: Consolidated Facility
dba_address1: 500 PASTEUR DRIVE
dba_city: PALO ALTO
dba_zip_code: 94304
county_code: 43
county_name: Santa Clara
er_service_level_desc: Emergency - Basic
total_number_beds: 368
facility_status_desc: Open
facility_status_date: 2019-11-07
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 37.43451410
longitude: -122.17663490
licensed_facility_listing_14 1 oshpd_id: 106430035
facility_name: STANFORD HEALTH CARE
license_num: 070000662
facility_level_desc: Consolidated Facility
dba_address1: 500 Pasteur Dr
dba_city: Palo Alto
dba_zip_code: 94304
county_code: 43
county_name: Santa Clara
er_service_level_desc: Emergency - Comprehensive
total_number_beds: 368
facility_status_desc: Open
facility_status_date: 2019-11-07
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 37.43384000
longitude: -122.17657000
licensed_facility_listing_15 1 oshpd_id: 106430035
facility_name: STANFORD HEALTH CARE
license_num: 070000662
facility_level_desc: Consolidated Facility
dba_address1: 500 Pasteur Dr
dba_city: Palo Alto
dba_zip_code: 94304
county_code: 43
county_name: Santa Clara
er_service_level_desc: Emergency - Comprehensive
total_number_beds: 368
facility_status_desc: Open
facility_status_date: 2019-11-07
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 37.43384000
longitude: -122.17657000
licensed_facility_listing_16 1 oshpd_id: 106430035
facility_name: STANFORD HEALTH CARE
license_num: 070000662
facility_level_desc: Consolidated Facility
dba_address1: 500 Pasteur Dr
dba_city: Palo Alto
dba_zip_code: 94304
county_code: 43
county_name: Santa Clara
er_service_level_desc: Emergency - Comprehensive
total_number_beds: 368
facility_status_desc: Open
facility_status_date: 2019-11-07
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 37.43384000
longitude: -122.17657000
licensed_facility_listing_17 1 oshpd_id: 106430035
facility_name: STANFORD HEALTH CARE
license_num: 070000662
facility_level_desc: Consolidated Facility
dba_address1: 500 Pasteur Dr
dba_city: Palo Alto
dba_zip_code: 94304
county_code: 43
county_name: Santa Clara
er_service_level_desc: None
total_number_beds: 368
facility_status_desc: Open
facility_status_date: 2019-11-07
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 37.43384000
longitude: -122.17657000
licensed_facility_listing_18 1 oshpd_id: 106430035
facility_name: STANFORD HEALTH CARE
license_num: 070000662
facility_level_desc: Consolidated Facility
dba_address1: 500 PASTEUR DRIVE
dba_city: PALO ALTO
dba_zip_code: 94304
county_code: 43
county_name: Santa Clara
er_service_level_desc: Emergency - Basic
total_number_beds: 368
facility_status_desc: Open
facility_status_date: 2019-11-07
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 37.43451410
longitude: -122.17663490
licensed_healthcare_facility_listing 8 period: current
oshpd_id: 106430035
facility_name: STANFORD HEALTH CARE
license_num: 070000662
facility_level_desc: Consolidated Facility
dba_address1: 500 PASTEUR DRIVE
dba_city: PALO ALTO
dba_zip_code: 94304
county_code: 43
county_name: Santa Clara
er_service_level_desc: Emergency - Basic
total_number_beds: 368
facility_status_desc: Open
facility_status_date: 2019-11-07
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 37.43451410
longitude: -122.17663490
period: 2020-12-31
oshpd_id: 106430035
facility_name: STANFORD HEALTH CARE
license_num: 070000662
facility_level_desc: Consolidated Facility
dba_address1: 500 Pasteur Dr
dba_city: Palo Alto
dba_zip_code: 94304
county_code: 43
county_name: Santa Clara
er_service_level_desc: Emergency - Comprehensive
total_number_beds: 368
facility_status_desc: Open
facility_status_date: 2019-11-07
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 37.43384000
longitude: -122.17657000
period: 2021-12-31
oshpd_id: 106430035
facility_name: STANFORD HEALTH CARE
license_num: 070000662
facility_level_desc: Consolidated Facility
dba_address1: 500 Pasteur Dr
dba_city: Palo Alto
dba_zip_code: 94304
county_code: 43
county_name: Santa Clara
er_service_level_desc: Emergency - Comprehensive
total_number_beds: 368
facility_status_desc: Open
facility_status_date: 2019-11-07
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 37.43384000
longitude: -122.17657000
period: 2022-12-31
oshpd_id: 106430035
facility_name: STANFORD HEALTH CARE
license_num: 070000662
facility_level_desc: Consolidated Facility
dba_address1: 500 Pasteur Dr
dba_city: Palo Alto
dba_zip_code: 94304
county_code: 43
county_name: Santa Clara
er_service_level_desc: Emergency - Comprehensive
total_number_beds: 368
facility_status_desc: Open
facility_status_date: 2019-11-07
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 37.43384000
longitude: -122.17657000
period: 2020-06-30
oshpd_id: 106430035
facility_name: STANFORD HEALTH CARE
license_num: 070000662
facility_level_desc: Consolidated Facility
dba_address1: 500 Pasteur Dr
dba_city: Palo Alto
dba_zip_code: 94304
county_code: 43
county_name: Santa Clara
er_service_level_desc: Emergency - Comprehensive
total_number_beds: 368
facility_status_desc: Open
facility_status_date: 2019-11-07
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 37.43384000
longitude: -122.17657000
period: 2021-06-30
oshpd_id: 106430035
facility_name: STANFORD HEALTH CARE
license_num: 070000662
facility_level_desc: Consolidated Facility
dba_address1: 500 Pasteur Dr
dba_city: Palo Alto
dba_zip_code: 94304
county_code: 43
county_name: Santa Clara
er_service_level_desc: Emergency - Comprehensive
total_number_beds: 368
facility_status_desc: Open
facility_status_date: 2019-11-07
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 37.43384000
longitude: -122.17657000
period: 2022-06-30
oshpd_id: 106430035
facility_name: STANFORD HEALTH CARE
license_num: 070000662
facility_level_desc: Consolidated Facility
dba_address1: 500 Pasteur Dr
dba_city: Palo Alto
dba_zip_code: 94304
county_code: 43
county_name: Santa Clara
er_service_level_desc: Emergency - Comprehensive
total_number_beds: 368
facility_status_desc: Open
facility_status_date: 2019-11-07
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 37.43384000
longitude: -122.17657000
period: 2023-06-30
oshpd_id: 106430035
facility_name: STANFORD HEALTH CARE
license_num: 070000662
facility_level_desc: Consolidated Facility
dba_address1: 500 Pasteur Dr
dba_city: Palo Alto
dba_zip_code: 94304
county_code: 43
county_name: Santa Clara
er_service_level_desc: None
total_number_beds: 368
facility_status_desc: Open
facility_status_date: 2019-11-07
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 37.43384000
longitude: -122.17657000