User:Andrew nyr/sandbox/chcoviddata
Appearance
state | hospital_name | address | city | total_beds_7_day_avg | all_adult_hospital_beds_7_day_avg | all_adult_hospital_inpatient_beds_7_day_avg | inpatient_beds_used_7_day_avg | all_adult_hospital_inpatient_bed_occupied_7_day_avg | total_adult_patients_hospitalized_confirmed_and_suspected_covid_7_day_avg | total_adult_patients_hospitalized_confirmed_covid_7_day_avg | total_pediatric_patients_hospitalized_confirmed_and_suspected_covid_7_day_avg | total_pediatric_patients_hospitalized_confirmed_covid_7_day_avg | inpatient_beds_7_day_avg | total_icu_beds_7_day_avg | total_staffed_adult_icu_beds_7_day_avg | icu_beds_used_7_day_avg | staffed_adult_icu_bed_occupancy_7_day_avg | staffed_icu_adult_patients_confirmed_and_suspected_covid_7_day_avg | staffed_icu_adult_patients_confirmed_covid_7_day_avg | total_patients_hospitalized_confirmed_influenza_7_day_avg | icu_patients_confirmed_influenza_7_day_avg |
AL | CHILDREN'S HOSPITAL OF ALABAMA | 1600 SEVENTH AVENUE SOUTH | BIRMINGHAM | 413 | 190 | 166 | 273.9 | 127.4 | 11.3 | 7.4 | 389 | 48 | 45.4 | ||||||||
AL | USA HEALTH CHILDREN'S & WOMEN'S HOSPITAL | 1700 CENTER STREET | MOBILE | 273 | 105 | 91 | 155.3 | 40.1 | 259 | 100 | 92.9 | ||||||||||
AZ | PHOENIX CHILDREN'S HOSPITAL | 1919 EAST THOMAS ROAD | PHOENIX | 375 | 211.7 | 7.1 | 7.1 | 375 | 120 | 63.7 | 38 | ||||||||||
AR | ARKANSAS CHILDREN'S HOSPITAL | 1 CHILDREN'S WAY, SLOT 301 | LITTLE ROCK | 374 | 169.9 | 14.1 | 6.3 | 329 | 183 | 92.6 | 7.1 | ||||||||||
AR | ARKANSAS CHILDREN'S NORTHWEST, INC | 2601 GENE GEORGE BOULEVARD | SPRINGDALE | 48 | 6.6 | 16 | |||||||||||||||
CA | UCSF BENIOFF CHILDREN'S HOSPITAL OAKLAND | 747 52ND STREET | OAKLAND | 149 | 67.1 | 149 | 59 | 34.3 | |||||||||||||
CA | VALLEY CHILDREN'S HOSPITAL | 9300 VALLEY CHILDRENS PLACE | MADERA | 241.3 | 169 | 6 | 5.7 | 191.1 | 107.1 | 89.3 | |||||||||||
CA | MEMORIAL CARE MILLER CHILDREN'S & WOMEN'S HOSP LB | 2801 ATLANTIC AVENUE | LONG BEACH | 262 | 94 | 94 | 116.3 | 27.3 | 262 | 125 | 57 | ||||||||||
CA | CHILDREN'S HOSP OF LOS ANGELES | 4650 SUNSET BLVD, MS 108 | LOS ANGELES | 392 | 277.9 | 18.1 | 16 | 331.1 | 99.7 | 93.1 | |||||||||||
CA | CHILDREN'S HOSPITAL OF ORANGE COUNTY | 1201 W LA VETA AVE | ORANGE | 334 | 174.7 | 11.6 | 7 | 334 | 146 | 79.7 | |||||||||||
CA | CHILDREN'S HOSPITAL AT MISSION | 27700 MEDICAL CENTER RD, 5TH FLOOR | MISSION VIEJO | 58.7 | 20.4 | 55.7 | 30 | 11 | |||||||||||||
CA | HEALTHBRIDGE CHILDREN'S HOSPITAL - ORANGE | 393 S TUSTIN STREET | ORANGE | 27 | 25.7 | 27 | |||||||||||||||
CA | SHRINERS HOSPITALS FOR CHILDREN NORTHERN CALIF | 2425 STOCKTON BOULEVARD | SACRAMENTO | 31 | 16.9 | 30 | 10 | 5 | |||||||||||||
CA | RADY CHILDREN'S HOSPITAL - SAN DIEGO | 3020 CHILDRENS WAY | SAN DIEGO | 531 | 74 | 243.3 | 4.4 | 457 | 192 | 93.6 | |||||||||||
CA | LUCILE SALTER PACKARD CHILDREN'S HSP AT STANFORD | 725 WELCH ROAD | PALO ALTO | 341 | 62 | 62 | 256 | 48.9 | 5.6 | 5.4 | 341 | 132 | 98.7 | ||||||||
CO | CHILDREN'S HOSPITAL COLORADO | 13123 E 16TH AVE | AURORA | 340 | 245.3 | 13 | 8.1 | 340 | 90 | 76.3 | |||||||||||
CO | CHILDREN'S HOSPITAL COLORADO - COLORADO SPRINGS | 4090 BRIARGATE PKWY | COLORADO SPRINGS | 89 | 52.4 | 4 | 89 | 15.1 | |||||||||||||
CT | CONNECTICUT CHILDRENS MEDICAL CENTER | 282 WASHINGTON STREET | HARTFORD | 183 | 115.4 | 5 | 183 | 90 | 59.3 | ||||||||||||
CT | YALE-NEW HAVEN HOSPITAL | 20 YORK ST | NEW HAVEN | 1643 | 1433 | 1370 | 1212.4 | 1068.7 | 237.7 | 225 | 4.7 | 4.1 | 1580 | 291.3 | 195.3 | 215.3 | 150.1 | 35.4 | 34.1 | ||
DE | ALFRED I DUPONT HOSPITAL FOR CHILDREN | 1600 ROCKLAND RD PO BOX 269 | WILMINGTON | 260 | 86.9 | 4.4 | 4.1 | 138 | 70 | 45 | |||||||||||
DC | Hospital for Sick Children Pediatric Center (AKA HSC Pediatric Center) | 1731 Bunker Hill Rd Ne | Washington | 66 | 24 | 50 | |||||||||||||||
DC | CHILDREN'S NATIONAL HOSPITAL | 111 MICHIGAN AVE, NW | WASHINGTON | 368 | 279 | 16.6 | 7.9 | 323 | 143 | 108.6 | |||||||||||
FL | NICKLAUS CHILDREN'S HOSPITAL | 3100 SW 62ND AVE | MIAMI | 309 | 127 | 4.7 | 4.3 | 141 | 106 | 75 | |||||||||||
FL | NEMOURS CHILDREN'S HOSPITAL | 6535 NEMOURS PKWY | ORLANDO | 130 | 66.7 | 130 | 38.9 | 33 | |||||||||||||
FL | JOHNS HOPKINS ALL CHILDREN'S HOSPITAL | 501 SIXTH AVENUE SOUTH | SAINT PETERSBURG | 259 | 129 | 259 | 50 | 30.3 | |||||||||||||
GA | CHILDREN'S HEALTHCARE OF ATLANTA AT EGLESTON | 1405 CLIFTON ROAD, NE | ATLANTA | 362 | 17.4 | 4.9 | 305 | 129 | 93.1 | ||||||||||||
GA | CHILDREN'S HEALTHCARE OF ATLANTA AT SCOTTISH RITE | 1001 JOHNSON FERRY ROAD | ATLANTA | 394 | 22.9 | 5.1 | 329 | 102 | 86 | ||||||||||||
HI | SHRINERS HOSPITAL FOR CHILDREN | 1310 PUNAHOU STREET | HONOLULU | 24 | 6 | ||||||||||||||||
HI | KAPIOLANI MEDICAL CENTER FOR WOMEN & CHILDREN | 1319 PUNAHOU STREET | HONOLULU | 277 | 99 | 96 | 136.4 | 50.1 | 253 | 97 | 62 | ||||||||||
IL | ANN & ROBERT H LURIE CHILDRENS HOSPITAL OF CHICAGO | 225 E CHICAGO AVE, BOX 140 | CHICAGO | 364 | 206 | 18 | 5 | 344 | 104 | 57.7 | |||||||||||
IL | LARABIDA CHILDRENS HOSPITAL I | E 65TH ST AT LAKE MICHIGAN | CHICAGO | 30 | 26.4 | 30 | |||||||||||||||
IL | SHRINERS HOSPITAL FOR CHILDREN | 2211 NORTH OAK PARK AVE | CHICAGO | 14 | 10 | 4 | |||||||||||||||
KS | CHILDREN'S MERCY HOSPITAL KANSAS | 5808 W 110TH STREET | OVERLAND PARK | 28 | 8 | ||||||||||||||||
LA | SHRINERS HOSPITALS FOR CHILDREN | 3100 SAMFORD AVENUE | SHREVEPORT | 48 | 38.7 | 48 | |||||||||||||||
LA | CHILDRENS HOSPITAL | 200 HENRY CLAY AVE | NEW ORLEANS | 186 | 88 | 186 | 75 | 38.9 | |||||||||||||
MA | SHRINERS' HOSPITAL FOR CHILDREN (THE) | 516 CAREW STREET | SPRINGFIELD | 10 | 10 | ||||||||||||||||
MA | BOSTON CHILDREN'S HOSPITAL | 300 LONGWOOD AVENUE | BOSTON | 478 | 315.4 | 5 | 426 | 107 | 91 | ||||||||||||
MA | FRANCISCAN CHILDREN'S HOSPITAL & REHAB CENTER | 30 WARREN STREET | BRIGHTON | 81 | 60.1 | 5 | 81 | ||||||||||||||
MA | SHRINERS' HOSPITAL FOR CHILDREN - BOSTON, THE | 51 BLOSSOM STREET | BOSTON | 29.4 | 29.4 | ||||||||||||||||
MI | CHILDREN'S HOSPITAL OF MICHIGAN | 3901 BEAUBIEN STREET | DETROIT | 235.4 | 152 | 5.9 | 5.4 | 172.1 | 87 | 72.9 | |||||||||||
MN | CHILDREN'S HOSPITALS & CLINICS OF MN | 2525 CHICAGO AVENUE SOUTH | MINNEAPOLIS | 439 | 244.4 | 12.6 | 12.6 | 371 | 182 | 113 | |||||||||||
MN | GILLETTE CHILDRENS SPECIALTY HOSPITAL | 200 UNIVERSITY AVENUE EAST | SAINT PAUL | 83 | 22.4 | 60 | 4.4 | ||||||||||||||
MO | CHILDRENS MERCY HOSPITAL | 2401 GILLHAM ROAD | KANSAS CITY | 301.7 | 5 | 5 | 250.3 | 13.6 | 8.4 | 262.3 | 121.1 | 116.1 | |||||||||
MO | RANKEN JORDAN PEDIATRIC BRIDGE HOSPITAL | 11365 DORSETT ROAD | MARYLAND HEIGHTS | 60 | 41.3 | 46 | |||||||||||||||
MO | SHRINERS HOSPITALS FOR CHILDREN | 4400 CLAYTON AVE | SAINT LOUIS | ||||||||||||||||||
MO | ST LOUIS CHILDRENS HOSPITAL | ONE CHILDRENS PLACE | SAINT LOUIS | 417.9 | 243 | 8.6 | 6.7 | 370 | 187 | 122.3 | |||||||||||
NE | BOYS TOWN NATIONAL RESEARCH HOSPITAL | 555 NORTH 30TH ST | OMAHA | 44 | 12.1 | 27 | 6 | ||||||||||||||
NE | CHILDREN'S HOSPITAL & MEDICAL CENTER | 8200 DODGE ST | OMAHA | 147 | 147 | 111.7 | 144 | 72 | 59.4 | ||||||||||||
NJ | WEISMAN CHILDRENS REHABILITATION HOSPITAL | 92 BRICK ROAD, 3RD FLOOR | MARLTON | 18 | 8.9 | 18 | |||||||||||||||
NJ | CHILDREN'S SPECIALIZED HOSPITAL | 200 SOMERSET STREET | NEW BRUNSWICK | 68 | 49.7 | 68 | |||||||||||||||
NY | John R Oishei Childrens Hospital | 818 Ellicott St | Buffalo | 289 | 71 | 71 | 147 | 31.1 | 4 | 265 | 118 | 55.3 | |||||||||
NY | BLYTHEDALE CHILDREN'S HOSPITAL | 95 BRADHURST AVENUE | VALHALLA | 85 | 76.9 | 85 | |||||||||||||||
OH | CLEVELAND CLINIC CHILDREN'S HOSPITAL FOR REHAB | 2801 MARTIN LUTHER KING, JR DRIVE | CLEVELAND | 25 | 11.4 | 25 | |||||||||||||||
OH | RAINBOW BABIES AND CHILDRENS HOSPITAL | 11100 EUCLID AVENUE | CLEVELAND | 170.9 | 6 | 6 | 73.7 | 152.9 | 28.6 | 15.4 | |||||||||||
OH | NATIONWIDE CHILDREN'S HOSPITAL | 700 CHILDREN'S DRIVE | COLUMBUS | 745 | 315.4 | 17 | 13 | 591 | 206 | 148.3 | |||||||||||
OH | CINCINNATI CHILDREN'S HOSPITAL MEDICAL CENTER | 3333 BURNET AVENUE | CINCINNATI | 579 | 260 | 8 | 424 | 69 | 45.9 | ||||||||||||
OH | SHRINERS HOSPITALS FOR CHILDREN - CINCINNATI | 3229 BURNETT AVENUE | CINCINNATI | 4 | 4 | ||||||||||||||||
OH | DAYTON CHILDRENS HOSPITAL | 1 CHILDRENS PLZ | DAYTON | 156 | 82.9 | 9.4 | 156 | 58 | 38.3 | ||||||||||||
OH | AKRON CHILDREN'S HOSPITAL | 1 PERKINS SQUARE | AKRON | 552 | 18 | 18 | 213.4 | 15.9 | 396 | 187 | 107.7 | ||||||||||
OK | J D MCCARTY CENTER FOR CHILDREN | 2002 EAST ROBINSON | NORMAN | 23 | 23 | 23 | |||||||||||||||
OR | SHRINERS HOSPITAL FOR CHILDREN-PORTLAND | 3101 SW SAM JACKSON PARK ROAD | PORTLAND | 12 | 12 | ||||||||||||||||
PA | CHILDREN'S HOME OF PITTSBURGH | 5324 PENN AVENUE | PITTSBURGH | 30 | 11.7 | 30 | |||||||||||||||
PA | UPMC CHILDREN'S HOSPITAL OF PITTSBURGH | ONE CHILDREN'S HOSPITAL DRIVE | PITTSBURGH | 369 | 200.7 | 4.6 | 4.4 | 313 | 124 | 89.3 | |||||||||||
PA | SHRINERS HOSPITALS FOR CHILDREN - PHILADELPHIA | 3551 N BROAD STREET | PHILADELPHIA | 39 | 11.4 | 34 | 5 | ||||||||||||||
PA | ST CHRISTOPHER'S HOSPITAL FOR CHILDREN | 160 EAST ERIE AVE | PHILADELPHIA | 188 | 71.4 | 5.6 | 82.7 | 38.1 | 31 | ||||||||||||
PA | CHILDREN'S HOSPITAL OF PHILADELPHIA | 34TH ST & CIVIC CENTER BLVD | PHILADELPHIA | 752 | 468.6 | 13.4 | 7.6 | 639 | 229 | 202.6 | |||||||||||
SC | SHRINERS HOSPITALS FOR CHILDREN | 950 WEST FARIS ROAD | GREENVILLE | 16 | 16 | ||||||||||||||||
TN | EAST TENNESSEE CHILDRENS HOSPITAL | 2018 CLINCH AVE SW | KNOXVILLE | 191 | 39 | 96.9 | 5.1 | 4.7 | 152 | 73 | 53.3 | ||||||||||
TN | ST JUDE CHILDRENS RESEARCH HOSPITAL | 262 DANNY THOMAS PLACE | MEMPHIS | 85 | 12 | 9 | 53.1 | 5.4 | 82 | 8 | |||||||||||
TX | CHILDREN'S HOSPITAL OF SAN ANTONIO | 333 N SANTA ROSA ST | SAN ANTONIO | 229.1 | 119 | 119 | 96 | 4.9 | 4 | 229.1 | 16.3 | 13.6 | |||||||||
TX | CHILDRENS MEDICAL CENTER PLANO | 7601 PRESTON ROAD | PLANO | 72 | 30 | 20 | 35.1 | 62 | 5.9 | ||||||||||||
TX | OUR CHILDRENS HOUSE | 8 PRESTIGE CIRCLE 101 | ALLEN | 23.6 | 5 | 5 | 17.3 | 23.6 | |||||||||||||
TX | TEXAS SCOTTISH RITE HOSPITAL FOR CHILDREN | 2222 WELBORN STREET | DALLAS | 52 | 9.4 | 52 | |||||||||||||||
TX | CHILDRENS MEDICAL CTR OF DALLAS | 1935 MEDICAL DISTRICT DRIVE | DALLAS | 313.6 | 55 | 35 | 245.7 | 9 | 8.6 | 293.6 | 50.4 | 42.7 | |||||||||
TX | EL PASO CHILDREN'S HOSPITAL | 4845 ALAMEDA AVENUE | EL PASO | 50 | 16 | 18.3 | 4 | 37 | 19.1 | 11.7 | |||||||||||
TX | SHRINERS HOSPITALS FOR CHILDREN | 815 MARKET STREET | GALVESTON | 24.7 | 13.7 | 13.7 | 23.4 | 13.7 | 24.7 | 15 | 13.7 | ||||||||||
TX | TEXAS CHILDRENS HOSP | 6621 FANNIN STREET | HOUSTON | 687.1 | 198.3 | 127.9 | 443.6 | 47 | 19.9 | 8.7 | 28.4 | 7.6 | 616.7 | 208 | 39.6 | 155.4 | 39.6 | 6.9 | 4.7 | ||
TX | SHRINERS HOSPITALS FOR CHILDREN | 6977 MAIN STREET | HOUSTON | ||||||||||||||||||
TX | HEALTHBRIDGE CHILDRENS'S HOSPITAL OF HOUSTON | 2929 WOODLAND PARK DRIVE | HOUSTON | 57 | 33.9 | 57 | |||||||||||||||
TX | COVENANT CHILDRENS HOSPITAL | 4015 22ND PLACE | LUBBOCK | 171.7 | 86.4 | 74.3 | 87.1 | 34 | 159.6 | 18.4 | 6 | ||||||||||
TX | DRISCOLL CHILDRENS HOSPITAL | 3533 S ALAMEDA BOX 6530 | CORPUS CHRISTI | 122 | 32 | 12 | 55.6 | 102 | 22 | 11.7 | |||||||||||
TX | COOK CHILDRENS MEDICAL CENTER | 801 SEVENTH AVENUE | FORT WORTH | 305.1 | 50.7 | 19.3 | 243.4 | 11.4 | 11.4 | 273.7 | 20.7 | 15.1 | |||||||||
TX | DELL CHILDREN'S MEDICAL CENTER OF CENTRAL TEXAS | 4900 MUELLER BLVD | AUSTIN | 153.4 | 15.4 | 118.9 | 140.9 | 33.3 | 30.4 | ||||||||||||
UT | SHRINERS HOSPITALS FOR CHILDREN - SALT LAKE CITY | 1275 EAST FAIRFAX ROAD | SALT LAKE CITY | 12 | 4.6 | 12 | |||||||||||||||
UT | PRIMARY CHILDRENS HOSPITAL | 100 NORTH MARIO CAPECCHI DRIVE | SALT LAKE CITY | 299 | 116.9 | 6.7 | 236 | 101 | 53 | ||||||||||||
VA | CHILDRENS HOSPITAL OF THE KINGS DAUGHTERS INC | 601 CHILDREN'S LANE | NORFOLK | 182 | 122.6 | 181 | 95 | 71 | |||||||||||||
VA | CHILDREN'S HOSP OF RICHMOND OF THE VCU HEALTH SYS | 2924 BROOK ROAD | RICHMOND | 34 | 28 | 34 | |||||||||||||||
WA | SEATTLE CHILDREN'S HOSPITAL | 4800 SAND POINT WAY NE, PO BOX C-5371 | SEATTLE | 433 | 258.7 | 7.1 | 5.4 | 406 | 90 | 66.6 | |||||||||||
WA | MARY BRIDGE CHILDREN'S HOSPITAL | 317 MARTIN LUTHER KING JR W BOX 5299 | TACOMA | 229.9 | 81.1 | 42.9 | 43.7 | 21 | 229.9 | 23.6 | 9.9 | ||||||||||
WA | SHRINERS HOSPITAL FOR CHILDREN | 911 WEST 5TH AVENUE | SPOKANE | 30 | 30 | ||||||||||||||||
WI | CHILDRENS HOSPITAL OF WISCONSIN | 9000 W WISCONSIN AVE | MILWAUKEE | 226 | 123.9 | 7 | 226 | 72 | 51.6 | ||||||||||||
WI | CHILDRENS HOSPITAL OF WISCONSIN FOX VALLEY | 130 SECOND ST | NEENAH | 42 | 26 | 12 | |||||||||||||||
PR | Puerto Rico Womens and Children Hospital (FKA Puerto Rico Childrens Hospital) | State Rd # 2 Km 117 Interior | Bayamon | 140 | 34.1 | 8 | 127 | 15 | 5.9 | ||||||||||||
PR | UNIVERSITY PEDIATRIC HOSPITAL | PUERTO RICO MEDICAL CENTER IN RIO PIEDRAS | SAN JUAN | 215 | 79.8 | 109 | 52 | 41.2 |