Frequencies for first 10,000 rows of dbo_vwhqi_hosp_mpv_msr dataset : by Jean Roth , jroth@nber.org , 16 Nov 2016 Frequencies for first 10,000 rows of provider variable in dbo_vwhqi_hosp_mpv_msr dataset : Provider | Number | Freq. Percent Cum. ------------+----------------------------------- 010001 | 63 0.63 0.63 010005 | 39 0.39 1.02 010006 | 63 0.63 1.65 010007 | 22 0.22 1.87 010008 | 13 0.13 2.00 010011 | 63 0.63 2.63 010012 | 37 0.37 3.00 010016 | 60 0.60 3.60 010019 | 46 0.46 4.06 010021 | 23 0.23 4.29 010022 | 15 0.15 4.44 010023 | 62 0.62 5.06 010024 | 60 0.60 5.66 010025 | 24 0.24 5.90 010027 | 9 0.09 5.99 010029 | 66 0.66 6.65 010032 | 13 0.13 6.78 010033 | 69 0.69 7.47 010034 | 17 0.17 7.64 010035 | 51 0.51 8.15 010036 | 27 0.27 8.42 010038 | 43 0.43 8.85 010039 | 68 0.68 9.53 010040 | 62 0.62 10.15 010043 | 10 0.10 10.25 010044 | 17 0.17 10.42 010045 | 19 0.19 10.61 010046 | 58 0.58 11.19 010047 | 12 0.12 11.31 010049 | 27 0.27 11.58 010050 | 18 0.18 11.76 010051 | 8 0.08 11.84 010052 | 11 0.11 11.95 010054 | 24 0.24 12.19 010055 | 63 0.63 12.82 010056 | 66 0.66 13.48 010058 | 7 0.07 13.55 010059 | 9 0.09 13.64 010061 | 29 0.29 13.93 010062 | 18 0.18 14.11 010065 | 41 0.41 14.52 010066 | 7 0.07 14.59 010069 | 16 0.16 14.75 010073 | 12 0.12 14.87 010078 | 57 0.57 15.44 010079 | 31 0.31 15.75 010083 | 39 0.39 16.14 010085 | 44 0.44 16.58 010086 | 28 0.28 16.86 010087 | 46 0.46 17.32 010089 | 42 0.42 17.74 010090 | 66 0.66 18.40 010091 | 12 0.12 18.52 010092 | 65 0.65 19.17 010095 | 8 0.08 19.25 010097 | 12 0.12 19.37 010099 | 23 0.23 19.60 010100 | 53 0.53 20.13 010101 | 25 0.25 20.38 010102 | 9 0.09 20.47 010103 | 64 0.64 21.11 010104 | 63 0.63 21.74 010108 | 19 0.19 21.93 010109 | 20 0.20 22.13 010110 | 8 0.08 22.21 010112 | 21 0.21 22.42 010113 | 66 0.66 23.08 010114 | 43 0.43 23.51 010118 | 38 0.38 23.89 010120 | 18 0.18 24.07 010125 | 19 0.19 24.26 010126 | 23 0.23 24.49 010128 | 8 0.08 24.57 010129 | 22 0.22 24.79 010130 | 14 0.14 24.93 010131 | 54 0.54 25.47 010137 | 17 0.17 25.64 010138 | 6 0.06 25.70 010139 | 64 0.64 26.34 010144 | 52 0.52 26.86 010146 | 18 0.18 27.04 010148 | 14 0.14 27.18 010149 | 41 0.41 27.59 010150 | 20 0.20 27.79 010152 | 21 0.21 28.00 010157 | 26 0.26 28.26 010158 | 34 0.34 28.60 010164 | 25 0.25 28.85 010168 | 33 0.33 29.18 010169 | 19 0.19 29.37 020001 | 62 0.62 29.99 020006 | 36 0.36 30.35 020008 | 22 0.22 30.57 020012 | 35 0.35 30.92 020017 | 57 0.57 31.49 020018 | 7 0.07 31.56 020024 | 32 0.32 31.88 020026 | 47 0.47 32.35 020027 | 14 0.14 32.49 030001 | 22 0.22 32.71 030002 | 68 0.68 33.39 030006 | 67 0.67 34.06 030007 | 37 0.37 34.43 030010 | 53 0.53 34.96 030011 | 56 0.56 35.52 030012 | 62 0.62 36.14 030013 | 59 0.59 36.73 030014 | 64 0.64 37.37 030016 | 43 0.43 37.80 030022 | 33 0.33 38.13 030023 | 60 0.60 38.73 030024 | 58 0.58 39.31 030030 | 53 0.53 39.84 030033 | 35 0.35 40.19 030036 | 56 0.56 40.75 030037 | 43 0.43 41.18 030038 | 56 0.56 41.74 030043 | 27 0.27 42.01 030055 | 47 0.47 42.48 030061 | 65 0.65 43.13 030062 | 34 0.34 43.47 030064 | 64 0.64 44.11 030065 | 65 0.65 44.76 030067 | 26 0.26 45.02 030068 | 22 0.22 45.24 030069 | 55 0.55 45.79 030071 | 21 0.21 46.00 030073 | 19 0.19 46.19 030074 | 2 0.02 46.21 030078 | 8 0.08 46.29 030083 | 33 0.33 46.62 030084 | 18 0.18 46.80 030085 | 63 0.63 47.43 030087 | 65 0.65 48.08 030088 | 51 0.51 48.59 030089 | 63 0.63 49.22 030092 | 53 0.53 49.75 030093 | 51 0.51 50.26 030094 | 60 0.60 50.86 030100 | 25 0.25 51.11 030101 | 54 0.54 51.65 030103 | 64 0.64 52.29 030105 | 31 0.31 52.60 030107 | 10 0.10 52.70 030108 | 11 0.11 52.81 030110 | 45 0.45 53.26 030111 | 31 0.31 53.57 030112 | 8 0.08 53.65 030113 | 6 0.06 53.71 030114 | 44 0.44 54.15 030115 | 56 0.56 54.71 030117 | 35 0.35 55.06 030118 | 28 0.28 55.34 030119 | 51 0.51 55.85 030120 | 15 0.15 56.00 030121 | 59 0.59 56.59 030122 | 39 0.39 56.98 030123 | 42 0.42 57.40 030126 | 32 0.32 57.72 030130 | 17 0.17 57.89 030131 | 5 0.05 57.94 040001 | 22 0.22 58.16 040002 | 25 0.25 58.41 040004 | 61 0.61 59.02 040007 | 67 0.67 59.69 040010 | 60 0.60 60.29 040011 | 17 0.17 60.46 040014 | 47 0.47 60.93 040015 | 17 0.17 61.10 040016 | 60 0.60 61.70 040017 | 32 0.32 62.02 040018 | 24 0.24 62.26 040019 | 18 0.18 62.44 040020 | 68 0.68 63.12 040022 | 62 0.62 63.74 040026 | 65 0.65 64.39 040027 | 58 0.58 64.97 040029 | 52 0.52 65.49 040036 | 63 0.63 66.12 040039 | 35 0.35 66.47 040041 | 38 0.38 66.85 040042 | 29 0.29 67.14 040047 | 15 0.15 67.29 040050 | 20 0.20 67.49 040051 | 22 0.22 67.71 040055 | 63 0.63 68.34 040062 | 63 0.63 68.97 040067 | 18 0.18 69.15 040069 | 18 0.18 69.33 040071 | 57 0.57 69.90 040072 | 15 0.15 70.05 040074 | 23 0.23 70.28 040076 | 19 0.19 70.47 040078 | 55 0.55 71.02 040080 | 14 0.14 71.16 040084 | 34 0.34 71.50 040085 | 15 0.15 71.65 040088 | 41 0.41 72.06 040091 | 15 0.15 72.21 040114 | 68 0.68 72.89 040118 | 57 0.57 73.46 040119 | 47 0.47 73.93 040134 | 41 0.41 74.34 040137 | 32 0.32 74.66 040147 | 14 0.14 74.80 040152 | 18 0.18 74.98 050002 | 41 0.41 75.39 050006 | 58 0.58 75.97 050007 | 59 0.59 76.56 050008 | 29 0.29 76.85 050009 | 61 0.61 77.46 050013 | 47 0.47 77.93 050014 | 25 0.25 78.18 050016 | 34 0.34 78.52 050017 | 62 0.62 79.14 050018 | 26 0.26 79.40 050022 | 62 0.62 80.02 050024 | 36 0.36 80.38 050025 | 66 0.66 81.04 050026 | 64 0.64 81.68 050028 | 23 0.23 81.91 050030 | 40 0.40 82.31 050036 | 58 0.58 82.89 050038 | 46 0.46 83.35 050039 | 63 0.63 83.98 050040 | 23 0.23 84.21 050042 | 27 0.27 84.48 050043 | 56 0.56 85.04 050045 | 33 0.33 85.37 050046 | 18 0.18 85.55 050047 | 66 0.66 86.21 050054 | 20 0.20 86.41 050055 | 31 0.31 86.72 050056 | 60 0.60 87.32 050057 | 65 0.65 87.97 050058 | 61 0.61 88.58 050060 | 62 0.62 89.20 050063 | 47 0.47 89.67 050067 | 19 0.19 89.86 050069 | 59 0.59 90.45 050070 | 23 0.23 90.68 050071 | 36 0.36 91.04 050072 | 29 0.29 91.33 050073 | 31 0.31 91.64 050075 | 37 0.37 92.01 050076 | 30 0.30 92.31 050077 | 65 0.65 92.96 050078 | 37 0.37 93.33 050079 | 48 0.48 93.81 050082 | 58 0.58 94.39 050084 | 61 0.61 95.00 050089 | 26 0.26 95.26 050090 | 33 0.33 95.59 050091 | 24 0.24 95.83 050093 | 63 0.63 96.46 050096 | 3 0.03 96.49 050099 | 59 0.59 97.08 050100 | 66 0.66 97.74 050101 | 40 0.40 98.14 050102 | 39 0.39 98.53 050103 | 52 0.52 99.05 050104 | 54 0.54 99.59 050107 | 41 0.41 100.00 ------------+----------------------------------- Total | 10,000 100.00 Frequencies for first 10,000 rows of hospname variable in dbo_vwhqi_hosp_mpv_msr dataset : Hospital Name | Freq. Percent Cum. ----------------------------------------+----------------------------------- ALASKA NATIVE MEDICAL CENTER | 47 0.47 0.47 ALASKA REGIONAL HOSPITAL | 57 0.57 1.04 ALTA BATES SUMMIT MEDICAL CENTER | 56 0.56 1.60 ANDALUSIA REGIONAL HOSPITAL | 27 0.27 1.87 ANTELOPE VALLEY HOSPITAL MED CENTER | 60 0.60 2.47 ARIZONA ORTHOPEDIC SURGICAL HOSPITAL | 8 0.08 2.55 ARIZONA REGIONAL MEDICAL CENTER | 32 0.32 2.87 ARIZONA SPINE AND JOINT HOSPITAL | 10 0.10 2.97 ARKANSAS HEART HOSPITAL | 41 0.41 3.38 ARKANSAS METHODIST MEDICAL CENTER | 35 0.35 3.73 ARKANSAS SURGICAL HOSPITAL | 14 0.14 3.87 ARROWHEAD HOSPITAL | 60 0.60 4.47 ARROYO GRANDE COMMUNITY HOSPITAL | 34 0.34 4.81 ATHENS-LIMESTONE HOSPITAL | 31 0.31 5.12 ATMORE COMMUNITY HOSPITAL | 19 0.19 5.31 BAKERSFIELD MEMORIAL HOSPITAL | 58 0.58 5.89 BANNER BAYWOOD MEDICAL CENTER | 51 0.51 6.40 BANNER BOSWELL MEDICAL CENTER | 65 0.65 7.05 BANNER DEL E WEBB MEDICAL CENTER | 51 0.51 7.56 BANNER DESERT MEDICAL CENTER | 65 0.65 8.21 BANNER ESTRELLA MEDICAL CENTER | 56 0.56 8.77 BANNER GATEWAY MEDICAL CENTER | 39 0.39 9.16 BANNER GOOD SAMARITAN MEDICAL CENTER | 68 0.68 9.84 BANNER HEART HOSPITAL | 31 0.31 10.15 BANNER IRONWOOD MEDICAL CENTER | 17 0.17 10.32 BANNER THUNDERBIRD MEDICAL CENTER | 63 0.63 10.95 BAPTIST HEALTH MEDICAL CENTER NORTH L.. | 63 0.63 11.58 BAPTIST HEALTH MEDICAL CENTER-LITTLE .. | 68 0.68 12.26 BAPTIST HEALTH MEDICAL CENTER-STUTTGART | 15 0.15 12.41 BAPTIST MEDICAL CENTER EAST | 41 0.41 12.82 BAPTIST MEDICAL CENTER SOUTH | 62 0.62 13.44 BAPTIST MEDICAL CENTER-PRINCETON | 64 0.64 14.08 BARTLETT REGIONAL HOSPITAL | 22 0.22 14.30 BAXTER REGIONAL MEDICAL CENTER | 58 0.58 14.88 BIBB MEDICAL CENTER | 7 0.07 14.95 BROOKWOOD MEDICAL CENTER | 64 0.64 15.59 BRYAN W WHITFIELD MEM HOSP INC | 21 0.21 15.80 BULLOCK COUNTY HOSPITAL | 8 0.08 15.88 CALIFORNIA PACIFIC MEDICAL CTR - ST. .. | 31 0.31 16.19 CALIFORNIA PACIFIC MEDICAL CTR-DAVIES.. | 29 0.29 16.48 CALIFORNIA PACIFIC MEDICAL CTR-PACIFI.. | 66 0.66 17.14 CARONDELET HEART AND VASCULAR INSTITUTE | 25 0.25 17.39 CARONDELET ST MARYS HOSPITAL | 53 0.53 17.92 CARONDELET ST JOSEPH'S HOSPITAL | 56 0.56 18.48 CASA GRANDE REGIONAL MEDICAL CENTER | 43 0.43 18.91 CENTRAL PENINSULA GENERAL HOSPITAL | 32 0.32 19.23 CHAMBERS MEMORIAL HOSPITAL | 17 0.17 19.40 CHANDLER REGIONAL MEDICAL CENTER | 56 0.56 19.96 CHEROKEE MEDICAL CENTER | 15 0.15 20.11 CHILTON MEDICAL CENTER | 10 0.10 20.21 CHINLE COMPREHENSIVE HEALTH CARE FACI.. | 18 0.18 20.39 CITIZENS BAPTIST MEDICAL CENTER | 25 0.25 20.64 CLAY COUNTY HOSPITAL | 12 0.12 20.76 COMMUNITY HOSPITAL INC | 17 0.17 20.93 COMMUNITY HOSPITAL OF HUNTINGTON PARK | 24 0.24 21.17 COMMUNITY HOSPITAL OF SAN BERNARDINO | 26 0.26 21.43 COMMUNITY REGIONAL MEDICAL CENTER | 62 0.62 22.05 CONWAY REGIONAL MEDICAL CENTER | 52 0.52 22.57 COOPER GREEN MERCY HOSPITAL | 17 0.17 22.74 COOSA VALLEY MEDICAL CENTER | 25 0.25 22.99 CRENSHAW COMMUNITY HOSPITAL | 13 0.13 23.12 CRESTWOOD MEDICAL CENTER | 54 0.54 23.66 CRITTENDEN MEMORIAL HOSPITAL | 29 0.29 23.95 CULLMAN REGIONAL MEDICAL CENTER | 51 0.51 24.46 D C H REGIONAL MEDICAL CENTER | 65 0.65 25.11 D W MCMILLAN MEMORIAL HOSPITAL | 23 0.23 25.34 DALE MEDICAL CENTER | 23 0.23 25.57 DECATUR GENERAL HOSPITAL | 44 0.44 26.01 DEKALB REGIONAL MEDICAL CENTER | 37 0.37 26.38 DOCTORS HOSPITAL OF WEST COVINA, INC | 3 0.03 26.41 DOCTORS MEDICAL CENTER-SAN PABLO | 48 0.48 26.89 DREW MEMORIAL HOSPITAL | 22 0.22 27.11 EAST ALABAMA MEDICAL CENTER AND SNF | 66 0.66 27.77 EL CENTRO REGIONAL MEDICAL CENTER | 33 0.33 28.10 ELBA GENERAL HOSPITAL | 9 0.09 28.19 ELIZA COFFEE MEMORIAL HOSPITAL | 63 0.63 28.82 ELMORE COMMUNITY HOSPITAL | 12 0.12 28.94 ENLOE MEDICAL CENTER | 63 0.63 29.57 EVERGREEN MEDICAL CENTER | 14 0.14 29.71 FAIRBANKS MEMORIAL HOSPITAL | 35 0.35 30.06 FAYETTE MEDICAL CENTER | 19 0.19 30.25 FIVE RIVERS MEDICAL CENTER | 15 0.15 30.40 FLAGSTAFF MEDICAL CENTER | 60 0.60 31.00 FLORALA MEMORIAL HOSPITAL | 7 0.07 31.07 FLOWERS HOSPITAL | 63 0.63 31.70 FORREST CITY MEDICAL CENTER | 18 0.18 31.88 FORT DEFIANCE INDIAN HOSPITAL | 21 0.21 32.09 GADSDEN REGIONAL MEDICAL CENTER | 62 0.62 32.71 GEORGE H. LANIER MEMORIAL HOSPITAL | 24 0.24 32.95 GEORGIANA HOSPITAL | 12 0.12 33.07 GILBERT HOSPITAL | 15 0.15 33.22 GLENDALE MEM HOSPITAL & HLTH CENTER | 61 0.61 33.83 GREAT RIVER MEDICAL CENTER | 18 0.18 34.01 GREENE COUNTY HOSPITAL | 8 0.08 34.09 GROSSMONT HOSPITAL | 64 0.64 34.73 GROVE HILL MEMORIAL HOSPITAL | 12 0.12 34.85 HALE COUNTY HOSPITAL | 8 0.08 34.93 HARRIS HOSPITAL | 14 0.14 35.07 HAVASU REGIONAL MEDICAL CENTER | 55 0.55 35.62 HELEN KELLER MEMORIAL HOSPITAL | 46 0.46 36.08 HELENA REGIONAL MEDICAL CENTER | 15 0.15 36.23 HIGHLANDS MEDICAL CENTER | 29 0.29 36.52 HILL HOSPITAL OF SUMTER COUNTY | 6 0.06 36.58 HOLLYWOOD PRESBYTERIAN MEDICAL CENTER | 47 0.47 37.05 HOT SPRING COUNTY MEDICAL CENTER | 19 0.19 37.24 HUNTSVILLE HOSPITAL | 68 0.68 37.92 INFIRMARY WEST | 21 0.21 38.13 J PAUL JONES HOSPITAL | 9 0.09 38.22 JACK HUGHSTON MEMORIAL HOSPITAL | 33 0.33 38.55 JACKSON HOSPITAL & CLINIC INC | 60 0.60 39.15 JACKSON MEDICAL CENTER | 8 0.08 39.23 JACKSONVILLE MEDICAL CENTER | 18 0.18 39.41 JEFFERSON REGIONAL MEDICAL CENTER | 57 0.57 39.98 JOHN C LINCOLN DEER VALLEY HOSPITAL | 53 0.53 40.51 JOHN C LINCOLN NORTH MOUNTAIN HOSPITAL | 64 0.64 41.15 JOHNSON REGIONAL MEDICAL CENTER | 25 0.25 41.40 KAISER FOUNDATION HOSPITAL - SAN FRAN.. | 30 0.30 41.70 KAISER FOUNDATION HOSPITAL - SOUTH SA.. | 23 0.23 41.93 KAISER FOUNDATION HOSPITAL - WALNUT C.. | 29 0.29 42.22 KAISER FOUNDATION HOSPITAL AND REHAB .. | 31 0.31 42.53 KAISER FOUNDATION HOSPITAL OAKLAND/RI.. | 37 0.37 42.90 KAISER FOUNDATION HOSPITAL-SANTA CLARA | 36 0.36 43.26 KAWEAH DELTA MEDICAL CENTER | 65 0.65 43.91 KINGMAN REGIONAL MEDICAL CENTER | 47 0.47 44.38 L V STABLER MEMORIAL HOSPITAL | 20 0.20 44.58 LA PAZ REGIONAL HOSPITAL | 26 0.26 44.84 LAC/OLIVE VIEW-UCLA MEDICAL CENTER | 23 0.23 45.07 LAKE MARTIN COMMUNITY HOSPITAL | 11 0.11 45.18 LAKELAND COMMUNITY HOSPITAL | 19 0.19 45.37 LAWRENCE MEDICAL CENTER | 9 0.09 45.46 MAD RIVER COMMUNITY HOSPITAL | 23 0.23 45.69 MAGNOLIA HOSPITAL | 18 0.18 45.87 MARIAN REGIONAL MEDICAL CENTER, ARROY.. | 41 0.41 46.28 MARICOPA MEDICAL CENTER | 33 0.33 46.61 MARION REGIONAL MEDICAL CENTER | 17 0.17 46.78 MARSHALL MEDICAL CENTER SOUTH | 39 0.39 47.17 MARYVALE HOSPITAL | 22 0.22 47.39 MAT-SU REGIONAL MEDICAL CENTER | 36 0.36 47.75 MAYO CLINIC HOSPITAL | 64 0.64 48.39 MEDICAL CENTER BARBOUR | 16 0.16 48.55 MEDICAL CENTER ENTERPRISE | 27 0.27 48.82 MEDICAL CENTER SOUTH ARKANSAS | 41 0.41 49.23 MEDICAL PARK HOSPITAL | 15 0.15 49.38 MEDICAL WEST, AN AFFILIATE OF UAB HEA.. | 43 0.43 49.81 MENA REGIONAL HEALTH SYSTEM | 17 0.17 49.98 MERCY GENERAL HOSPITAL | 62 0.62 50.60 MERCY GILBERT MEDICAL CENTER | 51 0.51 51.11 MERCY MEDICAL CENTER | 60 0.60 51.71 MIZELL MEMORIAL HOSPITAL | 22 0.22 51.93 MOBILE INFIRMARY | 66 0.66 52.59 MONROE COUNTY HOSPITAL | 18 0.18 52.77 MOUNTAIN VISTA MEDICAL CENTER, LP | 59 0.59 53.36 MT EDGECUMBE HOSPITAL | 14 0.14 53.50 MT GRAHAM REGIONAL MEDICAL CENTER | 22 0.22 53.72 NATIONAL PARK MEDICAL CENTER | 55 0.55 54.27 NEA BAPTIST MEMORIAL HOSPITAL | 57 0.57 54.84 NORTH ARKANSAS REGIONAL MEDICAL CENTER | 32 0.32 55.16 NORTH BALDWIN INFIRMARY | 22 0.22 55.38 NORTH METRO MEDICAL CENTER | 23 0.23 55.61 NORTHEAST ALABAMA REGIONAL MED CENTER | 57 0.57 56.18 NORTHWEST MEDICAL CENTER | 91 0.91 57.09 NW ARKANSAS HOSPITALS, LLC | 62 0.62 57.71 OAK VALLEY DISTRICT HOSPITAL | 19 0.19 57.90 OASIS HOSPITAL | 5 0.05 57.95 OJAI VALLEY COMMUNITY HOSPITAL | 18 0.18 58.13 ORO VALLEY HOSPITAL | 44 0.44 58.57 OROVILLE HOSPITAL | 40 0.40 58.97 OUACHITA COUNTY MEDICAL CENTER | 20 0.20 59.17 PACIFIC ALLIANCE MEDICAL CENTER | 26 0.26 59.43 PARADISE VALLEY HOSPITAL | 69 0.69 60.12 PARKVIEW COMMUNITY HOSPITAL MEDICAL C.. | 39 0.39 60.51 PARKWAY MEDICAL CENTER | 24 0.24 60.75 PAYSON REGIONAL MEDICAL CENTER | 35 0.35 61.10 PENINSULA MEDICAL CENTER | 59 0.59 61.69 PHOENIX BAPTIST HOSPITAL | 53 0.53 62.22 PHOENIX INDIAN MEDICAL CENTER | 8 0.08 62.30 PHYSICIANS' SPECIALTY HOSPITAL | 18 0.18 62.48 PICKENS COUNTY MEDICAL CENTER | 20 0.20 62.68 PRATTVILLE BAPTIST HOSPITAL | 19 0.19 62.87 PROVIDENCE ALASKA MEDICAL CENTER | 62 0.62 63.49 PROVIDENCE HOSPITAL | 66 0.66 64.15 PROVIDENCE LITTLE CO OF MARY MED CTR .. | 37 0.37 64.52 QUEEN OF THE VALLEY MEDICAL CENTER | 61 0.61 65.13 RIVERSIDE COMMUNITY HOSPITAL | 62 0.62 65.75 RIVERVIEW REGIONAL MEDICAL CENTER | 58 0.58 66.33 RUSSELL HOSPITAL | 41 0.41 66.74 RUSSELLVILLE HOSPITAL | 34 0.34 67.08 SAINT AGNES MEDICAL CENTER | 63 0.63 67.71 SAINT FRANCIS MEDICAL CENTER | 54 0.54 68.25 SALINE MEMORIAL HOSPITAL | 34 0.34 68.59 SAN ANTONIO COMMUNITY HOSPITAL | 59 0.59 69.18 SAN GORGONIO MEMORIAL HOSPITAL | 20 0.20 69.38 SANTA CLARA VALLEY MEDICAL CENTER | 46 0.46 69.84 SCOTTSDALE HEALTHCARE-OSBORN MEDICAL .. | 56 0.56 70.40 SCOTTSDALE HEALTHCARE-SHEA MEDICAL CE.. | 65 0.65 71.05 SCOTTSDALE HEALTHCARE-THOMPSON PEAK H.. | 42 0.42 71.47 SCRIPPS MERCY HOSPITAL | 65 0.65 72.12 SELLS INDIAN HEALTH SERVICE HOSPITAL | 2 0.02 72.14 SHARP MEMORIAL HOSPITAL | 66 0.66 72.80 SHELBY BAPTIST MEDICAL CENTER | 60 0.60 73.40 SHOALS HOSPITAL | 26 0.26 73.66 SIERRA VISTA REGIONAL HEALTH CENTER INC | 27 0.27 73.93 SILOAM SPRINGS REGIONAL HOSPITAL | 22 0.22 74.15 SONOMA VALLEY HOSPITAL | 33 0.33 74.48 SOUTH BALDWIN REGIONAL MEDICAL CENTER | 39 0.39 74.87 SOUTHEAST ALABAMA MEDICAL CENTER | 63 0.63 75.50 SPARKS REGIONAL MEDICAL CENTER | 63 0.63 76.13 SPRINGHILL MEDICAL CENTER | 52 0.52 76.65 ST BERNARDS MEDICAL CENTER | 68 0.68 77.33 ST EDWARD MERCY MEDICAL CENTER | 63 0.63 77.96 ST ELIZABETH COMMUNITY HOSPITAL | 27 0.27 78.23 ST HELENA HOSPITAL | 47 0.47 78.70 ST JOHNS REGIONAL MEDICAL CENTER | 58 0.58 79.28 ST JOSEPH HOSPITAL | 117 1.17 80.45 ST JOSEPH'S HOSPITAL AND MEDICAL CENTER | 58 0.58 81.03 ST JOSEPHS MED CENTER OF STOCKTON | 61 0.61 81.64 ST JOSEPHS MERCY HEALTH CENTER INC | 65 0.65 82.29 ST LUKES MEDICAL CENTER | 43 0.43 82.72 ST MARYS REGIONAL MEDICAL CENTER | 38 0.38 83.10 ST ROSE HOSPITAL | 41 0.41 83.51 ST VINCENT INFIRMARY MEDICAL CENTER | 67 0.67 84.18 ST VINCENT MEDICAL CENTER/NORTH | 32 0.32 84.50 ST VINCENT'S BIRMINGHAM | 66 0.66 85.16 ST VINCENT'S EAST | 63 0.63 85.79 ST VINCENT'S ST CLAIR | 14 0.14 85.93 ST VINCENTS BLOUNT | 18 0.18 86.11 STRINGFELLOW MEMORIAL HOSPITAL | 43 0.43 86.54 SUMMIT HEALTHCARE REGIONAL MEDICAL CE.. | 34 0.34 86.88 SUMMIT MEDICAL CENTER | 24 0.24 87.12 SURGICAL SPECIALTY HOSPITAL OF ARIZONA | 11 0.11 87.23 SUTTER AMADOR HOSPITAL | 25 0.25 87.48 SUTTER SOLANO MEDICAL CENTER | 40 0.40 87.88 THOMAS HOSPITAL | 53 0.53 88.41 TRINITY MEDICAL CENTER | 63 0.63 89.04 TROY REGIONAL MEDICAL CENTER | 23 0.23 89.27 TUBA CITY REGIONAL HEALTH CARE CORPOR.. | 19 0.19 89.46 TUCSON MEDICAL CENTER | 67 0.67 90.13 UAMS MEDICAL CENTER | 60 0.60 90.73 UNIV OF SOUTH ALABAMA MEDICAL CENTER | 46 0.46 91.19 UNIVERSITY OF ALABAMA HOSPITAL | 69 0.69 91.88 UNIVERSITY OF ARIZONA MEDICAL CTR- SO.. | 31 0.31 92.19 UNIVERSITY OF ARIZONA MEDICAL CTR-UNI.. | 64 0.64 92.83 UNIVERSITY OF CALIFORNIA SAN DIEGO ME.. | 66 0.66 93.49 VALLEY VIEW MEDICAL CENTER | 35 0.35 93.84 VAUGHAN REG MED CENTER PARKWAY CAMPUS | 38 0.38 94.22 VERDE VALLEY MEDICAL CENTER | 37 0.37 94.59 WALKER BAPTIST MEDICAL CENTER | 42 0.42 95.01 WASHINGTON REGIONAL MED CTR AT NORTH .. | 61 0.61 95.62 WEDOWEE HOSPITAL | 13 0.13 95.75 WEST VALLEY HOSPITAL | 45 0.45 96.20 WESTERN ARIZONA REGIONAL MEDICAL CTR | 54 0.54 96.74 WHITE COUNTY MEDICAL CENTER | 47 0.47 97.21 WHITE MEMORIAL MEDICAL CENTER | 52 0.52 97.73 WHITE RIVER MEDICAL CENTER | 47 0.47 98.20 WHITERIVER PHS INDIAN HOSPITAL | 6 0.06 98.26 WIREGRASS MEDICAL CENTER | 18 0.18 98.44 YAVAPAI REGIONAL MEDICAL CENTER | 62 0.62 99.06 YAVAPAI REGIONAL MEDICAL CENTER-EAST | 28 0.28 99.34 YUKON KUSKOKWIM DELTA REG HOSPITAL | 7 0.07 99.41 YUMA REGIONAL MEDICAL CENTER | 59 0.59 100.00 ----------------------------------------+----------------------------------- Total | 10,000 100.00 Frequencies for first 10,000 rows of state variable in dbo_vwhqi_hosp_mpv_msr dataset : State | Freq. Percent Cum. ------------+----------------------------------- AK | 312 3.12 3.12 AL | 2,937 29.37 32.49 AR | 1,704 17.04 49.53 AZ | 2,545 25.45 74.98 CA | 2,502 25.02 100.00 ------------+----------------------------------- Total | 10,000 100.00 Frequencies for first 10,000 rows of drg variable in dbo_vwhqi_hosp_mpv_msr dataset : Diagnosis | Related | Group ID | Freq. Percent Cum. ------------+----------------------------------- 38 | 123 1.23 1.23 39 | 141 1.41 2.64 190 | 253 2.53 5.17 191 | 254 2.54 7.71 192 | 253 2.53 10.24 193 | 247 2.47 12.71 219 | 94 0.94 13.65 220 | 96 0.96 14.61 221 | 67 0.67 15.28 224 | 89 0.89 16.17 225 | 85 0.85 17.02 226 | 104 1.04 18.06 227 | 118 1.18 19.24 235 | 93 0.93 20.17 236 | 99 0.99 21.16 237 | 133 1.33 22.49 243 | 156 1.56 24.05 244 | 157 1.57 25.62 247 | 134 1.34 26.96 280 | 240 2.40 29.36 281 | 230 2.30 31.66 282 | 229 2.29 33.95 291 | 253 2.53 36.48 292 | 255 2.55 39.03 293 | 254 2.54 41.57 313 | 242 2.42 43.99 328 | 143 1.43 45.42 329 | 215 2.15 47.57 330 | 217 2.17 49.74 331 | 190 1.90 51.64 353 | 114 1.14 52.78 354 | 169 1.69 54.47 355 | 172 1.72 56.19 414 | 118 1.18 57.37 417 | 188 1.88 59.25 418 | 214 2.14 61.39 419 | 219 2.19 63.58 459 | 75 0.75 64.33 460 | 117 1.17 65.50 461 | 10 0.10 65.60 462 | 71 0.71 66.31 466 | 104 1.04 67.35 467 | 152 1.52 68.87 468 | 139 1.39 70.26 469 | 182 1.82 72.08 470 | 203 2.03 74.11 471 | 75 0.75 74.86 472 | 91 0.91 75.77 473 | 114 1.14 76.91 477 | 75 0.75 77.66 478 | 99 0.99 78.65 479 | 64 0.64 79.29 490 | 109 1.09 80.38 491 | 115 1.15 81.53 507 | 31 0.31 81.84 508 | 36 0.36 82.20 515 | 88 0.88 83.08 637 | 228 2.28 85.36 656 | 101 1.01 86.37 657 | 109 1.09 87.46 658 | 104 1.04 88.50 659 | 91 0.91 89.41 668 | 102 1.02 90.43 673 | 138 1.38 91.81 674 | 135 1.35 93.16 675 | 68 0.68 93.84 713 | 129 1.29 95.13 714 | 145 1.45 96.58 743 | 185 1.85 98.43 748 | 157 1.57 100.00 ------------+----------------------------------- Total | 10,000 100.00 Frequencies for first 10,000 rows of drgname variable in dbo_vwhqi_hosp_mpv_msr dataset : Diagnosis Related Group Name | Freq. Percent Cum. ----------------------------------------+----------------------------------- Acute myocardial infarction, discharg.. | 230 2.30 2.30 Acute myocardial infarction, discharg.. | 240 2.40 4.70 Acute myocardial infarction, discharg.. | 229 2.29 6.99 Back and neck proc exc spinal fusion .. | 109 1.09 8.08 Back and neck proc exc spinal fusion .. | 115 1.15 9.23 Bilateral or multiple major joint pro.. | 10 0.10 9.33 Bilateral or multiple major joint pro.. | 71 0.71 10.04 Biopsies of musculoskeletal system an.. | 99 0.99 11.03 Biopsies of musculoskeletal system an.. | 75 0.75 11.78 Biopsies of musculoskeletal system an.. | 64 0.64 12.42 Cardiac defib implant w cardiac cath .. | 89 0.89 13.31 Cardiac defib implant w cardiac cath .. | 85 0.85 14.16 Cardiac defibrillator implant w/o car.. | 104 1.04 15.20 Cardiac defibrillator implant w/o car.. | 118 1.18 16.38 Cardiac valve and oth maj cardiothora.. | 96 0.96 17.34 Cardiac valve and oth maj cardiothora.. | 94 0.94 18.28 Cardiac valve and oth maj cardiothora.. | 67 0.67 18.95 Cervical spinal fusion w CC | 91 0.91 19.86 Cervical spinal fusion w MCC | 75 0.75 20.61 Cervical spinal fusion w/o CC/MCC | 114 1.14 21.75 Chest Pain | 242 2.42 24.17 Cholecystectomy except by laparoscope.. | 118 1.18 25.35 Chronic obstructive pulmonary disease.. | 254 2.54 27.89 Chronic obstructive pulmonary disease.. | 253 2.53 30.42 Chronic obstructive pulmonary disease.. | 253 2.53 32.95 Coronary bypass w/o cardiac cath w MCC | 93 0.93 33.88 Coronary bypass w/o cardiac cath w/o .. | 99 0.99 34.87 Diabetes w MCC | 228 2.28 37.15 Extracranial procedures w CC | 123 1.23 38.38 Extracranial procedures w/o CC/MCC | 141 1.41 39.79 Female reproductive system reconstruc.. | 157 1.57 41.36 Heart failure and shock w CC | 255 2.55 43.91 Heart failure and shock w MCC | 253 2.53 46.44 Heart failure and shock w/o CC/MCC | 254 2.54 48.98 Hernia procedures except inguinal and.. | 169 1.69 50.67 Hernia procedures except inguinal and.. | 114 1.14 51.81 Hernia procedures except inguinal and.. | 172 1.72 53.53 Kidney and ureter procedures for neop.. | 109 1.09 54.62 Kidney and ureter procedures for neop.. | 101 1.01 55.63 Kidney and ureter procedures for neop.. | 104 1.04 56.67 Kidney and ureter procedures for non-.. | 91 0.91 57.58 Laparoscopic cholecystectomy w/o c.d... | 214 2.14 59.72 Laparoscopic cholecystectomy w/o c.d... | 188 1.88 61.60 Laparoscopic cholecystectomy w/o c.d... | 219 2.19 63.79 Major cardiovasc procedures w MCC or .. | 133 1.33 65.12 Major joint replacement or reattachme.. | 182 1.82 66.94 Major joint replacement or reattachme.. | 203 2.03 68.97 Major shoulder or elbow joint procedu.. | 31 0.31 69.28 Major shoulder or elbow joint procedu.. | 36 0.36 69.64 Major small and large bowel procedure.. | 217 2.17 71.81 Major small and large bowel procedure.. | 215 2.15 73.96 Major small and large bowel procedure.. | 190 1.90 75.86 Other kidney and urinary tract proced.. | 135 1.35 77.21 Other kidney and urinary tract proced.. | 138 1.38 78.59 Other kidney and urinary tract proced.. | 68 0.68 79.27 Other musculoskelet sys and conn tiss.. | 88 0.88 80.15 Perc cardiovasc proc w drug-eluting s.. | 134 1.34 81.49 Permanent cardiac pacemaker implant w.. | 156 1.56 83.05 Permanent cardiac pacemaker implant w.. | 157 1.57 84.62 Revision of hip or knee replacement w.. | 152 1.52 86.14 Revision of hip or knee replacement w.. | 104 1.04 87.18 Revision of hip or knee replacement w.. | 139 1.39 88.57 Simple pneumonia and pleurisy w MCC | 247 2.47 91.04 Spinal fusion except cervical w MCC | 75 0.75 91.79 Spinal fusion except cervical w/o MCC | 117 1.17 92.96 Stomach, esophageal duodenal proc w/o.. | 143 1.43 94.39 Transurethral procedures w MCC | 102 1.02 95.41 Transurethral prostatectomy w CC/MCC | 129 1.29 96.70 Transurethral prostatectomy w/o CC/MCC | 145 1.45 98.15 Uterine and adnexa proc for non-malig.. | 185 1.85 100.00 ----------------------------------------+----------------------------------- Total | 10,000 100.00 Frequencies for first 10,000 rows of cases variable in dbo_vwhqi_hosp_mpv_msr dataset : Number Of | Cases | Freq. Percent Cum. ------------+----------------------------------- * | 6,063 60.63 60.63 100 | 5 0.05 60.68 101 | 6 0.06 60.74 102 | 3 0.03 60.77 103 | 8 0.08 60.85 104 | 8 0.08 60.93 105 | 5 0.05 60.98 106 | 9 0.09 61.07 107 | 3 0.03 61.10 108 | 4 0.04 61.14 109 | 5 0.05 61.19 11 | 222 2.22 63.41 110 | 5 0.05 63.46 111 | 3 0.03 63.49 112 | 4 0.04 63.53 113 | 3 0.03 63.56 114 | 7 0.07 63.63 115 | 6 0.06 63.69 116 | 3 0.03 63.72 117 | 2 0.02 63.74 118 | 3 0.03 63.77 119 | 1 0.01 63.78 12 | 207 2.07 65.85 120 | 1 0.01 65.86 121 | 5 0.05 65.91 122 | 2 0.02 65.93 123 | 2 0.02 65.95 124 | 2 0.02 65.97 125 | 5 0.05 66.02 126 | 1 0.01 66.03 127 | 2 0.02 66.05 129 | 3 0.03 66.08 13 | 201 2.01 68.09 130 | 7 0.07 68.16 131 | 5 0.05 68.21 132 | 3 0.03 68.24 133 | 2 0.02 68.26 134 | 3 0.03 68.29 135 | 2 0.02 68.31 136 | 3 0.03 68.34 137 | 1 0.01 68.35 138 | 2 0.02 68.37 139 | 3 0.03 68.40 14 | 159 1.59 69.99 142 | 1 0.01 70.00 143 | 2 0.02 70.02 146 | 5 0.05 70.07 147 | 6 0.06 70.13 148 | 3 0.03 70.16 15 | 158 1.58 71.74 150 | 3 0.03 71.77 151 | 1 0.01 71.78 153 | 2 0.02 71.80 154 | 1 0.01 71.81 156 | 1 0.01 71.82 157 | 2 0.02 71.84 158 | 2 0.02 71.86 159 | 1 0.01 71.87 16 | 146 1.46 73.33 162 | 1 0.01 73.34 163 | 1 0.01 73.35 164 | 2 0.02 73.37 165 | 1 0.01 73.38 166 | 2 0.02 73.40 167 | 1 0.01 73.41 168 | 2 0.02 73.43 169 | 1 0.01 73.44 17 | 135 1.35 74.79 171 | 1 0.01 74.80 172 | 2 0.02 74.82 178 | 3 0.03 74.85 18 | 154 1.54 76.39 182 | 1 0.01 76.40 183 | 2 0.02 76.42 184 | 1 0.01 76.43 185 | 1 0.01 76.44 189 | 2 0.02 76.46 19 | 112 1.12 77.58 191 | 1 0.01 77.59 192 | 2 0.02 77.61 193 | 1 0.01 77.62 194 | 1 0.01 77.63 196 | 1 0.01 77.64 197 | 2 0.02 77.66 198 | 1 0.01 77.67 199 | 1 0.01 77.68 20 | 114 1.14 78.82 201 | 3 0.03 78.85 204 | 1 0.01 78.86 205 | 1 0.01 78.87 208 | 2 0.02 78.89 21 | 111 1.11 80.00 211 | 2 0.02 80.02 213 | 1 0.01 80.03 214 | 2 0.02 80.05 215 | 2 0.02 80.07 217 | 2 0.02 80.09 219 | 1 0.01 80.10 22 | 108 1.08 81.18 220 | 1 0.01 81.19 226 | 1 0.01 81.20 228 | 1 0.01 81.21 229 | 1 0.01 81.22 23 | 94 0.94 82.16 230 | 2 0.02 82.18 234 | 1 0.01 82.19 236 | 1 0.01 82.20 238 | 1 0.01 82.21 239 | 1 0.01 82.22 24 | 84 0.84 83.06 242 | 1 0.01 83.07 243 | 1 0.01 83.08 244 | 2 0.02 83.10 246 | 1 0.01 83.11 25 | 81 0.81 83.92 255 | 1 0.01 83.93 26 | 86 0.86 84.79 262 | 2 0.02 84.81 263 | 1 0.01 84.82 266 | 1 0.01 84.83 267 | 1 0.01 84.84 27 | 75 0.75 85.59 275 | 1 0.01 85.60 278 | 1 0.01 85.61 28 | 61 0.61 86.22 280 | 1 0.01 86.23 285 | 1 0.01 86.24 287 | 1 0.01 86.25 289 | 1 0.01 86.26 29 | 55 0.55 86.81 292 | 1 0.01 86.82 296 | 1 0.01 86.83 299 | 2 0.02 86.85 30 | 53 0.53 87.38 302 | 1 0.01 87.39 304 | 2 0.02 87.41 31 | 54 0.54 87.95 311 | 1 0.01 87.96 314 | 1 0.01 87.97 32 | 43 0.43 88.40 328 | 1 0.01 88.41 33 | 47 0.47 88.88 330 | 1 0.01 88.89 339 | 2 0.02 88.91 34 | 46 0.46 89.37 347 | 1 0.01 89.38 35 | 45 0.45 89.83 36 | 36 0.36 90.19 37 | 31 0.31 90.50 38 | 42 0.42 90.92 380 | 1 0.01 90.93 39 | 29 0.29 91.22 40 | 31 0.31 91.53 408 | 1 0.01 91.54 41 | 32 0.32 91.86 415 | 1 0.01 91.87 42 | 29 0.29 92.16 425 | 1 0.01 92.17 43 | 26 0.26 92.43 44 | 23 0.23 92.66 45 | 27 0.27 92.93 46 | 23 0.23 93.16 468 | 1 0.01 93.17 469 | 1 0.01 93.18 47 | 24 0.24 93.42 470 | 1 0.01 93.43 48 | 21 0.21 93.64 49 | 33 0.33 93.97 494 | 1 0.01 93.98 50 | 31 0.31 94.29 51 | 22 0.22 94.51 52 | 25 0.25 94.76 53 | 19 0.19 94.95 54 | 16 0.16 95.11 55 | 17 0.17 95.28 56 | 15 0.15 95.43 560 | 1 0.01 95.44 57 | 22 0.22 95.66 58 | 15 0.15 95.81 59 | 14 0.14 95.95 60 | 16 0.16 96.11 608 | 1 0.01 96.12 61 | 11 0.11 96.23 62 | 15 0.15 96.38 63 | 18 0.18 96.56 632 | 1 0.01 96.57 64 | 12 0.12 96.69 643 | 1 0.01 96.70 65 | 9 0.09 96.79 66 | 17 0.17 96.96 67 | 14 0.14 97.10 68 | 16 0.16 97.26 69 | 20 0.20 97.46 70 | 10 0.10 97.56 71 | 14 0.14 97.70 710 | 1 0.01 97.71 72 | 14 0.14 97.85 73 | 15 0.15 98.00 732 | 1 0.01 98.01 74 | 8 0.08 98.09 75 | 15 0.15 98.24 76 | 6 0.06 98.30 767 | 1 0.01 98.31 77 | 3 0.03 98.34 78 | 9 0.09 98.43 79 | 5 0.05 98.48 80 | 8 0.08 98.56 81 | 11 0.11 98.67 818 | 1 0.01 98.68 82 | 9 0.09 98.77 83 | 8 0.08 98.85 84 | 9 0.09 98.94 85 | 11 0.11 99.05 86 | 5 0.05 99.10 87 | 4 0.04 99.14 88 | 4 0.04 99.18 89 | 6 0.06 99.24 90 | 4 0.04 99.28 91 | 10 0.10 99.38 92 | 11 0.11 99.49 93 | 7 0.07 99.56 94 | 7 0.07 99.63 95 | 8 0.08 99.71 96 | 7 0.07 99.78 97 | 8 0.08 99.86 98 | 9 0.09 99.95 99 | 5 0.05 100.00 ------------+----------------------------------- Total | 10,000 100.00 by Jean Roth , jroth@nber.org , 16 Nov 2016