hhs-hospital-icu-totals
Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README
- hospital
- The name of the hospital
- ccn
- The unique indentifier of the hospital.
- week
- The week for which hospital data were reported in ISO 8601 format.
- county
- The county where the hospitals is located.
- fips
- The FIPS code given to the county by the federal government. Can be used to merge with other data sources.
- region
- The region of the state where the hospital is located.
- covid_icu_patients_total
- The daily average of COVID-19 patients in the adult ICU at the hospital over the past seven days.
- available_adult_icu_beds_total
- The daily average of available adult ICU beds at the hospital over the past seven days.
- occupied_adult_icu_beds_total
- The daily average of occupied adult ICU beds at the hospital over the past seven days.
- staffed_adult_icu_beds_total
- The daily average of staffed adult ICU beds at the hospital over the past seven days.
- occupied_adult_icu_beds_percent
- The daily average of occupied adult ICU beds over the past seven days, measured as a percentage of the hospital's total.
- icu_patients_with_covid_percent
- The daily average of of adult ICU patients with COVID-19 over the past seven days, measured as a percentage of the hospital's total.
306 rows where "week" is on date 2020-12-04
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: region, week (date)
Link | rowid ▼ | hospital | ccn | week | county | fips | region | covid_icu_patients_total | available_adult_icu_beds_total | occupied_adult_icu_beds_total | staffed_adult_icu_beds_total | occupied_adult_icu_beds_percent | icu_patients_with_covid_percent |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
32438 | 32438 | Adventist Health Bakersfield | 50455 | 2020-12-04 | Kern | 29 | San Joaquin Valley | 14.142857142857142 | 5.428571428571431 | 25.142857142857142 | 30.571428571428573 | 0.822429906542056 | 0.5625 |
32439 | 32439 | Adventist Health Clearlake | 51317 | 2020-12-04 | Lake | 33 | Northern California | 0.0 | 0.0 | 4.0 | 4.0 | 1.0 | 0.0 |
32440 | 32440 | Adventist Health Delano | 50608 | 2020-12-04 | Kern | 29 | San Joaquin Valley | 5.142857142857143 | 1.1428571428571423 | 6.428571428571429 | 7.571428571428571 | 0.8490566037735849 | 0.8 |
32441 | 32441 | Adventist Health Hanford | 50121 | 2020-12-04 | Kings | 31 | San Joaquin Valley | 7.714285714285714 | 5.428571428571431 | 15.142857142857142 | 20.571428571428573 | 0.736111111111111 | 0.5094339622641509 |
32442 | 32442 | Adventist Health Howard Memorial | 51310 | 2020-12-04 | Mendocino | 45 | Northern California | 0.0 | 1.5714285714285716 | 2.4285714285714284 | 4.0 | 0.6071428571428571 | 0.0 |
32443 | 32443 | Adventist Health Lodi Memorial | 50336 | 2020-12-04 | San Joaquin | 77 | San Joaquin Valley | 6.428571428571429 | 3.857142857142856 | 8.857142857142858 | 12.714285714285714 | 0.6966292134831461 | 0.7258064516129032 |
32444 | 32444 | Adventist Health Mendocino Coast | 51325 | 2020-12-04 | Mendocino | 45 | Northern California | 0.0 | 3.2857142857142856 | 0.7142857142857143 | 4.0 | 0.1785714285714285 | 0.0 |
32445 | 32445 | Adventist Health Simi Valley | 50236 | 2020-12-04 | Ventura | 111 | Southern California | 13.142857142857142 | 4.714285714285715 | 19.142857142857142 | 23.857142857142858 | 0.8023952095808383 | 0.6865671641791045 |
32446 | 32446 | Adventist Health Sonora | 50335 | 2020-12-04 | Tuolumne | 109 | San Joaquin Valley | 0.0 | 1.8571428571428568 | 4.142857142857143 | 6.0 | 0.6904761904761906 | 0.0 |
32447 | 32447 | Adventist Health St. Helena | 50013 | 2020-12-04 | Napa | 55 | Bay Area | 0.0 | 4.0 | 1.1428571428571428 | 5.142857142857143 | 0.2222222222222221 | 0.0 |
32448 | 32448 | Adventist Health Tehachapi Valley | 51301 | 2020-12-04 | Kern | 29 | San Joaquin Valley | 2.0 | 1.7142857142857144 | 2.2857142857142856 | 4.0 | 0.5714285714285714 | 0.875 |
32449 | 32449 | Adventist Health Tulare | 50784 | 2020-12-04 | Tulare | 107 | San Joaquin Valley | 0.0 | 1.1428571428571428 | 2.857142857142857 | 4.0 | 0.7142857142857143 | 0.0 |
32450 | 32450 | Adventist Health Ukiah Valley | 50301 | 2020-12-04 | Mendocino | 45 | Northern California | 1.7142857142857142 | 2.2857142857142856 | 4.571428571428571 | 6.857142857142857 | 0.6666666666666666 | 0.375 |
32451 | 32451 | Adventist Health and Rideout | 50133 | 2020-12-04 | Yuba | 115 | Greater Sacramento | 8.714285714285714 | 5.857142857142858 | 18.142857142857142 | 24.0 | 0.7559523809523809 | 0.4803149606299212 |
32452 | 32452 | Ahmc Anaheim Regional Medical Center | 50226 | 2020-12-04 | Orange | 59 | Southern California | 9.0 | 0.1428571428571423 | 19.285714285714285 | 19.428571428571427 | 0.9926470588235294 | 0.4666666666666667 |
32453 | 32453 | Ahmc Seton Medical Center | 50289 | 2020-12-04 | San Mateo | 81 | Bay Area | 4.0 | 2.7142857142857157 | 9.714285714285714 | 12.428571428571429 | 0.7816091954022988 | 0.411764705882353 |
32454 | 32454 | Alameda Hospital | 50211 | 2020-12-04 | Alameda | 1 | Bay Area | 1.2857142857142858 | 4.714285714285714 | 3.2857142857142856 | 8.0 | 0.4107142857142857 | 0.391304347826087 |
32455 | 32455 | Alhambra Hospital Medical Center | 50281 | 2020-12-04 | Los Angeles | 37 | Southern California | 6.571428571428571 | 1.0 | 10.428571428571429 | 11.428571428571429 | 0.9125 | 0.6301369863013698 |
32456 | 32456 | Alta Bates Summit Medical Center | 50043 | 2020-12-04 | Alameda | 1 | Bay Area | 6.857142857142857 | 19.0 | 17.0 | 36.0 | 0.4722222222222222 | 0.4033613445378151 |
32457 | 32457 | Alta Bates Summit Medical Center - Alta Bates Camp | 50305 | 2020-12-04 | Alameda | 1 | Bay Area | 1.7142857142857142 | 17.714285714285715 | 12.285714285714286 | 30.0 | 0.4095238095238095 | 0.1395348837209302 |
32458 | 32458 | Alvarado Hospital Medical Center | 50757 | 2020-12-04 | San Diego | 73 | Southern California | 5.285714285714286 | 3.7142857142857135 | 9.857142857142858 | 13.571428571428571 | 0.7263157894736842 | 0.536231884057971 |
32459 | 32459 | Anaheim Global Medical Center | 50744 | 2020-12-04 | Orange | 59 | Southern California | 11.0 | 8.857142857142858 | 13.142857142857142 | 22.0 | 0.5974025974025974 | 0.8369565217391305 |
32460 | 32460 | Antelope Valley Hospital | 50056 | 2020-12-04 | Los Angeles | 37 | Southern California | 14.571428571428571 | 1.7142857142857153 | 43.0 | 44.71428571428572 | 0.9616613418530352 | 0.3388704318936877 |
32461 | 32461 | Arrowhead Regional Medical Center | 50245 | 2020-12-04 | San Bernardino | 71 | Southern California | 23.857142857142858 | 5.428571428571431 | 33.857142857142854 | 39.285714285714285 | 0.8618181818181818 | 0.7046413502109705 |
32462 | 32462 | Bakersfield Heart Hospital | 50724 | 2020-12-04 | Kern | 29 | San Joaquin Valley | 0.0 | 2.428571428571429 | 7.571428571428571 | 10.0 | 0.7571428571428571 | 0.0 |
32463 | 32463 | Bakersfield Memorial Hospital | 50036 | 2020-12-04 | Kern | 29 | San Joaquin Valley | 6.0 | 3.4285714285714306 | 26.285714285714285 | 29.714285714285715 | 0.8846153846153846 | 0.2282608695652174 |
32464 | 32464 | Barlow Respiratory Hospital | 52031 | 2020-12-04 | Los Angeles | 37 | Southern California | 0.0 | 3.4285714285714284 | 2.571428571428572 | 6.0 | 0.4285714285714286 | 0.0 |
32465 | 32465 | Barstow Community Hospital | 50298 | 2020-12-04 | San Bernardino | 71 | Southern California | 12.714285714285714 | 0.0 | 10.0 | 10.0 | 1.0 | 1.2714285714285714 |
32466 | 32466 | Barton Memorial Hospital | 50352 | 2020-12-04 | El Dorado | 17 | Greater Sacramento | 4.0 | 3.8571428571428568 | 4.142857142857143 | 8.0 | 0.5178571428571429 | 0.9655172413793104 |
32467 | 32467 | Beverly Hospital | 50350 | 2020-12-04 | Los Angeles | 37 | Southern California | 14.0 | 1.7142857142857153 | 22.857142857142858 | 24.571428571428573 | 0.9302325581395348 | 0.6124999999999999 |
32468 | 32468 | California Hospital Medical Center LA | 50149 | 2020-12-04 | Los Angeles | 37 | Southern California | 14.428571428571429 | 3.571428571428573 | 26.428571428571427 | 30.0 | 0.8809523809523809 | 0.545945945945946 |
32469 | 32469 | California Pacific Medical Center - Mission Bernal | 50055 | 2020-12-04 | San Francisco | 75 | Bay Area | 5.571428571428571 | 1.1428571428571423 | 8.857142857142858 | 10.0 | 0.8857142857142858 | 0.629032258064516 |
32470 | 32470 | California Pacific Medical Center- Van Ness Campus | 50047 | 2020-12-04 | San Francisco | 75 | Bay Area | 1.8571428571428568 | 4.857142857142858 | 31.142857142857142 | 36.0 | 0.8650793650793651 | 0.0596330275229357 |
32471 | 32471 | California Pacific Medical Ctr-davies Campus Hosp | 50008 | 2020-12-04 | San Francisco | 75 | Bay Area | 0.0 | 2.1428571428571432 | 5.857142857142857 | 8.0 | 0.7321428571428571 | 0.0 |
32472 | 32472 | Casa Colina Hospital | 50782 | 2020-12-04 | Los Angeles | 37 | Southern California | 0.0 | 3.4285714285714284 | 2.571428571428572 | 6.0 | 0.4285714285714286 | 0.0 |
32473 | 32473 | Cedars-Sinai Marina Del Rey Hospital | 50740 | 2020-12-04 | Los Angeles | 37 | Southern California | 4.428571428571429 | 4.571428571428571 | 11.428571428571429 | 16.0 | 0.7142857142857143 | 0.3875 |
32474 | 32474 | Cedars-Sinai Medical Center | 50625 | 2020-12-04 | Los Angeles | 37 | Southern California | 26.428571428571427 | 2.5714285714285694 | 105.42857142857144 | 108.0 | 0.9761904761904762 | 0.2506775067750677 |
32475 | 32475 | Centinela Hospital Medical Center | 50739 | 2020-12-04 | Los Angeles | 37 | Southern California | 24.714285714285715 | 5.0 | 36.0 | 41.0 | 0.8780487804878049 | 0.6865079365079365 |
32476 | 32476 | Chapman Global Medical Center | 50745 | 2020-12-04 | Orange | 59 | Southern California | 3.142857142857143 | 5.142857142857143 | 6.857142857142857 | 12.0 | 0.5714285714285714 | 0.4583333333333333 |
32477 | 32477 | Chinese Hospital | 50407 | 2020-12-04 | San Francisco | 75 | Bay Area | 0.0 | 2.4285714285714284 | 3.571428571428572 | 6.0 | 0.5952380952380952 | 0.0 |
32478 | 32478 | Chino Valley Medical Center | 50586 | 2020-12-04 | San Bernardino | 71 | Southern California | 4.857142857142857 | 0.8571428571428559 | 8.857142857142858 | 9.714285714285714 | 0.911764705882353 | 0.5483870967741935 |
32479 | 32479 | City of Hope Helford Clinical Research Hospital | 50146 | 2020-12-04 | Los Angeles | 37 | Southern California | 2.0 | 6.571428571428571 | 11.428571428571429 | 18.0 | 0.6349206349206349 | 0.175 |
32480 | 32480 | Clovis Community Medical Center | 50492 | 2020-12-04 | Fresno | 19 | San Joaquin Valley | 16.285714285714285 | 2.714285714285712 | 31.571428571428573 | 34.285714285714285 | 0.9208333333333334 | 0.5158371040723981 |
32481 | 32481 | Coast Plaza Hospital | 50771 | 2020-12-04 | Los Angeles | 37 | Southern California | 3.0 | 0.1428571428571432 | 7.0 | 7.142857142857143 | 0.98 | 0.4285714285714285 |
32482 | 32482 | College Medical Center | 50776 | 2020-12-04 | Los Angeles | 37 | Southern California | 2.857142857142857 | 0.5714285714285712 | 7.428571428571429 | 8.0 | 0.9285714285714286 | 0.3846153846153846 |
32483 | 32483 | Colusa Medical Center | 50783 | 2020-12-04 | Colusa | 11 | Greater Sacramento | 0.0 | 0.7142857142857143 | 0.0 | 0.7142857142857143 | 0.0 | |
32484 | 32484 | Community Hospital of Huntington Park | 50091 | 2020-12-04 | Los Angeles | 37 | Southern California | 2.857142857142857 | 0.0 | 6.714285714285714 | 6.714285714285714 | 1.0 | 0.425531914893617 |
32485 | 32485 | Community Hospital of San Bernardino | 50089 | 2020-12-04 | San Bernardino | 71 | Southern California | 13.571428571428571 | 2.0 | 19.0 | 21.0 | 0.9047619047619048 | 0.7142857142857143 |
32486 | 32486 | Community Hospital of the Monterey Peninsula | 50145 | 2020-12-04 | Monterey | 53 | Bay Area | 6.285714285714286 | 3.571428571428573 | 16.428571428571427 | 20.0 | 0.8214285714285714 | 0.3826086956521739 |
32487 | 32487 | Community Memorial Hospital San Buenaventura | 50394 | 2020-12-04 | Ventura | 111 | Southern California | 10.714285714285714 | 1.0 | 24.0 | 25.0 | 0.96 | 0.4464285714285714 |
32488 | 32488 | Community Regional Medical Center | 50060 | 2020-12-04 | Fresno | 19 | San Joaquin Valley | 33.285714285714285 | 1.2857142857142776 | 85.85714285714286 | 87.14285714285714 | 0.9852459016393444 | 0.3876871880199667 |
32489 | 32489 | Contra Costa Regional Medical Center | 50276 | 2020-12-04 | Contra Costa | 13 | Bay Area | 4.428571428571429 | 4.571428571428571 | 13.428571428571429 | 18.0 | 0.746031746031746 | 0.3297872340425532 |
32490 | 32490 | Corona Regional Medical Center | 50329 | 2020-12-04 | Riverside | 65 | Southern California | 24.0 | 3.5714285714285694 | 30.0 | 33.57142857142857 | 0.8936170212765958 | 0.8 |
32491 | 32491 | Dameron Hospital | 50122 | 2020-12-04 | San Joaquin | 77 | San Joaquin Valley | 4.714285714285714 | 1.0 | 14.571428571428571 | 15.571428571428571 | 0.9357798165137616 | 0.3235294117647059 |
32492 | 32492 | Desert Regional Medical Center | 50243 | 2020-12-04 | Riverside | 65 | Southern California | 10.428571428571429 | 0.8571428571428541 | 33.0 | 33.857142857142854 | 0.9746835443037976 | 0.316017316017316 |
32493 | 32493 | Desert Valley Hospital | 50709 | 2020-12-04 | San Bernardino | 71 | Southern California | 16.714285714285715 | 0.4285714285714306 | 21.428571428571427 | 21.857142857142858 | 0.9803921568627452 | 0.7800000000000001 |
32494 | 32494 | Doctors Hospital of Manteca | 50118 | 2020-12-04 | San Joaquin | 77 | San Joaquin Valley | 4.142857142857143 | 0.4285714285714297 | 7.857142857142857 | 8.285714285714286 | 0.9482758620689654 | 0.5272727272727273 |
32495 | 32495 | Doctors Hospital of Riverside, LLC | 50102 | 2020-12-04 | Riverside | 65 | Southern California | 3.142857142857143 | 7.857142857142858 | 14.142857142857142 | 22.0 | 0.6428571428571428 | 0.2222222222222222 |
32496 | 32496 | Doctors Medical Center | 50464 | 2020-12-04 | Stanislaus | 99 | San Joaquin Valley | 16.714285714285715 | 4.0 | 40.0 | 44.0 | 0.9090909090909092 | 0.4178571428571428 |
32497 | 32497 | Dominican Hospital | 50242 | 2020-12-04 | Santa Cruz | 87 | Bay Area | 6.285714285714286 | 2.8571428571428577 | 13.142857142857142 | 16.0 | 0.8214285714285714 | 0.4782608695652174 |
32498 | 32498 | East Los Angeles Doctors Hospital | 50641 | 2020-12-04 | Los Angeles | 37 | Southern California | 6.25 | 2.25 | 7.75 | 10.0 | 0.775 | 0.8064516129032258 |
32499 | 32499 | Eden Medical Center | 50488 | 2020-12-04 | Alameda | 1 | Bay Area | 5.285714285714286 | 3.571428571428573 | 20.428571428571427 | 24.0 | 0.8511904761904762 | 0.2587412587412587 |
32500 | 32500 | Eisenhower Medical Center | 50573 | 2020-12-04 | Riverside | 65 | Southern California | 8.0 | 2.428571428571427 | 23.0 | 25.428571428571427 | 0.904494382022472 | 0.3478260869565217 |
32501 | 32501 | El Camino Hospital | 50308 | 2020-12-04 | Santa Clara | 85 | Bay Area | 12.857142857142858 | 7.571428571428573 | 24.428571428571427 | 32.0 | 0.7633928571428571 | 0.5263157894736843 |
32502 | 32502 | El Centro Regional Medical Center | 50045 | 2020-12-04 | Imperial | 25 | Southern California | 18.857142857142858 | 1.2857142857142847 | 21.142857142857142 | 22.428571428571427 | 0.9426751592356688 | 0.8918918918918919 |
32503 | 32503 | Emanate Health Foothill Presbyterian Hospital | 50597 | 2020-12-04 | Los Angeles | 37 | Southern California | 8.857142857142858 | 3.7142857142857135 | 14.285714285714286 | 18.0 | 0.7936507936507937 | 0.62 |
32504 | 32504 | Emanate Health Inter-community Hospital | 50382 | 2020-12-04 | Los Angeles | 37 | Southern California | 14.142857142857142 | 7.142857142857146 | 32.857142857142854 | 40.0 | 0.8214285714285714 | 0.4304347826086956 |
32505 | 32505 | Emanuel Medical Center | 50179 | 2020-12-04 | Stanislaus | 99 | San Joaquin Valley | 4.142857142857143 | 2.714285714285713 | 9.285714285714286 | 12.0 | 0.7738095238095238 | 0.4461538461538462 |
32506 | 32506 | Encino Hospital Medical Center | 50158 | 2020-12-04 | Los Angeles | 37 | Southern California | 1.4285714285714286 | 0.285714285714286 | 3.857142857142857 | 4.142857142857143 | 0.9310344827586208 | 0.3703703703703703 |
32507 | 32507 | Enloe Medical Center | 50039 | 2020-12-04 | Butte | 7 | Greater Sacramento | 3.0 | 3.428571428571427 | 20.571428571428573 | 24.0 | 0.8571428571428572 | 0.1458333333333333 |
32508 | 32508 | Fairchild Medical Center | 51316 | 2020-12-04 | Siskiyou | 93 | Northern California | 2.5 | 0.5 | 3.5 | 4.0 | 0.875 | 0.7142857142857143 |
32509 | 32509 | Foothill Regional Medical Center | 50780 | 2020-12-04 | Orange | 59 | Southern California | 5.285714285714286 | 18.57142857142857 | 10.428571428571429 | 29.0 | 0.3596059113300492 | 0.5068493150684932 |
32510 | 32510 | Fountain Valley Regional Hospital & Medical Center | 50570 | 2020-12-04 | Orange | 59 | Southern California | 15.428571428571429 | 1.1428571428571423 | 26.571428571428573 | 27.714285714285715 | 0.9587628865979382 | 0.5806451612903225 |
32511 | 32511 | French Hospital Medical Center | 50232 | 2020-12-04 | San Luis Obispo | 79 | Southern California | 2.142857142857143 | 2.4285714285714297 | 7.857142857142857 | 10.285714285714286 | 0.7638888888888888 | 0.2727272727272727 |
32512 | 32512 | Fresno Heart and Surgical Hospital | 50732 | 2020-12-04 | Fresno | 19 | San Joaquin Valley | 0.0 | 1.1428571428571432 | 7.857142857142857 | 9.0 | 0.873015873015873 | 0.0 |
32513 | 32513 | Garden Grove Hospital & Medical Center | 50230 | 2020-12-04 | Orange | 59 | Southern California | 7.428571428571429 | 1.8571428571428577 | 9.428571428571429 | 11.285714285714286 | 0.8354430379746836 | 0.7878787878787878 |
32514 | 32514 | Garfield Medical Center | 50737 | 2020-12-04 | Los Angeles | 37 | Southern California | 5.714285714285714 | 5.428571428571427 | 16.571428571428573 | 22.0 | 0.7532467532467533 | 0.3448275862068965 |
32515 | 32515 | Glendale Adventist Medical Center | 50239 | 2020-12-04 | Los Angeles | 37 | Southern California | 14.0 | 5.142857142857139 | 31.714285714285715 | 36.85714285714285 | 0.8604651162790699 | 0.4414414414414414 |
32516 | 32516 | Glendale Mem Hospital & Health Center | 50058 | 2020-12-04 | Los Angeles | 37 | Southern California | 6.571428571428571 | 1.1428571428571423 | 17.285714285714285 | 18.428571428571427 | 0.937984496124031 | 0.3801652892561983 |
32517 | 32517 | Goleta Valley Cottage Hospital | 50357 | 2020-12-04 | Santa Barbara | 83 | Southern California | 0.0 | 6.714285714285714 | 1.2857142857142858 | 8.0 | 0.1607142857142857 | 0.0 |
32518 | 32518 | Good Samaritan Hospital | 50257 | 2020-12-04 | Kern | 29 | San Joaquin Valley | 0.0 | 4.0 | 0.0 | 4.0 | 0.0 | |
32519 | 32519 | Good Samaritan Hospital | 50380 | 2020-12-04 | Santa Clara | 85 | Bay Area | 9.714285714285714 | 4.142857142857146 | 32.857142857142854 | 37.0 | 0.8880308880308879 | 0.2956521739130435 |
32520 | 32520 | Greater El Monte Community Hospital | 50738 | 2020-12-04 | Los Angeles | 37 | Southern California | 7.285714285714286 | 0.1428571428571441 | 10.714285714285714 | 10.857142857142858 | 0.9868421052631576 | 0.68 |
32521 | 32521 | Grossmont Hospital | 50026 | 2020-12-04 | San Diego | 73 | Southern California | 37.71428571428572 | 6.285714285714292 | 68.71428571428571 | 75.0 | 0.916190476190476 | 0.5488565488565489 |
32522 | 32522 | Hazel Hawkins Memorial Hospital | 51337 | 2020-12-04 | San Benito | 69 | San Joaquin Valley | 1.8571428571428568 | 0.0 | 4.0 | 4.0 | 1.0 | 0.4642857142857143 |
32523 | 32523 | Healdsburg Hospital | 51321 | 2020-12-04 | Sonoma | 97 | Bay Area | 1.0 | 4.0 | 1.0 | 5.0 | 0.2 | 1.0 |
32524 | 32524 | Hemet Global Medical Center | 50390 | 2020-12-04 | Riverside | 65 | Southern California | 11.571428571428571 | 3.8571428571428577 | 22.142857142857142 | 26.0 | 0.8516483516483516 | 0.5225806451612903 |
32525 | 32525 | Henry Mayo Newhall Hospital | 50624 | 2020-12-04 | Los Angeles | 37 | Southern California | 13.142857142857142 | 20.571428571428573 | 24.428571428571427 | 45.0 | 0.5428571428571428 | 0.5380116959064327 |
32526 | 32526 | Hi-desert Medical Center | 50279 | 2020-12-04 | San Bernardino | 71 | Southern California | 1.8571428571428568 | 0.4285714285714284 | 3.571428571428572 | 4.0 | 0.8928571428571429 | 0.52 |
32527 | 32527 | Highland Hospital | 50320 | 2020-12-04 | Alameda | 1 | Bay Area | 5.142857142857143 | 8.714285714285715 | 24.285714285714285 | 33.0 | 0.7359307359307359 | 0.2117647058823529 |
32528 | 32528 | Hoag Memorial Hospital Presbyterian | 50224 | 2020-12-04 | Orange | 59 | Southern California | 24.714285714285715 | 12.285714285714285 | 49.142857142857146 | 61.42857142857143 | 0.8 | 0.502906976744186 |
32529 | 32529 | Hollywood Presbyterian Medical Center | 50063 | 2020-12-04 | Los Angeles | 37 | Southern California | 12.428571428571429 | 14.142857142857142 | 19.857142857142858 | 34.0 | 0.5840336134453782 | 0.6258992805755396 |
32530 | 32530 | Huntington Beach Hospital | 50526 | 2020-12-04 | Orange | 59 | Southern California | 7.142857142857143 | 0.2857142857142865 | 10.714285714285714 | 11.0 | 0.974025974025974 | 0.6666666666666667 |
32531 | 32531 | Huntington Hospital | 50438 | 2020-12-04 | Los Angeles | 37 | Southern California | 13.428571428571429 | 7.857142857142858 | 30.142857142857142 | 38.0 | 0.793233082706767 | 0.4454976303317535 |
32532 | 32532 | John F Kennedy Memorial Hospital | 50534 | 2020-12-04 | Riverside | 65 | Southern California | 6.857142857142857 | 3.0 | 14.142857142857142 | 17.142857142857142 | 0.825 | 0.4848484848484848 |
32533 | 32533 | John Muir Medical Center - Concord Campus | 50496 | 2020-12-04 | Contra Costa | 13 | Bay Area | 13.428571428571429 | 8.428571428571427 | 27.571428571428573 | 36.0 | 0.7658730158730159 | 0.4870466321243523 |
32534 | 32534 | John Muir Medical Center - Walnut Creek Campus | 50180 | 2020-12-04 | Contra Costa | 13 | Bay Area | 9.571428571428571 | 12.857142857142854 | 46.142857142857146 | 59.0 | 0.7820823244552059 | 0.2074303405572755 |
32535 | 32535 | Kaiser Foundation Hosp So Sacramento | 50674 | 2020-12-04 | Sacramento | 67 | Greater Sacramento | 15.428571428571429 | 1.7142857142857153 | 27.857142857142858 | 29.571428571428573 | 0.9420289855072465 | 0.5538461538461539 |
32536 | 32536 | Kaiser Foundation Hospital | 50510 | 2020-12-04 | Marin | 41 | Bay Area | 2.4285714285714284 | 0.7142857142857144 | 5.857142857142857 | 6.571428571428571 | 0.8913043478260869 | 0.4146341463414634 |
32537 | 32537 | Kaiser Foundation Hospital - Antioch | 50760 | 2020-12-04 | Contra Costa | 13 | Bay Area | 3.0 | 0.7142857142857144 | 6.714285714285714 | 7.428571428571429 | 0.903846153846154 | 0.4468085106382978 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "hhs-hospital-icu-totals" ( [hospital] TEXT, [ccn] INTEGER, [week] TEXT, [county] TEXT, [fips] INTEGER, [region] TEXT, [covid_icu_patients_total] FLOAT, [available_adult_icu_beds_total] FLOAT, [occupied_adult_icu_beds_total] FLOAT, [staffed_adult_icu_beds_total] FLOAT, [occupied_adult_icu_beds_percent] FLOAT, [icu_patients_with_covid_percent] FLOAT );