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 ccn
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
30557 | 30557 | St. Rose Hospital | 50002 | 2021-01-22 | Alameda | 1 | Bay Area | 7.142857142857143 | 3.1428571428571423 | 11.428571428571429 | 14.571428571428571 | 0.7843137254901961 | 0.625 |
30862 | 30862 | St. Rose Hospital | 50002 | 2021-01-15 | Alameda | 1 | Bay Area | 8.714285714285714 | 3.571428571428571 | 11.428571428571429 | 15.0 | 0.761904761904762 | 0.7625 |
31168 | 31168 | St. Rose Hospital | 50002 | 2021-01-08 | Alameda | 1 | Bay Area | 10.142857142857142 | 2.2857142857142865 | 12.714285714285714 | 15.0 | 0.8476190476190476 | 0.7977528089887641 |
31476 | 31476 | St. Rose Hospital | 50002 | 2021-01-01 | Alameda | 1 | Bay Area | 7.0 | 4.428571428571429 | 10.571428571428571 | 15.0 | 0.7047619047619047 | 0.6621621621621622 |
31783 | 31783 | St. Rose Hospital | 50002 | 2020-12-25 | Alameda | 1 | Bay Area | 4.857142857142857 | 5.7142857142857135 | 9.285714285714286 | 15.0 | 0.6190476190476191 | 0.523076923076923 |
32089 | 32089 | St. Rose Hospital | 50002 | 2020-12-18 | Alameda | 1 | Bay Area | 7.0 | 5.0 | 10.0 | 15.0 | 0.6666666666666666 | 0.7 |
32398 | 32398 | St. Rose Hospital | 50002 | 2020-12-11 | Alameda | 1 | Bay Area | 6.428571428571429 | 3.428571428571429 | 11.571428571428571 | 15.0 | 0.7714285714285715 | 0.5555555555555556 |
32705 | 32705 | St. Rose Hospital | 50002 | 2020-12-04 | Alameda | 1 | Bay Area | 5.857142857142857 | 3.428571428571429 | 11.571428571428571 | 15.0 | 0.7714285714285715 | 0.5061728395061729 |
33010 | 33010 | St. Rose Hospital | 50002 | 2020-11-27 | Alameda | 1 | Bay Area | 4.571428571428571 | 4.428571428571429 | 10.571428571428571 | 15.0 | 0.7047619047619047 | 0.4324324324324324 |
33315 | 33315 | St. Rose Hospital | 50002 | 2020-11-20 | Alameda | 1 | Bay Area | 2.857142857142857 | 6.428571428571429 | 8.571428571428571 | 15.0 | 0.5714285714285714 | 0.3333333333333333 |
33621 | 33621 | St. Rose Hospital | 50002 | 2020-11-13 | Alameda | 1 | Bay Area | 2.142857142857143 | 5.857142857142858 | 9.142857142857142 | 15.0 | 0.6095238095238095 | 0.234375 |
33927 | 33927 | St. Rose Hospital | 50002 | 2020-11-06 | Alameda | 1 | Bay Area | 3.142857142857143 | 6.285714285714287 | 8.714285714285714 | 15.0 | 0.5809523809523809 | 0.360655737704918 |
34233 | 34233 | St. Rose Hospital | 50002 | 2020-10-30 | Alameda | 1 | Bay Area | 2.2857142857142856 | 8.428571428571429 | 6.571428571428571 | 15.0 | 0.4380952380952381 | 0.3478260869565217 |
34539 | 34539 | St. Rose Hospital | 50002 | 2020-10-23 | Alameda | 1 | Bay Area | 1.7142857142857142 | 10.142857142857142 | 4.857142857142857 | 15.0 | 0.3238095238095237 | 0.3529411764705882 |
34845 | 34845 | St. Rose Hospital | 50002 | 2020-10-16 | Alameda | 1 | Bay Area | 1.7142857142857142 | 7.857142857142857 | 7.142857142857143 | 15.0 | 0.4761904761904762 | 0.2399999999999999 |
35149 | 35149 | St. Rose Hospital | 50002 | 2020-10-09 | Alameda | 1 | Bay Area | 1.7142857142857142 | 9.0 | 6.0 | 15.0 | 0.4 | 0.2857142857142857 |
35454 | 35454 | St. Rose Hospital | 50002 | 2020-10-02 | Alameda | 1 | Bay Area | 1.4285714285714286 | 5.857142857142858 | 9.142857142857142 | 15.0 | 0.6095238095238095 | 0.15625 |
35761 | 35761 | St. Rose Hospital | 50002 | 2020-09-25 | Alameda | 1 | Bay Area | 2.4285714285714284 | 9.428571428571429 | 5.571428571428571 | 15.0 | 0.3714285714285714 | 0.4358974358974359 |
36065 | 36065 | St. Rose Hospital | 50002 | 2020-09-18 | Alameda | 1 | Bay Area | 4.285714285714286 | 6.857142857142858 | 8.142857142857142 | 15.0 | 0.5428571428571428 | 0.5263157894736842 |
36370 | 36370 | St. Rose Hospital | 50002 | 2020-09-11 | Alameda | 1 | Bay Area | 3.571428571428572 | 8.142857142857142 | 6.857142857142857 | 15.0 | 0.4571428571428571 | 0.5208333333333334 |
36674 | 36674 | St. Rose Hospital | 50002 | 2020-09-04 | Alameda | 1 | Bay Area | 3.2857142857142856 | 8.571428571428571 | 6.428571428571429 | 15.0 | 0.4285714285714286 | 0.5111111111111111 |
36979 | 36979 | St. Rose Hospital | 50002 | 2020-08-28 | Alameda | 1 | Bay Area | 1.7142857142857142 | 8.714285714285715 | 6.285714285714286 | 15.0 | 0.419047619047619 | 0.2727272727272727 |
37284 | 37284 | St. Rose Hospital | 50002 | 2020-08-21 | Alameda | 1 | Bay Area | 1.1428571428571428 | 7.857142857142857 | 7.142857142857143 | 15.0 | 0.4761904761904762 | 0.1599999999999999 |
37590 | 37590 | St. Rose Hospital | 50002 | 2020-08-14 | Alameda | 1 | Bay Area | 2.0 | 7.857142857142857 | 7.142857142857143 | 15.0 | 0.4761904761904762 | 0.2799999999999999 |
37895 | 37895 | St. Rose Hospital | 50002 | 2020-08-07 | Alameda | 1 | Bay Area | 2.0 | 10.0 | 5.0 | 15.0 | 0.3333333333333333 | 0.4 |
38198 | 38198 | St. Rose Hospital | 50002 | 2020-07-31 | Alameda | 1 | Bay Area | 2.7142857142857144 | 10.428571428571429 | 4.571428571428571 | 15.0 | 0.3047619047619047 | 0.5937500000000001 |
38525 | 38525 | St. Rose Hospital | 50002 | 2020-07-24 | Alameda | 1 | Bay Area | 3.571428571428572 | 12.000000000000002 | 14.714285714285714 | 26.714285714285715 | 0.5508021390374331 | 0.2427184466019417 |
38811 | 38811 | St. Rose Hospital | 50002 | 2020-07-17 | Alameda | 1 | Bay Area | 0.0 | 9.0 | 6.0 | 15.0 | 0.4 | 0.0 |
189 | 189 | Providence St. Joseph Hospital | 50006 | 2022-12-23 | Humboldt | 23 | Northern California | 0.0 | 0.0 | 12.0 | 12.0 | 1.0 | 0.0 |
475 | 475 | Providence St. Joseph Hospital | 50006 | 2022-12-16 | Humboldt | 23 | Northern California | 0.0 | 2.714285714285713 | 9.285714285714286 | 12.0 | 0.7738095238095238 | 0.0 |
773 | 773 | Providence St. Joseph Hospital | 50006 | 2022-12-09 | Humboldt | 23 | Northern California | 1.1428571428571428 | 3.7142857142857135 | 8.285714285714286 | 12.0 | 0.6904761904761906 | 0.1379310344827586 |
1072 | 1072 | Providence St. Joseph Hospital | 50006 | 2022-12-02 | Humboldt | 23 | Northern California | 0.7142857142857143 | 3.428571428571429 | 8.571428571428571 | 12.0 | 0.7142857142857143 | 0.0833333333333333 |
1371 | 1371 | Providence St. Joseph Hospital | 50006 | 2022-11-25 | Humboldt | 23 | Northern California | 0.0 | 3.571428571428571 | 8.428571428571429 | 12.0 | 0.7023809523809524 | 0.0 |
1670 | 1670 | Providence St. Joseph Hospital | 50006 | 2022-11-18 | Humboldt | 23 | Northern California | 0.5714285714285714 | 3.1428571428571423 | 8.857142857142858 | 12.0 | 0.7380952380952381 | 0.064516129032258 |
1969 | 1969 | Providence St. Joseph Hospital | 50006 | 2022-11-11 | Humboldt | 23 | Northern California | 0.0 | 1.5714285714285712 | 10.428571428571429 | 12.0 | 0.8690476190476191 | 0.0 |
2268 | 2268 | Providence St. Joseph Hospital | 50006 | 2022-11-04 | Humboldt | 23 | Northern California | 1.5714285714285714 | 2.428571428571429 | 9.571428571428571 | 12.0 | 0.7976190476190476 | 0.1641791044776119 |
2568 | 2568 | Providence St. Joseph Hospital | 50006 | 2022-10-28 | Humboldt | 23 | Northern California | 1.2857142857142858 | 3.2857142857142865 | 8.714285714285714 | 12.0 | 0.7261904761904762 | 0.1475409836065574 |
2868 | 2868 | Providence St. Joseph Hospital | 50006 | 2022-10-21 | Humboldt | 23 | Northern California | 1.5714285714285714 | 1.7142857142857135 | 10.285714285714286 | 12.0 | 0.8571428571428572 | 0.1527777777777777 |
3168 | 3168 | Providence St. Joseph Hospital | 50006 | 2022-10-14 | Humboldt | 23 | Northern California | 0.0 | 3.571428571428571 | 8.428571428571429 | 12.0 | 0.7023809523809524 | 0.0 |
3468 | 3468 | Providence St. Joseph Hospital | 50006 | 2022-10-07 | Humboldt | 23 | Northern California | 0.0 | 4.714285714285714 | 7.285714285714286 | 12.0 | 0.6071428571428571 | 0.0 |
3770 | 3770 | Providence St. Joseph Hospital | 50006 | 2022-09-30 | Humboldt | 23 | Northern California | 0.0 | 4.0 | 8.0 | 12.0 | 0.6666666666666666 | 0.0 |
4071 | 4071 | Providence St. Joseph Hospital | 50006 | 2022-09-23 | Humboldt | 23 | Northern California | 0.0 | 5.285714285714286 | 6.714285714285714 | 12.0 | 0.5595238095238095 | 0.0 |
4369 | 4369 | Providence St. Joseph Hospital | 50006 | 2022-09-16 | Humboldt | 23 | Northern California | 2.2857142857142856 | 2.571428571428571 | 9.428571428571429 | 12.0 | 0.7857142857142857 | 0.2424242424242424 |
4666 | 4666 | Providence St. Joseph Hospital | 50006 | 2022-09-09 | Humboldt | 23 | Northern California | 2.571428571428572 | 0.4285714285714288 | 11.571428571428571 | 12.0 | 0.9642857142857144 | 0.2222222222222222 |
4962 | 4962 | Providence St. Joseph Hospital | 50006 | 2022-09-02 | Humboldt | 23 | Northern California | 0.8571428571428571 | 1.2857142857142865 | 10.714285714285714 | 12.0 | 0.8928571428571428 | 0.08 |
5258 | 5258 | Providence St. Joseph Hospital | 50006 | 2022-08-26 | Humboldt | 23 | Northern California | 0.0 | 2.1428571428571423 | 9.857142857142858 | 12.0 | 0.8214285714285715 | 0.0 |
5558 | 5558 | Providence St. Joseph Hospital | 50006 | 2022-08-19 | Humboldt | 23 | Northern California | 1.5714285714285714 | 1.4285714285714288 | 10.571428571428571 | 12.0 | 0.8809523809523809 | 0.1486486486486486 |
5862 | 5862 | Providence St. Joseph Hospital | 50006 | 2022-08-12 | Humboldt | 23 | Northern California | 0.0 | 1.8571428571428577 | 10.142857142857142 | 12.0 | 0.8452380952380952 | 0.0 |
6164 | 6164 | Providence St. Joseph Hospital | 50006 | 2022-08-05 | Humboldt | 23 | Northern California | 0.0 | 2.1428571428571423 | 9.857142857142858 | 12.0 | 0.8214285714285715 | 0.0 |
6465 | 6465 | Providence St. Joseph Hospital | 50006 | 2022-07-29 | Humboldt | 23 | Northern California | 0.5714285714285714 | 3.428571428571429 | 8.571428571428571 | 12.0 | 0.7142857142857143 | 0.0666666666666666 |
6764 | 6764 | Providence St. Joseph Hospital | 50006 | 2022-07-22 | Humboldt | 23 | Northern California | 0.7142857142857143 | 4.0 | 8.0 | 12.0 | 0.6666666666666666 | 0.0892857142857142 |
7063 | 7063 | Providence St. Joseph Hospital | 50006 | 2022-07-15 | Humboldt | 23 | Northern California | 1.5714285714285714 | 4.0 | 8.0 | 12.0 | 0.6666666666666666 | 0.1964285714285714 |
7365 | 7365 | Providence St. Joseph Hospital | 50006 | 2022-07-08 | Humboldt | 23 | Northern California | 0.0 | 3.571428571428571 | 8.428571428571429 | 12.0 | 0.7023809523809524 | 0.0 |
7664 | 7664 | Providence St. Joseph Hospital | 50006 | 2022-07-01 | Humboldt | 23 | Northern California | 1.0 | 5.0 | 7.0 | 12.0 | 0.5833333333333334 | 0.1428571428571428 |
7962 | 7962 | Providence St. Joseph Hospital | 50006 | 2022-06-24 | Humboldt | 23 | Northern California | 0.5714285714285714 | 6.142857142857143 | 5.857142857142857 | 12.0 | 0.4880952380952381 | 0.0975609756097561 |
8263 | 8263 | Providence St. Joseph Hospital | 50006 | 2022-06-17 | Humboldt | 23 | Northern California | 0.8571428571428571 | 5.571428571428571 | 6.428571428571429 | 12.0 | 0.5357142857142857 | 0.1333333333333333 |
8564 | 8564 | Providence St. Joseph Hospital | 50006 | 2022-06-10 | Humboldt | 23 | Northern California | 0.8571428571428571 | 1.2857142857142865 | 10.714285714285714 | 12.0 | 0.8928571428571428 | 0.08 |
8865 | 8865 | Providence St. Joseph Hospital | 50006 | 2022-06-03 | Humboldt | 23 | Northern California | 0.5714285714285714 | 2.2857142857142865 | 9.714285714285714 | 12.0 | 0.8095238095238094 | 0.0588235294117647 |
9166 | 9166 | Providence St. Joseph Hospital | 50006 | 2022-05-27 | Humboldt | 23 | Northern California | 0.7142857142857143 | 2.428571428571429 | 9.571428571428571 | 12.0 | 0.7976190476190476 | 0.0746268656716418 |
9466 | 9466 | Providence St. Joseph Hospital | 50006 | 2022-05-20 | Humboldt | 23 | Northern California | 1.4285714285714286 | 3.2857142857142865 | 8.714285714285714 | 12.0 | 0.7261904761904762 | 0.1639344262295082 |
9766 | 9766 | Providence St. Joseph Hospital | 50006 | 2022-05-13 | Humboldt | 23 | Northern California | 0.0 | 2.2857142857142865 | 9.714285714285714 | 12.0 | 0.8095238095238094 | 0.0 |
10067 | 10067 | Providence St. Joseph Hospital | 50006 | 2022-05-06 | Humboldt | 23 | Northern California | 0.0 | 2.0 | 10.0 | 12.0 | 0.8333333333333334 | 0.0 |
10368 | 10368 | Providence St. Joseph Hospital | 50006 | 2022-04-29 | Humboldt | 23 | Northern California | 0.0 | 3.2857142857142865 | 8.714285714285714 | 12.0 | 0.7261904761904762 | 0.0 |
10669 | 10669 | Providence St. Joseph Hospital | 50006 | 2022-04-22 | Humboldt | 23 | Northern California | 0.0 | 2.0 | 10.0 | 12.0 | 0.8333333333333334 | 0.0 |
10970 | 10970 | Providence St. Joseph Hospital | 50006 | 2022-04-15 | Humboldt | 23 | Northern California | 0.0 | 1.5714285714285712 | 10.428571428571429 | 12.0 | 0.8690476190476191 | 0.0 |
11270 | 11270 | Providence St. Joseph Hospital | 50006 | 2022-04-08 | Humboldt | 23 | Northern California | 0.0 | 1.8571428571428577 | 10.142857142857142 | 12.0 | 0.8452380952380952 | 0.0 |
11573 | 11573 | Providence St. Joseph Hospital | 50006 | 2022-04-01 | Humboldt | 23 | Northern California | 0.0 | 1.7142857142857135 | 10.285714285714286 | 12.0 | 0.8571428571428572 | 0.0 |
11877 | 11877 | Providence St. Joseph Hospital | 50006 | 2022-03-25 | Humboldt | 23 | Northern California | 0.5714285714285714 | 2.1428571428571423 | 9.857142857142858 | 12.0 | 0.8214285714285715 | 0.0579710144927536 |
12180 | 12180 | Providence St. Joseph Hospital | 50006 | 2022-03-18 | Humboldt | 23 | Northern California | 0.0 | 4.428571428571429 | 7.571428571428571 | 12.0 | 0.6309523809523809 | 0.0 |
12486 | 12486 | Providence St. Joseph Hospital | 50006 | 2022-03-11 | Humboldt | 23 | Northern California | 0.0 | 2.714285714285713 | 9.285714285714286 | 12.0 | 0.7738095238095238 | 0.0 |
12789 | 12789 | Providence St. Joseph Hospital | 50006 | 2022-03-04 | Humboldt | 23 | Northern California | 0.8571428571428571 | 1.8571428571428577 | 10.142857142857142 | 12.0 | 0.8452380952380952 | 0.0845070422535211 |
13092 | 13092 | Providence St. Joseph Hospital | 50006 | 2022-02-25 | Humboldt | 23 | Northern California | 1.0 | 3.7142857142857135 | 8.285714285714286 | 12.0 | 0.6904761904761906 | 0.1206896551724137 |
13397 | 13397 | Providence St. Joseph Hospital | 50006 | 2022-02-18 | Humboldt | 23 | Northern California | 1.7142857142857142 | 4.857142857142857 | 7.142857142857143 | 12.0 | 0.5952380952380952 | 0.2399999999999999 |
13702 | 13702 | Providence St. Joseph Hospital | 50006 | 2022-02-11 | Humboldt | 23 | Northern California | 2.4285714285714284 | 0.8571428571428577 | 11.142857142857142 | 12.0 | 0.9285714285714284 | 0.2179487179487179 |
14007 | 14007 | Providence St. Joseph Hospital | 50006 | 2022-02-04 | Humboldt | 23 | Northern California | 1.8571428571428568 | 2.0 | 10.0 | 12.0 | 0.8333333333333334 | 0.1857142857142857 |
14312 | 14312 | Providence St. Joseph Hospital | 50006 | 2022-01-28 | Humboldt | 23 | Northern California | 1.4285714285714286 | 3.0 | 9.0 | 12.0 | 0.75 | 0.1587301587301587 |
14616 | 14616 | Providence St. Joseph Hospital | 50006 | 2022-01-21 | Humboldt | 23 | Northern California | 2.571428571428572 | 3.0 | 9.0 | 12.0 | 0.75 | 0.2857142857142857 |
14921 | 14921 | Providence St. Joseph Hospital | 50006 | 2022-01-14 | Humboldt | 23 | Northern California | 3.0 | 1.4285714285714288 | 10.571428571428571 | 12.0 | 0.8809523809523809 | 0.2837837837837837 |
15225 | 15225 | Providence St. Joseph Hospital | 50006 | 2022-01-07 | Humboldt | 23 | Northern California | 1.4285714285714286 | 4.166666666666667 | 7.833333333333333 | 12.0 | 0.6527777777777778 | 0.182370820668693 |
15530 | 15530 | Providence St. Joseph Hospital | 50006 | 2021-12-31 | Humboldt | 23 | Northern California | 1.8571428571428568 | 3.0 | 9.0 | 12.0 | 0.75 | 0.2063492063492063 |
15833 | 15833 | Providence St. Joseph Hospital | 50006 | 2021-12-24 | Humboldt | 23 | Northern California | 0.7142857142857143 | 4.571428571428571 | 7.428571428571429 | 12.0 | 0.6190476190476191 | 0.0961538461538461 |
16136 | 16136 | Providence St. Joseph Hospital | 50006 | 2021-12-17 | Humboldt | 23 | Northern California | 1.4285714285714286 | 3.0 | 9.0 | 12.0 | 0.75 | 0.1587301587301587 |
16442 | 16442 | Providence St. Joseph Hospital | 50006 | 2021-12-10 | Humboldt | 23 | Northern California | 2.7142857142857144 | 1.7142857142857135 | 10.285714285714286 | 12.0 | 0.8571428571428572 | 0.2638888888888889 |
16748 | 16748 | Providence St. Joseph Hospital | 50006 | 2021-12-03 | Humboldt | 23 | Northern California | 3.142857142857143 | 2.428571428571429 | 9.571428571428571 | 12.0 | 0.7976190476190476 | 0.3283582089552239 |
17053 | 17053 | Providence St. Joseph Hospital | 50006 | 2021-11-26 | Humboldt | 23 | Northern California | 2.571428571428572 | 2.8571428571428577 | 9.142857142857142 | 12.0 | 0.7619047619047619 | 0.28125 |
17356 | 17356 | Providence St. Joseph Hospital | 50006 | 2021-11-19 | Humboldt | 23 | Northern California | 2.7142857142857144 | 2.571428571428571 | 9.428571428571429 | 12.0 | 0.7857142857142857 | 0.2878787878787879 |
17660 | 17660 | Providence St. Joseph Hospital | 50006 | 2021-11-12 | Humboldt | 23 | Northern California | 2.2857142857142856 | 0.5714285714285712 | 11.428571428571429 | 12.0 | 0.9523809523809524 | 0.1999999999999999 |
17964 | 17964 | Providence St. Joseph Hospital | 50006 | 2021-11-05 | Humboldt | 23 | Northern California | 3.0 | 0.5714285714285712 | 11.428571428571429 | 12.0 | 0.9523809523809524 | 0.2625 |
18270 | 18270 | Providence St. Joseph Hospital | 50006 | 2021-10-29 | Humboldt | 23 | Northern California | 1.4285714285714286 | 1.7142857142857135 | 10.285714285714286 | 12.0 | 0.8571428571428572 | 0.1388888888888889 |
18576 | 18576 | Providence St. Joseph Hospital | 50006 | 2021-10-22 | Humboldt | 23 | Northern California | 1.8571428571428568 | 0.5714285714285712 | 11.428571428571429 | 12.0 | 0.9523809523809524 | 0.1625 |
18881 | 18881 | Providence St. Joseph Hospital | 50006 | 2021-10-15 | Humboldt | 23 | Northern California | 3.142857142857143 | 1.0 | 11.0 | 12.0 | 0.9166666666666666 | 0.2857142857142857 |
19187 | 19187 | Providence St. Joseph Hospital | 50006 | 2021-10-08 | Humboldt | 23 | Northern California | 2.857142857142857 | 1.7142857142857135 | 10.285714285714286 | 12.0 | 0.8571428571428572 | 0.2777777777777778 |
19494 | 19494 | Providence St. Joseph Hospital | 50006 | 2021-10-01 | Humboldt | 23 | Northern California | 2.571428571428572 | 4.285714285714286 | 7.714285714285714 | 12.0 | 0.6428571428571429 | 0.3333333333333333 |
19801 | 19801 | Providence St. Joseph Hospital | 50006 | 2021-09-24 | Humboldt | 23 | Northern California | 1.5714285714285714 | 2.428571428571429 | 9.571428571428571 | 12.0 | 0.7976190476190476 | 0.1641791044776119 |
20107 | 20107 | Providence St. Joseph Hospital | 50006 | 2021-09-17 | Humboldt | 23 | Northern California | 1.0 | 2.8571428571428577 | 9.142857142857142 | 12.0 | 0.7619047619047619 | 0.109375 |
20414 | 20414 | Providence St. Joseph Hospital | 50006 | 2021-09-10 | Humboldt | 23 | Northern California | 0.8571428571428571 | 3.1428571428571423 | 8.857142857142858 | 12.0 | 0.7380952380952381 | 0.096774193548387 |
20720 | 20720 | Providence St. Joseph Hospital | 50006 | 2021-09-03 | Humboldt | 23 | Northern California | 4.428571428571429 | 1.7142857142857135 | 10.285714285714286 | 12.0 | 0.8571428571428572 | 0.4305555555555555 |
21026 | 21026 | Providence St. Joseph Hospital | 50006 | 2021-08-27 | Humboldt | 23 | Northern California | 7.428571428571429 | 1.4285714285714288 | 10.571428571428571 | 12.0 | 0.8809523809523809 | 0.7027027027027027 |
21331 | 21331 | Providence St. Joseph Hospital | 50006 | 2021-08-20 | Humboldt | 23 | Northern California | 7.285714285714286 | 2.714285714285713 | 13.714285714285714 | 16.428571428571427 | 0.8347826086956522 | 0.53125 |
21636 | 21636 | Providence St. Joseph Hospital | 50006 | 2021-08-13 | Humboldt | 23 | Northern California | 7.428571428571429 | 1.428571428571427 | 16.571428571428573 | 18.0 | 0.9206349206349208 | 0.4482758620689654 |
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 );