⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: Reusing the data · Data source: California Department of Public Health via The Los Angeles Times · About: Data dictionary for la_times_cdph_hospital_patient_county_totals

18,813 rows sorted by date descending

View and edit SQL

Suggested facets: date (date)

Link rowid date ▲ county fips positive_patients suspected_patients icu_positive_patients icu_suspected_patients icu_available_beds
1 2021-02-27 Alameda 1 163 26 38 4 95
2 2021-02-27 Amador 5 3 0 1 0 2
3 2021-02-27 Butte 7 23 0 4 0 10
4 2021-02-27 Calaveras 9 1 0 1 0 5
5 2021-02-27 Colusa 11 0 0 0 0 5
6 2021-02-27 Contra Costa 13 78 16 26 1 47
7 2021-02-27 Del Norte 15 1 0 0 0 0
8 2021-02-27 El Dorado 17 4 1 1 1 3
9 2021-02-27 Fresno 19 201 22 41 1 14
10 2021-02-27 Glenn 21 0 0 0 0 0
11 2021-02-27 Humboldt 23 6 3 0 1 9
12 2021-02-27 Imperial 25 21 2 9 0 1
13 2021-02-27 Inyo 27 1 0 0 0 2
14 2021-02-27 Kern 29 159 3 53 0 28
15 2021-02-27 Kings 31 37 0 7 0 6
16 2021-02-27 Lake 33 1 0 1 0 5
17 2021-02-27 Lassen 35 0 0 0 0 0
18 2021-02-27 Los Angeles 37 1578 183 495 29 465
19 2021-02-27 Madera 39 26 7 5 0 2
20 2021-02-27 Marin 41 13 3 4 1 18
21 2021-02-27 Mariposa 43 0 0 0 0 0
22 2021-02-27 Mendocino 45 6 0 3 0 3
23 2021-02-27 Merced 47 33 0 6 0 8
24 2021-02-27 Modoc 49 0 0 0 0 0
25 2021-02-27 Mono 51 1 0 0 0 2
26 2021-02-27 Monterey 53 38 3 9 0 14
27 2021-02-27 Napa 55 8 0 2 0 11
28 2021-02-27 Nevada 57 2 2 1 0 2
29 2021-02-27 Orange 59 421 22 132 5 245
30 2021-02-27 Placer 61 61 9 16 0 21
31 2021-02-27 Plumas 63 0 0 0 0 0
32 2021-02-27 Riverside 65 328 50 90 4 60
33 2021-02-27 Sacramento 67 165 22 49 6 68
34 2021-02-27 San Benito 69 4 0 3 0 0
35 2021-02-27 San Bernardino 71 299 23 78 4 116
36 2021-02-27 San Diego 73 485 34 156 6 205
37 2021-02-27 San Francisco 75 78 8 24 3 75
38 2021-02-27 San Joaquin 77 105 9 40 2 7
39 2021-02-27 San Luis Obispo 79 16 1 1 0 24
40 2021-02-27 San Mateo 81 56 3 17 0 17
41 2021-02-27 Santa Barbara 83 70 6 18 2 28
42 2021-02-27 Santa Clara 85 187 33 62 3 57
43 2021-02-27 Santa Cruz 87 15 1 1 1 9
44 2021-02-27 Shasta 89 18 1 4 0 20
45 2021-02-27 Siskiyou 93 3 0 0 0 3
46 2021-02-27 Solano 95 39 14 12 0 11
47 2021-02-27 Sonoma 97 30 1 13 0 14
48 2021-02-27 Stanislaus 99 120 15 31 2 23
49 2021-02-27 Sutter 101 0 0 0 0 0
50 2021-02-27 Tehama 103 3 0 0 0 3
51 2021-02-27 Trinity 105 0 0 0 0 0
52 2021-02-27 Tulare 107 62 3 7 0 23
53 2021-02-27 Tuolumne 109 0 0 0 0 2
54 2021-02-27 Ventura 111 141 5 36 2 43
55 2021-02-27 Yolo 113 11 0 4 0 4
56 2021-02-27 Yuba 115 22 0 6 0 2
57 2021-02-26 Alameda 1 157 24 42 2 101
58 2021-02-26 Amador 5 3 0 0 0 1
59 2021-02-26 Butte 7 15 0 2 0 4
60 2021-02-26 Calaveras 9 1 0 1 0 4
61 2021-02-26 Colusa 11 0 0 0 0 5
62 2021-02-26 Contra Costa 13 72 11 29 2 47
63 2021-02-26 Del Norte 15 1 0 0 0 0
64 2021-02-26 El Dorado 17 6 0 1 0 6
65 2021-02-26 Fresno 19 207 20 48 2 16
66 2021-02-26 Glenn 21 0 0 0 0 0
67 2021-02-26 Humboldt 23 6 2 0 1 9
68 2021-02-26 Imperial 25 22 0 8 0 5
69 2021-02-26 Inyo 27 2 0 0 0 2
70 2021-02-26 Kern 29 158 4 52 0 24
71 2021-02-26 Kings 31 34 0 6 0 0
72 2021-02-26 Lake 33 3 0 1 0 5
73 2021-02-26 Lassen 35 1 0 0 0 0
74 2021-02-26 Los Angeles 37 1661 194 533 32 461
75 2021-02-26 Madera 39 29 7 12 0 6
76 2021-02-26 Marin 41 15 2 5 1 16
77 2021-02-26 Mariposa 43 0 0 0 0 0
78 2021-02-26 Mendocino 45 5 0 3 0 4
79 2021-02-26 Merced 47 33 0 6 0 8
80 2021-02-26 Modoc 49 0 0 0 0 0
81 2021-02-26 Mono 51 1 0 0 0 2
82 2021-02-26 Monterey 53 40 1 9 0 12
83 2021-02-26 Napa 55 7 3 2 0 47
84 2021-02-26 Nevada 57 2 2 1 0 3
85 2021-02-26 Orange 59 444 15 128 2 249
86 2021-02-26 Placer 61 52 10 18 2 15
87 2021-02-26 Plumas 63 0 0 0 0 0
88 2021-02-26 Riverside 65 338 57 87 5 60
89 2021-02-26 Sacramento 67 177 17 49 4 71
90 2021-02-26 San Benito 69 6 0 4 0 0
91 2021-02-26 San Bernardino 71 327 23 85 4 116
92 2021-02-26 San Diego 73 523 39 167 6 222
93 2021-02-26 San Francisco 75 83 5 24 1 66
94 2021-02-26 San Joaquin 77 109 7 39 2 6
95 2021-02-26 San Luis Obispo 79 18 1 2 0 21
96 2021-02-26 San Mateo 81 54 3 16 3 12
97 2021-02-26 Santa Barbara 83 74 6 18 1 28
98 2021-02-26 Santa Clara 85 194 25 62 0 68
99 2021-02-26 Santa Cruz 87 16 2 1 0 7
100 2021-02-26 Shasta 89 18 1 4 0 17

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [la_times_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
);