Healthcare Information Division

Data Product Listings

Click the title of the report or product to navigate to the Web page where it is located.

Data/Information Product Description
California Perspectives in Healthcare County and statewide overview of healthcare facilities and services with demographic information; healthcare resource maps; hospitalization characteristics; and trends for selected conditions, procedures and injuries.
Healthcare Atlas, Interactive GIS Query System Interactive GIS mapping application using hospital and other health facility data including locations, financial and utilization reports, and patient-level summaries. Patient origin and market share maps can be created dynamically.
Ambulatory Surgery Profile Reports 15-day reports from the Data Warehouse. Queries by data type, facility ID number or facility name and reporting period begin and end dates.
Ambulatory Surgery CPT Code Frequencies Frequency of each Procedure Code is displayed as Total, Principal, and as each of 20 Other Procedure Codes.
Ambulatory Surgery ICD-9-CM Code Frequencies Tables with diagnosis codes, procedure codes, and external injury codes.
Ambulatory Surgery Public Dataset & Documentation Documentation only - users must order data on CD (ordering instructions).
Hospital Annual Financial Data Disclosure Report Individual reports are available in .pdf format beginning with report periods ending in 2002 and includes all data reported on the Hospital Annual Financial Disclosure Reporting Form.
Hospital Annual Financial Data Pivot Profiles Hospital annual financial data covering yearly report periods. Beginning 2004, file contains 5 worksheets - data, pivot table, profile, charts and glossary.
Hospital Annual Financial Data Subsets, Selected Data Selected set of data representing a wide range of commonly used data items.
Hospital Annual Financial Data Subsets, Selected Pages Data files in comma-delimited text format (.TXT) and Excel ZIP files, contain most of pages 0 through 9 for the stated report period.
Hospital Annual Financial Data, Complete Dataset & Documentation Contains all data fields from all Hospital Annual Financial Disclosure Reports submitted for a reporting cycle.  Product includes desk audited reports and OSHPD-completed fields.
Hospital Inpatient Case Mix Index Relative cost needed to treat patients each year.
Hospital Chargemasters Each hospital's prices of all services, goods and procedures for which a separate charge exists. Used to generate patient bill.
Common Surgery and Price Comparison Tool A new Web tool allowing healthcare consumers to view and compare the price of 28 common elective inpatient procedures at hospitals across California.
Community-Acquired Pneumonia Hospital Outcomes Report Comparative information on the performance of hospitals in caring for community-acquired pneumonia patients.
Coronary Artery Bypass Graft Hospital Outcomes Report Public disclosure of quality of care provided by hospitals and surgeons (every other report) performing coronary artery bypass graft (CABG) surgery. Early reports were voluntary and not inclusive of all hospitals.
Emergency Department CPT Code Frequencies Frequency of each Procedure Code is displayed as Total, Principal, and as each of the 20 Other Procedure Codes.
Emergency Department Encounters Hospital listing of number of ED encounters. Includes admissions via ED.
Emergency Department ICD-9-CM Code Frequencies Diagnosis codes, procedure codes, and external injury codes.
Emergency Department Profile Reports 15-day reports from the Data warehouse. Queries by data type, facility ID number or facility name and report period begin and end dates.
Emergency Department Public Dataset & Documentation Documentation only - users must order data on CD (ordering instructions).
Emergency Department Top Ten Causes of Injury Statewide listing of the top ten principal external cause of injury codes reported by Emergency Departments from encounters not resulting in hospital admission.
Emergency Department Top Ten Diagnosis and Procedure Groups Statewide listing of top ten principal diagnosis codes reported by Emergency Departments. Includes listing of the principal diagnosis groups (based on ICD-9-CM codebook chapters). This data is only from ED encounters that did not result in a hospital admission.
California Intensive Care Outcomes Report Voluntary program developed by OSHPD & UCSF to investigate feasibility of public reporting for ICU mortality. Participating hospitals collected detailed clinical data on subset of adult ICU patients & received feedback on data quality. Risk models were constructed & compared to provide risk-adjusted mortality rates and information on processes of care to participants.
Heart Attack Hospital Outcomes Report Report on AMIs w/3-vol.user's guide describing background/methods used.
Hospital Community Benefit Plans Excel file of hospitals required to submit a community benefit plan. Contains facility number, name, parent company, fiscal year-end, report due date, date received, and extended due date, if applicable. Individual plans available on request (ordering instructions).
Hospital Fair Pricing Policy Search Offers people the ability to search for free or discounted hospital care. California law requires every hospital to offer reduced rates to many uninsured and underinsured patients that are low- and moderate-income, and to have policies about who qualifies for free care.
Hospital Utilization Complete Data Basic licensing information: bed classifications; patient demographics; occupancy rates, number of discharges and patient days by bed classification, and the number of live births; as well as information on the type of services provided including the number of surgical operating rooms, number of surgeries performed (both inpatient and outpatient), the number of cardiovascular procedures performed, and licensed emergency medical services provided.
Hospital Utilization EMS Pivot Profiles Data from Annual Utilization Reports with 3 years of trend data and charts showing the EMS visits and percent admitted; visits by type; and emergency department closures with accompanying ambulance diversion hours.
Hospital Utilization Pivot Profiles Basic licensing information: bed classifications; patient demographics; occupancy rates, number of discharges and patient days by bed classification, and the number of live births; as well as information on the type of services provided including the number of surgical operating rooms, number of surgeries performed (both inpatient and outpatient), the number of cardiovascular procedures performed, and licensed emergency medical services provided.
Hospital Utilization Data, Report Search (ALIRTS) Takes the user directly to the ALIRTS site.
Hospital Utilization Trends Longitudinal utilization information. Includes information on patient services provided (by bed classification); hospital demographics, surgical and other patient services, as well as information on emergency medical services provided.
Inpatient Discharges, County Frequencies Discharges by Diagnostic categories and groups, gender, race, source of payment and admission etc.
Inpatient ICD-9-CM Code Frequencies Discharges by Diagnostic categories and groups, gender, race, source of payment and admission etc.
Inpatient Profile Reports Tables with Diagnoses, Present On Admission, External Causes and Procedures.
Inpatient Volume & Utilization Quality Indicators 11 Inpatient Quality Indicators organized by County and Hospital.
Patient Discharge Pivot Tables Patient discharge data aggregated at the hospital level displaying number and percent of discharges by various data elements available in the public file.
Patient Origin & Market Share Pivot Tables Origin of patients by ZIP Code for selected hospital as well as hospitals that patients from a selected ZIP Code or county go to for treatment.
Hospital Inpatient Public Dataset & Documentation Documentation only - users must order data on CD (ordering instructions).
Quarterly Financial Data, Complete Dataset Complete database containing all data reported by hospitals. Beginning in year 2000, the individual quarters are combined into one rolling 4th quarter file. Once the 4th quarter of the current year is posted, then the prior year quarters are rolled into one spreadsheet file for that year.
Quarterly Financial Data, Profile Characteristics Web-based query system that enables individuals to customize a report using Hospital Quarterly Financial and Utilization data.
Quarterly Financial Data, Report Search Allows a user to view an individual report immediately after it has been submitted by the hospital. This query system provides facsimiles of individual hospital quarterly reports.
Racial & Ethnic Disparities in Healthcare Report assessing racial and ethnic healthcare disparities using data collected by OSHPD. The three sections are: Preventable Hospital Admission; Mortality Following Hospitalization; and Use of Invasive Cardiovascular Procedures.
Research Brief - Mortality in California Hospitals, 2006 In-hospital mortality rates, top 5 admitting diagnoses of patients that die in-hospital, end-of-life preferences, conditions associated with higher mortality rates and factors that most strongly predict death.
Top 25 DRG Pivot Tables Patient discharge data file aggregated at the hospital level showing: Number of discharges; Average length of stay; Average charge per stay.
AHRQ Indicators for California - Inpatient Mortality Indicators  Quality of care inside hospitals excluding inpatient mortality for medical conditions and surgical procedures.
Benchmark DRG Pivot Tables Uses statewide Top 25 Diagnosis Related Groups (DRGs) as benchmarks and displays the total number of discharges, average charge per stay for the selected hospital and average charge per stay statewide.
Long-Term Care Facility Annual Financial, Complete Dataset & Documentation Documentation only - users must order data on CD (ordering instructions). Contains desk-audited data collected from all skilled nursing, intermediate care, intermediate care/developmentally disabled and congregate living health facilities.
Long-Term Care Facility Annual Financial Data, Pivot Profiles Developed using the long-term care annual financial data, users can choose a specific facility or county, or create a custom aggregation.
Long-Term Care Facility Annual Financial Data, Selected Data Basic facility demographics, financial statement items, utilization data and labor information.
Long-Term Care Facility Utilization Data, Complete Data Information on ownership and bed classification as well as patient demographics including age, gender, patient days, and census by payer categories.
Long-Term Care Facility Utilization Data, Pivot Profiles Information on ownership and bed classification as well as patient demographics including age, gender, patient days, and census by payer categories.
Primary Care Clinics Utilization Data, Complete Database Information including community services, clinic staffing data, and patient and staff language data; financial information including gross revenue, itemized write-offs by program, an income statement, and selected capital project items; and information on encounters by service, principal diagnosis, and procedure codes.
Primary Care Clinics Utilization Data, Pivot Profiles Information including community services, clinic staffing data, and patient and staff language data; financial information including gross revenue, itemized write-offs by program, an income statement, and selected capital project items; and information on encounters by service, principal diagnosis, and procedure codes.
Primary Care Clinics Utilization Data, Report Search (ALIRTS) Takes the user directly to the ALIRTS site.
Primary Care Clinics Utilization Data, Trends Longitudinal utilization information including information on number of: clinics by type; patients (by race, ethnicity, gender and age); encounters by payer source; and revenues by payer source including the average revenue per encounter.
Specialty Care Clinics Utilization Data, Complete Database Basic information including the number of: surgical operating rooms; surgeries performed; patients; encounters by service type; and major capital expenditures.
Specialty Care Clinics Utilization Data, Report Search (ALIRTS) Takes the user directly to the ALIRTS site.
Home Health & Hospice Utilization Data, Complete Database Information on visits, services provided, and gross revenues.
Home Health & Hospice Utilization Data, Report Search (ALIRTS) Takes the user directly to the ALIRTS site.
Home Health & Hospice Utilization Trends Information on the number of agencies and patients by ownership as well as the number of visits by principal diagnosis and payer source
Page last revised: September 19, 2012 3:49 PM