Globe1234
  • HOME
  • Specialists
  • Medicare
  • Salt etc.
  • More

Data on Hospitals

11/5/2020

2 Comments

 
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

2 Comments
Shail Patel link
8/1/2018 01:22:32 pm

Hello,

Do you have Financial data for hospitals and health insurance companies for FY2016-17. I do see that you have for hospital for 13-14. Also, is there any where I can find type of ACO and hospitals and payer associated to that particular ACO? Thanks a lot.

Reply
Paul link
2/12/2019 01:01:40 pm

The Medicare site I give as the source has recent data, but i have not compiled it. I do not know of a site showing hospitals connected to ACOs in general. Most ACOs identify hospital(s) on the ACO website. If not, a few doctor members can be looked up on PhysicianCompare to see which hospitals they use.

Reply



Leave a Reply.

    This site does not provide
    legal or medical advice.

    The site does not
    recommend doctors,
    hospitals or anyone. It
    summarizes information,
    mostly from Medicare, so
    you can decide.


    Dates are assigned
    arbitrarily to sort
    the articles.
     Most
    articles have been
    written or updated
    more recently.


    Like: Facebook, Twitter,
    Google+1
    , Reddit

    Pages

    All
    0verview
    1-updates
    About
    Accountable Care Org
    Aco
    Advance Directives
    Advocates
    Alternatives
    App
    Assisted Living
    Boards
    Citations
    Climate
    Comfort Care
    Comment To Medicare
    Concierge
    Contact
    Correlations
    Costs
    Courts
    Data
    Deaths
    Definitions
    Dentists
    Disaster
    Doctors
    Do Not Resuscitate
    Drug Interactions
    Drugs
    Ehr
    Electronic-records
    Emergency
    Ethics-guidance
    Excel
    Exclusions
    Financial
    Foia
    Foreign
    Fragile
    Hac
    Heart Failure
    Home Visits
    Hospice
    Hospital Data
    Hospital Lists
    Hospital Strategies
    Incentives
    IQR
    Kidney
    Lawyers
    Life-expectancy
    Literacy
    Living Will
    Luxury
    Math
    Medical Devices
    Medicare Advantage
    Medicare Data
    Medicare Texts
    Medicare-texts
    Medpac
    Minorities
    Nursing Homes
    Odds
    Overview
    Pain
    Palliative Care
    Part C
    Patient Strategies
    Payments
    Penalties
    Penalty Percent
    Premiums
    Preparedness
    Prescriptions
    Prices
    Privacy Policy
    Public Comment
    Quality
    Readability
    Readmissions
    Reducing Costs
    Referral
    Representative
    Research
    Short Comments
    Sources
    Statistics
    Submissions
    Subsidies
    Telehealth
    Timing Of Penalties
    Tourism
    Vbp
    Waivers

    RSS Feed

Picture
  • HOME
  • Specialists
  • Medicare
  • Salt etc.
  • More