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
Services by state
Sample of 25 rows out of about 3,008,319
· 13 columns
| id | year | geo | state_fips | hcpcs | description | drug | place | clinicians | patients | services | avg_allowed | avg_paid |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6456007 | 2013 | US | No data | 00100 | Anesthesia for procedure on salivary gland with biopsy | N | F | 9678.0 | 8629.0 | 12419.0 | 228.00370239 | 180.74465496 |
| 6456008 | 2013 | US | No data | 00100 | Anesthesia for procedure on salivary gland with biopsy | N | O | 6.0 | 12.0 | 13.0 | 169.17538462 | 120.89538462 |
| 6456009 | 2013 | US | No data | 00102 | Anesthesia for procedure to repair lip defect present at birth | N | F | 66.0 | 58.0 | 74.0 | 193.43378378 | 152.90148649 |
| 6456010 | 2013 | US | No data | 00103 | Anesthesia for procedure on eyelid | N | F | 21988.0 | 94420.0 | 126633.0 | 150.98895256 | 118.80683716 |
| 6456011 | 2013 | US | No data | 00103 | Anesthesia for procedure on eyelid | N | O | 93.0 | 299.0 | 329.0 | 200.84656535 | 159.11638298 |
| 6456012 | 2013 | US | No data | 00104 | Anesthesia for electric shock treatment | N | F | 12483.0 | 12760.0 | 187916.0 | 75.28142271 | 59.326034984 |
| 6456013 | 2013 | US | No data | 00104 | Anesthesia for electric shock treatment | N | O | 29.0 | 26.0 | 104.0 | 80.859038462 | 64.206730769 |
| 6456014 | 2013 | US | No data | 00120 | Anesthesia for biopsy of external middle and inner ear | N | F | 13230.0 | 16193.0 | 23810.0 | 194.83037295 | 154.08470559 |
| 6456015 | 2013 | US | No data | 00124 | Anesthesia for examination and biopsy of external middle and inner ear using an endoscope | N | F | 1055.0 | 794.0 | 1148.0 | 95.537482578 | 73.875156794 |
| 6456016 | 2013 | US | No data | 00126 | Anesthesia for incision of ear drum | N | F | 7841.0 | 8598.0 | 12579.0 | 90.964935209 | 71.595319183 |
| 6456017 | 2013 | US | No data | 00140 | Anesthesia for procedure on eye | N | F | 23743.0 | 93745.0 | 139296.0 | 146.58655963 | 115.72309004 |
| 6456018 | 2013 | US | No data | 00140 | Anesthesia for procedure on eye | N | O | 59.0 | 103.0 | 125.0 | 172.03048 | 137.26424 |
| 6456019 | 2013 | US | No data | 00142 | Anesthesia for lens surgery | N | F | 41914.0 | 1106563.0 | 2111334.0 | 102.84489623 | 81.29801005 |
| 6456020 | 2013 | US | No data | 00142 | Anesthesia for lens surgery | N | O | 210.0 | 2001.0 | 2924.0 | 120.99144323 | 96.306692886 |
| 6456021 | 2013 | US | No data | 00144 | Anesthesia for procedure on eye for corneal transplant | N | F | 7888.0 | 17157.0 | 26514.0 | 172.09396885 | 135.60150223 |
| 6456022 | 2013 | US | No data | 00145 | Anesthesia for retinal surgery | N | F | 19529.0 | 84276.0 | 132825.0 | 171.16792102 | 135.48649569 |
| 6456023 | 2013 | US | No data | 00145 | Anesthesia for retinal surgery | N | O | 34.0 | 297.0 | 347.0 | 190.09023055 | 151.59786744 |
| 6456024 | 2013 | US | No data | 00147 | Anesthesia for procedure on eye for removal of iris | N | F | 437.0 | 709.0 | 989.0 | 128.78688574 | 101.47199191 |
| 6456025 | 2013 | US | No data | 00148 | Anesthesia for eye examination using an endoscope | N | F | 884.0 | 669.0 | 1105.0 | 102.6801086 | 79.49758371 |
| 6456026 | 2013 | US | No data | 0015F | Melan follow-up complete | N | O | 1.0 | 16.0 | 16.0 | 0.01 | 0.0 |
| 6456027 | 2013 | US | No data | 00160 | Anesthesia for procedure on nose and sinus | N | F | 30575.0 | 51773.0 | 74954.0 | 171.15190597 | 135.42308763 |
| 6456028 | 2013 | US | No data | 00160 | Anesthesia for procedure on nose and sinus | N | O | 52.0 | 319.0 | 326.0 | 184.82389571 | 145.64855828 |
| 6456029 | 2013 | US | No data | 00162 | Anesthesia for surgery of nose and sinus | N | F | 850.0 | 690.0 | 967.0 | 345.56031024 | 274.81224405 |
| 6456030 | 2013 | US | No data | 00164 | Anesthesia for soft tissue biopsy on nose and sinus | N | F | 265.0 | 284.0 | 338.0 | 131.46168639 | 103.71633136 |
| 6456031 | 2013 | US | No data | 00170 | Anesthesia for procedure on mouth including biopsy | N | F | 19220.0 | 23798.0 | 34559.0 | 160.69118262 | 124.57735988 |
Need the whole thing? Spreadsheet links, downloads, and AI access come with Level 3.
See pricing