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)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
30290 | 30290 | Adventist Health Bakersfield | 50455 | 2021-01-22 | Kern | 29 | San Joaquin Valley | 18.571428571428573 | 5.714285714285708 | 36.142857142857146 | 41.85714285714285 | 0.8634812286689422 | 0.5138339920948617 |
30596 | 30596 | Adventist Health Bakersfield | 50455 | 2021-01-15 | Kern | 29 | San Joaquin Valley | 21.714285714285715 | 5.857142857142854 | 38.142857142857146 | 44.0 | 0.8668831168831169 | 0.5692883895131086 |
30901 | 30901 | Adventist Health Bakersfield | 50455 | 2021-01-08 | Kern | 29 | San Joaquin Valley | 22.571428571428573 | 3.2857142857142847 | 35.57142857142857 | 38.85714285714285 | 0.9154411764705882 | 0.6345381526104419 |
31207 | 31207 | Adventist Health Bakersfield | 50455 | 2021-01-01 | Kern | 29 | San Joaquin Valley | 20.571428571428573 | 0.7142857142857153 | 28.428571428571427 | 29.142857142857142 | 0.9754901960784312 | 0.7236180904522614 |
31516 | 31516 | Adventist Health Bakersfield | 50455 | 2020-12-25 | Kern | 29 | San Joaquin Valley | 17.142857142857142 | 0.0 | 28.428571428571427 | 28.428571428571427 | 1.0 | 0.6030150753768845 |
31822 | 31822 | Adventist Health Bakersfield | 50455 | 2020-12-18 | Kern | 29 | San Joaquin Valley | 15.428571428571429 | 3.5714285714285694 | 26.571428571428573 | 30.142857142857142 | 0.8815165876777252 | 0.5806451612903225 |
32129 | 32129 | Adventist Health Bakersfield | 50455 | 2020-12-11 | Kern | 29 | San Joaquin Valley | 17.857142857142858 | 3.2857142857142847 | 30.0 | 33.285714285714285 | 0.9012875536480688 | 0.5952380952380952 |
32438 | 32438 | Adventist Health Bakersfield | 50455 | 2020-12-04 | Kern | 29 | San Joaquin Valley | 14.142857142857142 | 5.428571428571431 | 25.142857142857142 | 30.571428571428573 | 0.822429906542056 | 0.5625 |
32744 | 32744 | Adventist Health Bakersfield | 50455 | 2020-11-27 | Kern | 29 | San Joaquin Valley | 12.142857142857142 | 12.857142857142858 | 23.142857142857142 | 36.0 | 0.6428571428571428 | 0.5246913580246914 |
33049 | 33049 | Adventist Health Bakersfield | 50455 | 2020-11-20 | Kern | 29 | San Joaquin Valley | 8.571428571428571 | 14.0 | 22.0 | 36.0 | 0.6111111111111112 | 0.3896103896103896 |
33354 | 33354 | Adventist Health Bakersfield | 50455 | 2020-11-13 | Kern | 29 | San Joaquin Valley | 7.0 | 14.0 | 22.0 | 36.0 | 0.6111111111111112 | 0.3181818181818182 |
33660 | 33660 | Adventist Health Bakersfield | 50455 | 2020-11-06 | Kern | 29 | San Joaquin Valley | 5.857142857142857 | 17.428571428571427 | 18.571428571428573 | 36.0 | 0.5158730158730159 | 0.3153846153846153 |
33966 | 33966 | Adventist Health Bakersfield | 50455 | 2020-10-30 | Kern | 29 | San Joaquin Valley | 6.857142857142857 | 13.0 | 23.0 | 36.0 | 0.6388888888888888 | 0.2981366459627329 |
34272 | 34272 | Adventist Health Bakersfield | 50455 | 2020-10-23 | Kern | 29 | San Joaquin Valley | 8.714285714285714 | 11.714285714285715 | 24.285714285714285 | 36.0 | 0.6746031746031745 | 0.3588235294117647 |
34578 | 34578 | Adventist Health Bakersfield | 50455 | 2020-10-16 | Kern | 29 | San Joaquin Valley | 6.857142857142857 | 11.142857142857142 | 24.857142857142858 | 36.0 | 0.6904761904761905 | 0.2758620689655172 |
34884 | 34884 | Adventist Health Bakersfield | 50455 | 2020-10-09 | Kern | 29 | San Joaquin Valley | 7.428571428571429 | 10.142857142857142 | 25.857142857142858 | 36.0 | 0.7182539682539683 | 0.287292817679558 |
35188 | 35188 | Adventist Health Bakersfield | 50455 | 2020-10-02 | Kern | 29 | San Joaquin Valley | 8.428571428571429 | 12.142857142857142 | 23.857142857142858 | 36.0 | 0.6626984126984127 | 0.3532934131736527 |
35493 | 35493 | Adventist Health Bakersfield | 50455 | 2020-09-25 | Kern | 29 | San Joaquin Valley | 9.142857142857142 | 8.571428571428573 | 27.428571428571427 | 36.0 | 0.7619047619047619 | 0.3333333333333333 |
35800 | 35800 | Adventist Health Bakersfield | 50455 | 2020-09-18 | Kern | 29 | San Joaquin Valley | 11.0 | 8.571428571428573 | 27.428571428571427 | 36.0 | 0.7619047619047619 | 0.4010416666666667 |
36103 | 36103 | Adventist Health Bakersfield | 50455 | 2020-09-11 | Kern | 29 | San Joaquin Valley | 6.857142857142857 | 12.428571428571429 | 23.571428571428573 | 36.0 | 0.6547619047619048 | 0.2909090909090909 |
36408 | 36408 | Adventist Health Bakersfield | 50455 | 2020-09-04 | Kern | 29 | San Joaquin Valley | 13.571428571428571 | 11.285714285714285 | 24.714285714285715 | 36.0 | 0.6865079365079365 | 0.5491329479768786 |
36712 | 36712 | Adventist Health Bakersfield | 50455 | 2020-08-28 | Kern | 29 | San Joaquin Valley | 17.571428571428573 | 7.571428571428573 | 28.428571428571427 | 36.0 | 0.7896825396825397 | 0.6180904522613067 |
37017 | 37017 | Adventist Health Bakersfield | 50455 | 2020-08-21 | Kern | 29 | San Joaquin Valley | 20.714285714285715 | 7.571428571428573 | 28.428571428571427 | 36.0 | 0.7896825396825397 | 0.7286432160804021 |
37322 | 37322 | Adventist Health Bakersfield | 50455 | 2020-08-14 | Kern | 29 | San Joaquin Valley | 26.285714285714285 | 3.7142857142857153 | 32.285714285714285 | 36.0 | 0.8968253968253967 | 0.8141592920353983 |
37628 | 37628 | Adventist Health Bakersfield | 50455 | 2020-08-07 | Kern | 29 | San Joaquin Valley | 26.285714285714285 | 3.7142857142857153 | 32.285714285714285 | 36.0 | 0.8968253968253967 | 0.8141592920353983 |
37932 | 37932 | Adventist Health Bakersfield | 50455 | 2020-07-31 | Kern | 29 | San Joaquin Valley | 26.5 | 7.833333333333332 | 28.166666666666668 | 36.0 | 0.7824074074074074 | 0.9408284023668638 |
38237 | 38237 | Adventist Health Bakersfield | 50455 | 2020-07-24 | Kern | 29 | San Joaquin Valley | 24.142857142857142 | 7.857142857142858 | 28.142857142857142 | 36.0 | 0.7817460317460317 | 0.8578680203045685 |
38567 | 38567 | Adventist Health Bakersfield | 50455 | 2020-07-17 | Kern | 29 | San Joaquin Valley | 21.33333333333333 | 4.0 | 32.0 | 36.0 | 0.8888888888888888 | 0.6666666666666666 |
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 |
267 | 267 | Adventist Health Clearlake | 51317 | 2022-12-16 | Lake | 33 | Northern California | 0.0 | 0.1428571428571428 | 3.857142857142857 | 4.0 | 0.9642857142857144 | 0.0 |
563 | 563 | Adventist Health Clearlake | 51317 | 2022-12-09 | Lake | 33 | Northern California | 0.0 | 0.0 | 4.0 | 4.0 | 1.0 | 0.0 |
863 | 863 | Adventist Health Clearlake | 51317 | 2022-12-02 | Lake | 33 | Northern California | 0.0 | 0.2857142857142856 | 3.7142857142857135 | 4.0 | 0.9285714285714286 | 0.0 |
1161 | 1161 | Adventist Health Clearlake | 51317 | 2022-11-25 | Lake | 33 | Northern California | 0.0 | 0.0 | 4.0 | 4.0 | 1.0 | 0.0 |
1460 | 1460 | Adventist Health Clearlake | 51317 | 2022-11-18 | Lake | 33 | Northern California | 0.8571428571428571 | 0.0 | 4.0 | 4.0 | 1.0 | 0.2142857142857142 |
1758 | 1758 | Adventist Health Clearlake | 51317 | 2022-11-11 | Lake | 33 | Northern California | 0.0 | 0.2857142857142856 | 3.7142857142857135 | 4.0 | 0.9285714285714286 | 0.0 |
2058 | 2058 | Adventist Health Clearlake | 51317 | 2022-11-04 | Lake | 33 | Northern California | 1.0 | 0.0 | 4.0 | 4.0 | 1.0 | 0.25 |
2357 | 2357 | Adventist Health Clearlake | 51317 | 2022-10-28 | Lake | 33 | Northern California | 1.0 | 0.0 | 4.0 | 4.0 | 1.0 | 0.25 |
2657 | 2657 | Adventist Health Clearlake | 51317 | 2022-10-21 | Lake | 33 | Northern California | 0.7142857142857143 | 0.0 | 4.0 | 4.0 | 1.0 | 0.1785714285714285 |
2957 | 2957 | Adventist Health Clearlake | 51317 | 2022-10-14 | Lake | 33 | Northern California | 0.0 | 0.7142857142857144 | 3.2857142857142856 | 4.0 | 0.8214285714285714 | 0.0 |
3257 | 3257 | Adventist Health Clearlake | 51317 | 2022-10-07 | Lake | 33 | Northern California | 0.0 | 0.0 | 4.0 | 4.0 | 1.0 | 0.0 |
3558 | 3558 | Adventist Health Clearlake | 51317 | 2022-09-30 | Lake | 33 | Northern California | 0.0 | 0.2857142857142856 | 3.7142857142857135 | 4.0 | 0.9285714285714286 | 0.0 |
3860 | 3860 | Adventist Health Clearlake | 51317 | 2022-09-23 | Lake | 33 | Northern California | 0.0 | 1.2857142857142856 | 2.571428571428572 | 3.857142857142857 | 0.6666666666666667 | 0.0 |
4161 | 4161 | Adventist Health Clearlake | 51317 | 2022-09-16 | Lake | 33 | Northern California | 0.0 | 0.7142857142857144 | 3.2857142857142856 | 4.0 | 0.8214285714285714 | 0.0 |
4458 | 4458 | Adventist Health Clearlake | 51317 | 2022-09-09 | Lake | 33 | Northern California | 0.0 | 0.7142857142857144 | 3.2857142857142856 | 4.0 | 0.8214285714285714 | 0.0 |
4755 | 4755 | Adventist Health Clearlake | 51317 | 2022-09-02 | Lake | 33 | Northern California | 0.0 | 0.2857142857142856 | 3.7142857142857135 | 4.0 | 0.9285714285714286 | 0.0 |
5051 | 5051 | Adventist Health Clearlake | 51317 | 2022-08-26 | Lake | 33 | Northern California | 0.0 | 1.0 | 3.0 | 4.0 | 0.75 | 0.0 |
5347 | 5347 | Adventist Health Clearlake | 51317 | 2022-08-19 | Lake | 33 | Northern California | 0.0 | 2.571428571428571 | 1.4285714285714286 | 4.0 | 0.3571428571428571 | 0.0 |
5649 | 5649 | Adventist Health Clearlake | 51317 | 2022-08-12 | Lake | 33 | Northern California | 0.7142857142857143 | 0.4285714285714284 | 3.571428571428572 | 4.0 | 0.8928571428571429 | 0.1999999999999999 |
5952 | 5952 | Adventist Health Clearlake | 51317 | 2022-08-05 | Lake | 33 | Northern California | 0.7142857142857143 | 0.0 | 4.0 | 4.0 | 1.0 | 0.1785714285714285 |
6255 | 6255 | Adventist Health Clearlake | 51317 | 2022-07-29 | Lake | 33 | Northern California | 0.8571428571428571 | 0.0 | 4.0 | 4.0 | 1.0 | 0.2142857142857142 |
6555 | 6555 | Adventist Health Clearlake | 51317 | 2022-07-22 | Lake | 33 | Northern California | 0.5714285714285714 | 0.2857142857142856 | 3.7142857142857135 | 4.0 | 0.9285714285714286 | 0.1538461538461538 |
6854 | 6854 | Adventist Health Clearlake | 51317 | 2022-07-15 | Lake | 33 | Northern California | 0.0 | 0.7142857142857144 | 3.2857142857142856 | 4.0 | 0.8214285714285714 | 0.0 |
7153 | 7153 | Adventist Health Clearlake | 51317 | 2022-07-08 | Lake | 33 | Northern California | 0.0 | 0.1428571428571428 | 3.857142857142857 | 4.0 | 0.9642857142857144 | 0.0 |
7456 | 7456 | Adventist Health Clearlake | 51317 | 2022-07-01 | Lake | 33 | Northern California | 0.0 | 1.1428571428571428 | 2.857142857142857 | 4.0 | 0.7142857142857143 | 0.0 |
7754 | 7754 | Adventist Health Clearlake | 51317 | 2022-06-24 | Lake | 33 | Northern California | 0.0 | 0.4285714285714284 | 3.571428571428572 | 4.0 | 0.8928571428571429 | 0.0 |
8052 | 8052 | Adventist Health Clearlake | 51317 | 2022-06-17 | Lake | 33 | Northern California | 0.7142857142857143 | 0.5714285714285716 | 3.4285714285714284 | 4.0 | 0.8571428571428571 | 0.2083333333333333 |
8354 | 8354 | Adventist Health Clearlake | 51317 | 2022-06-10 | Lake | 33 | Northern California | 0.0 | 1.1428571428571428 | 2.857142857142857 | 4.0 | 0.7142857142857143 | 0.0 |
8655 | 8655 | Adventist Health Clearlake | 51317 | 2022-06-03 | Lake | 33 | Northern California | 2.2857142857142856 | 0.1428571428571428 | 3.857142857142857 | 4.0 | 0.9642857142857144 | 0.5925925925925926 |
8956 | 8956 | Adventist Health Clearlake | 51317 | 2022-05-27 | Lake | 33 | Northern California | 0.0 | 0.7142857142857144 | 3.2857142857142856 | 4.0 | 0.8214285714285714 | 0.0 |
9257 | 9257 | Adventist Health Clearlake | 51317 | 2022-05-20 | Lake | 33 | Northern California | 0.8571428571428571 | 0.2857142857142856 | 3.7142857142857135 | 4.0 | 0.9285714285714286 | 0.2307692307692307 |
9556 | 9556 | Adventist Health Clearlake | 51317 | 2022-05-13 | Lake | 33 | Northern California | 0.0 | 0.4285714285714288 | 3.7142857142857135 | 4.142857142857143 | 0.8965517241379309 | 0.0 |
9857 | 9857 | Adventist Health Clearlake | 51317 | 2022-05-06 | Lake | 33 | Northern California | 0.0 | 0.1428571428571428 | 3.857142857142857 | 4.0 | 0.9642857142857144 | 0.0 |
10158 | 10158 | Adventist Health Clearlake | 51317 | 2022-04-29 | Lake | 33 | Northern California | 0.0 | 0.4285714285714284 | 3.571428571428572 | 4.0 | 0.8928571428571429 | 0.0 |
10458 | 10458 | Adventist Health Clearlake | 51317 | 2022-04-22 | Lake | 33 | Northern California | 0.0 | 0.8571428571428572 | 3.142857142857143 | 4.0 | 0.7857142857142857 | 0.0 |
10759 | 10759 | Adventist Health Clearlake | 51317 | 2022-04-15 | Lake | 33 | Northern California | 0.8571428571428571 | 0.2857142857142856 | 3.7142857142857135 | 4.0 | 0.9285714285714286 | 0.2307692307692307 |
11060 | 11060 | Adventist Health Clearlake | 51317 | 2022-04-08 | Lake | 33 | Northern California | 0.0 | 0.1428571428571428 | 3.857142857142857 | 4.0 | 0.9642857142857144 | 0.0 |
11362 | 11362 | Adventist Health Clearlake | 51317 | 2022-04-01 | Lake | 33 | Northern California | 0.0 | 0.2857142857142856 | 3.7142857142857135 | 4.0 | 0.9285714285714286 | 0.0 |
11665 | 11665 | Adventist Health Clearlake | 51317 | 2022-03-25 | Lake | 33 | Northern California | 0.0 | 0.1428571428571428 | 3.857142857142857 | 4.0 | 0.9642857142857144 | 0.0 |
11967 | 11967 | Adventist Health Clearlake | 51317 | 2022-03-18 | Lake | 33 | Northern California | 0.0 | 0.4285714285714284 | 3.571428571428572 | 4.0 | 0.8928571428571429 | 0.0 |
12272 | 12272 | Adventist Health Clearlake | 51317 | 2022-03-11 | Lake | 33 | Northern California | 0.0 | 0.0 | 4.0 | 4.0 | 1.0 | 0.0 |
12577 | 12577 | Adventist Health Clearlake | 51317 | 2022-03-04 | Lake | 33 | Northern California | 0.5714285714285714 | 0.1428571428571428 | 3.857142857142857 | 4.0 | 0.9642857142857144 | 0.1481481481481481 |
12880 | 12880 | Adventist Health Clearlake | 51317 | 2022-02-25 | Lake | 33 | Northern California | 1.1428571428571428 | 0.1428571428571428 | 3.857142857142857 | 4.0 | 0.9642857142857144 | 0.2962962962962963 |
13184 | 13184 | Adventist Health Clearlake | 51317 | 2022-02-18 | Lake | 33 | Northern California | 1.0 | 0.1428571428571428 | 3.857142857142857 | 4.0 | 0.9642857142857144 | 0.2592592592592592 |
13489 | 13489 | Adventist Health Clearlake | 51317 | 2022-02-11 | Lake | 33 | Northern California | 1.2857142857142858 | 0.0 | 4.0 | 4.0 | 1.0 | 0.3214285714285714 |
13794 | 13794 | Adventist Health Clearlake | 51317 | 2022-02-04 | Lake | 33 | Northern California | 1.4285714285714286 | 0.0 | 4.0 | 4.0 | 1.0 | 0.3571428571428571 |
14099 | 14099 | Adventist Health Clearlake | 51317 | 2022-01-28 | Lake | 33 | Northern California | 0.8571428571428571 | 0.0 | 4.0 | 4.0 | 1.0 | 0.2142857142857142 |
14404 | 14404 | Adventist Health Clearlake | 51317 | 2022-01-21 | Lake | 33 | Northern California | 0.7142857142857143 | 0.0 | 4.0 | 4.0 | 1.0 | 0.1785714285714285 |
14707 | 14707 | Adventist Health Clearlake | 51317 | 2022-01-14 | Lake | 33 | Northern California | 1.1428571428571428 | 0.4285714285714284 | 3.571428571428572 | 4.0 | 0.8928571428571429 | 0.3199999999999999 |
15012 | 15012 | Adventist Health Clearlake | 51317 | 2022-01-07 | Lake | 33 | Northern California | 0.0 | 0.8571428571428572 | 3.142857142857143 | 4.0 | 0.7857142857142857 | 0.0 |
15317 | 15317 | Adventist Health Clearlake | 51317 | 2021-12-31 | Lake | 33 | Northern California | 0.0 | 1.0 | 3.0 | 4.0 | 0.75 | 0.0 |
15621 | 15621 | Adventist Health Clearlake | 51317 | 2021-12-24 | Lake | 33 | Northern California | 0.0 | 0.0 | 4.0 | 4.0 | 1.0 | 0.0 |
15923 | 15923 | Adventist Health Clearlake | 51317 | 2021-12-17 | Lake | 33 | Northern California | 0.0 | 0.0 | 4.0 | 4.0 | 1.0 | 0.0 |
16228 | 16228 | Adventist Health Clearlake | 51317 | 2021-12-10 | Lake | 33 | Northern California | 0.0 | 0.1428571428571428 | 3.857142857142857 | 4.0 | 0.9642857142857144 | 0.0 |
16534 | 16534 | Adventist Health Clearlake | 51317 | 2021-12-03 | Lake | 33 | Northern California | 0.0 | 0.0 | 4.0 | 4.0 | 1.0 | 0.0 |
16840 | 16840 | Adventist Health Clearlake | 51317 | 2021-11-26 | Lake | 33 | Northern California | 0.0 | 0.1428571428571428 | 3.857142857142857 | 4.0 | 0.9642857142857144 | 0.0 |
17144 | 17144 | Adventist Health Clearlake | 51317 | 2021-11-19 | Lake | 33 | Northern California | 0.7142857142857143 | 1.2857142857142856 | 2.7142857142857144 | 4.0 | 0.6785714285714286 | 0.2631578947368421 |
17448 | 17448 | Adventist Health Clearlake | 51317 | 2021-11-12 | Lake | 33 | Northern California | 1.0 | 0.8571428571428572 | 3.142857142857143 | 4.0 | 0.7857142857142857 | 0.3181818181818182 |
17752 | 17752 | Adventist Health Clearlake | 51317 | 2021-11-05 | Lake | 33 | Northern California | 0.7142857142857143 | 0.0 | 4.0 | 4.0 | 1.0 | 0.1785714285714285 |
18056 | 18056 | Adventist Health Clearlake | 51317 | 2021-10-29 | Lake | 33 | Northern California | 0.0 | 0.0 | 4.0 | 4.0 | 1.0 | 0.0 |
18362 | 18362 | Adventist Health Clearlake | 51317 | 2021-10-22 | Lake | 33 | Northern California | 0.0 | 0.0 | 4.0 | 4.0 | 1.0 | 0.0 |
18668 | 18668 | Adventist Health Clearlake | 51317 | 2021-10-15 | Lake | 33 | Northern California | 0.7142857142857143 | 0.1428571428571428 | 3.857142857142857 | 4.0 | 0.9642857142857144 | 0.1851851851851851 |
18973 | 18973 | Adventist Health Clearlake | 51317 | 2021-10-08 | Lake | 33 | Northern California | 0.0 | 0.2857142857142856 | 3.7142857142857135 | 4.0 | 0.9285714285714286 | 0.0 |
19279 | 19279 | Adventist Health Clearlake | 51317 | 2021-10-01 | Lake | 33 | Northern California | 0.7142857142857143 | 0.0 | 4.0 | 4.0 | 1.0 | 0.1785714285714285 |
19586 | 19586 | Adventist Health Clearlake | 51317 | 2021-09-24 | Lake | 33 | Northern California | 2.142857142857143 | 0.4285714285714284 | 3.571428571428572 | 4.0 | 0.8928571428571429 | 0.6 |
19893 | 19893 | Adventist Health Clearlake | 51317 | 2021-09-17 | Lake | 33 | Northern California | 2.4285714285714284 | 0.8571428571428572 | 3.142857142857143 | 4.0 | 0.7857142857142857 | 0.7727272727272727 |
20199 | 20199 | Adventist Health Clearlake | 51317 | 2021-09-10 | Lake | 33 | Northern California | 1.8571428571428568 | 0.0 | 4.0 | 4.0 | 1.0 | 0.4642857142857143 |
20506 | 20506 | Adventist Health Clearlake | 51317 | 2021-09-03 | Lake | 33 | Northern California | 1.8571428571428568 | 0.0 | 4.0 | 4.0 | 1.0 | 0.4642857142857143 |
20812 | 20812 | Adventist Health Clearlake | 51317 | 2021-08-27 | Lake | 33 | Northern California | 3.2857142857142856 | 0.0 | 4.0 | 4.0 | 1.0 | 0.8214285714285714 |
21118 | 21118 | Adventist Health Clearlake | 51317 | 2021-08-20 | Lake | 33 | Northern California | 3.142857142857143 | 0.0 | 4.0 | 4.0 | 1.0 | 0.7857142857142857 |
21423 | 21423 | Adventist Health Clearlake | 51317 | 2021-08-13 | Lake | 33 | Northern California | 3.2857142857142856 | 0.1428571428571428 | 3.857142857142857 | 4.0 | 0.9642857142857144 | 0.8518518518518519 |
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 );