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)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
37144 | 37144 | Kaiser Permanente San Diego Medical Center | 2020-08-21 | 6.4 | 8.799999999999997 | 35.6 | 44.4 | 0.8018018018018018 | 0.1797752808988764 | ||||
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 |
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 |
18 | 18 | Alta Bates Summit Medical Center | 50043 | 2022-12-23 | Alameda | 1 | Bay Area | 0.0 | 17.0 | 19.0 | 36.0 | 0.5277777777777778 | 0.0 |
19 | 19 | Alta Bates Summit Medical Center - Alta Bates Camp | 50305 | 2022-12-23 | Alameda | 1 | Bay Area | 0.0 | 17.0 | 13.0 | 30.0 | 0.4333333333333333 | 0.0 |
28 | 28 | California Pacific Medical Center - Mission Bernal | 50055 | 2022-12-23 | San Francisco | 75 | Bay Area | 0.0 | 4.0 | 6.0 | 10.0 | 0.6 | 0.0 |
29 | 29 | California Pacific Medical Center- Van Ness Campus | 50047 | 2022-12-23 | San Francisco | 75 | Bay Area | 6.0 | 2.0 | 34.0 | 36.0 | 0.9444444444444444 | 0.1764705882352941 |
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 |
35 | 35 | Chinese Hospital | 50407 | 2022-12-23 | San Francisco | 75 | Bay Area | 0.0 | 6.0 | 0.0 | 6.0 | 0.0 | |
43 | 43 | Community Hospital of the Monterey Peninsula | 50145 | 2022-12-23 | Monterey | 53 | Bay Area | 0.0 | 9.0 | 17.0 | 26.0 | 0.6538461538461539 | 0.0 |
46 | 46 | Contra Costa Regional Medical Center | 50276 | 2022-12-23 | Contra Costa | 13 | Bay Area | 0.0 | 4.0 | 14.0 | 18.0 | 0.7777777777777778 | 0.0 |
50 | 50 | Dominican Hospital | 50242 | 2022-12-23 | Santa Cruz | 87 | Bay Area | 0.0 | 1.0 | 12.0 | 13.0 | 0.9230769230769232 | 0.0 |
52 | 52 | Eden Medical Center | 50488 | 2022-12-23 | Alameda | 1 | Bay Area | 0.0 | 0.0 | 24.0 | 24.0 | 1.0 | 0.0 |
54 | 54 | El Camino Hospital | 50308 | 2022-12-23 | Santa Clara | 85 | Bay Area | 5.0 | 6.0 | 26.0 | 32.0 | 0.8125 | 0.1923076923076923 |
65 | 65 | Good Samaritan Hospital | 50380 | 2022-12-23 | Santa Clara | 85 | Bay Area | 4.6 | 11.0 | 33.4 | 44.4 | 0.7522522522522522 | 0.1377245508982036 |
69 | 69 | Healdsburg Hospital | 51321 | 2022-12-23 | Sonoma | 97 | Bay Area | 0.0 | 5.0 | 0.0 | 5.0 | 0.0 | |
72 | 72 | Highland Hospital | 50320 | 2022-12-23 | Alameda | 1 | Bay Area | 2.0 | 8.5 | 24.5 | 33.0 | 0.7424242424242424 | 0.0816326530612244 |
77 | 77 | John Muir Medical Center - Concord Campus | 50496 | 2022-12-23 | Contra Costa | 13 | Bay Area | 0.0 | 8.0 | 28.0 | 36.0 | 0.7777777777777778 | 0.0 |
78 | 78 | John Muir Medical Center - Walnut Creek Campus | 50180 | 2022-12-23 | Contra Costa | 13 | Bay Area | 0.0 | 6.0 | 42.0 | 48.0 | 0.875 | 0.0 |
80 | 80 | Kaiser Foundation Hospital - Antioch | 50760 | 2022-12-23 | Contra Costa | 13 | Bay Area | 5.0 | 1.0 | 8.0 | 9.0 | 0.8888888888888888 | 0.625 |
83 | 83 | Kaiser Foundation Hospital - Fremont | 50512 | 2022-12-23 | Alameda | 1 | Bay Area | 0.0 | 0.0 | 4.0 | 4.0 | 1.0 | 0.0 |
86 | 86 | Kaiser Foundation Hospital - Oakland/richmond | 50075 | 2022-12-23 | Alameda | 1 | Bay Area | 10.0 | 2.0 | 20.0 | 22.0 | 0.9090909090909092 | 0.5 |
89 | 89 | Kaiser Foundation Hospital - Redwood City | 50541 | 2022-12-23 | San Mateo | 81 | Bay Area | 0.0 | 1.0 | 10.0 | 11.0 | 0.9090909090909092 | 0.0 |
92 | 92 | Kaiser Foundation Hospital - San Francisco | 50076 | 2022-12-23 | San Francisco | 75 | Bay Area | 0.0 | 2.0 | 20.0 | 22.0 | 0.9090909090909092 | 0.0 |
93 | 93 | Kaiser Foundation Hospital - San Leandro | 50777 | 2022-12-23 | Alameda | 1 | Bay Area | 7.0 | 2.0 | 15.0 | 17.0 | 0.8823529411764706 | 0.4666666666666667 |
95 | 95 | Kaiser Foundation Hospital - South San Francisco | 50070 | 2022-12-23 | San Mateo | 81 | Bay Area | 0.0 | 1.0 | 9.0 | 10.0 | 0.9 | 0.0 |
96 | 96 | Kaiser Foundation Hospital - Vacaville | 50767 | 2022-12-23 | Solano | 95 | Bay Area | 0.0 | 1.0 | 7.0 | 8.0 | 0.875 | 0.0 |
97 | 97 | Kaiser Foundation Hospital - Walnut Creek | 50072 | 2022-12-23 | Contra Costa | 13 | Bay Area | 4.0 | 2.0 | 15.0 | 17.0 | 0.8823529411764706 | 0.2666666666666666 |
103 | 103 | Kaiser Foundation Hospital and Rehab Center | 50073 | 2022-12-23 | Solano | 95 | Bay Area | 5.0 | 2.0 | 17.0 | 19.0 | 0.8947368421052632 | 0.2941176470588235 |
106 | 106 | Kaiser Foundation Hospital-san Jose | 50604 | 2022-12-23 | Santa Clara | 85 | Bay Area | 0.0 | 1.0 | 9.0 | 10.0 | 0.9 | 0.0 |
107 | 107 | Kaiser Foundation Hospital-santa Clara | 50071 | 2022-12-23 | Santa Clara | 85 | Bay Area | 4.0 | 1.0 | 29.0 | 30.0 | 0.9666666666666668 | 0.1379310344827586 |
108 | 108 | Kaiser Foundation Hospital-santa Rosa | 50690 | 2022-12-23 | Sonoma | 97 | Bay Area | 0.0 | 1.0 | 6.0 | 7.0 | 0.8571428571428571 | 0.0 |
114 | 114 | Kindred Hospital - San Francisco Bay Area | 52034 | 2022-12-23 | Alameda | 1 | Bay Area | 0.0 | 4.0 | 6.0 | 10.0 | 0.6 | 0.0 |
138 | 138 | Marinhealth Medical Center | 50360 | 2022-12-23 | Marin | 41 | Bay Area | 0.0 | 6.0 | 13.0 | 19.0 | 0.6842105263157895 | 0.0 |
156 | 156 | Mills-peninsula Medical Center | 50007 | 2022-12-23 | San Mateo | 81 | Bay Area | 0.0 | 7.0 | 17.0 | 24.0 | 0.7083333333333334 | 0.0 |
161 | 161 | Natividad Medical Center | 50248 | 2022-12-23 | Monterey | 53 | Bay Area | 0.0 | 2.0 | 8.0 | 10.0 | 0.8 | 0.0 |
162 | 162 | Northbay Medical Center | 50367 | 2022-12-23 | Solano | 95 | Bay Area | 0.0 | 6.0 | 18.0 | 24.0 | 0.75 | 0.0 |
165 | 165 | Novato Community Hospital | 50131 | 2022-12-23 | Marin | 41 | Bay Area | 0.0 | 1.0 | 5.0 | 6.0 | 0.8333333333333334 | 0.0 |
174 | 174 | Petaluma Valley Hospital | 50136 | 2022-12-23 | Sonoma | 97 | Bay Area | 0.0 | 1.0 | 5.0 | 6.0 | 0.8333333333333334 | 0.0 |
185 | 185 | Providence Queen of the Valley Medical Center | 50009 | 2022-12-23 | Napa | 55 | Bay Area | 0.0 | 0.0 | 12.0 | 12.0 | 1.0 | 0.0 |
188 | 188 | Providence Santa Rosa Memorial Hospital | 50174 | 2022-12-23 | Sonoma | 97 | Bay Area | 0.0 | 6.0 | 20.0 | 26.0 | 0.7692307692307693 | 0.0 |
192 | 192 | Regional Medical Center of San Jose | 50125 | 2022-12-23 | Santa Clara | 85 | Bay Area | 5.0 | 3.8000000000000007 | 30.2 | 34.0 | 0.888235294117647 | 0.1655629139072847 |
198 | 198 | Saint Francis Memorial Hospital | 50152 | 2022-12-23 | San Francisco | 75 | Bay Area | 4.0 | 12.0 | 8.0 | 20.0 | 0.4 | 0.5 |
200 | 200 | Salinas Valley Memorial Hospital | 50334 | 2022-12-23 | Monterey | 53 | Bay Area | 0.0 | 4.0 | 9.0 | 13.0 | 0.6923076923076923 | 0.0 |
206 | 206 | San Mateo Medical Center | 50113 | 2022-12-23 | San Mateo | 81 | Bay Area | 0.0 | 2.0 | 4.0 | 6.0 | 0.6666666666666666 | 0.0 |
208 | 208 | Santa Clara Valley Medical Center | 50038 | 2022-12-23 | Santa Clara | 85 | Bay Area | 7.0 | 25.0 | 63.0 | 88.0 | 0.7159090909090909 | 0.1111111111111111 |
213 | 213 | Sequoia Hospital | 50197 | 2022-12-23 | San Mateo | 81 | Bay Area | 0.0 | 8.0 | 5.0 | 13.0 | 0.3846153846153846 | 0.0 |
220 | 220 | Sonoma Valley Hospital | 50090 | 2022-12-23 | Sonoma | 97 | Bay Area | 0.0 | 6.0 | 0.0 | 6.0 | 0.0 | |
231 | 231 | St. Mary's Medical Center | 50457 | 2022-12-23 | San Francisco | 75 | Bay Area | 0.0 | 7.0 | 9.0 | 16.0 | 0.5625 | 0.0 |
232 | 232 | St. Rose Hospital | 50002 | 2022-12-23 | Alameda | 1 | Bay Area | 0.0 | 5.0 | 7.0 | 12.0 | 0.5833333333333334 | 0.0 |
233 | 233 | Stanford Health Care | 50441 | 2022-12-23 | Santa Clara | 85 | Bay Area | 9.0 | 0.0 | 105.0 | 105.0 | 1.0 | 0.0857142857142857 |
234 | 234 | Stanford Health Care - Valleycare | 50283 | 2022-12-23 | Alameda | 1 | Bay Area | 0.0 | 6.0 | 16.0 | 22.0 | 0.7272727272727273 | 0.0 |
239 | 239 | Sutter Delta Medical Center | 50523 | 2022-12-23 | Contra Costa | 13 | Bay Area | 0.0 | 2.0 | 10.0 | 12.0 | 0.8333333333333334 | 0.0 |
243 | 243 | Sutter Santa Rosa Regional Hospital | 50291 | 2022-12-23 | Sonoma | 97 | Bay Area | 0.0 | 1.0 | 11.0 | 12.0 | 0.9166666666666666 | 0.0 |
244 | 244 | Sutter Solano Medical Center | 50101 | 2022-12-23 | Solano | 95 | Bay Area | 0.0 | 6.0 | 6.0 | 12.0 | 0.5 | 0.0 |
250 | 250 | UCSF Medical Center | 50454 | 2022-12-23 | San Francisco | 75 | Bay Area | 0.0 | 2.0 | 6.0 | 8.0 | 0.75 | 0.0 |
259 | 259 | Washington Hospital | 50195 | 2022-12-23 | Alameda | 1 | Bay Area | 0.0 | 5.0 | 23.0 | 28.0 | 0.8214285714285714 | 0.0 |
265 | 265 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2022-12-23 | San Francisco | 75 | Bay Area | 0.0 | 0.0 | 38.0 | 38.0 | 1.0 | 0.0 |
275 | 275 | Adventist Health St. Helena | 50013 | 2022-12-16 | Napa | 55 | Bay Area | 0.0 | 1.8571428571428568 | 5.714285714285714 | 7.571428571428571 | 0.7547169811320755 | 0.0 |
281 | 281 | Ahmc Seton Medical Center | 50289 | 2022-12-16 | San Mateo | 81 | Bay Area | 3.4285714285714284 | 4.428571428571429 | 9.571428571428571 | 14.0 | 0.6836734693877551 | 0.3582089552238806 |
282 | 282 | Alameda Hospital | 50211 | 2022-12-16 | Alameda | 1 | Bay Area | 0.0 | 0.1428571428571432 | 7.857142857142857 | 8.0 | 0.9821428571428572 | 0.0 |
284 | 284 | Alta Bates Summit Medical Center | 50043 | 2022-12-16 | Alameda | 1 | Bay Area | 3.7142857142857135 | 16.714285714285715 | 19.285714285714285 | 36.0 | 0.5357142857142857 | 0.1925925925925926 |
285 | 285 | Alta Bates Summit Medical Center - Alta Bates Camp | 50305 | 2022-12-16 | Alameda | 1 | Bay Area | 1.5714285714285714 | 18.142857142857142 | 11.857142857142858 | 30.0 | 0.3952380952380953 | 0.1325301204819277 |
296 | 296 | California Pacific Medical Center - Mission Bernal | 50055 | 2022-12-16 | San Francisco | 75 | Bay Area | 0.8571428571428571 | 4.285714285714286 | 5.714285714285714 | 10.0 | 0.5714285714285714 | 0.15 |
297 | 297 | California Pacific Medical Center- Van Ness Campus | 50047 | 2022-12-16 | San Francisco | 75 | Bay Area | 2.7142857142857144 | 5.285714285714285 | 30.714285714285715 | 36.0 | 0.8531746031746033 | 0.0883720930232558 |
298 | 298 | California Pacific Medical Ctr-davies Campus Hosp | 50008 | 2022-12-16 | San Francisco | 75 | Bay Area | 0.0 | 0.1428571428571432 | 7.857142857142857 | 8.0 | 0.9821428571428572 | 0.0 |
303 | 303 | Chinese Hospital | 50407 | 2022-12-16 | San Francisco | 75 | Bay Area | 2.0 | 2.142857142857143 | 3.857142857142857 | 6.0 | 0.6428571428571429 | 0.5185185185185185 |
311 | 311 | Community Hospital of the Monterey Peninsula | 50145 | 2022-12-16 | Monterey | 53 | Bay Area | 0.0 | 3.571428571428573 | 23.428571428571427 | 27.0 | 0.8677248677248677 | 0.0 |
314 | 314 | Contra Costa Regional Medical Center | 50276 | 2022-12-16 | Contra Costa | 13 | Bay Area | 0.7142857142857143 | 2.1428571428571423 | 15.857142857142858 | 18.0 | 0.8809523809523809 | 0.045045045045045 |
322 | 322 | Dominican Hospital | 50242 | 2022-12-16 | Santa Cruz | 87 | Bay Area | 1.5714285714285714 | 0.1428571428571423 | 14.857142857142858 | 15.0 | 0.9904761904761904 | 0.1057692307692307 |
324 | 324 | Eden Medical Center | 50488 | 2022-12-16 | Alameda | 1 | Bay Area | 2.142857142857143 | 1.428571428571427 | 22.571428571428573 | 24.0 | 0.9404761904761906 | 0.0949367088607594 |
326 | 326 | El Camino Hospital | 50308 | 2022-12-16 | Santa Clara | 85 | Bay Area | 4.0 | 5.714285714285715 | 26.285714285714285 | 32.0 | 0.8214285714285714 | 0.1521739130434782 |
342 | 342 | Good Samaritan Hospital | 50380 | 2022-12-16 | Santa Clara | 85 | Bay Area | 2.2857142857142856 | 4.0 | 33.0 | 37.0 | 0.8918918918918919 | 0.0692640692640692 |
346 | 346 | Healdsburg Hospital | 51321 | 2022-12-16 | Sonoma | 97 | Bay Area | 0.0 | 3.75 | 1.25 | 5.0 | 0.25 | 0.0 |
350 | 350 | Highland Hospital | 50320 | 2022-12-16 | Alameda | 1 | Bay Area | 0.8571428571428571 | 8.714285714285715 | 24.285714285714285 | 33.0 | 0.7359307359307359 | 0.0352941176470588 |
356 | 356 | John Muir Medical Center - Concord Campus | 50496 | 2022-12-16 | Contra Costa | 13 | Bay Area | 1.8571428571428568 | 7.142857142857142 | 28.857142857142858 | 36.0 | 0.8015873015873016 | 0.0643564356435643 |
357 | 357 | John Muir Medical Center - Walnut Creek Campus | 50180 | 2022-12-16 | Contra Costa | 13 | Bay Area | 1.8571428571428568 | 5.5714285714285765 | 42.57142857142857 | 48.142857142857146 | 0.8842729970326408 | 0.0436241610738255 |
359 | 359 | Kaiser Foundation Hospital | 50510 | 2022-12-16 | Marin | 41 | Bay Area | 0.0 | 0.1428571428571428 | 3.2857142857142856 | 3.4285714285714284 | 0.9583333333333334 | 0.0 |
360 | 360 | Kaiser Foundation Hospital - Antioch | 50760 | 2022-12-16 | Contra Costa | 13 | Bay Area | 6.0 | 1.142857142857144 | 10.714285714285714 | 11.857142857142858 | 0.9036144578313252 | 0.56 |
363 | 363 | Kaiser Foundation Hospital - Fremont | 50512 | 2022-12-16 | Alameda | 1 | Bay Area | 2.142857142857143 | 1.0000000000000009 | 7.857142857142857 | 8.857142857142858 | 0.8870967741935483 | 0.2727272727272727 |
366 | 366 | Kaiser Foundation Hospital - Oakland/richmond | 50075 | 2022-12-16 | Alameda | 1 | Bay Area | 5.714285714285714 | 2.5714285714285694 | 20.571428571428573 | 23.142857142857142 | 0.888888888888889 | 0.2777777777777778 |
369 | 369 | Kaiser Foundation Hospital - Redwood City | 50541 | 2022-12-16 | San Mateo | 81 | Bay Area | 1.2857142857142858 | 1.0 | 8.857142857142858 | 9.857142857142858 | 0.8985507246376812 | 0.1451612903225806 |
372 | 372 | Kaiser Foundation Hospital - San Francisco | 50076 | 2022-12-16 | San Francisco | 75 | Bay Area | 1.4285714285714286 | 2.1428571428571423 | 20.285714285714285 | 22.428571428571427 | 0.9044585987261148 | 0.0704225352112676 |
373 | 373 | Kaiser Foundation Hospital - San Leandro | 50777 | 2022-12-16 | Alameda | 1 | Bay Area | 11.428571428571429 | 2.0 | 18.0 | 20.0 | 0.9 | 0.6349206349206349 |
375 | 375 | Kaiser Foundation Hospital - South San Francisco | 50070 | 2022-12-16 | San Mateo | 81 | Bay Area | 0.8571428571428571 | 1.0000000000000009 | 7.285714285714286 | 8.285714285714286 | 0.8793103448275861 | 0.1176470588235294 |
376 | 376 | Kaiser Foundation Hospital - Vacaville | 50767 | 2022-12-16 | Solano | 95 | Bay Area | 4.428571428571429 | 1.0 | 12.0 | 13.0 | 0.9230769230769232 | 0.369047619047619 |
377 | 377 | Kaiser Foundation Hospital - Walnut Creek | 50072 | 2022-12-16 | Contra Costa | 13 | Bay Area | 3.571428571428572 | 1.7142857142857135 | 15.714285714285714 | 17.428571428571427 | 0.9016393442622952 | 0.2272727272727273 |
383 | 383 | Kaiser Foundation Hospital and Rehab Center | 50073 | 2022-12-16 | Solano | 95 | Bay Area | 5.571428571428571 | 1.4285714285714288 | 14.714285714285714 | 16.142857142857142 | 0.911504424778761 | 0.3786407766990291 |
386 | 386 | Kaiser Foundation Hospital-san Jose | 50604 | 2022-12-16 | Santa Clara | 85 | Bay Area | 3.0 | 1.0 | 9.714285714285714 | 10.714285714285714 | 0.9066666666666666 | 0.3088235294117647 |
387 | 387 | Kaiser Foundation Hospital-santa Clara | 50071 | 2022-12-16 | Santa Clara | 85 | Bay Area | 2.857142857142857 | 1.7142857142857115 | 27.714285714285715 | 29.428571428571427 | 0.941747572815534 | 0.1030927835051546 |
388 | 388 | Kaiser Foundation Hospital-santa Rosa | 50690 | 2022-12-16 | Sonoma | 97 | Bay Area | 1.1428571428571428 | 1.0 | 8.428571428571429 | 9.428571428571429 | 0.8939393939393939 | 0.135593220338983 |
394 | 394 | Kindred Hospital - San Francisco Bay Area | 52034 | 2022-12-16 | Alameda | 1 | Bay Area | 0.0 | 4.857142857142857 | 5.142857142857143 | 10.0 | 0.5142857142857143 | 0.0 |
420 | 420 | Marinhealth Medical Center | 50360 | 2022-12-16 | Marin | 41 | Bay Area | 0.7142857142857143 | 4.857142857142858 | 14.142857142857142 | 19.0 | 0.7443609022556391 | 0.0505050505050505 |
439 | 439 | Mills-peninsula Medical Center | 50007 | 2022-12-16 | San Mateo | 81 | Bay Area | 1.8571428571428568 | 5.571428571428573 | 18.428571428571427 | 24.0 | 0.7678571428571428 | 0.1007751937984496 |
444 | 444 | Natividad Medical Center | 50248 | 2022-12-16 | Monterey | 53 | Bay Area | 0.0 | 3.428571428571429 | 6.571428571428571 | 10.0 | 0.6571428571428571 | 0.0 |
445 | 445 | Northbay Medical Center | 50367 | 2022-12-16 | Solano | 95 | Bay Area | 1.0 | 0.571428571428573 | 23.428571428571427 | 24.0 | 0.9761904761904762 | 0.0426829268292682 |
448 | 448 | Novato Community Hospital | 50131 | 2022-12-16 | Marin | 41 | Bay Area | 0.5714285714285714 | 0.8571428571428568 | 5.142857142857143 | 6.0 | 0.8571428571428572 | 0.111111111111111 |
459 | 459 | Petaluma Valley Hospital | 50136 | 2022-12-16 | Sonoma | 97 | Bay Area | 0.0 | 1.714285714285714 | 3.857142857142857 | 5.571428571428571 | 0.6923076923076924 | 0.0 |
471 | 471 | Providence Queen of the Valley Medical Center | 50009 | 2022-12-16 | Napa | 55 | Bay Area | 0.0 | 1.5714285714285712 | 11.0 | 12.571428571428571 | 0.875 | 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 );