WA-APCD - Washington All-Payer Claims Database

The WA-APCD is the state’s most complete source of health care eligibility, medical claims, pharmacy claims, and dental claims insurance data. It contains claims from more than 50 data suppliers, spanning commercial, Medicaid, and Medicare managed care. The WA-APCD has historical claims data for five years (2013-2017), with ongoing refreshes scheduled quarterly. Workers' compensation data from the Washington Department of Labor & Industries will be added in fall 2018.

Download the attachment for the data dictionary and more information about WA-APCD and the data.

This data set includes comparative cost and quality information for clinics with five or more physicians for medical claims in 2016. Only clinics with eligible Total Cost of Care indices and three quality measures, Breast Cancer Screening, A1c testing, and Medical Attention for Nephropathy are included.

This data set was calculated by the Utah Department of Health, Office of Healthcare Statistics (OHCS) and HealthInsight Utah using Utah’s All Payer Claims Database (APCD).

WA-APCD - Washington All-Payer Claims Database The WA-APCD is the state’s most complete source of health care eligibility, medical claims, pharmacy claims, and dental claims insurance data. It contains claims from more than 50 data suppliers, spanning commercial, Medicaid, and Medicare managed care. The WA-APCD has historical claims data for five years (2013-2017), with ongoing refreshes scheduled quarterly. Workers' compensation data from the Washington Department of Labor & Industries will be added in fall 2018. Download the attachment for the data dictionary and more information about WA-APCD and the data.

Analysis of ‘WA-APCD Quality and Cost Summary Report: Hospital Quality’ provided by Analyst-2 (analyst-2.ai), based on source dataset retrieved from https://catalog.data.gov/dataset/13e6499e-0f20-42f7-b51c-0dc0174855a9 on 12 November 2021.

--- Dataset description provided by original source is as follows ---

WA-APCD - Washington All-Payer Claims Database

The WA-APCD is the state’s most complete source of health care eligibility, medical claims, pharmacy claims, and dental claims insurance data. It contains claims from more than 50 data suppliers, spanning commercial, Medicaid, and Medicare managed care. The WA-APCD has historical claims data for five years (2013-2017), with ongoing refreshes scheduled quarterly. Workers' compensation data from the Washington Department of Labor & Industries will be added in fall 2018.

Download the attachment for the data dictionary and more information about WA-APCD and the data.

--- Original source retains full ownership of the source dataset ---

This dataset contains data for the Healthcare Payments Data (HPD): Medical Out-of-Pocket Costs and Chronic Conditions report. The data covers three measurement categories: annual member count, annual median out-of-pocket count, annual median claim count. The annual member count quantify the number of unique individuals who received at least one medical service in the reporting year. Annual median out-of-pocket measurements quantifies the sum of copay, coinsurance, and deductible incurred by members. Annual median claim count measurements quantifies the number of distinct claims or encounters associated with members. Both 25th and 75th percentiles for out-of-pocket cost and claim count are also included. Measures are grouped by payer types, chronic conditions flag, chronic condition types, and chronic condition numbers.

