{"procedure":{"code_type":"CPT","code":"45172","lay_name":"Removal of a rectal tumor including the deep muscle layer","blurb":"A tumor is removed from the rectum through the anus, with the excision extending through the full thickness of the muscle wall.","slug":"cpt-45172-removal-of-a-rectal-tumor-including-the-deep-muscle-layer","description":"Exc Rct Tum Incl Muscularis Propria","name_source":"llm:claude-opus-5","name_reviewed":false,"ccs":{"code":"78","label":"Colorectal resection","surgery_flag":"narrow"}},"settings":{"outpatient":{"setting":"outpatient","computed_at":"2026-09-25T11:55:12.319193Z","corpus_loaded_through":"2026-09-23T22:20:23.317834Z","filing_date_min":"2023-03-09","filing_date_max":"2026-09-22","checked_from":"2026-09-05T02:23:02.227918Z","checked_through":"2026-09-23T22:20:23.317834Z","n_priced_setters":3956,"n_filed":604,"n_usable":555,"n_not_usable":0,"n_labelled":38,"n_no_cash":9,"n_estimated":2,"n_states":48,"cash_p10":1004.4,"cash_p20":1437.91,"cash_p25":1594.0,"cash_p50":3153.8,"cash_p75":5240.4,"cash_p80":6267.6,"cash_p90":8803.2,"cash_mean_trimmed":3309.44,"gross_p50":4055.0,"cash_to_gross_p50":0.6,"medicare_rate":2835.78,"medicare_schedule":"opps","medicare_year":2026,"cash_to_medicare_p50":1.1121,"by_state":[{"state":"AK","n":3,"p20":null,"p50":null,"p80":null},{"state":"AL","n":6,"p20":null,"p50":null,"p80":null},{"state":"AR","n":8,"p20":null,"p50":null,"p80":null},{"state":"AZ","n":6,"p20":null,"p50":null,"p80":null},{"state":"CA","n":50,"p20":1874.4,"p50":5205.2,"p80":8803.2},{"state":"CO","n":6,"p20":null,"p50":null,"p80":null},{"state":"CT","n":1,"p20":null,"p50":null,"p80":null},{"state":"FL","n":19,"p20":3153.8,"p50":4421.6,"p80":12140.23},{"state":"GA","n":10,"p20":3232.0,"p50":16385.0,"p80":16385.0},{"state":"HI","n":3,"p20":null,"p50":null,"p80":null},{"state":"IA","n":22,"p20":1999.2,"p50":2019.2,"p80":2469.3},{"state":"ID","n":11,"p20":3090.0,"p50":7189.0,"p80":7189.0},{"state":"IL","n":21,"p20":1114.75,"p50":1994.3,"p80":18006.46},{"state":"IN","n":9,"p20":null,"p50":null,"p80":null},{"state":"KS","n":10,"p20":1033.2,"p50":1239.7,"p80":1444.0},{"state":"KY","n":7,"p20":null,"p50":null,"p80":null},{"state":"LA","n":11,"p20":1121.28,"p50":2280.69,"p80":4598.53},{"state":"MA","n":6,"p20":null,"p50":null,"p80":null},{"state":"MD","n":3,"p20":null,"p50":null,"p80":null},{"state":"ME","n":3,"p20":null,"p50":null,"p80":null},{"state":"MI","n":17,"p20":1551.2,"p50":3816.64,"p80":4163.25},{"state":"MN","n":17,"p20":2558.5,"p50":4081.44,"p80":4081.44},{"state":"MO","n":17,"p20":1176.48,"p50":2960.08,"p80":10603.82},{"state":"MS","n":5,"p20":null,"p50":null,"p80":null},{"state":"MT","n":3,"p20":null,"p50":null,"p80":null},{"state":"NC","n":5,"p20":null,"p50":null,"p80":null},{"state":"ND","n":1,"p20":null,"p50":null,"p80":null},{"state":"NE","n":7,"p20":null,"p50":null,"p80":null},{"state":"NH","n":8,"p20":null,"p50":null,"p80":null},{"state":"NJ","n":30,"p20":3035.44,"p50":3660.06,"p80":5339.0},{"state":"NM","n":7,"p20":null,"p50":null,"p80":null},{"state":"NV","n":4,"p20":null,"p50":null,"p80":null},{"state":"NY","n":47,"p20":2027.5,"p50":3245.23,"p80":4595.0},{"state":"OH","n":14,"p20":1170.0,"p50":3072.75,"p80":12954.23},{"state":"OK","n":13,"p20":1725.7,"p50":1725.7,"p80":5591.18},{"state":"OR","n":14,"p20":1511.25,"p50":1511.25,"p80":2291.2},{"state":"PA","n":20,"p20":507.98,"p50":2085.58,"p80":5167.76},{"state":"SC","n":6,"p20":null,"p50":null,"p80":null},{"state":"SD","n":1,"p20":null,"p50":null,"p80":null},{"state":"TN","n":8,"p20":null,"p50":null,"p80":null},{"state":"TX","n":26,"p20":2774.0,"p50":5595.41,"p80":6394.75},{"state":"UT","n":1,"p20":null,"p50":null,"p80":null},{"state":"VA","n":7,"p20":null,"p50":null,"p80":null},{"state":"VT","n":5,"p20":null,"p50":null,"p80":null},{"state":"WA","n":12,"p20":1592.0,"p50":1717.0,"p80":8931.0},{"state":"WI","n":30,"p20":4163.25,"p50":4163.25,"p80":6267.6},{"state":"WV","n":11,"p20":867.57,"p50":896.5,"p80":2250.0},{"state":"WY","n":4,"p20":null,"p50":null,"p80":null}],"by_segment":{"hospital_type":[{"key":"acute","n":438,"p20":1511.25,"p50":3271.5,"p80":6839.0},{"key":"childrens","n":6,"p20":null,"p50":null,"p80":null},{"key":"critical_access","n":110,"p20":1114.75,"p50":2019.2,"p80":4163.25}],"ownership":[{"key":"for_profit","n":57,"p20":1777.12,"p50":3432.0,"p80":8008.65},{"key":"government","n":92,"p20":1437.91,"p50":2291.0,"p80":4250.0},{"key":"nonprofit","n":405,"p20":1429.5,"p50":3385.62,"p80":6267.6}],"affiliation":[{"key":"affiliated","n":446,"p20":1450.44,"p50":3478.5,"p80":6394.75},{"key":"independent","n":109,"p20":1360.2,"p50":2085.58,"p80":4010.4}]},"histogram":[{"lo":778.94,"hi":1052.26,"n":35},{"lo":1052.26,"hi":1421.49,"n":45},{"lo":1421.49,"hi":1920.27,"n":72},{"lo":1920.27,"hi":2594.07,"n":61},{"lo":2594.07,"hi":3504.3,"n":69},{"lo":3504.3,"hi":4733.92,"n":89},{"lo":4733.92,"hi":6395.0,"n":62},{"lo":6395.0,"hi":8638.94,"n":23},{"lo":8638.94,"hi":11670.24,"n":34},{"lo":11670.24,"hi":15765.2,"n":13}],"previous":null},"inpatient":{"setting":"inpatient","computed_at":"2026-09-25T11:55:12.319193Z","corpus_loaded_through":"2026-09-23T22:20:23.317834Z","filing_date_min":"2024-01-27","filing_date_max":"2026-09-16","checked_from":"2026-09-05T02:23:05.982663Z","checked_through":"2026-09-23T22:20:23.317834Z","n_priced_setters":3956,"n_filed":291,"n_usable":261,"n_not_usable":0,"n_labelled":19,"n_no_cash":11,"n_estimated":0,"n_states":45,"cash_p10":914.65,"cash_p20":1176.48,"cash_p25":1429.4,"cash_p50":2250.0,"cash_p75":5205.2,"cash_p80":5490.66,"cash_p90":7499.82,"cash_mean_trimmed":2742.84,"gross_p50":3185.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":3,"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":40,"p20":2070.17,"p50":5205.2,"p80":8803.2},{"state":"CO","n":1,"p20":null,"p50":null,"p80":null},{"state":"CT","n":1,"p20":null,"p50":null,"p80":null},{"state":"FL","n":9,"p20":null,"p50":null,"p80":null},{"state":"GA","n":7,"p20":null,"p50":null,"p80":null},{"state":"HI","n":3,"p20":null,"p50":null,"p80":null},{"state":"IA","n":17,"p20":2019.2,"p50":2019.2,"p80":2019.2},{"state":"ID","n":7,"p20":null,"p50":null,"p80":null},{"state":"IL","n":13,"p20":1114.75,"p50":1552.38,"p80":1994.3},{"state":"IN","n":5,"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":"LA","n":1,"p20":null,"p50":null,"p80":null},{"state":"MA","n":4,"p20":null,"p50":null,"p80":null},{"state":"MD","n":1,"p20":null,"p50":null,"p80":null},{"state":"ME","n":3,"p20":null,"p50":null,"p80":null},{"state":"MI","n":11,"p20":1551.2,"p50":1551.2,"p80":4163.25},{"state":"MN","n":4,"p20":null,"p50":null,"p80":null},{"state":"MO","n":5,"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":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":5,"p20":null,"p50":null,"p80":null},{"state":"NV","n":2,"p20":null,"p50":null,"p80":null},{"state":"NY","n":16,"p20":943.99,"p50":2022.0,"p80":5853.3},{"state":"OH","n":6,"p20":null,"p50":null,"p80":null},{"state":"OK","n":10,"p20":1725.7,"p50":1725.7,"p80":1725.7},{"state":"OR","n":5,"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":2770.5,"p50":5595.41,"p80":6394.75},{"state":"VA","n":3,"p20":null,"p50":null,"p80":null},{"state":"VT","n":3,"p20":null,"p50":null,"p80":null},{"state":"WA","n":4,"p20":null,"p50":null,"p80":null},{"state":"WI","n":15,"p20":4010.4,"p50":4163.25,"p80":4163.25},{"state":"WV","n":3,"p20":null,"p50":null,"p80":null},{"state":"WY","n":1,"p20":null,"p50":null,"p80":null}],"by_segment":{"hospital_type":[{"key":"acute","n":213,"p20":1317.33,"p50":2301.0,"p80":5595.41},{"key":"childrens","n":4,"p20":null,"p50":null,"p80":null},{"key":"critical_access","n":43,"p20":999.46,"p50":1735.0,"p80":4163.25}],"ownership":[{"key":"for_profit","n":26,"p20":1114.75,"p50":2231.1,"p80":4532.59},{"key":"government","n":28,"p20":999.46,"p50":1562.4,"p80":2770.5},{"key":"nonprofit","n":206,"p20":1198.2,"p50":2405.0,"p80":5595.41}],"affiliation":[{"key":"affiliated","n":212,"p20":1138.97,"p50":2330.82,"p80":5853.3},{"key":"independent","n":49,"p20":1221.51,"p50":1635.42,"p80":2814.96}]},"histogram":[{"lo":764.4,"hi":976.01,"n":17},{"lo":976.01,"hi":1246.19,"n":28},{"lo":1246.19,"hi":1591.17,"n":31},{"lo":1591.17,"hi":2031.65,"n":37},{"lo":2031.65,"hi":2594.06,"n":22},{"lo":2594.06,"hi":3312.17,"n":14},{"lo":3312.17,"hi":4229.07,"n":18},{"lo":4229.07,"hi":5399.79,"n":29},{"lo":5399.79,"hi":6894.59,"n":19},{"lo":6894.59,"hi":8803.2,"n":27}],"previous":null}},"related":[{"code_type":"CPT","code":"45171","lay_name":"Removal of a rectal tumor, not into the deep muscle layer","slug":"cpt-45171-removal-of-a-rectal-tumor-not-into-the-deep-muscle-layer"},{"code_type":"CPT","code":"44140","lay_name":"Open partial colon removal with rejoining of the bowel","slug":"cpt-44140-open-partial-colon-removal-with-rejoining-of-the-bowel"},{"code_type":"CPT","code":"44204","lay_name":"Keyhole partial colon removal with rejoining of the bowel","slug":"cpt-44204-keyhole-partial-colon-removal-with-rejoining-of-the-bowel"},{"code_type":"CPT","code":"44160","lay_name":"Partial colon removal with end of small bowel, rejoined","slug":"cpt-44160-partial-colon-removal-with-end-of-small-bowel-rejoined"},{"code_type":"CPT","code":"44143","lay_name":"Open partial colon removal with end colostomy","slug":"cpt-44143-open-partial-colon-removal-with-end-colostomy"},{"code_type":"CPT","code":"44139","lay_name":"Freeing the splenic flexure during colon removal","slug":"cpt-44139-freeing-the-splenic-flexure-during-colon-removal"},{"code_type":"CPT","code":"44213","lay_name":"Keyhole freeing of the colon near the spleen, add-on","slug":"cpt-44213-keyhole-freeing-of-the-colon-near-the-spleen-add-on"},{"code_type":"CPT","code":"44205","lay_name":"Keyhole removal of part of the colon with end of small bowel","slug":"cpt-44205-keyhole-removal-of-part-of-the-colon-with-end-of-small-bowel"},{"code_type":"CPT","code":"44207","lay_name":"Keyhole partial colon removal with low rectal reconnection","slug":"cpt-44207-keyhole-partial-colon-removal-with-low-rectal-reconnection"},{"code_type":"CPT","code":"44145","lay_name":"Open partial colon removal with colon-to-rectum rejoining","slug":"cpt-44145-open-partial-colon-removal-with-colon-to-rectum-rejoining"},{"code_type":"CPT","code":"44141","lay_name":"Open partial colon removal with opening from the cecum","slug":"cpt-44141-open-partial-colon-removal-with-opening-from-the-cecum"},{"code_type":"CPT","code":"44206","lay_name":"Keyhole partial colon removal with colostomy","slug":"cpt-44206-keyhole-partial-colon-removal-with-colostomy"}]}