Summary statistics for nhamcsopd2009 dataset : by Jean Roth , jroth@nber.org , 28 Mar 2016 Variable | Obs Mean Std. Dev. Min Max -------------+--------------------------------------------------------- vmonth | 33,551 6.302316 3.522635 1 12 vyear | 33,551 2008.987 .1115755 2008 2009 vdayr | 33,551 3.902477 1.446543 1 7 age | 33,551 39.44321 24.04523 0 100 sex | 33,551 1.390689 .487912 1 2 -------------+--------------------------------------------------------- ethun | 33,551 .1556138 3.91968 -9 2 raceun | 33,551 .0937677 3.534986 -9 6 paypriv | 33,551 .3841018 .4863894 0 1 paymcare | 33,551 .1950463 .3962423 0 1 paymcaid | 33,551 .3533725 .4780242 0 1 -------------+--------------------------------------------------------- paywkcmp | 33,551 .0067956 .0821562 0 1 payself | 33,551 .1006825 .3009124 0 1 paynochg | 33,551 .0340079 .1812522 0 1 payoth | 33,551 .0431284 .2031491 0 1 paydk | 33,551 .0299842 .1705462 0 1 -------------+--------------------------------------------------------- paytyper | 33,551 2.070728 2.604428 -9 7 usetobac | 33,551 -2.440553 4.540098 -9 2 injdet | 33,551 4.477273 1.572438 -9 8 injury | 33,551 .1413669 .3484048 0 1 rfv1 | 33,551 29921.53 15515.92 -9 89980 -------------+--------------------------------------------------------- rfv2 | 33,551 8741.111 14931.81 -9 89980 rfv3 | 33,551 2679.329 8720.529 -9 89980 rfv13d | 33,551 2992.137 1551.59 0 8998 rfv23d | 33,551 874.6852 1492.829 0 8998 rfv33d | 33,551 268.7162 871.8 0 8998 -------------+--------------------------------------------------------- primcare | 33,551 .6972668 3.031519 -9 2 refer | 33,551 -2.634705 4.577691 -9 2 senbefor | 33,551 1.19451 .3958288 1 2 pastvis | 33,551 3.452475 10.38911 -7 99 major | 33,551 2.325713 2.136941 -9 5 -------------+--------------------------------------------------------- diag1 | 0 diag2 | 0 diag3 | 0 diag13d | 0 diag23d | 0 -------------+--------------------------------------------------------- diag33d | 0 prdiag1 | 33,551 -.0861077 .8047222 -7 1 prdiag2 | 33,551 -3.568567 3.509587 -7 1 prdiag3 | 33,551 -5.4058 2.940787 -7 1 arthrtis | 33,551 .09189 .2888749 0 1 -------------+--------------------------------------------------------- asthma | 33,551 .0770767 .2667171 0 1 cancer | 33,551 .0713243 .2573695 0 1 cebvd | 33,551 .0163333 .1267558 0 1 crf | 33,551 .0167208 .1282253 0 1 chf | 33,551 .0216685 .1456009 0 1 -------------+--------------------------------------------------------- copd | 33,551 .0300438 .1707104 0 1 deprn | 33,551 .1199964 .3249622 0 1 diabetes | 33,551 .1348097 .3415253 0 1 hyplipid | 33,551 .1024709 .303271 0 1 htn | 33,551 .2250902 .4176479 0 1 -------------+--------------------------------------------------------- ihd | 33,551 .023427 .1512577 0 1 obesity | 33,551 .0796996 .2708315 0 1 ostprsis | 33,551 .0167208 .1282253 0 1 nochron | 33,551 .4981074 .5487726 0 2 totchron | 33,551 .7971148 2.049419 -9 10 -------------+--------------------------------------------------------- htin | 33,551 24.65798 35.94887 -9 85 wtlb | 33,551 102.088 98.19139 -9 500 bmi | 33,551 5.48738 18.64082 -9 93.53 tempf | 33,551 402.2562 487.3259 -9 1050 bpsys | 33,551 70.59286 66.76302 -9 240 -------------+--------------------------------------------------------- bpdias | 33,551 40.84817 49.62869 -9 998 services | 33,551 .9562159 .2046174 0 1 breast | 33,551 .0485529 .2149347 0 1 foot | 33,551 .033233 .1792471 0 1 pelvic | 33,551 .0640815 .2449018 0 1 -------------+--------------------------------------------------------- rectal | 33,551 .0160055 .1254981 0 1 retinal | 33,551 .0248577 .1556936 0 1 skin | 33,551 .1795177 .383791 0 1 depress | 33,551 .0182707 .1339306 0 1 anyimage | 33,551 .1560013 .362862 0 1 -------------+--------------------------------------------------------- xray | 33,551 .0606539 .238698 0 1 bonedens | 33,551 .0020566 .0453034 0 1 catscan | 33,551 .0193437 .1377319 0 1 echocard | 33,551 .0129355 .1129982 0 1 othultra | 33,551 .0380615 .1913475 0 1 -------------+--------------------------------------------------------- mammo | 33,551 .0155286 .1236443 0 1 mri | 33,551 .0173467 .1305616 0 1 othimage | 33,551 .0104617 .1017475 0 1 cbc | 33,551 .1126345 .3161502 0 1 glucose | 33,551 .0609818 .2393005 0 1 -------------+--------------------------------------------------------- hgba | 33,551 .0346338 .1828533 0 1 cholest | 33,551 .0418169 .2001736 0 1 psa | 33,551 .0078686 .0883569 0 1 otherbld | 33,551 .1304283 .3367791 0 1 sigcolon | 33,551 .0072725 .0849696 0 1 -------------+--------------------------------------------------------- exam | 33,551 .1992787 .399464 0 1 biopsy | 33,551 .0111174 .1048529 0 1 chlamyd | 33,551 .0135316 .1155376 0 1 ekg | 33,551 .0234568 .1513515 0 1 hivtest | 33,551 .0109982 .1042955 0 1 -------------+--------------------------------------------------------- hpvdna | 33,551 .0030103 .0547848 0 1 papconv | 33,551 .0073023 .0851423 0 1 papliq | 33,551 .0140681 .1177737 0 1 papunsp | 33,551 .006885 .0826912 0 1 pregtest | 33,551 .012101 .1093385 0 1 -------------+--------------------------------------------------------- urine | 33,551 .0843492 .2779149 0 1 httake | 33,551 .4807904 .4996383 0 1 wttake | 33,551 .67381 .4688247 0 1 temptake | 33,551 .4159936 .4928997 0 1 blodpres | 33,551 .6004888 .4898052 0 1 -------------+--------------------------------------------------------- cam | 33,551 .0031594 .0561202 0 1 dme | 33,551 .0134422 .1151604 0 1 homehlth | 33,551 .0059015 .0765951 0 1 pt | 33,551 .0277786 .1643404 0 1 spocther | 33,551 .005663 .0750408 0 1 -------------+--------------------------------------------------------- psychoth | 33,551 .043188 .2032831 0 1 othmntl | 33,551 .0506393 .2192634 0 1 excision | 33,551 .018688 .1354226 0 1 wound | 33,551 .0638431 .2444769 0 1 cast | 33,551 .0041728 .0644629 0 1 -------------+--------------------------------------------------------- splint | 33,551 .0101636 .1003027 0 1 othserv | 33,551 .3277101 .4693855 0 1 proc1 | 0 proc2 | 0 proc3 | 0 -------------+--------------------------------------------------------- proc4 | 0 proc5 | 0 proc6 | 0 proc7 | 0 proc8 | 0 -------------+--------------------------------------------------------- proc9 | 0 proc13d | 0 proc23d | 0 proc33d | 0 proc43d | 0 -------------+--------------------------------------------------------- proc53d | 0 proc63d | 0 proc73d | 0 proc83d | 0 proc93d | 0 -------------+--------------------------------------------------------- proc12d | 0 proc22d | 0 proc32d | 0 proc42d | 0 proc52d | 0 -------------+--------------------------------------------------------- proc62d | 0 proc72d | 0 proc82d | 0 proc92d | 0 totserv | 33,551 3.940359 2.394888 0 18 -------------+--------------------------------------------------------- healthed | 33,551 .5046645 .537506 0 2 asthmaed | 33,551 .0117135 .1075948 0 1 dietnutr | 33,551 .1191321 .3239487 0 1 exercise | 33,551 .0715329 .2577167 0 1 famplan | 33,551 .018986 .1364775 0 1 -------------+--------------------------------------------------------- grwthdev | 33,551 .0354088 .1848135 0 1 injprev | 33,551 .0366606 .1879299 0 1 stresmgt | 33,551 .0281065 .1652795 0 1 tobaced | 33,551 .0342464 .1818641 0 1 wtreduc | 33,551 .0297756 .1699701 0 1 -------------+--------------------------------------------------------- othlthed | 33,551 .3305416 .4704152 0 1 tothlted | 33,551 .5409377 1.668428 -9 8 med | 33,551 .7221841 .4859725 0 2 med1 | 0 med2 | 0 -------------+--------------------------------------------------------- med3 | 0 med4 | 0 med5 | 0 med6 | 0 med7 | 0 -------------+--------------------------------------------------------- med8 | 0 ncmed1 | 33,551 -1.302733 4.15264 -9 2 ncmed2 | 33,551 -2.924205 4.395067 -9 2 ncmed3 | 33,551 -4.016602 4.19598 -9 2 ncmed4 | 33,551 -4.755685 3.87457 -9 2 -------------+--------------------------------------------------------- ncmed5 | 33,551 -5.24342 3.557184 -9 2 ncmed6 | 33,551 -5.619743 3.238556 -9 2 ncmed7 | 33,551 -5.924384 2.916775 -9 2 ncmed8 | 33,551 -6.204077 2.556822 -9 2 numnew | 33,551 .5711901 1.08796 0 8 -------------+--------------------------------------------------------- numcont | 33,551 1.73208 2.509942 0 8 nummed | 33,551 2.377813 2.599856 0 8 noprovid | 33,551 .0110578 .1045746 0 1 phys | 33,551 .7842389 .4113554 0 1 physasst | 33,551 .0501028 .2181604 0 1 -------------+--------------------------------------------------------- npnmw | 33,551 .0833954 .2764831 0 1 rnlpn | 33,551 .473041 .4992801 0 1 mhp | 33,551 .043486 .2039516 0 1 othprov | 33,551 .216387 .4117872 0 1 nodisp | 33,551 .0214599 .1449137 0 1 -------------+--------------------------------------------------------- refothmd | 33,551 .1338559 .3405025 0 1 retappt | 33,551 .7295759 .4441855 0 1 eradmhos | 33,551 .0156478 .1241105 0 1 othdisp | 33,551 .1783255 .3827922 0 1 patwt | 33,551 2865.258 4426.949 14 23108 -------------+--------------------------------------------------------- region | 33,551 2.237787 1.068432 1 4 msa | 33,551 1.119788 .3247181 1 2 owner | 33,551 1.326399 .5690636 1 3 hospcode | 33,551 102.2521 59.00802 1 205 clintype | 33,551 2.708831 1.810851 1 6 -------------+--------------------------------------------------------- patcode | 33,551 103.4737 77.17355 1 450 bdatefl | 33,551 .0092695 .0958323 0 1 sexfl | 33,551 .0074215 .0858294 0 1 ethnicfl | 33,551 .1538255 .3607868 0 1 racerfl | 33,551 .1258085 .3316383 0 1 -------------+--------------------------------------------------------- senbefl | 33,551 .0104021 .1014602 0 1 pastfl | 33,551 .1009508 .301268 0 1 drugid1 | 0 prescr1 | 23,036 1.701945 1.406172 1 5 contsub1 | 23,036 5.780344 .89478 2 8 -------------+--------------------------------------------------------- comstat1 | 23,036 1.203117 .4520227 1 3 rx1cat1 | 0 rx1cat2 | 0 rx1cat3 | 0 rx1cat4 | 0 -------------+--------------------------------------------------------- rx1v1c1 | 0 rx1v1c2 | 0 rx1v1c3 | 0 rx1v1c4 | 0 rx1v2c1 | 0 -------------+--------------------------------------------------------- rx1v2c2 | 0 rx1v2c3 | 0 rx1v2c4 | 0 rx1v3c1 | 0 rx1v3c2 | 0 -------------+--------------------------------------------------------- rx1v3c3 | 0 rx1v3c4 | 0 drugid2 | 0 prescr2 | 16,369 1.791496 1.511834 1 5 contsub2 | 16,369 5.801087 .8311925 2 8 -------------+--------------------------------------------------------- comstat2 | 16,369 1.145397 .3991649 1 3 rx2cat1 | 0 rx2cat2 | 0 rx2cat3 | 0 rx2cat4 | 0 -------------+--------------------------------------------------------- rx2v1c1 | 0 rx2v1c2 | 0 rx2v1c3 | 0 rx2v1c4 | 0 rx2v2c1 | 0 -------------+--------------------------------------------------------- rx2v2c2 | 0 rx2v2c3 | 0 rx2v2c4 | 0 rx2v3c1 | 0 rx2v3c2 | 0 -------------+--------------------------------------------------------- rx2v3c3 | 0 rx2v3c4 | 0 drugid3 | 0 prescr3 | 11,874 1.781371 1.512308 1 5 contsub3 | 11,874 5.82348 .7707933 2 8 -------------+--------------------------------------------------------- comstat3 | 11,874 1.128685 .3787689 1 3 rx3cat1 | 0 rx3cat2 | 0 rx3cat3 | 0 rx3cat4 | 0 -------------+--------------------------------------------------------- rx3v1c1 | 0 rx3v1c2 | 0 rx3v1c3 | 0 rx3v1c4 | 0 rx3v2c1 | 0 -------------+--------------------------------------------------------- rx3v2c2 | 0 rx3v2c3 | 0 rx3v2c4 | 0 rx3v3c1 | 0 rx3v3c2 | 0 -------------+--------------------------------------------------------- rx3v3c3 | 0 rx3v3c4 | 0 drugid4 | 0 prescr4 | 8,875 1.82569 1.554702 1 5 contsub4 | 8,875 5.828507 .7614343 2 8 -------------+--------------------------------------------------------- comstat4 | 8,875 1.109972 .3515424 1 3 rx4cat1 | 0 rx4cat2 | 0 rx4cat3 | 0 rx4cat4 | 0 -------------+--------------------------------------------------------- rx4v1c1 | 0 rx4v1c2 | 0 rx4v1c3 | 0 rx4v1c4 | 0 rx4v2c1 | 0 -------------+--------------------------------------------------------- rx4v2c2 | 0 rx4v2c3 | 0 rx4v2c4 | 0 rx4v3c1 | 0 rx4v3c2 | 0 -------------+--------------------------------------------------------- rx4v3c3 | 0 rx4v3c4 | 0 drugid5 | 0 prescr5 | 6,901 1.822779 1.555833 1 5 contsub5 | 6,901 5.84495 .7060911 1 8 -------------+--------------------------------------------------------- comstat5 | 6,901 1.099551 .3397801 1 3 rx5cat1 | 0 rx5cat2 | 0 rx5cat3 | 0 rx5cat4 | 0 -------------+--------------------------------------------------------- rx5v1c1 | 0 rx5v1c2 | 0 rx5v1c3 | 0 rx5v1c4 | 0 rx5v2c1 | 0 -------------+--------------------------------------------------------- rx5v2c2 | 0 rx5v2c3 | 0 rx5v2c4 | 0 rx5v3c1 | 0 rx5v3c2 | 0 -------------+--------------------------------------------------------- rx5v3c3 | 0 rx5v3c4 | 0 drugid6 | 0 prescr6 | 5,402 1.90522 1.613535 1 5 contsub6 | 5,402 5.844317 .7023212 1 8 -------------+--------------------------------------------------------- comstat6 | 5,402 1.099223 .3335292 1 3 rx6cat1 | 0 rx6cat2 | 0 rx6cat3 | 0 rx6cat4 | 0 -------------+--------------------------------------------------------- rx6v1c1 | 0 rx6v1c2 | 0 rx6v1c3 | 0 rx6v1c4 | 0 rx6v2c1 | 0 -------------+--------------------------------------------------------- rx6v2c2 | 0 rx6v2c3 | 0 rx6v2c4 | 0 rx6v3c1 | 0 rx6v3c2 | 0 -------------+--------------------------------------------------------- rx6v3c3 | 0 rx6v3c4 | 0 drugid7 | 0 prescr7 | 4,190 1.855847 1.579056 1 5 contsub7 | 4,190 5.817184 .7534377 2 8 -------------+--------------------------------------------------------- comstat7 | 4,190 1.1 .331774 1 3 rx7cat1 | 0 rx7cat2 | 0 rx7cat3 | 0 rx7cat4 | 0 -------------+--------------------------------------------------------- rx7v1c1 | 0 rx7v1c2 | 0 rx7v1c3 | 0 rx7v1c4 | 0 rx7v2c1 | 0 -------------+--------------------------------------------------------- rx7v2c2 | 0 rx7v2c3 | 0 rx7v2c4 | 0 rx7v3c1 | 0 rx7v3c2 | 0 -------------+--------------------------------------------------------- rx7v3c3 | 0 rx7v3c4 | 0 drugid8 | 0 prescr8 | 3,118 1.898332 1.618863 1 5 contsub8 | 3,118 5.79891 .7739163 2 8 -------------+--------------------------------------------------------- comstat8 | 3,118 1.098781 .3290917 1 3 rx8cat1 | 0 rx8cat2 | 0 rx8cat3 | 0 rx8cat4 | 0 -------------+--------------------------------------------------------- rx8v1c1 | 0 rx8v1c2 | 0 rx8v1c3 | 0 rx8v1c4 | 0 rx8v2c1 | 0 -------------+--------------------------------------------------------- rx8v2c2 | 0 rx8v2c3 | 0 rx8v2c4 | 0 rx8v3c1 | 0 rx8v3c2 | 0 -------------+--------------------------------------------------------- rx8v3c3 | 0 rx8v3c4 | 0 emropd | 33,551 2.003994 1.13704 -8 3 edemogo | 33,551 .8927007 1.475318 -9 2 eprolsto | 33,551 -.4853507 3.693118 -9 2 -------------+--------------------------------------------------------- ecpoeo | 33,551 .9501058 2.366825 -9 2 ewarno | 33,551 -3.705255 4.094765 -9 2 escripo | 33,551 -3.530238 4.229191 -9 4 ectoeo | 33,551 .8826861 2.313456 -9 2 eordero | 33,551 -2.95407 4.162447 -9 4 -------------+--------------------------------------------------------- eresulto | 33,551 .7750589 2.0859 -9 2 erangeo | 33,551 -1.305714 3.718561 -9 2 eimgreso | 33,551 .4448154 2.717507 -9 2 eimageo | 33,551 -1.699264 3.946738 -9 2 epnoteso | 33,551 .9165748 2.108301 -9 2 -------------+--------------------------------------------------------- ehxfuo | 33,551 -2.32929 4.029681 -9 2 eremindo | 33,551 .8406307 2.588009 -9 2 epubhtho | 33,551 .533695 3.162747 -9 2 enotdiso | 33,551 -4.834401 3.727555 -9 2 emrnewo | 33,551 -.3802569 3.869652 -9 3 -------------+--------------------------------------------------------- ccs | 33,551 -2.950672 4.262642 -9 2 ethim | 33,551 1.827308 .3779867 1 2 racer | 33,551 1.357873 .6027759 1 3 racereth | 33,551 1.713213 .9304668 1 4 agedays | 33,551 -1.69682 34.49806 -7 364 -------------+--------------------------------------------------------- ager | 33,551 3.191827 1.47937 1 6 diag1r | 33,551 159199.5 35095.73 -9 209980 diag2r | 33,551 78921.57 83392.09 -9 209970 diag3r | 33,551 36048.4 67925.97 -9 209920 proc1r | 33,551 2800.657 4131.06 -9 9999 -------------+--------------------------------------------------------- proc2r | 33,551 696.1341 2404.682 -9 9999 proc3r | 33,551 203.5317 1364.453 -9 9999 proc4r | 33,551 39.21329 651.6442 -9 9999 proc5r | 33,551 2.74272 318.7372 -9 9929 proc6r | 33,551 -8.452297 63.31713 -9 9925 -------------+--------------------------------------------------------- proc7r | 33,551 -8.599207 53.92314 -9 8605 proc8r | 33,551 -9 0 -9 -9 proc9r | 33,551 -9 0 -9 -9 whocomp | 33,551 1.883908 1.252393 1 5 settype | 33,551 2 0 2 2 -------------+--------------------------------------------------------- year | 33,551 2009 0 2009 2009 cstratm | 33,551 3.01e+07 1.00e+07 2.01e+07 4.04e+07 cpsum | 33,551 50754.18 50028.41 5 100202 opdwt | 33,551 .0774344 1.611054 0 89 pctpovr | 33,551 2.288218 2.396998 -9 4 -------------+--------------------------------------------------------- hincomer | 33,551 1.86367 2.36933 -9 4 pbamorer | 33,551 1.913207 2.397162 -9 4 urbanrur | 33,551 2.213883 2.094384 -9 5 by Jean Roth , jroth@nber.org , 28 Mar 2016