Data on Hospitals

Map shows where hospitals are (or maps of doctors)
​Financial Data (below)
Quality measures and mixed incentives
Hospital closures
Readmission penalties or xls (6MB)
Biggest penalties (methods)
Previous data: Readmission Penalties (August 2013, 3 MB xls)
List of Accountable Care Organizations (many include hospitals)
Other Medicare data
Medicare Costs, Premiums, and Alternatives
People in the area served by each hospital must be described on the hospital's website, titled "Community Health Needs Assessment". In the examples below, change uclahealth.org or hopkinsmedicine.org to your hospital's website:
https://duckduckgo.com/?q="community+health+needs+assessment"+site:uclahealth.org
https://duckduckgo.com/?q="community+health+needs+assessment"+site:hopkinsmedicine.org

Hospital Financial Statements

​A slideshow describes different sources of information for non-profit, profit, and publicly owned hospitals, as of 2013.

A spreadsheet (5MB) shows each hospital's 2013 or 2014 financial statements, and many Medicare calculations at each hospital. It includes both Medicare and non-Medicare revenue and spending. It is compiled by Medicare to provide a context for Medicare spending in each hospital, and is called a "Medicare Cost Report"

The spreadsheet includes:

• Revenue from patients, investments, donations, and other
• Expenses for Salaries, Capital, major departments such as ICU, Operating room, Radiology, Emergency, Lab, Pharmacy, Administration, Building operation
• Chain membership, Ownership type, number of beds, number of Medicare patients, address, phone, latitude + longitude, date certified
• Medicare payments for Diagnostic groups, outliers, education,
• Several penalties: HAC, VBP, IQR, EHR, and readmissions.

The spreadsheet has brief labels; fuller explanations are in the original Medicare form and instructions. Chapter 40 of Medicare's manual has the form (R6P240f), including work sheets S (p.1),  A (p.22), E (p.84), and G (p.100). Chapter 40 also has the instructions (pr2_40, abbreviations are on pp.9-11), which can answer many questions about the entries on the form. The current format has been used since 2010, and other data are available back to 1995.

Another article shows helpful commands for the spreadsheet.

The source also has each hospital's occupancy rate for several departments: general, maternity, ICU, coronary care, burn, hospice, psychiatric, rehab, etc. These have not been put in this spreadsheet. If you would find the occupancy rates useful, please leave a comment below or send an email.

​Medicare offers online access and downloadable spreadsheets for 2014 and 2015, without breakdowns by department, ownership, latitude+longitude or penalties.

The original Medicare databases are available from 1995 to the present. They are far more complex than the spreadsheet, with 3 types of records, and millions of records, since every number and answer on each form has a separate record showing hospital-id, worksheet-code, line number, column number, and contents. For those who need it, a CMS documentation page has:

• record  counts,
  
• a spreadsheet of hospital-ids covered,
  
• layouts & worksheet-codes. 
  

The Medicare database averages 3,000 numeric records and 600 alpha records per hospital each year. 65 key items are in the spreadsheet, and others can be available if needed.

 Other Hospital Financial Data

Electronic Municipal Market Access (EMMA) has PDF copies of operating expense and audited financial statements for each hospital (or other facility), if it has outstanding tax-free bonds. Put hospital name in their search box, to list its past & present bonds. Click any bond which is still outstanding (on right), accept the disclosure, then click "Continuing Disclosure" to see annual and sometimes quarterly data. The data are similar to the spreadsheet above, but in PDF, often with more data from the past, but fewer hospitals.

Single Audit shows financial statements for many organizations which receive federal money. Formerly was: "Summary of audit findings and federal awards"  form a few pages long for each hospital showing checkoffs for any audit findings, and the amount of each federal grant spent during a year ("awards"); it does not cover Medicare or Medicaid, since these are exempt from the federal "single audit" rules. It also shows address, Employer ID number (EIN) and DUNS number. 

IRS form 990 for US nonprofit hospitals is available from AHCJ (search by name, place or person; just hospitals; other sources have many more non-profits, which can make hospitals harder to find), Open990 (2010 to present, downloadable spreadsheets) or Guidestar or Foundation Center or ProPublica or Charity Navigator, or CitizenAudit (full text search $350/yr). Form 990 shows total revenue and expense and highly paid staff (schedule J ) and contractors (VII-B). It also shows total received from Medicare and Medicaid in section VIII-2 "Revenue, Program Service," and several types of expenses in section IX, balance sheet in X, political spending in schedule C.

Canadian nonprofits (non-governmental organisations, NGOs) are listed, and some have financial information, at a government site:
apps.cra-arc.gc.ca/ebci/hacc/srch/pub/dsplyBscSrch