IntroductionThis study aimed to estimate the direct medical costs and out-of-pocket (OOP) expenses associated with inpatient and outpatient care for IHD, based on types of health insurance. Additionally, we sought to identify time trends and factors associated with these costs using an all-payer health claims database among urban patients with IHD in Guangzhou City, Southern China.MethodsData were collected from the Urban Employee-based Basic Medical Insurance (UEBMI) and the Urban Resident-based Basic Medical Insurance (URBMI) administrative claims databases in Guangzhou City from 2008 to 2012. Direct medical costs were estimated in the entire sample and by types of insurance separately. Extended Estimating Equations models were employed to identify the potential factors associated with the direct medical costs including inpatient and outpatient care and OOP expenses.ResultsThe total sample included 58,357 patients with IHD. The average direct medical costs per patient were Chinese Yuan (CNY) 27,136.4 [US dollar (USD) 4,298.8] in 2012. The treatment and surgery fees were the largest contributor to direct medical costs (52.0%). The average direct medical costs of IHD patients insured by UEBMI were significantly higher than those insured by the URBMI [CNY 27,749.0 (USD 4,395.9) vs. CNY 21,057.7(USD 3,335.9), P < 0.05]. The direct medical costs and OOP expenses for all patients increased from 2008 to 2009, and then decreased during the period of 2009–2012. The time trends of direct medical costs between the UEBMI and URBMI patients were different during the period of 2008-2012. The regression analysis indicated that the UEBMI enrollees had higher direct medical costs (P < 0.001) but had lower OOP expenses (P < 0.001) than the URBMI enrollees. Male patients, patients having percutaneous coronary intervention operation and intensive care unit admission, patients treated in secondary hospitals and tertiary hospitals, patients with the LOS of 15–30 days, 30 days and longer had significantly higher direct medical costs and OOP expenses (all P < 0.001).ConclusionsThe direct medical costs and OOP expenses for patients with IHD in China were found to be high and varied between two medical insurance schemes. The type of insurance was significantly associated with direct medical costs and OOP expenses of IHD.

Usage

The National (Nationwide) Inpatient Sample (NIS) is part of a family of databases and software tools developed for the Healthcare Cost and Utilization Project (HCUP). The NIS is the largest publicly available all-payer inpatient healthcare database designed to produce U.S. regional and national estimates of inpatient utilization, access, cost, quality, and outcomes. Unweighted, it contains data from around 7 million hospital stays each year. Weighted, it estimates around 35 million hospitalizations nationally. Developed through a Federal-State-Industry partnership sponsored by the Agency for Healthcare Research and Quality (AHRQ), HCUP data inform decision making at the national, State, and community levels.

The Healthcare Cost and Utilization Project (HCUP) Nationwide Readmissions Database (NRD) is a unique and powerful database designed to support various types of analyses of national readmission rates for all payers and the uninsured. The NRD includes discharges for patients with and without repeat hospital visits in a year and those who have died in the hospital. Repeat stays may or may not be related. The criteria to determine the relationship between hospital admissions is left to the analyst using the NRD. This database addresses a large gap in health care data - the lack of nationally representative information on hospital readmissions for all ages. Outcomes of interest include national readmission rates, reasons for returning to the hospital for care, and the hospital costs for discharges with and without readmissions. Unweighted, the NRD contains data from approximately 18 million discharges each year. Weighted, it estimates roughly 35 million discharges. 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 NRD is drawn from HCUP State Inpatient Databases (SID) containing verified patient linkage numbers that can be used to track a person across hospitals within a State, while adhering to strict privacy guidelines. The NRD is not designed to support regional, State-, or hospital-specific readmission analyses.

The NRD contains more than 100 clinical and non-clinical data elements provided in a hospital discharge abstract. Data elements include but are not limited to: diagnoses, procedures, patient demographics (e.g., sex, age), expected source of payer, regardless of expected payer, including but not limited to Medicare, Medicaid, private insurance, self-pay, or those billed as ‘no charge, discharge month, quarter, and year, total charges, length of stay, and data elements essential to readmission analyses. The NIS excludes data elements that could directly or indirectly identify individuals.

Restricted access data files are available with a data use agreement and brief online security training.

The Nationwide Readmissions Database (NRD) is database under the Healthcare Cost and Utilization Project (HCUP) which contains nationally representative information on hospital readmissions for all ages, including all payers and the uninsured. The NRD contains data from approximately 18 million discharges per year (35 million weighted discharges) across most of the United States.

Data elements include:

• Discharge month, quarter, and year
• Verified patient linkage number
• Timing between admissions for a patient
• Length of inpatient stay (days)
• Transfers, same-day stays, and combined transfer records
• Identification of patient residency in the state in which he or she received hospital care
• International Classification of Diseases (ICD-9-CM) diagnosis, procedure, and external cause of injury codes (prior to October 1, 2015)
• ICD-10-CM/PCS diagnosis, procedures, and external cause of morbidity codes (beginning October 1, 2015)
• Patient demographics (e.g., sex, age, income quartile, rural/urban residency)
• Expected payment source (e.g., Medicare, Medicaid, private insurance, self-pay, those billed as 'no charge', and other insurance types)
• Total charges and hospital cost (calculated using the "Cost-to-Charge Ratio" file)

