| Name |
facility-profile-attributes |
|---|
| Updated |
2025-07-28 |
|---|
| CA Dataset |
link |
|---|
| Current |
False |
|---|
| Tables |
| facility_profile_attributes |
|
facility_desc - varchar(79)
site_address1 - varchar(42)
site_address2 - varchar(50)
site_city - varchar(23)
site_zip - varchar(10)
site_x_coordinate - varchar(17)
site_y_coordinate - varchar(17)
oshpd_id - varchar(9)
license_type_desc - varchar(26)
license_category_desc - varchar(33)
license_number - varchar(14)
facility_level_desc - varchar(22)
er_service_level_desc - varchar(21)
licensed_beds - varchar(13)
facility_status_desc - varchar(20)
financial_facility_count - varchar(24)
consolidated_facility_desc_pipe - varchar(158)
consolidated_facility_desc_comma - varchar(161)
period_begin_date - varchar(17)
period_end_date - varchar(15)
net_pat_rev_medicare_traditional_ip - varchar(35)
net_pat_rev_medicare_managed_ip - varchar(31)
net_pat_rev_medi_cal_traditional_ip - varchar(35)
net_pat_rev_medi_cal_managed_ip - varchar(31)
net_pat_rev_county_indigent_traditional_ip - varchar(42)
net_pat_rev_county_indigent_managed_ip - varchar(38)
net_pat_rev_third_party_traditional_ip - varchar(38)
net_pat_rev_third_party_managed_ip - varchar(34)
net_pat_rev_other_indigent_ip - varchar(29)
net_pat_rev_other_payer_ip - varchar(26)
net_pat_rev_total_ip - varchar(20)
net_pat_rev_medicare_traditional_op - varchar(35)
net_pat_rev_medicare_managed_op - varchar(31)
net_pat_rev_medi_cal_traditional_op - varchar(35)
net_pat_rev_medi_cal_managed_op - varchar(31)
net_pat_rev_county_indigent_traditional_op - varchar(42)
net_pat_rev_county_indigent_managed_op - varchar(38)
net_pat_rev_third_party_traditional_op - varchar(38)
net_pat_rev_third_party_managed_op - varchar(34)
net_pat_rev_other_indigent_op - varchar(29)
net_pat_rev_other_payer_op - varchar(26)
net_pat_rev_total_op - varchar(20)
payer_mix_medicare_traditional_ip - varchar(33)
payer_mix_medicare_traditional_ip_state - varchar(39)
payer_mix_medicare_managed_ip - varchar(29)
payer_mix_medicare_managed_ip_state - varchar(35)
payer_mix_medi_cal_traditional_ip - varchar(33)
payer_mix_medi_cal_traditional_ip_state - varchar(39)
payer_mix_medi_cal_managed_ip - varchar(29)
payer_mix_medi_cal_managed_ip_state - varchar(35)
payer_mix_county_indigent_traditional_ip - varchar(40)
payer_mix_county_indigent_traditional_ip_state - varchar(46)
payer_mix_county_indigent_managed_ip - varchar(36)
payer_mix_county_indigent_managed_ip_state - varchar(42)
payer_mix_third_party_traditional_ip - varchar(36)
payer_mix_third_party_traditional_ip_state - varchar(42)
payer_mix_third_party_managed_ip - varchar(32)
payer_mix_third_party_managed_ip_state - varchar(38)
payer_mix_other_indigent_ip - varchar(27)
payer_mix_other_indigent_ip_state - varchar(33)
payer_mix_other_payer_ip - varchar(24)
payer_mix_other_payer_ip_state - varchar(30)
payer_mix_medicare_traditional_op - varchar(33)
payer_mix_medicare_traditional_op_state - varchar(39)
payer_mix_medicare_managed_op - varchar(29)
payer_mix_medicare_managed_op_state - varchar(35)
payer_mix_medi_cal_traditional_op - varchar(33)
payer_mix_medi_cal_traditional_op_state - varchar(39)
payer_mix_medi_cal_managed_op - varchar(29)
payer_mix_medi_cal_managed_op_state - varchar(35)
payer_mix_county_indigent_traditional_op - varchar(40)
payer_mix_county_indigent_traditional_op_state - varchar(46)
payer_mix_county_indigent_managed_op - varchar(36)
payer_mix_county_indigent_managed_op_state - varchar(42)
payer_mix_third_party_traditional_op - varchar(36)
payer_mix_third_party_traditional_op_state - varchar(42)
payer_mix_third_party_managed_op - varchar(32)
payer_mix_third_party_managed_op_state - varchar(38)
payer_mix_other_indigent_op - varchar(27)
payer_mix_other_indigent_op_state - varchar(33)
payer_mix_other_payer_op - varchar(24)
payer_mix_other_payer_op_state - varchar(30)
avg_stay_medicare_traditional - varchar(29)
avg_stay_medicare_managed - varchar(25)
avg_stay_medi_cal_traditional - varchar(29)
avg_stay_medi_cal_managed - varchar(25)
avg_stay_county_indigent_traditional - varchar(36)
avg_stay_county_indigent_managed - varchar(32)
avg_stay_third_party_traditional - varchar(32)
avg_stay_third_party_managed - varchar(28)
avg_stay_other_indigent_total - varchar(29)
avg_stay_other_payer_total - varchar(26)
avg_stay_total - varchar(14)
active_projects - varchar(15)
active_project_costs - varchar(20)
active_projects_state - varchar(21)
active_project_costs_state - varchar(26)
spc_1 - varchar(5)
spc_2 - varchar(5)
spc_3 - varchar(5)
spc_4 - varchar(5)
spc_5 - varchar(5)
spc_1_state - varchar(11)
spc_2_state - varchar(11)
spc_3_state - varchar(11)
spc_4_state - varchar(11)
spc_5_state - varchar(11)
sysdate - varchar(7)
|
|
|---|
| Sources |
| datapackage.json | - | None |
| facility-profile-attributes.csv | - | facility_profile_attributes |
|
|---|
| Updates |
| 2025-07-11 17:44:22 |
|
None |
| 2025-07-04 16:28:28 |
|
0 |
| 2025-06-25 12:53:28 |
|
0 |
| 2025-06-09 12:11:53 |
|
0 |
| 2025-06-06 11:37:02 |
|
0 |
| 2025-03-18 12:19:50 |
|
0 |
| 2025-03-10 09:55:47 |
|
0 |
| 2025-03-03 10:01:02 |
|
0 |
| 2025-02-25 09:07:54 |
|
0 |
| 2025-02-19 11:14:15 |
|
0 |
| 2025-02-10 10:46:59 |
|
0 |
| 2025-02-03 09:55:22 |
|
0 |
| 2025-02-02 17:54:02 |
|
0 |
| 2025-01-31 16:04:34 |
|
0 |
| 2025-01-29 11:11:52 |
|
0 |
| 2025-01-23 20:00:42 |
|
0 |
| 2025-01-17 22:15:41 |
|
0 |
| 2025-01-14 12:00:20 |
|
0 |
| 2025-01-10 11:15:06 |
|
0 |
| 2025-01-03 14:47:23 |
|
0 |
| 2025-01-01 14:59:23 |
|
0 |
| 2024-12-28 23:13:28 |
|
0 |
| 2024-12-27 18:34:32 |
|
0 |
| 2024-12-24 16:35:56 |
|
0 |
| 2024-11-15 14:20:57 |
|
None |
| 2024-11-15 14:15:54 |
|
None |
| 2024-11-15 14:07:15 |
|
None |
| 2024-09-18 12:57:13 |
|
None |
| 2024-09-09 15:46:19 |
|
None |
| 2024-09-09 13:35:03 |
|
None |
|
|---|