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 | 66 0.66 0.66 010005 | 39 0.39 1.05 010006 | 58 0.58 1.63 010007 | 26 0.26 1.89 010008 | 11 0.11 2.00 010011 | 59 0.59 2.59 010012 | 34 0.34 2.93 010016 | 60 0.60 3.53 010019 | 45 0.45 3.98 010021 | 22 0.22 4.20 010022 | 13 0.13 4.33 010023 | 60 0.60 4.93 010024 | 58 0.58 5.51 010025 | 27 0.27 5.78 010029 | 65 0.65 6.43 010032 | 11 0.11 6.54 010033 | 70 0.70 7.24 010034 | 21 0.21 7.45 010035 | 45 0.45 7.90 010036 | 31 0.31 8.21 010038 | 43 0.43 8.64 010039 | 68 0.68 9.32 010040 | 61 0.61 9.93 010044 | 16 0.16 10.09 010045 | 18 0.18 10.27 010046 | 51 0.51 10.78 010047 | 11 0.11 10.89 010049 | 25 0.25 11.14 010050 | 17 0.17 11.31 010051 | 7 0.07 11.38 010052 | 12 0.12 11.50 010054 | 26 0.26 11.76 010055 | 65 0.65 12.41 010056 | 68 0.68 13.09 010058 | 5 0.05 13.14 010059 | 12 0.12 13.26 010061 | 27 0.27 13.53 010062 | 22 0.22 13.75 010065 | 36 0.36 14.11 010066 | 7 0.07 14.18 010069 | 18 0.18 14.36 010073 | 12 0.12 14.48 010078 | 60 0.60 15.08 010079 | 33 0.33 15.41 010083 | 49 0.49 15.90 010085 | 41 0.41 16.31 010086 | 23 0.23 16.54 010087 | 41 0.41 16.95 010089 | 47 0.47 17.42 010090 | 62 0.62 18.04 010091 | 12 0.12 18.16 010092 | 68 0.68 18.84 010095 | 8 0.08 18.92 010097 | 11 0.11 19.03 010099 | 21 0.21 19.24 010100 | 56 0.56 19.80 010101 | 24 0.24 20.04 010102 | 8 0.08 20.12 010103 | 64 0.64 20.76 010104 | 66 0.66 21.42 010108 | 20 0.20 21.62 010109 | 15 0.15 21.77 010110 | 8 0.08 21.85 010112 | 19 0.19 22.04 010113 | 66 0.66 22.70 010114 | 37 0.37 23.07 010118 | 39 0.39 23.46 010120 | 16 0.16 23.62 010125 | 19 0.19 23.81 010126 | 23 0.23 24.04 010128 | 9 0.09 24.13 010129 | 24 0.24 24.37 010130 | 11 0.11 24.48 010131 | 55 0.55 25.03 010138 | 8 0.08 25.11 010139 | 64 0.64 25.75 010144 | 57 0.57 26.32 010146 | 19 0.19 26.51 010148 | 12 0.12 26.63 010149 | 37 0.37 27.00 010150 | 18 0.18 27.18 010157 | 24 0.24 27.42 010158 | 29 0.29 27.71 010164 | 24 0.24 27.95 010168 | 26 0.26 28.21 010169 | 21 0.21 28.42 020001 | 61 0.61 29.03 020006 | 39 0.39 29.42 020008 | 24 0.24 29.66 020012 | 36 0.36 30.02 020017 | 56 0.56 30.58 020018 | 7 0.07 30.65 020024 | 34 0.34 30.99 020026 | 41 0.41 31.40 020027 | 17 0.17 31.57 030001 | 23 0.23 31.80 030002 | 66 0.66 32.46 030006 | 66 0.66 33.12 030007 | 41 0.41 33.53 030010 | 50 0.50 34.03 030011 | 58 0.58 34.61 030012 | 62 0.62 35.23 030013 | 59 0.59 35.82 030014 | 63 0.63 36.45 030016 | 40 0.40 36.85 030022 | 25 0.25 37.10 030023 | 61 0.61 37.71 030024 | 61 0.61 38.32 030030 | 50 0.50 38.82 030033 | 33 0.33 39.15 030036 | 65 0.65 39.80 030037 | 38 0.38 40.18 030038 | 57 0.57 40.75 030043 | 29 0.29 41.04 030055 | 49 0.49 41.53 030061 | 64 0.64 42.17 030062 | 37 0.37 42.54 030064 | 65 0.65 43.19 030065 | 66 0.66 43.85 030067 | 23 0.23 44.08 030068 | 21 0.21 44.29 030069 | 48 0.48 44.77 030071 | 16 0.16 44.93 030073 | 21 0.21 45.14 030078 | 11 0.11 45.25 030083 | 41 0.41 45.66 030084 | 10 0.10 45.76 030085 | 63 0.63 46.39 030087 | 64 0.64 47.03 030088 | 47 0.47 47.50 030089 | 60 0.60 48.10 030092 | 53 0.53 48.63 030093 | 54 0.54 49.17 030094 | 59 0.59 49.76 030101 | 52 0.52 50.28 030103 | 69 0.69 50.97 030105 | 29 0.29 51.26 030107 | 10 0.10 51.36 030108 | 10 0.10 51.46 030110 | 47 0.47 51.93 030111 | 33 0.33 52.26 030112 | 5 0.05 52.31 030113 | 10 0.10 52.41 030114 | 38 0.38 52.79 030115 | 56 0.56 53.35 030117 | 39 0.39 53.74 030118 | 29 0.29 54.03 030119 | 53 0.53 54.56 030120 | 20 0.20 54.76 030121 | 57 0.57 55.33 030122 | 38 0.38 55.71 030123 | 45 0.45 56.16 030126 | 36 0.36 56.52 030130 | 16 0.16 56.68 030131 | 15 0.15 56.83 030132 | 11 0.11 56.94 040001 | 24 0.24 57.18 040002 | 22 0.22 57.40 040004 | 65 0.65 58.05 040007 | 67 0.67 58.72 040010 | 56 0.56 59.28 040011 | 14 0.14 59.42 040014 | 57 0.57 59.99 040015 | 16 0.16 60.15 040016 | 63 0.63 60.78 040017 | 37 0.37 61.15 040018 | 21 0.21 61.36 040019 | 21 0.21 61.57 040020 | 60 0.60 62.17 040022 | 64 0.64 62.81 040026 | 63 0.63 63.44 040027 | 61 0.61 64.05 040029 | 54 0.54 64.59 040036 | 65 0.65 65.24 040039 | 36 0.36 65.60 040041 | 35 0.35 65.95 040042 | 28 0.28 66.23 040047 | 13 0.13 66.36 040050 | 23 0.23 66.59 040051 | 17 0.17 66.76 040055 | 63 0.63 67.39 040062 | 61 0.61 68.00 040067 | 17 0.17 68.17 040069 | 17 0.17 68.34 040071 | 55 0.55 68.89 040072 | 14 0.14 69.03 040074 | 23 0.23 69.26 040076 | 20 0.20 69.46 040078 | 58 0.58 70.04 040080 | 19 0.19 70.23 040084 | 35 0.35 70.58 040085 | 16 0.16 70.74 040088 | 46 0.46 71.20 040114 | 66 0.66 71.86 040118 | 54 0.54 72.40 040119 | 44 0.44 72.84 040134 | 39 0.39 73.23 040137 | 32 0.32 73.55 040147 | 13 0.13 73.68 040152 | 14 0.14 73.82 050002 | 42 0.42 74.24 050006 | 60 0.60 74.84 050007 | 55 0.55 75.39 050008 | 33 0.33 75.72 050009 | 59 0.59 76.31 050013 | 46 0.46 76.77 050014 | 28 0.28 77.05 050016 | 35 0.35 77.40 050017 | 62 0.62 78.02 050018 | 30 0.30 78.32 050022 | 60 0.60 78.92 050024 | 33 0.33 79.25 050025 | 66 0.66 79.91 050026 | 67 0.67 80.58 050028 | 22 0.22 80.80 050030 | 41 0.41 81.21 050036 | 61 0.61 81.82 050038 | 56 0.56 82.38 050039 | 64 0.64 83.02 050040 | 22 0.22 83.24 050042 | 25 0.25 83.49 050043 | 55 0.55 84.04 050045 | 34 0.34 84.38 050046 | 17 0.17 84.55 050047 | 65 0.65 85.20 050054 | 22 0.22 85.42 050055 | 24 0.24 85.66 050056 | 58 0.58 86.24 050057 | 62 0.62 86.86 050058 | 62 0.62 87.48 050060 | 63 0.63 88.11 050063 | 51 0.51 88.62 050067 | 21 0.21 88.83 050069 | 64 0.64 89.47 050070 | 18 0.18 89.65 050071 | 33 0.33 89.98 050072 | 27 0.27 90.25 050073 | 27 0.27 90.52 050075 | 35 0.35 90.87 050076 | 24 0.24 91.11 050077 | 66 0.66 91.77 050078 | 41 0.41 92.18 050079 | 43 0.43 92.61 050082 | 56 0.56 93.17 050084 | 62 0.62 93.79 050089 | 30 0.30 94.09 050090 | 26 0.26 94.35 050091 | 25 0.25 94.60 050093 | 64 0.64 95.24 050096 | 4 0.04 95.28 050099 | 53 0.53 95.81 050100 | 66 0.66 96.47 050101 | 38 0.38 96.85 050102 | 32 0.32 97.17 050103 | 56 0.56 97.73 050104 | 47 0.47 98.20 050107 | 59 0.59 98.79 050108 | 67 0.67 99.46 050110 | 27 0.27 99.73 050111 | 27 0.27 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 | 41 0.41 0.41 ALASKA REGIONAL HOSPITAL | 56 0.56 0.97 ALTA BATES SUMMIT MEDICAL CENTER | 55 0.55 1.52 ANDALUSIA REGIONAL HOSPITAL | 31 0.31 1.83 ANTELOPE VALLEY HOSPITAL MED CENTER | 58 0.58 2.41 ARIZONA ORTHOPEDIC SURGICAL HOSPITAL | 5 0.05 2.46 ARIZONA REGIONAL MEDICAL CENTER | 36 0.36 2.82 ARIZONA SPINE AND JOINT HOSPITAL | 10 0.10 2.92 ARKANSAS HEART HOSPITAL | 39 0.39 3.31 ARKANSAS METHODIST MEDICAL CENTER | 36 0.36 3.67 ARKANSAS SURGICAL HOSPITAL | 13 0.13 3.80 ARROWHEAD HOSPITAL | 59 0.59 4.39 ATHENS-LIMESTONE HOSPITAL | 33 0.33 4.72 ATMORE COMMUNITY HOSPITAL | 21 0.21 4.93 BAKERSFIELD MEMORIAL HOSPITAL | 61 0.61 5.54 BANNER BAYWOOD MEDICAL CENTER | 47 0.47 6.01 BANNER BOSWELL MEDICAL CENTER | 64 0.64 6.65 BANNER DEL E WEBB MEDICAL CENTER | 54 0.54 7.19 BANNER DESERT MEDICAL CENTER | 66 0.66 7.85 BANNER ESTRELLA MEDICAL CENTER | 56 0.56 8.41 BANNER GATEWAY MEDICAL CENTER | 38 0.38 8.79 BANNER GOOD SAMARITAN MEDICAL CENTER | 66 0.66 9.45 BANNER HEART HOSPITAL | 29 0.29 9.74 BANNER IRONWOOD MEDICAL CENTER | 16 0.16 9.90 BANNER THUNDERBIRD MEDICAL CENTER | 60 0.60 10.50 BAPTIST HEALTH MEDICAL CENTER NORTH L.. | 65 0.65 11.15 BAPTIST HEALTH MEDICAL CENTER-LITTLE .. | 66 0.66 11.81 BAPTIST HEALTH MEDICAL CENTER-STUTTGART | 14 0.14 11.95 BAPTIST MEDICAL CENTER EAST | 37 0.37 12.32 BAPTIST MEDICAL CENTER SOUTH | 60 0.60 12.92 BAPTIST MEDICAL CENTER-PRINCETON | 64 0.64 13.56 BARTLETT REGIONAL HOSPITAL | 24 0.24 13.80 BAXTER REGIONAL MEDICAL CENTER | 61 0.61 14.41 BIBB MEDICAL CENTER | 5 0.05 14.46 BROOKWOOD MEDICAL CENTER | 64 0.64 15.10 BRYAN W WHITFIELD MEM HOSP INC | 19 0.19 15.29 BULLOCK COUNTY HOSPITAL | 8 0.08 15.37 CALIFORNIA PACIFIC MEDICAL CTR - ST. .. | 24 0.24 15.61 CALIFORNIA PACIFIC MEDICAL CTR-DAVIES.. | 33 0.33 15.94 CALIFORNIA PACIFIC MEDICAL CTR-PACIFI.. | 65 0.65 16.59 CARONDELET ST MARYS HOSPITAL | 50 0.50 17.09 CARONDELET ST JOSEPH'S HOSPITAL | 58 0.58 17.67 CASA GRANDE REGIONAL MEDICAL CENTER | 40 0.40 18.07 CENTRAL PENINSULA GENERAL HOSPITAL | 34 0.34 18.41 CHAMBERS MEMORIAL HOSPITAL | 14 0.14 18.55 CHANDLER REGIONAL MEDICAL CENTER | 65 0.65 19.20 CHEROKEE MEDICAL CENTER | 13 0.13 19.33 CHINLE COMPREHENSIVE HEALTH CARE FACI.. | 10 0.10 19.43 CITIZENS BAPTIST MEDICAL CENTER | 24 0.24 19.67 CLAY COUNTY HOSPITAL | 12 0.12 19.79 COMMUNITY HOSPITAL INC | 21 0.21 20.00 COMMUNITY HOSPITAL OF HUNTINGTON PARK | 25 0.25 20.25 COMMUNITY HOSPITAL OF SAN BERNARDINO | 30 0.30 20.55 COMMUNITY REGIONAL MEDICAL CENTER | 63 0.63 21.18 CONWAY REGIONAL MEDICAL CENTER | 54 0.54 21.72 COOSA VALLEY MEDICAL CENTER | 24 0.24 21.96 CRENSHAW COMMUNITY HOSPITAL | 11 0.11 22.07 CRESTWOOD MEDICAL CENTER | 55 0.55 22.62 CRITTENDEN MEMORIAL HOSPITAL | 28 0.28 22.90 CULLMAN REGIONAL MEDICAL CENTER | 45 0.45 23.35 D C H REGIONAL MEDICAL CENTER | 68 0.68 24.03 D W MCMILLAN MEMORIAL HOSPITAL | 21 0.21 24.24 DALE MEDICAL CENTER | 22 0.22 24.46 DECATUR MORGAN HOSPITAL-DECATUR CAMPUS | 41 0.41 24.87 DEKALB REGIONAL MEDICAL CENTER | 34 0.34 25.21 DOCTORS HOSPITAL OF WEST COVINA, INC | 4 0.04 25.25 DOCTORS MEDICAL CENTER-SAN PABLO | 43 0.43 25.68 DREW MEMORIAL HOSPITAL | 17 0.17 25.85 EAST ALABAMA MEDICAL CENTER AND SNF | 65 0.65 26.50 EL CENTRO REGIONAL MEDICAL CENTER | 34 0.34 26.84 ELIZA COFFEE MEMORIAL HOSPITAL | 58 0.58 27.42 ELMORE COMMUNITY HOSPITAL | 11 0.11 27.53 ENLOE MEDICAL CENTER | 64 0.64 28.17 EVERGREEN MEDICAL CENTER | 12 0.12 28.29 FAIRBANKS MEMORIAL HOSPITAL | 36 0.36 28.65 FAYETTE MEDICAL CENTER | 18 0.18 28.83 FIVE RIVERS MEDICAL CENTER | 13 0.13 28.96 FLAGSTAFF MEDICAL CENTER | 61 0.61 29.57 FLORALA MEMORIAL HOSPITAL | 7 0.07 29.64 FLORENCE HOSPITAL AT ANTHEM, LLC | 11 0.11 29.75 FLOWERS HOSPITAL | 65 0.65 30.40 FORREST CITY MEDICAL CENTER | 21 0.21 30.61 FORT DEFIANCE INDIAN HOSPITAL | 16 0.16 30.77 GADSDEN REGIONAL MEDICAL CENTER | 61 0.61 31.38 GEORGE H. LANIER MEMORIAL HOSPITAL | 27 0.27 31.65 GEORGIANA MEDICAL CENTER | 11 0.11 31.76 GILBERT HOSPITAL | 20 0.20 31.96 GLENDALE MEM HOSPITAL & HLTH CENTER | 62 0.62 32.58 GREAT RIVER MEDICAL CENTER | 17 0.17 32.75 GREENE COUNTY HOSPITAL | 7 0.07 32.82 GROSSMONT HOSPITAL | 67 0.67 33.49 GROVE HILL MEMORIAL HOSPITAL | 12 0.12 33.61 HALE COUNTY HOSPITAL | 8 0.08 33.69 HARRIS HOSPITAL | 19 0.19 33.88 HAVASU REGIONAL MEDICAL CENTER | 48 0.48 34.36 HELEN KELLER MEMORIAL HOSPITAL | 45 0.45 34.81 HELENA REGIONAL MEDICAL CENTER | 16 0.16 34.97 HIGHLANDS MEDICAL CENTER | 27 0.27 35.24 HILL HOSPITAL OF SUMTER COUNTY | 8 0.08 35.32 HOLLYWOOD PRESBYTERIAN MEDICAL CENTER | 51 0.51 35.83 HOT SPRING COUNTY MEDICAL CENTER | 20 0.20 36.03 HUNTSVILLE HOSPITAL | 68 0.68 36.71 J PAUL JONES HOSPITAL | 8 0.08 36.79 JACK HUGHSTON MEMORIAL HOSPITAL | 26 0.26 37.05 JACKSON HOSPITAL & CLINIC INC | 58 0.58 37.63 JACKSON MEDICAL CENTER | 9 0.09 37.72 JACKSONVILLE MEDICAL CENTER | 19 0.19 37.91 JEFFERSON REGIONAL MEDICAL CENTER | 55 0.55 38.46 JOHN C LINCOLN DEER VALLEY HOSPITAL | 53 0.53 38.99 JOHN C LINCOLN NORTH MOUNTAIN HOSPITAL | 63 0.63 39.62 JOHNSON REGIONAL MEDICAL CENTER | 22 0.22 39.84 KAISER FOUNDATION HOSPITAL - SAN FRAN.. | 24 0.24 40.08 KAISER FOUNDATION HOSPITAL - SOUTH SA.. | 18 0.18 40.26 KAISER FOUNDATION HOSPITAL - WALNUT C.. | 27 0.27 40.53 KAISER FOUNDATION HOSPITAL AND REHAB .. | 27 0.27 40.80 KAISER FOUNDATION HOSPITAL OAKLAND/RI.. | 35 0.35 41.15 KAISER FOUNDATION HOSPITAL-SANTA CLARA | 33 0.33 41.48 KAWEAH DELTA MEDICAL CENTER | 62 0.62 42.10 KINGMAN REGIONAL MEDICAL CENTER | 49 0.49 42.59 L V STABLER MEMORIAL HOSPITAL | 18 0.18 42.77 LA PAZ REGIONAL HOSPITAL | 23 0.23 43.00 LAC/OLIVE VIEW-UCLA MEDICAL CENTER | 22 0.22 43.22 LAKE MARTIN COMMUNITY HOSPITAL | 12 0.12 43.34 LAKELAND COMMUNITY HOSPITAL | 19 0.19 43.53 LAWRENCE MEDICAL CENTER | 12 0.12 43.65 LOMPOC VALLEY MEDICAL CENTER | 27 0.27 43.92 MAD RIVER COMMUNITY HOSPITAL | 22 0.22 44.14 MAGNOLIA HOSPITAL | 17 0.17 44.31 MARIAN REGIONAL MEDICAL CENTER | 59 0.59 44.90 MARIAN REGIONAL MEDICAL CENTER, ARROY.. | 35 0.35 45.25 MARICOPA MEDICAL CENTER | 25 0.25 45.50 MARION REGIONAL MEDICAL CENTER | 16 0.16 45.66 MARSHALL MEDICAL CENTER SOUTH | 39 0.39 46.05 MARYVALE HOSPITAL | 23 0.23 46.28 MAT-SU REGIONAL MEDICAL CENTER | 39 0.39 46.67 MAYO CLINIC HOSPITAL | 69 0.69 47.36 MEDICAL CENTER BARBOUR | 18 0.18 47.54 MEDICAL CENTER ENTERPRISE | 25 0.25 47.79 MEDICAL CENTER SOUTH ARKANSAS | 46 0.46 48.25 MEDICAL WEST, AN AFFILIATE OF UAB HEA.. | 37 0.37 48.62 MENA REGIONAL HEALTH SYSTEM | 16 0.16 48.78 MERCY GENERAL HOSPITAL | 62 0.62 49.40 MERCY GILBERT MEDICAL CENTER | 53 0.53 49.93 MERCY HOSPITAL NORTHWEST ARKANSAS | 56 0.56 50.49 MIZELL MEMORIAL HOSPITAL | 26 0.26 50.75 MOBILE INFIRMARY | 66 0.66 51.41 MONROE COUNTY HOSPITAL | 16 0.16 51.57 MOUNTAIN VISTA MEDICAL CENTER, LP | 57 0.57 52.14 MT EDGECUMBE HOSPITAL | 17 0.17 52.31 MT GRAHAM REGIONAL MEDICAL CENTER | 21 0.21 52.52 NATIONAL PARK MEDICAL CENTER | 58 0.58 53.10 NEA BAPTIST MEMORIAL HOSPITAL | 54 0.54 53.64 NORTH ARKANSAS REGIONAL MEDICAL CENTER | 37 0.37 54.01 NORTH BALDWIN INFIRMARY | 24 0.24 54.25 NORTH METRO MEDICAL CENTER | 23 0.23 54.48 NORTHEAST ALABAMA REGIONAL MED CENTER | 60 0.60 55.08 NORTHWEST MEDICAL CENTER | 86 0.86 55.94 NW ARKANSAS HOSPITALS, LLC | 64 0.64 56.58 OAK VALLEY DISTRICT HOSPITAL | 21 0.21 56.79 OASIS HOSPITAL | 15 0.15 56.94 OJAI VALLEY COMMUNITY HOSPITAL | 17 0.17 57.11 ORO VALLEY HOSPITAL | 38 0.38 57.49 OROVILLE HOSPITAL | 41 0.41 57.90 OUACHITA COUNTY MEDICAL CENTER | 23 0.23 58.13 PACIFIC ALLIANCE MEDICAL CENTER | 30 0.30 58.43 PARADISE VALLEY HOSPITAL | 74 0.74 59.17 PARKVIEW COMMUNITY HOSPITAL MEDICAL C.. | 32 0.32 59.49 PARKWAY MEDICAL CENTER | 26 0.26 59.75 PAYSON REGIONAL MEDICAL CENTER | 33 0.33 60.08 PENINSULA MEDICAL CENTER | 55 0.55 60.63 PHOENIX BAPTIST HOSPITAL | 50 0.50 61.13 PHOENIX INDIAN MEDICAL CENTER | 11 0.11 61.24 PHYSICIANS' SPECIALTY HOSPITAL | 14 0.14 61.38 PICKENS COUNTY MEDICAL CENTER | 15 0.15 61.53 PRATTVILLE BAPTIST HOSPITAL | 20 0.20 61.73 PROVIDENCE ALASKA MEDICAL CENTER | 61 0.61 62.34 PROVIDENCE HOSPITAL | 62 0.62 62.96 PROVIDENCE LITTLE CO OF MARY MED CTR .. | 41 0.41 63.37 QUEEN OF THE VALLEY MEDICAL CENTER | 59 0.59 63.96 RIVERSIDE COMMUNITY HOSPITAL | 60 0.60 64.56 RIVERVIEW REGIONAL MEDICAL CENTER | 51 0.51 65.07 RUSSELL HOSPITAL | 36 0.36 65.43 RUSSELLVILLE HOSPITAL | 29 0.29 65.72 SAINT AGNES MEDICAL CENTER | 64 0.64 66.36 SAINT FRANCIS MEDICAL CENTER | 47 0.47 66.83 SALINE MEMORIAL HOSPITAL | 35 0.35 67.18 SAN ANTONIO COMMUNITY HOSPITAL | 53 0.53 67.71 SAN GORGONIO MEMORIAL HOSPITAL | 22 0.22 67.93 SANTA CLARA VALLEY MEDICAL CENTER | 56 0.56 68.49 SCOTTSDALE HEALTHCARE-OSBORN MEDICAL .. | 57 0.57 69.06 SCOTTSDALE HEALTHCARE-SHEA MEDICAL CE.. | 64 0.64 69.70 SCOTTSDALE HEALTHCARE-THOMPSON PEAK H.. | 45 0.45 70.15 SCRIPPS MERCY HOSPITAL | 66 0.66 70.81 SHARP MEMORIAL HOSPITAL | 66 0.66 71.47 SHELBY BAPTIST MEDICAL CENTER | 60 0.60 72.07 SHOALS HOSPITAL | 24 0.24 72.31 SIERRA VISTA REGIONAL HEALTH CENTER INC | 29 0.29 72.60 SILOAM SPRINGS REGIONAL HOSPITAL | 24 0.24 72.84 SONOMA VALLEY HOSPITAL | 26 0.26 73.10 SOUTH BALDWIN REGIONAL MEDICAL CENTER | 49 0.49 73.59 SOUTHEAST ALABAMA MEDICAL CENTER | 66 0.66 74.25 SPARKS REGIONAL MEDICAL CENTER | 63 0.63 74.88 SPRINGHILL MEDICAL CENTER | 57 0.57 75.45 ST BERNARDS MEDICAL CENTER | 60 0.60 76.05 ST EDWARD MERCY MEDICAL CENTER | 61 0.61 76.66 ST ELIZABETH COMMUNITY HOSPITAL | 25 0.25 76.91 ST HELENA HOSPITAL | 46 0.46 77.37 ST JOHNS REGIONAL MEDICAL CENTER | 56 0.56 77.93 ST JOSEPH HOSPITAL | 124 1.24 79.17 ST JOSEPH'S HOSPITAL AND MEDICAL CENTER | 61 0.61 79.78 ST JOSEPHS MEDICAL CENTER OF STOCKTON | 62 0.62 80.40 ST JOSEPHS MERCY HEALTH CENTER INC | 63 0.63 81.03 ST LUKES MEDICAL CENTER | 38 0.38 81.41 ST MARYS REGIONAL MEDICAL CENTER | 35 0.35 81.76 ST ROSE HOSPITAL | 42 0.42 82.18 ST VINCENT INFIRMARY MEDICAL CENTER | 67 0.67 82.85 ST VINCENT MEDICAL CENTER/NORTH | 32 0.32 83.17 ST VINCENT'S BIRMINGHAM | 68 0.68 83.85 ST VINCENT'S EAST | 59 0.59 84.44 ST VINCENT'S ST CLAIR | 11 0.11 84.55 ST VINCENTS BLOUNT | 17 0.17 84.72 STRINGFELLOW MEMORIAL HOSPITAL | 43 0.43 85.15 SUMMIT HEALTHCARE REGIONAL MEDICAL CE.. | 37 0.37 85.52 SUMMIT MEDICAL CENTER | 21 0.21 85.73 SUTTER AMADOR HOSPITAL | 28 0.28 86.01 SUTTER GENERAL HOSPITAL | 67 0.67 86.68 SUTTER SOLANO MEDICAL CENTER | 38 0.38 87.06 TEMPLE COMMUNITY HOSPITAL | 27 0.27 87.33 THE SURGICAL HOSPITAL OF PHOENIX | 10 0.10 87.43 THOMAS HOSPITAL | 56 0.56 87.99 TRINITY MEDICAL CENTER | 66 0.66 88.65 TROY REGIONAL MEDICAL CENTER | 23 0.23 88.88 TUBA CITY REGIONAL HEALTH CARE CORPOR.. | 21 0.21 89.09 TUCSON MEDICAL CENTER | 66 0.66 89.75 UAMS MEDICAL CENTER | 63 0.63 90.38 UNIV OF SOUTH ALABAMA MEDICAL CENTER | 41 0.41 90.79 UNIVERSITY OF ALABAMA HOSPITAL | 70 0.70 91.49 UNIVERSITY OF ARIZONA MEDICAL CTR- SO.. | 33 0.33 91.82 UNIVERSITY OF ARIZONA MEDICAL CTR-UNI.. | 65 0.65 92.47 UNIVERSITY OF CALIFORNIA SAN DIEGO ME.. | 66 0.66 93.13 VALLEY VIEW MEDICAL CENTER | 39 0.39 93.52 VAUGHAN REG MED CENTER PARKWAY CAMPUS | 39 0.39 93.91 VERDE VALLEY MEDICAL CENTER | 41 0.41 94.32 WALKER BAPTIST MEDICAL CENTER | 47 0.47 94.79 WASHINGTON REGIONAL MED CTR AT NORTH .. | 65 0.65 95.44 WEDOWEE HOSPITAL | 11 0.11 95.55 WEST VALLEY HOSPITAL | 47 0.47 96.02 WESTERN ARIZONA REGIONAL MEDICAL CTR | 52 0.52 96.54 WHITE COUNTY MEDICAL CENTER | 57 0.57 97.11 WHITE MEMORIAL MEDICAL CENTER | 56 0.56 97.67 WHITE RIVER MEDICAL CENTER | 44 0.44 98.11 WHITERIVER PHS INDIAN HOSPITAL | 10 0.10 98.21 WIREGRASS MEDICAL CENTER | 22 0.22 98.43 YAVAPAI REGIONAL MEDICAL CENTER | 62 0.62 99.05 YAVAPAI REGIONAL MEDICAL CENTER-EAST | 29 0.29 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 | 315 3.15 3.15 AL | 2,842 28.42 31.57 AR | 1,688 16.88 48.45 AZ | 2,537 25.37 73.82 CA | 2,618 26.18 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 | 131 1.31 1.31 39 | 133 1.33 2.64 190 | 250 2.50 5.14 191 | 252 2.52 7.66 192 | 249 2.49 10.15 193 | 248 2.48 12.63 219 | 95 0.95 13.58 220 | 99 0.99 14.57 221 | 73 0.73 15.30 224 | 80 0.80 16.10 225 | 90 0.90 17.00 226 | 100 1.00 18.00 227 | 113 1.13 19.13 235 | 93 0.93 20.06 236 | 99 0.99 21.05 237 | 140 1.40 22.45 243 | 155 1.55 24.00 244 | 161 1.61 25.61 247 | 138 1.38 26.99 280 | 227 2.27 29.26 281 | 226 2.26 31.52 282 | 226 2.26 33.78 291 | 251 2.51 36.29 292 | 253 2.53 38.82 293 | 252 2.52 41.34 313 | 245 2.45 43.79 328 | 137 1.37 45.16 329 | 218 2.18 47.34 330 | 220 2.20 49.54 331 | 194 1.94 51.48 353 | 120 1.20 52.68 354 | 166 1.66 54.34 355 | 168 1.68 56.02 414 | 117 1.17 57.19 417 | 193 1.93 59.12 418 | 217 2.17 61.29 419 | 217 2.17 63.46 459 | 83 0.83 64.29 460 | 121 1.21 65.50 461 | 15 0.15 65.65 462 | 79 0.79 66.44 466 | 94 0.94 67.38 467 | 154 1.54 68.92 468 | 148 1.48 70.40 469 | 175 1.75 72.15 470 | 204 2.04 74.19 471 | 74 0.74 74.93 472 | 110 1.10 76.03 473 | 115 1.15 77.18 477 | 70 0.70 77.88 478 | 118 1.18 79.06 479 | 70 0.70 79.76 490 | 115 1.15 80.91 491 | 125 1.25 82.16 507 | 32 0.32 82.48 508 | 36 0.36 82.84 515 | 100 1.00 83.84 637 | 215 2.15 85.99 656 | 97 0.97 86.96 657 | 118 1.18 88.14 658 | 99 0.99 89.13 659 | 92 0.92 90.05 668 | 105 1.05 91.10 673 | 141 1.41 92.51 674 | 128 1.28 93.79 675 | 48 0.48 94.27 713 | 123 1.23 95.50 714 | 130 1.30 96.80 743 | 185 1.85 98.65 748 | 135 1.35 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.. | 226 2.26 2.26 Acute myocardial infarction, discharg.. | 227 2.27 4.53 Acute myocardial infarction, discharg.. | 226 2.26 6.79 Back and neck proc exc spinal fusion .. | 115 1.15 7.94 Back and neck proc exc spinal fusion .. | 125 1.25 9.19 Bilateral or multiple major joint pro.. | 15 0.15 9.34 Bilateral or multiple major joint pro.. | 79 0.79 10.13 Biopsies of musculoskeletal system an.. | 118 1.18 11.31 Biopsies of musculoskeletal system an.. | 70 0.70 12.01 Biopsies of musculoskeletal system an.. | 70 0.70 12.71 Cardiac defib implant w cardiac cath .. | 80 0.80 13.51 Cardiac defib implant w cardiac cath .. | 90 0.90 14.41 Cardiac defibrillator implant w/o car.. | 100 1.00 15.41 Cardiac defibrillator implant w/o car.. | 113 1.13 16.54 Cardiac valve and oth maj cardiothora.. | 99 0.99 17.53 Cardiac valve and oth maj cardiothora.. | 95 0.95 18.48 Cardiac valve and oth maj cardiothora.. | 73 0.73 19.21 Cervical spinal fusion w CC | 110 1.10 20.31 Cervical spinal fusion w MCC | 74 0.74 21.05 Cervical spinal fusion w/o CC/MCC | 115 1.15 22.20 Chest Pain | 245 2.45 24.65 Cholecystectomy except by laparoscope.. | 117 1.17 25.82 Chronic obstructive pulmonary disease.. | 252 2.52 28.34 Chronic obstructive pulmonary disease.. | 250 2.50 30.84 Chronic obstructive pulmonary disease.. | 249 2.49 33.33 Coronary bypass w/o cardiac cath w MCC | 93 0.93 34.26 Coronary bypass w/o cardiac cath w/o .. | 99 0.99 35.25 Diabetes w MCC | 215 2.15 37.40 Extracranial procedures w CC | 131 1.31 38.71 Extracranial procedures w/o CC/MCC | 133 1.33 40.04 Female reproductive system reconstruc.. | 135 1.35 41.39 Heart failure and shock w CC | 253 2.53 43.92 Heart failure and shock w MCC | 251 2.51 46.43 Heart failure and shock w/o CC/MCC | 252 2.52 48.95 Hernia procedures except inguinal and.. | 166 1.66 50.61 Hernia procedures except inguinal and.. | 120 1.20 51.81 Hernia procedures except inguinal and.. | 168 1.68 53.49 Kidney and ureter procedures for neop.. | 118 1.18 54.67 Kidney and ureter procedures for neop.. | 97 0.97 55.64 Kidney and ureter procedures for neop.. | 99 0.99 56.63 Kidney and ureter procedures for non-.. | 92 0.92 57.55 Laparoscopic cholecystectomy w/o c.d... | 217 2.17 59.72 Laparoscopic cholecystectomy w/o c.d... | 193 1.93 61.65 Laparoscopic cholecystectomy w/o c.d... | 217 2.17 63.82 Major cardiovasc procedures w MCC or .. | 140 1.40 65.22 Major joint replacement or reattachme.. | 175 1.75 66.97 Major joint replacement or reattachme.. | 204 2.04 69.01 Major shoulder or elbow joint procedu.. | 32 0.32 69.33 Major shoulder or elbow joint procedu.. | 36 0.36 69.69 Major small and large bowel procedure.. | 220 2.20 71.89 Major small and large bowel procedure.. | 218 2.18 74.07 Major small and large bowel procedure.. | 194 1.94 76.01 Other kidney and urinary tract proced.. | 128 1.28 77.29 Other kidney and urinary tract proced.. | 141 1.41 78.70 Other kidney and urinary tract proced.. | 48 0.48 79.18 Other musculoskelet sys and conn tiss.. | 100 1.00 80.18 Perc cardiovasc proc w drug-eluting s.. | 138 1.38 81.56 Permanent cardiac pacemaker implant w.. | 155 1.55 83.11 Permanent cardiac pacemaker implant w.. | 161 1.61 84.72 Revision of hip or knee replacement w.. | 154 1.54 86.26 Revision of hip or knee replacement w.. | 94 0.94 87.20 Revision of hip or knee replacement w.. | 148 1.48 88.68 Simple pneumonia and pleurisy w MCC | 248 2.48 91.16 Spinal fusion except cervical w MCC | 83 0.83 91.99 Spinal fusion except cervical w/o MCC | 121 1.21 93.20 Stomach, esophageal duodenal proc w/o.. | 137 1.37 94.57 Transurethral procedures w MCC | 105 1.05 95.62 Transurethral prostatectomy w CC/MCC | 123 1.23 96.85 Transurethral prostatectomy w/o CC/MCC | 130 1.30 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,260 62.60 62.60 100 | 4 0.04 62.64 101 | 4 0.04 62.68 102 | 10 0.10 62.78 103 | 5 0.05 62.83 104 | 6 0.06 62.89 105 | 1 0.01 62.90 106 | 1 0.01 62.91 107 | 8 0.08 62.99 108 | 5 0.05 63.04 109 | 2 0.02 63.06 11 | 207 2.07 65.13 110 | 3 0.03 65.16 111 | 7 0.07 65.23 112 | 3 0.03 65.26 113 | 5 0.05 65.31 114 | 4 0.04 65.35 115 | 4 0.04 65.39 116 | 3 0.03 65.42 117 | 1 0.01 65.43 118 | 5 0.05 65.48 119 | 4 0.04 65.52 12 | 221 2.21 67.73 120 | 2 0.02 67.75 121 | 2 0.02 67.77 122 | 3 0.03 67.80 123 | 2 0.02 67.82 125 | 2 0.02 67.84 126 | 3 0.03 67.87 127 | 3 0.03 67.90 129 | 8 0.08 67.98 13 | 152 1.52 69.50 130 | 3 0.03 69.53 131 | 2 0.02 69.55 133 | 2 0.02 69.57 135 | 3 0.03 69.60 136 | 3 0.03 69.63 138 | 2 0.02 69.65 139 | 4 0.04 69.69 14 | 181 1.81 71.50 140 | 3 0.03 71.53 142 | 2 0.02 71.55 143 | 2 0.02 71.57 144 | 2 0.02 71.59 145 | 2 0.02 71.61 146 | 2 0.02 71.63 147 | 1 0.01 71.64 148 | 2 0.02 71.66 149 | 4 0.04 71.70 15 | 161 1.61 73.31 150 | 1 0.01 73.32 151 | 1 0.01 73.33 152 | 3 0.03 73.36 153 | 1 0.01 73.37 156 | 1 0.01 73.38 157 | 1 0.01 73.39 158 | 2 0.02 73.41 159 | 1 0.01 73.42 16 | 158 1.58 75.00 160 | 1 0.01 75.01 162 | 1 0.01 75.02 164 | 1 0.01 75.03 168 | 2 0.02 75.05 169 | 1 0.01 75.06 17 | 133 1.33 76.39 171 | 1 0.01 76.40 173 | 1 0.01 76.41 174 | 2 0.02 76.43 177 | 2 0.02 76.45 178 | 1 0.01 76.46 179 | 2 0.02 76.48 18 | 136 1.36 77.84 181 | 2 0.02 77.86 182 | 2 0.02 77.88 184 | 1 0.01 77.89 186 | 1 0.01 77.90 187 | 1 0.01 77.91 188 | 1 0.01 77.92 189 | 1 0.01 77.93 19 | 113 1.13 79.06 192 | 1 0.01 79.07 195 | 4 0.04 79.11 197 | 1 0.01 79.12 20 | 93 0.93 80.05 200 | 2 0.02 80.07 201 | 3 0.03 80.10 202 | 2 0.02 80.12 206 | 1 0.01 80.13 209 | 1 0.01 80.14 21 | 93 0.93 81.07 210 | 2 0.02 81.09 211 | 1 0.01 81.10 213 | 1 0.01 81.11 22 | 86 0.86 81.97 222 | 1 0.01 81.98 223 | 1 0.01 81.99 224 | 1 0.01 82.00 225 | 1 0.01 82.01 229 | 1 0.01 82.02 23 | 80 0.80 82.82 230 | 1 0.01 82.83 233 | 1 0.01 82.84 234 | 1 0.01 82.85 24 | 76 0.76 83.61 244 | 1 0.01 83.62 248 | 1 0.01 83.63 25 | 79 0.79 84.42 250 | 1 0.01 84.43 251 | 2 0.02 84.45 253 | 1 0.01 84.46 26 | 66 0.66 85.12 266 | 2 0.02 85.14 269 | 1 0.01 85.15 27 | 73 0.73 85.88 275 | 1 0.01 85.89 28 | 53 0.53 86.42 286 | 1 0.01 86.43 287 | 1 0.01 86.44 29 | 52 0.52 86.96 291 | 1 0.01 86.97 292 | 1 0.01 86.98 296 | 1 0.01 86.99 30 | 49 0.49 87.48 304 | 1 0.01 87.49 307 | 1 0.01 87.50 31 | 56 0.56 88.06 314 | 1 0.01 88.07 317 | 1 0.01 88.08 319 | 1 0.01 88.09 32 | 56 0.56 88.65 323 | 1 0.01 88.66 33 | 48 0.48 89.14 334 | 1 0.01 89.15 338 | 1 0.01 89.16 34 | 51 0.51 89.67 342 | 1 0.01 89.68 347 | 2 0.02 89.70 349 | 1 0.01 89.71 35 | 36 0.36 90.07 351 | 1 0.01 90.08 359 | 1 0.01 90.09 36 | 48 0.48 90.57 37 | 34 0.34 90.91 371 | 1 0.01 90.92 375 | 1 0.01 90.93 376 | 1 0.01 90.94 38 | 32 0.32 91.26 39 | 36 0.36 91.62 390 | 2 0.02 91.64 40 | 36 0.36 92.00 41 | 28 0.28 92.28 410 | 1 0.01 92.29 42 | 32 0.32 92.61 427 | 1 0.01 92.62 43 | 32 0.32 92.94 44 | 25 0.25 93.19 45 | 29 0.29 93.48 46 | 24 0.24 93.72 460 | 1 0.01 93.73 47 | 26 0.26 93.99 473 | 1 0.01 94.00 48 | 22 0.22 94.22 49 | 19 0.19 94.41 50 | 22 0.22 94.63 51 | 20 0.20 94.83 513 | 1 0.01 94.84 514 | 1 0.01 94.85 52 | 18 0.18 95.03 53 | 13 0.13 95.16 54 | 20 0.20 95.36 55 | 14 0.14 95.50 559 | 1 0.01 95.51 56 | 18 0.18 95.69 57 | 15 0.15 95.84 572 | 1 0.01 95.85 58 | 11 0.11 95.96 59 | 22 0.22 96.18 60 | 13 0.13 96.31 61 | 18 0.18 96.49 62 | 20 0.20 96.69 63 | 10 0.10 96.79 64 | 15 0.15 96.94 649 | 1 0.01 96.95 65 | 18 0.18 97.13 66 | 10 0.10 97.23 667 | 1 0.01 97.24 67 | 12 0.12 97.36 68 | 11 0.11 97.47 69 | 8 0.08 97.55 694 | 1 0.01 97.56 70 | 12 0.12 97.68 71 | 16 0.16 97.84 72 | 11 0.11 97.95 726 | 1 0.01 97.96 73 | 10 0.10 98.06 74 | 12 0.12 98.18 75 | 11 0.11 98.29 76 | 9 0.09 98.38 77 | 7 0.07 98.45 78 | 13 0.13 98.58 79 | 11 0.11 98.69 798 | 1 0.01 98.70 80 | 9 0.09 98.79 81 | 7 0.07 98.86 82 | 7 0.07 98.93 83 | 5 0.05 98.98 84 | 8 0.08 99.06 847 | 1 0.01 99.07 85 | 8 0.08 99.15 86 | 8 0.08 99.23 87 | 11 0.11 99.34 88 | 4 0.04 99.38 89 | 8 0.08 99.46 893 | 1 0.01 99.47 90 | 8 0.08 99.55 91 | 8 0.08 99.63 92 | 7 0.07 99.70 93 | 6 0.06 99.76 94 | 5 0.05 99.81 95 | 7 0.07 99.88 96 | 2 0.02 99.90 97 | 2 0.02 99.92 98 | 2 0.02 99.94 99 | 6 0.06 100.00 ------------+----------------------------------- Total | 10,000 100.00 by Jean Roth , jroth@nber.org , 16 Nov 2016