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. --------------+----------------------------------- 10116 - 12857 | 1 1.43 1.43 10294 - 13081 | 1 1.43 2.86 10644 - 13405 | 1 1.43 4.29 10896 - 14606 | 1 1.43 5.71 11051 - 14077 | 1 1.43 7.14 11402 - 14386 | 1 1.43 8.57 11505 - 14244 | 1 1.43 10.00 11649 - 14438 | 1 1.43 11.43 12091 - 15905 | 1 1.43 12.86 12160 - 15239 | 1 1.43 14.29 13044 - 16261 | 1 1.43 15.71 13792 - 17017 | 1 1.43 17.14 14190 - 18127 | 1 1.43 18.57 14379 - 18876 | 1 1.43 20.00 14762 - 19283 | 1 1.43 21.43 14803 - 18444 | 1 1.43 22.86 16147 - 21219 | 1 1.43 24.29 16955 - 22040 | 1 1.43 25.71 17079 - 22381 | 1 1.43 27.14 17258 - 23136 | 1 1.43 28.57 17305 - 22198 | 1 1.43 30.00 17449 - 22970 | 1 1.43 31.43 18528 - 23967 | 1 1.43 32.86 19262 - 25876 | 1 1.43 34.29 19291 - 27640 | 1 1.43 35.71 20233 - 26420 | 1 1.43 37.14 20489 - 26342 | 1 1.43 38.57 21163 - 27327 | 1 1.43 40.00 24331 - 33337 | 1 1.43 41.43 25846 - 34302 | 1 1.43 42.86 26142 - 34113 | 1 1.43 44.29 27717 - 38185 | 1 1.43 45.71 28386 - 38058 | 1 1.43 47.14 29819 - 41483 | 1 1.43 48.57 29828 - 39377 | 1 1.43 50.00 30384 - 41101 | 1 1.43 51.43 31346 - 43425 | 1 1.43 52.86 3139 - 4006 | 1 1.43 54.29 33634 - 45709 | 1 1.43 55.71 34483 - 44902 | 1 1.43 57.14 3690 - 4668 | 1 1.43 58.57 39281 - 52196 | 1 1.43 60.00 3944 - 4900 | 1 1.43 61.43 4062 - 4991 | 1 1.43 62.86 4531 - 5689 | 1 1.43 64.29 45441 - 60020 | 1 1.43 65.71 46057 - 65147 | 1 1.43 67.14 5060 - 6254 | 1 1.43 68.57 5112 - 6505 | 1 1.43 70.00 5439 - 6667 | 1 1.43 71.43 5500 - 6845 | 1 1.43 72.86 5504 - 6951 | 1 1.43 74.29 5724 - 6959 | 1 1.43 75.71 5729 - 7293 | 1 1.43 77.14 6479 - 7997 | 1 1.43 78.57 6481 - 8137 | 1 1.43 80.00 6545 - 8240 | 1 1.43 81.43 6797 - 8387 | 1 1.43 82.86 7167 - 9214 | 1 1.43 84.29 7592 - 9766 | 1 1.43 85.71 7629 - 9986 | 1 1.43 87.14 8034 - 10830 | 1 1.43 88.57 8077 - 10013 | 1 1.43 90.00 8178 - 10922 | 1 1.43 91.43 8240 - 10351 | 1 1.43 92.86 8338 - 10673 | 1 1.43 94.29 8470 - 10403 | 1 1.43 95.71 8667 - 10676 | 1 1.43 97.14 9155 - 11614 | 1 1.43 98.57 9352 - 11328 | 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. ------------+----------------------------------- 682 | 1 1.43 1.43 972 | 1 1.43 2.86 1056 | 1 1.43 4.29 2309 | 1 1.43 5.71 2893 | 1 1.43 7.14 3180 | 1 1.43 8.57 3368 | 1 1.43 10.00 3823 | 1 1.43 11.43 4100 | 1 1.43 12.86 4142 | 1 1.43 14.29 4332 | 1 1.43 15.71 4829 | 1 1.43 17.14 4953 | 1 1.43 18.57 5011 | 1 1.43 20.00 5099 | 1 1.43 21.43 5217 | 1 1.43 22.86 5822 | 1 1.43 24.29 6009 | 1 1.43 25.71 6972 | 1 1.43 27.14 7012 | 1 1.43 28.57 7295 | 1 1.43 30.00 7894 | 1 1.43 31.43 7946 | 1 1.43 32.86 8981 | 1 1.43 34.29 9171 | 1 1.43 35.71 9196 | 1 1.43 37.14 9310 | 1 1.43 38.57 10735 | 1 1.43 40.00 10756 | 1 1.43 41.43 12209 | 1 1.43 42.86 12655 | 1 1.43 44.29 12750 | 1 1.43 45.71 15392 | 1 1.43 47.14 15543 | 1 1.43 48.57 15555 | 1 1.43 50.00 15702 | 1 1.43 51.43 19715 | 1 1.43 52.86 20117 | 1 1.43 54.29 20866 | 1 1.43 55.71 21458 | 1 1.43 57.14 22165 | 1 1.43 58.57 24280 | 1 1.43 60.00 24283 | 1 1.43 61.43 24717 | 1 1.43 62.86 24962 | 1 1.43 64.29 26726 | 1 1.43 65.71 26762 | 1 1.43 67.14 26991 | 1 1.43 68.57 28790 | 1 1.43 70.00 32373 | 1 1.43 71.43 32943 | 1 1.43 72.86 36621 | 1 1.43 74.29 38875 | 1 1.43 75.71 38957 | 1 1.43 77.14 40741 | 1 1.43 78.57 41960 | 1 1.43 80.00 48991 | 1 1.43 81.43 54152 | 1 1.43 82.86 65508 | 1 1.43 84.29 79780 | 1 1.43 85.71 104820 | 1 1.43 87.14 122873 | 1 1.43 88.57 125573 | 1 1.43 90.00 130651 | 1 1.43 91.43 151057 | 1 1.43 92.86 154270 | 1 1.43 94.29 161260 | 1 1.43 95.71 176344 | 1 1.43 97.14 241821 | 1 1.43 98.57 423627 | 1 1.43 100.00 ------------+----------------------------------- Total | 70 100.00 by Jean Roth , jroth@nber.org , 16 Nov 2016