cdph-hospital-patient-county-totals
Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README
- date
- The date for which hospital data were reported in ISO 8601 format.
- county
- The name of the county.
- fips
- The FIPS code given to the county by the federal government. Can be used to merge with other data sources.
- positive_patients
- The current number confirmed coronavirus cases in hospitals on this date.
- suspected_patients
- The current number suspected coronavirus cases in hospitals on this date.
- icu_positive_patients
- The current number confirmed coronavirus cases in intensive-care units on this date.
- icu_suspected_patients
- The current number suspected coronavirus cases in intensive-care units on this date.
- icu_available_beds
- The current number open and avilable intensive-care beds on this date.
56,333 rows sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county ▼ | fips | positive_patients | suspected_patients | icu_positive_patients | icu_suspected_patients | icu_available_beds |
---|---|---|---|---|---|---|---|---|---|
1 | 1 | 2022-12-29 | Alameda | 1 | 168 | 68 | 13 | 8 | 75 |
57 | 57 | 2022-12-28 | Alameda | 1 | 180 | 61 | 21 | 5 | 81 |
113 | 113 | 2022-12-27 | Alameda | 1 | 178 | 55 | 22 | 5 | 90 |
169 | 169 | 2022-12-26 | Alameda | 1 | 167 | 63 | 17 | 8 | 90 |
225 | 225 | 2022-12-25 | Alameda | 1 | 156 | 51 | 23 | 5 | 88 |
281 | 281 | 2022-12-24 | Alameda | 1 | 170 | 47 | 24 | 5 | 75 |
337 | 337 | 2022-12-23 | Alameda | 1 | 164 | 58 | 19 | 6 | 71 |
393 | 393 | 2022-12-22 | Alameda | 1 | 168 | 65 | 18 | 7 | 73 |
449 | 449 | 2022-12-21 | Alameda | 1 | 174 | 74 | 22 | 9 | 74 |
505 | 505 | 2022-12-20 | Alameda | 1 | 173 | 78 | 23 | 11 | 79 |
561 | 561 | 2022-12-19 | Alameda | 1 | 163 | 75 | 19 | 12 | 79 |
617 | 617 | 2022-12-18 | Alameda | 1 | 170 | 68 | 18 | 14 | 86 |
673 | 673 | 2022-12-17 | Alameda | 1 | 167 | 77 | 14 | 14 | 82 |
729 | 729 | 2022-12-16 | Alameda | 1 | 192 | 73 | 28 | 14 | 66 |
785 | 785 | 2022-12-15 | Alameda | 1 | 167 | 71 | 17 | 13 | 78 |
841 | 841 | 2022-12-14 | Alameda | 1 | 174 | 81 | 20 | 11 | 72 |
897 | 897 | 2022-12-13 | Alameda | 1 | 169 | 80 | 20 | 11 | 81 |
953 | 953 | 2022-12-12 | Alameda | 1 | 167 | 69 | 20 | 12 | 79 |
1009 | 1009 | 2022-12-11 | Alameda | 1 | 155 | 66 | 17 | 13 | 84 |
1065 | 1065 | 2022-12-10 | Alameda | 1 | 153 | 81 | 11 | 15 | 79 |
1121 | 1121 | 2022-12-09 | Alameda | 1 | 154 | 67 | 16 | 13 | 73 |
1177 | 1177 | 2022-12-08 | Alameda | 1 | 155 | 64 | 13 | 11 | 78 |
1233 | 1233 | 2022-12-07 | Alameda | 1 | 145 | 74 | 12 | 9 | 79 |
1289 | 1289 | 2022-12-06 | Alameda | 1 | 149 | 62 | 12 | 9 | 82 |
1345 | 1345 | 2022-12-05 | Alameda | 1 | 139 | 51 | 13 | 8 | 85 |
1401 | 1401 | 2022-12-04 | Alameda | 1 | 129 | 54 | 18 | 8 | 81 |
1457 | 1457 | 2022-12-03 | Alameda | 1 | 121 | 47 | 13 | 11 | 81 |
1513 | 1513 | 2022-12-02 | Alameda | 1 | 138 | 59 | 17 | 10 | 81 |
1569 | 1569 | 2022-12-01 | Alameda | 1 | 131 | 68 | 16 | 11 | 68 |
1625 | 1625 | 2022-11-30 | Alameda | 1 | 119 | 62 | 14 | 10 | 85 |
1681 | 1681 | 2022-11-29 | Alameda | 1 | 122 | 60 | 14 | 13 | 83 |
1737 | 1737 | 2022-11-28 | Alameda | 1 | 116 | 53 | 13 | 8 | 91 |
1793 | 1793 | 2022-11-27 | Alameda | 1 | 108 | 59 | 15 | 8 | 97 |
1849 | 1849 | 2022-11-26 | Alameda | 1 | 113 | 56 | 14 | 14 | 90 |
1905 | 1905 | 2022-11-25 | Alameda | 1 | 110 | 46 | 13 | 10 | 100 |
1961 | 1961 | 2022-11-24 | Alameda | 1 | 102 | 45 | 12 | 10 | 96 |
2017 | 2017 | 2022-11-23 | Alameda | 1 | 102 | 48 | 16 | 7 | 89 |
2073 | 2073 | 2022-11-22 | Alameda | 1 | 90 | 56 | 15 | 9 | 82 |
2129 | 2129 | 2022-11-21 | Alameda | 1 | 98 | 51 | 16 | 7 | 95 |
2185 | 2185 | 2022-11-20 | Alameda | 1 | 97 | 46 | 16 | 6 | 96 |
2241 | 2241 | 2022-11-19 | Alameda | 1 | 84 | 54 | 16 | 7 | 89 |
2297 | 2297 | 2022-11-18 | Alameda | 1 | 86 | 47 | 17 | 9 | 82 |
2353 | 2353 | 2022-11-17 | Alameda | 1 | 86 | 49 | 13 | 5 | 76 |
2409 | 2409 | 2022-11-16 | Alameda | 1 | 85 | 40 | 10 | 4 | 86 |
2465 | 2465 | 2022-11-15 | Alameda | 1 | 78 | 44 | 10 | 2 | 87 |
2521 | 2521 | 2022-11-14 | Alameda | 1 | 86 | 43 | 9 | 3 | 98 |
2577 | 2577 | 2022-11-13 | Alameda | 1 | 84 | 53 | 8 | 5 | 93 |
2633 | 2633 | 2022-11-12 | Alameda | 1 | 82 | 59 | 9 | 9 | 93 |
2689 | 2689 | 2022-11-11 | Alameda | 1 | 85 | 53 | 10 | 8 | 86 |
2745 | 2745 | 2022-11-10 | Alameda | 1 | 77 | 42 | 6 | 3 | 100 |
2801 | 2801 | 2022-11-09 | Alameda | 1 | 85 | 47 | 12 | 5 | 109 |
2857 | 2857 | 2022-11-08 | Alameda | 1 | 61 | 46 | 11 | 4 | 95 |
2913 | 2913 | 2022-11-07 | Alameda | 1 | 69 | 42 | 11 | 5 | 114 |
2969 | 2969 | 2022-11-06 | Alameda | 1 | 64 | 41 | 9 | 7 | 106 |
3025 | 3025 | 2022-11-05 | Alameda | 1 | 60 | 45 | 9 | 5 | 102 |
3081 | 3081 | 2022-11-04 | Alameda | 1 | 67 | 36 | 9 | 2 | 100 |
3137 | 3137 | 2022-11-03 | Alameda | 1 | 69 | 38 | 5 | 2 | 105 |
3193 | 3193 | 2022-11-02 | Alameda | 1 | 65 | 31 | 3 | 1 | 104 |
3249 | 3249 | 2022-11-01 | Alameda | 1 | 55 | 42 | 3 | 3 | 110 |
3305 | 3305 | 2022-10-31 | Alameda | 1 | 61 | 39 | 4 | 4 | 110 |
3361 | 3361 | 2022-10-30 | Alameda | 1 | 55 | 39 | 5 | 4 | 107 |
3417 | 3417 | 2022-10-29 | Alameda | 1 | 49 | 45 | 5 | 4 | 108 |
3473 | 3473 | 2022-10-28 | Alameda | 1 | 54 | 42 | 7 | 2 | 115 |
3529 | 3529 | 2022-10-27 | Alameda | 1 | 53 | 38 | 8 | 3 | 100 |
3585 | 3585 | 2022-10-26 | Alameda | 1 | 52 | 31 | 7 | 4 | 107 |
3641 | 3641 | 2022-10-25 | Alameda | 1 | 51 | 28 | 9 | 4 | 108 |
3697 | 3697 | 2022-10-24 | Alameda | 1 | 56 | 40 | 10 | 2 | 108 |
3753 | 3753 | 2022-10-23 | Alameda | 1 | 57 | 34 | 10 | 1 | 108 |
3809 | 3809 | 2022-10-22 | Alameda | 1 | 54 | 29 | 11 | 5 | 99 |
3865 | 3865 | 2022-10-21 | Alameda | 1 | 53 | 26 | 7 | 3 | 97 |
3921 | 3921 | 2022-10-20 | Alameda | 1 | 58 | 27 | 9 | 5 | 101 |
3977 | 3977 | 2022-10-19 | Alameda | 1 | 58 | 28 | 9 | 4 | 107 |
4033 | 4033 | 2022-10-18 | Alameda | 1 | 67 | 31 | 10 | 3 | 102 |
4089 | 4089 | 2022-10-17 | Alameda | 1 | 68 | 44 | 8 | 3 | 103 |
4145 | 4145 | 2022-10-16 | Alameda | 1 | 69 | 35 | 12 | 2 | 107 |
4201 | 4201 | 2022-10-15 | Alameda | 1 | 70 | 32 | 13 | 6 | 106 |
4257 | 4257 | 2022-10-14 | Alameda | 1 | 70 | 27 | 12 | 5 | 101 |
4313 | 4313 | 2022-10-13 | Alameda | 1 | 66 | 21 | 12 | 3 | 102 |
4369 | 4369 | 2022-10-12 | Alameda | 1 | 64 | 18 | 11 | 1 | 89 |
4425 | 4425 | 2022-10-11 | Alameda | 1 | 64 | 31 | 7 | 1 | 98 |
4481 | 4481 | 2022-10-10 | Alameda | 1 | 52 | 25 | 7 | 2 | 110 |
4537 | 4537 | 2022-10-09 | Alameda | 1 | 55 | 31 | 13 | 2 | 110 |
4593 | 4593 | 2022-10-08 | Alameda | 1 | 52 | 23 | 10 | 4 | 110 |
4649 | 4649 | 2022-10-07 | Alameda | 1 | 56 | 30 | 11 | 3 | 110 |
4705 | 4705 | 2022-10-06 | Alameda | 1 | 66 | 23 | 10 | 1 | 99 |
4761 | 4761 | 2022-10-05 | Alameda | 1 | 57 | 30 | 8 | 2 | 91 |
4817 | 4817 | 2022-10-04 | Alameda | 1 | 62 | 31 | 6 | 3 | 90 |
4873 | 4873 | 2022-10-03 | Alameda | 1 | 59 | 28 | 5 | 0 | 91 |
4929 | 4929 | 2022-10-02 | Alameda | 1 | 53 | 29 | 4 | 0 | 94 |
4985 | 4985 | 2022-10-01 | Alameda | 1 | 53 | 25 | 7 | 0 | 93 |
5041 | 5041 | 2022-09-30 | Alameda | 1 | 58 | 27 | 7 | 1 | 97 |
5097 | 5097 | 2022-09-29 | Alameda | 1 | 72 | 27 | 8 | 1 | 94 |
5153 | 5153 | 2022-09-28 | Alameda | 1 | 73 | 32 | 8 | 3 | 89 |
5209 | 5209 | 2022-09-27 | Alameda | 1 | 85 | 37 | 7 | 3 | 90 |
5265 | 5265 | 2022-09-26 | Alameda | 1 | 81 | 36 | 4 | 3 | 99 |
5321 | 5321 | 2022-09-25 | Alameda | 1 | 81 | 35 | 5 | 4 | 92 |
5377 | 5377 | 2022-09-24 | Alameda | 1 | 85 | 37 | 8 | 5 | 93 |
5433 | 5433 | 2022-09-23 | Alameda | 1 | 80 | 40 | 5 | 5 | 94 |
5489 | 5489 | 2022-09-22 | Alameda | 1 | 82 | 40 | 5 | 3 | 92 |
5545 | 5545 | 2022-09-21 | Alameda | 1 | 82 | 32 | 9 | 2 | 90 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "cdph-hospital-patient-county-totals" ( [date] TEXT, [county] TEXT, [fips] INTEGER, [positive_patients] INTEGER, [suspected_patients] INTEGER, [icu_positive_patients] INTEGER, [icu_suspected_patients] INTEGER, [icu_available_beds] INTEGER );