The NRD consists of four data files:

• Core File: Available for all years of the NRD and contains commonly used data elements (e.g., age, expected primary payer, discharge status, ICD-10-CM/PCS codes, total charges)
• Severity File: Available for all years of the NRD and contains additional data elements related to identifying health conditions at discharge.
• Diagnosis and Procedure Groups File: Contains additional information on ICD-10-CM/PCS; available beginning in 2018.
• Hospital File: Available for all years of the NRD and contains additional information on participating hospital characteristics.

This line chart compares the median cost vs. median charge for cesarean deliveries with a minor severity of illness by hospital. The dataset contains information submitted by New York State Article 28 Hospitals as part of the New York Statewide Planning and Research Cooperative (SPARCS) and Institutional Cost Report (ICR) data submissions. The dataset contains information on the volume of discharges, All Payer Refined Diagnosis Related Group (APR-DRG), the severity of illness level (SOI), medical or surgical classification the median charge, median cost, average charge and average cost per discharge. When interpreting New York’s data, it is important to keep in mind that variations in cost may be attributed to many factors. Some of these include overall volume, teaching hospital status, facility specific attributes, geographic region and quality of care provided.For more information, check out: http://www.health.ny.gov/statistics/sparcs/. The "About" tab contains additional details concerning this dataset..

The Healthcare Cost and Utilization Project (HCUP) Kids' Inpatient Database (KID) is the largest publicly available all-payer pediatric inpatient care database in the United States, containing data from two to three million hospital stays each year. Its large sample size is ideal for developing national and regional estimates and enables analyses of rare conditions, such as congenital anomalies, as well as uncommon treatments, such as organ transplantation. 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 KID is a sample of pediatric discharges from 4,000 U.S. hospitals in the HCUP State Inpatient Databases yielding approximately two to three million unweighted hospital discharges for newborns, children, and adolescents per year. About 10 percent of normal newborns and 80 percent of other neonatal and pediatric stays are selected from each hospital that is sampled for patients younger than 21 years of age.

The KID contains clinical and resource use information included in a typical discharge abstract, with safeguards to protect the privacy of individual patients, physicians, and hospitals (as required by data sources). It includes discharge status, diagnoses, procedures, patient demographics (e.g., sex, age), expected source of primary payment (e.g., Medicare, Medicaid, private insurance, self-pay, and other insurance types), and hospital charges and cost.

Restricted access data files are available with a data use agreement and brief online security training.

This dataset contains information submitted by New York State Article 28 Hospitals as part of the New York Statewide Planning and Research Cooperative (SPARCS) and Institutional Cost Report (ICR) data submissions. The dataset contains information on the volume of discharges, All Payer Refined Diagnosis Related Group (APR-DRG), the severity of illness level (SOI), medical or surgical classification the median charge, median cost, average charge and average cost per discharge. When interpreting New York’s data, it is important to keep in mind that variations in cost may be attributed to many factors. Some of these include overall volume, teaching hospital status, facility specific attributes, geographic region and quality of care provided. For more information, check out: http://www.health.ny.gov/statistics/sparcs/ or go to the "About" tab.

The Healthcare Cost and Utilization Project (HCUP) Nationwide Emergency Department Sample (NEDS) is the largest all-payer emergency department (ED) database in the United States. yielding national estimates of hospital-owned ED visits. Unweighted, it contains data from over 30 million ED visits each year. Weighted, it estimates roughly 145 million ED visits nationally. 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.

