The largest all-payer ambulatory surgery database in the United States, the Healthcare Cost and Utilization Project (HCUP) Nationwide Ambulatory Surgery Sample (NASS) produces national estimates of major ambulatory surgery encounters in hospital-owned facilities. Major ambulatory surgeries are defined as selected major therapeutic procedures that require the use of an operating room, penetrate or break the skin, and involve regional anesthesia, general anesthesia, or sedation to control pain (i.e., surgeries flagged as "narrow" in the HCUP Surgery Flag Software). Unweighted, the NASS contains approximately 9.0 million ambulatory surgery encounters each year and approximately 11.8 million ambulatory surgery procedures. Weighted, it estimates approximately 11.9 million ambulatory surgery encounters and 15.7 million ambulatory surgery procedures. Sampled from the HCUP State Ambulatory Surgery and Services Databases (SASD) and State Emergency Department Databases (SEDD) in order to capture both planned and emergent major ambulatory surgeries, the NASS can be used to examine selected ambulatory surgery utilization patterns. Developed through a Federal-State-Industry partnership sponsored by the Agency for Healthcare Research and Quality, HCUP data inform decision making at the national, State, and community levels. The NASS contains clinical and resource-use information that is included in a typical hospital-owned facility record, including patient characteristics, clinical diagnostic and surgical procedure codes, disposition of patients, total charges, facility characteristics, and expected source of payment, regardless of payer, including patients covered by Medicaid, private insurance, and the uninsured. The NASS excludes data elements that could directly or indirectly identify individuals, hospitals, or states. The NASS is limited to encounters with at least one in-scope major ambulatory surgery on the record, performed at hospital-owned facilities. Procedures intended primarily for diagnostic purposes are not considered in-scope. Restricted access data files are available with a data use agreement and brief online security training.

The national average for the OAS CAHPS Survey categories. The OAS CAHPS survey collects information about patients’ experiences of care in hospital outpatient departments (HOPDs) and ambulatory surgical centers (ASCs).

The National Hospital Ambulatory Medical Care Survey (NHAMCS) is a national survey that collects information information about the provision and use of ambulatory medical care services in the United States. The survey samples visits to hospital outpatient departments (OPD), hospital emergency departments (ED), and hospital-based ambulatory surgery locations (ASL). The survey has been conducted annually since 1992; since 2018, the survey has only collected data on hospital emergency department visits.

Approximately 500 nationally representative hospitals are selected to provide data on a sample of patient visits each year. Excluded hospitals include federal, hospital units within institutions, and hospitals with fewer than six staffed beds for patient use. Data collected includes patient demographics, conditions treated, services provided, and payment methods. The data is weighted to produce national estimates.

A list of hospital outpatient department ratings for the Outpatient and Ambulatory Surgery Consumer Assessment of Healthcare Providers and Systems (OAS CAHPS) survey. For the initial OAS CAHPS Survey reporting period, the survey data were collected from hospital outpatient departments that voluntarily participated in the survey for 4 consecutive quarters from October 2016 through September 2017. The data are updated and reported each quarter with data from the most recently completed quarter replacing the oldest quarter of data.

The Medicare Outpatient Hospitals by Provider and Service dataset provides information on services for Original Medicare Part B beneficiaries by OPPS hospitals. These datasets contain information on the number of services, payments, and submitted charges organized by provider CMS Certified Number (CCN) and comprehensive Ambulatory Payment Classification (APC).

The National Ambulatory Medical Care Survey (NAMCS) is a national survey designed to meet the need for objective, reliable information about the provision and use of ambulatory medical care services in the United States. Findings are based on a sample of visits to non-federal employed office-based physicians who are primarily engaged in direct patient care.

