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

13,997 rows sorted by date descending

✎ View and edit SQL

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