{"procedure":{"code_type":"CPT","code":"23474","lay_name":"Revision of shoulder replacement, both parts replaced","blurb":"Repeat surgery on a previous shoulder replacement in which both the upper arm bone part and the socket part are exchanged.","slug":"cpt-23474-revision-of-shoulder-replacement-both-parts-replaced","description":"Revis Shoulder Arthrplsty Humeral&Glenoid Compnt","name_source":"llm:claude-opus-5","name_reviewed":false,"ccs":{"code":"154","label":"Arthroplasty other than hip or knee","surgery_flag":"narrow"}},"settings":{"outpatient":{"setting":"outpatient","computed_at":"2026-09-25T11:55:12.319193Z","corpus_loaded_through":"2026-09-25T01:10:45.071082Z","filing_date_min":"2023-03-09","filing_date_max":"2026-09-22","checked_from":"2026-09-05T02:22:45.006185Z","checked_through":"2026-09-25T01:10:45.071082Z","n_priced_setters":3956,"n_filed":622,"n_usable":549,"n_not_usable":0,"n_labelled":48,"n_no_cash":23,"n_estimated":2,"n_states":48,"cash_p10":1849.79,"cash_p20":2655.0,"cash_p25":3188.9,"cash_p50":5339.0,"cash_p75":11348.08,"cash_p80":13631.45,"cash_p90":25120.02,"cash_mean_trimmed":6499.61,"gross_p50":6745.0,"cash_to_gross_p50":0.65,"medicare_rate":13116.76,"medicare_schedule":"opps","medicare_year":2026,"cash_to_medicare_p50":0.407,"by_state":[{"state":"AK","n":3,"p20":null,"p50":null,"p80":null},{"state":"AL","n":11,"p20":4002.0,"p50":11458.0,"p80":33396.05},{"state":"AR","n":5,"p20":null,"p50":null,"p80":null},{"state":"AZ","n":7,"p20":null,"p50":null,"p80":null},{"state":"CA","n":48,"p20":6350.4,"p50":10152.8,"p80":10152.8},{"state":"CO","n":9,"p20":null,"p50":null,"p80":null},{"state":"CT","n":3,"p20":null,"p50":null,"p80":null},{"state":"FL","n":10,"p20":1368.0,"p50":7074.6,"p80":20759.96},{"state":"GA","n":9,"p20":null,"p50":null,"p80":null},{"state":"HI","n":5,"p20":null,"p50":null,"p80":null},{"state":"IA","n":19,"p20":3694.4,"p50":4315.2,"p80":4852.0},{"state":"ID","n":17,"p20":3782.93,"p50":11807.6,"p80":19343.0},{"state":"IL","n":13,"p20":2360.75,"p50":2580.68,"p80":7058.4},{"state":"IN","n":12,"p20":1781.64,"p50":2360.75,"p80":3517.43},{"state":"KS","n":11,"p20":1150.7,"p50":2291.0,"p80":3704.35},{"state":"KY","n":7,"p20":null,"p50":null,"p80":null},{"state":"LA","n":6,"p20":null,"p50":null,"p80":null},{"state":"MA","n":1,"p20":null,"p50":null,"p80":null},{"state":"MD","n":2,"p20":null,"p50":null,"p80":null},{"state":"ME","n":2,"p20":null,"p50":null,"p80":null},{"state":"MI","n":38,"p20":2089.8,"p50":2984.0,"p80":17653.66},{"state":"MN","n":20,"p20":3200.0,"p50":9573.0,"p80":11232.32},{"state":"MO","n":9,"p20":null,"p50":null,"p80":null},{"state":"MS","n":2,"p20":null,"p50":null,"p80":null},{"state":"MT","n":4,"p20":null,"p50":null,"p80":null},{"state":"NC","n":4,"p20":null,"p50":null,"p80":null},{"state":"ND","n":2,"p20":null,"p50":null,"p80":null},{"state":"NE","n":15,"p20":2612.64,"p50":4893.0,"p80":5492.47},{"state":"NH","n":8,"p20":null,"p50":null,"p80":null},{"state":"NJ","n":23,"p20":4350.0,"p50":5855.0,"p80":13000.0},{"state":"NM","n":1,"p20":null,"p50":null,"p80":null},{"state":"NV","n":6,"p20":null,"p50":null,"p80":null},{"state":"NY","n":31,"p20":2198.0,"p50":4209.0,"p80":13116.76},{"state":"OH","n":21,"p20":3549.6,"p50":7074.6,"p80":36770.37},{"state":"OK","n":13,"p20":3645.36,"p50":3645.36,"p80":4775.72},{"state":"OR","n":20,"p20":3188.9,"p50":5037.0,"p80":5709.6},{"state":"PA","n":18,"p20":1073.6,"p50":1317.6,"p80":11348.08},{"state":"SC","n":5,"p20":null,"p50":null,"p80":null},{"state":"SD","n":2,"p20":null,"p50":null,"p80":null},{"state":"TN","n":5,"p20":null,"p50":null,"p80":null},{"state":"TX","n":26,"p20":3281.09,"p50":3445.15,"p80":10846.8},{"state":"UT","n":1,"p20":null,"p50":null,"p80":null},{"state":"VA","n":3,"p20":null,"p50":null,"p80":null},{"state":"VT","n":6,"p20":null,"p50":null,"p80":null},{"state":"WA","n":9,"p20":null,"p50":null,"p80":null},{"state":"WI","n":37,"p20":5192.94,"p50":9048.65,"p80":10686.4},{"state":"WV","n":14,"p20":1849.79,"p50":2868.8,"p80":6635.0},{"state":"WY","n":6,"p20":null,"p50":null,"p80":null}],"by_segment":{"hospital_type":[{"key":"acute","n":396,"p20":2960.12,"p50":6839.0,"p80":16052.22},{"key":"childrens","n":3,"p20":null,"p50":null,"p80":null},{"key":"critical_access","n":148,"p20":2291.0,"p50":4231.13,"p80":9048.65}],"ownership":[{"key":"for_profit","n":60,"p20":3281.09,"p50":11807.6,"p80":32373.0},{"key":"government","n":91,"p20":2795.96,"p50":4542.0,"p80":13116.76},{"key":"nonprofit","n":396,"p20":2580.68,"p50":5304.0,"p80":11348.08}],"affiliation":[{"key":"affiliated","n":411,"p20":2798.1,"p50":5709.6,"p80":13964.0},{"key":"independent","n":138,"p20":2509.28,"p50":4542.0,"p80":12608.5}]},"histogram":[{"lo":1268.8,"hi":1776.66,"n":19},{"lo":1776.66,"hi":2487.79,"n":53},{"lo":2487.79,"hi":3483.57,"n":75},{"lo":3483.57,"hi":4877.92,"n":74},{"lo":4877.92,"hi":6830.39,"n":56},{"lo":6830.39,"hi":9564.36,"n":69},{"lo":9564.36,"hi":13392.65,"n":64},{"lo":13392.65,"hi":18753.27,"n":37},{"lo":18753.27,"hi":26259.56,"n":26},{"lo":26259.56,"hi":36770.37,"n":22}],"previous":null},"inpatient":{"setting":"inpatient","computed_at":"2026-09-25T11:55:12.319193Z","corpus_loaded_through":"2026-09-25T01:10:45.071082Z","filing_date_min":"2024-07-01","filing_date_max":"2026-09-11","checked_from":"2026-09-05T02:23:05.982663Z","checked_through":"2026-09-25T01:10:45.071082Z","n_priced_setters":3956,"n_filed":309,"n_usable":276,"n_not_usable":0,"n_labelled":22,"n_no_cash":11,"n_estimated":0,"n_states":40,"cash_p10":1803.6,"cash_p20":2360.75,"cash_p25":2765.12,"cash_p50":3938.4,"cash_p75":8643.3,"cash_p80":9048.65,"cash_p90":10757.45,"cash_mean_trimmed":4742.96,"gross_p50":5741.91,"cash_to_gross_p50":0.65,"medicare_rate":null,"medicare_schedule":null,"medicare_year":null,"cash_to_medicare_p50":null,"by_state":[{"state":"AL","n":6,"p20":null,"p50":null,"p80":null},{"state":"AR","n":1,"p20":null,"p50":null,"p80":null},{"state":"CA","n":38,"p20":7841.6,"p50":7841.6,"p80":10152.8},{"state":"CO","n":3,"p20":null,"p50":null,"p80":null},{"state":"CT","n":3,"p20":null,"p50":null,"p80":null},{"state":"FL","n":2,"p20":null,"p50":null,"p80":null},{"state":"GA","n":6,"p20":null,"p50":null,"p80":null},{"state":"HI","n":3,"p20":null,"p50":null,"p80":null},{"state":"IA","n":15,"p20":4315.2,"p50":4315.2,"p80":4315.2},{"state":"ID","n":8,"p20":null,"p50":null,"p80":null},{"state":"IL","n":10,"p20":2360.75,"p50":3138.8,"p80":4315.2},{"state":"IN","n":8,"p20":null,"p50":null,"p80":null},{"state":"KS","n":1,"p20":null,"p50":null,"p80":null},{"state":"KY","n":4,"p20":null,"p50":null,"p80":null},{"state":"ME","n":2,"p20":null,"p50":null,"p80":null},{"state":"MI","n":19,"p20":608.0,"p50":3406.0,"p80":9048.65},{"state":"MN","n":6,"p20":null,"p50":null,"p80":null},{"state":"MO","n":4,"p20":null,"p50":null,"p80":null},{"state":"MS","n":1,"p20":null,"p50":null,"p80":null},{"state":"MT","n":1,"p20":null,"p50":null,"p80":null},{"state":"NC","n":1,"p20":null,"p50":null,"p80":null},{"state":"ND","n":1,"p20":null,"p50":null,"p80":null},{"state":"NE","n":6,"p20":null,"p50":null,"p80":null},{"state":"NH","n":6,"p20":null,"p50":null,"p80":null},{"state":"NM","n":1,"p20":null,"p50":null,"p80":null},{"state":"NV","n":2,"p20":null,"p50":null,"p80":null},{"state":"NY","n":18,"p20":2052.92,"p50":3694.43,"p80":5099.0},{"state":"OH","n":9,"p20":null,"p50":null,"p80":null},{"state":"OK","n":11,"p20":3645.36,"p50":3645.36,"p80":3645.36},{"state":"OR","n":10,"p20":3188.9,"p50":3188.9,"p80":8643.3},{"state":"PA","n":15,"p20":2072.39,"p50":2765.12,"p80":10453.79},{"state":"SC","n":1,"p20":null,"p50":null,"p80":null},{"state":"SD","n":1,"p20":null,"p50":null,"p80":null},{"state":"TN","n":4,"p20":null,"p50":null,"p80":null},{"state":"TX","n":20,"p20":3281.09,"p50":3445.15,"p80":3445.15},{"state":"VT","n":6,"p20":null,"p50":null,"p80":null},{"state":"WA","n":3,"p20":null,"p50":null,"p80":null},{"state":"WI","n":15,"p20":9048.65,"p50":9048.65,"p80":9048.65},{"state":"WV","n":3,"p20":null,"p50":null,"p80":null},{"state":"WY","n":2,"p20":null,"p50":null,"p80":null}],"by_segment":{"hospital_type":[{"key":"acute","n":209,"p20":2360.75,"p50":3854.75,"p80":10152.8},{"key":"childrens","n":2,"p20":null,"p50":null,"p80":null},{"key":"critical_access","n":64,"p20":2360.75,"p50":4263.0,"p80":9048.65}],"ownership":[{"key":"for_profit","n":23,"p20":2360.75,"p50":3454.4,"p80":11404.22},{"key":"government","n":33,"p20":2831.52,"p50":4002.0,"p80":6420.4},{"key":"nonprofit","n":219,"p20":2403.8,"p50":3961.5,"p80":9117.34}],"affiliation":[{"key":"affiliated","n":213,"p20":2360.75,"p50":4155.0,"p80":9048.65},{"key":"independent","n":63,"p20":2403.8,"p50":3406.0,"p80":8084.0}]},"histogram":[{"lo":1032.05,"hi":1383.51,"n":2},{"lo":1383.51,"hi":1854.66,"n":16},{"lo":1854.66,"hi":2486.27,"n":29},{"lo":2486.27,"hi":3332.96,"n":39},{"lo":3332.96,"hi":4467.99,"n":62},{"lo":4467.99,"hi":5989.56,"n":14},{"lo":5989.56,"hi":8029.29,"n":26},{"lo":8029.29,"hi":10763.64,"n":48},{"lo":10763.64,"hi":14429.18,"n":11},{"lo":14429.18,"hi":19343.0,"n":7}],"previous":null}},"related":[{"code_type":"CPT","code":"23472","lay_name":"Total shoulder replacement","slug":"cpt-23472-total-shoulder-replacement"},{"code_type":"CPT","code":"25447","lay_name":"Wrist or thumb-base joint resurfacing with a tissue spacer","slug":"cpt-25447-wrist-or-thumb-base-joint-resurfacing-with-a-tissue-spacer"},{"code_type":"CPT","code":"23470","lay_name":"Partial shoulder replacement","slug":"cpt-23470-partial-shoulder-replacement"},{"code_type":"CPT","code":"23473","lay_name":"Revision of shoulder replacement, one part replaced","slug":"cpt-23473-revision-of-shoulder-replacement-one-part-replaced"},{"code_type":"CPT","code":"26535","lay_name":"Finger joint resurfacing without implant, each joint","slug":"cpt-26535-finger-joint-resurfacing-without-implant-each-joint"},{"code_type":"CPT","code":"23420","lay_name":"Open repair of a completely torn rotator cuff","slug":"cpt-23420-open-repair-of-a-completely-torn-rotator-cuff"},{"code_type":"CPT","code":"24366","lay_name":"Radial head replacement with an implant","slug":"cpt-24366-radial-head-replacement-with-an-implant"},{"code_type":"CPT","code":"26531","lay_name":"Knuckle joint replacement with implant, each joint","slug":"cpt-26531-knuckle-joint-replacement-with-implant-each-joint"},{"code_type":"CPT","code":"27702","lay_name":"Total ankle replacement with implant","slug":"cpt-27702-total-ankle-replacement-with-implant"},{"code_type":"CPT","code":"26536","lay_name":"Finger joint replacement with implant, each joint","slug":"cpt-26536-finger-joint-replacement-with-implant-each-joint"},{"code_type":"CPT","code":"26530","lay_name":"Knuckle joint resurfacing without implant, each joint","slug":"cpt-26530-knuckle-joint-resurfacing-without-implant-each-joint"},{"code_type":"CPT","code":"25332","lay_name":"Wrist joint replacement or resurfacing","slug":"cpt-25332-wrist-joint-replacement-or-resurfacing"}]}