⚠️ 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

13,997 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 2020-12-03 Alameda 1 206 49 58 3 91
2 2020-12-03 Amador 5 5 0 3 0 2
3 2020-12-03 Butte 7 47 1 7 1 21
4 2020-12-03 Calaveras 9 5 0 2 0 5
5 2020-12-03 Colusa 11 10 0 0 0 0
6 2020-12-03 Contra Costa 13 122 14 36 3 35
7 2020-12-03 Del Norte 15 0 0 0 0 2
8 2020-12-03 El Dorado 17 15 1 4 0 7
9 2020-12-03 Fresno 19 340 38 66 4 11
10 2020-12-03 Glenn 21 0 0 0 0 0
11 2020-12-03 Humboldt 23 7 0 2 0 4
12 2020-12-03 Imperial 25 91 1 21 0 1
13 2020-12-03 Inyo 27 2 0 0 0 2
14 2020-12-03 Kern 29 182 6 39 0 39
15 2020-12-03 Kings 31 60 0 12 0 7
16 2020-12-03 Lake 33 2 0 0 0 2
17 2020-12-03 Lassen 35 11 0 0 0 0
18 2020-12-03 Los Angeles 37 2769 328 644 38 486
19 2020-12-03 Madera 39 29 10 7 1 3
20 2020-12-03 Marin 41 16 3 6 0 11
21 2020-12-03 Mariposa 43 1 0 0 0 0
22 2020-12-03 Mendocino 45 10 0 3 0 3
23 2020-12-03 Merced 47 38 0 7 0 10
24 2020-12-03 Modoc 49 1 2 0 0 0
25 2020-12-03 Mono 51 3 0 0 0 2
26 2020-12-03 Monterey 53 90 1 23 0 14
27 2020-12-03 Napa 55 12 1 4 1 24
28 2020-12-03 Nevada 57 16 2 4 1 4
29 2020-12-03 Orange 59 746 64 195 6 133
30 2020-12-03 Placer 61 144 19 22 0 23
31 2020-12-03 Plumas 63 1 0 0 0 0
32 2020-12-03 Riverside 65 658 81 135 5 45
33 2020-12-03 Sacramento 67 373 23 71 4 79
34 2020-12-03 San Benito 69 6 0 3 0 0
35 2020-12-03 San Bernardino 71 880 84 199 9 64
36 2020-12-03 San Diego 73 743 54 207 4 210
37 2020-12-03 San Francisco 75 93 5 34 1 53
38 2020-12-03 San Joaquin 77 160 5 46 1 24
39 2020-12-03 San Luis Obispo 79 13 0 1 0 24
40 2020-12-03 San Mateo 81 76 7 22 0 38
41 2020-12-03 Santa Barbara 83 59 1 16 0 40
42 2020-12-03 Santa Clara 85 307 23 79 2 51
43 2020-12-03 Santa Cruz 87 43 0 8 0 6
44 2020-12-03 Shasta 89 51 0 11 0 8
45 2020-12-03 Siskiyou 93 13 3 3 0 8
46 2020-12-03 Solano 95 64 14 18 1 12
47 2020-12-03 Sonoma 97 37 5 6 1 7
48 2020-12-03 Stanislaus 99 218 13 49 2 18
49 2020-12-03 Sutter 101 0 0 0 0 0
50 2020-12-03 Tehama 103 11 0 2 0 1
51 2020-12-03 Trinity 105 0 0 0 0 0
52 2020-12-03 Tulare 107 107 10 11 2 18
53 2020-12-03 Tuolumne 109 11 0 2 0 2
54 2020-12-03 Ventura 111 104 15 43 6 19
55 2020-12-03 Yolo 113 18 0 11 0 3
56 2020-12-03 Yuba 115 39 0 10 0 1
57 2020-12-02 Alameda 1 195 43 58 5 85
58 2020-12-02 Amador 5 4 0 2 0 3
59 2020-12-02 Butte 7 44 1 6 1 12
60 2020-12-02 Calaveras 9 5 0 3 0 5
61 2020-12-02 Colusa 11 11 0 0 0 0
62 2020-12-02 Contra Costa 13 116 15 27 1 55
63 2020-12-02 Del Norte 15 0 0 0 0 3
64 2020-12-02 El Dorado 17 13 0 1 0 8
65 2020-12-02 Fresno 19 338 29 62 2 10
66 2020-12-02 Glenn 21 0 0 0 0 0
67 2020-12-02 Humboldt 23 5 6 2 1 2
68 2020-12-02 Imperial 25 82 1 18 0 2
69 2020-12-02 Inyo 27 2 0 0 0 4
70 2020-12-02 Kern 29 179 5 42 0 31
71 2020-12-02 Kings 31 58 1 11 0 7
72 2020-12-02 Lake 33 0 0 0 0 2
73 2020-12-02 Lassen 35 7 0 0 0 0
74 2020-12-02 Los Angeles 37 2668 336 632 25 528
75 2020-12-02 Madera 39 28 10 8 0 10
76 2020-12-02 Marin 41 16 4 6 0 12
77 2020-12-02 Mariposa 43 1 0 0 0 0
78 2020-12-02 Mendocino 45 11 0 4 0 1
79 2020-12-02 Merced 47 32 0 7 0 4
80 2020-12-02 Modoc 49 1 0 0 0 0
81 2020-12-02 Mono 51 2 0 0 0 2
82 2020-12-02 Monterey 53 82 1 17 0 20
83 2020-12-02 Napa 55 12 0 6 0 22
84 2020-12-02 Nevada 57 17 0 3 0 6
85 2020-12-02 Orange 59 735 49 179 6 114
86 2020-12-02 Placer 61 131 14 19 2 25
87 2020-12-02 Plumas 63 0 0 0 0 0
88 2020-12-02 Riverside 65 649 72 124 5 44
89 2020-12-02 Sacramento 67 359 29 76 4 71
90 2020-12-02 San Benito 69 9 0 3 0 0
91 2020-12-02 San Bernardino 71 904 98 192 12 57
92 2020-12-02 San Diego 73 705 56 204 4 219
93 2020-12-02 San Francisco 75 93 5 28 0 62
94 2020-12-02 San Joaquin 77 162 7 41 1 27
95 2020-12-02 San Luis Obispo 79 8 1 1 0 26
96 2020-12-02 San Mateo 81 70 6 21 1 43
97 2020-12-02 Santa Barbara 83 57 3 16 0 46
98 2020-12-02 Santa Clara 85 304 23 83 2 56
99 2020-12-02 Santa Cruz 87 47 0 9 0 5
100 2020-12-02 Shasta 89 53 0 8 0 4

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
);