Help
Data dictionary
What each term and column means, the codes behind every procedure, and how often each source is refreshed.
Terms you will meet
- Reported and estimated
Medicare fee-for-service is reported: CMS’s own count of patients on traditional Medicare. Fee-for-service alone falls as patients move to Medicare Advantage, so its trend understates the market.
All Medicare is estimated: Fee-for-service plus Medicare Advantage patients at each state's enrollment share. All payers is estimated too: Medicare scaled by its share of the procedure nationally: commercial, Medicaid and other patients added. An estimate is always labelled (“est.”, “all”, or a range) and never replaces the reported count.
For you: Rank on the reported count; size a market or an account with the estimate. Quote a surgeon’s own figures only as Medicare.
- CMS's under-11 rule
- CMS leaves out any surgeon, code and year with fewer than 11 patients, to protect privacy.
- A blank is “none, or under 11”, not zero.
- MedaRep estimates the missing cases from the state totals CMS does publish and shows them as “+~N est.” under the reported count, placed with the surgeons most likely to hold them.
For you: A surgeon with a small count, or none, may still operate here: check their practice and hospitals before writing them off.
- Payment depth
The deepest kind of engagement a company reported with a surgeon for these products in Open Payments, which says more than the dollar total. A surgeon’s main company is the one with the most reported engagement (Open Payments dollars) for these products in a program year, over $500.
- none: No payment for these products in Open Payments: no visible tie to any company.
- hospitality: Meals, travel or education only. A courtesy, not a commitment: the surgeon may be open to a conversation.
- speaker: Speaking or teaching for the company: a closer working relationship, and may be less likely to change.
- consulting: Consulting: a sign of a working relationship with the company.
- royalty: Royalties or licence fees: often a sign of design work on a product. The deepest tie, and the least likely to change.
For you: Consider starting with the surgeons at none or hospitality. Open Payments shows the payments companies reported. It suggests engagement, not which devices a surgeon uses, and is not evidence of wrongdoing. Payments are never something to raise with them.
- Employment model
How the surgeon’s practice is run, from Medicare enrollment, NPPES and hospital ownership records. It says who decides on product:
- Independent group: surgeon-led: the group decides, and implant economics are theirs.
- Solo: single decision-maker.
- Health-system employed: committee-gated: surgeon preference feeds a value-analysis process.
- Academic: department-gated: chair, residents, and research ties shape adoption.
- Not a practice: the record is a therapy, imaging, anesthesia or staffing company, not a surgical practice.
- Unknown: not enough public evidence to say.
For you: With an independent group, sell to the surgeons; with a health system, plan for value analysis and the contract as well as the surgeon.
- Engagement moved
- Engagement moved: a different main company (the one most engaged with them) in the latest payment year than the year before. Engagement moved; the earlier company may still call on them, and it does not show device use.
- Engagement may move: a model trained on past changes scores the chance of one next year.
- With your lines on your account: engagement moving to your company reads Engagement moved to you, away from it Engagement moved away, and a high chance of a change away from you Retention risk.
For you: A surgeon whose engagement just moved may still be settling in: consider calling the ones whose engagement moved away from a competitor, and checking in with the ones marked Retention risk.
- Warm paths
The warmest way from one of your customers to a target, from public records only, strongest first:
- Partners in the same group (strong in a group of up to 10, or the same office).
- Former partners.
- The same hospital (real at a small one, weak at a large one).
- The same company’s faculty or speaker bureau.
No public file records referrals, so a path suggests who knows whom.
For you: Ask the customer at the start of the path for an introduction before you cold-call the surgeon at its end.
- Trend
- A surgeon’s yearly change in Medicare cases over 3 years.
- Their county’s shift to Medicare Advantage is removed first: it otherwise looks like a decline in every growing market.
- Growth or decline is called only on 20 or more cases and a change of 15% or more; anything smaller reads as steady.
For you: A growing surgeon is adding cases someone will supply: be early.
- Forecasts
- CMS publishes about two years late.
- A model trained on every surgeon’s billing history forecasts each surgeon’s cases for the years since; a second scores the chance they stop billing Medicare here.
- Every forecast comes with a range from its measured error: treat the range, not the point, as the claim.
- How they are built and tested is on the about page.
For you: Use the forecast to plan this year’s calls, and the reported years to talk about the past.
- MS-DRG, MCC and CC
A hospital is paid for an inpatient stay by its Medicare Severity Diagnosis Related Group: the main operation (or diagnosis), split by how sick the patient was.
- With MCC: the stay had a major complication or comorbidity (MCC), a secondary diagnosis on CMS's MCC list, such as acute respiratory failure or sepsis.
- With CC: the stay had a complication or comorbidity (CC), none of them major.
- Without CC/MCC: neither a complication nor a comorbidity on CMS's lists.
- The operations are the same in each half of a pair, so 469 and 470 together are the hospital’s hip and knee replacements.
- CMS renumbers DRGs every October; the families list old and new numbers, and each one below says when it started or stopped (MS-DRG v44.0, in use from October 2026).
- A DRG can hold more than one family’s procedures: 469 and 470 count hips and knees together. Such a DRG is marked shared, and its count is the same number on each family, so never add the families’ DRG counts together.
- The CPT counts on a surgeon are the family-only view.
For you: Add the with- and without-MCC halves together for a hospital’s volume. A high MCC share points to a trauma or referral centre, where sicker patients mean longer stays and more implants per case.
- All-payer cases (New York)
New York publishes, free, every hospital’s inpatient stays from every payer, by procedure: its SPARCS de-identified discharge file. MedaRep has it for New York only.
- Counting: each stay by its principal procedure, in the state’s procedure categories (AHRQ’s CCSR), each read for the families below. One category can serve two families (spine fusion is lumbar and cervical together).
- Payers: Medicare (traditional and Medicare Advantage together), Commercial (Blue Cross and private insurance), Medicaid (including its managed care), and Other and self-pay.
- Campuses: those CMS certifies under one number are counted together.
- Small counts: none of 10 or fewer is shown, nor one that could be worked out from the others.
Source: New York State Department of Health, SPARCS de-identified inpatient discharges (health.data.ny.gov). The New York State Department of Health makes no representation, warranty or guarantee relating to the data or analyses derived from these data.
For you: Beside a New York hospital’s Medicare figures, this is its whole book of business: rank accounts on it for an under-65 procedure (spine, trauma, bariatric), and lead with a premium product where the commercial share is high.
- Why now
Reasons to call a surgeon this week, each a fact MedaRep holds, strongest first:
- Engagement moved: The company most engaged with them for these products changed in the latest Open Payments year.
- Engagement may move: The model puts the chance that the company most engaged with them changes next year well above average, with its reasons.
- Possible disruption (FDA recall): FDA posted a recall in the last 120 days on products of a company engaged with them for these products, weighed by its class and size: a possible disruption of supply or service. Consider asking how their supply and service have been, without raising the recall.
- Practice change: A move or a new practice in the last 12 months, from the Medicare enrollment snapshots.
- Partner left the group: A partner in the same specialty left their group of 2 to 5 in the last 12 months, from the Medicare enrollment snapshots. In groups this small the partners who stay have tended to pick up about 3% more of the family the next year than forecast (2021-2024 back-test).
- New surgeon: A fellow who stayed or a surgeon who joined a group, not in CMS's claims files yet.
- Volume surge: Medicare cases up 25% or more on a real base.
- Latest CMS count: CMS's clinician count for the latest 12 months it has processed (what Medicare.gov shows on their profile), read against their latest Medicare claims: new to a procedure (no claims in three years and none estimated under the floor), busier or slower by half or more, or few or none. Months behind, where the claims run two years behind; the 14 procedure groups CMS counts.
- TEAM hospital: Operates at a hospital in CMS's Transforming Episode Accountability Model (TEAM), mandatory in selected areas from January 2026: the hospital answers for the total Medicare cost of joint replacement, hip fracture, spinal fusion and major bowel episodes through 30 days after discharge, so it may weigh length of stay, setting and readmissions beside the implant price. From CMS's participant list (refreshed quarterly).
- Moving to surgery centers: Did 11 or more Medicare cases in the latest claims year on procedures CMS's outpatient rules have since added to the list a surgery center can bill (the CY2026 and CY2027 OPPS/ASC final rules, which also took them off the inpatient-only list): some of those cases may leave the hospital.
- Prior authorization (WISeR): Among the 25 busiest surgeons in a territory in Arizona, New Jersey, Ohio, Oklahoma, Texas or Washington, in a family with services in CMS's WISeR model (spinal cord stimulator leads, knee arthroscopy for osteoarthritis, cervical fusion, vertebral augmentation, hypoglossal and vagus nerve stimulators, incontinence devices and sacral nerve stimulation, penile prostheses, skin substitutes): Original Medicare needs prior authorization for those cases from 2026-01-15 through 2031. From CMS's operational guide, Appendix A.
- New to Medicare: On CMS's list of first-time Medicare enrollments still being processed (updated about twice a week), and in the territory by NPPES with a specialty for its procedures: new here, before any claim shows them.
- Hospital changed owners: Operates at a hospital that changed owners in the last 18 months, from CMS's quarterly change-of-ownership list: new owners often revisit contracts and value analysis.
- In CMS's specialty model: In CMS's Ambulatory Specialty Model from 2027, low back pain (spine and pain procedures) or heart failure (cardiac devices): part of the clinician's Medicare pay follows the cost and outcomes of those patients.
- Moved into the office: 40% or more of a procedure's Medicare cases billed in their own office, up 25 points or more in 3 years: most likely an office-based lab, where the surgeon buys the devices on cost.
- Stimulator trials: Spinal cord stimulation: about 10 or more stimulator trials in the latest Medicare year, either up 25% or more on the year before or with few permanent implants of their own. Trials are estimated from lead claims (two leads a placement, less the leads of their own percutaneous implants). The system is chosen at the trial.
- Customer's partner: In a group now with one of your customers: the land-and-expand call.
- Likely incumbent's FDA clearance: The company most engaged with them for these products got a new device cleared or approved by FDA recently: a new entrant, a new system or a line extension.
- Looks like your customers: Fits the pattern of your customers: where they operate, how they are employed, how busy they are, who engages them.
- In the news: This week's news for the territory names them or their practice.
- Trial gone quiet: You marked them trialing, and no visit is logged in 21 days.
- Competitor account, worth a call: You marked them on a competitor, and a reason above may make them open to a conversation: a likely change of company, a recall that may disrupt supply, a move, a company change, a new office or a new product.
- Worth reconnecting: You marked them lost, and a reason above may make them open to a conversation again.
- Room to grow: Your customer in this segment, at some or about half of their cases by your own mark, with 20 or more Medicare cases here.
- Customer gone quiet: Your customer (using us), with no visit logged in 60 days.
- Worth checking in: Your customer (using us), with a reason above that they may leave: a likely change of company, a move or a new office of their own. The share you set says what is at stake.
For you: Work through the list on a Friday, when there is time to look into each surgeon, and plan next week’s calls top down; the Friday email sends the same list. More in Why now.
Codes by procedure
Each procedure family is a fixed set of billing codes:
- The CPT and HCPCS codes the surgeon bills (CMS’s physician files).
- The MS-DRGs the hospital bills for an inpatient stay.
- The APCs an outpatient department is paid under.
- The FDA product codes its devices are cleared under.
The numbers are listed here, so a code can be found on this page; open a family for what each code is.
Spine & neurosurgery
- Lumbar fusion22612 22630 22633 22558 · beside a case 22614 22853 22840 22842 · DRG 453 454 455 459 460 402 426 427 428 447 448 450 451 523 524 525 · FDA KWP KWQ MAX MBP MNH MNI MPW MQP MQV NKB OVD PEK PML
- Cervical fusion & disc arthroplasty22551 22600 22856 · beside a case 22552 22845 22858 · DRG 471 472 473 429 430 · FDA KWP KWQ MJO NKG ODP OVE PLR
- Decompression & minimally invasive spine63030 63047 63020 63045 22867 · beside a case 63048 · DRG 518 519 520 · FDA NQO PEK
- Kyphoplasty & vertebroplasty22513 22514 22510 22511 · beside a case 22515 · FDA NDN OBL OBM
- SI joint fusion27279 27280 0775T 27278 · FDA OUR
Biologics & wound care
- Skin substitutes & wound grafts15271 15273 15275 15277 · beside a case 15272 15274 15276 15278 · FDA FRO KGN MDD MGP MGQ MGR
- Debridement & negative-pressure wound therapy11042 11043 11044 97597 97605 97606 97607 97608 · beside a case 97598 · DRG 463 464 465 · FDA OKO OMP QFC QPX
- Bone graft & orthobiologics20930 20931 20936 20937 20938 20939 · FDA MBP MPW MQV NEK
Pain & neuromodulation
- Spinal cord & DRG stimulation63685 · beside a case 63650 63655 63688 · FDA GZB LGW
- Radiofrequency ablation (facet, genicular, basivertebral)64635 64633 64624 64625 64628 · beside a case 64636 64634 64629 · FDA GXD GXI
- Peripheral nerve stimulation & intrathecal pumps64555 64590 62362 62350 · FDA GZF LKK
Cardiac rhythm & electrophysiology
- Pacemaker, ICD & CRT implantation33206 33207 33208 33274 33249 33270 33262 33263 33264 · beside a case 33225 · DRG 242 243 244 226 227 275 276 277 · FDA DTB DXY LWP LWS MRM NIK NKE NVN NVY PNJ
- EP ablation93656 93653 93654 · DRG 273 274 317 · FDA LPB OAD OAE QZI
- LAA occlusion & loop recorders33340 33285 · DRG 273 274 317 · FDA MXD NGV
Interventional & structural cardiology
- Coronary intervention (PCI)92920 92928 92933 92937 92941 92943 · beside a case 92978 · DRG 246 247 248 249 321 322 323 324 325 318 359 360 · FDA LOX MAF NIQ
- Structural heart (TAVR, TEER)33361 33362 33363 33364 33365 33366 33418 33419 · DRG 266 267 · FDA DYE NKM NPT
- PFO & septal closure93580 · FDA MLV
- Mechanical circulatory support33990 33991 33995 33967 33970 · DRG 268 269 · FDA DSP DSQ
Vascular & endovascular
- Peripheral arterial intervention37220 37221 37224 37225 37226 37227 37228 37229 37230 37231 · DRG 252 253 254 · FDA LIT MCW NIO NIP PRC
- Aortic endografts (EVAR/TEVAR)34701 34702 34703 34704 34705 34706 33880 33881 · DRG 268 269 213 209 · FDA MIH
- Carotid revascularization35301 37215 · FDA NIM
- Superficial venous ablation36475 36478 36482 · beside a case 36483 · FDA PJQ
- Thrombectomy, IVC filters & venous stents37187 37184 37191 37238 · FDA DTK NRY QAN
- Dialysis access36821 36830 36902 36903 36905 36906 36818 36819 · FDA DSY DYF
Neurovascular & neurosurgical devices
- Stroke thrombectomy61645 · DRG 023 024 · FDA POL
- Aneurysm & intracranial embolization61624 61635 61630 · FDA HCG KGG NPE OUT
- DBS & VNS61863 61867 61885 61886 64568 · DRG 040 041 042 · FDA LYJ MHY NHL PFN
- CSF shunts62223 62230 · FDA JXG
General & bariatric surgery
- Hernia repair49505 49650 49651 49560 49561 49565 49566 49570 49572 49585 49587 49590 49652 49653 49654 49655 49656 49657 49591 49592 49593 49594 49595 49596 49613 49614 49615 49616 49617 49618 49621 49622 · DRG 353 354 355 · FDA FTL FTM OWT
- Bariatric surgery43644 43775 43770 · DRG 619 620 621 · FDA GAG GDW
- Antireflux & hiatal hernia surgery43280 43281 43282 · DRG 326 327 328 · FDA GAG GDW
- Colorectal resection44204 44205 44207 44140 44145 44160 45395 45397 · DRG 329 330 331 · FDA GAG GDW NAY
- Cholecystectomy & appendectomy47562 47563 44970 47600 · DRG 417 418 419 338 339 340 397 398 399 · FDA GAG GCJ GDW
- Breast reconstruction19357 19340 19342 19364 19380 · FDA FTR FWM
Urology & women's health
- BPH procedures52601 52648 52649 52441 52442 53854 55874 · FDA MER NOY NZC OEJ OEK OEL PEW QKA QXB
- Prostatectomy & nephrectomy55866 50543 50545 50546 50548 · DRG 707 708 656 657 658 · FDA NAY
- Kidney stone management52356 52353 52352 50590 50080 50081 · FDA FGB LNS
- Incontinence, prolapse & sacral neuromodulation57288 53440 53445 57425 57282 57283 64581 64590 54405 · FDA EZW EZY FAE FAG OTN OTO OTP PAI PAJ
- Hysterectomy, hysteroscopy & ablation58571 58573 58558 58563 58353 58356 58661 58662 · FDA HIH MNB
ENT & sleep
- Sinus surgery & balloon dilation31295 31296 31297 31298 31255 31267 31276 31287 31288 31237 · FDA OWO
- Cochlear implants69930 · FDA MCM
- Ear tubes & middle ear surgery69436 69631 69633 69641 · FDA ETA ETD
- Sleep apnea & airway implants64582 64583 64584 42145 41530 · FDA MNQ
Ophthalmology
- Cataract & MIGS66984 66982 66989 66991 66987 66988 65820 66174 66183 0671T 0449T · FDA HQC HQL KYF OGO
- Vitreoretinal surgery67036 67040 67041 67042 67108 67113 · FDA HQE
GI & pulmonary endoscopy
- Colonoscopy & upper endoscopy45378 45380 45385 45390 43239 43235 43251 · FDA FDF FDS
- ERCP & endoscopic ultrasound43264 43274 43260 43259 43242 43266 · FDA FDT
- Bronchoscopy & lung nodule31652 31653 31628 31647 32663 · beside a case 31627 · FDA EOQ
Interventional oncology & breast
- Tumor ablation47382 47383 50592 50593 32998 20982 20983 · FDA GEH NEY
- Tumor & fibroid embolization37243 · FDA KRD QVG
- Breast biopsy & localization19081 19083 19085 19281 19283 19285 · FDA NEU PDW POY PXP
Diabetes & referred DME
- CGM & insulin pump management95249 95250 95251 · FDA LZG MDS OYC OZO OZP OZQ QBJ QFG QJS QLG SFI
Referred equipment (Who orders it)
Equipment and supplies a clinician orders and a supplier bills (CMS’s DMEPOS file by referring provider), counted by HCPCS Level II code. The referring clinician is the account for these reps.
- Knee bracesL1810–L1860
- Spinal orthosesL0112–L0651
Cervical collars through TLSOs.
- Ankle-foot orthoses & walking bootsL1900–L2999, L4350–L4398
- Shoulder, elbow, wrist & hand orthosesL3650–L3999
- Bone growth stimulatorsE0747, E0748, E0749, E0760
Spinal (E0748) and non-spinal electrical and ultrasonic stimulators, ordered after fusion or for non-union.
- Continuous glucose monitorsA9276–A9278, K0553, K0554, E2102, E2103, A4238, A4239
- Insulin pumps & suppliesA4224–A4232, E0784, E0787, A9274
- Diabetic shoes & insertsA5500–A5514
- Negative-pressure wound therapyE2402, A6550, A9272, K0743–K0746
- Surgical dressingsA6010–A6530
- Pneumatic compression & lymphedema garmentsE0650–E0676, A6531–A6549
- CPAP & sleep therapyE0601, E0470, E0471, E0561, E0562, A7027–A7039, A7044–A7046
- CPM & cold therapyE0935, E0936, E0218, E0217, E0236
Continuous passive motion and water-circulating cold therapy after joint surgery.
Sources, refresh and lag
Every figure is shown with the year it describes. Public files lag, so the newest year is rarely this one. Publishers and uses are on the data sources page.
- Medicare Physician & Other Practitioners, by Provider and Service; by Provider; by Geography and Service · CMS
- Refresh
- Once a year, when CMS publishes the year
- Lag
- Newest year 2024: about 2 years behind
- Physician/Supplier Procedure Summary (PSPS) · CMS
- Refresh
- Once a year, when CMS publishes the year
- Lag
- Newest year 2025: about 1 year behind
- Medicare Inpatient and Outpatient Hospitals, by Provider and Service · CMS
- Refresh
- Once a year, when CMS publishes the year
- Lag
- Newest year 2024: about 2 years behind
- Medicare Durable Medical Equipment, Devices & Supplies, by Referring Provider and Service · CMS
- Refresh
- Once a year, when CMS publishes the year
- Lag
- Newest year 2024: about 2 years behind
- Medicare Part D Prescribers, by Provider and Drug · CMS
- Refresh
- Once a year, when CMS publishes the year
- Lag
- Newest year 2024: about 2 years behind
- Doctors and Clinicians national file (PECOS) and its archives · CMS
- Refresh
- Every month, on the 21st
- Lag
- CMS updates it monthly; a move can take months to reach it
- Medicare Fee-For-Service Public Provider Enrollment and Reassignment · CMS
- Refresh
- Every month, on the 21st
- Lag
- The latest monthly release
- Hospital General Information, ASC Quality, Provider of Services, Hospital All Owners, Cost Reports (HCRIS) · CMS
- Refresh
- Every month on the 21st; the yearly files once a year, when CMS publishes the year
- Lag
- The monthly files are current; the yearly ones' newest year is 2024
- Medicare Monthly Enrollment; Medicare Advantage state/county penetration; Geographic Variation · CMS
- Refresh
- Every month, on the 21st
- Lag
- Medicare Advantage share monthly, the enrollment file about four months behind; Medicare use per county about two years behind
- Hospital Inpatient Discharges (SPARCS De-Identified), 2018-2024 · New York State Department of Health
- Refresh
- Reloaded by hand once a year, when New York posts the year
- Lag
- New York posts a year about eight months after it ends: newest year 2024
- MS-DRG Definitions Manual (v40-v44) and ICD-10-PCS code tables · CMS
- Refresh
- Rebuilt by hand each October from CMS’s new version
- Lag
- Version 44, in use since October 1, 2026
- Open Payments: general and research payments · CMS
- Refresh
- Once a year, when CMS publishes the program year (by June 30)
- Lag
- Newest year 2025: about 1 year behind
- NPPES NPI files and the NPI Registry API · CMS
- Refresh
- Every month, on the 21st
- Lag
- Current: clinicians update their own records, some rarely
- Population estimates and ZCTA-to-county relationship files · U.S. Census Bureau
- Refresh
- Every month, on the 21st
- Lag
- Population as of July 1 of the year before; ZIP-to-county from the 2020 census
- 510(k) premarket notifications, PMA approvals and device classification (openFDA) · U.S. Food and Drug Administration
- Refresh
- Reloaded by hand
- Lag
- As of the last reload; FDA posts a decision within days to weeks
- Device recalls and enforcement reports (openFDA) · U.S. Food and Drug Administration
- Refresh
- Reloaded by hand
- Lag
- As of the last reload; FDA posts a recall once it has classified it
- MAUDE adverse event reports (openFDA) · U.S. Food and Drug Administration
- Refresh
- Reloaded by hand
- Lag
- Trends stop six months short of today: about a third of reports are filed late
- EDGAR company facts (XBRL) · U.S. Securities and Exchange Commission
- Refresh
- Reloaded by hand
- Lag
- The company's latest quarterly or annual filing
- Hospital price transparency files (45 CFR 180) · Each hospital
- Refresh
- Reloaded by hand
- Lag
- Each file's own date, which hospitals must update at least yearly
- OpenAlex · OurResearch
- Refresh
- Reloaded by hand
- Lag
- Weeks after a paper is published
- IP to City Lite (CC BY 4.0) · DB-IP (db-ip.com)
- Refresh
- Every month, on the 2nd
- Lag
- The month's file