Ebitda-Per-Share Time Series for Cardinal Health Inc. Cardinal Health, Inc. operates as a healthcare services and products company in the United States and internationally. It operates in two segments: Pharmaceutical and Specialty Solutions, and Global Medical Products and Distribution. The company provides customized solutions for hospitals, healthcare systems, pharmacies, ambulatory surgery centers, clinical laboratories, physician offices, and patients in the home. It distributes branded and generic pharmaceutical, specialty pharmaceutical, and over-the-counter healthcare and consumer products. The company also provides services to pharmaceutical manufacturers and healthcare providers for specialty pharmaceutical products; pharmacy management services to hospitals; operates pharmacies, including pharmacies in community health centers; and repackages generic pharmaceuticals and over-the-counter healthcare products. In addition, it manufactures, sources, and distributes Cardinal Health branded medical, surgical, and laboratory products and devices that include exam and surgical gloves; needles, syringe, and sharps disposals; compression, incontinence, nutritional delivery, and wound care products; single-use surgical drapes, gowns, and apparel products; fluid suction and collection systems; urology products; operating room supply products; and electrode product lines. Further, the company distributes a range of national brand products, including medical, surgical, and laboratory products; provides supply chain services and solutions to hospitals, ambulatory surgery centers, clinical laboratories, and other healthcare providers; and assembles and sells sterile and non-sterile procedure kits. Additionally, it manufactures, prepares, and delivers radiopharmaceuticals; and optimizes direct shipments through integrated technology solutions. The company was incorporated in 1979 and is headquartered in Dublin, Ohio.

Abstract

The State Ambulatory Surgery Databases (SASD), State Inpatient Databases (SID), and State Emergency Department Databases (SEDD) are part of a family of databases and software tools developed for the Healthcare Cost and Utilization Project (HCUP).

HCUP's state-specific databases can be used to investigate state-specific and multi-state trends in health care utilization, access, charges, quality, and outcomes. PHS has several years (2008-2011) and datasets (SASSD, SED and SIDD) for HCUP California available.

Usage

The State Ambulatory Surgery and Services Databases (SASD) are State-specific files that include data for ambulatory surgery and other outpatient services from hospital-owned facilities. In addition, some States provide ambulatory surgery and outpatient services from nonhospital-owned facilities. The uniform format of the SASD helps facilitate cross-State comparisons. The SASD are well suited for research that requires complete enumeration of hospital-based ambulatory surgeries within geographic areas or States.

The State Inpatient Databases (SID) are State-specific files that contain all inpatient care records in participating states. Together, the SID encompass more than 95 percent of all U.S. hospital discharges. The uniform format of the SID helps facilitate cross-state comparisons. In addition, the SID are well suited for research that requires complete enumeration of hospitals and discharges within geographic areas or states.

The State Emergency Department Databases (SEDD) are a set of longitudinal State-specific emergency department (ED) databases included in the HCUP family. The SEDD capture discharge information on all emergency department visits that do not result in an admission. Information on patients seen in the emergency room and then admitted to the hospital is included in the State Inpatient Databases (SID)

SASD, SID, and SEDD each have **Documentation **which includes:

• Description of the Database
• Restrictions on Use
• File Specifications and Load Program
• Data Elements
• Additional Resources for Data Elements
• ICD-10-CM/PCS Data Included in the Dataset Starting with 2015
• Known Data Issues
• HCUP Tools: Labels and Formats
• HCUP Supplemental Files
• Obtaining HCUP Data

%3C!-- --%3E

Before Manuscript Submission

