{"procedure":{"code_type":"CPT","code":"28171","lay_name":"Extensive tumor removal from a midfoot bone","blurb":"Wide surgical removal of a tumor and surrounding tissue involving a tarsal bone other than the talus or heel bone.","slug":"cpt-28171-extensive-tumor-removal-from-a-midfoot-bone","description":"Rad Rescj Tumor Tarsal Except Talus/Calcaneus","name_source":"llm:claude-opus-5","name_reviewed":false,"ccs":{"code":"142","label":"Partial excision bone","surgery_flag":"narrow"}},"settings":{"outpatient":{"setting":"outpatient","computed_at":"2026-09-25T11:55:12.319193Z","corpus_loaded_through":"2026-09-23T21:50:31.523775Z","filing_date_min":"2024-07-01","filing_date_max":"2026-09-22","checked_from":"2026-09-05T10:45:50.833230Z","checked_through":"2026-09-23T21:50:31.523775Z","n_priced_setters":3956,"n_filed":226,"n_usable":209,"n_not_usable":1,"n_labelled":12,"n_no_cash":4,"n_estimated":0,"n_states":38,"cash_p10":1018.15,"cash_p20":1460.04,"cash_p25":1821.4,"cash_p50":3545.97,"cash_p75":5302.97,"cash_p80":5741.0,"cash_p90":7285.6,"cash_mean_trimmed":3298.24,"gross_p50":3416.0,"cash_to_gross_p50":0.5927,"medicare_rate":3342.87,"medicare_schedule":"opps","medicare_year":2026,"cash_to_medicare_p50":1.0608,"by_state":[{"state":"AK","n":1,"p20":null,"p50":null,"p80":null},{"state":"AR","n":2,"p20":null,"p50":null,"p80":null},{"state":"AZ","n":2,"p20":null,"p50":null,"p80":null},{"state":"CA","n":21,"p20":7285.6,"p50":7285.6,"p80":7285.6},{"state":"CO","n":1,"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":"IA","n":14,"p20":2484.3,"p50":2732.8,"p80":2732.8},{"state":"ID","n":6,"p20":null,"p50":null,"p80":null},{"state":"IL","n":11,"p20":1018.15,"p50":1460.04,"p80":2108.44},{"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":2,"p20":null,"p50":null,"p80":null},{"state":"MI","n":7,"p20":null,"p50":null,"p80":null},{"state":"MN","n":1,"p20":null,"p50":null,"p80":null},{"state":"MO","n":2,"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":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":3591.33,"p50":3986.0,"p80":5419.0},{"state":"NM","n":1,"p20":null,"p50":null,"p80":null},{"state":"NV","n":3,"p20":null,"p50":null,"p80":null},{"state":"NY","n":19,"p20":3342.87,"p50":3839.54,"p80":3883.81},{"state":"OH","n":6,"p20":null,"p50":null,"p80":null},{"state":"OK","n":12,"p20":1821.4,"p50":1821.4,"p80":1821.4},{"state":"OR","n":6,"p20":null,"p50":null,"p80":null},{"state":"PA","n":19,"p20":687.06,"p50":3139.0,"p80":6113.99},{"state":"SC","n":3,"p20":null,"p50":null,"p80":null},{"state":"TN","n":6,"p20":null,"p50":null,"p80":null},{"state":"TX","n":2,"p20":null,"p50":null,"p80":null},{"state":"VT","n":3,"p20":null,"p50":null,"p80":null},{"state":"WA","n":3,"p20":null,"p50":null,"p80":null},{"state":"WI","n":7,"p20":null,"p50":null,"p80":null},{"state":"WY","n":1,"p20":null,"p50":null,"p80":null}],"by_segment":{"hospital_type":[{"key":"acute","n":181,"p20":1460.04,"p50":3553.2,"p80":5741.0},{"key":"childrens","n":6,"p20":null,"p50":null,"p80":null},{"key":"critical_access","n":22,"p20":1034.4,"p50":2732.8,"p80":5813.6}],"ownership":[{"key":"for_profit","n":23,"p20":1018.15,"p50":2789.88,"p80":5751.45},{"key":"government","n":24,"p20":1831.5,"p50":2484.3,"p80":3839.54},{"key":"nonprofit","n":162,"p20":1460.04,"p50":3591.33,"p80":6113.99}],"affiliation":[{"key":"affiliated","n":171,"p20":1460.04,"p50":3804.28,"p80":6307.0},{"key":"independent","n":38,"p20":1632.0,"p50":2108.44,"p80":4121.31}]},"histogram":[{"lo":818.96,"hi":1019.02,"n":18},{"lo":1019.02,"hi":1267.95,"n":11},{"lo":1267.95,"hi":1577.7,"n":6},{"lo":1577.7,"hi":1963.11,"n":20},{"lo":1963.11,"hi":2442.67,"n":16},{"lo":2442.67,"hi":3039.37,"n":19},{"lo":3039.37,"hi":3781.85,"n":11},{"lo":3781.85,"hi":4705.71,"n":40},{"lo":4705.71,"hi":5855.24,"n":20},{"lo":5855.24,"hi":7285.6,"n":31}],"previous":null},"inpatient":{"setting":"inpatient","computed_at":"2026-09-25T11:55:12.319193Z","corpus_loaded_through":"2026-09-23T17:10:10.717090Z","filing_date_min":"2024-07-01","filing_date_max":"2026-09-02","checked_from":"2026-09-05T11:18:47.736875Z","checked_through":"2026-09-23T21:50:19.708917Z","n_priced_setters":3956,"n_filed":136,"n_usable":122,"n_not_usable":0,"n_labelled":7,"n_no_cash":7,"n_estimated":0,"n_states":31,"cash_p10":1018.15,"cash_p20":1317.98,"cash_p25":1795.68,"cash_p50":2732.8,"cash_p75":7285.6,"cash_p80":7285.6,"cash_p90":7285.6,"cash_mean_trimmed":4025.92,"gross_p50":3416.0,"cash_to_gross_p50":0.61,"medicare_rate":null,"medicare_schedule":null,"medicare_year":null,"cash_to_medicare_p50":null,"by_state":[{"state":"AL","n":1,"p20":null,"p50":null,"p80":null},{"state":"AR","n":1,"p20":null,"p50":null,"p80":null},{"state":"CA","n":19,"p20":7285.6,"p50":7285.6,"p80":7285.6},{"state":"GA","n":6,"p20":null,"p50":null,"p80":null},{"state":"IA","n":13,"p20":2732.8,"p50":2732.8,"p80":2732.8},{"state":"ID","n":6,"p20":null,"p50":null,"p80":null},{"state":"IL","n":10,"p20":1018.15,"p50":2031.6,"p80":2732.8},{"state":"IN","n":6,"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":"MI","n":3,"p20":null,"p50":null,"p80":null},{"state":"MO","n":2,"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":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":3,"p20":null,"p50":null,"p80":null},{"state":"OH","n":3,"p20":null,"p50":null,"p80":null},{"state":"OK","n":10,"p20":1821.4,"p50":1821.4,"p80":1821.4},{"state":"OR","n":5,"p20":null,"p50":null,"p80":null},{"state":"PA","n":6,"p20":null,"p50":null,"p80":null},{"state":"TN","n":4,"p20":null,"p50":null,"p80":null},{"state":"TX","n":1,"p20":null,"p50":null,"p80":null},{"state":"VT","n":2,"p20":null,"p50":null,"p80":null},{"state":"WA","n":2,"p20":null,"p50":null,"p80":null},{"state":"WY","n":1,"p20":null,"p50":null,"p80":null}],"by_segment":{"hospital_type":[{"key":"acute","n":106,"p20":1632.0,"p50":2732.8,"p80":7285.6},{"key":"childrens","n":3,"p20":null,"p50":null,"p80":null},{"key":"critical_access","n":13,"p20":null,"p50":null,"p80":null}],"ownership":[{"key":"for_profit","n":13,"p20":null,"p50":null,"p80":null},{"key":"government","n":10,"p20":null,"p50":null,"p80":null},{"key":"nonprofit","n":99,"p20":1524.96,"p50":2732.8,"p80":7285.6}],"affiliation":[{"key":"affiliated","n":97,"p20":1524.96,"p50":2732.8,"p80":7285.6},{"key":"independent","n":25,"p20":1155.0,"p50":2031.6,"p80":4121.31}]},"histogram":[{"lo":1018.15,"hi":1297.89,"n":19},{"lo":1297.89,"hi":1654.5,"n":5},{"lo":1654.5,"hi":2109.08,"n":25},{"lo":2109.08,"hi":2688.56,"n":4},{"lo":2688.56,"hi":3427.26,"n":13},{"lo":3427.26,"hi":4368.92,"n":5},{"lo":4368.92,"hi":5569.31,"n":5},{"lo":5569.31,"hi":7099.51,"n":10},{"lo":7099.51,"hi":9050.15,"n":24},{"lo":9050.15,"hi":11536.73,"n":1}],"previous":null}},"related":[{"code_type":"CPT","code":"28124","lay_name":"Removal of diseased bone from a toe bone","slug":"cpt-28124-removal-of-diseased-bone-from-a-toe-bone"},{"code_type":"CPT","code":"26236","lay_name":"Partial removal of bone in fingertip","slug":"cpt-26236-partial-removal-of-bone-in-fingertip"},{"code_type":"CPT","code":"28122","lay_name":"Removal of diseased bone from a midfoot or forefoot bone","slug":"cpt-28122-removal-of-diseased-bone-from-a-midfoot-or-forefoot-bone"},{"code_type":"CPT","code":"29824","lay_name":"Shoulder scope removal of the collarbone end","slug":"cpt-29824-shoulder-scope-removal-of-the-collarbone-end"},{"code_type":"CPT","code":"28120","lay_name":"Removal of diseased bone from the ankle or heel bone","slug":"cpt-28120-removal-of-diseased-bone-from-the-ankle-or-heel-bone"},{"code_type":"CPT","code":"28118","lay_name":"Removal of part of the heel bone","slug":"cpt-28118-removal-of-part-of-the-heel-bone"},{"code_type":"CPT","code":"28110","lay_name":"Shaving of the bony bump at the base of the little toe","slug":"cpt-28110-shaving-of-the-bony-bump-at-the-base-of-the-little-toe"},{"code_type":"CPT","code":"23120","lay_name":"Partial removal of the collarbone","slug":"cpt-23120-partial-removal-of-the-collarbone"},{"code_type":"CPT","code":"28119","lay_name":"Heel spur removal, with or without fascia release","slug":"cpt-28119-heel-spur-removal-with-or-without-fascia-release"},{"code_type":"CPT","code":"28288","lay_name":"Partial removal of a metatarsal head, one bone","slug":"cpt-28288-partial-removal-of-a-metatarsal-head-one-bone"},{"code_type":"CPT","code":"28113","lay_name":"Removal of the fifth metatarsal head in the foot","slug":"cpt-28113-removal-of-the-fifth-metatarsal-head-in-the-foot"},{"code_type":"CPT","code":"28112","lay_name":"Removal of a middle metatarsal head in the foot","slug":"cpt-28112-removal-of-a-middle-metatarsal-head-in-the-foot"}]}