2
transparency-in-pricing
source link: https://www.dolthub.com/repositories/dolthub/transparency-in-pricing/data/main/rate
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
dolthub/transparency-in-pricing - rate | DoltHub
Branch
Query
hospital_id | row_id | line_type | description | rev_code | local_code | code | ms_drg | apr_drg | eapg | hcpcs_cpt | modifiers | alt_hcpcs_cpt | thru | apc | icd | ndc | drug_hcpcs_multiplier | drug_quantity | drug_unit_of_measurement | drug_type_of_measurement | billing_class | setting | payer_category | payer_name | plan_name | standard_charge | standard_charge_percent | contracting_method | additional_generic_notes | additional_payer_specific_notes | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
010011 | 161537516867685 | 1-CDM | GUIDE TIB RESECTION SS .050 00597708400 | 0272 | NULL | 78028195 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | gross | Gross_Charge | NULL | 80.00 | NULL | NULL | NULL | NULL | |
010011 | 249997096058832 | 1-CDM | FECAL MICROBIOTA TRANSPLANT 30ML | 0636 | NULL | 70602343 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | max | Max_Negotiated_Rate | NULL | 642.00 | NULL | NULL | NULL | NULL | |
010011 | 295451234627855 | 3-DRG | Cardiac Defibrillator Implant With Card… | NULL | NULL | 223 | 223 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | payer | i200255_BLUE_ADVANTAGE_PART_B_IP_ONLY_2… | NULL | 35156.05 | NULL | NULL | NULL | NULL | |
010011 | 473471384440130 | 1-CDM | ACETAB LINER SZ27 32MM 11-107007 | 0278 | NULL | 78024728 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | min | Min_Negotiated_Rate | NULL | 1345.50 | NULL | NULL | NULL | NULL | |
010011 | 542486266379116 | 3-DRG | Major Chest Procedures Without CC/MCC | NULL | NULL | 165 | 165 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | payer | i200260_BLUE_ADVANTAGE_OUT_OF_STATE_278… | NULL | 10801.31 | NULL | NULL | NULL | NULL | |
010011 | 789494387742852 | 1-CDM | IV PUSH EA ADDTL NEW DRUG | 0260 | NULL | 62066510 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | max | Max_Negotiated_Rate | NULL | 144.42 | NULL | NULL | NULL | NULL | |
010011 | 857357448961671 | 3-DRG | Intraocular Procedures Without CC/MCC | NULL | NULL | 117 | 117 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | payer | i450413_GOLDEN_RULE_2727 | NULL | 9086.22 | NULL | NULL | NULL | NULL | |
010011 | 946505552697359 | 1-CDM | ELECTRODE NIMH EEG 2CH #8227410 | 0272 | NULL | 78011934 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | gross | Gross_Charge | NULL | 216.00 | NULL | NULL | NULL | NULL | |
010011 | 972175763963166 | 1-CDM | SCREW CORTICAL SELF TAP 3.5X44MM 338644 | 0278 | NULL | 78014628 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | payer | i450432_HEALTH_CHOICE_PIGGLY_WIGGLY_171… | NULL | 25.00 | NULL | NULL | NULL | NULL | |
010011 | 981012367514542 | 3-DRG | Gastrointestinal Hemorrhage With CC | NULL | NULL | 378 | 378 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | payer | i150180_VIVA_MEDICARE_ME_CAP_2801 | NULL | 5855.00 | NULL | NULL | NULL | NULL | |
010011 | 1125885781375155 | 1-CDM | SCREW BONE NONLCKING 58813512 | 0278 | NULL | 78023114 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | payer | i450432_HEALTH_CHOICE_PIGGLY_WIGGLY_171… | NULL | 72.00 | NULL | NULL | NULL | NULL | |
010011 | 1246309169513407 | 1-CDM | MESH VENTRALIGHT ST 8 X 10" OVAL 595481… | 0278 | NULL | 70204225 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | cash | Cash_Charge | NULL | 521.01 | NULL | NULL | NULL | NULL | |
010011 | 1343746245285951 | 3-DRG | Major Thumb Or Joint Procedures | NULL | NULL | 506 | 506 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | payer | i450401_UNITED_HEALTHCARE_2727 | NULL | 12906.47 | NULL | NULL | NULL | NULL | |
010011 | 1364313704949465 | 1-CDM | COIL EMB MREYE 5X5 0.038 IMWCE-38-5-5 | 0278 | NULL | 78021991 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | max | Max_Negotiated_Rate | NULL | 110.33 | NULL | NULL | NULL | NULL | |
010011 | 1460780482550800 | 1-CDM | SCREW BONE HEADLESS CMPRSN 658034 | 0278 | NULL | 78019037 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | max | Max_Negotiated_Rate | NULL | 430.11 | NULL | NULL | NULL | NULL | |
010011 | 1662487230546656 | 1-CDM | TX METACARPOPHALANGEAL DISL RT HD 4TH D… | 0450 | NULL | 72306663 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | cash | Cash_Charge | NULL | 86.42 | NULL | NULL | NULL | NULL | |
010011 | 1758699152876491 | 1-CDM | PIN EXT FIX 5X275M 00-5204-090-28 | 0278 | NULL | 78021636 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | payer | i450430_HEALTH_CHOICE_1712 | NULL | 172.00 | NULL | NULL | NULL | NULL | |
010011 | 1768563010450908 | 3-DRG | Infections, Female Reproductive System … | NULL | NULL | 759 | 759 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | payer | i150180_VIVA_MEDICARE_ME_CAP_2798 | NULL | 4027.53 | NULL | NULL | NULL | NULL | |
010011 | 1796667263800840 | 1-CDM | *THYROGLOBULIN ANTIBODY | 0302 | NULL | 70609149 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | cash | Cash_Charge | NULL | 16.59 | NULL | NULL | NULL | NULL | |
010011 | 2236553268469955 | 1-CDM | BONE GRAFT MAT DEM DBM001 | 0278 | NULL | 78022956 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | payer | i450430_HEALTH_CHOICE_1712 | NULL | 102.50 | NULL | NULL | NULL | NULL | |
010011 | 2270134812531527 | 1-CDM | CHROMOSOME INTER/REPORT | 0311 | NULL | 70609119 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | cash | Cash_Charge | NULL | 22.26 | NULL | NULL | NULL | NULL | |
010011 | 2453755260735366 | 1-CDM | SURGICLIP TITANIUM LG 13IN MCL20 | 0272 | NULL | 70207038 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | max | Max_Negotiated_Rate | NULL | 63.80 | NULL | NULL | NULL | NULL | |
010011 | 2548287782480353 | 3-DRG | Cardiac Congenital And Valvular Disorde… | NULL | NULL | 307 | 307 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | min | Min_Negotiated_Rate | NULL | 2016.00 | NULL | NULL | NULL | NULL | |
010011 | 2559880351297369 | 1-CDM | SCRW CORTEX SELF-TAPPING 2.7MM 202.834 | 0278 | NULL | 78023490 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | cash | Cash_Charge | NULL | 16.17 | NULL | NULL | NULL | NULL | |
010011 | 2647837596796627 | 1-CDM | SCREW OST #338632 32MMX3.5 AXSOS | 0278 | NULL | 70202303 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | max | Max_Negotiated_Rate | NULL | 29.50 | NULL | NULL | NULL | NULL | |
010011 | 2722384203806670 | 3-DRG | Upper Limb And Toe Amputation For Circu… | NULL | NULL | 255 | 255 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | payer | i150180_VIVA_MEDICARE_ME_CAP_2798 | NULL | 14991.21 | NULL | NULL | NULL | NULL | |
010011 | 2773515448540277 | 1-CDM | STENT SMART CONTROL 8X80X120 | 0278 | NULL | 71325321 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | gross | Gross_Charge | NULL | 1250.00 | NULL | NULL | NULL | NULL | |
010011 | 2790947166375808 | 1-CDM | EMG W NCS COMPLETE | 0922 | NULL | 71201019 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | max | Max_Negotiated_Rate | NULL | 455.30 | NULL | NULL | NULL | NULL | |
010011 | 2915094882053506 | 1-CDM | DEOXYRIBONUCLEASE ANTIBODY | 0302 | NULL | 70649243 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | gross | Gross_Charge | NULL | 66.00 | NULL | NULL | NULL | NULL | |
010011 | 2923886640510048 | 1-CDM | LIVER KIDNEY MICROSOME-1 AB IGG | 0302 | NULL | 70649353 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | payer | i400409_MUTUAL_OF_OMAHA_1933 | NULL | 41.76 | NULL | NULL | NULL | NULL | |
010011 | 3135084237023103 | 3-DRG | Other Hepatobiliary Or Pancreas O.R. Pr… | NULL | NULL | 425 | 425 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | payer | i450403_UNITED_BEHAVIORAL_HEALTH_2727 | NULL | 13497.70 | NULL | NULL | NULL | NULL | |
010011 | 3220513891659782 | 3-DRG | Peritoneal Adhesiolysis With MCC | NULL | NULL | 335 | 335 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | payer | i150186_MEDICARE_VIVA_OPEN_ACCESS_2798 | NULL | 22934.26 | NULL | NULL | NULL | NULL | |
010011 | 3696199992721914 | 3-DRG | Penis Procedures Without CC/MCC | NULL | NULL | 710 | 710 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | payer | i150195_VIVA_MCR_ME_CAP_OOP_STVHS_2798 | NULL | 9431.55 | NULL | NULL | NULL | NULL | |
010011 | 3750870107446836 | 1-CDM | CATH BLLN DILAT ELATION 18-20MM ECB18 | 0272 | NULL | 73206595 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | gross | Gross_Charge | NULL | 388.50 | NULL | NULL | NULL | NULL | |
010011 | 3767723412770576 | 1-CDM | OMNILINK ELITE 8.0 X 29 135CM | 0278 | NULL | 71323463 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | gross | Gross_Charge | NULL | 1276.00 | NULL | NULL | NULL | NULL | |
010011 | 3791139772889030 | 1-CDM | MR BRACHIAL PLEX W/WO | 0610 | NULL | 71449302 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | cash | Cash_Charge | NULL | 1812.09 | NULL | NULL | NULL | NULL | |
010011 | 3878923946887625 | 1-CDM | DRILL BIT SURGICAL CANNU AR-8943-02 | 0272 | NULL | 78021816 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | gross | Gross_Charge | NULL | 438.00 | NULL | NULL | NULL | NULL | |
010011 | 4116614718721048 | 1-CDM | SCREW VUEPOINT 4.5X30 8975730 | 0278 | NULL | 78022902 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | gross | Gross_Charge | NULL | 1250.00 | NULL | NULL | NULL | NULL | |
010011 | 4134346636281004 | 1-CDM | PLATE BONELOCKING 6HOLE 75M 628006S | 0278 | NULL | 78019887 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | min | Min_Negotiated_Rate | NULL | 693.42 | NULL | NULL | NULL | NULL | |
010011 | 4596009990876818 | 1-CDM | HUMERAL NAIL TI PROX 04.016.035S | 0278 | NULL | 78028707 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | payer | i400409_MUTUAL_OF_OMAHA_1933 | NULL | 1928.50 | NULL | NULL | NULL | NULL | |
010011 | 4653547311036317 | 3-DRG | Malignancy Of Hepatobiliary System Or P… | NULL | NULL | 435 | 435 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | payer | i450425_GEHA_2727 | NULL | 15329.99 | NULL | NULL | NULL | NULL | |
010011 | 5663241906153131 | 1-CDM | CATH 6FR XBC4 GUIDE 67007400 | 0272 | NULL | 71325864 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | payer | i400409_MUTUAL_OF_OMAHA_1933 | NULL | 57.42 | NULL | NULL | NULL | NULL | |
010011 | 5716364732709791 | 1-CDM | ANGIOSCULPT OTW 4.0 X 40 | 0272 | NULL | 71323860 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | max | Max_Negotiated_Rate | NULL | 1087.50 | NULL | NULL | NULL | NULL | |
010011 | 5738076654837123 | 3-DRG | Craniotomy And Endovascular Intracrania… | NULL | NULL | 27 | 027 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | payer | i450400_HUMANA_PPO_2774 | NULL | 32600.65 | NULL | NULL | NULL | NULL | |
010011 | 5872888941673277 | 1-CDM | BETA 2 GLYCOPROT 1 AB IGA | 0302 | NULL | 70608070 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | max | Max_Negotiated_Rate | NULL | 73.08 | NULL | NULL | NULL | NULL | |
010011 | 6017780618301616 | 1-CDM | ALLERGEN SPECIFIC IGE TIMOTHY | 0302 | NULL | 70649697 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | max | Max_Negotiated_Rate | NULL | 15.08 | NULL | NULL | NULL | NULL | |
010011 | 6205400043075555 | 1-CDM | MPL CODON 515 MUTATION DETECTION | 0300 | NULL | 70601152 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | payer | i400409_MUTUAL_OF_OMAHA_1933 | NULL | 433.26 | NULL | NULL | NULL | NULL | |
010011 | 6245424406203445 | 1-CDM | SCREW LAG HIP 10.5X85MM 814510085 | 0278 | NULL | 78024150 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | payer | i450432_HEALTH_CHOICE_PIGGLY_WIGGLY_171… | NULL | 629.50 | NULL | NULL | NULL | NULL | |
010011 | 6370104799257444 | 1-CDM | TISSUE EXPANDER 850ML #133FV-16 | 0278 | NULL | 70200717 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | gross | Gross_Charge | NULL | 2748.50 | NULL | NULL | NULL | NULL | |
010011 | 6371007544902241 | 3-DRG | Cellulitis With MCC | NULL | NULL | 602 | 602 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | payer | i400434_UMWA_2720 | NULL | 8468.89 | NULL | NULL | NULL | NULL |
Loading rows ...
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK