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 hospital
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
266 | 266 | Adventist Health Bakersfield | 50455 | 2022-12-16 | Kern | 29 | San Joaquin Valley | 0.5714285714285714 | 0.0 | 15.714285714285714 | 15.714285714285714 | 1.0 | 0.0363636363636363 |
562 | 562 | Adventist Health Bakersfield | 50455 | 2022-12-09 | Kern | 29 | San Joaquin Valley | 0.0 | 0.0 | 19.285714285714285 | 19.285714285714285 | 1.0 | 0.0 |
862 | 862 | Adventist Health Bakersfield | 50455 | 2022-12-02 | Kern | 29 | San Joaquin Valley | 1.7142857142857142 | 0.0 | 24.857142857142858 | 24.857142857142858 | 1.0 | 0.0689655172413793 |
1160 | 1160 | Adventist Health Bakersfield | 50455 | 2022-11-25 | Kern | 29 | San Joaquin Valley | 2.0 | 0.0 | 22.571428571428573 | 22.571428571428573 | 1.0 | 0.0886075949367088 |
1459 | 1459 | Adventist Health Bakersfield | 50455 | 2022-11-18 | Kern | 29 | San Joaquin Valley | 2.4285714285714284 | 0.0 | 21.0 | 21.0 | 1.0 | 0.1156462585034013 |
1757 | 1757 | Adventist Health Bakersfield | 50455 | 2022-11-11 | Kern | 29 | San Joaquin Valley | 1.8571428571428568 | 0.0 | 21.428571428571427 | 21.428571428571427 | 1.0 | 0.0866666666666666 |
2057 | 2057 | Adventist Health Bakersfield | 50455 | 2022-11-04 | Kern | 29 | San Joaquin Valley | 2.571428571428572 | 0.0 | 23.571428571428573 | 23.571428571428573 | 1.0 | 0.109090909090909 |
2356 | 2356 | Adventist Health Bakersfield | 50455 | 2022-10-28 | Kern | 29 | San Joaquin Valley | 1.7142857142857142 | 0.1428571428571459 | 25.428571428571427 | 25.571428571428573 | 0.9944134078212288 | 0.0674157303370786 |
2656 | 2656 | Adventist Health Bakersfield | 50455 | 2022-10-21 | Kern | 29 | San Joaquin Valley | 2.2857142857142856 | 0.0 | 18.714285714285715 | 18.714285714285715 | 1.0 | 0.1221374045801526 |
2956 | 2956 | Adventist Health Bakersfield | 50455 | 2022-10-14 | Kern | 29 | San Joaquin Valley | 1.4285714285714286 | 0.0 | 18.571428571428573 | 18.571428571428573 | 1.0 | 0.0769230769230769 |
3256 | 3256 | Adventist Health Bakersfield | 50455 | 2022-10-07 | Kern | 29 | San Joaquin Valley | 2.4285714285714284 | 0.0 | 19.428571428571427 | 19.428571428571427 | 1.0 | 0.125 |
3557 | 3557 | Adventist Health Bakersfield | 50455 | 2022-09-30 | Kern | 29 | San Joaquin Valley | 1.8571428571428568 | 0.0 | 16.285714285714285 | 16.285714285714285 | 1.0 | 0.1140350877192982 |
3859 | 3859 | Adventist Health Bakersfield | 50455 | 2022-09-23 | Kern | 29 | San Joaquin Valley | 2.142857142857143 | 0.0 | 16.142857142857142 | 16.142857142857142 | 1.0 | 0.1327433628318584 |
4160 | 4160 | Adventist Health Bakersfield | 50455 | 2022-09-16 | Kern | 29 | San Joaquin Valley | 2.2857142857142856 | 0.0 | 19.0 | 19.0 | 1.0 | 0.1203007518796992 |
4457 | 4457 | Adventist Health Bakersfield | 50455 | 2022-09-09 | Kern | 29 | San Joaquin Valley | 2.7142857142857144 | 0.0 | 17.714285714285715 | 17.714285714285715 | 1.0 | 0.1532258064516129 |
4754 | 4754 | Adventist Health Bakersfield | 50455 | 2022-09-02 | Kern | 29 | San Joaquin Valley | 1.0 | 0.0 | 16.0 | 16.0 | 1.0 | 0.0625 |
5050 | 5050 | Adventist Health Bakersfield | 50455 | 2022-08-26 | Kern | 29 | San Joaquin Valley | 0.0 | 0.0 | 15.428571428571429 | 15.428571428571429 | 1.0 | 0.0 |
5346 | 5346 | Adventist Health Bakersfield | 50455 | 2022-08-19 | Kern | 29 | San Joaquin Valley | 1.8571428571428568 | 0.0 | 19.0 | 19.0 | 1.0 | 0.0977443609022556 |
5648 | 5648 | Adventist Health Bakersfield | 50455 | 2022-08-12 | Kern | 29 | San Joaquin Valley | 5.571428571428571 | 0.0 | 24.714285714285715 | 24.714285714285715 | 1.0 | 0.2254335260115606 |
5951 | 5951 | Adventist Health Bakersfield | 50455 | 2022-08-05 | Kern | 29 | San Joaquin Valley | 4.714285714285714 | 0.0 | 21.714285714285715 | 21.714285714285715 | 1.0 | 0.2171052631578947 |
6254 | 6254 | Adventist Health Bakersfield | 50455 | 2022-07-29 | Kern | 29 | San Joaquin Valley | 6.571428571428571 | 0.0 | 20.857142857142858 | 20.857142857142858 | 1.0 | 0.3150684931506849 |
6554 | 6554 | Adventist Health Bakersfield | 50455 | 2022-07-22 | Kern | 29 | San Joaquin Valley | 6.142857142857143 | 0.0 | 18.0 | 18.0 | 1.0 | 0.3412698412698413 |
6853 | 6853 | Adventist Health Bakersfield | 50455 | 2022-07-15 | Kern | 29 | San Joaquin Valley | 6.285714285714286 | 0.0 | 19.714285714285715 | 19.714285714285715 | 1.0 | 0.3188405797101449 |
7152 | 7152 | Adventist Health Bakersfield | 50455 | 2022-07-08 | Kern | 29 | San Joaquin Valley | 3.7142857142857135 | 0.0 | 24.714285714285715 | 24.714285714285715 | 1.0 | 0.1502890173410404 |
7455 | 7455 | Adventist Health Bakersfield | 50455 | 2022-07-01 | Kern | 29 | San Joaquin Valley | 2.4285714285714284 | 0.0 | 26.428571428571427 | 26.428571428571427 | 1.0 | 0.0918918918918918 |
7753 | 7753 | Adventist Health Bakersfield | 50455 | 2022-06-24 | Kern | 29 | San Joaquin Valley | 2.0 | 0.0 | 22.285714285714285 | 22.285714285714285 | 1.0 | 0.0897435897435897 |
8051 | 8051 | Adventist Health Bakersfield | 50455 | 2022-06-17 | Kern | 29 | San Joaquin Valley | 1.2857142857142858 | 0.0 | 18.714285714285715 | 18.714285714285715 | 1.0 | 0.0687022900763358 |
8353 | 8353 | Adventist Health Bakersfield | 50455 | 2022-06-10 | Kern | 29 | San Joaquin Valley | 1.5714285714285714 | 0.0 | 23.0 | 23.0 | 1.0 | 0.0683229813664596 |
8654 | 8654 | Adventist Health Bakersfield | 50455 | 2022-06-03 | Kern | 29 | San Joaquin Valley | 2.571428571428572 | 0.0 | 19.285714285714285 | 19.285714285714285 | 1.0 | 0.1333333333333333 |
8955 | 8955 | Adventist Health Bakersfield | 50455 | 2022-05-27 | Kern | 29 | San Joaquin Valley | 1.1428571428571428 | 0.0 | 20.714285714285715 | 20.714285714285715 | 1.0 | 0.0551724137931034 |
9256 | 9256 | Adventist Health Bakersfield | 50455 | 2022-05-20 | Kern | 29 | San Joaquin Valley | 0.8571428571428571 | 0.0 | 16.0 | 16.0 | 1.0 | 0.0535714285714285 |
9555 | 9555 | Adventist Health Bakersfield | 50455 | 2022-05-13 | Kern | 29 | San Joaquin Valley | 0.5714285714285714 | 0.0 | 18.571428571428573 | 18.571428571428573 | 1.0 | 0.0307692307692307 |
9856 | 9856 | Adventist Health Bakersfield | 50455 | 2022-05-06 | Kern | 29 | San Joaquin Valley | 0.5714285714285714 | 0.0 | 17.285714285714285 | 17.285714285714285 | 1.0 | 0.0330578512396694 |
10157 | 10157 | Adventist Health Bakersfield | 50455 | 2022-04-29 | Kern | 29 | San Joaquin Valley | 0.7142857142857143 | 0.1428571428571423 | 18.571428571428573 | 18.714285714285715 | 0.9923664122137404 | 0.0384615384615384 |
10457 | 10457 | Adventist Health Bakersfield | 50455 | 2022-04-22 | Kern | 29 | San Joaquin Valley | 2.0 | 0.0 | 22.142857142857142 | 22.142857142857142 | 1.0 | 0.0903225806451613 |
10758 | 10758 | Adventist Health Bakersfield | 50455 | 2022-04-15 | Kern | 29 | San Joaquin Valley | 2.0 | 0.0 | 21.714285714285715 | 21.714285714285715 | 1.0 | 0.0921052631578947 |
11059 | 11059 | Adventist Health Bakersfield | 50455 | 2022-04-08 | Kern | 29 | San Joaquin Valley | 1.5714285714285714 | 0.0 | 19.142857142857142 | 19.142857142857142 | 1.0 | 0.0820895522388059 |
11361 | 11361 | Adventist Health Bakersfield | 50455 | 2022-04-01 | Kern | 29 | San Joaquin Valley | 1.4285714285714286 | 0.0 | 19.428571428571427 | 19.428571428571427 | 1.0 | 0.0735294117647058 |
11664 | 11664 | Adventist Health Bakersfield | 50455 | 2022-03-25 | Kern | 29 | San Joaquin Valley | 3.0 | 0.0 | 21.0 | 21.0 | 1.0 | 0.1428571428571428 |
11966 | 11966 | Adventist Health Bakersfield | 50455 | 2022-03-18 | Kern | 29 | San Joaquin Valley | 3.142857142857143 | 0.0 | 17.428571428571427 | 17.428571428571427 | 1.0 | 0.180327868852459 |
12271 | 12271 | Adventist Health Bakersfield | 50455 | 2022-03-11 | Kern | 29 | San Joaquin Valley | 4.428571428571429 | 0.0 | 20.714285714285715 | 20.714285714285715 | 1.0 | 0.2137931034482758 |
12576 | 12576 | Adventist Health Bakersfield | 50455 | 2022-03-04 | Kern | 29 | San Joaquin Valley | 5.428571428571429 | 1.8571428571428577 | 20.142857142857142 | 22.0 | 0.9155844155844156 | 0.2695035460992908 |
12879 | 12879 | Adventist Health Bakersfield | 50455 | 2022-02-25 | Kern | 29 | San Joaquin Valley | 5.428571428571429 | 0.0 | 24.285714285714285 | 24.285714285714285 | 1.0 | 0.2235294117647059 |
13183 | 13183 | Adventist Health Bakersfield | 50455 | 2022-02-18 | Kern | 29 | San Joaquin Valley | 8.285714285714286 | 0.0 | 26.714285714285715 | 26.714285714285715 | 1.0 | 0.3101604278074866 |
13488 | 13488 | Adventist Health Bakersfield | 50455 | 2022-02-11 | Kern | 29 | San Joaquin Valley | 10.571428571428571 | 0.0 | 28.0 | 28.0 | 1.0 | 0.3775510204081632 |
13793 | 13793 | Adventist Health Bakersfield | 50455 | 2022-02-04 | Kern | 29 | San Joaquin Valley | 15.142857142857142 | 0.0 | 28.857142857142858 | 28.857142857142858 | 1.0 | 0.5247524752475248 |
14098 | 14098 | Adventist Health Bakersfield | 50455 | 2022-01-28 | Kern | 29 | San Joaquin Valley | 14.428571428571429 | 0.0 | 29.142857142857142 | 29.142857142857142 | 1.0 | 0.4950980392156863 |
14403 | 14403 | Adventist Health Bakersfield | 50455 | 2022-01-21 | Kern | 29 | San Joaquin Valley | 15.714285714285714 | 5.142857142857142 | 24.714285714285715 | 29.857142857142858 | 0.8277511961722488 | 0.6358381502890172 |
14706 | 14706 | Adventist Health Bakersfield | 50455 | 2022-01-14 | Kern | 29 | San Joaquin Valley | 13.285714285714286 | 5.571428571428573 | 23.0 | 28.571428571428573 | 0.8049999999999999 | 0.577639751552795 |
15011 | 15011 | Adventist Health Bakersfield | 50455 | 2022-01-07 | Kern | 29 | San Joaquin Valley | 8.285714285714286 | 5.333333333333332 | 23.0 | 28.33333333333333 | 0.8117647058823529 | 0.3602484472049689 |
15316 | 15316 | Adventist Health Bakersfield | 50455 | 2021-12-31 | Kern | 29 | San Joaquin Valley | 5.0 | 4.714285714285715 | 23.0 | 27.714285714285715 | 0.8298969072164948 | 0.217391304347826 |
15620 | 15620 | Adventist Health Bakersfield | 50455 | 2021-12-24 | Kern | 29 | San Joaquin Valley | 7.714285714285714 | 3.1428571428571423 | 23.0 | 26.142857142857142 | 0.8797814207650273 | 0.3354037267080745 |
15922 | 15922 | Adventist Health Bakersfield | 50455 | 2021-12-17 | Kern | 29 | San Joaquin Valley | 9.285714285714286 | 5.428571428571427 | 23.0 | 28.428571428571427 | 0.8090452261306533 | 0.4037267080745342 |
16227 | 16227 | Adventist Health Bakersfield | 50455 | 2021-12-10 | Kern | 29 | San Joaquin Valley | 9.0 | 1.7142857142857153 | 23.0 | 24.714285714285715 | 0.9306358381502888 | 0.391304347826087 |
16533 | 16533 | Adventist Health Bakersfield | 50455 | 2021-12-03 | Kern | 29 | San Joaquin Valley | 9.142857142857142 | 0.1428571428571423 | 23.0 | 23.142857142857142 | 0.9938271604938272 | 0.3975155279503105 |
16839 | 16839 | Adventist Health Bakersfield | 50455 | 2021-11-26 | Kern | 29 | San Joaquin Valley | 7.0 | 0.2857142857142847 | 24.0 | 24.285714285714285 | 0.9882352941176472 | 0.2916666666666667 |
17143 | 17143 | Adventist Health Bakersfield | 50455 | 2021-11-19 | Kern | 29 | San Joaquin Valley | 8.857142857142858 | 0.0 | 25.142857142857142 | 25.142857142857142 | 1.0 | 0.3522727272727273 |
17447 | 17447 | Adventist Health Bakersfield | 50455 | 2021-11-12 | Kern | 29 | San Joaquin Valley | 9.714285714285714 | 0.0 | 26.285714285714285 | 26.285714285714285 | 1.0 | 0.3695652173913043 |
17751 | 17751 | Adventist Health Bakersfield | 50455 | 2021-11-05 | Kern | 29 | San Joaquin Valley | 11.571428571428571 | 1.142857142857146 | 28.428571428571427 | 29.571428571428573 | 0.9613526570048307 | 0.4070351758793969 |
18055 | 18055 | Adventist Health Bakersfield | 50455 | 2021-10-29 | Kern | 29 | San Joaquin Valley | 13.428571428571429 | 4.571428571428573 | 25.428571428571427 | 30.0 | 0.8476190476190476 | 0.5280898876404495 |
18361 | 18361 | Adventist Health Bakersfield | 50455 | 2021-10-22 | Kern | 29 | San Joaquin Valley | 20.142857142857142 | 2.7142857142857157 | 27.285714285714285 | 30.0 | 0.9095238095238096 | 0.7382198952879582 |
18667 | 18667 | Adventist Health Bakersfield | 50455 | 2021-10-15 | Kern | 29 | San Joaquin Valley | 20.571428571428573 | 1.8571428571428577 | 28.142857142857142 | 30.0 | 0.938095238095238 | 0.7309644670050762 |
18972 | 18972 | Adventist Health Bakersfield | 50455 | 2021-10-08 | Kern | 29 | San Joaquin Valley | 20.142857142857142 | 1.1428571428571423 | 28.857142857142858 | 30.0 | 0.961904761904762 | 0.698019801980198 |
19278 | 19278 | Adventist Health Bakersfield | 50455 | 2021-10-01 | Kern | 29 | San Joaquin Valley | 20.0 | 1.428571428571427 | 28.571428571428573 | 30.0 | 0.9523809523809524 | 0.7 |
19585 | 19585 | Adventist Health Bakersfield | 50455 | 2021-09-24 | Kern | 29 | San Joaquin Valley | 18.714285714285715 | 2.1428571428571423 | 27.857142857142858 | 30.0 | 0.9285714285714286 | 0.6717948717948719 |
19892 | 19892 | Adventist Health Bakersfield | 50455 | 2021-09-17 | Kern | 29 | San Joaquin Valley | 20.571428571428573 | 3.2857142857142847 | 26.714285714285715 | 30.0 | 0.8904761904761905 | 0.770053475935829 |
20198 | 20198 | Adventist Health Bakersfield | 50455 | 2021-09-10 | Kern | 29 | San Joaquin Valley | 20.714285714285715 | 2.2857142857142847 | 27.714285714285715 | 30.0 | 0.923809523809524 | 0.7474226804123711 |
20505 | 20505 | Adventist Health Bakersfield | 50455 | 2021-09-03 | Kern | 29 | San Joaquin Valley | 19.428571428571427 | 1.1428571428571423 | 28.857142857142858 | 30.0 | 0.961904761904762 | 0.6732673267326732 |
20811 | 20811 | Adventist Health Bakersfield | 50455 | 2021-08-27 | Kern | 29 | San Joaquin Valley | 15.857142857142858 | 2.571428571428573 | 27.428571428571427 | 30.0 | 0.9142857142857144 | 0.578125 |
21117 | 21117 | Adventist Health Bakersfield | 50455 | 2021-08-20 | Kern | 29 | San Joaquin Valley | 12.428571428571429 | 7.428571428571431 | 27.0 | 34.42857142857143 | 0.7842323651452282 | 0.4603174603174603 |
21422 | 21422 | Adventist Health Bakersfield | 50455 | 2021-08-13 | Kern | 29 | San Joaquin Valley | 9.714285714285714 | 8.285714285714285 | 25.714285714285715 | 34.0 | 0.7563025210084033 | 0.3777777777777777 |
21727 | 21727 | Adventist Health Bakersfield | 50455 | 2021-08-06 | Kern | 29 | San Joaquin Valley | 6.714285714285714 | 8.285714285714285 | 25.714285714285715 | 34.0 | 0.7563025210084033 | 0.2611111111111111 |
22033 | 22033 | Adventist Health Bakersfield | 50455 | 2021-07-30 | Kern | 29 | San Joaquin Valley | 4.285714285714286 | 8.857142857142858 | 25.142857142857142 | 34.0 | 0.7394957983193278 | 0.1704545454545454 |
22340 | 22340 | Adventist Health Bakersfield | 50455 | 2021-07-23 | Kern | 29 | San Joaquin Valley | 2.0 | 14.571428571428571 | 19.428571428571427 | 34.0 | 0.5714285714285714 | 0.1029411764705882 |
22645 | 22645 | Adventist Health Bakersfield | 50455 | 2021-07-16 | Kern | 29 | San Joaquin Valley | 1.7142857142857142 | 12.714285714285715 | 21.285714285714285 | 34.0 | 0.6260504201680672 | 0.0805369127516778 |
22951 | 22951 | Adventist Health Bakersfield | 50455 | 2021-07-09 | Kern | 29 | San Joaquin Valley | 0.0 | 9.285714285714285 | 24.714285714285715 | 34.0 | 0.7268907563025211 | 0.0 |
23258 | 23258 | Adventist Health Bakersfield | 50455 | 2021-07-02 | Kern | 29 | San Joaquin Valley | 0.8571428571428571 | 16.0 | 18.0 | 34.0 | 0.5294117647058824 | 0.0476190476190476 |
23563 | 23563 | Adventist Health Bakersfield | 50455 | 2021-06-25 | Kern | 29 | San Joaquin Valley | 1.0 | 16.714285714285715 | 17.285714285714285 | 34.0 | 0.5084033613445378 | 0.0578512396694214 |
23870 | 23870 | Adventist Health Bakersfield | 50455 | 2021-06-18 | Kern | 29 | San Joaquin Valley | 0.7142857142857143 | 15.285714285714285 | 18.714285714285715 | 34.0 | 0.5504201680672269 | 0.0381679389312977 |
24177 | 24177 | Adventist Health Bakersfield | 50455 | 2021-06-11 | Kern | 29 | San Joaquin Valley | 0.0 | 15.142857142857142 | 18.857142857142858 | 34.0 | 0.5546218487394958 | 0.0 |
24482 | 24482 | Adventist Health Bakersfield | 50455 | 2021-06-04 | Kern | 29 | San Joaquin Valley | 0.0 | 17.142857142857142 | 16.857142857142858 | 34.0 | 0.4957983193277311 | 0.0 |
24789 | 24789 | Adventist Health Bakersfield | 50455 | 2021-05-28 | Kern | 29 | San Joaquin Valley | 0.0 | 15.142857142857142 | 18.857142857142858 | 34.0 | 0.5546218487394958 | 0.0 |
25094 | 25094 | Adventist Health Bakersfield | 50455 | 2021-05-21 | Kern | 29 | San Joaquin Valley | 0.0 | 15.714285714285715 | 18.285714285714285 | 34.0 | 0.5378151260504201 | 0.0 |
25401 | 25401 | Adventist Health Bakersfield | 50455 | 2021-05-14 | Kern | 29 | San Joaquin Valley | 0.7142857142857143 | 15.857142857142858 | 18.142857142857142 | 34.0 | 0.5336134453781513 | 0.0393700787401574 |
25706 | 25706 | Adventist Health Bakersfield | 50455 | 2021-05-07 | Kern | 29 | San Joaquin Valley | 0.7142857142857143 | 15.714285714285715 | 19.714285714285715 | 35.42857142857143 | 0.5564516129032258 | 0.036231884057971 |
26007 | 26007 | Adventist Health Bakersfield | 50455 | 2021-04-30 | Kern | 29 | San Joaquin Valley | 0.0 | 11.142857142857142 | 16.571428571428573 | 27.714285714285715 | 0.5979381443298969 | 0.0 |
26315 | 26315 | Adventist Health Bakersfield | 50455 | 2021-04-23 | Kern | 29 | San Joaquin Valley | 0.8571428571428571 | 11.0 | 33.0 | 44.0 | 0.75 | 0.0259740259740259 |
26621 | 26621 | Adventist Health Bakersfield | 50455 | 2021-04-16 | Kern | 29 | San Joaquin Valley | 0.0 | 15.0 | 29.0 | 44.0 | 0.6590909090909091 | 0.0 |
26927 | 26927 | Adventist Health Bakersfield | 50455 | 2021-04-09 | Kern | 29 | San Joaquin Valley | 2.4285714285714284 | 17.428571428571427 | 26.571428571428573 | 44.0 | 0.6038961038961039 | 0.0913978494623655 |
27234 | 27234 | Adventist Health Bakersfield | 50455 | 2021-04-02 | Kern | 29 | San Joaquin Valley | 3.4285714285714284 | 16.142857142857142 | 27.857142857142858 | 44.0 | 0.6331168831168831 | 0.123076923076923 |
27538 | 27538 | Adventist Health Bakersfield | 50455 | 2021-03-26 | Kern | 29 | San Joaquin Valley | 4.857142857142857 | 9.142857142857146 | 34.857142857142854 | 44.0 | 0.7922077922077921 | 0.1393442622950819 |
27843 | 27843 | Adventist Health Bakersfield | 50455 | 2021-03-19 | Kern | 29 | San Joaquin Valley | 4.142857142857143 | 10.285714285714285 | 33.714285714285715 | 44.0 | 0.7662337662337663 | 0.1228813559322034 |
28149 | 28149 | Adventist Health Bakersfield | 50455 | 2021-03-12 | Kern | 29 | San Joaquin Valley | 5.428571428571429 | 12.285714285714285 | 31.714285714285715 | 44.0 | 0.7207792207792209 | 0.1711711711711711 |
28454 | 28454 | Adventist Health Bakersfield | 50455 | 2021-03-05 | Kern | 29 | San Joaquin Valley | 4.571428571428571 | 8.285714285714285 | 35.714285714285715 | 44.0 | 0.8116883116883117 | 0.128 |
28759 | 28759 | Adventist Health Bakersfield | 50455 | 2021-02-26 | Kern | 29 | San Joaquin Valley | 10.142857142857142 | 7.285714285714285 | 35.285714285714285 | 42.57142857142857 | 0.8288590604026845 | 0.2874493927125506 |
29064 | 29064 | Adventist Health Bakersfield | 50455 | 2021-02-19 | Kern | 29 | San Joaquin Valley | 12.428571428571429 | 6.571428571428569 | 37.42857142857143 | 44.0 | 0.8506493506493507 | 0.3320610687022901 |
29370 | 29370 | Adventist Health Bakersfield | 50455 | 2021-02-12 | Kern | 29 | San Joaquin Valley | 13.571428571428571 | 9.0 | 35.0 | 44.0 | 0.7954545454545454 | 0.3877551020408163 |
29677 | 29677 | Adventist Health Bakersfield | 50455 | 2021-02-05 | Kern | 29 | San Joaquin Valley | 9.142857142857142 | 8.42857142857143 | 35.57142857142857 | 44.0 | 0.8084415584415584 | 0.2570281124497992 |
29983 | 29983 | Adventist Health Bakersfield | 50455 | 2021-01-29 | Kern | 29 | San Joaquin Valley | 17.714285714285715 | 7.714285714285715 | 36.285714285714285 | 44.0 | 0.8246753246753247 | 0.4881889763779528 |
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 );