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

56,333 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-12-29 Alameda 1 168 68 13 8 75
2 2 2022-12-29 Amador 5 5 1 0 0 0
3 3 2022-12-29 Butte 7 35 0 2 0 12
4 4 2022-12-29 Calaveras 9 1 0 0 0 0
5 5 2022-12-29 Colusa 11 0 0 0 0 0
6 6 2022-12-29 Contra Costa 13 100 70 11 4 35
7 7 2022-12-29 Del Norte 15 1 0 0 0 1
8 8 2022-12-29 El Dorado 17 8 0 1 0 1
9 9 2022-12-29 Fresno 19 251 44 31 1 18
10 10 2022-12-29 Glenn 21 0 0 0 0 0
11 11 2022-12-29 Humboldt 23 7 0 2 0 1
12 12 2022-12-29 Imperial 25 14 0 2 0 14
13 13 2022-12-29 Inyo 27 0 0 0 0 4
14 14 2022-12-29 Kern 29 57 0 7 0 20
15 15 2022-12-29 Kings 31 3 0 1 0 0
16 16 2022-12-29 Lake 33 8 0 2 0 0
17 17 2022-12-29 Lassen 35 0 0 0 0 0
18 18 2022-12-29 Los Angeles 37 1249 94 142 5 681
19 19 2022-12-29 Madera 39 4 0 1 0 13
20 20 2022-12-29 Marin 41 31 9 4 0 8
21 21 2022-12-29 Mariposa 43 0 0 0 0 0
22 22 2022-12-29 Mendocino 45 9 0 4 0 0
23 23 2022-12-29 Merced 47 16 0 3 0 4
24 24 2022-12-29 Modoc 49 0 0 0 0 0
25 25 2022-12-29 Mono 51 0 0 0 0 2
26 26 2022-12-29 Monterey 53 23 0 1 0 15
27 27 2022-12-29 Napa 55 10 1 0 0 2
28 28 2022-12-29 Nevada 57 5 0 1 0 2
29 29 2022-12-29 Orange 59 348 10 34 0 135
30 30 2022-12-29 Placer 61 110 28 6 1 21
31 31 2022-12-29 Plumas 63 0 0 0 0 0
32 32 2022-12-29 Riverside 65 240 20 31 2 118
33 33 2022-12-29 Sacramento 67 238 60 28 9 72
34 34 2022-12-29 San Benito 69 1 0 1 0 0
35 35 2022-12-29 San Bernardino 71 217 2 33 1 161
36 36 2022-12-29 San Diego 73 481 16 47 2 246
37 37 2022-12-29 San Francisco 75 104 8 12 0 69
38 38 2022-12-29 San Joaquin 77 81 5 13 1 7
39 39 2022-12-29 San Luis Obispo 79 16 0 1 0 17
40 40 2022-12-29 San Mateo 81 54 30 7 6 17
41 41 2022-12-29 Santa Barbara 83 48 2 6 2 10
42 42 2022-12-29 Santa Clara 85 237 48 35 7 55
43 43 2022-12-29 Santa Cruz 87 24 0 2 0 0
44 44 2022-12-29 Shasta 89 25 3 2 0 19
45 45 2022-12-29 Siskiyou 93 0 0 0 0 3
46 46 2022-12-29 Solano 95 64 41 5 2 10
47 47 2022-12-29 Sonoma 97 49 16 4 0 21
48 48 2022-12-29 Stanislaus 99 109 26 8 5 29
49 49 2022-12-29 Sutter 101 0 0 0 0 0
50 50 2022-12-29 Tehama 103 3 0 0 0 3
51 51 2022-12-29 Trinity 105 0 0 0 0 0
52 52 2022-12-29 Tulare 107 50 3 2 2 13
53 53 2022-12-29 Tuolumne 109 5 0 0 0 1
54 54 2022-12-29 Ventura 111 87 6 10 0 38
55 55 2022-12-29 Yolo 113 8 0 1 0 0
56 56 2022-12-29 Yuba 115 15 1 1 0 5
57 57 2022-12-28 Alameda 1 180 61 21 5 81
58 58 2022-12-28 Amador 5 6 0 0 0 0
59 59 2022-12-28 Butte 7 35 0 2 0 11
60 60 2022-12-28 Calaveras 9 1 0 0 0 0
61 61 2022-12-28 Colusa 11 0 0 0 0 0
62 62 2022-12-28 Contra Costa 13 94 69 10 3 34
63 63 2022-12-28 Del Norte 15 2 0 0 0 1
64 64 2022-12-28 El Dorado 17 4 0 1 0 1
65 65 2022-12-28 Fresno 19 222 24 31 1 28
66 66 2022-12-28 Glenn 21 1 0 0 0 0
67 67 2022-12-28 Humboldt 23 3 0 1 0 0
68 68 2022-12-28 Imperial 25 12 0 2 0 11
69 69 2022-12-28 Inyo 27 1 0 0 0 3
70 70 2022-12-28 Kern 29 64 0 8 0 26
71 71 2022-12-28 Kings 31 3 0 1 0 4
72 72 2022-12-28 Lake 33 7 0 2 0 0
73 73 2022-12-28 Lassen 35 0 0 0 0 0
74 74 2022-12-28 Los Angeles 37 1269 93 148 8 740
75 75 2022-12-28 Madera 39 5 3 1 0 8
76 76 2022-12-28 Marin 41 34 8 4 1 6
77 77 2022-12-28 Mariposa 43 0 0 0 0 0
78 78 2022-12-28 Mendocino 45 12 0 2 0 1
79 79 2022-12-28 Merced 47 21 0 3 0 6
80 80 2022-12-28 Modoc 49 0 0 0 0 0
81 81 2022-12-28 Mono 51 0 0 0 0 2
82 82 2022-12-28 Monterey 53 18 0 1 0 19
83 83 2022-12-28 Napa 55 10 0 0 0 0
84 84 2022-12-28 Nevada 57 8 0 1 0 2
85 85 2022-12-28 Orange 59 329 16 47 0 124
86 86 2022-12-28 Placer 61 109 32 7 2 21
87 87 2022-12-28 Plumas 63 1 0 0 0 0
88 88 2022-12-28 Riverside 65 236 24 27 2 102
89 89 2022-12-28 Sacramento 67 220 66 23 9 76
90 90 2022-12-28 San Benito 69 1 0 1 0 0
91 91 2022-12-28 San Bernardino 71 223 4 32 0 150
92 92 2022-12-28 San Diego 73 456 21 48 0 251
93 93 2022-12-28 San Francisco 75 108 13 14 1 68
94 94 2022-12-28 San Joaquin 77 80 4 12 1 9
95 95 2022-12-28 San Luis Obispo 79 21 1 0 0 17
96 96 2022-12-28 San Mateo 81 59 22 6 5 17
97 97 2022-12-28 Santa Barbara 83 49 1 4 1 11
98 98 2022-12-28 Santa Clara 85 234 48 33 7 47
99 99 2022-12-28 Santa Cruz 87 22 0 1 0 1
100 100 2022-12-28 Shasta 89 22 0 1 0 25

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