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 available_adult_icu_beds_total
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
32165 | 32165 | Cedars-Sinai Medical Center | 50625 | 2020-12-11 | Los Angeles | 37 | Southern California | 38.142857142857146 | -8.333333333333329 | 116.33333333333331 | 108.0 | 1.0771604938271604 | 0.3278755628325829 |
29713 | 29713 | Cedars-Sinai Medical Center | 50625 | 2021-02-05 | Los Angeles | 37 | Southern California | 32.142857142857146 | -7.5 | 111.5 | 104.0 | 1.0721153846153846 | 0.2882767456758488 |
37248 | 37248 | Salinas Valley Memorial Hospital | 50334 | 2020-08-21 | Monterey | 53 | Bay Area | 11.142857142857142 | -2.0 | 15.0 | 13.0 | 1.1538461538461535 | 0.7428571428571428 |
31052 | 31052 | Loma Linda University Medical Center-murrieta | 50770 | 2021-01-08 | Riverside | 65 | Southern California | 7.857142857142857 | -1.5 | 13.5 | 12.0 | 1.125 | 0.582010582010582 |
21254 | 21254 | Kindred Hospital Ontario | 52037 | 2021-08-20 | San Bernardino | 71 | Southern California | 0.0 | -1.2857142857142865 | 9.285714285714286 | 8.0 | 1.1607142857142858 | 0.0 |
19136 | 19136 | Memorial Hospital Los Banos | 50528 | 2021-10-08 | Merced | 47 | San Joaquin Valley | 3.571428571428572 | -1.1428571428571432 | 5.714285714285714 | 4.571428571428571 | 1.25 | 0.625 |
20776 | 20776 | Sutter Coast Hospital | 50417 | 2021-09-03 | Del Norte | 15 | Northern California | 5.714285714285714 | -1.1428571428571432 | 7.142857142857143 | 6.0 | 1.1904761904761905 | 0.7999999999999999 |
16697 | 16697 | Memorial Hospital Los Banos | 50528 | 2021-12-03 | Merced | 47 | San Joaquin Valley | 4.0 | -1.1428571428571423 | 5.571428571428571 | 4.428571428571429 | 1.258064516129032 | 0.717948717948718 |
157 | 157 | Mission Community Hospital | 50704 | 2022-12-23 | Los Angeles | 37 | Southern California | 5.75 | -1.0 | 11.0 | 10.0 | 1.1 | 0.5227272727272727 |
14566 | 14566 | Memorial Hospital Los Banos | 50528 | 2022-01-21 | Merced | 47 | San Joaquin Valley | 3.2857142857142856 | -1.0 | 5.142857142857143 | 4.142857142857143 | 1.2413793103448276 | 0.6388888888888888 |
28330 | 28330 | Monrovia Memorial Hospital | 52054 | 2021-03-12 | Los Angeles | 37 | Southern California | 0.0 | -1.0 | 5.0 | 4.0 | 1.25 | 0.0 |
31143 | 31143 | Scripps Memorial Hospital - Encinitas | 50503 | 2021-01-08 | San Diego | 73 | Southern California | 14.714285714285714 | -1.0 | 13.0 | 12.0 | 1.0833333333333333 | 1.1318681318681318 |
36638 | 36638 | Salinas Valley Memorial Hospital | 50334 | 2020-09-04 | Monterey | 53 | Bay Area | 12.0 | -1.0 | 14.0 | 13.0 | 1.0769230769230769 | 0.8571428571428571 |
36943 | 36943 | Salinas Valley Memorial Hospital | 50334 | 2020-08-28 | Monterey | 53 | Bay Area | 9.857142857142858 | -1.0 | 14.0 | 13.0 | 1.0769230769230769 | 0.7040816326530612 |
19442 | 19442 | Memorial Hospital Los Banos | 50528 | 2021-10-01 | Merced | 47 | San Joaquin Valley | 3.0 | -0.8571428571428568 | 4.857142857142857 | 4.0 | 1.2142857142857142 | 0.6176470588235294 |
20669 | 20669 | Memorial Hospital Los Banos | 50528 | 2021-09-03 | Merced | 47 | San Joaquin Valley | 3.571428571428572 | -0.8571428571428568 | 5.0 | 4.142857142857143 | 1.206896551724138 | 0.7142857142857143 |
21998 | 21998 | Sutter Coast Hospital | 50417 | 2021-08-06 | Del Norte | 15 | Northern California | 6.714285714285714 | -0.8571428571428568 | 7.285714285714286 | 6.428571428571429 | 1.1333333333333333 | 0.9215686274509804 |
28025 | 28025 | Monrovia Memorial Hospital | 52054 | 2021-03-19 | Los Angeles | 37 | Southern California | 0.0 | -0.8571428571428568 | 4.857142857142857 | 4.0 | 1.2142857142857142 | 0.0 |
17002 | 17002 | Memorial Hospital Los Banos | 50528 | 2021-11-26 | Merced | 47 | San Joaquin Valley | 2.2857142857142856 | -0.833333333333333 | 4.833333333333333 | 4.0 | 1.2083333333333333 | 0.4729064039408867 |
14071 | 14071 | Sutter Tracy Community Hospital | 50313 | 2022-02-04 | San Joaquin | 77 | San Joaquin Valley | 5.714285714285714 | -0.7142857142857153 | 9.428571428571429 | 8.714285714285714 | 1.0819672131147542 | 0.6060606060606061 |
14061 | 14061 | Sutter Amador Hospital | 50014 | 2022-02-04 | Amador | 5 | Greater Sacramento | 4.142857142857143 | -0.7142857142857144 | 7.142857142857143 | 6.428571428571429 | 1.1111111111111112 | 0.5800000000000001 |
29841 | 29841 | Memorial Hospital Los Banos | 50528 | 2021-02-05 | Merced | 47 | San Joaquin Valley | 3.7142857142857135 | -0.7142857142857144 | 5.0 | 4.285714285714286 | 1.1666666666666667 | 0.7428571428571429 |
32425 | 32425 | Valley Children's Hospital | 53300 | 2020-12-11 | Fresno | 19 | San Joaquin Valley | 0.8571428571428571 | -0.7142857142857144 | 4.428571428571429 | 3.7142857142857135 | 1.1923076923076923 | 0.1935483870967741 |
14262 | 14262 | Memorial Hospital Los Banos | 50528 | 2022-01-28 | Merced | 47 | San Joaquin Valley | 3.142857142857143 | -0.5714285714285712 | 5.857142857142857 | 5.285714285714286 | 1.108108108108108 | 0.5365853658536586 |
14870 | 14870 | Memorial Hospital Los Banos | 50528 | 2022-01-14 | Merced | 47 | San Joaquin Valley | 4.285714285714286 | -0.5714285714285712 | 5.285714285714286 | 4.714285714285714 | 1.121212121212121 | 0.8108108108108109 |
17609 | 17609 | Memorial Hospital Los Banos | 50528 | 2021-11-12 | Merced | 47 | San Joaquin Valley | 4.142857142857143 | -0.5714285714285712 | 4.714285714285714 | 4.142857142857143 | 1.1379310344827585 | 0.8787878787878789 |
19857 | 19857 | Sutter Coast Hospital | 50417 | 2021-09-24 | Del Norte | 15 | Northern California | 3.0 | -0.5714285714285712 | 6.571428571428571 | 6.0 | 1.0952380952380951 | 0.4565217391304348 |
20774 | 20774 | Sutter Amador Hospital | 50014 | 2021-09-03 | Amador | 5 | Greater Sacramento | 5.142857142857143 | -0.5714285714285712 | 6.571428571428571 | 6.0 | 1.0952380952380951 | 0.782608695652174 |
21281 | 21281 | Memorial Hospital Los Banos | 50528 | 2021-08-20 | Merced | 47 | San Joaquin Valley | 3.4285714285714284 | -0.5714285714285712 | 4.714285714285714 | 4.142857142857143 | 1.1379310344827585 | 0.7272727272727272 |
20468 | 20468 | Sutter Amador Hospital | 50014 | 2021-09-10 | Amador | 5 | Greater Sacramento | 5.142857142857143 | -0.5 | 8.0 | 7.5 | 1.0666666666666669 | 0.6428571428571429 |
15174 | 15174 | Memorial Hospital Los Banos | 50528 | 2022-01-07 | Merced | 47 | San Joaquin Valley | 3.857142857142857 | -0.4285714285714288 | 4.428571428571429 | 4.0 | 1.1071428571428572 | 0.8709677419354839 |
16391 | 16391 | Memorial Hospital Los Banos | 50528 | 2021-12-10 | Merced | 47 | San Joaquin Valley | 3.4285714285714284 | -0.4285714285714288 | 5.714285714285714 | 5.285714285714286 | 1.0810810810810811 | 0.6 |
17714 | 17714 | Sutter Amador Hospital | 50014 | 2021-11-12 | Amador | 5 | Greater Sacramento | 3.0 | -0.4285714285714288 | 6.428571428571429 | 6.0 | 1.0714285714285714 | 0.4666666666666667 |
20948 | 20948 | Kindred Hospital Ontario | 52037 | 2021-08-27 | San Bernardino | 71 | Southern California | 0.0 | -0.4285714285714288 | 8.428571428571429 | 8.0 | 1.0535714285714286 | 0.0 |
37349 | 37349 | Barstow Community Hospital | 50298 | 2020-08-14 | San Bernardino | 71 | Southern California | 1.1428571428571428 | -0.4285714285714288 | 5.142857142857143 | 4.714285714285714 | 1.090909090909091 | 0.2222222222222221 |
17305 | 17305 | Memorial Hospital Los Banos | 50528 | 2021-11-19 | Merced | 47 | San Joaquin Valley | 3.571428571428572 | -0.4285714285714279 | 5.571428571428571 | 5.142857142857143 | 1.0833333333333333 | 0.6410256410256411 |
19749 | 19749 | Memorial Hospital Los Banos | 50528 | 2021-09-24 | Merced | 47 | San Joaquin Valley | 3.7142857142857135 | -0.4285714285714279 | 4.571428571428571 | 4.142857142857143 | 1.1034482758620687 | 0.8125000000000001 |
14679 | 14679 | Sutter Tracy Community Hospital | 50313 | 2022-01-21 | San Joaquin | 77 | San Joaquin Valley | 4.857142857142857 | -0.428571428571427 | 8.714285714285714 | 8.285714285714286 | 1.0517241379310345 | 0.5573770491803278 |
20670 | 20670 | Memorial Hospital of Gardena | 50468 | 2021-09-03 | Los Angeles | 37 | Southern California | 5.4 | -0.4000000000000003 | 10.4 | 10.0 | 1.04 | 0.5192307692307693 |
29534 | 29534 | Memorial Hospital Los Banos | 50528 | 2021-02-12 | Merced | 47 | San Joaquin Valley | 3.571428571428572 | -0.4000000000000003 | 4.4 | 4.0 | 1.1 | 0.8116883116883117 |
21279 | 21279 | Marshall Medical Center | 50254 | 2021-08-20 | El Dorado | 17 | Greater Sacramento | 5.0 | -0.3333333333333339 | 10.0 | 9.666666666666666 | 1.0344827586206895 | 0.5 |
33038 | 33038 | Ventura County Medical Center | 50159 | 2020-11-27 | Ventura | 111 | Southern California | 2.2857142857142856 | -0.3333333333333339 | 8.333333333333334 | 8.0 | 1.0416666666666667 | 0.2742857142857142 |
30654 | 30654 | Dominican Hospital | 50242 | 2021-01-15 | Santa Cruz | 87 | Bay Area | 6.857142857142857 | -0.3333333333333321 | 17.0 | 16.666666666666668 | 1.02 | 0.4033613445378151 |
11895 | 11895 | San Joaquin General Hospital | 50167 | 2022-03-25 | San Joaquin | 77 | San Joaquin Valley | 1.2857142857142858 | -0.2857142857142882 | 17.714285714285715 | 17.428571428571427 | 1.016393442622951 | 0.0725806451612903 |
17541 | 17541 | Kaiser Foundation Hosp So Sacramento | 50674 | 2021-11-12 | Sacramento | 67 | Greater Sacramento | 8.0 | -0.2857142857142882 | 31.571428571428573 | 31.285714285714285 | 1.0091324200913243 | 0.253393665158371 |
14669 | 14669 | Sutter Amador Hospital | 50014 | 2022-01-21 | Amador | 5 | Greater Sacramento | 4.142857142857143 | -0.2857142857142856 | 6.428571428571429 | 6.142857142857143 | 1.0465116279069768 | 0.6444444444444445 |
18803 | 18803 | Kindred Hospital Ontario | 52037 | 2021-10-15 | San Bernardino | 71 | Southern California | 0.0 | -0.2857142857142856 | 7.285714285714286 | 7.0 | 1.0408163265306123 | 0.0 |
19722 | 19722 | Kindred Hospital Ontario | 52037 | 2021-09-24 | San Bernardino | 71 | Southern California | 0.0 | -0.2857142857142856 | 8.142857142857142 | 7.857142857142857 | 1.0363636363636364 | 0.0 |
20362 | 20362 | Memorial Hospital Los Banos | 50528 | 2021-09-10 | Merced | 47 | San Joaquin Valley | 2.857142857142857 | -0.2857142857142856 | 4.428571428571429 | 4.142857142857143 | 1.0689655172413792 | 0.6451612903225806 |
21692 | 21692 | Sutter Coast Hospital | 50417 | 2021-08-13 | Del Norte | 15 | Northern California | 5.857142857142857 | -0.2857142857142856 | 7.285714285714286 | 7.0 | 1.0408163265306123 | 0.8039215686274509 |
28635 | 28635 | Monrovia Memorial Hospital | 52054 | 2021-03-05 | Los Angeles | 37 | Southern California | 0.0 | -0.2857142857142856 | 4.285714285714286 | 4.0 | 1.0714285714285714 | 0.0 |
21321 | 21321 | Pomona Valley Hospital Medical Center | 50231 | 2021-08-20 | Los Angeles | 37 | Southern California | 12.714285714285714 | -0.2857142857142847 | 51.0 | 50.71428571428572 | 1.0056338028169014 | 0.2492997198879551 |
17682 | 17682 | Santa Clara Valley Medical Center | 50038 | 2021-11-12 | Santa Clara | 85 | Bay Area | 9.857142857142858 | -0.2857142857142776 | 66.57142857142857 | 66.28571428571429 | 1.004310344827586 | 0.148068669527897 |
21387 | 21387 | Sutter Coast Hospital | 50417 | 2021-08-20 | Del Norte | 15 | Northern California | 7.285714285714286 | -0.2000000000000001 | 7.8 | 7.6 | 1.0263157894736843 | 0.934065934065934 |
22898 | 22898 | Sonoma Specialty Hospital | 52057 | 2021-07-16 | Sonoma | 97 | Bay Area | 0.0 | -0.2000000000000001 | 5.0 | 4.8 | 1.0416666666666667 | 0.0 |
20976 | 20976 | Memorial Hospital of Gardena | 50468 | 2021-08-27 | Los Angeles | 37 | Southern California | 4.2 | -0.1999999999999993 | 11.0 | 10.8 | 1.0185185185185184 | 0.3818181818181818 |
29956 | 29956 | Sutter Tracy Community Hospital | 50313 | 2021-02-05 | San Joaquin | 77 | San Joaquin Valley | 4.142857142857143 | -0.1666666666666678 | 8.333333333333334 | 8.166666666666666 | 1.0204081632653064 | 0.4971428571428571 |
37312 | 37312 | Ventura County Medical Center | 50159 | 2020-08-21 | Ventura | 111 | Southern California | 5.5 | -0.1666666666666669 | 8.0 | 7.833333333333333 | 1.021276595744681 | 0.6875 |
29416 | 29416 | Community Hospital of Huntington Park | 50091 | 2021-02-12 | Los Angeles | 37 | Southern California | 6.5 | -0.166666666666666 | 10.666666666666666 | 10.5 | 1.0158730158730158 | 0.609375 |
13888 | 13888 | Kaiser Foundation Hosp So Sacramento | 50674 | 2022-02-04 | Sacramento | 67 | Greater Sacramento | 19.571428571428573 | -0.1428571428571459 | 32.42857142857143 | 32.285714285714285 | 1.004424778761062 | 0.6035242290748899 |
19815 | 19815 | San Antonio Regional Hospital | 50099 | 2021-09-24 | San Bernardino | 71 | Southern California | 11.857142857142858 | -0.1428571428571459 | 33.142857142857146 | 33.0 | 1.0043290043290043 | 0.3577586206896551 |
4288 | 4288 | Kindred Hospital - Los Angeles | 52032 | 2022-09-16 | Los Angeles | 37 | Southern California | 0.0 | -0.1428571428571432 | 5.142857142857143 | 5.0 | 1.0285714285714287 | 0.0 |
19855 | 19855 | Sutter Amador Hospital | 50014 | 2021-09-24 | Amador | 5 | Greater Sacramento | 5.0 | -0.1428571428571432 | 6.142857142857143 | 6.0 | 1.023809523809524 | 0.813953488372093 |
21655 | 21655 | San Mateo Medical Center | 50113 | 2021-08-13 | San Mateo | 81 | Bay Area | 0.5714285714285714 | -0.1428571428571432 | 5.0 | 4.857142857142857 | 1.0294117647058825 | 0.1142857142857142 |
28008 | 28008 | Memorial Hospital Los Banos | 50528 | 2021-03-19 | Merced | 47 | San Joaquin Valley | 2.7142857142857144 | -0.1428571428571432 | 4.714285714285714 | 4.571428571428571 | 1.03125 | 0.5757575757575758 |
28940 | 28940 | Monrovia Memorial Hospital | 52054 | 2021-02-26 | Los Angeles | 37 | Southern California | 0.0 | -0.1428571428571432 | 5.0 | 4.857142857142857 | 1.0294117647058825 | 0.0 |
33254 | 33254 | Pioneers Memorial Healthcare District | 50342 | 2020-11-20 | Imperial | 25 | Southern California | 4.142857142857143 | -0.1428571428571432 | 8.0 | 7.857142857142857 | 1.0181818181818183 | 0.5178571428571429 |
9426 | 9426 | Mercy Medical Center Mt Shasta | 51319 | 2022-05-20 | Siskiyou | 93 | Northern California | 0.0 | -0.1428571428571429 | 0.7142857142857143 | 0.5714285714285714 | 1.25 | 0.0 |
6612 | 6612 | East Los Angeles Doctors Hospital | 50641 | 2022-07-22 | Los Angeles | 37 | Southern California | 0.0 | -0.1428571428571428 | 3.2857142857142856 | 3.142857142857143 | 1.0454545454545454 | 0.0 |
14693 | 14693 | Valley Children's Hospital | 53300 | 2022-01-21 | Fresno | 19 | San Joaquin Valley | 0.0 | -0.1428571428571428 | 2.142857142857143 | 2.0 | 1.0714285714285714 | 0.0 |
403 | 403 | Kindred Hospital Westminster | 52035 | 2022-12-16 | Orange | 59 | Southern California | 0.0 | -0.1428571428571423 | 12.142857142857142 | 12.0 | 1.011904761904762 | 0.0 |
2485 | 2485 | Kindred Hospital - Los Angeles | 52032 | 2022-10-28 | Los Angeles | 37 | Southern California | 0.0 | -0.1428571428571423 | 4.857142857142857 | 4.714285714285714 | 1.0303030303030305 | 0.0 |
10179 | 10179 | Antelope Valley Hospital | 50056 | 2022-04-29 | Los Angeles | 37 | Southern California | 0.0 | -0.1428571428571423 | 28.714285714285715 | 28.571428571428573 | 1.005 | 0.0 |
12130 | 12130 | Memorial Hospital of Gardena | 50468 | 2022-03-18 | Los Angeles | 37 | Southern California | 0.0 | -0.1428571428571423 | 9.428571428571429 | 9.285714285714286 | 1.015384615384615 | 0.0 |
16790 | 16790 | Southwest Healthcare System | 50701 | 2021-12-03 | Riverside | 65 | Southern California | 9.142857142857142 | -0.1428571428571423 | 25.285714285714285 | 25.142857142857142 | 1.005681818181818 | 0.3615819209039548 |
17325 | 17325 | Natividad Medical Center | 50248 | 2021-11-19 | Monterey | 53 | Bay Area | 0.0 | -0.1428571428571423 | 8.428571428571429 | 8.285714285714286 | 1.0172413793103448 | 0.0 |
18630 | 18630 | Sutter Amador Hospital | 50014 | 2021-10-22 | Amador | 5 | Greater Sacramento | 5.142857142857143 | -0.1428571428571423 | 6.285714285714286 | 6.142857142857143 | 1.0232558139534882 | 0.8181818181818182 |
20243 | 20243 | Community Hospital of Huntington Park | 50091 | 2021-09-10 | Los Angeles | 37 | Southern California | 2.857142857142857 | -0.1428571428571423 | 5.571428571428571 | 5.428571428571429 | 1.026315789473684 | 0.5128205128205129 |
28279 | 28279 | Kern Medical Center | 50315 | 2021-03-12 | Kern | 29 | San Joaquin Valley | 5.0 | -0.1428571428571423 | 24.857142857142858 | 24.714285714285715 | 1.0057803468208093 | 0.2011494252873563 |
30736 | 30736 | Kindred Hospital South Bay | 52050 | 2021-01-15 | Los Angeles | 37 | Southern California | 4.714285714285714 | -0.1428571428571423 | 9.142857142857142 | 9.0 | 1.0158730158730158 | 0.515625 |
32815 | 32815 | Fountain Valley Regional Hospital & Medical Center | 50570 | 2020-11-27 | Orange | 59 | Southern California | 13.0 | -0.1428571428571423 | 26.857142857142858 | 26.714285714285715 | 1.0053475935828875 | 0.4840425531914893 |
1 | 1 | Adventist Health Bakersfield | 50455 | 2022-12-23 | Kern | 29 | San Joaquin Valley | 0.0 | 0.0 | 14.0 | 14.0 | 1.0 | 0.0 |
2 | 2 | Adventist Health Clearlake | 51317 | 2022-12-23 | Lake | 33 | Northern California | 0.0 | 0.0 | 4.0 | 4.0 | 1.0 | 0.0 |
5 | 5 | Adventist Health Lodi Memorial | 50336 | 2022-12-23 | San Joaquin | 77 | San Joaquin Valley | 4.0 | 0.0 | 10.0 | 10.0 | 1.0 | 0.4 |
6 | 6 | Adventist Health Mendocino Coast | 51325 | 2022-12-23 | Mendocino | 45 | Northern California | 0.0 | 0.0 | 4.0 | 4.0 | 1.0 | 0.0 |
9 | 9 | Adventist Health St. Helena | 50013 | 2022-12-23 | Napa | 55 | Bay Area | 0.0 | 0.0 | 7.0 | 7.0 | 1.0 | 0.0 |
10 | 10 | Adventist Health Tehachapi Valley | 51301 | 2022-12-23 | Kern | 29 | San Joaquin Valley | 0.0 | 0.0 | 4.0 | 4.0 | 1.0 | 0.0 |
12 | 12 | Adventist Health Ukiah Valley | 50301 | 2022-12-23 | Mendocino | 45 | Northern California | 0.0 | 0.0 | 8.0 | 8.0 | 1.0 | 0.0 |
14 | 14 | Ahmc Anaheim Regional Medical Center | 50226 | 2022-12-23 | Orange | 59 | Southern California | 0.0 | 0.0 | 10.0 | 10.0 | 1.0 | 0.0 |
15 | 15 | Ahmc Seton Medical Center | 50289 | 2022-12-23 | San Mateo | 81 | Bay Area | 0.0 | 0.0 | 11.0 | 11.0 | 1.0 | 0.0 |
16 | 16 | Alameda Hospital | 50211 | 2022-12-23 | Alameda | 1 | Bay Area | 1.0 | 0.0 | 8.0 | 8.0 | 1.0 | 0.125 |
20 | 20 | Alvarado Hospital Medical Center | 50757 | 2022-12-23 | San Diego | 73 | Southern California | 0.0 | 0.0 | 11.0 | 11.0 | 1.0 | 0.0 |
22 | 22 | Antelope Valley Hospital | 50056 | 2022-12-23 | Los Angeles | 37 | Southern California | 7.0 | 0.0 | 28.0 | 28.0 | 1.0 | 0.25 |
24 | 24 | Bakersfield Memorial Hospital | 50036 | 2022-12-23 | Kern | 29 | San Joaquin Valley | 5.0 | 0.0 | 26.0 | 26.0 | 1.0 | 0.1923076923076923 |
30 | 30 | California Pacific Medical Ctr-davies Campus Hosp | 50008 | 2022-12-23 | San Francisco | 75 | Bay Area | 0.0 | 0.0 | 8.0 | 8.0 | 1.0 | 0.0 |
33 | 33 | Cedars-Sinai Medical Center | 50625 | 2022-12-23 | Los Angeles | 37 | Southern California | 12.0 | 0.0 | 108.0 | 108.0 | 1.0 | 0.1111111111111111 |
34 | 34 | Centinela Hospital Medical Center | 50739 | 2022-12-23 | Los Angeles | 37 | Southern California | 0.0 | 0.0 | 23.0 | 23.0 | 1.0 | 0.0 |
36 | 36 | Chino Valley Medical Center | 50586 | 2022-12-23 | San Bernardino | 71 | Southern California | 0.0 | 0.0 | 6.0 | 6.0 | 1.0 | 0.0 |
41 | 41 | Community Hospital of Huntington Park | 50091 | 2022-12-23 | Los Angeles | 37 | Southern California | 0.0 | 0.0 | 4.0 | 4.0 | 1.0 | 0.0 |
47 | 47 | Dameron Hospital | 50122 | 2022-12-23 | San Joaquin | 77 | San Joaquin Valley | 0.0 | 0.0 | 11.0 | 11.0 | 1.0 | 0.0 |
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 );