{"procedure":{"code_type":"CPT","code":"23040","lay_name":"Open shoulder joint drainage or foreign body removal","blurb":"Surgical opening of the main shoulder joint to look inside, drain infection, or take out a foreign object.","slug":"cpt-23040-open-shoulder-joint-drainage-or-foreign-body-removal","description":"Arthrotomy Glenohumeral Jt Expl/Drg/Rmvl FB","name_source":"llm:claude-opus-5","name_reviewed":false,"ccs":{"code":"162","label":"Other OR therapeutic procedures on joints","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:23:02.227918Z","checked_through":"2026-09-25T01:10:45.071082Z","n_priced_setters":3956,"n_filed":509,"n_usable":447,"n_not_usable":4,"n_labelled":42,"n_no_cash":14,"n_estimated":2,"n_states":47,"cash_p10":779.8,"cash_p20":1191.0,"cash_p25":1335.75,"cash_p50":2388.0,"cash_p75":4265.0,"cash_p80":5110.0,"cash_p90":7022.7,"cash_mean_trimmed":2633.13,"gross_p50":2694.0,"cash_to_gross_p50":0.65,"medicare_rate":3342.87,"medicare_schedule":"opps","medicare_year":2026,"cash_to_medicare_p50":0.7144,"by_state":[{"state":"AK","n":1,"p20":null,"p50":null,"p80":null},{"state":"AL","n":4,"p20":null,"p50":null,"p80":null},{"state":"AR","n":2,"p20":null,"p50":null,"p80":null},{"state":"AZ","n":6,"p20":null,"p50":null,"p80":null},{"state":"CA","n":30,"p20":1661.22,"p50":7968.8,"p80":7968.8},{"state":"CO","n":3,"p20":null,"p50":null,"p80":null},{"state":"CT","n":2,"p20":null,"p50":null,"p80":null},{"state":"FL","n":10,"p20":2788.5,"p50":3256.87,"p80":4144.23},{"state":"GA","n":8,"p20":null,"p50":null,"p80":null},{"state":"HI","n":4,"p20":null,"p50":null,"p80":null},{"state":"IA","n":21,"p20":1753.6,"p50":1765.6,"p80":1765.6},{"state":"ID","n":10,"p20":1380.0,"p50":3909.89,"p80":8372.0},{"state":"IL","n":14,"p20":887.95,"p50":1310.1,"p80":1765.6},{"state":"IN","n":6,"p20":null,"p50":null,"p80":null},{"state":"KS","n":5,"p20":null,"p50":null,"p80":null},{"state":"KY","n":7,"p20":null,"p50":null,"p80":null},{"state":"LA","n":5,"p20":null,"p50":null,"p80":null},{"state":"MD","n":1,"p20":null,"p50":null,"p80":null},{"state":"ME","n":1,"p20":null,"p50":null,"p80":null},{"state":"MI","n":33,"p20":1434.0,"p50":1605.4,"p80":3326.7},{"state":"MN","n":20,"p20":1779.9,"p50":3468.6,"p80":4415.84},{"state":"MO","n":4,"p20":null,"p50":null,"p80":null},{"state":"MS","n":2,"p20":null,"p50":null,"p80":null},{"state":"MT","n":8,"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":11,"p20":1442.7,"p50":1869.37,"p80":2345.4},{"state":"NH","n":7,"p20":null,"p50":null,"p80":null},{"state":"NJ","n":23,"p20":3591.33,"p50":3986.0,"p80":5419.0},{"state":"NM","n":1,"p20":null,"p50":null,"p80":null},{"state":"NV","n":5,"p20":null,"p50":null,"p80":null},{"state":"NY","n":33,"p20":1550.27,"p50":3839.54,"p80":4084.39},{"state":"OH","n":13,"p20":1432.36,"p50":2788.5,"p80":2944.23},{"state":"OK","n":13,"p20":1185.1,"p50":1185.1,"p80":6615.1},{"state":"OR","n":16,"p20":1335.75,"p50":1715.0,"p80":2388.0},{"state":"PA","n":19,"p20":447.7,"p50":549.45,"p80":5485.51},{"state":"RI","n":1,"p20":null,"p50":null,"p80":null},{"state":"SC","n":5,"p20":null,"p50":null,"p80":null},{"state":"SD","n":1,"p20":null,"p50":null,"p80":null},{"state":"TN","n":6,"p20":null,"p50":null,"p80":null},{"state":"TX","n":22,"p20":3126.96,"p50":5447.0,"p80":5447.0},{"state":"VA","n":4,"p20":null,"p50":null,"p80":null},{"state":"VT","n":7,"p20":null,"p50":null,"p80":null},{"state":"WA","n":8,"p20":null,"p50":null,"p80":null},{"state":"WI","n":29,"p20":3326.7,"p50":3508.0,"p80":7022.7},{"state":"WV","n":10,"p20":760.0,"p50":760.77,"p80":1216.0},{"state":"WY","n":4,"p20":null,"p50":null,"p80":null}],"by_segment":{"hospital_type":[{"key":"acute","n":325,"p20":1191.0,"p50":2788.5,"p80":5447.0},{"key":"childrens","n":9,"p20":null,"p50":null,"p80":null},{"key":"critical_access","n":112,"p20":1063.2,"p50":1972.0,"p80":3565.07}],"ownership":[{"key":"for_profit","n":42,"p20":1628.0,"p50":3705.4,"p80":8372.0},{"key":"government","n":74,"p20":1225.8,"p50":1856.0,"p80":3839.54},{"key":"nonprofit","n":330,"p20":1185.1,"p50":2388.0,"p80":5419.0}],"affiliation":[{"key":"affiliated","n":353,"p20":1216.0,"p50":2788.5,"p80":5447.0},{"key":"independent","n":94,"p20":1147.2,"p50":1614.0,"p80":3296.0}]},"histogram":[{"lo":564.3,"hi":735.36,"n":8},{"lo":735.36,"hi":958.27,"n":37},{"lo":958.27,"hi":1248.75,"n":31},{"lo":1248.75,"hi":1627.28,"n":53},{"lo":1627.28,"hi":2120.56,"n":59},{"lo":2120.56,"hi":2763.37,"n":30},{"lo":2763.37,"hi":3601.04,"n":59},{"lo":3601.04,"hi":4692.63,"n":53},{"lo":4692.63,"hi":6115.12,"n":30},{"lo":6115.12,"hi":7968.8,"n":43}],"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-10","checked_from":"2026-09-05T02:23:05.982663Z","checked_through":"2026-09-25T01:10:45.071082Z","n_priced_setters":3956,"n_filed":264,"n_usable":236,"n_not_usable":0,"n_labelled":17,"n_no_cash":11,"n_estimated":0,"n_states":44,"cash_p10":804.26,"cash_p20":1162.0,"cash_p25":1189.2,"cash_p50":1883.43,"cash_p75":4720.37,"cash_p80":5447.0,"cash_p90":7968.8,"cash_mean_trimmed":2486.48,"gross_p50":2537.0,"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":5,"p20":null,"p50":null,"p80":null},{"state":"AR","n":1,"p20":null,"p50":null,"p80":null},{"state":"AZ","n":1,"p20":null,"p50":null,"p80":null},{"state":"CA","n":23,"p20":7968.8,"p50":7968.8,"p80":7968.8},{"state":"CO","n":1,"p20":null,"p50":null,"p80":null},{"state":"CT","n":2,"p20":null,"p50":null,"p80":null},{"state":"FL","n":1,"p20":null,"p50":null,"p80":null},{"state":"GA","n":6,"p20":null,"p50":null,"p80":null},{"state":"HI","n":4,"p20":null,"p50":null,"p80":null},{"state":"IA","n":14,"p20":1765.6,"p50":1765.6,"p80":1765.6},{"state":"ID","n":6,"p20":null,"p50":null,"p80":null},{"state":"IL","n":10,"p20":887.95,"p50":887.95,"p80":1364.4},{"state":"IN","n":6,"p20":null,"p50":null,"p80":null},{"state":"KS","n":2,"p20":null,"p50":null,"p80":null},{"state":"KY","n":5,"p20":null,"p50":null,"p80":null},{"state":"LA","n":1,"p20":null,"p50":null,"p80":null},{"state":"ME","n":2,"p20":null,"p50":null,"p80":null},{"state":"MI","n":16,"p20":1397.0,"p50":1503.0,"p80":1628.0},{"state":"MN","n":8,"p20":null,"p50":null,"p80":null},{"state":"MO","n":1,"p20":null,"p50":null,"p80":null},{"state":"MS","n":1,"p20":null,"p50":null,"p80":null},{"state":"MT","n":5,"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":3,"p20":null,"p50":null,"p80":null},{"state":"NH","n":6,"p20":null,"p50":null,"p80":null},{"state":"NJ","n":2,"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":14,"p20":859.28,"p50":1550.27,"p80":8441.76},{"state":"OH","n":8,"p20":null,"p50":null,"p80":null},{"state":"OK","n":11,"p20":1185.1,"p50":1185.1,"p80":2549.2},{"state":"OR","n":6,"p20":null,"p50":null,"p80":null},{"state":"PA","n":7,"p20":null,"p50":null,"p80":null},{"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":19,"p20":5317.49,"p50":5447.0,"p80":5447.0},{"state":"VA","n":3,"p20":null,"p50":null,"p80":null},{"state":"VT","n":5,"p20":null,"p50":null,"p80":null},{"state":"WA","n":2,"p20":null,"p50":null,"p80":null},{"state":"WI","n":14,"p20":3326.7,"p50":3326.7,"p80":3326.7},{"state":"WV","n":2,"p20":null,"p50":null,"p80":null},{"state":"WY","n":2,"p20":null,"p50":null,"p80":null}],"by_segment":{"hospital_type":[{"key":"acute","n":182,"p20":1185.1,"p50":1796.86,"p80":6144.33},{"key":"childrens","n":4,"p20":null,"p50":null,"p80":null},{"key":"critical_access","n":49,"p20":887.95,"p50":2022.15,"p80":3326.7}],"ownership":[{"key":"for_profit","n":21,"p20":887.95,"p50":2578.0,"p80":5317.49},{"key":"government","n":28,"p20":1245.0,"p50":1779.9,"p80":2736.98},{"key":"nonprofit","n":186,"p20":1147.2,"p50":1872.94,"p80":6113.99}],"affiliation":[{"key":"affiliated","n":188,"p20":1185.1,"p50":2021.0,"p80":6144.33},{"key":"independent","n":48,"p20":1067.91,"p50":1397.0,"p80":2401.5}]},"histogram":[{"lo":686.34,"hi":877.05,"n":16},{"lo":877.05,"hi":1120.75,"n":19},{"lo":1120.75,"hi":1432.17,"n":35},{"lo":1432.17,"hi":1830.13,"n":34},{"lo":1830.13,"hi":2338.65,"n":19},{"lo":2338.65,"hi":2988.49,"n":16},{"lo":2988.49,"hi":3818.89,"n":23},{"lo":3818.89,"hi":4880.03,"n":5},{"lo":4880.03,"hi":6236.02,"n":19},{"lo":6236.02,"hi":7968.8,"n":28}],"previous":null}},"related":[{"code_type":"CPT","code":"27570","lay_name":"Bending and straightening a stiff knee under anesthesia","slug":"cpt-27570-bending-and-straightening-a-stiff-knee-under-anesthesia"},{"code_type":"CPT","code":"29823","lay_name":"Shoulder scope cleanout of damaged tissue, extensive","slug":"cpt-29823-shoulder-scope-cleanout-of-damaged-tissue-extensive"},{"code_type":"CPT","code":"29822","lay_name":"Shoulder scope cleanout of damaged tissue, limited","slug":"cpt-29822-shoulder-scope-cleanout-of-damaged-tissue-limited"},{"code_type":"CPT","code":"26990","lay_name":"Drainage of a deep abscess or blood collection at the hip","slug":"cpt-26990-drainage-of-a-deep-abscess-or-blood-collection-at-the-hip"},{"code_type":"CPT","code":"26080","lay_name":"Opening a finger joint to drain or remove a loose body","slug":"cpt-26080-opening-a-finger-joint-to-drain-or-remove-a-loose-body"},{"code_type":"CPT","code":"29877","lay_name":"Knee arthroscopy to shave damaged cartilage","slug":"cpt-29877-knee-arthroscopy-to-shave-damaged-cartilage"},{"code_type":"CPT","code":"28750","lay_name":"Fusion of the big toe joint at the ball of the foot","slug":"cpt-28750-fusion-of-the-big-toe-joint-at-the-ball-of-the-foot"},{"code_type":"CPT","code":"29806","lay_name":"Shoulder scope surgery to tighten the joint capsule","slug":"cpt-29806-shoulder-scope-surgery-to-tighten-the-joint-capsule"},{"code_type":"CPT","code":"29875","lay_name":"Knee arthroscopy with limited removal of joint lining","slug":"cpt-29875-knee-arthroscopy-with-limited-removal-of-joint-lining"},{"code_type":"CPT","code":"27695","lay_name":"Repair of torn ankle ligament on one side, fresh injury","slug":"cpt-27695-repair-of-torn-ankle-ligament-on-one-side-fresh-injury"},{"code_type":"CPT","code":"26540","lay_name":"Repair of side ligament of a finger or knuckle joint","slug":"cpt-26540-repair-of-side-ligament-of-a-finger-or-knuckle-joint"},{"code_type":"CPT","code":"29876","lay_name":"Knee arthroscopy to remove joint lining in two or more areas","slug":"cpt-29876-knee-arthroscopy-to-remove-joint-lining-in-two-or-more-areas"}]}