Sampled from the HCUP State Inpatient Databases (SID) and State Emergency Department Databases (SEDD), the HCUP NEDS can be used to create national and regional estimates of ED care. The SID contain information on patients initially seen in the ED and subsequently admitted to the same hospital. The SEDD capture information on ED visits that do not result in an admission (i.e., treat-and-release visits and transfers to another hospital). 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 NEDS contain information about geographic characteristics, hospital characteristics, patient characteristics, and the nature of visits (e.g., common reasons for ED visits, including injuries). The NEDS contains clinical and resource use information included in a typical discharge abstract, with safeguards to protect the privacy of individual patients, physicians, and hospitals (as required by data sources). It includes ED charge information for over 85% of patients, regardless of expected payer, including but not limited to Medicare, Medicaid, private insurance, self-pay, or those billed as ‘no charge’. The NEDS excludes data elements that could directly or indirectly identify individuals, hospitals, or states.Restricted access data files are available with a data use agreement and brief online security training.

Users can use the online interactive tool (HCUP-net) to gather national, state and all-payer patient health care data or users can purchase the data from the HCUP databases. Background HCUP is sponsored by the Agency for Healthcare Research and Quality. It is a collection of databases that provide information on patient health care data, including information typically found on a hospital discharge form. Topics include: cost of care, access to care, and treatment outcomes. The HCUP databases include: The National Inpatient Sample, The Kids' Inpatient Database, The State Ambulatory Surgery Database, and The State Emergency Department Databases. Many of these are available for purchase. User Functionality Users can purchase any of the aforementioned databases from the HCUP Central Administrator. Directions and contact information are readily available from the HCUP website. Users can also access the HCUP interactive tool, HCUP-net. Please click the appropriate link in the keywords to access this tool. Data Notes HCUP began collecting health care data in 1988. Specific information about a particular database can be found on the website.

This line chart compares the median cost vs. median charge for other pneumonia with a minor severity of illness by hospital. The dataset contains information submitted by New York State Article 28 Hospitals as part of the New York Statewide Planning and Research Cooperative (SPARCS) and Institutional Cost Report (ICR) data submissions. The dataset contains information on the volume of discharges, All Payer Refined Diagnosis Related Group (APR-DRG), the severity of illness level (SOI), medical or surgical classification the median charge, median cost, average charge and average cost per discharge. When interpreting New York’s data, it is important to keep in mind that variations in cost may be attributed to many factors. Some of these include overall volume, teaching hospital status, facility specific attributes, geographic region and quality of care provided.For more information, check out: http://www.health.ny.gov/statistics/sparcs/. The "About" tab contains additional details concerning this dataset.

The Healthcare Cost and Utilization Project (HCUP) National Inpatient Sample (NIS) is the largest publicly available all-payer inpatient care database in the United States. The NIS is designed to produce U.S. regional and national estimates of inpatient utilization, access, cost, quality, and outcomes. Unweighted, it contains data from more than 7 million hospital stays each year. Weighted, it estimates more than 35 million hospitalizations nationally. Developed through a Federal-State-Industry partnership sponsored by the Agency for Healthcare Research and Quality (AHRQ), HCUP data inform decision making at the national, State, and community levels.

Starting with the 2012 data year, the NIS is a sample of discharges from all hospitals participating in HCUP, covering more than 97 percent of the U.S. population. For prior years, the NIS was a sample of hospitals. The NIS allows for weighted national estimates to identify, track, and analyze national trends in health care utilization, access, charges, quality, and outcomes. The NIS's large sample size enables analyses of rare conditions, such as congenital anomalies; uncommon treatments, such as organ transplantation; and special patient populations, such as the uninsured. NIS data are available since 1988, allowing analysis of trends over time.

The NIS inpatient data include clinical and resource use information typically available from discharge abstracts with safeguards to protect the privacy of individual patients, physicians, and hospitals (as required by data sources). Data elements include but are not limited to: diagnoses, procedures, discharge status, patient demographics (e.g., sex, age), total charges, length of stay, and expected payment source, including but not limited to Medicare, Medicaid, private insurance, self-pay, or those billed as ‘no charge’. The NIS excludes data elements that could directly or indirectly identify individuals.

Restricted access data files are available with a data use agreement and brief online security training.

