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.
307 rows where "week" is on date 2021-02-12 sorted by covid_icu_patients_total
This data as json, yaml, Notebook, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29371 | 29371 | Adventist Health Clearlake | 51317 | 2021-02-12 | Lake | 33 | Northern California | 0.0 | 0.1428571428571428 | 3.857142857142857 | 4.0 | 0.9642857142857144 | 0.0 |
29372 | 29372 | Adventist Health Delano | 50608 | 2021-02-12 | Kern | 29 | San Joaquin Valley | 0.0 | 0.8571428571428568 | 6.0 | 6.857142857142857 | 0.875 | 0.0 |
29378 | 29378 | Adventist Health Sonora | 50335 | 2021-02-12 | Tuolumne | 109 | San Joaquin Valley | 0.0 | 2.4285714285714284 | 3.571428571428572 | 6.0 | 0.5952380952380952 | 0.0 |
29380 | 29380 | Adventist Health Tehachapi Valley | 51301 | 2021-02-12 | Kern | 29 | San Joaquin Valley | 0.0 | 6.142857142857142 | 1.8571428571428568 | 8.0 | 0.2321428571428571 | 0.0 |
29381 | 29381 | Adventist Health Tulare | 50784 | 2021-02-12 | Tulare | 107 | San Joaquin Valley | 0.0 | 1.7142857142857144 | 2.2857142857142856 | 4.0 | 0.5714285714285714 | 0.0 |
29396 | 29396 | Barlow Respiratory Hospital | 52031 | 2021-02-12 | Los Angeles | 37 | Southern California | 0.0 | 2.571428571428572 | 3.4285714285714284 | 6.0 | 0.5714285714285714 | 0.0 |
29401 | 29401 | California Pacific Medical Center - Mission Bernal | 50055 | 2021-02-12 | San Francisco | 75 | Bay Area | 0.0 | 7.142857142857142 | 2.857142857142857 | 10.0 | 0.2857142857142857 | 0.0 |
29403 | 29403 | California Pacific Medical Ctr-davies Campus Hosp | 50008 | 2021-02-12 | San Francisco | 75 | Bay Area | 0.0 | 3.571428571428571 | 4.428571428571429 | 8.0 | 0.5535714285714286 | 0.0 |
29404 | 29404 | Casa Colina Hospital | 50782 | 2021-02-12 | Los Angeles | 37 | Southern California | 0.0 | 3.0 | 3.0 | 6.0 | 0.5 | 0.0 |
29415 | 29415 | Colusa Medical Center | 50783 | 2021-02-12 | Colusa | 11 | Greater Sacramento | 0.0 | 5.0 | 0.0 | 5.0 | 0.0 | |
29444 | 29444 | Fresno Heart and Surgical Hospital | 50732 | 2021-02-12 | Fresno | 19 | San Joaquin Valley | 0.0 | 1.4285714285714288 | 7.571428571428571 | 9.0 | 0.8412698412698413 | 0.0 |
29449 | 29449 | Good Samaritan Hospital | 50257 | 2021-02-12 | Kern | 29 | San Joaquin Valley | 0.0 | 4.0 | 0.0 | 4.0 | 0.0 | |
29454 | 29454 | Healdsburg Hospital | 51321 | 2021-02-12 | Sonoma | 97 | Bay Area | 0.0 | 5.0 | 0.0 | 5.0 | 0.0 | |
29501 | 29501 | Kindred Hospital - Los Angeles | 52032 | 2021-02-12 | Los Angeles | 37 | Southern California | 0.0 | 0.0 | 5.0 | 5.0 | 1.0 | 0.0 |
29502 | 29502 | Kindred Hospital - San Diego | 52036 | 2021-02-12 | San Diego | 73 | Southern California | 0.0 | 2.1428571428571432 | 5.857142857142857 | 8.0 | 0.7321428571428571 | 0.0 |
29503 | 29503 | Kindred Hospital - San Francisco Bay Area | 52034 | 2021-02-12 | Alameda | 1 | Bay Area | 0.0 | 0.1428571428571423 | 9.857142857142858 | 10.0 | 0.9857142857142858 | 0.0 |
29505 | 29505 | Kindred Hospital Baldwin Park | 52045 | 2021-02-12 | Los Angeles | 37 | Southern California | 0.0 | 0.0 | 8.0 | 8.0 | 1.0 | 0.0 |
29506 | 29506 | Kindred Hospital Brea | 52039 | 2021-02-12 | Orange | 59 | Southern California | 0.0 | 0.0 | 4.0 | 4.0 | 1.0 | 0.0 |
29507 | 29507 | Kindred Hospital Ontario | 52037 | 2021-02-12 | San Bernardino | 71 | Southern California | 0.0 | 3.0 | 8.0 | 11.0 | 0.7272727272727273 | 0.0 |
29509 | 29509 | Kindred Hospital Rancho | 52049 | 2021-02-12 | San Bernardino | 71 | Southern California | 0.0 | 0.4285714285714288 | 7.571428571428571 | 8.0 | 0.9464285714285714 | 0.0 |
29510 | 29510 | Kindred Hospital Riverside | 52052 | 2021-02-12 | Riverside | 65 | Southern California | 0.0 | 0.1428571428571432 | 7.857142857142857 | 8.0 | 0.9821428571428572 | 0.0 |
29512 | 29512 | Kindred Hospital Westminster | 52035 | 2021-02-12 | Orange | 59 | Southern California | 0.0 | 0.0 | 16.0 | 16.0 | 1.0 | 0.0 |
29528 | 29528 | Mammoth Hospital | 51303 | 2021-02-12 | Mono | 51 | Southern California | 0.0 | 1.7142857142857142 | 0.0 | 1.7142857142857142 | 0.0 | |
29545 | 29545 | Mercy Medical Center Mt Shasta | 51319 | 2021-02-12 | Siskiyou | 93 | Northern California | 0.0 | 2.2857142857142856 | 1.7142857142857142 | 4.0 | 0.4285714285714285 | 0.0 |
29551 | 29551 | Monrovia Memorial Hospital | 52054 | 2021-02-12 | Los Angeles | 37 | Southern California | 0.0 | 0.0 | 4.0 | 4.0 | 1.0 | 0.0 |
29556 | 29556 | Northern Inyo Hospital | 51324 | 2021-02-12 | Inyo | 27 | Southern California | 0.0 | 2.0 | 0.0 | 2.0 | 0.0 | |
29560 | 29560 | Ojai Valley Community Hospital | 51334 | 2021-02-12 | Ventura | 111 | Southern California | 0.0 | 0.4285714285714284 | 3.571428571428572 | 4.0 | 0.8928571428571429 | 0.0 |
29563 | 29563 | Orchard Hospital | 51311 | 2021-02-12 | Butte | 7 | Greater Sacramento | 0.0 | 1.8571428571428568 | 2.142857142857143 | 4.0 | 0.5357142857142857 | 0.0 |
29564 | 29564 | Oroville Hospital | 50030 | 2021-02-12 | Butte | 7 | Greater Sacramento | 0.0 | 1.2857142857142865 | 8.714285714285714 | 10.0 | 0.8714285714285713 | 0.0 |
29582 | 29582 | Providence Queen of the Valley Medical Center | 50009 | 2021-02-12 | Napa | 55 | Bay Area | 0.0 | 4.285714285714285 | 8.428571428571429 | 12.714285714285714 | 0.6629213483146068 | 0.0 |
29615 | 29615 | Select Specialty Hospital - San Diego | 52044 | 2021-02-12 | San Diego | 73 | Southern California | 0.0 | 0.0 | 0.8571428571428571 | 0.8571428571428571 | 1.0 | 0.0 |
29620 | 29620 | Shasta Regional Medical Center | 50764 | 2021-02-12 | Shasta | 89 | Northern California | 0.0 | 16.285714285714285 | 5.714285714285714 | 22.0 | 0.2597402597402597 | 0.0 |
29622 | 29622 | Sierra Nevada Memorial Hospital | 50150 | 2021-02-12 | Nevada | 57 | Greater Sacramento | 0.0 | 3.571428571428571 | 4.428571428571429 | 8.0 | 0.5535714285714286 | 0.0 |
29624 | 29624 | Sonoma Specialty Hospital | 52057 | 2021-02-12 | Sonoma | 97 | Bay Area | 0.0 | 4.8 | 0.0 | 4.8 | 0.0 | |
29642 | 29642 | Sutter Coast Hospital | 50417 | 2021-02-12 | Del Norte | 15 | Northern California | 0.0 | 1.4285714285714288 | 4.571428571428571 | 6.0 | 0.7619047619047619 | 0.0 |
29651 | 29651 | Tahoe Forest Hospital | 51328 | 2021-02-12 | Nevada | 57 | Greater Sacramento | 0.0 | 3.857142857142857 | 2.142857142857143 | 6.0 | 0.3571428571428571 | 0.0 |
29659 | 29659 | USC Kenneth Norris Jr Cancer Hospital | 50660 | 2021-02-12 | Los Angeles | 37 | Southern California | 0.0 | 0.714285714285714 | 2.7142857142857144 | 3.4285714285714284 | 0.7916666666666667 | 0.0 |
29667 | 29667 | Vibra Hospital of Sacramento | 52033 | 2021-02-12 | Sacramento | 67 | Greater Sacramento | 0.0 | 0.0 | 6.0 | 6.0 | 1.0 | 0.0 |
29583 | 29583 | Providence Redwood Memorial Hospital | 51318 | 2021-02-12 | Humboldt | 23 | Northern California | 0.5714285714285714 | 0.7142857142857144 | 3.2857142857142856 | 4.0 | 0.8214285714285714 | 0.1739130434782608 |
29630 | 29630 | St. Elizabeth Community Hospital | 50042 | 2021-02-12 | Tehama | 103 | Northern California | 0.5714285714285714 | 1.1428571428571432 | 6.857142857142857 | 8.0 | 0.8571428571428571 | 0.0833333333333333 |
29376 | 29376 | Adventist Health Mendocino Coast | 51325 | 2021-02-12 | Mendocino | 45 | Northern California | 0.7142857142857143 | 2.571428571428571 | 1.4285714285714286 | 4.0 | 0.3571428571428571 | 0.5 |
29409 | 29409 | Chinese Hospital | 50407 | 2021-02-12 | San Francisco | 75 | Bay Area | 0.7142857142857143 | 2.571428571428572 | 3.4285714285714284 | 6.0 | 0.5714285714285714 | 0.2083333333333333 |
29575 | 29575 | Placentia Linda Hospital | 50589 | 2021-02-12 | Orange | 59 | Southern California | 0.7142857142857143 | 8.428571428571429 | 3.571428571428572 | 12.0 | 0.2976190476190476 | 0.1999999999999999 |
29398 | 29398 | Barton Memorial Hospital | 50352 | 2021-02-12 | El Dorado | 17 | Greater Sacramento | 0.8571428571428571 | 5.0 | 3.0 | 8.0 | 0.375 | 0.2857142857142857 |
29457 | 29457 | Hi-desert Medical Center | 50279 | 2021-02-12 | San Bernardino | 71 | Southern California | 0.8571428571428571 | 0.8571428571428572 | 3.142857142857143 | 4.0 | 0.7857142857142857 | 0.2727272727272727 |
29526 | 29526 | Mad River Community Hospital | 50028 | 2021-02-12 | Humboldt | 23 | Northern California | 0.8571428571428571 | 2.2857142857142856 | 3.7142857142857135 | 6.0 | 0.6190476190476191 | 0.2307692307692307 |
29541 | 29541 | Mercy General Hospital | 50017 | 2021-02-12 | Sacramento | 67 | Greater Sacramento | 0.8571428571428571 | 3.5714285714285694 | 22.714285714285715 | 26.285714285714285 | 0.8641304347826088 | 0.0377358490566037 |
29645 | 29645 | Sutter Lakeside Hospital | 51329 | 2021-02-12 | Lake | 33 | Northern California | 0.8571428571428571 | 0.8571428571428572 | 3.142857142857143 | 4.0 | 0.7857142857142857 | 0.2727272727272727 |
29379 | 29379 | Adventist Health St. Helena | 50013 | 2021-02-12 | Napa | 55 | Bay Area | 1.0 | 0.7142857142857153 | 11.142857142857142 | 11.857142857142858 | 0.9397590361445782 | 0.0897435897435897 |
29440 | 29440 | Fairchild Medical Center | 51316 | 2021-02-12 | Siskiyou | 93 | Northern California | 1.0 | 0.4285714285714284 | 3.571428571428572 | 4.0 | 0.8928571428571429 | 0.2799999999999999 |
29531 | 29531 | Mark Twain Medical Center | 51332 | 2021-02-12 | Calaveras | 9 | San Joaquin Valley | 1.0 | 9.428571428571429 | 2.571428571428572 | 12.0 | 0.2142857142857143 | 0.3888888888888888 |
29558 | 29558 | Novato Community Hospital | 50131 | 2021-02-12 | Marin | 41 | Bay Area | 1.0 | 3.857142857142857 | 2.142857142857143 | 6.0 | 0.3571428571428571 | 0.4666666666666667 |
29591 | 29591 | Ridgecrest Regional Hospital | 51333 | 2021-02-12 | Kern | 29 | San Joaquin Valley | 1.0 | 0.1428571428571428 | 3.857142857142857 | 4.0 | 0.9642857142857144 | 0.2592592592592592 |
29653 | 29653 | Tenet Health Central Coast Sierra Vista Rmc | 50506 | 2021-02-12 | San Luis Obispo | 79 | Southern California | 1.0 | 11.571428571428571 | 5.428571428571429 | 17.0 | 0.319327731092437 | 0.1842105263157894 |
29374 | 29374 | Adventist Health Howard Memorial | 51310 | 2021-02-12 | Mendocino | 45 | Northern California | 1.1428571428571428 | 0.2857142857142856 | 3.7142857142857135 | 4.0 | 0.9285714285714286 | 0.3076923076923076 |
29513 | 29513 | LA Downtown Medical Center, LLC | 50763 | 2021-02-12 | Los Angeles | 37 | Southern California | 1.1428571428571428 | 0.0 | 12.0 | 12.0 | 1.0 | 0.0952380952380952 |
29549 | 29549 | Mills-peninsula Medical Center | 50007 | 2021-02-12 | San Mateo | 81 | Bay Area | 1.1428571428571428 | 9.857142857142858 | 14.142857142857142 | 24.0 | 0.5892857142857143 | 0.0808080808080808 |
29625 | 29625 | Sonoma Valley Hospital | 50090 | 2021-02-12 | Sonoma | 97 | Bay Area | 1.1428571428571428 | 4.571428571428571 | 1.4285714285714286 | 6.0 | 0.2380952380952381 | 0.7999999999999999 |
29641 | 29641 | Sutter Auburn Faith Hospital | 50498 | 2021-02-12 | Placer | 61 | Greater Sacramento | 1.1428571428571428 | 5.857142857142858 | 2.142857142857143 | 8.0 | 0.2678571428571428 | 0.5333333333333333 |
29532 | 29532 | Marshall Medical Center | 50254 | 2021-02-12 | El Dorado | 17 | Greater Sacramento | 1.1666666666666667 | 3.000000000000001 | 5.333333333333333 | 8.333333333333334 | 0.6399999999999999 | 0.21875 |
29664 | 29664 | Valley Children's Hospital | 53300 | 2021-02-12 | Fresno | 19 | San Joaquin Valley | 1.2857142857142858 | 0.0 | 2.571428571428572 | 2.571428571428572 | 1.0 | 0.5 |
29418 | 29418 | Community Hospital of the Monterey Peninsula | 50145 | 2021-02-12 | Monterey | 53 | Bay Area | 1.4285714285714286 | 12.857142857142858 | 13.142857142857142 | 26.0 | 0.5054945054945055 | 0.108695652173913 |
29439 | 29439 | Enloe Medical Center | 50039 | 2021-02-12 | Butte | 7 | Greater Sacramento | 1.4285714285714286 | 8.142857142857142 | 15.857142857142858 | 24.0 | 0.6607142857142857 | 0.09009009009009 |
29504 | 29504 | Kindred Hospital -- La Mirada | 52038 | 2021-02-12 | Los Angeles | 37 | Southern California | 1.4285714285714286 | 1.2857142857142847 | 17.714285714285715 | 19.0 | 0.9323308270676692 | 0.0806451612903225 |
29559 | 29559 | Oak Valley Hospital District | 50067 | 2021-02-12 | Stanislaus | 99 | San Joaquin Valley | 1.4285714285714286 | 2.7142857142857144 | 2.2857142857142856 | 5.0 | 0.4571428571428571 | 0.625 |
29570 | 29570 | Petaluma Valley Hospital | 50136 | 2021-02-12 | Sonoma | 97 | Bay Area | 1.4285714285714286 | 0.8571428571428568 | 4.0 | 4.857142857142857 | 0.823529411764706 | 0.3571428571428571 |
29553 | 29553 | Monterey Park Hospital | 50736 | 2021-02-12 | Los Angeles | 37 | Southern California | 1.5714285714285714 | 0.5714285714285716 | 3.4285714285714284 | 4.0 | 0.8571428571428571 | 0.4583333333333333 |
29543 | 29543 | Mercy Hospital of Folsom | 50414 | 2021-02-12 | Sacramento | 67 | Greater Sacramento | 1.6666666666666667 | 3.0 | 5.0 | 8.0 | 0.625 | 0.3333333333333333 |
29508 | 29508 | Kindred Hospital Paramount | 52046 | 2021-02-12 | Los Angeles | 37 | Southern California | 1.7142857142857142 | 0.1428571428571423 | 11.857142857142858 | 12.0 | 0.988095238095238 | 0.144578313253012 |
29597 | 29597 | Saint Francis Memorial Hospital | 50152 | 2021-02-12 | San Francisco | 75 | Bay Area | 1.7142857142857142 | 12.428571428571429 | 7.571428571428571 | 20.0 | 0.3785714285714285 | 0.2264150943396226 |
29640 | 29640 | Sutter Amador Hospital | 50014 | 2021-02-12 | Amador | 5 | Greater Sacramento | 1.7142857142857142 | 1.0 | 5.0 | 6.0 | 0.8333333333333334 | 0.3428571428571428 |
29616 | 29616 | Sequoia Hospital | 50197 | 2021-02-12 | San Mateo | 81 | Bay Area | 1.8571428571428568 | 11.42857142857143 | 5.142857142857143 | 16.571428571428573 | 0.3103448275862069 | 0.3611111111111111 |
29643 | 29643 | Sutter Davis Hospital | 50537 | 2021-02-12 | Yolo | 113 | Greater Sacramento | 1.8571428571428568 | 1.0 | 5.0 | 6.0 | 0.8333333333333334 | 0.3714285714285714 |
29382 | 29382 | Adventist Health Ukiah Valley | 50301 | 2021-02-12 | Mendocino | 45 | Northern California | 2.0 | 0.8571428571428568 | 6.428571428571429 | 7.285714285714286 | 0.8823529411764707 | 0.3111111111111111 |
29386 | 29386 | Alameda Hospital | 50211 | 2021-02-12 | Alameda | 1 | Bay Area | 2.0 | 2.0 | 6.0 | 8.0 | 0.75 | 0.3333333333333333 |
29402 | 29402 | California Pacific Medical Center- Van Ness Campus | 50047 | 2021-02-12 | San Francisco | 75 | Bay Area | 2.0 | 11.571428571428571 | 24.428571428571427 | 36.0 | 0.6785714285714285 | 0.0818713450292397 |
29546 | 29546 | Mercy Medical Center Redding | 50280 | 2021-02-12 | Shasta | 89 | Northern California | 2.0 | 5.285714285714285 | 27.714285714285715 | 33.0 | 0.8398268398268398 | 0.0721649484536082 |
29626 | 29626 | South Coast Global Medical Center | 50747 | 2021-02-12 | Orange | 59 | Southern California | 2.0 | 3.428571428571429 | 5.571428571428571 | 9.0 | 0.6190476190476191 | 0.358974358974359 |
29565 | 29565 | Pacifica Hospital of the Valley | 50378 | 2021-02-12 | Los Angeles | 37 | Southern California | 2.142857142857143 | 2.2857142857142865 | 12.571428571428571 | 14.857142857142858 | 0.8461538461538461 | 0.1704545454545454 |
29568 | 29568 | Palomar Medical Center Poway | 50636 | 2021-02-12 | San Diego | 73 | Southern California | 2.142857142857143 | 3.8571428571428577 | 8.142857142857142 | 12.0 | 0.6785714285714285 | 0.2631578947368421 |
29530 | 29530 | Marinhealth Medical Center | 50360 | 2021-02-12 | Marin | 41 | Bay Area | 2.2857142857142856 | 10.571428571428571 | 8.428571428571429 | 19.0 | 0.443609022556391 | 0.2711864406779661 |
29650 | 29650 | Sutter Tracy Community Hospital | 50313 | 2021-02-12 | San Joaquin | 77 | San Joaquin Valley | 2.2857142857142856 | 2.0 | 6.0 | 8.0 | 0.75 | 0.3809523809523809 |
29375 | 29375 | Adventist Health Lodi Memorial | 50336 | 2021-02-12 | San Joaquin | 77 | San Joaquin Valley | 2.4285714285714284 | 1.8571428571428577 | 8.142857142857142 | 10.0 | 0.8142857142857143 | 0.2982456140350877 |
29388 | 29388 | Alta Bates Summit Medical Center | 50043 | 2021-02-12 | Alameda | 1 | Bay Area | 2.4285714285714284 | 18.571428571428573 | 17.428571428571427 | 36.0 | 0.4841269841269841 | 0.1393442622950819 |
29397 | 29397 | Barstow Community Hospital | 50298 | 2021-02-12 | San Bernardino | 71 | Southern California | 2.4285714285714284 | 5.285714285714285 | 4.428571428571429 | 9.714285714285714 | 0.4558823529411765 | 0.5483870967741935 |
29443 | 29443 | French Hospital Medical Center | 50232 | 2021-02-12 | San Luis Obispo | 79 | Southern California | 2.4285714285714284 | 1.7142857142857153 | 8.571428571428571 | 10.285714285714286 | 0.8333333333333333 | 0.2833333333333333 |
29586 | 29586 | Providence St. Joseph Hospital | 50006 | 2021-02-12 | Humboldt | 23 | Northern California | 2.4285714285714284 | 3.428571428571429 | 14.571428571428571 | 18.0 | 0.8095238095238095 | 0.1666666666666666 |
29605 | 29605 | San Mateo Medical Center | 50113 | 2021-02-12 | San Mateo | 81 | Bay Area | 2.4285714285714284 | 1.1428571428571432 | 5.0 | 6.142857142857143 | 0.813953488372093 | 0.4857142857142856 |
29387 | 29387 | Alhambra Hospital Medical Center | 50281 | 2021-02-12 | Los Angeles | 37 | Southern California | 2.571428571428572 | 1.0 | 9.0 | 10.0 | 0.9 | 0.2857142857142857 |
29426 | 29426 | Doctors Hospital of Manteca | 50118 | 2021-02-12 | San Joaquin | 77 | San Joaquin Valley | 2.571428571428572 | 1.2857142857142856 | 6.714285714285714 | 8.0 | 0.8392857142857143 | 0.3829787234042553 |
29438 | 29438 | Encino Hospital Medical Center | 50158 | 2021-02-12 | Los Angeles | 37 | Southern California | 2.571428571428572 | 1.4285714285714284 | 2.571428571428572 | 4.0 | 0.6428571428571429 | 1.0 |
29467 | 29467 | Kaiser Foundation Hospital | 50510 | 2021-02-12 | Marin | 41 | Bay Area | 2.571428571428572 | 1.0 | 5.714285714285714 | 6.714285714285714 | 0.851063829787234 | 0.45 |
29606 | 29606 | San Ramon Regional Medical Center | 50689 | 2021-02-12 | Contra Costa | 13 | Bay Area | 2.571428571428572 | 5.428571428571429 | 6.571428571428571 | 12.0 | 0.5476190476190476 | 0.391304347826087 |
29610 | 29610 | Santa Paula Hospital | 2021-02-12 | Ventura | 111 | Southern California | 2.571428571428572 | 0.2857142857142856 | 5.714285714285714 | 6.0 | 0.9523809523809524 | 0.45 | |
29411 | 29411 | City of Hope Helford Clinical Research Hospital | 50146 | 2021-02-12 | Los Angeles | 37 | Southern California | 2.7142857142857144 | 6.0 | 12.0 | 18.0 | 0.6666666666666666 | 0.2261904761904762 |
29654 | 29654 | Tenet Health Central Twin Cities Community Hosp | 50633 | 2021-02-12 | San Luis Obispo | 79 | Southern California | 2.7142857142857144 | 6.571428571428571 | 3.4285714285714284 | 10.0 | 0.3428571428571428 | 0.7916666666666667 |
29666 | 29666 | Ventura County Medical Center | 50159 | 2021-02-12 | Ventura | 111 | Southern California | 2.7142857142857144 | 8.857142857142858 | 7.142857142857143 | 16.0 | 0.4464285714285714 | 0.38 |
29639 | 29639 | Stanford Health Care - Valleycare | 50283 | 2021-02-12 | Alameda | 1 | Bay Area | 2.857142857142857 | 4.714285714285715 | 17.285714285714285 | 22.0 | 0.7857142857142857 | 0.1652892561983471 |
29421 | 29421 | Contra Costa Regional Medical Center | 50276 | 2021-02-12 | Contra Costa | 13 | Bay Area | 3.0 | 5.166666666666666 | 12.833333333333334 | 18.0 | 0.712962962962963 | 0.2337662337662337 |
29431 | 29431 | Eden Medical Center | 50488 | 2021-02-12 | Alameda | 1 | Bay Area | 3.0 | 3.7142857142857153 | 20.285714285714285 | 24.0 | 0.8452380952380952 | 0.1478873239436619 |
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 );