Description
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.
Resources
| Name | Format | Description | Link |
|---|---|---|---|
| 2001 Quarter 4 - Sum of Four Quarters (Revised May 2007) | XLS | hospital-quarterly-sum-of-qtrs-2001q4r4-revised-507.xls | Open resource |
| 2005 Quarter 3 - Sum of Four Quarters | XLS | hospital-quarterly-sum-of-qtrs-2005q3r4.xls | Open resource |
| 2003 Quarter 4 - Sum of Four Quarters (Revised May 2007) | XLS | hospital-quarterly-sum-of-qtrs-2003q4r4-revised-507.xls | Open resource |
| Data Importing Instructions for Excel | Doc | Please note that this data contains fields with leading zeroes. In order to use this data with Microsoft Excel, you must save the file to your computer and then import the data. If you double-click on the .csv file and allow Excel to open the file automatically, the leading zeroes will disappear. | Open resource |
| 2011 Quarter 2 - Sum of Four Quarters | XLS | hospital-quarterly-sum-of-qtrs-2011q2r4.xls | Open resource |
| 2008 Quarter 1 - Sum of Four Quarters | XLS | hospital-quarterly-sum-of-qtrs-2008q1r4.xls | Open resource |
| 2004 Quarter 3 - Sum of Four Quarters | XLS | hospital-quarterly-sum-of-qtrs-2004q3r4.xls | Open resource |
| 2000 Quarter 4 - Sum of Four Quarters (Revised May 2007) | XLS | hospital-quarterly-sum-of-qtrs-2000q4r4-revised-507.xls | Open resource |
| 2004 Quarter 2 - Sum of Four Quarters | XLS | hospital-quarterly-sum-of-qtrs-2004q2r4.xls | Open resource |
| 1996 Quarter 4 - Sum of Four Quarters | CSV | hospital-quarterly-sum-of-qtrs-1996q4r4.csv | Open resource |
| 2005 Quarter 2 - Sum of Four Quarters | XLS | hospital-quarterly-sum-of-qtrs-2005q2r4.xls | Open resource |
| 2005 Quarter 4 - Sum of Four Quarters (Revised April 2008) | XLS | hospital-quarterly-sum-of-qtrs-2005q4r4-revised-408.xls | Open resource |
| 1998 Quarter 4 - Sum of Four Quarters | CSV | hospital-quarterly-sum-of-qtrs-1998q4r4.csv | Open resource |
| 2006 Quarter 2 - Sum of Four Quarters | XLS | hospital-quarterly-sum-of-qtrs-2006q2r4.xls | Open resource |
| 2008 Quarter 3 - Sum of Four Quarters | XLS | hospital-quarterly-sum-of-qtrs-2008q3r4.xls | Open resource |
| 2006 Quarter 1 - Sum of Four Quarters | XLS | hospital-quarterly-sum-of-qtrs-2006q1r4.xls | Open resource |
| 2008 Quarter 2 - Sum of Four Quarters | XLS | hospital-quarterly-sum-of-qtrs-2008q2r4.xls | Open resource |
| 2007 Quarter 4 - Sum of Four Quarters (Revised May 2010) | XLS | hospital-quarterly-sum-of-qtrs-2007q4r4-revised-510.xls | Open resource |
| 2010 Quarter 4 - Sum of Four Quarters (Revised October 2012) | XLS | hospital-quarterly-sum-of-qtrs-2010q4r4-revised-1012.xls | Open resource |
| 2007 Quarter 3 - Sum of Four Quarters | XLS | hospital-quarterly-sum-of-qtrs-2007q3r4.xls | Open resource |
| 2005 Quarter 1 - Sum of Four Quarters | XLS | hospital-quarterly-sum-of-qtrs-2005q1r4.xls | Open resource |
| 2004 Quarter 4 - Sum of Four Quarters (Revised May 2007) | XLS | hospital-quarterly-sum-of-qtrs-2004q4r4-revised-507.xls | Open resource |
| 2009 Quarter 2 - Sum of Four Quarters | XLS | hospital-quarterly-sum-of-qtrs-2009q2r4.xls | Open resource |
| 2010 Quarter 2 - Sum of Four Quarters | XLS | hospital-quarterly-sum-of-qtrs-2010q2r4.xls | Open resource |
| 2007 Quarter 2 - Sum of Four Quarters | XLS | hospital-quarterly-sum-of-qtrs-2007q2r4.xls | Open resource |
| 1996 Documentation - Sum of Four Quarters | hospital-quarterly-sum-of-qtrs-1996-documentation.pdf | Open resource | |
| 2010 Quarter 1 - Sum of Four Quarters | XLS | hospital-quarterly-sum-of-qtrs-2010q1r4.xls | Open resource |
| 2009 Quarter 3 - Sum of Four Quarters | XLS | hospital-quarterly-sum-of-qtrs-2009q3r4.xls | Open resource |
| 1999 Quarter 4 - Sum of Four Quarters | CSV | hospital-quarterly-sum-of-qtrs-1999q4r4.csv | Open resource |
| 1995 Quarter 4 - Sum of Four Quarters | CSV | hospital-quarterly-sum-of-qtrs-1995q4r4.csv | Open resource |
| 2006 Quarter 3 - Sum of Four Quarters | XLS | hospital-quarterly-sum-of-qtrs-2006q3r4.xls | Open resource |
| 2009 Quarter 1 - Sum of Four Quarters | XLS | hospital-quarterly-sum-of-qtrs-2009q1r4.xls | Open resource |
| 2006 Quarter 4 - Sum of Four Quarters (Revised May 2017) | XLS | hospital-quarterly-sum-of-qtrs-2006q4r4-revised-517.xls | Open resource |
| 2011 Quarter 3 - Sum of Four Quarters | XLS | hospital-quarterly-sum-of-qtrs-2011q3r4.xls | Open resource |
| 1997 Quarter 4 - Sum of Four Quarters | CSV | hospital-quarterly-sum-of-qtrs-1997q4r4.csv | Open resource |
| 2004 Quarter 1 - Sum of Four Quarters | XLS | hospital-quarterly-sum-of-qtrs-2004q1r4.xls | Open resource |
| 1995 Documentation - Sum of 4 Quarters | hospital-quarterly-sum-of-qtrs-1995-documentation.pdf | Open resource | |
| 2011 Quarter 4 - Sum of Four Quarters (Revised July 2015) | XLS | hospital-quarterly-sum-of-qtrs-2011q4r4-revised-715.xls | Open resource |
| All resource data | ZIP | pre-2012-hospital-quarterly-financial-utilization-report-sum-of-four-quarters-kmagiq.zip | Open resource |
| 2008 Quarter 4 - Sum of Four Quarters (Revised April 2011) | XLS | hospital-quarterly-sum-of-qtrs-2008q4r4-revised-411.xls | Open resource |
| 2011 Quarter 1 - Sum of Four Quarters (this is really one the other is Q4) | XLS | hospital-quarterly-sum-of-qtrs-2011q1r4.xls | Open resource |
| 2007 Quarter 1 - Sum of Four Quarters | XLS | hospital-quarterly-sum-of-qtrs-2007q1r4.xls | Open resource |
| 2002 Quarter 4 - Sum of Four Quarters (Revised May 2007) | XLS | hospital-quarterly-sum-of-qtrs-2002q4r4-revised-507.xls | Open resource |
| 2009 Quarter 4 - Sum of Four Quarters (Revised April 2011) | XLS | hospital-quarterly-sum-of-qtrs-2009q4r4-revised-411.xls | Open resource |
| 2010 Quarter 3 - Sum of Four Quarters | XLS | hospital-quarterly-sum-of-qtrs-2010q3r4.xls | Open resource |
| Post-2011 Hospital Quarterly Financial & Utilization Report - Sum of Four Quarters | HTML | Open resource | |
| Individual Facility Report Search (SIERA) | HTML | Financial Disclosure Report site, where you can view and save detailed financial disclosure reports submitted by California’s 450 hospitals and 1,200 long-term care facilities. | Open resource |