Table # Values
facility_profile_attributes 1 facility_desc: VILLA CORONADO (DP/SNF)
site_address1: 233 PROSPECT PLACE
site_address2: None
site_city: CORONADO
site_zip: 92118
site_x_coordinate: -117.167329
site_y_coordinate: 32.694472
oshpd_id: 206374321
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
license_number: 090000036
facility_level_desc: Distinct Part Facility
er_service_level_desc: Not Specified
licensed_beds: 122
facility_status_desc: Open
financial_facility_count: 2
consolidated_facility_desc_pipe: SHARP CORONADO HOSPITAL AND HEALTHCARE CENTER|VILLA CORONADO (DP/SNF)
consolidated_facility_desc_comma: SHARP CORONADO HOSPITAL AND HEALTHCARE CENTER, VILLA CORONADO (DP/SNF)
period_begin_date: 2022-10-01
period_end_date: 2023-09-30
net_pat_rev_medicare_traditional_ip: 11421480
net_pat_rev_medicare_managed_ip: 5019059
net_pat_rev_medi_cal_traditional_ip: 5605508
net_pat_rev_medi_cal_managed_ip: 27594359
net_pat_rev_county_indigent_traditional_ip: 0
net_pat_rev_county_indigent_managed_ip: 0
net_pat_rev_third_party_traditional_ip: 2222000
net_pat_rev_third_party_managed_ip: 9002761
net_pat_rev_other_indigent_ip: 0
net_pat_rev_other_payer_ip: 402243
net_pat_rev_total_ip: 61267410
net_pat_rev_medicare_traditional_op: 7557172
net_pat_rev_medicare_managed_op: 6764144
net_pat_rev_medi_cal_traditional_op: 3447752
net_pat_rev_medi_cal_managed_op: 25664137
net_pat_rev_county_indigent_traditional_op: 0
net_pat_rev_county_indigent_managed_op: 0
net_pat_rev_third_party_traditional_op: 3158570
net_pat_rev_third_party_managed_op: 48457138
net_pat_rev_other_indigent_op: 0
net_pat_rev_other_payer_op: 611453
net_pat_rev_total_op: 95660366
payer_mix_medicare_traditional_ip: .262655205348
payer_mix_medicare_traditional_ip_state: .2319
payer_mix_medicare_managed_ip: .226997771410
payer_mix_medicare_managed_ip_state: .1787
payer_mix_medi_cal_traditional_ip: .060808659662
payer_mix_medi_cal_traditional_ip_state: .0995
payer_mix_medi_cal_managed_ip: .283667621776
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: .025787965616
payer_mix_third_party_traditional_ip_state: .0365
payer_mix_third_party_managed_ip: .127347978350
payer_mix_third_party_managed_ip_state: .1991
payer_mix_other_indigent_ip: .003820439350
payer_mix_other_indigent_ip_state: .0050
payer_mix_other_payer_ip: .008914358484
payer_mix_other_payer_ip_state: .0107
payer_mix_medicare_traditional_op: .231915873338
payer_mix_medicare_traditional_op_state: .2267
payer_mix_medicare_managed_op: .153421929044
payer_mix_medicare_managed_op_state: .0967
payer_mix_medi_cal_traditional_op: .015955794951
payer_mix_medi_cal_traditional_op_state: .0584
payer_mix_medi_cal_managed_op: .123566387886
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: .086418298833
payer_mix_third_party_traditional_op_state: .0490
payer_mix_third_party_managed_op: .373601190794
payer_mix_third_party_managed_op_state: .2667
payer_mix_other_indigent_op: .007174753434
payer_mix_other_indigent_op_state: .0074
payer_mix_other_payer_op: .007945771714
payer_mix_other_payer_op_state: .0182
avg_stay_medicare_traditional: 6.2570
avg_stay_medicare_managed: 5.1865
avg_stay_medi_cal_traditional: 19.7173
avg_stay_medi_cal_managed: 26.1459
avg_stay_county_indigent_traditional: .0000
avg_stay_county_indigent_managed: .0000
avg_stay_third_party_traditional: 14.4321
avg_stay_third_party_managed: 7.1400
avg_stay_other_indigent_total: 5.5000
avg_stay_other_payer_total: 5.5714
avg_stay_total: 12.7886
active_projects: 3
active_project_costs: 1337861
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: 206374321
facility_name: VILLA CORONADO (DP/SNF)
license_num: 090000036
facility_level_desc: Distinct Part Facility
dba_address1: 233 PROSPECT PLACE
dba_city: CORONADO
dba_zip_code: 92118
county_code: 37
county_name: San Diego
er_service_level_desc: None
total_number_beds: 122
facility_status_desc: Open
facility_status_date: 1991-03-01
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 32.69447220
longitude: -117.16732850
licensed_facility_listing_06 1 oshpd_id: 206374321
facility_name: VILLA CORONADO (DP/SNF)
license_num: 090000036
facility_level_desc: Distinct Part Facility
dba_address1: 233 PROSPECT PL
dba_city: CORONADO
dba_zip_code: 92118
county_code: 37
county_name: San Diego
er_service_level_desc: None
total_number_beds: 122
facility_status_desc: Open
facility_status_date: 1991-03-01
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 32.69444000
longitude: -117.16774000
licensed_facility_listing_07 1 oshpd_id: 206374321
facility_name: VILLA CORONADO (DP/SNF)
license_num: 090000036
facility_level_desc: Distinct Part Facility
dba_address1: 233 PROSPECT PL
dba_city: CORONADO
dba_zip_code: 92118
county_code: 37
county_name: San Diego
er_service_level_desc: None
total_number_beds: 122
facility_status_desc: Open
facility_status_date: 1991-03-01
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 32.69444000
longitude: -117.16774000
licensed_facility_listing_08 1 oshpd_id: 206374321
facility_name: VILLA CORONADO (DP/SNF)
license_num: 090000036
facility_level_desc: Distinct Part Facility
dba_address1: 233 PROSPECT PL
dba_city: CORONADO
dba_zip_code: 92118
county_code: 37
county_name: San Diego
er_service_level_desc: None
total_number_beds: 122
facility_status_desc: Open
facility_status_date: 1991-03-01
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 32.69444000
longitude: -117.16774000
licensed_facility_listing_09 1 oshpd_id: 206374321
facility_name: VILLA CORONADO (DP/SNF)
license_num: 090000036
facility_level_desc: Distinct Part Facility
dba_address1: 233 PROSPECT PL
dba_city: CORONADO
dba_zip_code: 92118
county_code: 37
county_name: San Diego
er_service_level_desc: None
total_number_beds: 122
facility_status_desc: Open
facility_status_date: 1991-03-01
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 32.69447220
longitude: -117.16732850
licensed_facility_listing_10 1 oshpd_id: 206374321
facility_name: VILLA CORONADO (DP/SNF)
license_num: 090000036
facility_level_desc: Distinct Part Facility
dba_address1: 233 PROSPECT PLACE
dba_city: CORONADO
dba_zip_code: 92118
county_code: 37
county_name: San Diego
er_service_level_desc: None
total_number_beds: 122
facility_status_desc: Open
facility_status_date: 1991-03-01
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 32.69447220
longitude: -117.16732850
licensed_facility_listing_12 1 oshpd_id: 206374321
facility_name: VILLA CORONADO CONVALESCENT (DP/SNF)
license_num: 090000036
facility_level_desc: Distinct Part Facility
dba_address1: 233 PROSPECT PLACE
dba_city: CORONADO
dba_zip_code: 92118
county_code: 37
county_name: SAN DIEGO
er_service_level_desc: None
total_number_beds: 122
facility_status_desc: Open
facility_status_date: 1991-03-01
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 32.69444000
longitude: -117.16774000
licensed_facility_listing_13 1 oshpd_id: 206374321
facility_name: VILLA CORONADO CONVALESCENT (DP/SNF)
license_num: 090000036
facility_level_desc: Distinct Part Facility
dba_address1: 233 PROSPECT PLACE
dba_city: CORONADO
dba_zip_code: 92118
county_code: 37
county_name: SAN DIEGO
er_service_level_desc: None
total_number_beds: 122
facility_status_desc: Open
facility_status_date: 1991-03-01
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 32.69444000
longitude: -117.16774000
licensed_facility_listing_14 1 oshpd_id: 206374321
facility_name: VILLA CORONADO (DP/SNF)
license_num: 090000036
facility_level_desc: Distinct Part Facility
dba_address1: 233 PROSPECT PL
dba_city: CORONADO
dba_zip_code: 92118
county_code: 37
county_name: San Diego
er_service_level_desc: None
total_number_beds: 122
facility_status_desc: Open
facility_status_date: 1991-03-01
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 32.69444000
longitude: -117.16774000
licensed_facility_listing_15 1 oshpd_id: 206374321
facility_name: VILLA CORONADO (DP/SNF)
license_num: 090000036
facility_level_desc: Distinct Part Facility
dba_address1: 233 PROSPECT PL
dba_city: CORONADO
dba_zip_code: 92118
county_code: 37
county_name: San Diego
er_service_level_desc: None
total_number_beds: 122
facility_status_desc: Open
facility_status_date: 1991-03-01
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 32.69444000
longitude: -117.16774000
licensed_facility_listing_16 1 oshpd_id: 206374321
facility_name: VILLA CORONADO (DP/SNF)
license_num: 090000036
facility_level_desc: Distinct Part Facility
dba_address1: 233 PROSPECT PL
dba_city: CORONADO
dba_zip_code: 92118
county_code: 37
county_name: San Diego
er_service_level_desc: None
total_number_beds: 122
facility_status_desc: Open
facility_status_date: 1991-03-01
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 32.69444000
longitude: -117.16774000
licensed_facility_listing_17 1 oshpd_id: 206374321
facility_name: VILLA CORONADO (DP/SNF)
license_num: 090000036
facility_level_desc: Distinct Part Facility
dba_address1: 233 PROSPECT PL
dba_city: CORONADO
dba_zip_code: 92118
county_code: 37
county_name: San Diego
er_service_level_desc: None
total_number_beds: 122
facility_status_desc: Open
facility_status_date: 1991-03-01
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 32.69444000
longitude: -117.16774000
licensed_facility_listing_18 1 oshpd_id: 206374321
facility_name: VILLA CORONADO (DP/SNF)
license_num: 090000036
facility_level_desc: Distinct Part Facility
dba_address1: 233 PROSPECT PLACE
dba_city: CORONADO
dba_zip_code: 92118
county_code: 37
county_name: San Diego
er_service_level_desc: None
total_number_beds: 122
facility_status_desc: Open
facility_status_date: 1991-03-01
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 0.00000000
longitude: 0.00000000
licensed_healthcare_facility_listing 10 period: current
oshpd_id: 206374321
facility_name: VILLA CORONADO (DP/SNF)
license_num: 090000036
facility_level_desc: Distinct Part Facility
dba_address1: 233 PROSPECT PLACE
dba_city: CORONADO
dba_zip_code: 92118
county_code: 37
county_name: San Diego
er_service_level_desc: None
total_number_beds: 122
facility_status_desc: Open
facility_status_date: 1991-03-01
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 32.69447220
longitude: -117.16732850
period: 2020-12-31
oshpd_id: 206374321
facility_name: VILLA CORONADO (DP/SNF)
license_num: 090000036
facility_level_desc: Distinct Part Facility
dba_address1: 233 PROSPECT PL
dba_city: CORONADO
dba_zip_code: 92118
county_code: 37
county_name: San Diego
er_service_level_desc: None
total_number_beds: 122
facility_status_desc: Open
facility_status_date: 1991-03-01
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 32.69444000
longitude: -117.16774000
period: 2021-12-31
oshpd_id: 206374321
facility_name: VILLA CORONADO (DP/SNF)
license_num: 090000036
facility_level_desc: Distinct Part Facility
dba_address1: 233 PROSPECT PL
dba_city: CORONADO
dba_zip_code: 92118
county_code: 37
county_name: San Diego
er_service_level_desc: None
total_number_beds: 122
facility_status_desc: Open
facility_status_date: 1991-03-01
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 32.69444000
longitude: -117.16774000
period: 2022-12-31
oshpd_id: 206374321
facility_name: VILLA CORONADO (DP/SNF)
license_num: 090000036
facility_level_desc: Distinct Part Facility
dba_address1: 233 PROSPECT PL
dba_city: CORONADO
dba_zip_code: 92118
county_code: 37
county_name: San Diego
er_service_level_desc: None
total_number_beds: 122
facility_status_desc: Open
facility_status_date: 1991-03-01
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 32.69444000
longitude: -117.16774000
period: 2018-06-30
oshpd_id: 206374321
facility_name: VILLA CORONADO CONVALESCENT (DP/SNF)
license_num: 090000036
facility_level_desc: Distinct Part Facility
dba_address1: 233 PROSPECT PLACE
dba_city: CORONADO
dba_zip_code: 92118
county_code: 37
county_name: SAN DIEGO
er_service_level_desc: None
total_number_beds: 122
facility_status_desc: Open
facility_status_date: 1991-03-01
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 32.69444000
longitude: -117.16774000
period: 2019-06-30
oshpd_id: 206374321
facility_name: VILLA CORONADO CONVALESCENT (DP/SNF)
license_num: 090000036
facility_level_desc: Distinct Part Facility
dba_address1: 233 PROSPECT PLACE
dba_city: CORONADO
dba_zip_code: 92118
county_code: 37
county_name: SAN DIEGO
er_service_level_desc: None
total_number_beds: 122
facility_status_desc: Open
facility_status_date: 1991-03-01
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 32.69444000
longitude: -117.16774000
period: 2020-06-30
oshpd_id: 206374321
facility_name: VILLA CORONADO (DP/SNF)
license_num: 090000036
facility_level_desc: Distinct Part Facility
dba_address1: 233 PROSPECT PL
dba_city: CORONADO
dba_zip_code: 92118
county_code: 37
county_name: San Diego
er_service_level_desc: None
total_number_beds: 122
facility_status_desc: Open
facility_status_date: 1991-03-01
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 32.69444000
longitude: -117.16774000
period: 2021-06-30
oshpd_id: 206374321
facility_name: VILLA CORONADO (DP/SNF)
license_num: 090000036
facility_level_desc: Distinct Part Facility
dba_address1: 233 PROSPECT PL
dba_city: CORONADO
dba_zip_code: 92118
county_code: 37
county_name: San Diego
er_service_level_desc: None
total_number_beds: 122
facility_status_desc: Open
facility_status_date: 1991-03-01
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 32.69444000
longitude: -117.16774000
period: 2022-06-30
oshpd_id: 206374321
facility_name: VILLA CORONADO (DP/SNF)
license_num: 090000036
facility_level_desc: Distinct Part Facility
dba_address1: 233 PROSPECT PL
dba_city: CORONADO
dba_zip_code: 92118
county_code: 37
county_name: San Diego
er_service_level_desc: None
total_number_beds: 122
facility_status_desc: Open
facility_status_date: 1991-03-01
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 32.69444000
longitude: -117.16774000
period: 2023-06-30
oshpd_id: 206374321
facility_name: VILLA CORONADO (DP/SNF)
license_num: 090000036
facility_level_desc: Distinct Part Facility
dba_address1: 233 PROSPECT PL
dba_city: CORONADO
dba_zip_code: 92118
county_code: 37
county_name: San Diego
er_service_level_desc: None
total_number_beds: 122
facility_status_desc: Open
facility_status_date: 1991-03-01
license_type_desc: Hospital
license_category_desc: General Acute Care Hospital
latitude: 32.69444000
longitude: -117.16774000