la_times_cdph_hospital_patient_county_totals

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

36,789 rows sorted by date descending

✎ View and edit SQL

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-01-14 Alameda 1 407 35 58 5 80
2 2 2022-01-14 Amador 5 7 0 3 0 0
3 3 2022-01-14 Butte 7 54 0 5 0 8
4 4 2022-01-14 Calaveras 9 5 0 2 0 6
5 5 2022-01-14 Colusa 11 2 0 0 0 0
6 6 2022-01-14 Contra Costa 13 220 22 34 3 31
7 7 2022-01-14 Del Norte 15 2 0 0 0 2
8 8 2022-01-14 El Dorado 17 13 0 3 0 0
9 9 2022-01-14 Fresno 19 417 18 65 2 11
10 10 2022-01-14 Glenn 21 0 0 0 0 0
11 11 2022-01-14 Humboldt 23 24 13 7 0 3
12 12 2022-01-14 Imperial 25 93 0 27 0 0
13 13 2022-01-14 Inyo 27 3 0 0 0 2
14 14 2022-01-14 Kern 29 253 2 35 0 22
15 15 2022-01-14 Kings 31 47 0 3 0 5
16 16 2022-01-14 Lake 33 5 0 3 0 0
17 17 2022-01-14 Lassen 35 1 0 0 0 0
18 18 2022-01-14 Los Angeles 37 4386 163 602 23 426
19 19 2022-01-14 Madera 39 33 3 4 1 11
20 20 2022-01-14 Marin 41 33 2 4 0 17
21 21 2022-01-14 Mariposa 43 0 0 0 0 0
22 22 2022-01-14 Mendocino 45 23 1 3 0 5
23 23 2022-01-14 Merced 47 55 0 9 0 2
24 24 2022-01-14 Modoc 49 0 0 0 0 0
25 25 2022-01-14 Mono 51 0 0 0 0 1
26 26 2022-01-14 Monterey 53 63 1 12 0 22
27 27 2022-01-14 Napa 55 25 0 6 0 0
28 28 2022-01-14 Nevada 57 24 0 0 0 2
29 29 2022-01-14 Orange 59 1194 26 178 6 140
30 30 2022-01-14 Placer 61 219 16 33 2 9
31 31 2022-01-14 Plumas 63 4 0 0 0 0
32 32 2022-01-14 Riverside 65 1006 43 152 2 83
33 33 2022-01-14 Sacramento 67 515 16 86 2 66
34 34 2022-01-14 San Benito 69 8 0 3 0 0
35 35 2022-01-14 San Bernardino 71 1101 40 218 1 89
36 36 2022-01-14 San Diego 73 1223 27 181 4 164
37 37 2022-01-14 San Francisco 75 235 6 41 0 81
38 38 2022-01-14 San Joaquin 77 233 9 50 0 12
39 39 2022-01-14 San Luis Obispo 79 45 1 6 0 17
40 40 2022-01-14 San Mateo 81 138 10 24 2 14
41 41 2022-01-14 Santa Barbara 83 112 1 13 0 17
42 42 2022-01-14 Santa Clara 85 486 32 71 6 42
43 43 2022-01-14 Santa Cruz 87 30 1 3 0 3
44 44 2022-01-14 Shasta 89 66 6 12 0 9
45 45 2022-01-14 Siskiyou 93 5 0 2 0 3
46 46 2022-01-14 Solano 95 131 15 18 2 12
47 47 2022-01-14 Sonoma 97 89 3 14 0 13
48 48 2022-01-14 Stanislaus 99 227 12 28 3 22
49 49 2022-01-14 Sutter 101 0 0 0 0 0
50 50 2022-01-14 Tehama 103 19 0 3 0 0
51 51 2022-01-14 Trinity 105 0 0 0 0 0
52 52 2022-01-14 Tulare 107 97 7 11 0 13
53 53 2022-01-14 Tuolumne 109 10 0 3 0 2
54 54 2022-01-14 Ventura 111 335 6 47 2 35
55 55 2022-01-14 Yolo 113 17 0 5 0 2
56 56 2022-01-14 Yuba 115 36 11 6 0 2
57 57 2022-01-13 Alameda 1 401 37 52 5 76
58 58 2022-01-13 Amador 5 8 0 3 0 0
59 59 2022-01-13 Butte 7 54 0 5 0 5
60 60 2022-01-13 Calaveras 9 4 0 2 0 6
61 61 2022-01-13 Colusa 11 3 0 0 0 0
62 62 2022-01-13 Contra Costa 13 214 32 31 2 30
63 63 2022-01-13 Del Norte 15 3 0 1 0 4
64 64 2022-01-13 El Dorado 17 13 0 1 0 2
65 65 2022-01-13 Fresno 19 390 22 62 2 10
66 66 2022-01-13 Glenn 21 0 0 0 0 0
67 67 2022-01-13 Humboldt 23 28 8 8 0 4
68 68 2022-01-13 Imperial 25 95 0 29 0 0
69 69 2022-01-13 Inyo 27 4 0 1 0 2
70 70 2022-01-13 Kern 29 244 4 42 0 25
71 71 2022-01-13 Kings 31 42 0 3 0 1
72 72 2022-01-13 Lake 33 4 0 2 0 0
73 73 2022-01-13 Lassen 35 0 0 0 0 0
74 74 2022-01-13 Los Angeles 37 4257 150 600 18 433
75 75 2022-01-13 Madera 39 34 6 6 2 7
76 76 2022-01-13 Marin 41 33 2 4 0 15
77 77 2022-01-13 Mariposa 43 0 0 0 0 0
78 78 2022-01-13 Mendocino 45 13 0 1 0 1
79 79 2022-01-13 Merced 47 49 0 10 0 2
80 80 2022-01-13 Modoc 49 0 0 0 0 0
81 81 2022-01-13 Mono 51 0 0 0 0 2
82 82 2022-01-13 Monterey 53 65 1 14 0 21
83 83 2022-01-13 Napa 55 30 0 5 0 2
84 84 2022-01-13 Nevada 57 14 0 1 0 2
85 85 2022-01-13 Orange 59 1154 20 171 4 148
86 86 2022-01-13 Placer 61 205 21 33 1 11
87 87 2022-01-13 Plumas 63 5 0 0 0 0
88 88 2022-01-13 Riverside 65 991 42 151 3 73
89 89 2022-01-13 Sacramento 67 505 15 82 1 65
90 90 2022-01-13 San Benito 69 8 0 3 0 0
91 91 2022-01-13 San Bernardino 71 1107 43 219 2 97
92 92 2022-01-13 San Diego 73 1180 24 178 4 170
93 93 2022-01-13 San Francisco 75 228 5 41 0 67
94 94 2022-01-13 San Joaquin 77 217 5 47 1 10
95 95 2022-01-13 San Luis Obispo 79 44 1 8 0 16
96 96 2022-01-13 San Mateo 81 138 12 21 3 13
97 97 2022-01-13 Santa Barbara 83 103 1 10 0 20
98 98 2022-01-13 Santa Clara 85 461 30 67 6 46
99 99 2022-01-13 Santa Cruz 87 35 0 3 0 3
100 100 2022-01-13 Shasta 89 60 8 11 0 10

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