The Nationwide Inpatient Sample (NIS) is a database focused on hospital stay information. Users are able to use the NIS to identify, track, and analyze national trends in health care utilization, access, charges, quality, and outcomes. Background The Nationwide Inpatient Sample (NIS) is maintained by the Healthcare Cost and Utilization Project. The NIS is the largest all-payer inpatient care database in the United States. It contains data from approximately 8 million hospital stays each year. The 2009 NIS contains all discharge data from 1,050 hospitals located in 44 States, approximating a 20-percent stratified sample of U.S. community hospitals. The sampling frame for the 2009 NIS is a sample of hospitals that comprises approximately 95 percent of all hospital discharges in the United States. The NIS is the only national hospital database containing charge information on all patients, regardless of payer, including persons covered by Medicare, Medicaid, private insurance, and the uninsured. User functionality Users must pay to access the database. NIS releases for data years 1988-2009 are available from the HCUP Central Distributor. The 2009 NIS may be purchased for $50 for students and $350 for all others on a single DVD-ROM with accompanying documentation. . Data Notes NIS data are available from 1988 to 2009. The number of states in the NIS has grown from 8 in the first year to 44 at present. Beginning with the 2002 NIS, severity adjustment data elements including APR-DRGs, APS-DRGs, Disease Staging, and AHRQ Comorbidity Indicators, are available. Begi nning with the 2005 NIS, Diagnosis and Procedure Groups Files containing data elements from AHRQ software tools designed to facilitate the use of the ICD-9-CM diagnostic and procedure information are available. Beginning with the 2007 NIS, data elements describing hospital structural characteristics and provision of outpatient services are available in the Hospital Weights file. NIS Release 1 includes data from 8-11 States and spans the years 1988 to 1992. NIS Releases 2 and 3 contain data from 17 States for 1993 and 1994, respectively. NIS Releases 4 and 5 contain data from 19 States for 1995 and 1996. NIS Release 6 contains data from 22 States for 1997. NIS 1998 contains data from 22 States. NIS 1999 contains data from 24 States. NIS 2000 contains data from 28 States. NIS 2001 contains data from 33 States. NIS 2002 contains data from 35 States. NIS 2003 contains data from 37 States. NIS 2004 contains data from 37 States. NIS 2005 contains data from 37 States. NIS 2006 contains data from 38 States. NIS 2007 contains data from 40 States. NIS 2008 contains data from 42 States.

HCUPnet is an on-line query system that provides free, instant access to the largest set of all-payer health care databases that are publicly available. Using HCUPnet's easy step-by-step query system, you can generate tables and graphs on statistics and trends for acute care hospitals in the U.S. HCUPnet provides:  National and regional estimates for inpatient stays and emergency department visits;  State counts of inpatient stays and emergency department visits for those states that agreed to participate;  National estimates on readmissions and readmission rates;  County-level statistics on hospital use and potentially preventable admissions, based on the AHRQ Quality Indicators (QIs)* For most queries, detailed information is available for conditions and procedures (by ICD-9-CM codes and Clinical Classification Software), and for diagnosis related groups (DRGs). HCUPnet allows easy access to information from datasets that are part of the Healthcare Cost and Utilization Project (HCUP); details on obtaining these datasets are also available in www.healthdata.gov

Average costs of outpatient services.

On an annual basis (individual hospital fiscal year), individual hospitals and hospital systems report detailed facility-level data on services capacity, inpatient/outpatient utilization, patients, revenues and expenses by type and payer, balance sheet and income statement.

Due to the large size of the complete dataset, a selected set of data representing a wide range of commonly used data items, has been created that can be easily managed and downloaded. The selected data file includes general hospital information, utilization data by payer, revenue data by payer, expense data by natural expense category, financial ratios, and labor information.

There are two groups of data contained in this dataset: 1) Selected Data - Calendar Year: To make it easier to compare hospitals by year, hospital reports with report periods ending within a given calendar year are grouped together. The Pivot Tables for a specific calendar year are also found here. 2) Selected Data - Fiscal Year: Hospital reports with report periods ending within a given fiscal year (July-June) are grouped together.