Frequencies for dbo_vwhqi_us_national_mpv_msr dataset : by Jean Roth , jroth@nber.org , 16 Nov 2016 Frequencies for state variable in dbo_vwhqi_us_national_mpv_msr dataset : State | Freq. Percent Cum. ------------+----------------------------------- Nation | 70 100.00 100.00 ------------+----------------------------------- Total | 70 100.00 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 and neck proc exc spinal fusion .. | 1 1.43 5.71 Back and neck proc exc spinal fusion .. | 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 an.. | 1 1.43 11.43 Biopsies of musculoskeletal system an.. | 1 1.43 12.86 Biopsies of musculoskeletal system an.. | 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 and oth maj cardiothora.. | 1 1.43 21.43 Cardiac valve and oth maj cardiothora.. | 1 1.43 22.86 Cardiac valve and oth maj cardiothora.. | 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 and shock w CC | 1 1.43 45.71 Heart failure and shock w MCC | 1 1.43 47.14 Heart failure and shock w/o CC/MCC | 1 1.43 48.57 Hernia procedures except inguinal and.. | 1 1.43 50.00 Hernia procedures except inguinal and.. | 1 1.43 51.43 Hernia procedures except inguinal and.. | 1 1.43 52.86 Kidney and ureter procedures for neop.. | 1 1.43 54.29 Kidney and ureter procedures for neop.. | 1 1.43 55.71 Kidney and ureter procedures for neop.. | 1 1.43 57.14 Kidney and ureter procedures for non-.. | 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 and large bowel procedure.. | 1 1.43 71.43 Major small and large bowel procedure.. | 1 1.43 72.86 Major small and large bowel procedure.. | 1 1.43 74.29 Other kidney and urinary tract proced.. | 1 1.43 75.71 Other kidney and urinary tract proced.. | 1 1.43 77.14 Other kidney and urinary tract proced.. | 1 1.43 78.57 Other musculoskelet sys and conn tiss.. | 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 and 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/o.. | 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 and adnexa proc for non-malig.. | 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. --------------+----------------------------------- 10073 - 13525 | 1 1.43 1.43 10130 - 13307 | 1 1.43 2.86 10249 - 13106 | 1 1.43 4.29 10551 - 13244 | 1 1.43 5.71 10728 - 13581 | 1 1.43 7.14 11320 - 14245 | 1 1.43 8.57 11905 - 15600 | 1 1.43 10.00 12187 - 15498 | 1 1.43 11.43 12845 - 17352 | 1 1.43 12.86 13279 - 17406 | 1 1.43 14.29 13444 - 16698 | 1 1.43 15.71 13549 - 21092 | 1 1.43 17.14 13607 - 17889 | 1 1.43 18.57 13838 - 17543 | 1 1.43 20.00 14067 - 18882 | 1 1.43 21.43 14748 - 20696 | 1 1.43 22.86 15408 - 21108 | 1 1.43 24.29 15840 - 20854 | 1 1.43 25.71 16738 - 22316 | 1 1.43 27.14 17051 - 22266 | 1 1.43 28.57 17848 - 24502 | 1 1.43 30.00 17997 - 26579 | 1 1.43 31.43 18150 - 24701 | 1 1.43 32.86 18342 - 24690 | 1 1.43 34.29 18844 - 25317 | 1 1.43 35.71 18925 - 31346 | 1 1.43 37.14 22888 - 31537 | 1 1.43 38.57 23988 - 36183 | 1 1.43 40.00 24401 - 34793 | 1 1.43 41.43 24844 - 31849 | 1 1.43 42.86 26044 - 40467 | 1 1.43 44.29 27028 - 36668 | 1 1.43 45.71 27272 - 39403 | 1 1.43 47.14 27362 - 39267 | 1 1.43 48.57 27449 - 42932 | 1 1.43 50.00 2846 - 3727 | 1 1.43 51.43 32029 - 43106 | 1 1.43 52.86 3367 - 4274 | 1 1.43 54.29 36816 - 50133 | 1 1.43 55.71 3799 - 4822 | 1 1.43 57.14 3847 - 4754 | 1 1.43 58.57 3848 - 5637 | 1 1.43 60.00 40830 - 62390 | 1 1.43 61.43 4328 - 5518 | 1 1.43 62.86 43366 - 59207 | 1 1.43 64.29 4556 - 5872 | 1 1.43 65.71 5031 - 6408 | 1 1.43 67.14 5173 - 6666 | 1 1.43 68.57 5180 - 6422 | 1 1.43 70.00 5285 - 6708 | 1 1.43 71.43 5305 - 6557 | 1 1.43 72.86 5577 - 8054 | 1 1.43 74.29 6002 - 7519 | 1 1.43 75.71 6002 - 7581 | 1 1.43 77.14 6004 - 7609 | 1 1.43 78.57 6892 - 8590 | 1 1.43 80.00 7020 - 9343 | 1 1.43 81.43 7178 - 9535 | 1 1.43 82.86 7341 - 10052 | 1 1.43 84.29 7569 - 9501 | 1 1.43 85.71 7646 - 9943 | 1 1.43 87.14 7696 - 9939 | 1 1.43 88.57 7805 - 10615 | 1 1.43 90.00 8001 - 9697 | 1 1.43 91.43 8220 - 10337 | 1 1.43 92.86 8528 - 11055 | 1 1.43 94.29 8853 - 10886 | 1 1.43 95.71 8918 - 12960 | 1 1.43 97.14 9201 - 11894 | 1 1.43 98.57 9303 - 12047 | 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. ------------+----------------------------------- 988 | 1 1.43 1.43 1102 | 1 1.43 2.86 2063 | 1 1.43 4.29 3506 | 1 1.43 5.71 3600 | 1 1.43 7.14 3779 | 1 1.43 8.57 3833 | 1 1.43 10.00 4417 | 1 1.43 11.43 5124 | 1 1.43 12.86 5402 | 1 1.43 14.29 5485 | 1 1.43 15.71 5549 | 1 1.43 17.14 5645 | 1 1.43 18.57 5877 | 1 1.43 20.00 6127 | 1 1.43 21.43 6273 | 1 1.43 22.86 6341 | 1 1.43 24.29 6732 | 1 1.43 25.71 8764 | 1 1.43 27.14 9098 | 1 1.43 28.57 9578 | 1 1.43 30.00 9999 | 1 1.43 31.43 10147 | 1 1.43 32.86 10364 | 1 1.43 34.29 10463 | 1 1.43 35.71 10618 | 1 1.43 37.14 11564 | 1 1.43 38.57 13024 | 1 1.43 40.00 13077 | 1 1.43 41.43 14056 | 1 1.43 42.86 15422 | 1 1.43 44.29 16252 | 1 1.43 45.71 17094 | 1 1.43 47.14 18790 | 1 1.43 48.57 18837 | 1 1.43 50.00 20460 | 1 1.43 51.43 22638 | 1 1.43 52.86 23338 | 1 1.43 54.29 26933 | 1 1.43 55.71 27271 | 1 1.43 57.14 28814 | 1 1.43 58.57 28871 | 1 1.43 60.00 29159 | 1 1.43 61.43 29332 | 1 1.43 62.86 29929 | 1 1.43 64.29 30080 | 1 1.43 65.71 33144 | 1 1.43 67.14 33658 | 1 1.43 68.57 34367 | 1 1.43 70.00 39610 | 1 1.43 71.43 41699 | 1 1.43 72.86 41843 | 1 1.43 74.29 49610 | 1 1.43 75.71 52053 | 1 1.43 77.14 53427 | 1 1.43 78.57 53659 | 1 1.43 80.00 58878 | 1 1.43 81.43 67339 | 1 1.43 82.86 71966 | 1 1.43 84.29 94743 | 1 1.43 85.71 139986 | 1 1.43 87.14 149817 | 1 1.43 88.57 156549 | 1 1.43 90.00 156976 | 1 1.43 91.43 169275 | 1 1.43 92.86 172079 | 1 1.43 94.29 200936 | 1 1.43 95.71 223365 | 1 1.43 97.14 264959 | 1 1.43 98.57 480281 | 1 1.43 100.00 ------------+----------------------------------- Total | 70 100.00 by Jean Roth , jroth@nber.org , 16 Nov 2016