{"procedure":{"code_type":"CPT","code":"23107","lay_name":"Open exploration of the shoulder joint","blurb":"Surgical opening of the main shoulder joint to inspect it, with or without removal of a loose fragment or foreign body.","slug":"cpt-23107-open-exploration-of-the-shoulder-joint","description":"Arthrt Glenohmrl Jt W/Jt Expl W/WO Rmvl Loose/FB","name_source":"llm:claude-opus-5","name_reviewed":false,"ccs":{"code":"159","label":"Other diagnostic procedures on musculoskeletal system","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:05.982663Z","checked_through":"2026-09-25T01:10:45.071082Z","n_priced_setters":3956,"n_filed":354,"n_usable":311,"n_not_usable":2,"n_labelled":32,"n_no_cash":9,"n_estimated":0,"n_states":43,"cash_p10":866.95,"cash_p20":1100.4,"cash_p25":1207.19,"cash_p50":2740.0,"cash_p75":8453.6,"cash_p80":9388.33,"cash_p90":12319.45,"cash_mean_trimmed":3787.56,"gross_p50":2455.0,"cash_to_gross_p50":0.65,"medicare_rate":7413.38,"medicare_schedule":"opps","medicare_year":2026,"cash_to_medicare_p50":0.3696,"by_state":[{"state":"AK","n":2,"p20":null,"p50":null,"p80":null},{"state":"AL","n":3,"p20":null,"p50":null,"p80":null},{"state":"AR","n":2,"p20":null,"p50":null,"p80":null},{"state":"AZ","n":4,"p20":null,"p50":null,"p80":null},{"state":"CA","n":28,"p20":1617.0,"p50":10035.2,"p80":10035.2},{"state":"CO","n":3,"p20":null,"p50":null,"p80":null},{"state":"FL","n":5,"p20":null,"p50":null,"p80":null},{"state":"GA","n":2,"p20":null,"p50":null,"p80":null},{"state":"HI","n":1,"p20":null,"p50":null,"p80":null},{"state":"IA","n":15,"p20":1623.2,"p50":1623.2,"p80":1623.2},{"state":"ID","n":8,"p20":null,"p50":null,"p80":null},{"state":"IL","n":18,"p20":866.95,"p50":1623.2,"p80":16329.6},{"state":"IN","n":7,"p20":null,"p50":null,"p80":null},{"state":"KS","n":3,"p20":null,"p50":null,"p80":null},{"state":"KY","n":3,"p20":null,"p50":null,"p80":null},{"state":"LA","n":3,"p20":null,"p50":null,"p80":null},{"state":"ME","n":1,"p20":null,"p50":null,"p80":null},{"state":"MI","n":12,"p20":1034.4,"p50":1034.4,"p80":9977.57},{"state":"MN","n":8,"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":2,"p20":null,"p50":null,"p80":null},{"state":"NC","n":3,"p20":null,"p50":null,"p80":null},{"state":"ND","n":2,"p20":null,"p50":null,"p80":null},{"state":"NE","n":2,"p20":null,"p50":null,"p80":null},{"state":"NH","n":3,"p20":null,"p50":null,"p80":null},{"state":"NJ","n":22,"p20":4881.0,"p50":6311.0,"p80":7913.97},{"state":"NM","n":1,"p20":null,"p50":null,"p80":null},{"state":"NV","n":3,"p20":null,"p50":null,"p80":null},{"state":"NY","n":24,"p20":4937.7,"p50":8453.6,"p80":8613.01},{"state":"OH","n":8,"p20":null,"p50":null,"p80":null},{"state":"OK","n":14,"p20":1100.4,"p50":1100.4,"p80":7323.8},{"state":"OR","n":11,"p20":1241.5,"p50":1241.5,"p80":2204.8},{"state":"PA","n":20,"p20":415.8,"p50":703.5,"p80":11093.08},{"state":"SC","n":5,"p20":null,"p50":null,"p80":null},{"state":"SD","n":2,"p20":null,"p50":null,"p80":null},{"state":"TN","n":6,"p20":null,"p50":null,"p80":null},{"state":"TX","n":22,"p20":3751.66,"p50":3751.66,"p80":5886.74},{"state":"VT","n":5,"p20":null,"p50":null,"p80":null},{"state":"WA","n":5,"p20":null,"p50":null,"p80":null},{"state":"WI","n":11,"p20":3318.28,"p50":3318.28,"p80":3318.28},{"state":"WV","n":3,"p20":null,"p50":null,"p80":null},{"state":"WY","n":4,"p20":null,"p50":null,"p80":null}],"by_segment":{"hospital_type":[{"key":"acute","n":253,"p20":1100.4,"p50":3751.66,"p80":9977.57},{"key":"childrens","n":7,"p20":null,"p50":null,"p80":null},{"key":"critical_access","n":50,"p20":1125.3,"p50":1922.7,"p80":4760.0}],"ownership":[{"key":"for_profit","n":39,"p20":866.95,"p50":3909.89,"p80":15749.37},{"key":"government","n":49,"p20":1167.2,"p50":1706.0,"p80":8453.6},{"key":"nonprofit","n":222,"p20":1100.4,"p50":3318.28,"p80":9977.57}],"affiliation":[{"key":"affiliated","n":242,"p20":1100.4,"p50":3751.66,"p80":10035.2},{"key":"independent","n":69,"p20":1148.0,"p50":1691.25,"p80":6167.0}]},"histogram":[{"lo":558.9,"hi":783.25,"n":13},{"lo":783.25,"hi":1097.65,"n":31},{"lo":1097.65,"hi":1538.25,"n":46},{"lo":1538.25,"hi":2155.71,"n":37},{"lo":2155.71,"hi":3021.03,"n":15},{"lo":3021.03,"hi":4233.69,"n":24},{"lo":4233.69,"hi":5933.12,"n":23},{"lo":5933.12,"hi":8314.71,"n":24},{"lo":8314.71,"hi":11652.29,"n":49},{"lo":11652.29,"hi":16329.6,"n":23}],"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-14","checked_from":"2026-09-05T02:23:05.982663Z","checked_through":"2026-09-25T01:10:45.071082Z","n_priced_setters":3956,"n_filed":186,"n_usable":165,"n_not_usable":0,"n_labelled":14,"n_no_cash":7,"n_estimated":0,"n_states":37,"cash_p10":866.95,"cash_p20":1034.4,"cash_p25":1100.4,"cash_p50":1653.03,"cash_p75":5886.74,"cash_p80":7907.11,"cash_p90":10035.2,"cash_mean_trimmed":2447.13,"gross_p50":2477.0,"cash_to_gross_p50":0.6,"medicare_rate":null,"medicare_schedule":null,"medicare_year":null,"cash_to_medicare_p50":null,"by_state":[{"state":"AL","n":2,"p20":null,"p50":null,"p80":null},{"state":"AR","n":1,"p20":null,"p50":null,"p80":null},{"state":"CA","n":23,"p20":10035.2,"p50":10035.2,"p80":10035.2},{"state":"CO","n":1,"p20":null,"p50":null,"p80":null},{"state":"FL","n":1,"p20":null,"p50":null,"p80":null},{"state":"HI","n":1,"p20":null,"p50":null,"p80":null},{"state":"IA","n":14,"p20":1623.2,"p50":1623.2,"p80":1623.2},{"state":"ID","n":5,"p20":null,"p50":null,"p80":null},{"state":"IL","n":7,"p20":null,"p50":null,"p80":null},{"state":"IN","n":4,"p20":null,"p50":null,"p80":null},{"state":"KS","n":2,"p20":null,"p50":null,"p80":null},{"state":"KY","n":3,"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":7,"p20":null,"p50":null,"p80":null},{"state":"MN","n":4,"p20":null,"p50":null,"p80":null},{"state":"MO","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":2,"p20":null,"p50":null,"p80":null},{"state":"NH","n":3,"p20":null,"p50":null,"p80":null},{"state":"NJ","n":1,"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":4,"p20":null,"p50":null,"p80":null},{"state":"OH","n":3,"p20":null,"p50":null,"p80":null},{"state":"OK","n":11,"p20":1100.4,"p50":1100.4,"p80":1100.4},{"state":"OR","n":5,"p20":null,"p50":null,"p80":null},{"state":"PA","n":17,"p20":2641.92,"p50":3242.36,"p80":12077.48},{"state":"SD","n":1,"p20":null,"p50":null,"p80":null},{"state":"TN","n":4,"p20":null,"p50":null,"p80":null},{"state":"TX","n":18,"p20":3751.66,"p50":3751.66,"p80":5886.74},{"state":"VT","n":4,"p20":null,"p50":null,"p80":null},{"state":"WA","n":1,"p20":null,"p50":null,"p80":null},{"state":"WI","n":2,"p20":null,"p50":null,"p80":null},{"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":139,"p20":1100.4,"p50":1810.0,"p80":10035.2},{"key":"childrens","n":3,"p20":null,"p50":null,"p80":null},{"key":"critical_access","n":22,"p20":866.95,"p50":1517.6,"p80":6564.35}],"ownership":[{"key":"for_profit","n":18,"p20":null,"p50":null,"p80":null},{"key":"government","n":18,"p20":null,"p50":null,"p80":null},{"key":"nonprofit","n":128,"p20":1100.4,"p50":1772.0,"p80":10035.2}],"affiliation":[{"key":"affiliated","n":134,"p20":1034.4,"p50":1860.0,"p80":10035.2},{"key":"independent","n":31,"p20":1179.5,"p50":1311.0,"p80":2202.0}]},"histogram":[{"lo":699.19,"hi":931.53,"n":18},{"lo":931.53,"hi":1241.06,"n":28},{"lo":1241.06,"hi":1653.46,"n":30},{"lo":1653.46,"hi":2202.89,"n":12},{"lo":2202.89,"hi":2934.9,"n":10},{"lo":2934.9,"hi":3910.15,"n":13},{"lo":3910.15,"hi":5209.46,"n":3},{"lo":5209.46,"hi":6940.52,"n":8},{"lo":6940.52,"hi":9246.81,"n":4},{"lo":9246.81,"hi":12319.45,"n":24}],"previous":null}},"related":[{"code_type":"CPT","code":"20220","lay_name":"Needle biopsy of bone near the surface","slug":"cpt-20220-needle-biopsy-of-bone-near-the-surface"},{"code_type":"CPT","code":"20206","lay_name":"Needle biopsy of muscle","slug":"cpt-20206-needle-biopsy-of-muscle"},{"code_type":"CPT","code":"20225","lay_name":"Needle biopsy of deep bone","slug":"cpt-20225-needle-biopsy-of-deep-bone"},{"code_type":"CPT","code":"20501","lay_name":"Contrast injection into a draining tract for X-ray study","slug":"cpt-20501-contrast-injection-into-a-draining-tract-for-x-ray-study"},{"code_type":"CPT","code":"21550","lay_name":"Biopsy of soft tissue in the neck or chest wall","slug":"cpt-21550-biopsy-of-soft-tissue-in-the-neck-or-chest-wall"},{"code_type":"CPT","code":"20240","lay_name":"Open biopsy of bone near the surface","slug":"cpt-20240-open-biopsy-of-bone-near-the-surface"},{"code_type":"CPT","code":"20950","lay_name":"Pressure monitoring inside a muscle compartment","slug":"cpt-20950-pressure-monitoring-inside-a-muscle-compartment"},{"code_type":"CPT","code":"20205","lay_name":"Biopsy of deep muscle","slug":"cpt-20205-biopsy-of-deep-muscle"},{"code_type":"CPT","code":"27040","lay_name":"Biopsy of shallow soft tissue of the hip or pelvis","slug":"cpt-27040-biopsy-of-shallow-soft-tissue-of-the-hip-or-pelvis"},{"code_type":"CPT","code":"20245","lay_name":"Open biopsy of deep bone","slug":"cpt-20245-open-biopsy-of-deep-bone"},{"code_type":"CPT","code":"27323","lay_name":"Biopsy of shallow soft tissue of the thigh or knee","slug":"cpt-27323-biopsy-of-shallow-soft-tissue-of-the-thigh-or-knee"},{"code_type":"CPT","code":"21920","lay_name":"Biopsy of soft tissue of the back or flank, surface level","slug":"cpt-21920-biopsy-of-soft-tissue-of-the-back-or-flank-surface-level"}]}