{"procedure":{"code_type":"CPT","code":"31287","lay_name":"Endoscopic surgery to open the sphenoid sinus","blurb":"Endoscopic surgery through the nose that creates an opening into the sphenoid sinus behind the nasal cavity.","slug":"cpt-31287-endoscopic-surgery-to-open-the-sphenoid-sinus","description":"PR Nasal Scopy,Sphenoidotomy","name_source":"llm:claude-opus-5","name_reviewed":false,"ccs":{"code":"33","label":"Other OR therapeutic procedures on nose, mouth and pharynx","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:07:09.005325Z","checked_through":"2026-09-25T01:10:45.071082Z","n_priced_setters":3956,"n_filed":615,"n_usable":549,"n_not_usable":1,"n_labelled":49,"n_no_cash":15,"n_estimated":1,"n_states":50,"cash_p10":331.8,"cash_p20":484.4,"cash_p25":531.76,"cash_p50":2445.3,"cash_p75":7210.32,"cash_p80":8191.77,"cash_p90":12178.26,"cash_mean_trimmed":3208.73,"gross_p50":1739.5,"cash_to_gross_p50":0.6,"medicare_rate":7210.32,"medicare_schedule":"opps","medicare_year":2026,"cash_to_medicare_p50":0.3391,"by_state":[{"state":"AK","n":1,"p20":null,"p50":null,"p80":null},{"state":"AL","n":9,"p20":null,"p50":null,"p80":null},{"state":"AR","n":5,"p20":null,"p50":null,"p80":null},{"state":"AZ","n":3,"p20":null,"p50":null,"p80":null},{"state":"CA","n":47,"p20":2319.08,"p50":3573.72,"p80":6232.8},{"state":"CO","n":5,"p20":null,"p50":null,"p80":null},{"state":"CT","n":1,"p20":null,"p50":null,"p80":null},{"state":"DE","n":1,"p20":null,"p50":null,"p80":null},{"state":"FL","n":13,"p20":1001.0,"p50":11481.18,"p80":12122.0},{"state":"GA","n":15,"p20":1061.0,"p50":6698.0,"p80":7795.6},{"state":"HI","n":5,"p20":null,"p50":null,"p80":null},{"state":"IA","n":22,"p20":501.6,"p50":501.6,"p80":1110.0},{"state":"ID","n":10,"p20":3043.13,"p50":17730.0,"p80":17730.0},{"state":"IL","n":21,"p20":433.36,"p50":552.8,"p80":2960.1},{"state":"IN","n":9,"p20":null,"p50":null,"p80":null},{"state":"KS","n":6,"p20":null,"p50":null,"p80":null},{"state":"KY","n":4,"p20":null,"p50":null,"p80":null},{"state":"LA","n":8,"p20":null,"p50":null,"p80":null},{"state":"MA","n":1,"p20":null,"p50":null,"p80":null},{"state":"MD","n":2,"p20":null,"p50":null,"p80":null},{"state":"ME","n":4,"p20":null,"p50":null,"p80":null},{"state":"MI","n":31,"p20":732.8,"p50":869.8,"p80":9704.27},{"state":"MN","n":21,"p20":450.66,"p50":1690.5,"p80":1983.52},{"state":"MO","n":14,"p20":323.19,"p50":412.8,"p80":22406.42},{"state":"MS","n":10,"p20":1316.99,"p50":1489.71,"p80":6639.31},{"state":"MT","n":3,"p20":null,"p50":null,"p80":null},{"state":"NC","n":7,"p20":null,"p50":null,"p80":null},{"state":"ND","n":1,"p20":null,"p50":null,"p80":null},{"state":"NE","n":6,"p20":null,"p50":null,"p80":null},{"state":"NH","n":5,"p20":null,"p50":null,"p80":null},{"state":"NJ","n":33,"p20":4881.0,"p50":7565.43,"p80":8184.0},{"state":"NM","n":4,"p20":null,"p50":null,"p80":null},{"state":"NV","n":5,"p20":null,"p50":null,"p80":null},{"state":"NY","n":35,"p20":580.0,"p50":7740.0,"p80":8191.77},{"state":"OH","n":16,"p20":571.8,"p50":750.0,"p80":1001.0},{"state":"OK","n":14,"p20":331.8,"p50":331.8,"p80":10745.62},{"state":"OR","n":10,"p20":366.6,"p50":366.6,"p80":513.81},{"state":"PA","n":26,"p20":129.49,"p50":3221.0,"p80":10181.48},{"state":"RI","n":1,"p20":null,"p50":null,"p80":null},{"state":"SC","n":7,"p20":null,"p50":null,"p80":null},{"state":"SD","n":1,"p20":null,"p50":null,"p80":null},{"state":"TN","n":9,"p20":null,"p50":null,"p80":null},{"state":"TX","n":32,"p20":3585.8,"p50":4340.45,"p80":12178.26},{"state":"UT","n":3,"p20":null,"p50":null,"p80":null},{"state":"VA","n":3,"p20":null,"p50":null,"p80":null},{"state":"VT","n":7,"p20":null,"p50":null,"p80":null},{"state":"WA","n":10,"p20":351.05,"p50":471.6,"p80":9239.75},{"state":"WI","n":30,"p20":937.3,"p50":2952.8,"p80":4424.84},{"state":"WV","n":8,"p20":null,"p50":null,"p80":null},{"state":"WY","n":5,"p20":null,"p50":null,"p80":null}],"by_segment":{"hospital_type":[{"key":"acute","n":443,"p20":501.6,"p50":3374.1,"p80":8660.52},{"key":"childrens","n":11,"p20":null,"p50":null,"p80":null},{"key":"critical_access","n":94,"p20":426.0,"p50":937.3,"p80":3374.1}],"ownership":[{"key":"for_profit","n":71,"p20":937.3,"p50":5827.5,"p80":14593.31},{"key":"government","n":90,"p20":365.2,"p50":1183.72,"p80":8191.77},{"key":"nonprofit","n":387,"p20":483.0,"p50":1983.52,"p80":7313.4}],"affiliation":[{"key":"affiliated","n":437,"p20":484.4,"p50":3099.2,"p80":8191.77},{"key":"independent","n":112,"p20":406.98,"p50":1183.72,"p80":7952.5}]},"histogram":[{"lo":233.08,"hi":365.65,"n":41},{"lo":365.65,"hi":573.63,"n":75},{"lo":573.63,"hi":899.91,"n":50},{"lo":899.91,"hi":1411.77,"n":47},{"lo":1411.77,"hi":2214.77,"n":29},{"lo":2214.77,"hi":3474.5,"n":41},{"lo":3474.5,"hi":5450.76,"n":54},{"lo":5450.76,"hi":8551.1,"n":87},{"lo":8551.1,"hi":13414.87,"n":48},{"lo":13414.87,"hi":21045.1,"n":23}],"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-07-01","filing_date_max":"2026-09-08","checked_from":"2026-09-05T02:07:09.005325Z","checked_through":"2026-09-23T22:20:23.317834Z","n_priced_setters":3956,"n_filed":312,"n_usable":276,"n_not_usable":0,"n_labelled":23,"n_no_cash":13,"n_estimated":0,"n_states":42,"cash_p10":286.52,"cash_p20":366.6,"cash_p25":415.5,"cash_p50":819.83,"cash_p75":4340.45,"cash_p80":6232.8,"cash_p90":8226.0,"cash_mean_trimmed":2004.81,"gross_p50":1384.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":3,"p20":null,"p50":null,"p80":null},{"state":"CA","n":40,"p20":3099.2,"p50":3099.2,"p80":6232.8},{"state":"CO","n":1,"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":9,"p20":null,"p50":null,"p80":null},{"state":"HI","n":4,"p20":null,"p50":null,"p80":null},{"state":"IA","n":18,"p20":501.6,"p50":501.6,"p80":1024.8},{"state":"ID","n":7,"p20":null,"p50":null,"p80":null},{"state":"IL","n":14,"p20":433.36,"p50":484.4,"p80":664.2},{"state":"IN","n":10,"p20":268.65,"p50":329.4,"p80":484.4},{"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":"MA","n":1,"p20":null,"p50":null,"p80":null},{"state":"MD","n":2,"p20":null,"p50":null,"p80":null},{"state":"ME","n":4,"p20":null,"p50":null,"p80":null},{"state":"MI","n":11,"p20":732.8,"p50":732.8,"p80":937.3},{"state":"MN","n":7,"p20":null,"p50":null,"p80":null},{"state":"MO","n":5,"p20":null,"p50":null,"p80":null},{"state":"MT","n":2,"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":5,"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":13,"p20":384.0,"p50":580.0,"p80":7740.0},{"state":"OH","n":10,"p20":262.5,"p50":671.3,"p80":7308.0},{"state":"OK","n":11,"p20":331.8,"p50":331.8,"p80":331.8},{"state":"OR","n":7,"p20":null,"p50":null,"p80":null},{"state":"PA","n":9,"p20":null,"p50":null,"p80":null},{"state":"SC","n":2,"p20":null,"p50":null,"p80":null},{"state":"SD","n":1,"p20":null,"p50":null,"p80":null},{"state":"TN","n":5,"p20":null,"p50":null,"p80":null},{"state":"TX","n":22,"p20":3585.8,"p50":3585.8,"p80":4340.45},{"state":"VT","n":6,"p20":null,"p50":null,"p80":null},{"state":"WA","n":6,"p20":null,"p50":null,"p80":null},{"state":"WI","n":13,"p20":937.3,"p50":937.3,"p80":937.3},{"state":"WV","n":5,"p20":null,"p50":null,"p80":null},{"state":"WY","n":2,"p20":null,"p50":null,"p80":null}],"by_segment":{"hospital_type":[{"key":"acute","n":220,"p20":366.6,"p50":937.3,"p80":6232.8},{"key":"childrens","n":6,"p20":null,"p50":null,"p80":null},{"key":"critical_access","n":49,"p20":373.15,"p50":709.75,"p80":2802.8}],"ownership":[{"key":"for_profit","n":28,"p20":331.8,"p50":732.8,"p80":9518.5},{"key":"government","n":40,"p20":356.1,"p50":662.0,"p80":6384.3},{"key":"nonprofit","n":207,"p20":366.6,"p50":937.3,"p80":6232.8}],"affiliation":[{"key":"affiliated","n":219,"p20":366.6,"p50":937.3,"p80":6232.8},{"key":"independent","n":57,"p20":356.1,"p50":659.27,"p80":6149.79}]},"histogram":[{"lo":218.66,"hi":333.53,"n":34},{"lo":333.53,"hi":508.74,"n":57},{"lo":508.74,"hi":775.99,"n":32},{"lo":775.99,"hi":1183.64,"n":27},{"lo":1183.64,"hi":1805.44,"n":4},{"lo":1805.44,"hi":2753.88,"n":7},{"lo":2753.88,"hi":4200.56,"n":29},{"lo":4200.56,"hi":6407.23,"n":32},{"lo":6407.23,"hi":9773.11,"n":17},{"lo":9773.11,"hi":14907.17,"n":11}],"previous":null}},"related":[{"code_type":"CPT","code":"42700","lay_name":"Draining an abscess beside the tonsil","slug":"cpt-42700-draining-an-abscess-beside-the-tonsil"},{"code_type":"CPT","code":"40800","lay_name":"Simple drainage of abscess or blood pocket in the mouth","slug":"cpt-40800-simple-drainage-of-abscess-or-blood-pocket-in-the-mouth"},{"code_type":"CPT","code":"40650","lay_name":"Full-thickness lip repair, red border only","slug":"cpt-40650-full-thickness-lip-repair-red-border-only"},{"code_type":"CPT","code":"40652","lay_name":"Full-thickness lip repair, up to half the lip height","slug":"cpt-40652-full-thickness-lip-repair-up-to-half-the-lip-height"},{"code_type":"CPT","code":"40654","lay_name":"Full-thickness lip repair, more than half the lip height","slug":"cpt-40654-full-thickness-lip-repair-more-than-half-the-lip-height"},{"code_type":"CPT","code":"30000","lay_name":"Drainage of an abscess or blood collection inside the nose","slug":"cpt-30000-drainage-of-an-abscess-or-blood-collection-inside-the-nose"},{"code_type":"CPT","code":"41008","lay_name":"Draining an abscess under the jaw, inside the mouth","slug":"cpt-41008-draining-an-abscess-under-the-jaw-inside-the-mouth"},{"code_type":"CPT","code":"40812","lay_name":"Removal of a mouth lining growth with simple repair","slug":"cpt-40812-removal-of-a-mouth-lining-growth-with-simple-repair"},{"code_type":"CPT","code":"42330","lay_name":"Removal of salivary stone through the mouth, simple","slug":"cpt-42330-removal-of-salivary-stone-through-the-mouth-simple"},{"code_type":"CPT","code":"41000","lay_name":"Drainage of tongue abscess from inside the mouth","slug":"cpt-41000-drainage-of-tongue-abscess-from-inside-the-mouth"},{"code_type":"CPT","code":"40801","lay_name":"Complicated drainage of abscess or cyst in the mouth","slug":"cpt-40801-complicated-drainage-of-abscess-or-cyst-in-the-mouth"},{"code_type":"CPT","code":"30140","lay_name":"Turbinate reduction from beneath the lining","slug":"cpt-30140-turbinate-reduction-from-beneath-the-lining"}]}