{"procedure":{"code_type":"CPT","code":"47420","lay_name":"Open bile duct exploration with stone removal or drainage","blurb":"Open surgery that opens the common bile duct to explore it, drain it, or remove stones, without cutting or reshaping the muscular valve where the duct enters the intestine.","slug":"cpt-47420-open-bile-duct-exploration-with-stone-removal-or-drainage","description":"Choledochot/Ost W/O Sphnctrotomy/Sphnctrop","name_source":"llm:claude-opus-5","name_reviewed":false,"ccs":{"code":"84","label":"Cholecystectomy and common duct exploration","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-01-27","filing_date_max":"2026-09-22","checked_from":"2026-09-05T02:22:45.006185Z","checked_through":"2026-09-25T01:09:24.241146Z","n_priced_setters":3956,"n_filed":277,"n_usable":238,"n_not_usable":1,"n_labelled":24,"n_no_cash":14,"n_estimated":0,"n_states":46,"cash_p10":1168.38,"cash_p20":1457.75,"cash_p25":1700.56,"cash_p50":2727.2,"cash_p75":3950.76,"cash_p80":4453.5,"cash_p90":6300.45,"cash_mean_trimmed":2678.14,"gross_p50":4113.0,"cash_to_gross_p50":0.65,"medicare_rate":null,"medicare_schedule":null,"medicare_year":null,"cash_to_medicare_p50":null,"by_state":[{"state":"AK","n":2,"p20":null,"p50":null,"p80":null},{"state":"AL","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":25,"p20":2788.8,"p50":2788.8,"p80":2788.8},{"state":"CO","n":2,"p20":null,"p50":null,"p80":null},{"state":"CT","n":1,"p20":null,"p50":null,"p80":null},{"state":"FL","n":3,"p20":null,"p50":null,"p80":null},{"state":"GA","n":1,"p20":null,"p50":null,"p80":null},{"state":"HI","n":4,"p20":null,"p50":null,"p80":null},{"state":"IA","n":14,"p20":3291.2,"p50":3291.2,"p80":3291.2},{"state":"ID","n":1,"p20":null,"p50":null,"p80":null},{"state":"IL","n":12,"p20":1457.75,"p50":1881.78,"p80":3561.6},{"state":"IN","n":5,"p20":null,"p50":null,"p80":null},{"state":"KS","n":3,"p20":null,"p50":null,"p80":null},{"state":"KY","n":5,"p20":null,"p50":null,"p80":null},{"state":"LA","n":2,"p20":null,"p50":null,"p80":null},{"state":"MA","n":1,"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":12,"p20":1719.2,"p50":1863.21,"p80":1981.6},{"state":"MN","n":4,"p20":null,"p50":null,"p80":null},{"state":"MO","n":6,"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":2,"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":13,"p20":4350.0,"p50":5110.0,"p80":5855.0},{"state":"NM","n":1,"p20":null,"p50":null,"p80":null},{"state":"NV","n":2,"p20":null,"p50":null,"p80":null},{"state":"NY","n":9,"p20":null,"p50":null,"p80":null},{"state":"OH","n":10,"p20":2069.1,"p50":4983.21,"p80":6300.45},{"state":"OK","n":10,"p20":2200.1,"p50":2200.1,"p80":2200.1},{"state":"OR","n":11,"p20":2444.65,"p50":3280.0,"p80":3638.4},{"state":"PA","n":18,"p20":193.58,"p50":247.06,"p80":4514.96},{"state":"SD","n":1,"p20":null,"p50":null,"p80":null},{"state":"TN","n":1,"p20":null,"p50":null,"p80":null},{"state":"TX","n":5,"p20":null,"p50":null,"p80":null},{"state":"VA","n":3,"p20":null,"p50":null,"p80":null},{"state":"VT","n":3,"p20":null,"p50":null,"p80":null},{"state":"WA","n":6,"p20":null,"p50":null,"p80":null},{"state":"WI","n":8,"p20":null,"p50":null,"p80":null},{"state":"WV","n":10,"p20":1433.5,"p50":1456.0,"p80":3687.0},{"state":"WY","n":3,"p20":null,"p50":null,"p80":null}],"by_segment":{"hospital_type":[{"key":"acute","n":184,"p20":1457.75,"p50":2788.8,"p80":4390.77},{"key":"childrens","n":4,"p20":null,"p50":null,"p80":null},{"key":"critical_access","n":49,"p20":1456.0,"p50":2210.1,"p80":4902.3}],"ownership":[{"key":"for_profit","n":14,"p20":null,"p50":null,"p80":null},{"key":"government","n":37,"p20":1350.0,"p50":2220.0,"p80":4165.7},{"key":"nonprofit","n":186,"p20":1675.92,"p50":2788.8,"p80":4514.96}],"affiliation":[{"key":"affiliated","n":184,"p20":1457.75,"p50":2788.8,"p80":4514.96},{"key":"independent","n":54,"p20":1608.13,"p50":2596.0,"p80":4453.5}]},"histogram":[{"lo":395.5,"hi":536.11,"n":3},{"lo":536.11,"hi":726.7,"n":1},{"lo":726.7,"hi":985.06,"n":5},{"lo":985.06,"hi":1335.27,"n":6},{"lo":1335.27,"hi":1809.98,"n":35},{"lo":1809.98,"hi":2453.46,"n":53},{"lo":2453.46,"hi":3325.71,"n":47},{"lo":3325.71,"hi":4508.06,"n":31},{"lo":4508.06,"hi":6110.75,"n":20},{"lo":6110.75,"hi":8283.24,"n":21}],"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-01-27","filing_date_max":"2026-09-16","checked_from":"2026-09-05T02:23:05.982663Z","checked_through":"2026-09-25T01:09:24.241146Z","n_priced_setters":3956,"n_filed":187,"n_usable":167,"n_not_usable":0,"n_labelled":16,"n_no_cash":4,"n_estimated":0,"n_states":41,"cash_p10":886.38,"cash_p20":1388.4,"cash_p25":1457.75,"cash_p50":2444.65,"cash_p75":3291.2,"cash_p80":3306.79,"cash_p90":4453.5,"cash_mean_trimmed":2380.17,"gross_p50":4114.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":21,"p20":2788.8,"p50":2788.8,"p80":2788.8},{"state":"CO","n":1,"p20":null,"p50":null,"p80":null},{"state":"CT","n":1,"p20":null,"p50":null,"p80":null},{"state":"FL","n":1,"p20":null,"p50":null,"p80":null},{"state":"GA","n":1,"p20":null,"p50":null,"p80":null},{"state":"HI","n":4,"p20":null,"p50":null,"p80":null},{"state":"IA","n":15,"p20":3291.2,"p50":3291.2,"p80":3291.2},{"state":"ID","n":1,"p20":null,"p50":null,"p80":null},{"state":"IL","n":11,"p20":1457.75,"p50":2521.8,"p80":3223.5},{"state":"IN","n":9,"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":"MA","n":1,"p20":null,"p50":null,"p80":null},{"state":"ME","n":1,"p20":null,"p50":null,"p80":null},{"state":"MI","n":7,"p20":null,"p50":null,"p80":null},{"state":"MN","n":2,"p20":null,"p50":null,"p80":null},{"state":"MO","n":3,"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":1,"p20":null,"p50":null,"p80":null},{"state":"NH","n":5,"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":7,"p20":null,"p50":null,"p80":null},{"state":"OH","n":3,"p20":null,"p50":null,"p80":null},{"state":"OK","n":10,"p20":2200.1,"p50":2200.1,"p80":2200.1},{"state":"OR","n":5,"p20":null,"p50":null,"p80":null},{"state":"PA","n":17,"p20":193.58,"p50":247.06,"p80":4514.96},{"state":"TN","n":4,"p20":null,"p50":null,"p80":null},{"state":"TX","n":4,"p20":null,"p50":null,"p80":null},{"state":"VA","n":3,"p20":null,"p50":null,"p80":null},{"state":"VT","n":3,"p20":null,"p50":null,"p80":null},{"state":"WA","n":5,"p20":null,"p50":null,"p80":null},{"state":"WI","n":1,"p20":null,"p50":null,"p80":null},{"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":142,"p20":1388.4,"p50":2444.65,"p80":3597.78},{"key":"childrens","n":1,"p20":null,"p50":null,"p80":null},{"key":"critical_access","n":23,"p20":1388.4,"p50":1986.88,"p80":2752.2}],"ownership":[{"key":"for_profit","n":16,"p20":null,"p50":null,"p80":null},{"key":"government","n":22,"p20":1350.0,"p50":2161.91,"p80":3306.79},{"key":"nonprofit","n":128,"p20":1457.75,"p50":2521.8,"p80":3291.2}],"affiliation":[{"key":"affiliated","n":132,"p20":1372.5,"p50":2200.1,"p80":3291.2},{"key":"independent","n":35,"p20":1625.6,"p50":2596.0,"p80":4390.77}]},"histogram":[{"lo":247.06,"hi":337.38,"n":1},{"lo":337.38,"hi":460.72,"n":3},{"lo":460.72,"hi":629.15,"n":0},{"lo":629.15,"hi":859.16,"n":2},{"lo":859.16,"hi":1173.25,"n":6},{"lo":1173.25,"hi":1602.17,"n":27},{"lo":1602.17,"hi":2187.9,"n":21},{"lo":2187.9,"hi":2987.75,"n":50},{"lo":2987.75,"hi":4080.02,"n":27},{"lo":4080.02,"hi":5571.6,"n":14}],"previous":null}},"related":[{"code_type":"CPT","code":"47562","lay_name":"Gallbladder removal through small incisions","slug":"cpt-47562-gallbladder-removal-through-small-incisions"},{"code_type":"CPT","code":"47563","lay_name":"Gallbladder removal by laparoscopy with bile duct x-ray","slug":"cpt-47563-gallbladder-removal-by-laparoscopy-with-bile-duct-x-ray"},{"code_type":"CPT","code":"47564","lay_name":"Keyhole gallbladder removal with bile duct exploration","slug":"cpt-47564-keyhole-gallbladder-removal-with-bile-duct-exploration"},{"code_type":"CPT","code":"47600","lay_name":"Open gallbladder removal","slug":"cpt-47600-open-gallbladder-removal"},{"code_type":"CPT","code":"47605","lay_name":"Open gallbladder removal with bile duct X-ray","slug":"cpt-47605-open-gallbladder-removal-with-bile-duct-x-ray"},{"code_type":"CPT","code":"47550","lay_name":"Bile duct scope exam during surgery","slug":"cpt-47550-bile-duct-scope-exam-during-surgery"},{"code_type":"CPT","code":"47610","lay_name":"Open gallbladder removal with bile duct exploration","slug":"cpt-47610-open-gallbladder-removal-with-bile-duct-exploration"},{"code_type":"CPT","code":"47612","lay_name":"Gallbladder removal with bile duct joined to intestine","slug":"cpt-47612-gallbladder-removal-with-bile-duct-joined-to-intestine"},{"code_type":"CPT","code":"47620","lay_name":"Gallbladder removal with cutting of the bile duct opening","slug":"cpt-47620-gallbladder-removal-with-cutting-of-the-bile-duct-opening"},{"code_type":"CPT","code":"47425","lay_name":"Opening of main bile duct with sphincter surgery","slug":"cpt-47425-opening-of-main-bile-duct-with-sphincter-surgery"},{"code_type":"CPT","code":"47460","lay_name":"Cutting or reshaping the bile duct valve through the gut","slug":"cpt-47460-cutting-or-reshaping-the-bile-duct-valve-through-the-gut"},{"code_type":"CPT","code":"47400","lay_name":"Opening of bile duct inside the liver to drain stones","slug":"cpt-47400-opening-of-bile-duct-inside-the-liver-to-drain-stones"}]}