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 descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
561 | 561 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2022-12-16 | San Francisco | 75 | Bay Area | 1.5714285714285714 | 0.1428571428571388 | 39.42857142857143 | 39.57142857142857 | 0.996389891696751 | 0.0398550724637681 |
861 | 861 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2022-12-09 | San Francisco | 75 | Bay Area | 1.5714285714285714 | 0.4285714285714306 | 39.285714285714285 | 39.71428571428572 | 0.9892086330935252 | 0.04 |
1159 | 1159 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2022-12-02 | San Francisco | 75 | Bay Area | 0.7142857142857143 | 4.285714285714285 | 35.42857142857143 | 39.71428571428572 | 0.8920863309352518 | 0.0201612903225806 |
1458 | 1458 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2022-11-25 | San Francisco | 75 | Bay Area | 0.0 | 3.2857142857142847 | 34.714285714285715 | 38.0 | 0.9135338345864662 | 0.0 |
1756 | 1756 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2022-11-18 | San Francisco | 75 | Bay Area | 0.5714285714285714 | 7.714285714285715 | 30.285714285714285 | 38.0 | 0.7969924812030075 | 0.0188679245283018 |
2056 | 2056 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2022-11-11 | San Francisco | 75 | Bay Area | 2.142857142857143 | 5.142857142857146 | 32.857142857142854 | 38.0 | 0.8646616541353382 | 0.0652173913043478 |
2355 | 2355 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2022-11-04 | San Francisco | 75 | Bay Area | 1.4285714285714286 | 5.714285714285715 | 32.285714285714285 | 38.0 | 0.849624060150376 | 0.0442477876106194 |
2655 | 2655 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2022-10-28 | San Francisco | 75 | Bay Area | 2.142857142857143 | 8.142857142857142 | 29.857142857142858 | 38.0 | 0.7857142857142857 | 0.0717703349282296 |
2955 | 2955 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2022-10-21 | San Francisco | 75 | Bay Area | 1.2857142857142858 | 8.428571428571427 | 29.571428571428573 | 38.0 | 0.7781954887218046 | 0.0434782608695652 |
3255 | 3255 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2022-10-14 | San Francisco | 75 | Bay Area | 2.4285714285714284 | 7.714285714285715 | 30.285714285714285 | 38.0 | 0.7969924812030075 | 0.080188679245283 |
3556 | 3556 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2022-10-07 | San Francisco | 75 | Bay Area | 2.571428571428572 | 8.428571428571427 | 29.571428571428573 | 38.0 | 0.7781954887218046 | 0.0869565217391304 |
3858 | 3858 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2022-09-30 | San Francisco | 75 | Bay Area | 0.0 | 11.0 | 27.0 | 38.0 | 0.7105263157894737 | 0.0 |
4159 | 4159 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2022-09-23 | San Francisco | 75 | Bay Area | 0.0 | 13.0 | 25.0 | 38.0 | 0.6578947368421053 | 0.0 |
4456 | 4456 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2022-09-16 | San Francisco | 75 | Bay Area | 0.0 | 6.571428571428573 | 31.428571428571427 | 38.0 | 0.8270676691729323 | 0.0 |
4753 | 4753 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2022-09-09 | San Francisco | 75 | Bay Area | 1.0 | 6.285714285714285 | 31.714285714285715 | 38.0 | 0.8345864661654135 | 0.0315315315315315 |
5049 | 5049 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2022-09-02 | San Francisco | 75 | Bay Area | 2.0 | 7.857142857142858 | 30.142857142857142 | 38.0 | 0.793233082706767 | 0.0663507109004739 |
5345 | 5345 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2022-08-26 | San Francisco | 75 | Bay Area | 2.4285714285714284 | 10.285714285714285 | 27.714285714285715 | 38.0 | 0.7293233082706767 | 0.0876288659793814 |
5647 | 5647 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2022-08-19 | San Francisco | 75 | Bay Area | 1.0 | 10.857142857142858 | 27.142857142857142 | 38.0 | 0.7142857142857143 | 0.0368421052631579 |
5950 | 5950 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2022-08-12 | San Francisco | 75 | Bay Area | 1.0 | 15.571428571428571 | 22.428571428571427 | 38.0 | 0.5902255639097744 | 0.0445859872611465 |
6253 | 6253 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2022-08-05 | San Francisco | 75 | Bay Area | 1.5714285714285714 | 13.142857142857142 | 24.857142857142858 | 38.0 | 0.6541353383458647 | 0.0632183908045977 |
6553 | 6553 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2022-07-29 | San Francisco | 75 | Bay Area | 2.142857142857143 | 8.857142857142858 | 29.142857142857142 | 38.0 | 0.7669172932330827 | 0.0735294117647058 |
6852 | 6852 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2022-07-22 | San Francisco | 75 | Bay Area | 2.142857142857143 | 11.714285714285715 | 26.285714285714285 | 38.0 | 0.6917293233082706 | 0.0815217391304347 |
7151 | 7151 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2022-07-15 | San Francisco | 75 | Bay Area | 1.5714285714285714 | 11.857142857142858 | 26.142857142857142 | 38.0 | 0.68796992481203 | 0.0601092896174863 |
7454 | 7454 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2022-07-08 | San Francisco | 75 | Bay Area | 3.142857142857143 | 10.571428571428571 | 27.428571428571427 | 38.0 | 0.7218045112781954 | 0.1145833333333333 |
7752 | 7752 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2022-07-01 | San Francisco | 75 | Bay Area | 2.142857142857143 | 10.142857142857142 | 27.857142857142858 | 38.0 | 0.7330827067669173 | 0.0769230769230769 |
8050 | 8050 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2022-06-24 | San Francisco | 75 | Bay Area | 2.0 | 10.285714285714285 | 27.714285714285715 | 38.0 | 0.7293233082706767 | 0.0721649484536082 |
8352 | 8352 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2022-06-17 | San Francisco | 75 | Bay Area | 2.857142857142857 | 8.285714285714285 | 29.714285714285715 | 38.0 | 0.7819548872180452 | 0.0961538461538461 |
8653 | 8653 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2022-06-10 | San Francisco | 75 | Bay Area | 3.142857142857143 | 7.857142857142858 | 30.142857142857142 | 38.0 | 0.793233082706767 | 0.1042654028436018 |
8954 | 8954 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2022-06-03 | San Francisco | 75 | Bay Area | 1.7142857142857142 | 9.285714285714285 | 28.714285714285715 | 38.0 | 0.7556390977443609 | 0.0597014925373134 |
9255 | 9255 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2022-05-27 | San Francisco | 75 | Bay Area | 2.4285714285714284 | 7.714285714285715 | 30.285714285714285 | 38.0 | 0.7969924812030075 | 0.080188679245283 |
9554 | 9554 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2022-05-20 | San Francisco | 75 | Bay Area | 2.857142857142857 | 7.857142857142858 | 30.142857142857142 | 38.0 | 0.793233082706767 | 0.0947867298578199 |
9855 | 9855 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2022-05-13 | San Francisco | 75 | Bay Area | 2.0 | 6.285714285714285 | 31.714285714285715 | 38.0 | 0.8345864661654135 | 0.063063063063063 |
10156 | 10156 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2022-05-06 | San Francisco | 75 | Bay Area | 0.8571428571428571 | 10.142857142857142 | 27.857142857142858 | 38.0 | 0.7330827067669173 | 0.0307692307692307 |
10456 | 10456 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2022-04-29 | San Francisco | 75 | Bay Area | 0.8571428571428571 | 9.0 | 29.0 | 38.0 | 0.7631578947368421 | 0.0295566502463054 |
10757 | 10757 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2022-04-22 | San Francisco | 75 | Bay Area | 1.0 | 10.857142857142858 | 27.142857142857142 | 38.0 | 0.7142857142857143 | 0.0368421052631579 |
11058 | 11058 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2022-04-15 | San Francisco | 75 | Bay Area | 1.1428571428571428 | 7.285714285714285 | 30.714285714285715 | 38.0 | 0.8082706766917294 | 0.0372093023255813 |
11360 | 11360 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2022-04-08 | San Francisco | 75 | Bay Area | 1.1428571428571428 | 9.428571428571429 | 28.571428571428573 | 38.0 | 0.7518796992481204 | 0.0399999999999999 |
11663 | 11663 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2022-04-01 | San Francisco | 75 | Bay Area | 0.8571428571428571 | 6.857142857142858 | 31.142857142857142 | 38.0 | 0.8195488721804511 | 0.0275229357798165 |
11965 | 11965 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2022-03-25 | San Francisco | 75 | Bay Area | 0.0 | 12.0 | 26.0 | 38.0 | 0.6842105263157895 | 0.0 |
12270 | 12270 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2022-03-18 | San Francisco | 75 | Bay Area | 0.5714285714285714 | 13.142857142857142 | 24.857142857142858 | 38.0 | 0.6541353383458647 | 0.0229885057471264 |
12575 | 12575 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2022-03-11 | San Francisco | 75 | Bay Area | 0.0 | 7.285714285714285 | 29.285714285714285 | 36.57142857142857 | 0.80078125 | 0.0 |
12878 | 12878 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2022-03-04 | San Francisco | 75 | Bay Area | 0.0 | 7.428571428571427 | 30.571428571428573 | 38.0 | 0.8045112781954887 | 0.0 |
13182 | 13182 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2022-02-25 | San Francisco | 75 | Bay Area | 1.0 | 7.0 | 31.0 | 38.0 | 0.8157894736842105 | 0.032258064516129 |
13487 | 13487 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2022-02-18 | San Francisco | 75 | Bay Area | 3.2857142857142856 | 3.285714285714292 | 34.857142857142854 | 38.142857142857146 | 0.9138576779026216 | 0.0942622950819672 |
13792 | 13792 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2022-02-11 | San Francisco | 75 | Bay Area | 7.0 | 5.285714285714285 | 32.714285714285715 | 38.0 | 0.8609022556390977 | 0.2139737991266375 |
14097 | 14097 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2022-02-04 | San Francisco | 75 | Bay Area | 5.571428571428571 | 5.571428571428569 | 32.42857142857143 | 38.0 | 0.8533834586466166 | 0.171806167400881 |
14402 | 14402 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2022-01-28 | San Francisco | 75 | Bay Area | 7.714285714285714 | 5.571428571428569 | 32.42857142857143 | 38.0 | 0.8533834586466166 | 0.237885462555066 |
14705 | 14705 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2022-01-21 | San Francisco | 75 | Bay Area | 8.285714285714286 | 1.4285714285714306 | 37.0 | 38.42857142857143 | 0.9628252788104088 | 0.2239382239382239 |
15010 | 15010 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2022-01-14 | San Francisco | 75 | Bay Area | 8.285714285714286 | 5.714285714285715 | 32.857142857142854 | 38.57142857142857 | 0.8518518518518519 | 0.2521739130434783 |
15315 | 15315 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2022-01-07 | San Francisco | 75 | Bay Area | 7.714285714285714 | 5.0 | 33.0 | 38.0 | 0.868421052631579 | 0.2337662337662337 |
15619 | 15619 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2021-12-31 | San Francisco | 75 | Bay Area | 6.571428571428571 | 5.857142857142854 | 32.142857142857146 | 38.0 | 0.8458646616541354 | 0.2044444444444444 |
15921 | 15921 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2021-12-24 | San Francisco | 75 | Bay Area | 3.0 | 9.571428571428571 | 28.428571428571427 | 38.0 | 0.7481203007518796 | 0.1055276381909547 |
16226 | 16226 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2021-12-17 | San Francisco | 75 | Bay Area | 2.4285714285714284 | 5.714285714285715 | 32.285714285714285 | 38.0 | 0.849624060150376 | 0.075221238938053 |
16532 | 16532 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2021-12-10 | San Francisco | 75 | Bay Area | 1.2857142857142858 | 5.142857142857146 | 32.857142857142854 | 38.0 | 0.8646616541353382 | 0.0391304347826087 |
16838 | 16838 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2021-12-03 | San Francisco | 75 | Bay Area | 0.0 | 6.428571428571427 | 31.571428571428573 | 38.0 | 0.830827067669173 | 0.0 |
17142 | 17142 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2021-11-26 | San Francisco | 75 | Bay Area | 0.0 | 5.571428571428569 | 32.42857142857143 | 38.0 | 0.8533834586466166 | 0.0 |
17446 | 17446 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2021-11-19 | San Francisco | 75 | Bay Area | 1.1428571428571428 | 6.0 | 32.0 | 38.0 | 0.8421052631578947 | 0.0357142857142857 |
17750 | 17750 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2021-11-12 | San Francisco | 75 | Bay Area | 1.4285714285714286 | 4.428571428571431 | 33.57142857142857 | 38.0 | 0.8834586466165413 | 0.0425531914893617 |
18054 | 18054 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2021-11-05 | San Francisco | 75 | Bay Area | 1.0 | 6.285714285714285 | 31.714285714285715 | 38.0 | 0.8345864661654135 | 0.0315315315315315 |
18360 | 18360 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2021-10-29 | San Francisco | 75 | Bay Area | 0.8571428571428571 | 8.714285714285715 | 29.285714285714285 | 38.0 | 0.7706766917293233 | 0.0292682926829268 |
18666 | 18666 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2021-10-22 | San Francisco | 75 | Bay Area | 0.0 | 9.0 | 29.0 | 38.0 | 0.7631578947368421 | 0.0 |
18971 | 18971 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2021-10-15 | San Francisco | 75 | Bay Area | 0.8571428571428571 | 6.428571428571427 | 31.571428571428573 | 38.0 | 0.830827067669173 | 0.0271493212669683 |
19277 | 19277 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2021-10-08 | San Francisco | 75 | Bay Area | 1.0 | 6.857142857142858 | 31.142857142857142 | 38.0 | 0.8195488721804511 | 0.0321100917431192 |
19584 | 19584 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2021-10-01 | San Francisco | 75 | Bay Area | 2.857142857142857 | 7.285714285714285 | 30.714285714285715 | 38.0 | 0.8082706766917294 | 0.0930232558139534 |
19891 | 19891 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2021-09-24 | San Francisco | 75 | Bay Area | 2.2857142857142856 | 9.285714285714285 | 28.714285714285715 | 38.0 | 0.7556390977443609 | 0.0796019900497512 |
20197 | 20197 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2021-09-17 | San Francisco | 75 | Bay Area | 3.4285714285714284 | 10.857142857142858 | 27.142857142857142 | 38.0 | 0.7142857142857143 | 0.1263157894736842 |
20504 | 20504 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2021-09-10 | San Francisco | 75 | Bay Area | 4.714285714285714 | 10.0 | 28.0 | 38.0 | 0.7368421052631579 | 0.1683673469387755 |
20810 | 20810 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2021-09-03 | San Francisco | 75 | Bay Area | 5.571428571428571 | 8.142857142857142 | 29.857142857142858 | 38.0 | 0.7857142857142857 | 0.1866028708133971 |
21116 | 21116 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2021-08-27 | San Francisco | 75 | Bay Area | 7.142857142857143 | 6.571428571428573 | 31.428571428571427 | 38.0 | 0.8270676691729323 | 0.2272727272727273 |
21421 | 21421 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2021-08-20 | San Francisco | 75 | Bay Area | 5.142857142857143 | 9.142857142857142 | 28.857142857142858 | 38.0 | 0.7593984962406015 | 0.1782178217821782 |
21726 | 21726 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2021-08-13 | San Francisco | 75 | Bay Area | 5.285714285714286 | 8.142857142857142 | 29.857142857142858 | 38.0 | 0.7857142857142857 | 0.1770334928229665 |
22032 | 22032 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2021-08-06 | San Francisco | 75 | Bay Area | 2.7142857142857144 | 8.857142857142858 | 29.142857142857142 | 38.0 | 0.7669172932330827 | 0.0931372549019607 |
22339 | 22339 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2021-07-30 | San Francisco | 75 | Bay Area | 3.142857142857143 | 11.285714285714285 | 26.714285714285715 | 38.0 | 0.7030075187969925 | 0.1176470588235294 |
22644 | 22644 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2021-07-23 | San Francisco | 75 | Bay Area | 2.857142857142857 | 7.142857142857142 | 30.857142857142858 | 38.0 | 0.81203007518797 | 0.0925925925925925 |
22950 | 22950 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2021-07-16 | San Francisco | 75 | Bay Area | 1.7142857142857142 | 7.428571428571427 | 30.571428571428573 | 38.0 | 0.8045112781954887 | 0.0560747663551401 |
23257 | 23257 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2021-07-09 | San Francisco | 75 | Bay Area | 1.8571428571428568 | 8.428571428571427 | 29.571428571428573 | 38.0 | 0.7781954887218046 | 0.0628019323671497 |
23562 | 23562 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2021-07-02 | San Francisco | 75 | Bay Area | 1.0 | 12.0 | 26.0 | 38.0 | 0.6842105263157895 | 0.0384615384615384 |
23869 | 23869 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2021-06-25 | San Francisco | 75 | Bay Area | 0.0 | 13.285714285714285 | 24.714285714285715 | 38.0 | 0.650375939849624 | 0.0 |
24176 | 24176 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2021-06-18 | San Francisco | 75 | Bay Area | 0.0 | 18.857142857142858 | 19.142857142857142 | 38.0 | 0.5037593984962406 | 0.0 |
24481 | 24481 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2021-06-11 | San Francisco | 75 | Bay Area | 0.0 | 15.428571428571429 | 22.571428571428573 | 38.0 | 0.5939849624060151 | 0.0 |
24788 | 24788 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2021-06-04 | San Francisco | 75 | Bay Area | 1.8571428571428568 | 8.857142857142858 | 29.142857142857142 | 38.0 | 0.7669172932330827 | 0.0637254901960784 |
25093 | 25093 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2021-05-28 | San Francisco | 75 | Bay Area | 2.0 | 7.571428571428573 | 30.428571428571427 | 38.0 | 0.8007518796992481 | 0.0657276995305164 |
25400 | 25400 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2021-05-21 | San Francisco | 75 | Bay Area | 1.5714285714285714 | 9.142857142857142 | 28.857142857142858 | 38.0 | 0.7593984962406015 | 0.0544554455445544 |
25705 | 25705 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2021-05-14 | San Francisco | 75 | Bay Area | 1.2857142857142858 | 7.142857142857142 | 30.857142857142858 | 38.0 | 0.81203007518797 | 0.0416666666666666 |
26006 | 26006 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2021-05-07 | San Francisco | 75 | Bay Area | 1.2857142857142858 | 6.285714285714285 | 31.714285714285715 | 38.0 | 0.8345864661654135 | 0.0405405405405405 |
26314 | 26314 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2021-04-30 | San Francisco | 75 | Bay Area | 1.0 | 8.142857142857142 | 29.857142857142858 | 38.0 | 0.7857142857142857 | 0.0334928229665071 |
26620 | 26620 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2021-04-23 | San Francisco | 75 | Bay Area | 2.142857142857143 | 7.571428571428573 | 30.428571428571427 | 38.0 | 0.8007518796992481 | 0.0704225352112676 |
26926 | 26926 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2021-04-16 | San Francisco | 75 | Bay Area | 2.0 | 8.142857142857142 | 28.142857142857142 | 36.285714285714285 | 0.7755905511811023 | 0.0710659898477157 |
27233 | 27233 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2021-04-09 | San Francisco | 75 | Bay Area | 1.2857142857142858 | 6.857142857142858 | 31.142857142857142 | 38.0 | 0.8195488721804511 | 0.0412844036697247 |
27537 | 27537 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2021-04-02 | San Francisco | 75 | Bay Area | 0.8571428571428571 | 6.857142857142858 | 31.142857142857142 | 38.0 | 0.8195488721804511 | 0.0275229357798165 |
27842 | 27842 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2021-03-26 | San Francisco | 75 | Bay Area | 0.0 | 6.142857142857142 | 30.428571428571427 | 36.57142857142857 | 0.83203125 | 0.0 |
28148 | 28148 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2021-03-19 | San Francisco | 75 | Bay Area | 0.0 | 6.0 | 32.0 | 38.0 | 0.8421052631578947 | 0.0 |
28453 | 28453 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2021-03-12 | San Francisco | 75 | Bay Area | 0.5714285714285714 | 10.285714285714285 | 27.714285714285715 | 38.0 | 0.7293233082706767 | 0.0206185567010309 |
28758 | 28758 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2021-03-05 | San Francisco | 75 | Bay Area | 0.0 | 12.142857142857142 | 25.857142857142858 | 38.0 | 0.6804511278195489 | 0.0 |
29063 | 29063 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2021-02-26 | San Francisco | 75 | Bay Area | 1.1428571428571428 | 7.714285714285715 | 30.285714285714285 | 38.0 | 0.7969924812030075 | 0.0377358490566037 |
29369 | 29369 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2021-02-19 | San Francisco | 75 | Bay Area | 2.571428571428572 | 6.285714285714285 | 31.714285714285715 | 38.0 | 0.8345864661654135 | 0.081081081081081 |
29676 | 29676 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2021-02-12 | San Francisco | 75 | Bay Area | 3.571428571428572 | 3.5714285714285694 | 34.42857142857143 | 38.0 | 0.906015037593985 | 0.1037344398340249 |
29982 | 29982 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2021-02-05 | San Francisco | 75 | Bay Area | 4.714285714285714 | 1.142857142857146 | 37.57142857142857 | 38.71428571428572 | 0.970479704797048 | 0.1254752851711026 |
30289 | 30289 | Zuckerberg San Francisco General Hosp & Trauma Center | 50228 | 2021-01-29 | San Francisco | 75 | Bay Area | 7.285714285714286 | 0.4285714285714306 | 38.85714285714285 | 39.285714285714285 | 0.989090909090909 | 0.1875 |
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 );