All manuscripts (and other items you'd like to publish) must be submitted to

phsdatacore@stanford.edu for approval prior to journal submission.

We will check your cell sizes and citations.

For more information about how to cite PHS and PHS datasets, please visit:

https:/phsdocs.developerhub.io/need-help/citing-phs-data-core

Documentation

The HCUP California inpatient files were constructed from the confidential files received from the Office of Statewide Health Planning and Development (OSHPD). OSHPD excluded inpatient stays that, after processing by OSHPD, did not contain a complete and “in-range” admission date or discharge date. California also excluded inpatient stays that had an unknown or missing date of birth. OSHPD removes ICD-9-CM and ICD-10-CM diagnoses codes for HIV test results. Beginning with 2009 data, OSHPD changed regulations to require hospitals to report all external cause of injury diagnosis codes including those specific to medical misadventures. Prior to 2009, OSHPD did not require collection of diagnosis codes identifying medical misadventures.

**Types of Facilities Included in the Files Provided to HCUP by the Partner **

California supplied discharge data for inpatient stays in general acute care hospitals, acute psychiatric hospitals, chemical dependency recovery hospitals, psychiatric health facilities, and state operated hospitals. A comparison of the number of hospitals included in the SID and the number of hospitals reported in the AHA Annual Survey is available starting in data year 2010. Hospitals do not always report data for a full calendar year. Some hospitals open or close during the year; other hospitals have technical problems that prevent them from reporting data for all months in a year.

**Inclusion of Stays in Special Units **

Included with the general acute care stays are stays in skilled nursing, intermediate care, rehabilitation, alcohol/chemical dependency treatment, and psychiatric units of hospitals in California. How the stays in these different types of units can be identified differs by data year. Beginning in 2006, the information is retained in the HCUP variable HOSPITALUNIT. Reliability of this indicator for the level of care depends on how it was assigned by the hospital. For data years 1998-2006, the information was retained in the HCUP variable LEVELCARE. Prior to 1998, the first

Total-Other-Finance-Cost Time Series for Cardinal Health Inc. Cardinal Health, Inc. operates as a healthcare services and products company in the United States and internationally. It operates in two segments: Pharmaceutical and Specialty Solutions, and Global Medical Products and Distribution. The company provides customized solutions for hospitals, healthcare systems, pharmacies, ambulatory surgery centers, clinical laboratories, physician offices, and patients in the home. It distributes branded and generic pharmaceutical, specialty pharmaceutical, and over-the-counter healthcare and consumer products. The company also provides services to pharmaceutical manufacturers and healthcare providers for specialty pharmaceutical products; pharmacy management services to hospitals; operates pharmacies, including pharmacies in community health centers; and repackages generic pharmaceuticals and over-the-counter healthcare products. In addition, it manufactures, sources, and distributes Cardinal Health branded medical, surgical, and laboratory products and devices that include exam and surgical gloves; needles, syringe, and sharps disposals; compression, incontinence, nutritional delivery, and wound care products; single-use surgical drapes, gowns, and apparel products; fluid suction and collection systems; urology products; operating room supply products; and electrode product lines. Further, the company distributes a range of national brand products, including medical, surgical, and laboratory products; provides supply chain services and solutions to hospitals, ambulatory surgery centers, clinical laboratories, and other healthcare providers; and assembles and sells sterile and non-sterile procedure kits. Additionally, it manufactures, prepares, and delivers radiopharmaceuticals; and optimizes direct shipments through integrated technology solutions. The company was incorporated in 1979 and is headquartered in Dublin, Ohio.

Minority-Interest-Expense Time Series for Cardinal Health Inc. Cardinal Health, Inc. operates as a healthcare services and products company in the United States and internationally. It operates in two segments: Pharmaceutical and Specialty Solutions, and Global Medical Products and Distribution. The company provides customized solutions for hospitals, healthcare systems, pharmacies, ambulatory surgery centers, clinical laboratories, physician offices, and patients in the home. It distributes branded and generic pharmaceutical, specialty pharmaceutical, and over-the-counter healthcare and consumer products. The company also provides services to pharmaceutical manufacturers and healthcare providers for specialty pharmaceutical products; pharmacy management services to hospitals; operates pharmacies, including pharmacies in community health centers; and repackages generic pharmaceuticals and over-the-counter healthcare products. In addition, it manufactures, sources, and distributes Cardinal Health branded medical, surgical, and laboratory products and devices that include exam and surgical gloves; needles, syringe, and sharps disposals; compression, incontinence, nutritional delivery, and wound care products; single-use surgical drapes, gowns, and apparel products; fluid suction and collection systems; urology products; operating room supply products; and electrode product lines. Further, the company distributes a range of national brand products, including medical, surgical, and laboratory products; provides supply chain services and solutions to hospitals, ambulatory surgery centers, clinical laboratories, and other healthcare providers; and assembles and sells sterile and non-sterile procedure kits. Additionally, it manufactures, prepares, and delivers radiopharmaceuticals; and optimizes direct shipments through integrated technology solutions. The company was incorporated in 1979 and is headquartered in Dublin, Ohio.

Stock-Based-Compensation Time Series for Cardinal Health Inc. Cardinal Health, Inc. operates as a healthcare services and products company in the United States and internationally. It operates in two segments: Pharmaceutical and Specialty Solutions, and Global Medical Products and Distribution. The company provides customized solutions for hospitals, healthcare systems, pharmacies, ambulatory surgery centers, clinical laboratories, physician offices, and patients in the home. It distributes branded and generic pharmaceutical, specialty pharmaceutical, and over-the-counter healthcare and consumer products. The company also provides services to pharmaceutical manufacturers and healthcare providers for specialty pharmaceutical products; pharmacy management services to hospitals; operates pharmacies, including pharmacies in community health centers; and repackages generic pharmaceuticals and over-the-counter healthcare products. In addition, it manufactures, sources, and distributes Cardinal Health branded medical, surgical, and laboratory products and devices that include exam and surgical gloves; needles, syringe, and sharps disposals; compression, incontinence, nutritional delivery, and wound care products; single-use surgical drapes, gowns, and apparel products; fluid suction and collection systems; urology products; operating room supply products; and electrode product lines. Further, the company distributes a range of national brand products, including medical, surgical, and laboratory products; provides supply chain services and solutions to hospitals, ambulatory surgery centers, clinical laboratories, and other healthcare providers; and assembles and sells sterile and non-sterile procedure kits. Additionally, it manufactures, prepares, and delivers radiopharmaceuticals; and optimizes direct shipments through integrated technology solutions. The company was incorporated in 1979 and is headquartered in Dublin, Ohio.

Medical Emergency Response StructuresThis feature layer, utilizing National Geospatial Data Asset (NGDA) data from the U.S. Geological Survey, displays hospitals, medical centers, ambulance services, fire stations and EMS stations in the U.S. Per the USGS, "Structures data are designed to be used in general mapping and in the analysis of structure related activities using geographic information system technology. The National Map structures data is commonly combined with other data themes, such as boundaries, elevation, hydrography, and transportation, to produce general reference base maps. The types of structures collected are largely determined by the needs of disaster planning and emergency response, and homeland security organizations."Greendale Fire DepartmentData currency: This cached Esri federal service is checked weekly for updates from its enterprise federal source (Medical & Emergency Response) and will support mapping, analysis, data exports and OGC API – Feature access.NGDAID: 135 (USGS National Structures Dataset - USGS National Map Downloadable Data Collection)OGC API Features Link: (Medical Emergency Response Structures - OGC Features) copy this link to embed it in OGC Compliant viewersFor more information, please visit: The National MapFor feedback please contact: Esri_US_Federal_Data@esri.comNGDA Theme CommunityThis data set is part of the NGDA Real Property Theme Community. Per the Federal Geospatial Data Committee (FGDC), Real Property is defined as "the spatial representation (location) of real property entities, typically consisting of one or more of the following: unimproved land, a building, a structure, site improvements and the underlying land. Complex real property entities (that is "facilities") are used for a broad spectrum of functions or missions. This theme focuses on spatial representation of real property assets only and does not seek to describe special purpose functions of real property such as those found in the Cultural Resources, Transportation, or Utilities themes."For other NGDA Content: Esri Federal Datasets

The CMS Program Statistics - Medicare Outpatient Facility tables provide use and payment data for all outpatient facilities, including hospitals providing outpatient services, rural health clinics, community mental health centers, federally qualified health centers, outpatient dialysis facilities, comprehensive outpatient rehabilitation facilities, and other outpatient facilities.

For additional information on enrollment, providers, and Medicare use and payment, visit the CMS Program Statistics page.

These data do not exist in a machine-readable format, so the view data and API options are not available. Please use the download function to access the data.

Below is the list of tables:

MDCR OUTPATIENT 1. Medicare Outpatient Facilities: Utilization, Program Payments, and Cost Sharing for Original Medicare Beneficiaries, by Type of Entitlement, Yearly Trend MDCR OUTPATIENT 2. Medicare Outpatient Facilities: Utilization, Program Payments, and Cost Sharing for Original Medicare Beneficiaries, by Demographic Characteristics and Medicare-Medicaid Enrollment Status MDCR OUTPATIENT 3. Medicare Outpatient Facilities: Utilization, Program Payments, and Cost Sharing for Original Medicare Beneficiaries, by Area of Residence MDCR OUTPATIENT 4. Medicare Outpatient Facilities: Utilization and Program Payments for Original Medicare Beneficiaries, by Type of Outpatient Facility MDCR OUTPATIENT 5. Medicare Outpatient Facilities: Utilization for Original Medicare Beneficiaries, by Type of Outpatient Facility and Type of Service MDCR OUTPATIENT 6. Medicare Outpatient Prospective Payment System Hospitals: Utilization, Program Payments, and Cost Sharing for Original Medicare Beneficiaries, by Type of Entitlement, Yearly Trend MDCR OUTPATIENT 7. Medicare Outpatient Prospective Payment System Hospitals: Utilization, Program Payments, and Cost Sharing for Original Medicare Beneficiaries, by Demographic Characteristics and Medicare-Medicaid Enrollment Status MDCR OUTPATIENT 8. Medicare Outpatient Prospective Payment System Hospitals: Utilization, Program Payments, and Cost Sharing for Original Medicare Beneficiaries, by Area of Residence MDCR OUTPATIENT 9. Medicare Outpatient Critical Access Hospitals: Utilization, Program Payments, and Cost Sharing for Original Medicare Beneficiaries, by Type of Entitlement, Yearly Trend MDCR OUTPATIENT 10. Medicare Outpatient Critical Access Hospitals: Utilization, Program Payments, and Cost Sharing for Original Medicare Beneficiaries, by Demographic Characteristics and Medicare-Medicaid Enrollment Status MDCR OUTPATIENT 11. Medicare Outpatient Critical Access Hospitals: Utilization, Program Payments, and Cost Sharing for Original Medicare Beneficiaries, by Area of Residence

Total-Cashflows-From-Financing-Activities Time Series for Surgery Partners Inc. Surgery Partners, Inc., together with its subsidiaries, owns and operates a network of surgical facilities and ancillary services in the United States. The company provides ambulatory surgery centers and surgical hospitals that offer non-emergency surgical procedures in various specialties, including orthopedics and pain management, ophthalmology, gastroenterology, and general surgery. It offers emergency departments; and ancillary services, such as multi-specialty physician practices, urgent care facilities, and anesthesia services. In addition, it offers single- and multi-specialty facilities. Surgery Partners, Inc. was founded in 2004 and is headquartered in Brentwood, Tennessee.

Current-Ratio Time Series for HCA Holdings Inc. HCA Healthcare, Inc., through its subsidiaries, owns and operates hospitals and related healthcare entities in the United States. It operates general and acute care hospitals that offers medical and surgical services, including inpatient care, intensive care, cardiac care, diagnostic, and emergency services; and outpatient services, such as outpatient surgery, laboratory, radiology, respiratory therapy, cardiology, and physical therapy. The company also operates outpatient health care facilities consisting of freestanding ambulatory surgery centers, freestanding emergency care facilities, urgent care facilities, walk-in clinics, diagnostic and imaging centers, rehabilitation and physical therapy centers, radiation and oncology therapy centers, physician practices, and various other facilities. In addition, it operates behavioral hospitals, which provide therapeutic programs comprising child, adolescent and adult psychiatric care, adolescent and adult alcohol, drug abuse treatment, and counseling services. The company was formerly known as HCA Holdings, Inc. HCA Healthcare, Inc. was founded in 1968 and is headquartered in Nashville, Tennessee.

Deferred-Long-Term-Liabilities Time Series for Cardinal Health Inc. Cardinal Health, Inc. operates as a healthcare services and products company in the United States and internationally. It operates in two segments: Pharmaceutical and Specialty Solutions, and Global Medical Products and Distribution. The company provides customized solutions for hospitals, healthcare systems, pharmacies, ambulatory surgery centers, clinical laboratories, physician offices, and patients in the home. It distributes branded and generic pharmaceutical, specialty pharmaceutical, and over-the-counter healthcare and consumer products. The company also provides services to pharmaceutical manufacturers and healthcare providers for specialty pharmaceutical products; pharmacy management services to hospitals; operates pharmacies, including pharmacies in community health centers; and repackages generic pharmaceuticals and over-the-counter healthcare products. In addition, it manufactures, sources, and distributes Cardinal Health branded medical, surgical, and laboratory products and devices that include exam and surgical gloves; needles, syringe, and sharps disposals; compression, incontinence, nutritional delivery, and wound care products; single-use surgical drapes, gowns, and apparel products; fluid suction and collection systems; urology products; operating room supply products; and electrode product lines. Further, the company distributes a range of national brand products, including medical, surgical, and laboratory products; provides supply chain services and solutions to hospitals, ambulatory surgery centers, clinical laboratories, and other healthcare providers; and assembles and sells sterile and non-sterile procedure kits. Additionally, it manufactures, prepares, and delivers radiopharmaceuticals; and optimizes direct shipments through integrated technology solutions. The company was incorporated in 1979 and is headquartered in Dublin, Ohio.

Abstract (en): The National Ambulatory Medical Care Surveys (NAMCS) supply data on ambulatory medical care provided in physicians' offices. The 2006 survey contains information from 29,392 patient visits to 1,455 physicians' offices. Data are available on the patient's smoking habits, reason for the visit, expected source of payment, the physician's diagnosis, and the kinds of diagnostic and therapeutic services rendered. Other variables cover drugs/medications ordered, administered, or provided during office visits, with information on medication code, generic name and code, brand name, entry status, prescription status, federal controlled substance status, composition status, and related ingredient codes. Information is also included on the physician's specialization and geographic location. Demographic information on patients, such as age, sex, race, and ethnicity, was also collected. In addition, the 2006 survey contains two new sampling strata which are from 104 Community Health Centers (CHCs) and 200 oncologists. Microdata file users should be fully aware of the importance of the "patient visit weight" (PATWT) and how it must be used. Information about the patient visit weight is presented in the codebook. If more information is needed, the staff of the Ambulatory Care Statistics Branch can be consulted by calling (301) 458-4600 during regular working hours. Prior to this data release, researchers could not make physician-level estimates with publicly available NAMCS data. For 2006, a new "physician weight" (PHYSWT) variable was added to the first record for each individual physician in the dataset. Office visits made within the United States by patients of nonfederally-employed physicians who were primarily involved in office-based patient care activities, but not engaged in the specialties of radiology, pathology, or anesthesiology. The 2006 NAMCS utilized a multistage probability sample design. Primary sampling units (PSUs) were selected in the first stage, physician practices within PSUs in the second stage, and patient visits to selected physicians in the third stage. 2011-10-12 Changes to the CPSUM variable have been made within the dataset. Funding insitution(s): United States Department of Health and Human Services. National Institutes of Health. National Cancer Institute. Per agreement with the National Center for Health Statistics (NCHS), ICPSR distributes the data file and text of the technical documentation for this collection as prepared by NCHS.A portion of NAMCS 2006, the sampling stratum of 200 oncologists, was made possible through funding from the National Cancer Institute.The Stata dataset (.dta file) made available by ICPSR does not contain all of the value labels found within the .do file supplied by ICPSR. Specifically, the value labels that are composed primarily of ICD-9 codes have been omitted from the .dta file. Those data users interested in applying the value labels to the dataset will be able to edit the Stata setup files, which include the aforementioned labels, provided by ICPSR.

Physician Experiences Related to COVID-19 from the National Ambulatory Medical Care Survey

  Description

The National Ambulatory Medical Care Survey (NAMCS), conducted by the National Center for Health Statistics (NCHS), collects data on visits to physician offices to describe patterns of ambulatory care delivery in the United States. As part of NAMCS, the Physician Induction Interview collects information about practice characteristics at physician offices. Partway through… See the full description on the dataset page: https://huggingface.co/datasets/HHS-Official/physician-experiences-related-to-covid-19-from-the.

Context

In the United States, Medicare is a single-payer, national social insurance program administered by the U.S. federal government since 1966. It provides health insurance for Americans aged 65 and older who have worked and paid into the system through the payroll tax. Source: https://en.wikipedia.org/wiki/Medicare_(United_States)

Content

This public dataset was created by the Centers for Medicare & Medicaid Services. The data summarizes the utilization and payments for procedures, services, and prescription drugs provided to Medicare beneficiaries by specific inpatient and outpatient hospitals, physicians, and other suppliers. The dataset includes the following data.

Common inpatient and outpatient services All physician and other supplier procedures and services All Part D prescriptions. Providers determine what they will charge for items, services, and procedures provided to patients and these charges are the amount that providers bill for an item, service, or procedure.

Fork this kernel to get started.

Acknowledgements

https://bigquery.cloud.google.com/dataset/bigquery-public-data:medicare

https://cloud.google.com/bigquery/public-data/medicare

Dataset Source: Center for Medicare and Medicaid Services. This dataset is publicly available for anyone to use under the following terms provided by the Dataset Source - http://www.data.gov/privacy-policy#data_policy — and is provided "AS IS" without any warranty, express or implied, from Google. Google disclaims all liability for any damages, direct or indirect, resulting from the use of the dataset.

Banner Photo by @rawpixel from Unplash.

Inspiration

What is the total number of medications prescribed in each state?

What is the most prescribed medication in each state?

What is the average cost for inpatient and outpatient treatment in each city and state?

Which are the most common inpatient diagnostic conditions in the United States?

Which cities have the most number of cases for each diagnostic condition?

What are the average payments for these conditions in these cities and how do they compare to the national average?

This dataset contains annual Excel pivot tables that identify where a facility’s patients come from (Patient Origin) and where patients from a specific area go to (Market Share) for hospital inpatient, emergency department, and ambulatory surgery treatment. The Patient Origin Report shows the ZIP codes of origin (based on a selected facility or facility county) and the Market Share Report lists the destination facilities (based on a selected patient ZIP code or patient county). Note: Physician-owned ambulatory surgery clinics do not report their data to HCAI and, therefore, are not included here.