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.
306 rows where "week" is on date 2021-01-22 sorted by ccn
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: region
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 |
30507 | 30507 | Providence St. Joseph Hospital | 50006 | 2021-01-22 | Humboldt | 23 | Northern California | 3.571428571428572 | 6.285714285714287 | 11.714285714285714 | 18.0 | 0.6507936507936507 | 0.3048780487804878 |
30470 | 30470 | Mills-peninsula Medical Center | 50007 | 2021-01-22 | San Mateo | 81 | Bay Area | 5.714285714285714 | 4.571428571428573 | 19.428571428571427 | 24.0 | 0.8095238095238094 | 0.2941176470588235 |
30323 | 30323 | California Pacific Medical Ctr-davies Campus Hosp | 50008 | 2021-01-22 | San Francisco | 75 | Bay Area | 0.0 | 1.7142857142857144 | 6.285714285714286 | 8.0 | 0.7857142857142857 | 0.0 |
30503 | 30503 | Providence Queen of the Valley Medical Center | 50009 | 2021-01-22 | Napa | 55 | Bay Area | 6.714285714285714 | 1.2857142857142847 | 10.857142857142858 | 12.142857142857142 | 0.8941176470588236 | 0.618421052631579 |
30299 | 30299 | Adventist Health St. Helena | 50013 | 2021-01-22 | Napa | 55 | Bay Area | 0.0 | 1.7142857142857144 | 7.285714285714286 | 9.0 | 0.8095238095238095 | 0.0 |
30560 | 30560 | Sutter Amador Hospital | 50014 | 2021-01-22 | Amador | 5 | Greater Sacramento | 5.714285714285714 | 0.0 | 6.142857142857143 | 6.142857142857143 | 1.0 | 0.9302325581395348 |
30462 | 30462 | Mercy General Hospital | 50017 | 2021-01-22 | Sacramento | 67 | Greater Sacramento | 7.285714285714286 | 1.7142857142857153 | 27.428571428571427 | 29.142857142857142 | 0.9411764705882352 | 0.265625 |
30513 | 30513 | Riverside Community Hospital | 50022 | 2021-01-22 | Riverside | 65 | Southern California | 45.285714285714285 | 0.0 | 86.14285714285714 | 86.14285714285714 | 1.0 | 0.5257048092868989 |
30490 | 30490 | Paradise Valley Hospital | 50024 | 2021-01-22 | San Diego | 73 | Southern California | 13.142857142857142 | 1.2857142857142865 | 13.714285714285714 | 15.0 | 0.9142857142857144 | 0.9583333333333334 |
30581 | 30581 | Uc San Diego Health Hillcrest - Hillcrest Medical Center | 50025 | 2021-01-22 | San Diego | 73 | Southern California | 36.85714285714285 | 10.0 | 91.0 | 101.0 | 0.900990099009901 | 0.4050235478806907 |
30372 | 30372 | Grossmont Hospital | 50026 | 2021-01-22 | San Diego | 73 | Southern California | 42.42857142857143 | 5.571428571428584 | 69.71428571428571 | 75.28571428571429 | 0.925996204933586 | 0.6086065573770493 |
30447 | 30447 | Mad River Community Hospital | 50028 | 2021-01-22 | Humboldt | 23 | Northern California | 0.8571428571428571 | 5.0 | 1.0 | 6.0 | 0.1666666666666666 | 0.8571428571428571 |
30485 | 30485 | Oroville Hospital | 50030 | 2021-01-22 | Butte | 7 | Greater Sacramento | 3.571428571428572 | 2.428571428571429 | 7.571428571428571 | 10.0 | 0.7571428571428571 | 0.4716981132075472 |
30315 | 30315 | Bakersfield Memorial Hospital | 50036 | 2021-01-22 | Kern | 29 | San Joaquin Valley | 15.857142857142858 | 3.428571428571427 | 29.142857142857142 | 32.57142857142857 | 0.8947368421052632 | 0.5441176470588236 |
30529 | 30529 | Santa Clara Valley Medical Center | 50038 | 2021-01-22 | Santa Clara | 85 | Bay Area | 31.142857142857142 | 14.42857142857143 | 73.57142857142857 | 88.0 | 0.836038961038961 | 0.4233009708737864 |
30358 | 30358 | Enloe Medical Center | 50039 | 2021-01-22 | Butte | 7 | Greater Sacramento | 4.428571428571429 | 5.428571428571427 | 18.571428571428573 | 24.0 | 0.7738095238095238 | 0.2384615384615384 |
30436 | 30436 | LAC/Olive View-UCLA Medical Center | 50040 | 2021-01-22 | Los Angeles | 37 | Southern California | 15.142857142857142 | 4.428571428571431 | 29.0 | 33.42857142857143 | 0.8675213675213674 | 0.5221674876847291 |
30550 | 30550 | St. Elizabeth Community Hospital | 50042 | 2021-01-22 | Tehama | 103 | Northern California | 1.1428571428571428 | 1.0 | 7.0 | 8.0 | 0.875 | 0.1632653061224489 |
30308 | 30308 | Alta Bates Summit Medical Center | 50043 | 2021-01-22 | Alameda | 1 | Bay Area | 9.857142857142858 | 11.0 | 25.0 | 36.0 | 0.6944444444444444 | 0.3942857142857143 |
30353 | 30353 | El Centro Regional Medical Center | 50045 | 2021-01-22 | Imperial | 25 | Southern California | 26.857142857142858 | 1.7142857142857082 | 35.142857142857146 | 36.85714285714285 | 0.9534883720930234 | 0.7642276422764227 |
30322 | 30322 | California Pacific Medical Center- Van Ness Campus | 50047 | 2021-01-22 | San Francisco | 75 | Bay Area | 4.285714285714286 | 3.5714285714285694 | 32.42857142857143 | 36.0 | 0.9007936507936508 | 0.13215859030837 |
30524 | 30524 | San Gorgonio Memorial Hospital | 50054 | 2021-01-22 | Riverside | 65 | Southern California | 16.0 | 0.0 | 18.714285714285715 | 18.714285714285715 | 1.0 | 0.8549618320610687 |
30321 | 30321 | California Pacific Medical Center - Mission Bernal | 50055 | 2021-01-22 | San Francisco | 75 | Bay Area | 4.571428571428571 | 2.2857142857142856 | 7.714285714285714 | 10.0 | 0.7714285714285715 | 0.5925925925925926 |
30312 | 30312 | Antelope Valley Hospital | 50056 | 2021-01-22 | Los Angeles | 37 | Southern California | 22.428571428571427 | 1.4285714285714306 | 30.285714285714285 | 31.714285714285715 | 0.9549549549549547 | 0.7405660377358491 |
30418 | 30418 | Kaweah Health Medical Center | 50057 | 2021-01-22 | Tulare | 107 | San Joaquin Valley | 15.142857142857142 | 9.714285714285715 | 31.285714285714285 | 41.0 | 0.7630662020905923 | 0.4840182648401826 |
30367 | 30367 | Glendale Mem Hospital & Health Center | 50058 | 2021-01-22 | Los Angeles | 37 | Southern California | 16.285714285714285 | 0.0 | 16.285714285714285 | 16.285714285714285 | 1.0 | 1.0 |
30339 | 30339 | Community Regional Medical Center | 50060 | 2021-01-22 | Fresno | 19 | San Joaquin Valley | 25.428571428571427 | 3.285714285714292 | 91.71428571428572 | 95.0 | 0.9654135338345864 | 0.2772585669781931 |
30380 | 30380 | Hollywood Presbyterian Medical Center | 50063 | 2021-01-22 | Los Angeles | 37 | Southern California | 16.857142857142858 | 3.571428571428573 | 25.142857142857142 | 28.714285714285715 | 0.8756218905472636 | 0.6704545454545455 |
30480 | 30480 | Oak Valley Hospital District | 50067 | 2021-01-22 | Stanislaus | 99 | San Joaquin Valley | 1.5714285714285714 | 1.8571428571428568 | 3.142857142857143 | 5.0 | 0.6285714285714286 | 0.5 |
30508 | 30508 | Providence St. Joseph Hospital | 50069 | 2021-01-22 | Orange | 59 | Southern California | 28.0 | 1.4285714285714306 | 41.57142857142857 | 43.0 | 0.9667774086378738 | 0.6735395189003437 |
30403 | 30403 | Kaiser Foundation Hospital - South San Francisco | 50070 | 2021-01-22 | San Mateo | 81 | Bay Area | 10.0 | 1.0 | 12.285714285714286 | 13.285714285714286 | 0.9247311827956988 | 0.813953488372093 |
30415 | 30415 | Kaiser Foundation Hospital-santa Clara | 50071 | 2021-01-22 | Santa Clara | 85 | Bay Area | 16.0 | 0.571428571428573 | 30.142857142857142 | 30.714285714285715 | 0.9813953488372092 | 0.5308056872037915 |
30405 | 30405 | Kaiser Foundation Hospital - Walnut Creek | 50072 | 2021-01-22 | Contra Costa | 13 | Bay Area | 6.142857142857143 | 1.4285714285714288 | 14.0 | 15.428571428571429 | 0.9074074074074074 | 0.4387755102040817 |
30411 | 30411 | Kaiser Foundation Hospital and Rehab Center | 50073 | 2021-01-22 | Solano | 95 | Bay Area | 11.571428571428571 | 1.5714285714285712 | 15.285714285714286 | 16.857142857142858 | 0.9067796610169492 | 0.7570093457943925 |
30394 | 30394 | Kaiser Foundation Hospital - Oakland/richmond | 50075 | 2021-01-22 | Alameda | 1 | Bay Area | 27.428571428571427 | 0.0 | 33.57142857142857 | 33.57142857142857 | 1.0 | 0.8170212765957446 |
30400 | 30400 | Kaiser Foundation Hospital - San Francisco | 50076 | 2021-01-22 | San Francisco | 75 | Bay Area | 8.0 | 1.7142857142857135 | 15.285714285714286 | 17.0 | 0.8991596638655462 | 0.5233644859813084 |
30535 | 30535 | Scripps Mercy Hospital | 50077 | 2021-01-22 | San Diego | 73 | Southern California | 43.71428571428572 | 5.571428571428569 | 69.42857142857143 | 75.0 | 0.9257142857142856 | 0.6296296296296297 |
30500 | 30500 | Providence Little Company of Mary Medical Center San Pedro | 50078 | 2021-01-22 | Los Angeles | 37 | Southern California | 10.285714285714286 | 0.1428571428571423 | 18.857142857142858 | 19.0 | 0.9924812030075189 | 0.5454545454545455 |
30552 | 30552 | St. Johns Regional Medical Center | 50082 | 2021-01-22 | Ventura | 111 | Southern California | 19.857142857142858 | 0.8571428571428577 | 26.714285714285715 | 27.571428571428573 | 0.9689119170984456 | 0.7433155080213903 |
30553 | 30553 | St. Joseph's Medical Center of Stockton | 50084 | 2021-01-22 | San Joaquin | 77 | San Joaquin Valley | 34.285714285714285 | 0.0 | 39.0 | 39.0 | 1.0 | 0.8791208791208791 |
30336 | 30336 | Community Hospital of San Bernardino | 50089 | 2021-01-22 | San Bernardino | 71 | Southern California | 13.428571428571429 | 2.8571428571428577 | 18.142857142857142 | 21.0 | 0.8639455782312925 | 0.7401574803149606 |
30545 | 30545 | Sonoma Valley Hospital | 50090 | 2021-01-22 | Sonoma | 97 | Bay Area | 0.0 | 5.285714285714286 | 0.7142857142857143 | 6.0 | 0.119047619047619 | 0.0 |
30335 | 30335 | Community Hospital of Huntington Park | 50091 | 2021-01-22 | Los Angeles | 37 | Southern California | 12.0 | 0.0 | 13.714285714285714 | 13.714285714285714 | 1.0 | 0.875 |
30516 | 30516 | Saint Agnes Medical Center | 50093 | 2021-01-22 | Fresno | 19 | San Joaquin Valley | 35.0 | 0.0 | 48.0 | 48.0 | 1.0 | 0.7291666666666666 |
30521 | 30521 | San Antonio Regional Hospital | 50099 | 2021-01-22 | San Bernardino | 71 | Southern California | 19.0 | 2.4285714285714306 | 56.0 | 58.42857142857143 | 0.9584352078239609 | 0.3392857142857143 |
30539 | 30539 | Sharp Memorial Hospital | 50100 | 2021-01-22 | San Diego | 73 | Southern California | 40.285714285714285 | 7.285714285714285 | 63.285714285714285 | 70.57142857142857 | 0.8967611336032388 | 0.636568848758465 |
30569 | 30569 | Sutter Solano Medical Center | 50101 | 2021-01-22 | Solano | 95 | Bay Area | 7.285714285714286 | 0.4285714285714288 | 11.571428571428571 | 12.0 | 0.9642857142857144 | 0.6296296296296297 |
30346 | 30346 | Doctors Hospital of Riverside, LLC | 50102 | 2021-01-22 | Riverside | 65 | Southern California | 21.142857142857142 | 0.0 | 27.285714285714285 | 27.285714285714285 | 1.0 | 0.774869109947644 |
30592 | 30592 | White Memorial Medical Center | 50103 | 2021-01-22 | Los Angeles | 37 | Southern California | 13.714285714285714 | 2.1428571428571423 | 29.142857142857142 | 31.285714285714285 | 0.9315068493150686 | 0.4705882352941176 |
30517 | 30517 | Saint Francis Medical Center | 50104 | 2021-01-22 | Los Angeles | 37 | Southern California | 28.857142857142858 | 1.0 | 34.142857142857146 | 35.142857142857146 | 0.9715447154471544 | 0.8451882845188284 |
30450 | 30450 | Marian Regional Medical Center | 50107 | 2021-01-22 | Santa Barbara | 83 | Southern California | 25.571428571428573 | 2.1428571428571423 | 30.142857142857142 | 32.285714285714285 | 0.9336283185840708 | 0.8483412322274883 |
30566 | 30566 | Sutter Medical Center, Sacramento | 50108 | 2021-01-22 | Sacramento | 67 | Greater Sacramento | 20.142857142857142 | 4.714285714285715 | 55.285714285714285 | 60.0 | 0.9214285714285714 | 0.3643410852713178 |
30443 | 30443 | Lompoc Valley Medical Center | 50110 | 2021-01-22 | Santa Barbara | 83 | Southern California | 5.0 | 0.0 | 6.0 | 6.0 | 1.0 | 0.8333333333333334 |
30530 | 30530 | Santa Monica - UCLA Medical Center & Orthopaedic Hospital | 50112 | 2021-01-22 | Los Angeles | 37 | Southern California | 10.571428571428571 | 3.428571428571427 | 18.571428571428573 | 22.0 | 0.8441558441558442 | 0.5692307692307692 |
30526 | 30526 | San Mateo Medical Center | 50113 | 2021-01-22 | San Mateo | 81 | Bay Area | 5.571428571428571 | 0.5714285714285712 | 6.428571428571429 | 7.0 | 0.9183673469387756 | 0.8666666666666666 |
30488 | 30488 | Palomar Health Downtown Campus | 50115 | 2021-01-22 | San Diego | 73 | Southern California | 44.285714285714285 | 0.0 | 48.0 | 48.0 | 1.0 | 0.9226190476190476 |
30478 | 30478 | Northridge Hospital Medical Center | 50116 | 2021-01-22 | Los Angeles | 37 | Southern California | 40.285714285714285 | 2.5714285714285765 | 49.85714285714285 | 52.42857142857143 | 0.9509536784741144 | 0.8080229226361032 |
30345 | 30345 | Doctors Hospital of Manteca | 50118 | 2021-01-22 | San Joaquin | 77 | San Joaquin Valley | 5.857142857142857 | 1.0 | 7.0 | 8.0 | 0.875 | 0.836734693877551 |
30293 | 30293 | Adventist Health Hanford | 50121 | 2021-01-22 | Kings | 31 | San Joaquin Valley | 10.285714285714286 | 4.285714285714285 | 22.714285714285715 | 27.0 | 0.8412698412698413 | 0.4528301886792453 |
30342 | 30342 | Dameron Hospital | 50122 | 2021-01-22 | San Joaquin | 77 | San Joaquin Valley | 7.0 | 3.2857142857142865 | 10.571428571428571 | 13.857142857142858 | 0.7628865979381443 | 0.6621621621621622 |
30580 | 30580 | USC Verdugo Hills Hospital | 50124 | 2021-01-22 | Los Angeles | 37 | Southern California | 7.142857142857143 | 2.1428571428571423 | 10.0 | 12.142857142857142 | 0.823529411764706 | 0.7142857142857143 |
30511 | 30511 | Regional Medical Center of San Jose | 50125 | 2021-01-22 | Santa Clara | 85 | Bay Area | 29.571428571428573 | 0.0 | 51.285714285714285 | 51.285714285714285 | 1.0 | 0.5766016713091923 |
30594 | 30594 | Woodland Memorial Hospital | 50127 | 2021-01-22 | Yolo | 113 | Greater Sacramento | 7.142857142857143 | 0.2857142857142847 | 12.428571428571429 | 12.714285714285714 | 0.9775280898876404 | 0.5747126436781609 |
30576 | 30576 | Tri-city Medical Center | 50128 | 2021-01-22 | San Diego | 73 | Southern California | 19.0 | 0.571428571428573 | 26.285714285714285 | 26.857142857142858 | 0.9787234042553192 | 0.7228260869565217 |
30549 | 30549 | St. Bernardine Medical Center | 50129 | 2021-01-22 | San Bernardino | 71 | Southern California | 27.857142857142858 | 4.571428571428569 | 41.71428571428572 | 46.285714285714285 | 0.9012345679012346 | 0.6678082191780822 |
30479 | 30479 | Novato Community Hospital | 50131 | 2021-01-22 | Marin | 41 | Bay Area | 2.0 | 3.0 | 3.0 | 6.0 | 0.5 | 0.6666666666666666 |
30523 | 30523 | San Gabriel Valley Medical Center | 50132 | 2021-01-22 | Los Angeles | 37 | Southern California | 13.571428571428571 | 0.2857142857142847 | 17.571428571428573 | 17.857142857142858 | 0.984 | 0.7723577235772356 |
30303 | 30303 | Adventist Health and Rideout | 50133 | 2021-01-22 | Yuba | 115 | Greater Sacramento | 11.714285714285714 | 2.8571428571428577 | 26.714285714285715 | 29.571428571428573 | 0.9033816425120772 | 0.4385026737967914 |
30547 | 30547 | Southern California Hospital at Hollywood | 50135 | 2021-01-22 | Los Angeles | 37 | Southern California | 15.142857142857142 | 9.285714285714285 | 24.714285714285715 | 34.0 | 0.7268907563025211 | 0.6127167630057803 |
30491 | 30491 | Petaluma Valley Hospital | 50136 | 2021-01-22 | Sonoma | 97 | Bay Area | 3.0 | 0.4285714285714279 | 4.142857142857143 | 4.571428571428571 | 0.90625 | 0.7241379310344827 |
30396 | 30396 | Kaiser Foundation Hospital - Panorama City | 50137 | 2021-01-22 | Los Angeles | 37 | Southern California | 31.428571428571427 | 0.0 | 34.142857142857146 | 34.142857142857146 | 1.0 | 0.920502092050209 |
30393 | 30393 | Kaiser Foundation Hospital - Los Angeles | 50138 | 2021-01-22 | Los Angeles | 37 | Southern California | 36.42857142857143 | 18.57142857142857 | 70.42857142857143 | 89.0 | 0.7913322632423756 | 0.5172413793103449 |
30390 | 30390 | Kaiser Foundation Hospital - Downey | 50139 | 2021-01-22 | Los Angeles | 37 | Southern California | 40.285714285714285 | 0.0 | 47.285714285714285 | 47.285714285714285 | 1.0 | 0.851963746223565 |
30409 | 30409 | Kaiser Foundation Hospital Fontana | 50140 | 2021-01-22 | San Bernardino | 71 | Southern California | 72.71428571428571 | 12.285714285714292 | 97.0 | 109.28571428571428 | 0.8875816993464052 | 0.7496318114874815 |
30337 | 30337 | Community Hospital of the Monterey Peninsula | 50145 | 2021-01-22 | Monterey | 53 | Bay Area | 7.428571428571429 | 9.0 | 17.0 | 26.0 | 0.6538461538461539 | 0.4369747899159664 |
30330 | 30330 | City of Hope Helford Clinical Research Hospital | 50146 | 2021-01-22 | Los Angeles | 37 | Southern California | 3.857142857142857 | 2.1428571428571423 | 15.857142857142858 | 18.0 | 0.8809523809523809 | 0.2432432432432432 |
30320 | 30320 | California Hospital Medical Center LA | 50149 | 2021-01-22 | Los Angeles | 37 | Southern California | 26.142857142857142 | 6.285714285714285 | 43.71428571428572 | 50.0 | 0.8742857142857143 | 0.5980392156862745 |
30542 | 30542 | Sierra Nevada Memorial Hospital | 50150 | 2021-01-22 | Nevada | 57 | Greater Sacramento | 2.5 | 1.666666666666667 | 6.333333333333333 | 8.0 | 0.7916666666666666 | 0.3947368421052631 |
30518 | 30518 | Saint Francis Memorial Hospital | 50152 | 2021-01-22 | San Francisco | 75 | Bay Area | 2.571428571428572 | 12.0 | 8.0 | 20.0 | 0.4 | 0.3214285714285714 |
30357 | 30357 | Encino Hospital Medical Center | 50158 | 2021-01-22 | Los Angeles | 37 | Southern California | 4.285714285714286 | 0.0 | 5.285714285714286 | 5.285714285714286 | 1.0 | 0.8108108108108109 |
30585 | 30585 | Ventura County Medical Center | 50159 | 2021-01-22 | Ventura | 111 | Southern California | 6.571428571428571 | 5.857142857142858 | 10.142857142857142 | 16.0 | 0.6339285714285714 | 0.647887323943662 |
30525 | 30525 | San Joaquin General Hospital | 50167 | 2021-01-22 | San Joaquin | 77 | San Joaquin Valley | 14.714285714285714 | 0.0 | 30.142857142857142 | 30.142857142857142 | 1.0 | 0.4881516587677725 |
30509 | 30509 | Providence St. Jude Medical Center | 50168 | 2021-01-22 | Orange | 59 | Southern California | 23.285714285714285 | 1.7142857142857224 | 65.71428571428571 | 67.42857142857143 | 0.9745762711864404 | 0.3543478260869565 |
30494 | 30494 | Pih Health Hospital-Whittier | 50169 | 2021-01-22 | Los Angeles | 37 | Southern California | 37.285714285714285 | 9.142857142857146 | 50.285714285714285 | 59.42857142857143 | 0.8461538461538461 | 0.7414772727272727 |
30506 | 30506 | Providence Santa Rosa Memorial Hospital | 50174 | 2021-01-22 | Sonoma | 97 | Bay Area | 7.0 | 4.428571428571427 | 21.571428571428573 | 26.0 | 0.8296703296703297 | 0.3245033112582781 |
30356 | 30356 | Emanuel Medical Center | 50179 | 2021-01-22 | Stanislaus | 99 | San Joaquin Valley | 5.428571428571429 | 2.1428571428571423 | 9.857142857142858 | 12.0 | 0.8214285714285715 | 0.5507246376811594 |
30385 | 30385 | John Muir Medical Center - Walnut Creek Campus | 50180 | 2021-01-22 | Contra Costa | 13 | Bay Area | 11.714285714285714 | 5.428571428571431 | 52.71428571428572 | 58.142857142857146 | 0.9066339066339066 | 0.2222222222222222 |
30555 | 30555 | St. Mary Medical Center | 50191 | 2021-01-22 | Los Angeles | 37 | Southern California | 32.857142857142854 | 16.57142857142857 | 43.42857142857143 | 60.0 | 0.7238095238095238 | 0.7565789473684209 |
30589 | 30589 | Watsonville Community Hospital | 50194 | 2021-01-22 | Santa Cruz | 87 | Bay Area | 2.2857142857142856 | 1.1428571428571432 | 4.857142857142857 | 6.0 | 0.8095238095238094 | 0.4705882352941176 |
30588 | 30588 | Washington Hospital | 50195 | 2021-01-22 | Alameda | 1 | Bay Area | 14.285714285714286 | 0.8571428571428577 | 28.142857142857142 | 29.0 | 0.9704433497536946 | 0.5076142131979696 |
30536 | 30536 | Sequoia Hospital | 50197 | 2021-01-22 | San Mateo | 81 | Bay Area | 10.285714285714286 | 2.428571428571429 | 15.571428571428571 | 18.0 | 0.8650793650793651 | 0.6605504587155964 |
30487 | 30487 | Palmdale Regional Medical Center | 50204 | 2021-01-22 | Los Angeles | 37 | Southern California | 15.142857142857142 | 5.857142857142858 | 18.142857142857142 | 24.0 | 0.7559523809523809 | 0.8346456692913385 |
30306 | 30306 | Alameda Hospital | 50211 | 2021-01-22 | Alameda | 1 | Bay Area | 5.714285714285714 | 1.5714285714285712 | 6.428571428571429 | 8.0 | 0.8035714285714286 | 0.8888888888888888 |
30537 | 30537 | Sharp Chula Vista Medical Center | 50222 | 2021-01-22 | San Diego | 73 | Southern California | 37.142857142857146 | 1.7142857142857153 | 51.85714285714285 | 53.57142857142857 | 0.968 | 0.7162534435261709 |
30379 | 30379 | Hoag Memorial Hospital Presbyterian | 50224 | 2021-01-22 | Orange | 59 | Southern California | 35.142857142857146 | 10.714285714285715 | 51.57142857142857 | 62.285714285714285 | 0.8279816513761468 | 0.6814404432132964 |
30304 | 30304 | Ahmc Anaheim Regional Medical Center | 50226 | 2021-01-22 | Orange | 59 | Southern California | 21.285714285714285 | 0.2857142857142847 | 25.714285714285715 | 26.0 | 0.989010989010989 | 0.8277777777777777 |
30595 | 30595 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2021-01-22 | San Francisco | 75 | Bay Area | 7.714285714285714 | 0.5714285714285694 | 40.71428571428572 | 41.285714285714285 | 0.986159169550173 | 0.1894736842105263 |
30364 | 30364 | Garden Grove Hospital & Medical Center | 50230 | 2021-01-22 | Orange | 59 | Southern California | 16.142857142857142 | 0.1428571428571423 | 16.285714285714285 | 16.428571428571427 | 0.991304347826087 | 0.9912280701754388 |
30497 | 30497 | Pomona Valley Hospital Medical Center | 50231 | 2021-01-22 | Los Angeles | 37 | Southern California | 42.42857142857143 | 4.857142857142861 | 75.71428571428571 | 80.57142857142857 | 0.9397163120567376 | 0.5603773584905661 |
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 );