[IMPORTANT NOTE: Sample file posted on Datarade is not the complete dataset, as Datarade permits only a single CSV file. Visit https://www.careprecise.com/healthcare-provider-data-sample.htm for more complete samples.] Updated every month, CarePrecise developed the AHD to provide a comprehensive database of U.S. hospital information. Extracted from the CarePrecise master provider database with information all of the 6.3 million HIPAA-covered US healthcare providers and additional sources, the Authoritative Hospital Database (AHD) contains records for all HIPAA-covered hospitals. In this database of hospitals we include bed counts, patient satisfaction data, hospital system ownership, hospital charges and cases by Zip Code®, and more. Most records include a cabinet-level or director-level contact. A PlaceKey is provided where available.
The AHD includes bed counts for 95% of hospitals, full contact information on 85%, and fax numbers for 62%. We include detailed patient satisfaction data, employee counts, and medical procedure volumes.
The AHD integrates directly with our extended provider data product to bring you the physicians and practice groups affiliated with the hospitals. This combination of data is the only commercially available hospital dataset of this depth.
NEW: Hospital NPI to CCN Rollup A CarePrecise Exclusive. Using advanced record-linkage technology, the AHD now includes a new file that makes it possible to mine the vast hospital information available in the National Provider Identifier registry database. Hospitals may have dozens of NPI records, each with its own information about a unit, listing facility type and/or medical specialties practiced, as well as separate contact names. To wield the power of this new feature, you'll need the CarePrecise Master Bundle, which contains all of the publicly available NPI registry data. These data are available in other CarePrecise data products.
Counts are approximate due to ongoing updates. Please review the current AHD information here: https://www.careprecise.com/detail_authoritative_hospital_database.htm
The AHD is sold as-is and no warranty is offered regarding accuracy, timeliness, completeness, or fitness for any purpose.
NOTE: This dataset is historical-only as of 5/10/2023. All data currently in the dataset will remain, but new data will not be added. The recommended alternative dataset for similar data beyond that date is https://healthdata.gov/Hospital/COVID-19-Reported-Patient-Impact-and-Hospital-Capa/anag-cw7u. (This is not a City of Chicago site. Please direct any questions or comments through the contact information on the site.)
During the COVID-19 pandemic, the Chicago Department of Public Health (CDPH) required EMS Region XI (Chicago area) hospitals to report hospital capacity and patient impact metrics related to COVID-19 to CDPH through the statewide EMResource system. This requirement has been lifted as of May 9, 2023, in alignment with the expiration of the national and statewide COVID-19 public health emergency declarations on May 11, 2023. However, all hospitals will still be required by the U.S. Department of Health and Human Services (HHS) to report COVID-19 hospital capacity and utilization metrics into the HHS Protect system through the CDC’s National Healthcare Safety Network until April 30, 2024. Facility-level data from the HHS Protect system can be found at healthdata.gov.
Until May 9, 2023, all Chicago (EMS Region XI) hospitals (n=28) were required to report bed and ventilator capacity, availability, and occupancy to the Chicago Department of Public Health (CDPH) daily. A list of reporting hospitals is included below. All data represent hospital status as of 11:59 pm for that calendar day. Counts include Chicago residents and non-residents.
ICU bed counts include both adult and pediatric ICU beds. Neonatal ICU beds are not included. Capacity refers to all staffed adult and pediatric ICU beds. Availability refers to all available/vacant adult and pediatric ICU beds. Hospitals began reporting COVID-19 confirmed and suspected (PUI) cases in ICU on 03/19/2020. Hospitals began reporting ICU surge capacity as part of total capacity on 5/18/2020.
Acute non-ICU bed counts include burn unit, emergency department, medical/surgery (ward), other, pediatrics (pediatric ward) and psychiatry beds. Burn beds include those approved by the American Burn Association or self-designated. Capacity refers to all staffed acute non-ICU beds. An additional 500 acute/non-ICU beds were added at the McCormick Place Treatment Facility on 4/15/2020. These beds are not included in the total capacity count. The McCormick Place Treatment Facility closed on 05/08/2020. Availability refers to all available/vacant acute non-ICU beds. Hospitals began reporting COVID-19 confirmed and suspected (PUI) cases in acute non-ICU beds on 04/03/2020.
Ventilator counts prior to 04/24/2020 include all full-functioning mechanical ventilators, with ventilators with bilevel positive airway pressure (BiPAP), anesthesia machines, and portable/transport ventilators counted as surge. Beginning 04/24/2020, ventilator counts include all full-functioning mechanical ventilators, BiPAP, anesthesia machines and portable/transport ventilators. Ventilators are counted regardless of ability to staff. Hospitals began reporting COVID-19 confirmed and suspected (PUI) cases on ventilators on 03/19/2020. CDPH has access to additional ventilators from the EAMC (Emergency Asset Management Center) cache. These ventilators are included in the total capacity count.
Chicago (EMS Region 11) hospitals: Advocate Illinois Masonic Medical Center, Advocate Trinity Hospital, AMITA Resurrection Medical Center Chicago, AMITA Saint Joseph Hospital Chicago, AMITA Saints Mary & Elizabeth Medical Center, Ann & Robert H Lurie Children's Hospital, Comer Children's Hospital, Community First Medical Center, Holy Cross Hospital, Jackson Park Hospital & Medical Center, John H. Stroger Jr. Hospital of Cook County, Loretto Hospital, Mercy Hospital and Medical Center, , Mount Sinai Hospital, Northwestern Memorial Hospital, Norwegian American Hospital, Roseland Community Hospital, Rush University M
Note: This dataset is no longer updated as of 7/28/2023.
This dataset includes information at the report date level by individual facilities on the total number of staff, how many staff are partially vaccinated, and how many are fully vaccinated. This information is only collected once a week from hospitals. The title of this dataset was initially the Hospital Electronic Response Data System (HERDS) Hospital Survey: Hospital Staff COVID-19 Vaccinations. The dataset was changed to its current title on 11/4/2021.
DREES has built long series on the number of employees in the hospital sector since 2003. They are updated each year, mobilising the administrative sources of social data: SIASP file for the public sector and INSEE dissemination file, based on DADS and registered social declarations (DSN). Some CAS data is used to complete the field. Field Number of employees, in natural persons, paid at 31 December by hospitals in metropolitan France and in the DROMs (including Mayotte, excluding Saint-Martin, Saint-Barthélemy), including the Armed Forces Health Service (SSA). The private hospital sector includes private non-profit institutions (including Espic) and for-profit institutions (private clinics). The concept of establishment used here corresponds to that of the Sirene directory (an establishment is identified by its Siret number). An establishment belongs to the hospital sector if its main activity code (APE) is that of ‘hospital activities’ (coded 8610Z in Naf rev. 2). This field encompasses the field of health facilities within the meaning of the Annual Statistics of Health Facilities (ASH), but is somewhat broader because of the mesh used which is the Siret. It can therefore sometimes include, in addition to the Fines of health establishments, some Fines of non-health establishments: Medico-social establishments or training centres for health and medico-social professions, for example. Source The annual social data declaration (DADS) is a declarative formality that must be carried out by any company employing employees. In this document common to the tax and social administrations, employers provide a certain amount of information on the establishment and the employees (the nature of the job and the qualification, the amount of remuneration paid, etc.) on an annual basis and for each establishment. It is necessary to distinguish the DADS, as a reporting formality, from the statistical file known as the ‘large format DADS’ (DADS-GF) produced by INSEE, which is used to estimate the number of employees in the private hospital sector up to 2016. From 2017, and to take account of the gradual disappearance of DADS in the private sector, the number of employees in the private hospital sector is estimated using a dissemination file, produced by INSEE from DADS and registered social declarations (DSN). In addition, the Public Sector Employee Information System (SIASP) file exploits the information contained in the DADS on the scope of the civil service. It incorporates concepts and variables characteristic of the public sector, linked in particular to the status of the agent (grade, grade, index, etc.). This SIASP file is used to estimate the number of employees in the public hospital sector. Finally, SAE data are used to estimate the number of hospital employees in Mayotte and the SSA, but also to share the number of in-house staff and FFI staff, collected in full in SIASP, between the public and private sectors.
https://www.usa.gov/government-workshttps://www.usa.gov/government-works
After May 3, 2024, this dataset and webpage will no longer be updated because hospitals are no longer required to report data on COVID-19 hospital admissions, and hospital capacity and occupancy data, to HHS through CDC’s National Healthcare Safety Network. Data voluntarily reported to NHSN after May 1, 2024, will be available starting May 10, 2024, at COVID Data Tracker Hospitalizations.
The following dataset provides facility-level data for hospital utilization aggregated on a weekly basis (Sunday to Saturday). These are derived from reports with facility-level granularity across two main sources: (1) HHS TeleTracking, and (2) reporting provided directly to HHS Protect by state/territorial health departments on behalf of their healthcare facilities.
The hospital population includes all hospitals registered with Centers for Medicare & Medicaid Services (CMS) as of June 1, 2020. It includes non-CMS hospitals that have reported since July 15, 2020. It does not include psychiatric, rehabilitation, Indian Health Service (IHS) facilities, U.S. Department of Veterans Affairs (VA) facilities, Defense Health Agency (DHA) facilities, and religious non-medical facilities.
For a given entry, the term “collection_week” signifies the start of the period that is aggregated. For example, a “collection_week” of 2020-11-15 means the average/sum/coverage of the elements captured from that given facility starting and including Sunday, November 15, 2020, and ending and including reports for Saturday, November 21, 2020.
Reported elements include an append of either “_coverage”, “_sum”, or “_avg”.
The file will be updated weekly. No statistical analysis is applied to impute non-response. For averages, calculations are based on the number of values collected for a given hospital in that collection week. Suppression is applied to the file for sums and averages less than four (4). In these cases, the field will be replaced with “-999,999”.
A story page was created to display both corrected and raw datasets and can be accessed at this link: https://healthdata.gov/stories/s/nhgk-5gpv
This data is preliminary and subject to change as more data become available. Data is available starting on July 31, 2020.
Sometimes, reports for a given facility will be provided to both HHS TeleTracking and HHS Protect. When this occurs, to ensure that there are not duplicate reports, deduplication is applied according to prioritization rules within HHS Protect.
For influenza fields listed in the file, the current HHS guidance marks these fields as optional. As a result, coverage of these elements are varied.
For recent updates to the dataset, scroll to the bottom of the dataset description.
On May 3, 2021, the following fields have been added to this data set.
On May 8, 2021, this data set is the originally reported numbers by the facility. This data set may contain data anomalies due to data key entries.
On May 13, 2021 Changed vaccination fields from sum to max or min fields. This reflects the maximum or minimum number reported for that metric in a given week.
On June 7, 2021 Changed vaccination fields from max or min fields to Wednesday reported only. This reflects that the number reported for that metric is only reported on Wednesdays in a given week.
On January 19, 2022, the following fields have been added to this dataset:
On April 28, 2022, the following pediatric fields have been added to this dataset:
Due to changes in reporting requirements, after June 19, 2023, a collection week is defined as starting on a Sunday and ending on the next Saturday.
Attribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
DSH COVID-19 Staff Data reports on DSH staff and non-DSH personnel positives at the facility level for DSH. The table reports on the following data fields:
Total staff positive for COVID-19 confirmed by Public Health or medical facility since 3/20/2020
Staff newly positive for COVID-19 in the last 14 days
Non-DSH personnel positive for COVID-19 confirmed by Public Health or medical facility since 5/26/2020
Non-DSH personnel newly positive for COVID-19 in the last 14 days
Data has been de-identified in accordance with CalHHS Data De-Identification Guidelines. Counts between 1-10 are masked with "<11". Other includes non-DSH personnel who perform work at DSH facilities and personnel working at sites located on DSH facilities that are operated by other organizations. Metro-Norwalk is additional COVID-19 surge space and technically a branch location that is part of DSH Metropolitan Hospital.
The data-set contains the university staff, i.e. employees of the University, who serve on 31 December of the reference year in each ASL, Hospital, University Hospital and public IRCCS also established in foundation. The information contained in the data-set is processed with reference to the data that the companies send to the Ministry of Economy and Finance, using the T1B form of the “Annual Account” survey provided for in Title V of Legislative Decree No 165/2001. For each ASL, Azienda Ospedaliera e Azienda Ospedaliera Universitaria and IRCCS pubblico also established as a foundation and by role (Health, Technical, Professional and Administrative), as from 2010, the data relating to the allocation of separate staff on an open-ended, fixed-term, full-time, part-time and gender basis and the ‘of which’ relating to medical and nursing staff are shown in separate rows. For information on the dataset, please refer to the dictionary:http://www.dati.salute.gov.it/dati/documenti/T1B_Dataset_Personale_Universitario_per_Azienda.pdf.
https://www.pioneerdatahub.co.uk/data/data-request-process/https://www.pioneerdatahub.co.uk/data/data-request-process/
OMOP dataset: Hospital COVID patients: severity, acuity, therapies, outcomes Dataset number 2.0
Coronavirus disease 2019 (COVID-19) was identified in January 2020. Currently, there have been more than 6 million cases & more than 1.5 million deaths worldwide. Some individuals experience severe manifestations of infection, including viral pneumonia, adult respiratory distress syndrome (ARDS) & death. There is a pressing need for tools to stratify patients, to identify those at greatest risk. Acuity scores are composite scores which help identify patients who are more unwell to support & prioritise clinical care. There are no validated acuity scores for COVID-19 & it is unclear whether standard tools are accurate enough to provide this support. This secondary care COVID OMOP dataset contains granular demographic, morbidity, serial acuity and outcome data to inform risk prediction tools in COVID-19.
PIONEER geography The West Midlands (WM) has a population of 5.9 million & includes a diverse ethnic & socio-economic mix. There is a higher than average percentage of minority ethnic groups. WM has a large number of elderly residents but is the youngest population in the UK. Each day >100,000 people are treated in hospital, see their GP or are cared for by the NHS. The West Midlands was one of the hardest hit regions for COVID admissions in both wave 1 & 2.
EHR. University Hospitals Birmingham NHS Foundation Trust (UHB) is one of the largest NHS Trusts in England, providing direct acute services & specialist care across four hospital sites, with 2.2 million patient episodes per year, 2750 beds & 100 ITU beds. UHB runs a fully electronic healthcare record (EHR) (PICS; Birmingham Systems), a shared primary & secondary care record (Your Care Connected) & a patient portal “My Health”. UHB has cared for >5000 COVID admissions to date. This is a subset of data in OMOP format.
Scope: All COVID swab confirmed hospitalised patients to UHB from January – August 2020. The dataset includes highly granular patient demographics & co-morbidities taken from ICD-10 & SNOMED-CT codes. Serial, structured data pertaining to care process (timings, staff grades, specialty review, wards), presenting complaint, acuity, all physiology readings (pulse, blood pressure, respiratory rate, oxygen saturations), all blood results, microbiology, all prescribed & administered treatments (fluids, antibiotics, inotropes, vasopressors, organ support), all outcomes.
Available supplementary data: Health data preceding & following admission event. Matched “non-COVID” controls; ambulance, 111, 999 data, synthetic data. Further OMOP data available as an additional service.
Available supplementary support: Analytics, Model build, validation & refinement; A.I.; Data partner support for ETL (extract, transform & load) process, Clinical expertise, Patient & end-user access, Purchaser access, Regulatory requirements, Data-driven trials, “fast screen” services.
• Available within 40 miles of S75 2JG • Between 20 April 2023 to date We should be grateful if you would kindly include the information set out below in any table complied: • Name of organisation • Vacancy reference number • Job title • Staff group • Salary • AfC banding • Date published • Date closed • Duration (i.e. permanent/fixed term for X months) • Vacancy site (i.e. the hospital/site the position was held) Should you require any further information in order to complete this request, please do not hesitate to contact us. On the 30 May 2024 you clarified the following:
This data table contains a list of all hospitals that have been registered with Medicare. This list includes addresses, phone numbers, hospital types and quality of care information. The quality of care data is provided for over 4,000 Medicare-certified hospitals, including over 130 Veterans Administration (VA) medical centers, across the country. You can use this data to find hospitals and compare the quality of their care. This data was created through the efforts of the Centers for Medicare & Medicaid Services (CMS) in collaboration with organizations representing consumers, hospitals, doctors, employers, accrediting organizations, and other federal agencies. This public dataset is hosted in Google BigQuery and is included in BigQuery's 1TB/mo of free tier processing. This means that each user receives 1TB of free BigQuery processing every month, which can be used to run queries on this public dataset. Watch this short video to learn how to get started quickly using BigQuery to access public datasets. What is BigQuery .
ODC Public Domain Dedication and Licence (PDDL) v1.0http://www.opendatacommons.org/licenses/pddl/1.0/
License information was derived automatically
A. SUMMARY Count of COVID+ patients admitted to the hospital. Patients who are hospitalized and test positive for COVID-19 may be admitted to an acute care bed (a regular hospital bed), or an intensive care unit (ICU) bed. This data shows the daily total count of COVID+ patients in these two bed types, and the data reflects totals from all San Francisco Hospitals.
B. HOW THE DATASET IS CREATED Hospital information is based on admission data reported to the San Francisco Department of Public Health.
C. UPDATE PROCESS Updated daily, dataset uploaded manually by staff
D. HOW TO USE THIS DATASET Each record represents how many people were hospitalized on the date recorded in either an ICU bed or acute care bed (shown as Med/Surg under DPHCategory field).
Data shown here include all San Francisco hospitals and will be updated daily with a two-day lag as information is collected and verified. Data may change as more current information becomes available.
The summation contains updated data which reflect all corrections made by HCAI audit staff and hospital representatives. Each file consists of one rolling 4th quarter file for the respective calendar year of data. Comparison of the previously released data files with the revised data files may not have a material effect on statewide aggregations, but may have a significant effect on the data for individual hospitals.
The summation contains updated data which reflect all corrections made by HCAI audit staff and hospital representatives. Each file consists of one rolling 4th quarter file for the respective calendar year of data. Comparison of the previously released data files with the revised data files may not have a material effect on statewide aggregations, but may have a significant effect on the data for individual hospitals.
DSH COVID-19 Staff Testing: Last updated - 11/07/2024 DSH COVID-19 Staff Data reports on DSH staff and non-DSH personnel positives at the facility level for DSH. The table reports on the following data fields: Total staff positive for COVID-19 confirmed by Public Health or medical facility since 3/20/2020 Staff newly positive for COVID-19 in the last 14 days Non-DSH personnel positive for COVID-19 confirmed by Public Health or medical facility since 5/26/2020 Non-DSH personnel newly positive for COVID-19 in the last 14 days Table Notes: Data has been de-identified in accordance with CalHHS Data De-Identification Guidelines. Counts between 1-10 are masked with "<11". Other includes non-DSH personnel who perform work at DSH facilities and personnel working at sites located on DSH facilities that are operated by other organizations. Metro-Norwalk is additional COVID-19 surge space and technically a branch location that is part of DSH Metropolitan Hospital.
Attribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
This study delves into the complex dynamics of ethical leadership’s influence on employees’ pro-social rule-breaking behavior, taking into account the mediating role of psychological capital and the moderating effect of moral identity. Using data collected from nursing staff in Pakistani hospitals and analyzed through PLS SEM, the study yielded unexpected results. Contrary to the initial hypotheses, the findings reveal a positive relationship between ethical leadership and employees’ pro-social rule-breaking behavior within organizational settings. Furthermore, the study identifies psychological capital as a key mediator in this relationship, while moral identity emerges as a crucial moderator. These results challenge the conventional perception of ethical leadership as an exclusively positive form of leadership and underscore its unintended consequences. Moreover, they underscore the significance of employees’ psychological processes and individual differences in unraveling this paradoxical relationship. These results have the potential to reshape how organizations view ethical leadership and consider the unintended outcomes it may generate. Future research can build upon these findings to explore the boundaries and contextual factors that influence the effects of ethical leadership, ultimately contributing to a more comprehensive understanding of leadership dynamics in diverse organizational settings.
Attribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
Analysis of ‘COVID-19 Staff Data’ provided by Analyst-2 (analyst-2.ai), based on source dataset retrieved from https://catalog.data.gov/dataset/a1d604bb-6724-4fb2-aee3-0466854d3547 on 27 January 2022.
--- Dataset description provided by original source is as follows ---
DSH COVID-19 Staff Data reports on DSH staff and non-DSH personnel positives at the facility level for DSH. The table reports on the following data fields:
Total staff positive for COVID-19 confirmed by Public Health or medical facility since 3/20/2020
Staff newly positive for COVID-19 in the last 14 days
Non-DSH personnel positive for COVID-19 confirmed by Public Health or medical facility since 5/26/2020
Non-DSH personnel newly positive for COVID-19 in the last 14 days
Data has been de-identified in accordance with CHHS Data De-identification Guidelines. Counts between 1-10 are masked with "<11". Other includes non-DSH personnel who perform work at DSH facilities and personnel working at sites located on DSH facilities that are operated by other organizations. Metro-Norwalk is additional COVID-19 surge space and technically a branch location that is part of DSH Metropolitan Hospital.
--- Original source retains full ownership of the source dataset ---
Attribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
This table provides an overview of the key figures on health and care available on StatLine. All figures are taken from other tables on StatLine, either directly or through a simple conversion. In the original tables, breakdowns by characteristics of individuals or other variables are possible. The period after the year of review before data become available differs between the data series. The number of exam passes/graduates in year t is the number of persons who obtained a diploma in school/study year starting in t-1 and ending in t.
Data available from: 2001
Status of the figures:
2024: Most available figures are definite. Figures are provisional for: - causes of death; - youth care; - persons employed in health and welfare; - persons employed in healthcare; - Mbo health care graduates; - Hbo nursing graduates / medicine graduates (university).
2023: Most available figures are definite. Figures are provisional for: - perinatal mortality at pregnancy duration at least 24 weeks; - diagnoses known to the general practitioner; - hospital admissions by some diagnoses; - average period of hospitalisation; - supplied drugs; - AWBZ/Wlz-funded long term care; - physicians and nurses employed in care; - persons employed in health and welfare; - average distance to facilities; - profitability and operating results at institutions. Figures are revised provisional for: - expenditures on health and welfare.
2022: Most available figures are definite. Figures are revised provisional for: - expenditures on health and welfare.
2021: Most available figures are definite, Figures are revised provisional for: - expenditures on health and welfare.f
2020 and earlier: All available figures are definite.
Changes as of 4 July 2025: More recent figures have been added for: - causes of death; - life expectancy; - life expectancy in perceived good health; - self-perceived health; - hospital admissions by some diagnoses; - sickness absence; - average period of hospitalisation; - contacts with health professionals; - youth care; - smoking, heavy drinkers, physical activity; - overweight; - high blood pressure; - physicians and nurses employed in care; - persons employed in health and welfare; - persons employed in healthcare; - Mbo health care graduates; - Hbo nursing graduates / medicine graduates (university); - expenditures on health and welfare; - profitability and operating results at institutions.
Changes as of 18 december 2024: - Distance to facilities: the figures withdrawn on 5 June have been replaced (unchanged). - Youth care: the previously published final results for 2021 and 2022 have been adjusted due to improvements in the processing. - Due to a revision of the statistics Expenditure on health and welfare 2021, figures for expenditure on health and welfare care have been replaced from 2021 onwards. - Due to the revision of the National Accounts, the figures on persons employed in health and welfare have been replaced for all years. - AWBZ/Wlz-funded long term care: from 2015, the series Wlz residential care including total package at home has been replaced by total Wlz care. This series fits better with the chosen demarcation of indications for Wlz care.
When will new figures be published? New figures will be published in December 2025.
ODC Public Domain Dedication and Licence (PDDL) v1.0http://www.opendatacommons.org/licenses/pddl/1.0/
License information was derived automatically
As of 9/12/2024, we will begin reporting on hospitalization data again using a new San Francisco specific dataset. Updated data can be accessed here.
On 5/1/2024, hospitalization data reporting will change from mandatory to optional for all hospitals nationwide. We will be pausing the refresh of the underlying data beginning 5/2/2024.
A. SUMMARY Count of COVID+ patients admitted to the hospital. Patients who are hospitalized and test positive for COVID-19 may be admitted to an acute care bed (a regular hospital bed), or an intensive care unit (ICU) bed. This data shows the daily total count of COVID+ patients in these two bed types, and the data reflects totals from all San Francisco Hospitals.
B. HOW THE DATASET IS CREATED Hospital information is based on admission data reported to the National Healthcare Safety Network (NHSN) and provided by the California Department of Public Health (CDPH).
C. UPDATE PROCESS Updates automatically every week.
D. HOW TO USE THIS DATASET Each record represents how many people were hospitalized on the date recorded in either an ICU bed or acute care bed (shown as Med/Surg under DPHCategory field).
The dataset shown here includes all San Francisco hospitals and updates weekly with data for the past Sunday-Saturday as information is collected and verified. Data may change as more current information becomes available.
E. CHANGE LOG
A. SUMMARY This dataset includes hospital diversion events declared by San Francisco hospitals.
B. HOW THE DATASET IS CREATED San Francisco hospitals can declare ambulance diversion status, which diverts all ambulance transports away from the hospital of interest except certain specialty calls. This dataset contains number of diversion hours for each hospital. Each record includes the hospital name, the date and time diversion status started, the date and time diversion status ended, and duration of diversion status.
C. UPDATE PROCESS The data is updated monthly by San Francisco Emergency Medical Services Agency.
D. HOW TO USE THIS DATASET Hospitals are allowed to go on diversion for a maximum of 2 hours before they must re-declare diversion. If 4 or more hospitals go on diversion at the same time, diversion is suspended across all hospitals which means that no hospitals can go on diversion for the next 4 hours. The exception is San Francisco General (SFG) hospital. SFG can declare Trauma Override (functionally identical to hospital diversion) while diversion is suspended since it is San Francisco’s only trauma center. Please refer to the Hospital Suspensions dataset for more information on diversion suspension.
The dataset contains risk-adjusted mortality rates, quality ratings, and number of deaths and cases for 6 medical conditions treated (Acute Stroke, Acute Myocardial Infarction, Heart Failure, Gastrointestinal Hemorrhage, Hip Fracture and Pneumonia) and 3 procedures performed (Carotid Endarterectomy, Pancreatic Resection, and Percutaneous Coronary Intervention) in California hospitals. The 2023 IMIs were generated using AHRQ Version 2024, while previous years' IMIs were generated with older versions of AHRQ software (2022 IMIs by Version 2023, 2021 IMIs by Version 2022, 2020 IMIs by Version 2021, 2019 IMIs by Version 2020, 2016-2018 IMIs by Version 2019, 2014 and 2015 IMIs by Version 5.0, and 2012 and 2013 IMIs by Version 4.5). The differences in the statistical method employed and inclusion and exclusion criteria using different versions can lead to different results. Users should not compare trends of mortality rates over time. However, many hospitals showed consistent performance over years; “better” performing hospitals may perform better and “worse” performing hospitals may perform worse consistently across years. This dataset does not include conditions treated or procedures performed in outpatient settings. Please refer to statewide table for California overall rates: https://data.chhs.ca.gov/dataset/california-hospital-inpatient-mortality-rates-and-quality-ratings/resource/af88090e-b6f5-4f65-a7ea-d613e6569d96
[IMPORTANT NOTE: Sample file posted on Datarade is not the complete dataset, as Datarade permits only a single CSV file. Visit https://www.careprecise.com/healthcare-provider-data-sample.htm for more complete samples.] Updated every month, CarePrecise developed the AHD to provide a comprehensive database of U.S. hospital information. Extracted from the CarePrecise master provider database with information all of the 6.3 million HIPAA-covered US healthcare providers and additional sources, the Authoritative Hospital Database (AHD) contains records for all HIPAA-covered hospitals. In this database of hospitals we include bed counts, patient satisfaction data, hospital system ownership, hospital charges and cases by Zip Code®, and more. Most records include a cabinet-level or director-level contact. A PlaceKey is provided where available.
The AHD includes bed counts for 95% of hospitals, full contact information on 85%, and fax numbers for 62%. We include detailed patient satisfaction data, employee counts, and medical procedure volumes.
The AHD integrates directly with our extended provider data product to bring you the physicians and practice groups affiliated with the hospitals. This combination of data is the only commercially available hospital dataset of this depth.
NEW: Hospital NPI to CCN Rollup A CarePrecise Exclusive. Using advanced record-linkage technology, the AHD now includes a new file that makes it possible to mine the vast hospital information available in the National Provider Identifier registry database. Hospitals may have dozens of NPI records, each with its own information about a unit, listing facility type and/or medical specialties practiced, as well as separate contact names. To wield the power of this new feature, you'll need the CarePrecise Master Bundle, which contains all of the publicly available NPI registry data. These data are available in other CarePrecise data products.
Counts are approximate due to ongoing updates. Please review the current AHD information here: https://www.careprecise.com/detail_authoritative_hospital_database.htm
The AHD is sold as-is and no warranty is offered regarding accuracy, timeliness, completeness, or fitness for any purpose.