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.
38,919 rows sorted by region
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
474 | 474 | Providence Santa Rosa Memorial Hospital | 50174 | 2022-12-16 | Sonoma | 97 | Bay Area | 2.142857142857143 | 6.0 | 20.0 | 26.0 | 0.7692307692307693 | 0.1071428571428571 |
479 | 479 | Regional Medical Center of San Jose | 50125 | 2022-12-16 | Santa Clara | 85 | Bay Area | 3.571428571428572 | 2.0 | 32.285714285714285 | 34.285714285714285 | 0.9416666666666668 | 0.1106194690265486 |
486 | 486 | Saint Francis Memorial Hospital | 50152 | 2022-12-16 | San Francisco | 75 | Bay Area | 1.5714285714285714 | 9.857142857142858 | 10.142857142857142 | 20.0 | 0.5071428571428571 | 0.1549295774647887 |
488 | 488 | Salinas Valley Memorial Hospital | 50334 | 2022-12-16 | Monterey | 53 | Bay Area | 1.0 | 1.8571428571428577 | 11.142857142857142 | 13.0 | 0.8571428571428571 | 0.0897435897435897 |
494 | 494 | San Mateo Medical Center | 50113 | 2022-12-16 | San Mateo | 81 | Bay Area | 0.0 | 1.2857142857142856 | 3.7142857142857135 | 5.0 | 0.7428571428571429 | 0.0 |
495 | 495 | San Ramon Regional Medical Center | 50689 | 2022-12-16 | Contra Costa | 13 | Bay Area | 0.6666666666666666 | 4.833333333333333 | 7.166666666666667 | 12.0 | 0.5972222222222222 | 0.0930232558139534 |
497 | 497 | Santa Clara Valley Medical Center | 50038 | 2022-12-16 | Santa Clara | 85 | Bay Area | 7.714285714285714 | 26.0 | 62.0 | 88.0 | 0.7045454545454546 | 0.1244239631336405 |
503 | 503 | Sequoia Hospital | 50197 | 2022-12-16 | San Mateo | 81 | Bay Area | 0.0 | 6.285714285714286 | 6.714285714285714 | 13.0 | 0.5164835164835165 | 0.0 |
511 | 511 | Sonoma Specialty Hospital | 52057 | 2022-12-16 | Sonoma | 97 | Bay Area | 0.0 | 5.0 | 0.0 | 5.0 | 0.0 | |
512 | 512 | Sonoma Valley Hospital | 50090 | 2022-12-16 | Sonoma | 97 | Bay Area | 0.0 | 6.0 | 0.0 | 6.0 | 0.0 | |
523 | 523 | St. Mary's Medical Center | 50457 | 2022-12-16 | San Francisco | 75 | Bay Area | 1.0 | 5.571428571428571 | 10.428571428571429 | 16.0 | 0.6517857142857143 | 0.0958904109589041 |
524 | 524 | St. Rose Hospital | 50002 | 2022-12-16 | Alameda | 1 | Bay Area | 0.0 | 6.857142857142857 | 5.142857142857143 | 12.0 | 0.4285714285714286 | 0.0 |
525 | 525 | Stanford Health Care | 50441 | 2022-12-16 | Santa Clara | 85 | Bay Area | 11.714285714285714 | 0.0 | 111.57142857142856 | 111.57142857142856 | 1.0 | 0.1049935979513444 |
526 | 526 | Stanford Health Care - Valleycare | 50283 | 2022-12-16 | Alameda | 1 | Bay Area | 0.0 | 4.199999999999999 | 17.8 | 22.0 | 0.8090909090909091 | 0.0 |
531 | 531 | Sutter Delta Medical Center | 50523 | 2022-12-16 | Contra Costa | 13 | Bay Area | 1.0 | 1.0 | 11.0 | 12.0 | 0.9166666666666666 | 0.0909090909090909 |
535 | 535 | Sutter Santa Rosa Regional Hospital | 50291 | 2022-12-16 | Sonoma | 97 | Bay Area | 1.1428571428571428 | 1.5714285714285712 | 10.428571428571429 | 12.0 | 0.8690476190476191 | 0.1095890410958904 |
536 | 536 | Sutter Solano Medical Center | 50101 | 2022-12-16 | Solano | 95 | Bay Area | 1.7142857142857142 | 7.571428571428571 | 4.428571428571429 | 12.0 | 0.369047619047619 | 0.3870967741935483 |
544 | 544 | UCSF Medical Center | 50454 | 2022-12-16 | San Francisco | 75 | Bay Area | 0.0 | 4.0 | 4.0 | 8.0 | 0.5 | 0.0 |
555 | 555 | Washington Hospital | 50195 | 2022-12-16 | Alameda | 1 | Bay Area | 4.857142857142857 | 7.285714285714285 | 20.714285714285715 | 28.0 | 0.7397959183673469 | 0.2344827586206896 |
561 | 561 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2022-12-16 | San Francisco | 75 | Bay Area | 1.5714285714285714 | 0.1428571428571388 | 39.42857142857143 | 39.57142857142857 | 0.996389891696751 | 0.0398550724637681 |
571 | 571 | Adventist Health St. Helena | 50013 | 2022-12-09 | Napa | 55 | Bay Area | 0.0 | 1.2857142857142865 | 7.571428571428571 | 8.857142857142858 | 0.8548387096774193 | 0.0 |
577 | 577 | Ahmc Seton Medical Center | 50289 | 2022-12-09 | San Mateo | 81 | Bay Area | 1.7142857142857142 | 0.7142857142857135 | 10.285714285714286 | 11.0 | 0.9350649350649352 | 0.1666666666666666 |
578 | 578 | Alameda Hospital | 50211 | 2022-12-09 | Alameda | 1 | Bay Area | 0.0 | 0.5714285714285712 | 7.428571428571429 | 8.0 | 0.9285714285714286 | 0.0 |
580 | 580 | Alta Bates Summit Medical Center | 50043 | 2022-12-09 | Alameda | 1 | Bay Area | 3.4285714285714284 | 12.857142857142858 | 23.142857142857142 | 36.0 | 0.6428571428571428 | 0.1481481481481481 |
581 | 581 | Alta Bates Summit Medical Center - Alta Bates Camp | 50305 | 2022-12-09 | Alameda | 1 | Bay Area | 2.857142857142857 | 17.42857142857143 | 12.571428571428571 | 30.0 | 0.419047619047619 | 0.2272727272727273 |
593 | 593 | California Pacific Medical Center - Mission Bernal | 50055 | 2022-12-09 | San Francisco | 75 | Bay Area | 1.1428571428571428 | 3.2857142857142856 | 6.714285714285714 | 10.0 | 0.6714285714285715 | 0.1702127659574468 |
594 | 594 | California Pacific Medical Center- Van Ness Campus | 50047 | 2022-12-09 | San Francisco | 75 | Bay Area | 2.571428571428572 | 4.142857142857142 | 31.857142857142858 | 36.0 | 0.8849206349206349 | 0.0807174887892376 |
595 | 595 | California Pacific Medical Ctr-davies Campus Hosp | 50008 | 2022-12-09 | San Francisco | 75 | Bay Area | 1.0 | 1.4285714285714288 | 6.571428571428571 | 8.0 | 0.8214285714285714 | 0.1521739130434782 |
601 | 601 | Chinese Hospital | 50407 | 2022-12-09 | San Francisco | 75 | Bay Area | 0.0 | 2.857142857142857 | 3.142857142857143 | 6.0 | 0.5238095238095238 | 0.0 |
609 | 609 | Community Hospital of the Monterey Peninsula | 50145 | 2022-12-09 | Monterey | 53 | Bay Area | 0.5714285714285714 | 7.0 | 19.0 | 26.0 | 0.7307692307692307 | 0.0300751879699248 |
612 | 612 | Contra Costa Regional Medical Center | 50276 | 2022-12-09 | Contra Costa | 13 | Bay Area | 2.2857142857142856 | 2.714285714285713 | 15.285714285714286 | 18.0 | 0.8492063492063493 | 0.1495327102803738 |
620 | 620 | Dominican Hospital | 50242 | 2022-12-09 | Santa Cruz | 87 | Bay Area | 1.2857142857142858 | 0.7142857142857135 | 13.285714285714286 | 14.0 | 0.9489795918367347 | 0.0967741935483871 |
622 | 622 | Eden Medical Center | 50488 | 2022-12-09 | Alameda | 1 | Bay Area | 3.0 | 2.7142857142857157 | 21.285714285714285 | 24.0 | 0.8869047619047619 | 0.1409395973154362 |
624 | 624 | El Camino Hospital | 50308 | 2022-12-09 | Santa Clara | 85 | Bay Area | 3.857142857142857 | 4.428571428571427 | 27.571428571428573 | 32.0 | 0.8616071428571429 | 0.1398963730569948 |
640 | 640 | Good Samaritan Hospital | 50380 | 2022-12-09 | Santa Clara | 85 | Bay Area | 3.7142857142857135 | 2.0 | 35.0 | 37.0 | 0.945945945945946 | 0.1061224489795918 |
644 | 644 | Healdsburg Hospital | 51321 | 2022-12-09 | Sonoma | 97 | Bay Area | 0.0 | 4.285714285714286 | 0.7142857142857143 | 5.0 | 0.1428571428571428 | 0.0 |
648 | 648 | Highland Hospital | 50320 | 2022-12-09 | Alameda | 1 | Bay Area | 0.0 | 9.0 | 24.0 | 33.0 | 0.7272727272727273 | 0.0 |
654 | 654 | John Muir Medical Center - Concord Campus | 50496 | 2022-12-09 | Contra Costa | 13 | Bay Area | 1.4285714285714286 | 6.714285714285715 | 29.285714285714285 | 36.0 | 0.8134920634920635 | 0.048780487804878 |
655 | 655 | John Muir Medical Center - Walnut Creek Campus | 50180 | 2022-12-09 | Contra Costa | 13 | Bay Area | 2.0 | 7.714285714285715 | 40.285714285714285 | 48.0 | 0.8392857142857143 | 0.0496453900709219 |
657 | 657 | Kaiser Foundation Hospital | 50510 | 2022-12-09 | Marin | 41 | Bay Area | 1.5714285714285714 | 0.5714285714285712 | 5.142857142857143 | 5.714285714285714 | 0.9 | 0.3055555555555555 |
658 | 658 | Kaiser Foundation Hospital - Antioch | 50760 | 2022-12-09 | Contra Costa | 13 | Bay Area | 3.2857142857142856 | 0.9999999999999992 | 7.714285714285714 | 8.714285714285714 | 0.8852459016393444 | 0.4259259259259259 |
661 | 661 | Kaiser Foundation Hospital - Fremont | 50512 | 2022-12-09 | Alameda | 1 | Bay Area | 2.4285714285714284 | 0.8571428571428577 | 6.571428571428571 | 7.428571428571429 | 0.8846153846153846 | 0.3695652173913043 |
664 | 664 | Kaiser Foundation Hospital - Oakland/richmond | 50075 | 2022-12-09 | Alameda | 1 | Bay Area | 4.428571428571429 | 2.0 | 16.714285714285715 | 18.714285714285715 | 0.8931297709923665 | 0.2649572649572649 |
667 | 667 | Kaiser Foundation Hospital - Redwood City | 50541 | 2022-12-09 | San Mateo | 81 | Bay Area | 2.142857142857143 | 1.1428571428571423 | 12.857142857142858 | 14.0 | 0.9183673469387756 | 0.1666666666666666 |
670 | 670 | Kaiser Foundation Hospital - San Francisco | 50076 | 2022-12-09 | San Francisco | 75 | Bay Area | 0.7142857142857143 | 1.7142857142857153 | 18.428571428571427 | 20.142857142857142 | 0.9148936170212766 | 0.0387596899224806 |
671 | 671 | Kaiser Foundation Hospital - San Leandro | 50777 | 2022-12-09 | Alameda | 1 | Bay Area | 8.714285714285714 | 1.857142857142854 | 16.571428571428573 | 18.428571428571427 | 0.8992248062015505 | 0.5258620689655171 |
673 | 673 | Kaiser Foundation Hospital - South San Francisco | 50070 | 2022-12-09 | San Mateo | 81 | Bay Area | 2.2857142857142856 | 1.0 | 6.142857142857143 | 7.142857142857143 | 0.86 | 0.3720930232558139 |
674 | 674 | Kaiser Foundation Hospital - Vacaville | 50767 | 2022-12-09 | Solano | 95 | Bay Area | 3.142857142857143 | 1.0 | 10.571428571428571 | 11.571428571428571 | 0.9135802469135802 | 0.2972972972972973 |
675 | 675 | Kaiser Foundation Hospital - Walnut Creek | 50072 | 2022-12-09 | Contra Costa | 13 | Bay Area | 3.2857142857142856 | 1.8571428571428577 | 15.142857142857142 | 17.0 | 0.8907563025210083 | 0.2169811320754717 |
681 | 681 | Kaiser Foundation Hospital and Rehab Center | 50073 | 2022-12-09 | Solano | 95 | Bay Area | 3.571428571428572 | 1.142857142857144 | 10.714285714285714 | 11.857142857142858 | 0.9036144578313252 | 0.3333333333333333 |
684 | 684 | Kaiser Foundation Hospital-san Jose | 50604 | 2022-12-09 | Santa Clara | 85 | Bay Area | 2.7142857142857144 | 1.4285714285714288 | 13.142857142857142 | 14.571428571428571 | 0.9019607843137256 | 0.2065217391304348 |
685 | 685 | Kaiser Foundation Hospital-santa Clara | 50071 | 2022-12-09 | Santa Clara | 85 | Bay Area | 5.142857142857143 | 0.0 | 33.285714285714285 | 33.285714285714285 | 1.0 | 0.1545064377682403 |
686 | 686 | Kaiser Foundation Hospital-santa Rosa | 50690 | 2022-12-09 | Sonoma | 97 | Bay Area | 1.0 | 0.8571428571428577 | 8.428571428571429 | 9.285714285714286 | 0.9076923076923076 | 0.1186440677966101 |
693 | 693 | Kindred Hospital - San Francisco Bay Area | 52034 | 2022-12-09 | Alameda | 1 | Bay Area | 0.0 | 5.0 | 5.0 | 10.0 | 0.5 | 0.0 |
718 | 718 | Marinhealth Medical Center | 50360 | 2022-12-09 | Marin | 41 | Bay Area | 0.5714285714285714 | 5.857142857142858 | 13.142857142857142 | 19.0 | 0.6917293233082706 | 0.0434782608695652 |
737 | 737 | Mills-peninsula Medical Center | 50007 | 2022-12-09 | San Mateo | 81 | Bay Area | 2.7142857142857144 | 3.7142857142857153 | 20.285714285714285 | 24.0 | 0.8452380952380952 | 0.1338028169014084 |
742 | 742 | Natividad Medical Center | 50248 | 2022-12-09 | Monterey | 53 | Bay Area | 0.0 | 3.1428571428571432 | 6.857142857142857 | 10.0 | 0.6857142857142857 | 0.0 |
743 | 743 | Northbay Medical Center | 50367 | 2022-12-09 | Solano | 95 | Bay Area | 2.7142857142857144 | 0.1428571428571423 | 23.857142857142858 | 24.0 | 0.9940476190476192 | 0.1137724550898203 |
746 | 746 | Novato Community Hospital | 50131 | 2022-12-09 | Marin | 41 | Bay Area | 0.0 | 2.2857142857142856 | 3.7142857142857135 | 6.0 | 0.6190476190476191 | 0.0 |
757 | 757 | Petaluma Valley Hospital | 50136 | 2022-12-09 | Sonoma | 97 | Bay Area | 0.0 | 1.714285714285714 | 3.571428571428572 | 5.285714285714286 | 0.6756756756756758 | 0.0 |
769 | 769 | Providence Queen of the Valley Medical Center | 50009 | 2022-12-09 | Napa | 55 | Bay Area | 0.8571428571428571 | 1.7142857142857153 | 10.571428571428571 | 12.285714285714286 | 0.8604651162790697 | 0.081081081081081 |
772 | 772 | Providence Santa Rosa Memorial Hospital | 50174 | 2022-12-09 | Sonoma | 97 | Bay Area | 3.142857142857143 | 8.285714285714285 | 17.714285714285715 | 26.0 | 0.6813186813186813 | 0.1774193548387096 |
777 | 777 | Regional Medical Center of San Jose | 50125 | 2022-12-09 | Santa Clara | 85 | Bay Area | 1.2857142857142858 | 0.7142857142857153 | 34.42857142857143 | 35.142857142857146 | 0.9796747967479674 | 0.0373443983402489 |
784 | 784 | Saint Francis Memorial Hospital | 50152 | 2022-12-09 | San Francisco | 75 | Bay Area | 1.5714285714285714 | 12.428571428571429 | 7.571428571428571 | 20.0 | 0.3785714285714285 | 0.2075471698113207 |
786 | 786 | Salinas Valley Memorial Hospital | 50334 | 2022-12-09 | Monterey | 53 | Bay Area | 1.7142857142857142 | 1.4285714285714288 | 12.142857142857142 | 13.571428571428571 | 0.8947368421052632 | 0.1411764705882353 |
792 | 792 | San Mateo Medical Center | 50113 | 2022-12-09 | San Mateo | 81 | Bay Area | 0.8571428571428571 | 1.1428571428571432 | 4.571428571428571 | 5.714285714285714 | 0.7999999999999999 | 0.1875 |
793 | 793 | San Ramon Regional Medical Center | 50689 | 2022-12-09 | Contra Costa | 13 | Bay Area | 1.0 | 4.428571428571429 | 7.571428571428571 | 12.0 | 0.6309523809523809 | 0.1320754716981132 |
795 | 795 | Santa Clara Valley Medical Center | 50038 | 2022-12-09 | Santa Clara | 85 | Bay Area | 4.714285714285714 | 28.142857142857142 | 59.85714285714285 | 88.0 | 0.6801948051948051 | 0.0787589498806682 |
803 | 803 | Sequoia Hospital | 50197 | 2022-12-09 | San Mateo | 81 | Bay Area | 0.0 | 6.0 | 7.0 | 13.0 | 0.5384615384615384 | 0.0 |
811 | 811 | Sonoma Specialty Hospital | 52057 | 2022-12-09 | Sonoma | 97 | Bay Area | 0.0 | 5.0 | 0.0 | 5.0 | 0.0 | |
812 | 812 | Sonoma Valley Hospital | 50090 | 2022-12-09 | Sonoma | 97 | Bay Area | 0.0 | 5.0 | 1.0 | 6.0 | 0.1666666666666666 | 0.0 |
823 | 823 | St. Mary's Medical Center | 50457 | 2022-12-09 | San Francisco | 75 | Bay Area | 0.8571428571428571 | 7.0 | 9.0 | 16.0 | 0.5625 | 0.0952380952380952 |
824 | 824 | St. Rose Hospital | 50002 | 2022-12-09 | Alameda | 1 | Bay Area | 0.0 | 8.571428571428571 | 3.4285714285714284 | 12.0 | 0.2857142857142857 | 0.0 |
825 | 825 | Stanford Health Care | 50441 | 2022-12-09 | Santa Clara | 85 | Bay Area | 15.714285714285714 | 1.0 | 107.85714285714286 | 108.85714285714286 | 0.9908136482939632 | 0.1456953642384106 |
826 | 826 | Stanford Health Care - Valleycare | 50283 | 2022-12-09 | Alameda | 1 | Bay Area | 0.6666666666666666 | 3.5 | 18.5 | 22.0 | 0.8409090909090909 | 0.036036036036036 |
831 | 831 | Sutter Delta Medical Center | 50523 | 2022-12-09 | Contra Costa | 13 | Bay Area | 0.0 | 2.428571428571429 | 9.571428571428571 | 12.0 | 0.7976190476190476 | 0.0 |
835 | 835 | Sutter Santa Rosa Regional Hospital | 50291 | 2022-12-09 | Sonoma | 97 | Bay Area | 0.5714285714285714 | 2.0 | 10.0 | 12.0 | 0.8333333333333334 | 0.0571428571428571 |
836 | 836 | Sutter Solano Medical Center | 50101 | 2022-12-09 | Solano | 95 | Bay Area | 0.7142857142857143 | 6.0 | 6.0 | 12.0 | 0.5 | 0.119047619047619 |
844 | 844 | UCSF Medical Center | 50454 | 2022-12-09 | San Francisco | 75 | Bay Area | 1.0 | 16.0 | 71.28571428571429 | 87.28571428571429 | 0.8166939443535188 | 0.0140280561122244 |
855 | 855 | Washington Hospital | 50195 | 2022-12-09 | Alameda | 1 | Bay Area | 2.857142857142857 | 8.714285714285715 | 19.285714285714285 | 28.0 | 0.6887755102040816 | 0.1481481481481481 |
861 | 861 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2022-12-09 | San Francisco | 75 | Bay Area | 1.5714285714285714 | 0.4285714285714306 | 39.285714285714285 | 39.71428571428572 | 0.9892086330935252 | 0.04 |
871 | 871 | Adventist Health St. Helena | 50013 | 2022-12-02 | Napa | 55 | Bay Area | 0.0 | 2.1428571428571423 | 6.571428571428571 | 8.714285714285714 | 0.7540983606557378 | 0.0 |
877 | 877 | Ahmc Seton Medical Center | 50289 | 2022-12-02 | San Mateo | 81 | Bay Area | 0.8571428571428571 | 0.4285714285714297 | 7.857142857142857 | 8.285714285714286 | 0.9482758620689654 | 0.109090909090909 |
878 | 878 | Alameda Hospital | 50211 | 2022-12-02 | Alameda | 1 | Bay Area | 0.0 | 0.7142857142857144 | 7.285714285714286 | 8.0 | 0.9107142857142856 | 0.0 |
880 | 880 | Alta Bates Summit Medical Center | 50043 | 2022-12-02 | Alameda | 1 | Bay Area | 2.571428571428572 | 16.857142857142858 | 19.142857142857142 | 36.0 | 0.5317460317460317 | 0.1343283582089552 |
881 | 881 | Alta Bates Summit Medical Center - Alta Bates Camp | 50305 | 2022-12-02 | Alameda | 1 | Bay Area | 1.2857142857142858 | 19.42857142857143 | 10.571428571428571 | 30.0 | 0.3523809523809523 | 0.1216216216216216 |
893 | 893 | California Pacific Medical Center - Mission Bernal | 50055 | 2022-12-02 | San Francisco | 75 | Bay Area | 0.0 | 3.2857142857142856 | 6.714285714285714 | 10.0 | 0.6714285714285715 | 0.0 |
894 | 894 | California Pacific Medical Center- Van Ness Campus | 50047 | 2022-12-02 | San Francisco | 75 | Bay Area | 3.4285714285714284 | 1.4285714285714306 | 34.57142857142857 | 36.0 | 0.9603174603174602 | 0.0991735537190082 |
895 | 895 | California Pacific Medical Ctr-davies Campus Hosp | 50008 | 2022-12-02 | San Francisco | 75 | Bay Area | 1.5714285714285714 | 0.8571428571428568 | 7.142857142857143 | 8.0 | 0.8928571428571429 | 0.2199999999999999 |
901 | 901 | Chinese Hospital | 50407 | 2022-12-02 | San Francisco | 75 | Bay Area | 0.0 | 2.4 | 3.6 | 6.0 | 0.6 | 0.0 |
909 | 909 | Community Hospital of the Monterey Peninsula | 50145 | 2022-12-02 | Monterey | 53 | Bay Area | 0.8571428571428571 | 14.142857142857142 | 11.857142857142858 | 26.0 | 0.4560439560439561 | 0.072289156626506 |
912 | 912 | Contra Costa Regional Medical Center | 50276 | 2022-12-02 | Contra Costa | 13 | Bay Area | 1.1428571428571428 | 3.8571428571428577 | 14.142857142857142 | 18.0 | 0.7857142857142857 | 0.0808080808080808 |
920 | 920 | Dominican Hospital | 50242 | 2022-12-02 | Santa Cruz | 87 | Bay Area | 2.4285714285714284 | 0.5714285714285712 | 13.571428571428571 | 14.142857142857142 | 0.9595959595959596 | 0.1789473684210526 |
922 | 922 | Eden Medical Center | 50488 | 2022-12-02 | Alameda | 1 | Bay Area | 0.8571428571428571 | 2.1428571428571423 | 21.857142857142858 | 24.0 | 0.9107142857142856 | 0.0392156862745098 |
924 | 924 | El Camino Hospital | 50308 | 2022-12-02 | Santa Clara | 85 | Bay Area | 4.285714285714286 | 3.571428571428573 | 28.428571428571427 | 32.0 | 0.8883928571428571 | 0.1507537688442211 |
940 | 940 | Good Samaritan Hospital | 50380 | 2022-12-02 | Santa Clara | 85 | Bay Area | 3.857142857142857 | 3.142857142857146 | 33.857142857142854 | 37.0 | 0.915057915057915 | 0.1139240506329114 |
944 | 944 | Healdsburg Hospital | 51321 | 2022-12-02 | Sonoma | 97 | Bay Area | 0.0 | 4.428571428571429 | 0.5714285714285714 | 5.0 | 0.1142857142857142 | 0.0 |
948 | 948 | Highland Hospital | 50320 | 2022-12-02 | Alameda | 1 | Bay Area | 0.7142857142857143 | 6.714285714285715 | 26.285714285714285 | 33.0 | 0.7965367965367965 | 0.0271739130434782 |
954 | 954 | John Muir Medical Center - Concord Campus | 50496 | 2022-12-02 | Contra Costa | 13 | Bay Area | 1.1428571428571428 | 6.285714285714285 | 29.714285714285715 | 36.0 | 0.8253968253968255 | 0.0384615384615384 |
955 | 955 | John Muir Medical Center - Walnut Creek Campus | 50180 | 2022-12-02 | Contra Costa | 13 | Bay Area | 3.4285714285714284 | 6.714285714285715 | 41.285714285714285 | 48.0 | 0.8601190476190476 | 0.0830449826989619 |
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 );