CMS Medicare Physician & Other Practitioners; Medicare Inpatient Hospitals
Medicare clinicians, services & hospital stays
Clinicians billing Medicare by county and specialty (office location), 2013 on — local doctor supply and how it's changing; every service code by state (how often, what Medicare pays); hospital stays by DRG and state (discharges, charges, payments). Totals only.
Published by CMS Medicare Physician & Other Practitioners; Medicare Inpatient Hospitals
Finest detail county
Tables 3
How we use this · on 1 desk
“Is this county losing doctors?”
Where you'll see it
- Region Brief: County dossier
- AI & Spreadsheets: at Level 3, link it into Excel or Google Sheets, download it, or ask your AI assistant about it
What we added
- Matched to the same county codes as every other source, so it lines up cleanly with all of them
- Every year kept since 2013, to show the trend
- Checked every day for a new release, and loaded when there is one
Hospital stays by state and DRG
Sample of 25 rows out of about 324,759
· 10 columns
| id | year | geo | state_fips | drg | description | discharges | avg_charges | avg_total_paid | avg_medicare_paid |
|---|---|---|---|---|---|---|---|---|---|
| 689500 | 2013 | US | No data | 001 | HEART TRANSPLANT OR IMPLANT OF HEART ASSIST SYSTEM WITH MCC | 1619.0 | 843946.20074 | 256885.02347 | 221367.29216 |
| 689501 | 2013 | US | No data | 002 | HEART TRANSPLANT OR IMPLANT OF HEART ASSIST SYSTEM WITHOUT MCC | 327.0 | 561456.54128 | 149336.74312 | 126796.96636 |
| 689502 | 2013 | US | No data | 003 | ECMO OR TRACHEOSTOMY WITH MV >96 HOURS OR PRINCIPAL DIAGNOSIS EXCEPT FACE, MOUTH AND NEC | 17208.0 | 496163.80486 | 139258.31561 | 126641.09042 |
| 689503 | 2013 | US | No data | 004 | TRACHEOSTOMY WITH MV >96 HOURS OR PRINCIPAL DIAGNOSIS EXCEPT FACE, MOUTH AND NECK WITHOU | 18880.0 | 291574.20742 | 80951.137341 | 73741.837553 |
| 689504 | 2013 | US | No data | 005 | LIVER TRANSPLANT WITH MCC OR INTESTINAL TRANSPLANT | 1010.0 | 472418.66733 | 123047.0 | 101519.26733 |
| 689505 | 2013 | US | No data | 006 | LIVER TRANSPLANT WITHOUT MCC | 345.0 | 270564.42899 | 58939.582609 | 38929.484058 |
| 689506 | 2013 | US | No data | 007 | LUNG TRANSPLANT | 553.0 | 459826.55515 | 111121.96383 | 83599.518987 |
| 689507 | 2013 | US | No data | 008 | SIMULTANEOUS PANCREAS AND KIDNEY TRANSPLANT | 435.0 | 370358.28736 | 67281.397701 | 41827.301149 |
| 689508 | 2013 | US | No data | 010 | PANCREAS TRANSPLANT | 65.0 | 246658.49231 | 66213.969231 | 35710.984615 |
| 689509 | 2013 | US | No data | 011 | TRACHEOSTOMY FOR FACE, MOUTH AND NECK DIAGNOSES OR LARYNGECTOMY WITH MCC | 1644.0 | 152967.59124 | 44791.209854 | 39280.319951 |
| 689510 | 2013 | US | No data | 012 | TRACHEOSTOMY FOR FACE, MOUTH AND NECK DIAGNOSES OR LARYNGECTOMY WITH CC | 1852.0 | 110438.03456 | 29794.146868 | 25460.591253 |
| 689511 | 2013 | US | No data | 013 | TRACHEOSTOMY FOR FACE, MOUTH AND NECK DIAGNOSES OR LARYNGECTOMY WITHOUT CC/MCC | 821.0 | 73094.226553 | 18468.764921 | 15004.816078 |
| 689512 | 2013 | US | No data | 014 | ALLOGENEIC BONE MARROW TRANSPLANT | 721.0 | 350564.1706 | 115225.04022 | 96127.837725 |
| 689513 | 2013 | US | No data | 016 | AUTOLOGOUS BONE MARROW TRANSPLANT WITH CC/MCC | 1760.0 | 191321.9733 | 60506.022159 | 49272.026705 |
| 689514 | 2013 | US | No data | 017 | AUTOLOGOUS BONE MARROW TRANSPLANT WITHOUT CC/MCC | 179.0 | 141955.15642 | 43655.726257 | 34802.977654 |
| 689515 | 2013 | US | No data | 020 | INTRACRANIAL VASCULAR PROCEDURES WITH PRINCIPAL DIAGNOSIS HEMORRHAGE WITH MCC | 1334.0 | 315799.14093 | 85543.448276 | 75897.374813 |
| 689516 | 2013 | US | No data | 021 | INTRACRANIAL VASCULAR PROCEDURES WITH PRINCIPAL DIAGNOSIS HEMORRHAGE WITH CC | 391.0 | 226162.97698 | 59256.296675 | 52250.519182 |
| 689517 | 2013 | US | No data | 022 | INTRACRANIAL VASCULAR PROCEDURES WITH PRINCIPAL DIAGNOSIS HEMORRHAGE WITHOUT CC/MCC | 111.0 | 158247.21622 | 39545.153153 | 33178.072072 |
| 689518 | 2013 | US | No data | 023 | CRANIOTOMY WITH MAJOR DEVICE IMPLANT OR ACUTE COMPLEX CNS PRINCIPAL DIAGNOSIS WITH MCC O | 5797.0 | 167965.20148 | 43937.677419 | 39201.887011 |
| 689519 | 2013 | US | No data | 024 | CRANIOTOMY WITH MAJOR DEVICE IMPLANT OR ACUTE COMPLEX CNS PRINCIPAL DIAGNOSIS WITHOUT MC | 1898.0 | 116488.19652 | 28829.029505 | 25171.255532 |
| 689520 | 2013 | US | No data | 025 | CRANIOTOMY AND ENDOVASCULAR INTRACRANIAL PROCEDURES WITH MCC | 17347.0 | 133755.4557 | 36491.505678 | 32523.524817 |
| 689521 | 2013 | US | No data | 026 | CRANIOTOMY AND ENDOVASCULAR INTRACRANIAL PROCEDURES WITH CC | 8982.0 | 94874.829437 | 24139.709864 | 20781.250835 |
| 689522 | 2013 | US | No data | 027 | CRANIOTOMY AND ENDOVASCULAR INTRACRANIAL PROCEDURES WITHOUT CC/MCC | 10949.0 | 75118.45237 | 18675.736597 | 15453.650562 |
| 689523 | 2013 | US | No data | 028 | SPINAL PROCEDURES WITH MCC | 2150.0 | 157078.46651 | 44803.322326 | 39753.047907 |
| 689524 | 2013 | US | No data | 029 | SPINAL PROCEDURES WITH CC OR SPINAL NEUROSTIMULATORS | 3890.0 | 92452.81054 | 24646.016452 | 20561.436504 |
Need the whole thing? Spreadsheet links, downloads, and AI access come with Level 3.
See pricing