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 010138 | 6 0.06 25.53 010139 | 64 0.64 26.17 010144 | 52 0.52 26.69 010146 | 18 0.18 26.87 010148 | 14 0.14 27.01 010149 | 41 0.41 27.42 010150 | 20 0.20 27.62 010157 | 26 0.26 27.88 010158 | 34 0.34 28.22 010164 | 25 0.25 28.47 010168 | 33 0.33 28.80 010169 | 19 0.19 28.99 020001 | 62 0.62 29.61 020006 | 36 0.36 29.97 020008 | 22 0.22 30.19 020012 | 35 0.35 30.54 020017 | 57 0.57 31.11 020018 | 7 0.07 31.18 020024 | 32 0.32 31.50 020026 | 47 0.47 31.97 020027 | 14 0.14 32.11 030001 | 22 0.22 32.33 030002 | 68 0.68 33.01 030006 | 67 0.67 33.68 030007 | 37 0.37 34.05 030010 | 53 0.53 34.58 030011 | 56 0.56 35.14 030012 | 62 0.62 35.76 030013 | 59 0.59 36.35 030014 | 64 0.64 36.99 030016 | 43 0.43 37.42 030022 | 33 0.33 37.75 030023 | 60 0.60 38.35 030024 | 58 0.58 38.93 030030 | 53 0.53 39.46 030033 | 35 0.35 39.81 030036 | 56 0.56 40.37 030037 | 43 0.43 40.80 030038 | 56 0.56 41.36 030043 | 27 0.27 41.63 030055 | 47 0.47 42.10 030061 | 65 0.65 42.75 030062 | 34 0.34 43.09 030064 | 64 0.64 43.73 030065 | 65 0.65 44.38 030067 | 26 0.26 44.64 030068 | 22 0.22 44.86 030069 | 55 0.55 45.41 030071 | 21 0.21 45.62 030073 | 19 0.19 45.81 030074 | 2 0.02 45.83 030078 | 8 0.08 45.91 030083 | 33 0.33 46.24 030084 | 18 0.18 46.42 030085 | 63 0.63 47.05 030087 | 65 0.65 47.70 030088 | 51 0.51 48.21 030089 | 63 0.63 48.84 030092 | 53 0.53 49.37 030093 | 51 0.51 49.88 030094 | 60 0.60 50.48 030100 | 25 0.25 50.73 030101 | 54 0.54 51.27 030103 | 64 0.64 51.91 030105 | 31 0.31 52.22 030107 | 10 0.10 52.32 030108 | 11 0.11 52.43 030110 | 45 0.45 52.88 030111 | 31 0.31 53.19 030112 | 8 0.08 53.27 030113 | 6 0.06 53.33 030114 | 44 0.44 53.77 030115 | 56 0.56 54.33 030117 | 35 0.35 54.68 030118 | 28 0.28 54.96 030119 | 51 0.51 55.47 030120 | 15 0.15 55.62 030121 | 59 0.59 56.21 030122 | 39 0.39 56.60 030123 | 42 0.42 57.02 030126 | 32 0.32 57.34 030130 | 17 0.17 57.51 030131 | 5 0.05 57.56 040001 | 22 0.22 57.78 040002 | 25 0.25 58.03 040004 | 61 0.61 58.64 040007 | 67 0.67 59.31 040010 | 60 0.60 59.91 040011 | 17 0.17 60.08 040014 | 47 0.47 60.55 040015 | 17 0.17 60.72 040016 | 60 0.60 61.32 040017 | 32 0.32 61.64 040018 | 24 0.24 61.88 040019 | 18 0.18 62.06 040020 | 68 0.68 62.74 040022 | 62 0.62 63.36 040026 | 65 0.65 64.01 040027 | 58 0.58 64.59 040029 | 52 0.52 65.11 040036 | 63 0.63 65.74 040039 | 35 0.35 66.09 040041 | 38 0.38 66.47 040042 | 29 0.29 66.76 040047 | 15 0.15 66.91 040050 | 20 0.20 67.11 040051 | 22 0.22 67.33 040055 | 63 0.63 67.96 040062 | 63 0.63 68.59 040067 | 18 0.18 68.77 040069 | 18 0.18 68.95 040071 | 57 0.57 69.52 040072 | 15 0.15 69.67 040074 | 23 0.23 69.90 040076 | 19 0.19 70.09 040078 | 55 0.55 70.64 040080 | 14 0.14 70.78 040084 | 34 0.34 71.12 040085 | 15 0.15 71.27 040088 | 41 0.41 71.68 040091 | 15 0.15 71.83 040114 | 68 0.68 72.51 040118 | 57 0.57 73.08 040119 | 47 0.47 73.55 040134 | 41 0.41 73.96 040137 | 32 0.32 74.28 040147 | 14 0.14 74.42 040152 | 18 0.18 74.60 050002 | 41 0.41 75.01 050006 | 58 0.58 75.59 050007 | 59 0.59 76.18 050008 | 29 0.29 76.47 050009 | 61 0.61 77.08 050013 | 47 0.47 77.55 050014 | 25 0.25 77.80 050016 | 34 0.34 78.14 050017 | 62 0.62 78.76 050018 | 26 0.26 79.02 050022 | 62 0.62 79.64 050024 | 36 0.36 80.00 050025 | 66 0.66 80.66 050026 | 64 0.64 81.30 050028 | 23 0.23 81.53 050030 | 40 0.40 81.93 050036 | 58 0.58 82.51 050038 | 46 0.46 82.97 050039 | 63 0.63 83.60 050040 | 23 0.23 83.83 050042 | 27 0.27 84.10 050043 | 56 0.56 84.66 050045 | 33 0.33 84.99 050046 | 18 0.18 85.17 050047 | 66 0.66 85.83 050054 | 20 0.20 86.03 050055 | 31 0.31 86.34 050056 | 60 0.60 86.94 050057 | 65 0.65 87.59 050058 | 61 0.61 88.20 050060 | 62 0.62 88.82 050063 | 47 0.47 89.29 050067 | 19 0.19 89.48 050069 | 59 0.59 90.07 050070 | 23 0.23 90.30 050071 | 36 0.36 90.66 050072 | 29 0.29 90.95 050073 | 31 0.31 91.26 050075 | 37 0.37 91.63 050076 | 30 0.30 91.93 050077 | 65 0.65 92.58 050078 | 37 0.37 92.95 050079 | 48 0.48 93.43 050082 | 58 0.58 94.01 050084 | 61 0.61 94.62 050089 | 26 0.26 94.88 050090 | 33 0.33 95.21 050091 | 24 0.24 95.45 050093 | 63 0.63 96.08 050096 | 3 0.03 96.11 050099 | 59 0.59 96.70 050100 | 66 0.66 97.36 050101 | 40 0.40 97.76 050102 | 39 0.39 98.15 050103 | 52 0.52 98.67 050104 | 54 0.54 99.21 050107 | 55 0.55 99.76 050108 | 24 0.24 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 ATHENS-LIMESTONE HOSPITAL | 31 0.31 4.78 ATMORE COMMUNITY HOSPITAL | 19 0.19 4.97 BAKERSFIELD MEMORIAL HOSPITAL | 58 0.58 5.55 BANNER BAYWOOD MEDICAL CENTER | 51 0.51 6.06 BANNER BOSWELL MEDICAL CENTER | 65 0.65 6.71 BANNER DEL E WEBB MEDICAL CENTER | 51 0.51 7.22 BANNER DESERT MEDICAL CENTER | 65 0.65 7.87 BANNER ESTRELLA MEDICAL CENTER | 56 0.56 8.43 BANNER GATEWAY MEDICAL CENTER | 39 0.39 8.82 BANNER GOOD SAMARITAN MEDICAL CENTER | 68 0.68 9.50 BANNER HEART HOSPITAL | 31 0.31 9.81 BANNER IRONWOOD MEDICAL CENTER | 17 0.17 9.98 BANNER THUNDERBIRD MEDICAL CENTER | 63 0.63 10.61 BAPTIST HEALTH MEDICAL CENTER NORTH L.. | 63 0.63 11.24 BAPTIST HEALTH MEDICAL CENTER-LITTLE .. | 68 0.68 11.92 BAPTIST HEALTH MEDICAL CENTER-STUTTGART | 15 0.15 12.07 BAPTIST MEDICAL CENTER EAST | 41 0.41 12.48 BAPTIST MEDICAL CENTER SOUTH | 62 0.62 13.10 BAPTIST MEDICAL CENTER-PRINCETON | 64 0.64 13.74 BARTLETT REGIONAL HOSPITAL | 22 0.22 13.96 BAXTER REGIONAL MEDICAL CENTER | 58 0.58 14.54 BIBB MEDICAL CENTER | 7 0.07 14.61 BROOKWOOD MEDICAL CENTER | 64 0.64 15.25 BRYAN W WHITFIELD MEM HOSP INC | 21 0.21 15.46 BULLOCK COUNTY HOSPITAL | 8 0.08 15.54 CALIFORNIA PACIFIC MEDICAL CTR - ST. .. | 31 0.31 15.85 CALIFORNIA PACIFIC MEDICAL CTR-DAVIES.. | 29 0.29 16.14 CALIFORNIA PACIFIC MEDICAL CTR-PACIFI.. | 66 0.66 16.80 CARONDELET HEART AND VASCULAR INSTITUTE | 25 0.25 17.05 CARONDELET ST MARYS HOSPITAL | 53 0.53 17.58 CARONDELET ST JOSEPH'S HOSPITAL | 56 0.56 18.14 CASA GRANDE REGIONAL MEDICAL CENTER | 43 0.43 18.57 CENTRAL PENINSULA GENERAL HOSPITAL | 32 0.32 18.89 CHAMBERS MEMORIAL HOSPITAL | 17 0.17 19.06 CHANDLER REGIONAL MEDICAL CENTER | 56 0.56 19.62 CHEROKEE MEDICAL CENTER | 15 0.15 19.77 CHILTON MEDICAL CENTER | 10 0.10 19.87 CHINLE COMPREHENSIVE HEALTH CARE FACI.. | 18 0.18 20.05 CITIZENS BAPTIST MEDICAL CENTER | 25 0.25 20.30 CLAY COUNTY HOSPITAL | 12 0.12 20.42 COMMUNITY HOSPITAL INC | 17 0.17 20.59 COMMUNITY HOSPITAL OF HUNTINGTON PARK | 24 0.24 20.83 COMMUNITY HOSPITAL OF SAN BERNARDINO | 26 0.26 21.09 COMMUNITY REGIONAL MEDICAL CENTER | 62 0.62 21.71 CONWAY REGIONAL MEDICAL CENTER | 52 0.52 22.23 COOSA VALLEY MEDICAL CENTER | 25 0.25 22.48 CRENSHAW COMMUNITY HOSPITAL | 13 0.13 22.61 CRESTWOOD MEDICAL CENTER | 54 0.54 23.15 CRITTENDEN MEMORIAL HOSPITAL | 29 0.29 23.44 CULLMAN REGIONAL MEDICAL CENTER | 51 0.51 23.95 D C H REGIONAL MEDICAL CENTER | 65 0.65 24.60 D W MCMILLAN MEMORIAL HOSPITAL | 23 0.23 24.83 DALE MEDICAL CENTER | 23 0.23 25.06 DECATUR GENERAL HOSPITAL | 44 0.44 25.50 DEKALB REGIONAL MEDICAL CENTER | 37 0.37 25.87 DOCTORS HOSPITAL OF WEST COVINA, INC | 3 0.03 25.90 DOCTORS MEDICAL CENTER-SAN PABLO | 48 0.48 26.38 DREW MEMORIAL HOSPITAL | 22 0.22 26.60 EAST ALABAMA MEDICAL CENTER AND SNF | 66 0.66 27.26 EL CENTRO REGIONAL MEDICAL CENTER | 33 0.33 27.59 ELBA GENERAL HOSPITAL | 9 0.09 27.68 ELIZA COFFEE MEMORIAL HOSPITAL | 63 0.63 28.31 ELMORE COMMUNITY HOSPITAL | 12 0.12 28.43 ENLOE MEDICAL CENTER | 63 0.63 29.06 EVERGREEN MEDICAL CENTER | 14 0.14 29.20 FAIRBANKS MEMORIAL HOSPITAL | 35 0.35 29.55 FAYETTE MEDICAL CENTER | 19 0.19 29.74 FIVE RIVERS MEDICAL CENTER | 15 0.15 29.89 FLAGSTAFF MEDICAL CENTER | 60 0.60 30.49 FLORALA MEMORIAL HOSPITAL | 7 0.07 30.56 FLOWERS HOSPITAL | 63 0.63 31.19 FORREST CITY MEDICAL CENTER | 18 0.18 31.37 FORT DEFIANCE INDIAN HOSPITAL | 21 0.21 31.58 GADSDEN REGIONAL MEDICAL CENTER | 62 0.62 32.20 GEORGE H. LANIER MEMORIAL HOSPITAL | 24 0.24 32.44 GEORGIANA HOSPITAL | 12 0.12 32.56 GILBERT HOSPITAL | 15 0.15 32.71 GLENDALE MEM HOSPITAL & HLTH CENTER | 61 0.61 33.32 GREAT RIVER MEDICAL CENTER | 18 0.18 33.50 GREENE COUNTY HOSPITAL | 8 0.08 33.58 GROSSMONT HOSPITAL | 64 0.64 34.22 GROVE HILL MEMORIAL HOSPITAL | 12 0.12 34.34 HALE COUNTY HOSPITAL | 8 0.08 34.42 HARRIS HOSPITAL | 14 0.14 34.56 HAVASU REGIONAL MEDICAL CENTER | 55 0.55 35.11 HELEN KELLER MEMORIAL HOSPITAL | 46 0.46 35.57 HELENA REGIONAL MEDICAL CENTER | 15 0.15 35.72 HIGHLANDS MEDICAL CENTER | 29 0.29 36.01 HILL HOSPITAL OF SUMTER COUNTY | 6 0.06 36.07 HOLLYWOOD PRESBYTERIAN MEDICAL CENTER | 47 0.47 36.54 HOT SPRING COUNTY MEDICAL CENTER | 19 0.19 36.73 HUNTSVILLE HOSPITAL | 68 0.68 37.41 J PAUL JONES HOSPITAL | 9 0.09 37.50 JACK HUGHSTON MEMORIAL HOSPITAL | 33 0.33 37.83 JACKSON HOSPITAL & CLINIC INC | 60 0.60 38.43 JACKSON MEDICAL CENTER | 8 0.08 38.51 JACKSONVILLE MEDICAL CENTER | 18 0.18 38.69 JEFFERSON REGIONAL MEDICAL CENTER | 57 0.57 39.26 JOHN C LINCOLN DEER VALLEY HOSPITAL | 53 0.53 39.79 JOHN C LINCOLN NORTH MOUNTAIN HOSPITAL | 64 0.64 40.43 JOHNSON REGIONAL MEDICAL CENTER | 25 0.25 40.68 KAISER FOUNDATION HOSPITAL - SAN FRAN.. | 30 0.30 40.98 KAISER FOUNDATION HOSPITAL - SOUTH SA.. | 23 0.23 41.21 KAISER FOUNDATION HOSPITAL - WALNUT C.. | 29 0.29 41.50 KAISER FOUNDATION HOSPITAL AND REHAB .. | 31 0.31 41.81 KAISER FOUNDATION HOSPITAL OAKLAND/RI.. | 37 0.37 42.18 KAISER FOUNDATION HOSPITAL-SANTA CLARA | 36 0.36 42.54 KAWEAH DELTA MEDICAL CENTER | 65 0.65 43.19 KINGMAN REGIONAL MEDICAL CENTER | 47 0.47 43.66 L V STABLER MEMORIAL HOSPITAL | 20 0.20 43.86 LA PAZ REGIONAL HOSPITAL | 26 0.26 44.12 LAC/OLIVE VIEW-UCLA MEDICAL CENTER | 23 0.23 44.35 LAKE MARTIN COMMUNITY HOSPITAL | 11 0.11 44.46 LAKELAND COMMUNITY HOSPITAL | 19 0.19 44.65 LAWRENCE MEDICAL CENTER | 9 0.09 44.74 MAD RIVER COMMUNITY HOSPITAL | 23 0.23 44.97 MAGNOLIA HOSPITAL | 18 0.18 45.15 MARIAN REGIONAL MEDICAL CENTER | 55 0.55 45.70 MARIAN REGIONAL MEDICAL CENTER, ARROY.. | 34 0.34 46.04 MARICOPA MEDICAL CENTER | 33 0.33 46.37 MARION REGIONAL MEDICAL CENTER | 17 0.17 46.54 MARSHALL MEDICAL CENTER SOUTH | 39 0.39 46.93 MARYVALE HOSPITAL | 22 0.22 47.15 MAT-SU REGIONAL MEDICAL CENTER | 36 0.36 47.51 MAYO CLINIC HOSPITAL | 64 0.64 48.15 MEDICAL CENTER BARBOUR | 16 0.16 48.31 MEDICAL CENTER ENTERPRISE | 27 0.27 48.58 MEDICAL CENTER SOUTH ARKANSAS | 41 0.41 48.99 MEDICAL PARK HOSPITAL | 15 0.15 49.14 MEDICAL WEST, AN AFFILIATE OF UAB HEA.. | 43 0.43 49.57 MENA REGIONAL HEALTH SYSTEM | 17 0.17 49.74 MERCY GENERAL HOSPITAL | 62 0.62 50.36 MERCY GILBERT MEDICAL CENTER | 51 0.51 50.87 MERCY MEDICAL CENTER | 60 0.60 51.47 MIZELL MEMORIAL HOSPITAL | 22 0.22 51.69 MOBILE INFIRMARY | 66 0.66 52.35 MONROE COUNTY HOSPITAL | 18 0.18 52.53 MOUNTAIN VISTA MEDICAL CENTER, LP | 59 0.59 53.12 MT EDGECUMBE HOSPITAL | 14 0.14 53.26 MT GRAHAM REGIONAL MEDICAL CENTER | 22 0.22 53.48 NATIONAL PARK MEDICAL CENTER | 55 0.55 54.03 NEA BAPTIST MEMORIAL HOSPITAL | 57 0.57 54.60 NORTH ARKANSAS REGIONAL MEDICAL CENTER | 32 0.32 54.92 NORTH BALDWIN INFIRMARY | 22 0.22 55.14 NORTH METRO MEDICAL CENTER | 23 0.23 55.37 NORTHEAST ALABAMA REGIONAL MED CENTER | 57 0.57 55.94 NORTHWEST MEDICAL CENTER | 91 0.91 56.85 NW ARKANSAS HOSPITALS, LLC | 62 0.62 57.47 OAK VALLEY DISTRICT HOSPITAL | 19 0.19 57.66 OASIS HOSPITAL | 5 0.05 57.71 OJAI VALLEY COMMUNITY HOSPITAL | 18 0.18 57.89 ORO VALLEY HOSPITAL | 44 0.44 58.33 OROVILLE HOSPITAL | 40 0.40 58.73 OUACHITA COUNTY MEDICAL CENTER | 20 0.20 58.93 PACIFIC ALLIANCE MEDICAL CENTER | 26 0.26 59.19 PARADISE VALLEY HOSPITAL | 69 0.69 59.88 PARKVIEW COMMUNITY HOSPITAL MEDICAL C.. | 39 0.39 60.27 PARKWAY MEDICAL CENTER | 24 0.24 60.51 PAYSON REGIONAL MEDICAL CENTER | 35 0.35 60.86 PENINSULA MEDICAL CENTER | 59 0.59 61.45 PHOENIX BAPTIST HOSPITAL | 53 0.53 61.98 PHOENIX INDIAN MEDICAL CENTER | 8 0.08 62.06 PHYSICIANS' SPECIALTY HOSPITAL | 18 0.18 62.24 PICKENS COUNTY MEDICAL CENTER | 20 0.20 62.44 PRATTVILLE BAPTIST HOSPITAL | 19 0.19 62.63 PROVIDENCE ALASKA MEDICAL CENTER | 62 0.62 63.25 PROVIDENCE HOSPITAL | 66 0.66 63.91 PROVIDENCE LITTLE CO OF MARY MED CTR .. | 37 0.37 64.28 QUEEN OF THE VALLEY MEDICAL CENTER | 61 0.61 64.89 RIVERSIDE COMMUNITY HOSPITAL | 62 0.62 65.51 RIVERVIEW REGIONAL MEDICAL CENTER | 58 0.58 66.09 RUSSELL HOSPITAL | 41 0.41 66.50 RUSSELLVILLE HOSPITAL | 34 0.34 66.84 SAINT AGNES MEDICAL CENTER | 63 0.63 67.47 SAINT FRANCIS MEDICAL CENTER | 54 0.54 68.01 SALINE MEMORIAL HOSPITAL | 34 0.34 68.35 SAN ANTONIO COMMUNITY HOSPITAL | 59 0.59 68.94 SAN GORGONIO MEMORIAL HOSPITAL | 20 0.20 69.14 SANTA CLARA VALLEY MEDICAL CENTER | 46 0.46 69.60 SCOTTSDALE HEALTHCARE-OSBORN MEDICAL .. | 56 0.56 70.16 SCOTTSDALE HEALTHCARE-SHEA MEDICAL CE.. | 65 0.65 70.81 SCOTTSDALE HEALTHCARE-THOMPSON PEAK H.. | 42 0.42 71.23 SCRIPPS MERCY HOSPITAL | 65 0.65 71.88 SELLS INDIAN HEALTH SERVICE HOSPITAL | 2 0.02 71.90 SHARP MEMORIAL HOSPITAL | 66 0.66 72.56 SHELBY BAPTIST MEDICAL CENTER | 60 0.60 73.16 SHOALS HOSPITAL | 26 0.26 73.42 SIERRA VISTA REGIONAL HEALTH CENTER INC | 27 0.27 73.69 SILOAM SPRINGS REGIONAL HOSPITAL | 22 0.22 73.91 SONOMA VALLEY HOSPITAL | 33 0.33 74.24 SOUTH BALDWIN REGIONAL MEDICAL CENTER | 39 0.39 74.63 SOUTHEAST ALABAMA MEDICAL CENTER | 63 0.63 75.26 SPARKS REGIONAL MEDICAL CENTER | 63 0.63 75.89 SPRINGHILL MEDICAL CENTER | 52 0.52 76.41 ST BERNARDS MEDICAL CENTER | 68 0.68 77.09 ST EDWARD MERCY MEDICAL CENTER | 63 0.63 77.72 ST ELIZABETH COMMUNITY HOSPITAL | 27 0.27 77.99 ST HELENA HOSPITAL | 47 0.47 78.46 ST JOHNS REGIONAL MEDICAL CENTER | 58 0.58 79.04 ST JOSEPH HOSPITAL | 117 1.17 80.21 ST JOSEPH'S HOSPITAL AND MEDICAL CENTER | 58 0.58 80.79 ST JOSEPHS MEDICAL CENTER OF STOCKTON | 61 0.61 81.40 ST JOSEPHS MERCY HEALTH CENTER INC | 65 0.65 82.05 ST LUKES MEDICAL CENTER | 43 0.43 82.48 ST MARYS REGIONAL MEDICAL CENTER | 38 0.38 82.86 ST ROSE HOSPITAL | 41 0.41 83.27 ST VINCENT INFIRMARY MEDICAL CENTER | 67 0.67 83.94 ST VINCENT MEDICAL CENTER/NORTH | 32 0.32 84.26 ST VINCENT'S BIRMINGHAM | 66 0.66 84.92 ST VINCENT'S EAST | 63 0.63 85.55 ST VINCENT'S ST CLAIR | 14 0.14 85.69 ST VINCENTS BLOUNT | 18 0.18 85.87 STRINGFELLOW MEMORIAL HOSPITAL | 43 0.43 86.30 SUMMIT HEALTHCARE REGIONAL MEDICAL CE.. | 34 0.34 86.64 SUMMIT MEDICAL CENTER | 24 0.24 86.88 SURGICAL SPECIALTY HOSPITAL OF PHOENIX | 11 0.11 86.99 SUTTER AMADOR HOSPITAL | 25 0.25 87.24 SUTTER GENERAL HOSPITAL | 24 0.24 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,899 28.99 32.11 AR | 1,704 17.04 49.15 AZ | 2,545 25.45 74.60 CA | 2,540 25.40 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 | 124 1.24 1.24 39 | 142 1.42 2.66 190 | 253 2.53 5.19 191 | 253 2.53 7.72 192 | 252 2.52 10.24 193 | 246 2.46 12.70 219 | 95 0.95 13.65 220 | 97 0.97 14.62 221 | 68 0.68 15.30 224 | 90 0.90 16.20 225 | 86 0.86 17.06 226 | 105 1.05 18.11 227 | 119 1.19 19.30 235 | 94 0.94 20.24 236 | 100 1.00 21.24 237 | 134 1.34 22.58 243 | 157 1.57 24.15 244 | 158 1.58 25.73 247 | 135 1.35 27.08 280 | 239 2.39 29.47 281 | 229 2.29 31.76 282 | 230 2.30 34.06 291 | 252 2.52 36.58 292 | 254 2.54 39.12 293 | 252 2.52 41.64 313 | 240 2.40 44.04 328 | 143 1.43 45.47 329 | 214 2.14 47.61 330 | 215 2.15 49.76 331 | 190 1.90 51.66 353 | 114 1.14 52.80 354 | 168 1.68 54.48 355 | 171 1.71 56.19 414 | 118 1.18 57.37 417 | 187 1.87 59.24 418 | 213 2.13 61.37 419 | 217 2.17 63.54 459 | 75 0.75 64.29 460 | 117 1.17 65.46 461 | 10 0.10 65.56 462 | 71 0.71 66.27 466 | 104 1.04 67.31 467 | 151 1.51 68.82 468 | 138 1.38 70.20 469 | 181 1.81 72.01 470 | 201 2.01 74.02 471 | 76 0.76 74.78 472 | 91 0.91 75.69 473 | 115 1.15 76.84 477 | 76 0.76 77.60 478 | 100 1.00 78.60 479 | 64 0.64 79.24 490 | 110 1.10 80.34 491 | 116 1.16 81.50 507 | 31 0.31 81.81 508 | 36 0.36 82.17 515 | 88 0.88 83.05 637 | 227 2.27 85.32 656 | 101 1.01 86.33 657 | 110 1.10 87.43 658 | 105 1.05 88.48 659 | 91 0.91 89.39 668 | 103 1.03 90.42 673 | 136 1.36 91.78 674 | 136 1.36 93.14 675 | 68 0.68 93.82 713 | 130 1.30 95.12 714 | 145 1.45 96.57 743 | 186 1.86 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.. | 229 2.29 2.29 Acute myocardial infarction, discharg.. | 239 2.39 4.68 Acute myocardial infarction, discharg.. | 230 2.30 6.98 Back and neck proc exc spinal fusion .. | 110 1.10 8.08 Back and neck proc exc spinal fusion .. | 116 1.16 9.24 Bilateral or multiple major joint pro.. | 10 0.10 9.34 Bilateral or multiple major joint pro.. | 71 0.71 10.05 Biopsies of musculoskeletal system an.. | 100 1.00 11.05 Biopsies of musculoskeletal system an.. | 76 0.76 11.81 Biopsies of musculoskeletal system an.. | 64 0.64 12.45 Cardiac defib implant w cardiac cath .. | 90 0.90 13.35 Cardiac defib implant w cardiac cath .. | 86 0.86 14.21 Cardiac defibrillator implant w/o car.. | 105 1.05 15.26 Cardiac defibrillator implant w/o car.. | 119 1.19 16.45 Cardiac valve and oth maj cardiothora.. | 97 0.97 17.42 Cardiac valve and oth maj cardiothora.. | 95 0.95 18.37 Cardiac valve and oth maj cardiothora.. | 68 0.68 19.05 Cervical spinal fusion w CC | 91 0.91 19.96 Cervical spinal fusion w MCC | 76 0.76 20.72 Cervical spinal fusion w/o CC/MCC | 115 1.15 21.87 Chest Pain | 240 2.40 24.27 Cholecystectomy except by laparoscope.. | 118 1.18 25.45 Chronic obstructive pulmonary disease.. | 253 2.53 27.98 Chronic obstructive pulmonary disease.. | 253 2.53 30.51 Chronic obstructive pulmonary disease.. | 252 2.52 33.03 Coronary bypass w/o cardiac cath w MCC | 94 0.94 33.97 Coronary bypass w/o cardiac cath w/o .. | 100 1.00 34.97 Diabetes w MCC | 227 2.27 37.24 Extracranial procedures w CC | 124 1.24 38.48 Extracranial procedures w/o CC/MCC | 142 1.42 39.90 Female reproductive system reconstruc.. | 157 1.57 41.47 Heart failure and shock w CC | 254 2.54 44.01 Heart failure and shock w MCC | 252 2.52 46.53 Heart failure and shock w/o CC/MCC | 252 2.52 49.05 Hernia procedures except inguinal and.. | 168 1.68 50.73 Hernia procedures except inguinal and.. | 114 1.14 51.87 Hernia procedures except inguinal and.. | 171 1.71 53.58 Kidney and ureter procedures for neop.. | 110 1.10 54.68 Kidney and ureter procedures for neop.. | 101 1.01 55.69 Kidney and ureter procedures for neop.. | 105 1.05 56.74 Kidney and ureter procedures for non-.. | 91 0.91 57.65 Laparoscopic cholecystectomy w/o c.d... | 213 2.13 59.78 Laparoscopic cholecystectomy w/o c.d... | 187 1.87 61.65 Laparoscopic cholecystectomy w/o c.d... | 217 2.17 63.82 Major cardiovasc procedures w MCC or .. | 134 1.34 65.16 Major joint replacement or reattachme.. | 181 1.81 66.97 Major joint replacement or reattachme.. | 201 2.01 68.98 Major shoulder or elbow joint procedu.. | 31 0.31 69.29 Major shoulder or elbow joint procedu.. | 36 0.36 69.65 Major small and large bowel procedure.. | 215 2.15 71.80 Major small and large bowel procedure.. | 214 2.14 73.94 Major small and large bowel procedure.. | 190 1.90 75.84 Other kidney and urinary tract proced.. | 136 1.36 77.20 Other kidney and urinary tract proced.. | 136 1.36 78.56 Other kidney and urinary tract proced.. | 68 0.68 79.24 Other musculoskelet sys and conn tiss.. | 88 0.88 80.12 Perc cardiovasc proc w drug-eluting s.. | 135 1.35 81.47 Permanent cardiac pacemaker implant w.. | 157 1.57 83.04 Permanent cardiac pacemaker implant w.. | 158 1.58 84.62 Revision of hip or knee replacement w.. | 151 1.51 86.13 Revision of hip or knee replacement w.. | 104 1.04 87.17 Revision of hip or knee replacement w.. | 138 1.38 88.55 Simple pneumonia and pleurisy w MCC | 246 2.46 91.01 Spinal fusion except cervical w MCC | 75 0.75 91.76 Spinal fusion except cervical w/o MCC | 117 1.17 92.93 Stomach, esophageal duodenal proc w/o.. | 143 1.43 94.36 Transurethral procedures w MCC | 103 1.03 95.39 Transurethral prostatectomy w CC/MCC | 130 1.30 96.69 Transurethral prostatectomy w/o CC/MCC | 145 1.45 98.14 Uterine and adnexa proc for non-malig.. | 186 1.86 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,048 60.48 60.48 100 | 5 0.05 60.53 101 | 6 0.06 60.59 102 | 3 0.03 60.62 103 | 8 0.08 60.70 104 | 8 0.08 60.78 105 | 5 0.05 60.83 106 | 9 0.09 60.92 107 | 3 0.03 60.95 108 | 4 0.04 60.99 109 | 5 0.05 61.04 11 | 220 2.20 63.24 110 | 5 0.05 63.29 111 | 3 0.03 63.32 112 | 4 0.04 63.36 113 | 3 0.03 63.39 114 | 7 0.07 63.46 115 | 6 0.06 63.52 116 | 3 0.03 63.55 117 | 2 0.02 63.57 118 | 3 0.03 63.60 119 | 1 0.01 63.61 12 | 207 2.07 65.68 120 | 1 0.01 65.69 121 | 5 0.05 65.74 122 | 2 0.02 65.76 123 | 2 0.02 65.78 124 | 2 0.02 65.80 125 | 5 0.05 65.85 126 | 1 0.01 65.86 127 | 2 0.02 65.88 129 | 3 0.03 65.91 13 | 201 2.01 67.92 130 | 7 0.07 67.99 131 | 5 0.05 68.04 132 | 3 0.03 68.07 133 | 2 0.02 68.09 134 | 3 0.03 68.12 135 | 2 0.02 68.14 136 | 3 0.03 68.17 137 | 1 0.01 68.18 138 | 2 0.02 68.20 139 | 3 0.03 68.23 14 | 159 1.59 69.82 142 | 1 0.01 69.83 143 | 2 0.02 69.85 146 | 5 0.05 69.90 147 | 6 0.06 69.96 148 | 3 0.03 69.99 15 | 158 1.58 71.57 150 | 3 0.03 71.60 151 | 1 0.01 71.61 153 | 2 0.02 71.63 154 | 1 0.01 71.64 156 | 1 0.01 71.65 157 | 2 0.02 71.67 158 | 2 0.02 71.69 159 | 1 0.01 71.70 16 | 147 1.47 73.17 162 | 1 0.01 73.18 163 | 1 0.01 73.19 164 | 2 0.02 73.21 165 | 1 0.01 73.22 166 | 2 0.02 73.24 167 | 1 0.01 73.25 168 | 2 0.02 73.27 169 | 1 0.01 73.28 17 | 135 1.35 74.63 171 | 1 0.01 74.64 172 | 2 0.02 74.66 178 | 3 0.03 74.69 18 | 153 1.53 76.22 182 | 1 0.01 76.23 183 | 2 0.02 76.25 184 | 1 0.01 76.26 185 | 1 0.01 76.27 189 | 2 0.02 76.29 19 | 112 1.12 77.41 191 | 1 0.01 77.42 192 | 2 0.02 77.44 193 | 1 0.01 77.45 194 | 1 0.01 77.46 196 | 1 0.01 77.47 197 | 2 0.02 77.49 198 | 1 0.01 77.50 199 | 1 0.01 77.51 20 | 114 1.14 78.65 201 | 3 0.03 78.68 204 | 1 0.01 78.69 205 | 1 0.01 78.70 208 | 2 0.02 78.72 21 | 111 1.11 79.83 211 | 2 0.02 79.85 213 | 1 0.01 79.86 214 | 2 0.02 79.88 215 | 2 0.02 79.90 217 | 2 0.02 79.92 219 | 1 0.01 79.93 22 | 109 1.09 81.02 220 | 1 0.01 81.03 226 | 1 0.01 81.04 228 | 1 0.01 81.05 229 | 1 0.01 81.06 23 | 93 0.93 81.99 230 | 2 0.02 82.01 234 | 1 0.01 82.02 236 | 1 0.01 82.03 238 | 1 0.01 82.04 239 | 1 0.01 82.05 24 | 84 0.84 82.89 242 | 1 0.01 82.90 243 | 1 0.01 82.91 244 | 2 0.02 82.93 246 | 1 0.01 82.94 25 | 82 0.82 83.76 255 | 1 0.01 83.77 26 | 86 0.86 84.63 262 | 2 0.02 84.65 263 | 1 0.01 84.66 266 | 1 0.01 84.67 267 | 1 0.01 84.68 27 | 75 0.75 85.43 275 | 1 0.01 85.44 278 | 1 0.01 85.45 28 | 61 0.61 86.06 280 | 1 0.01 86.07 285 | 1 0.01 86.08 287 | 1 0.01 86.09 289 | 1 0.01 86.10 29 | 57 0.57 86.67 292 | 1 0.01 86.68 296 | 1 0.01 86.69 299 | 2 0.02 86.71 30 | 55 0.55 87.26 302 | 1 0.01 87.27 304 | 2 0.02 87.29 31 | 54 0.54 87.83 311 | 1 0.01 87.84 314 | 1 0.01 87.85 32 | 43 0.43 88.28 328 | 1 0.01 88.29 33 | 47 0.47 88.76 330 | 1 0.01 88.77 339 | 2 0.02 88.79 34 | 47 0.47 89.26 347 | 1 0.01 89.27 35 | 45 0.45 89.72 36 | 36 0.36 90.08 37 | 31 0.31 90.39 38 | 42 0.42 90.81 380 | 1 0.01 90.82 39 | 31 0.31 91.13 40 | 31 0.31 91.44 408 | 1 0.01 91.45 41 | 32 0.32 91.77 415 | 1 0.01 91.78 42 | 29 0.29 92.07 425 | 1 0.01 92.08 43 | 26 0.26 92.34 44 | 23 0.23 92.57 45 | 27 0.27 92.84 46 | 23 0.23 93.07 468 | 1 0.01 93.08 469 | 1 0.01 93.09 47 | 24 0.24 93.33 470 | 1 0.01 93.34 48 | 21 0.21 93.55 49 | 33 0.33 93.88 494 | 1 0.01 93.89 50 | 31 0.31 94.20 51 | 22 0.22 94.42 52 | 25 0.25 94.67 53 | 19 0.19 94.86 54 | 16 0.16 95.02 55 | 17 0.17 95.19 56 | 15 0.15 95.34 560 | 1 0.01 95.35 57 | 22 0.22 95.57 58 | 15 0.15 95.72 59 | 14 0.14 95.86 60 | 18 0.18 96.04 608 | 1 0.01 96.05 61 | 11 0.11 96.16 62 | 15 0.15 96.31 63 | 18 0.18 96.49 632 | 1 0.01 96.50 64 | 12 0.12 96.62 643 | 1 0.01 96.63 65 | 9 0.09 96.72 66 | 17 0.17 96.89 67 | 15 0.15 97.04 68 | 16 0.16 97.20 69 | 20 0.20 97.40 70 | 11 0.11 97.51 71 | 14 0.14 97.65 710 | 1 0.01 97.66 72 | 14 0.14 97.80 73 | 15 0.15 97.95 732 | 1 0.01 97.96 74 | 8 0.08 98.04 75 | 15 0.15 98.19 76 | 6 0.06 98.25 767 | 1 0.01 98.26 77 | 3 0.03 98.29 78 | 9 0.09 98.38 79 | 5 0.05 98.43 80 | 9 0.09 98.52 81 | 11 0.11 98.63 818 | 1 0.01 98.64 82 | 10 0.10 98.74 83 | 9 0.09 98.83 84 | 9 0.09 98.92 85 | 11 0.11 99.03 86 | 5 0.05 99.08 87 | 4 0.04 99.12 88 | 4 0.04 99.16 89 | 6 0.06 99.22 90 | 5 0.05 99.27 91 | 10 0.10 99.37 92 | 12 0.12 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