| Name |
hospital-supplier-diversity-reports |
|---|
| Updated |
2025-04-09 |
|---|
| Current |
True |
|---|
| Tables |
| 2021_hospital_supplier_diversity_individual_report_extract | |
hospital_name - varchar(79)
hospital_address - varchar(59)
hcai_id - varchar(9)
license_number - varchar(14)
licensee - varchar(60)
type_control - varchar(45)
county - varchar(15)
mssa - varchar(5)
hsa - varchar(26)
hfpa - varchar(4)
reporting_organization - varchar(95)
report_start_date - varchar(17)
report_end_date - varchar(15)
supplier_diversity_statement - text
encourage_suppliers - text
encourage_employees - text
conduct_outreach_comm - text
certification_support - text
require_certification - varchar(21)
self_certification - varchar(18)
tier_i_african_american - varchar(23)
tier_ii_african_american - varchar(24)
total_african_american - varchar(22)
tier_i_hispanic_american - varchar(24)
tier_ii_hispanic_american - varchar(25)
total_hispanic_american - varchar(23)
tier_i_native_american - varchar(22)
tier_ii_native_american - varchar(23)
total_native_american - varchar(21)
tier_i_asian_pacific_american - varchar(29)
tier_ii_asian_pacific_american - varchar(30)
total_asian_pacific_american - varchar(28)
tier_i_unknown_minority - varchar(23)
tier_ii_unknown_minority - varchar(24)
total_unknown_minority - varchar(22)
total_tier_i_minority - varchar(21)
total_tier_ii_minority - varchar(22)
total_minority - varchar(14)
tier_i_women - varchar(12)
tier_ii_women - varchar(13)
total_women - varchar(11)
tier_i_lgbt - varchar(11)
tier_ii_lgbt - varchar(12)
total_lgbt - varchar(10)
tier_i_disabled_veteran - varchar(23)
tier_ii_disabled_veteran - varchar(24)
total_disabled_veteran - varchar(22)
tier_i_less_duplicated_amount - varchar(29)
tier_ii_less_duplicated_amount - varchar(30)
total_less_duplicated_amount - varchar(28)
combined_tier_i_total - varchar(21)
combined_tier_ii_total - varchar(22)
combined_total - varchar(14)
total_hospital_procurement - varchar(26)
contact_name - varchar(51)
contact_email - varchar(51)
contact_phone_number - varchar(20)
website_link - varchar(111)
third_party - varchar(11)
third_party_name - varchar(58)
third_party_website - varchar(137)
other_relevant_info - text
|
| 2021_hospital_supplier_diversity_regional_report_extract | |
system_reporting_organization - varchar(31)
system_description - varchar(886)
system_report_start_date - varchar(24)
system_report_end_date - varchar(22)
associated_hospitals - varchar(189)
system_require_certification - varchar(28)
system_self_certification - varchar(25)
system_tier_i_african_american - varchar(30)
system_tier_ii_african_american - varchar(31)
system_total_african_american - varchar(29)
system_tier_i_hispanic_american - varchar(31)
system_tier_ii_hispanic_american - varchar(32)
system_total_hispanic_american - varchar(30)
system_tier_i_native_american - varchar(29)
system_tier_ii_native_american - varchar(30)
system_total_native_american - varchar(28)
system_tier_i_asian_pacific_american - varchar(36)
system_tier_ii_asian_pacific_american - varchar(37)
system_total_asian_pacific_american - varchar(35)
system_tier_i_unknown_minority - varchar(30)
system_tier_ii_unknown_minority - varchar(31)
system_total_unknown_minority - varchar(29)
system_total_tier_i_minority - varchar(28)
system_total_tier_ii_minority - varchar(29)
system_total_minority - varchar(21)
system_tier_i_women - varchar(19)
system_tier_ii_women - varchar(20)
system_total_women - varchar(18)
system_tier_i_lgbt - varchar(18)
system_tier_ii_lgbt - varchar(19)
system_total_lgbt - varchar(17)
system_tier_i_disabled_veteran - varchar(30)
system_tier_ii_disabled_veteran - varchar(31)
system_total_disabled_veteran - varchar(29)
system_tier_i_less_duplicated_amount - varchar(36)
system_tier_ii_less_duplicated_amount - varchar(37)
system_total_less_duplicated_amount - varchar(35)
system_combined_tier_i_total - varchar(28)
system_combined_tier_ii_total - varchar(29)
system_combined_total - varchar(21)
system_total_hospital_procurement - varchar(33)
system_other_relevant_info - varchar(2277)
|
|
|---|
| Sources |
2020-hospital-supplier-diversity-reports/2020_Hospital_Supplier_Diversity_Reports/Hospital --> None
2020-hospital-supplier-diversity-reports/2020_Hospital_Supplier_Diversity_Reports/Individual --> None
2021-hospital-supplier-diversity-report-document.pdf --> None
2021-supplier-diversity-individual-reports/Supplier --> None
2021-system-regional-reports/System --> None
2022-hospital-supplier-diversity-individual-report-extract/Supplier --> None
2022-hospital-supplier-diversity-regional-report-extract/System --> None
2022-hospital-supplier-diversity-report-document.pdf --> None
2022-supplier-diversity-individual-reports/Supplier --> None
2022-system-regional-reports/System --> None
2022-hospital-supplier-diversity-individual-report-extract --> None
2020-hospital-supplier-diversity-reports --> None
2022-hospital-supplier-diversity-regional-report-extract --> None
2021-supplier-diversity-individual-reports --> None
2021-system-regional-reports --> None
2022-system-regional-reports --> None
2022-supplier-diversity-individual-reports --> None
2020-hospital-supplier-diversity-reports.zip --> None
2022-supplier-diversity-individual-reports.zip --> None
2021-supplier-diversity-individual-reports.zip --> None
2022-system-regional-reports.zip --> None
2022-hospital-supplier-diversity-regional-report-extract.zip --> None
2022-hospital-supplier-diversity-individual-report-extract.zip --> None
2021-system-regional-reports.zip --> None
2021-hospital-supplier-diversity-individual-report-extract.csv --> 2021_hospital_supplier_diversity_individual_report_extract
2021-hospital-supplier-diversity-regional-report-extract.csv --> 2021_hospital_supplier_diversity_regional_report_extract
|
|---|
| Updates |
| 2025-04-11 11:27:23 |
|
0 |
| 2025-02-14 11:02:24 |
|
0 |
| 2025-02-02 18:13:00 |
|
0 |
| 2025-01-17 22:16:23 |
|
0 |
| 2025-01-17 22:16:23 |
|
0 |
| 2024-12-24 15:27:24 |
|
0 |
| 2024-12-24 15:27:23 |
|
0 |
| 2024-12-24 15:25:57 |
|
0 |
| 2024-12-24 15:25:57 |
|
0 |
| 2024-12-24 15:24:32 |
|
0 |
| 2024-12-24 15:24:31 |
|
0 |
| 2024-12-24 15:23:02 |
|
1 |
| 2024-12-24 15:23:02 |
|
0 |
| 2024-12-24 15:21:03 |
|
0 |
| 2024-12-24 15:20:21 |
|
0 |
| 2024-12-24 15:18:39 |
|
0 |
| 2024-12-24 15:12:09 |
|
0 |
| 2024-12-24 15:12:02 |
|
1 |
| 2024-12-24 15:10:20 |
|
0 |
| 2024-12-24 15:09:05 |
|
0 |
| 2024-12-24 15:09:00 |
|
1 |
| 2024-12-24 15:07:59 |
|
0 |
| 2024-12-24 15:07:45 |
|
0 |
| 2024-12-24 15:07:39 |
|
1 |
| 2024-12-24 15:06:48 |
|
0 |
| 2024-12-24 15:06:33 |
|
1 |
| 2024-12-24 14:59:25 |
|
1 |
| 2024-12-20 19:30:46 |
|
1 |
| 2024-12-20 19:22:17 |
|
1 |
| 2024-12-20 18:53:46 |
|
1 |
| 2024-12-20 10:20:56 |
|
1 |
| 2024-12-14 15:49:13 |
|
1 |
| 2024-12-04 16:29:00 |
|
None |
| 2024-09-18 13:07:36 |
|
None |
|
|---|