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

Hospitals' Experience

9/15/2020

0 Comments

 
If you want to find which hospitals have the most experience with each procedure, you need to download a spreadsheet of codes used at hospitals. These Diagnostic Related Groups (DRG) cover major types of hospital treatment. (or click for experienced doctors):
  1. Download and open the spreadsheet of codes used at hospitals, Globe1234.org/hosp.xlsx
  2. After it opens, click "Enable editing" at the top, if it asks
  3. Click the B at the top of column B to highlight the whole column of procedure names
  4. Press Ctrl and F at the same time, or click Home/Find, or View/Find, or Menu/Find
  5. Type a search word in the Find box, like knee, and click "Find All." Use up and down arrows to see all the choices in the file.
  6. Note the codes and search before and after them for related work. For example a search on "knee" gives 10 codes between 466 and 489. Looking at this range you will see 469 and 470 are "Major Joint Replacement Or Reattachment Of Lower Extremity." That covers knee and hip replacements even though they don't use either word.
  7. They use abbreviations such as: Exc-except, Mcc-major complications and comorbidities (defined here), Mv-mechanical Ventilation, Pdx-principal diagnosis, W-with, W/O-without
  8. Copy down any codes you want
 
Download a detailed file of hospitals' experience, the Inpatient Charge Data at:
cms.gov/Research-Statistics-Data-and-Systems/Statistics-Trends-and-Reports/Medicare-Provider-Charge-Data/Inpatient2014.html
  1. Download the latest Detailed Excel data on that page.
  2. Double-click the downloaded zip file.
  3. Double-click the xlsx file inside it.
  4. Save it so you don't have to download it again: Click File/Save As and put it somewhere you can find it, like the desktop.
  5. Near the top of column A, click the small triangle to see the choices in that column
  6. Unclick "Select All" or click "Clear"
  7. Click one or more categories you need, such as 469 and 470
  8. Click OK if asked
  9. At the top of Column i - Total Discharges, click the small triangle and click "Sort Largest to Smallest"
  10. Now the highest volume hospitals are at the top
  11. You can also see the average amount Medicare allowed for each procedure, and the average charges each hospital submitted for the procedure.  These costs do not include the doctor bills, which you would need to find on the Specialists page.
0 Comments



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
    Comfort Care
    Comment To Medicare
    Concierge
    Contact
    Correlations
    Costs
    Data
    Deaths
    Definitions
    Disaster
    Doctors
    Do Not Resuscitate
    Drug Interactions
    Drugs
    Ehr
    Electronic-records
    Emergency
    Ethics-guidance
    Excel
    Exclusions
    Financial
    Foia
    Foreign
    Fragile
    Hac
    Home Visits
    Hospice
    Hospital Data
    Hospital Lists
    Hospital Strategies
    Incentives
    IQR
    Kidney
    Life-expectancy
    Literacy
    Living Will
    Luxury
    Math
    Medical Devices
    Medicare Data
    Medicare Texts
    Medicare-texts
    Medpac
    Minorities
    Nursing Homes
    Odds
    Overview
    Pain
    Palliative Care
    Patient Strategies
    Payments
    Penalties
    Penalty Percent
    Premiums
    Preparedness
    Prescriptions
    Privacy Policy
    Public Comment
    Quality
    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