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

22,509 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-05-04 Alameda 1 64 34 19 6 113
2 2021-05-04 Amador 5 1 0 1 0 2
3 2021-05-04 Butte 7 17 0 2 0 13
4 2021-05-04 Calaveras 9 1 0 0 0 7
5 2021-05-04 Colusa 11 0 0 0 0 5
6 2021-05-04 Contra Costa 13 27 15 9 1 52
7 2021-05-04 Del Norte 15 0 0 0 0 2
8 2021-05-04 El Dorado 17 3 0 2 0 5
9 2021-05-04 Fresno 19 83 12 22 1 10
10 2021-05-04 Glenn 21 0 0 0 0 0
11 2021-05-04 Humboldt 23 13 2 4 0 8
12 2021-05-04 Imperial 25 13 1 7 1 6
13 2021-05-04 Inyo 27 0 0 0 0 2
14 2021-05-04 Kern 29 17 8 6 0 42
15 2021-05-04 Kings 31 4 0 0 0 4
16 2021-05-04 Lake 33 1 0 1 0 0
17 2021-05-04 Lassen 35 0 0 0 0 0
18 2021-05-04 Los Angeles 37 387 90 93 5 634
19 2021-05-04 Madera 39 5 7 1 1 6
20 2021-05-04 Marin 41 2 5 1 0 9
21 2021-05-04 Mariposa 43 0 0 0 0 0
22 2021-05-04 Mendocino 45 0 0 0 0 4
23 2021-05-04 Merced 47 9 0 2 0 5
24 2021-05-04 Modoc 49 0 0 0 0 0
25 2021-05-04 Mono 51 0 0 0 0 2
26 2021-05-04 Monterey 53 9 0 2 0 26
27 2021-05-04 Napa 55 2 0 1 0 4
28 2021-05-04 Nevada 57 5 0 1 0 1
29 2021-05-04 Orange 59 89 21 25 2 260
30 2021-05-04 Placer 61 33 19 8 2 18
31 2021-05-04 Plumas 63 0 0 0 0 0
32 2021-05-04 Riverside 65 72 18 23 0 107
33 2021-05-04 Sacramento 67 87 16 20 3 100
34 2021-05-04 San Benito 69 1 0 1 0 0
35 2021-05-04 San Bernardino 71 71 11 25 3 163
36 2021-05-04 San Diego 73 146 17 41 2 214
37 2021-05-04 San Francisco 75 15 7 7 2 105
38 2021-05-04 San Joaquin 77 46 4 14 0 8
39 2021-05-04 San Luis Obispo 79 3 0 1 0 21
40 2021-05-04 San Mateo 81 24 3 6 0 22
41 2021-05-04 Santa Barbara 83 7 0 2 0 26
42 2021-05-04 Santa Clara 85 67 14 18 4 79
43 2021-05-04 Santa Cruz 87 2 0 0 0 9
44 2021-05-04 Shasta 89 8 0 1 0 22
45 2021-05-04 Siskiyou 93 11 0 1 0 6
46 2021-05-04 Solano 95 28 5 5 0 22
47 2021-05-04 Sonoma 97 7 1 3 0 20
48 2021-05-04 Stanislaus 99 112 18 25 3 24
49 2021-05-04 Sutter 101 0 0 0 0 0
50 2021-05-04 Tehama 103 4 0 1 0 0
51 2021-05-04 Trinity 105 0 0 0 0 0
52 2021-05-04 Tulare 107 17 5 2 1 26
53 2021-05-04 Tuolumne 109 0 0 0 0 5
54 2021-05-04 Ventura 111 28 5 4 0 49
55 2021-05-04 Yolo 113 2 0 0 0 7
56 2021-05-04 Yuba 115 12 0 1 0 4
57 2021-05-03 Alameda 1 75 30 19 3 116
58 2021-05-03 Amador 5 0 0 0 0 3
59 2021-05-03 Butte 7 14 0 2 0 14
60 2021-05-03 Calaveras 9 1 0 0 0 7
61 2021-05-03 Colusa 11 1 0 0 0 5
62 2021-05-03 Contra Costa 13 26 20 9 2 58
63 2021-05-03 Del Norte 15 0 0 0 0 1
64 2021-05-03 El Dorado 17 3 0 2 0 2
65 2021-05-03 Fresno 19 79 6 18 1 15
66 2021-05-03 Glenn 21 0 0 0 0 0
67 2021-05-03 Humboldt 23 11 3 5 1 7
68 2021-05-03 Imperial 25 12 1 5 0 6
69 2021-05-03 Inyo 27 0 0 0 0 2
70 2021-05-03 Kern 29 20 1 4 0 38
71 2021-05-03 Kings 31 4 0 1 0 4
72 2021-05-03 Lake 33 0 1 0 0 2
73 2021-05-03 Lassen 35 0 0 0 0 0
74 2021-05-03 Los Angeles 37 400 88 97 11 721
75 2021-05-03 Madera 39 6 16 1 2 6
76 2021-05-03 Marin 41 4 4 1 1 11
77 2021-05-03 Mariposa 43 0 0 0 0 0
78 2021-05-03 Mendocino 45 0 0 0 0 7
79 2021-05-03 Merced 47 9 0 3 0 9
80 2021-05-03 Modoc 49 0 0 0 0 0
81 2021-05-03 Mono 51 0 0 0 0 2
82 2021-05-03 Monterey 53 9 0 2 0 27
83 2021-05-03 Napa 55 2 0 1 0 5
84 2021-05-03 Nevada 57 3 0 1 0 3
85 2021-05-03 Orange 59 97 17 26 4 274
86 2021-05-03 Placer 61 38 15 8 2 21
87 2021-05-03 Plumas 63 0 0 0 0 0
88 2021-05-03 Riverside 65 68 18 17 5 97
89 2021-05-03 Sacramento 67 99 16 17 3 99
90 2021-05-03 San Benito 69 1 0 1 0 1
91 2021-05-03 San Bernardino 71 83 13 26 4 175
92 2021-05-03 San Diego 73 145 17 41 4 236
93 2021-05-03 San Francisco 75 15 6 6 3 143
94 2021-05-03 San Joaquin 77 45 1 16 0 5
95 2021-05-03 San Luis Obispo 79 2 0 1 0 25
96 2021-05-03 San Mateo 81 19 4 5 0 23
97 2021-05-03 Santa Barbara 83 6 0 2 0 35
98 2021-05-03 Santa Clara 85 68 14 20 0 94
99 2021-05-03 Santa Cruz 87 2 0 0 0 11
100 2021-05-03 Shasta 89 11 0 1 0 21

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