Frequencies for dbo_vwhqi_us_national_mpv_msr dataset : by Jean Roth , jroth@nber.org , 16 Nov 2016 Frequencies for drg variable in dbo_vwhqi_us_national_mpv_msr dataset : Diagnosis | Related | Group ID | Freq. Percent Cum. ------------+----------------------------------- 38 | 1 1.43 1.43 39 | 1 1.43 2.86 190 | 1 1.43 4.29 191 | 1 1.43 5.71 192 | 1 1.43 7.14 193 | 1 1.43 8.57 219 | 1 1.43 10.00 220 | 1 1.43 11.43 221 | 1 1.43 12.86 224 | 1 1.43 14.29 225 | 1 1.43 15.71 226 | 1 1.43 17.14 227 | 1 1.43 18.57 235 | 1 1.43 20.00 236 | 1 1.43 21.43 237 | 1 1.43 22.86 243 | 1 1.43 24.29 244 | 1 1.43 25.71 247 | 1 1.43 27.14 280 | 1 1.43 28.57 281 | 1 1.43 30.00 282 | 1 1.43 31.43 291 | 1 1.43 32.86 292 | 1 1.43 34.29 293 | 1 1.43 35.71 313 | 1 1.43 37.14 328 | 1 1.43 38.57 329 | 1 1.43 40.00 330 | 1 1.43 41.43 331 | 1 1.43 42.86 353 | 1 1.43 44.29 354 | 1 1.43 45.71 355 | 1 1.43 47.14 414 | 1 1.43 48.57 417 | 1 1.43 50.00 418 | 1 1.43 51.43 419 | 1 1.43 52.86 459 | 1 1.43 54.29 460 | 1 1.43 55.71 461 | 1 1.43 57.14 462 | 1 1.43 58.57 466 | 1 1.43 60.00 467 | 1 1.43 61.43 468 | 1 1.43 62.86 469 | 1 1.43 64.29 470 | 1 1.43 65.71 471 | 1 1.43 67.14 472 | 1 1.43 68.57 473 | 1 1.43 70.00 477 | 1 1.43 71.43 478 | 1 1.43 72.86 479 | 1 1.43 74.29 490 | 1 1.43 75.71 491 | 1 1.43 77.14 507 | 1 1.43 78.57 508 | 1 1.43 80.00 515 | 1 1.43 81.43 637 | 1 1.43 82.86 656 | 1 1.43 84.29 657 | 1 1.43 85.71 658 | 1 1.43 87.14 659 | 1 1.43 88.57 668 | 1 1.43 90.00 673 | 1 1.43 91.43 674 | 1 1.43 92.86 675 | 1 1.43 94.29 713 | 1 1.43 95.71 714 | 1 1.43 97.14 743 | 1 1.43 98.57 748 | 1 1.43 100.00 ------------+----------------------------------- Total | 70 100.00 Frequencies for drgname variable in dbo_vwhqi_us_national_mpv_msr dataset : Diagnosis Related Group Name | Freq. Percent Cum. ----------------------------------------+----------------------------------- Acute myocardial infarction, discharg.. | 1 1.43 1.43 Acute myocardial infarction, discharg.. | 1 1.43 2.86 Acute myocardial infarction, discharg.. | 1 1.43 4.29 Back & neck proc exc spinal fusion w .. | 1 1.43 5.71 Back & neck proc exc spinal fusion w/.. | 1 1.43 7.14 Bilateral or multiple major joint pro.. | 1 1.43 8.57 Bilateral or multiple major joint pro.. | 1 1.43 10.00 Biopsies of musculoskeletal system & .. | 1 1.43 11.43 Biopsies of musculoskeletal system & .. | 1 1.43 12.86 Biopsies of musculoskeletal system & .. | 1 1.43 14.29 Cardiac defib implant w cardiac cath .. | 1 1.43 15.71 Cardiac defib implant w cardiac cath .. | 1 1.43 17.14 Cardiac defibrillator implant w/o car.. | 1 1.43 18.57 Cardiac defibrillator implant w/o car.. | 1 1.43 20.00 Cardiac valve & oth maj cardiothoraci.. | 1 1.43 21.43 Cardiac valve & oth maj cardiothoraci.. | 1 1.43 22.86 Cardiac valve & oth maj cardiothoraci.. | 1 1.43 24.29 Cervical spinal fusion w CC | 1 1.43 25.71 Cervical spinal fusion w MCC | 1 1.43 27.14 Cervical spinal fusion w/o CC/MCC | 1 1.43 28.57 Chest Pain | 1 1.43 30.00 Cholecystectomy except by laparoscope.. | 1 1.43 31.43 Chronic obstructive pulmonary disease.. | 1 1.43 32.86 Chronic obstructive pulmonary disease.. | 1 1.43 34.29 Chronic obstructive pulmonary disease.. | 1 1.43 35.71 Coronary bypass w/o cardiac cath w MCC | 1 1.43 37.14 Coronary bypass w/o cardiac cath w/o .. | 1 1.43 38.57 Diabetes w MCC | 1 1.43 40.00 Extracranial procedures w CC | 1 1.43 41.43 Extracranial procedures w/o CC/MCC | 1 1.43 42.86 Female reproductive system reconstruc.. | 1 1.43 44.29 Heart failure & shock w CC | 1 1.43 45.71 Heart failure & shock w MCC | 1 1.43 47.14 Heart failure & shock w/o CC/MCC | 1 1.43 48.57 Hernia procedures except inguinal & f.. | 1 1.43 50.00 Hernia procedures except inguinal & f.. | 1 1.43 51.43 Hernia procedures except inguinal & f.. | 1 1.43 52.86 Kidney & ureter procedures for neopla.. | 1 1.43 54.29 Kidney & ureter procedures for neopla.. | 1 1.43 55.71 Kidney & ureter procedures for neopla.. | 1 1.43 57.14 Kidney & ureter procedures for non-ne.. | 1 1.43 58.57 Laparoscopic cholecystectomy w/o c.d... | 1 1.43 60.00 Laparoscopic cholecystectomy w/o c.d... | 1 1.43 61.43 Laparoscopic cholecystectomy w/o c.d... | 1 1.43 62.86 Major cardiovasc procedures w MCC or .. | 1 1.43 64.29 Major joint replacement or reattachme.. | 1 1.43 65.71 Major joint replacement or reattachme.. | 1 1.43 67.14 Major shoulder or elbow joint procedu.. | 1 1.43 68.57 Major shoulder or elbow joint procedu.. | 1 1.43 70.00 Major small & large bowel procedures .. | 1 1.43 71.43 Major small & large bowel procedures .. | 1 1.43 72.86 Major small & large bowel procedures .. | 1 1.43 74.29 Other kidney & urinary tract procedur.. | 1 1.43 75.71 Other kidney & urinary tract procedur.. | 1 1.43 77.14 Other kidney & urinary tract procedur.. | 1 1.43 78.57 Other musculoskelet sys & conn tiss O.. | 1 1.43 80.00 Perc cardiovasc proc w drug-eluting s.. | 1 1.43 81.43 Permanent cardiac pacemaker implant w.. | 1 1.43 82.86 Permanent cardiac pacemaker implant w.. | 1 1.43 84.29 Revision of hip or knee replacement w.. | 1 1.43 85.71 Revision of hip or knee replacement w.. | 1 1.43 87.14 Revision of hip or knee replacement w.. | 1 1.43 88.57 Simple pneumonia & pleurisy w MCC | 1 1.43 90.00 Spinal fusion except cervical w MCC | 1 1.43 91.43 Spinal fusion except cervical w/o MCC | 1 1.43 92.86 Stomach, esophageal & duodenal proc w.. | 1 1.43 94.29 Transurethral procedures w MCC | 1 1.43 95.71 Transurethral prostatectomy w CC/MCC | 1 1.43 97.14 Transurethral prostatectomy w/o CC/MCC | 1 1.43 98.57 Uterine & adnexa proc for non-maligna.. | 1 1.43 100.00 ----------------------------------------+----------------------------------- Total | 70 100.00 Frequencies for medicareaveragepaymentrange variable in dbo_vwhqi_us_national_mpv_msr dataset : Medicare | Average | Payment Range | Freq. Percent Cum. --------------+----------------------------------- 10138 - 13413 | 1 1.43 1.43 10282 - 12913 | 1 1.43 2.86 10305 - 12748 | 1 1.43 4.29 10348 - 12869 | 1 1.43 5.71 10967 - 14443 | 1 1.43 7.14 11194 - 14375 | 1 1.43 8.57 11281 - 14031 | 1 1.43 10.00 11345 - 16860 | 1 1.43 11.43 11356 - 14715 | 1 1.43 12.86 11359 - 14074 | 1 1.43 14.29 12703 - 16812 | 1 1.43 15.71 12725 - 16750 | 1 1.43 17.14 13351 - 17629 | 1 1.43 18.57 13371 - 17842 | 1 1.43 20.00 13434 - 16796 | 1 1.43 21.43 13660 - 18292 | 1 1.43 22.86 13792 - 18949 | 1 1.43 24.29 14439 - 19751 | 1 1.43 25.71 14850 - 18919 | 1 1.43 27.14 15072 - 22546 | 1 1.43 28.57 15526 - 24382 | 1 1.43 30.00 15891 - 21517 | 1 1.43 31.43 16485 - 21250 | 1 1.43 32.86 18334 - 23750 | 1 1.43 34.29 18922 - 24875 | 1 1.43 35.71 19360 - 28211 | 1 1.43 37.14 20367 - 27027 | 1 1.43 38.57 22199 - 31370 | 1 1.43 40.00 23877 - 35299 | 1 1.43 41.43 24073 - 34500 | 1 1.43 42.86 24476 - 36136 | 1 1.43 44.29 27015 - 35815 | 1 1.43 45.71 27261 - 35816 | 1 1.43 47.14 2897 - 3751 | 1 1.43 48.57 29488 - 40684 | 1 1.43 50.00 32162 - 44457 | 1 1.43 51.43 33688 - 44020 | 1 1.43 52.86 3547 - 4425 | 1 1.43 54.29 36687 - 55989 | 1 1.43 55.71 39909 - 54615 | 1 1.43 57.14 4166 - 5181 | 1 1.43 58.57 4240 - 5185 | 1 1.43 60.00 4542 - 5696 | 1 1.43 61.43 4614 - 5865 | 1 1.43 62.86 4687 - 6677 | 1 1.43 64.29 4895 - 5999 | 1 1.43 65.71 5229 - 6487 | 1 1.43 67.14 5253 - 6595 | 1 1.43 68.57 5323 - 6651 | 1 1.43 70.00 5380 - 6859 | 1 1.43 71.43 5683 - 7598 | 1 1.43 72.86 5693 - 6936 | 1 1.43 74.29 5802 - 7163 | 1 1.43 75.71 5937 - 7517 | 1 1.43 77.14 6485 - 8216 | 1 1.43 78.57 6512 - 7949 | 1 1.43 80.00 6538 - 8407 | 1 1.43 81.43 6541 - 8397 | 1 1.43 82.86 7531 - 9630 | 1 1.43 84.29 7659 - 9828 | 1 1.43 85.71 7721 - 9546 | 1 1.43 87.14 7967 - 10186 | 1 1.43 88.57 8341 - 11354 | 1 1.43 90.00 8748 - 11640 | 1 1.43 91.43 8875 - 10607 | 1 1.43 92.86 9025 - 10923 | 1 1.43 94.29 9122 - 11588 | 1 1.43 95.71 9194 - 11822 | 1 1.43 97.14 9546 - 12089 | 1 1.43 98.57 9584 - 12617 | 1 1.43 100.00 --------------+----------------------------------- Total | 70 100.00 Frequencies for cases variable in dbo_vwhqi_us_national_mpv_msr dataset : Number Of | Cases | Freq. Percent Cum. ------------+----------------------------------- 1088 | 1 1.43 1.43 1180 | 1 1.43 2.86 2305 | 1 1.43 4.29 3206 | 1 1.43 5.71 3420 | 1 1.43 7.14 3701 | 1 1.43 8.57 4097 | 1 1.43 10.00 4806 | 1 1.43 11.43 5135 | 1 1.43 12.86 5204 | 1 1.43 14.29 5251 | 1 1.43 15.71 5533 | 1 1.43 17.14 5553 | 1 1.43 18.57 5683 | 1 1.43 20.00 5790 | 1 1.43 21.43 5898 | 1 1.43 22.86 6032 | 1 1.43 24.29 8740 | 1 1.43 25.71 8883 | 1 1.43 27.14 8931 | 1 1.43 28.57 9345 | 1 1.43 30.00 9447 | 1 1.43 31.43 9903 | 1 1.43 32.86 9945 | 1 1.43 34.29 10237 | 1 1.43 35.71 10469 | 1 1.43 37.14 11933 | 1 1.43 38.57 12347 | 1 1.43 40.00 13879 | 1 1.43 41.43 14801 | 1 1.43 42.86 14848 | 1 1.43 44.29 15751 | 1 1.43 45.71 16300 | 1 1.43 47.14 16611 | 1 1.43 48.57 19609 | 1 1.43 50.00 19681 | 1 1.43 51.43 21796 | 1 1.43 52.86 22020 | 1 1.43 54.29 26083 | 1 1.43 55.71 26486 | 1 1.43 57.14 27055 | 1 1.43 58.57 28123 | 1 1.43 60.00 28881 | 1 1.43 61.43 29313 | 1 1.43 62.86 29834 | 1 1.43 64.29 30299 | 1 1.43 65.71 33693 | 1 1.43 67.14 35576 | 1 1.43 68.57 38554 | 1 1.43 70.00 40495 | 1 1.43 71.43 43141 | 1 1.43 72.86 47082 | 1 1.43 74.29 53668 | 1 1.43 75.71 55649 | 1 1.43 77.14 57008 | 1 1.43 78.57 57668 | 1 1.43 80.00 58343 | 1 1.43 81.43 62955 | 1 1.43 82.86 68650 | 1 1.43 84.29 90512 | 1 1.43 85.71 127156 | 1 1.43 87.14 142756 | 1 1.43 88.57 152186 | 1 1.43 90.00 156694 | 1 1.43 91.43 171992 | 1 1.43 92.86 172587 | 1 1.43 94.29 217104 | 1 1.43 95.71 226741 | 1 1.43 97.14 233893 | 1 1.43 98.57 464290 | 1 1.43 100.00 ------------+----------------------------------- Total | 70 100.00 by Jean Roth , jroth@nber.org , 16 Nov 2016