User:Andrew nyr/sandbox/chcoviddata

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