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

18,813 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 2021-02-27 Alameda 1 163 26 38 4 95
2 2 2021-02-27 Amador 5 3 0 1 0 2
3 3 2021-02-27 Butte 7 23 0 4 0 10
4 4 2021-02-27 Calaveras 9 1 0 1 0 5
5 5 2021-02-27 Colusa 11 0 0 0 0 5
6 6 2021-02-27 Contra Costa 13 78 16 26 1 47
7 7 2021-02-27 Del Norte 15 1 0 0 0 0
8 8 2021-02-27 El Dorado 17 4 1 1 1 3
9 9 2021-02-27 Fresno 19 201 22 41 1 14
10 10 2021-02-27 Glenn 21 0 0 0 0 0
11 11 2021-02-27 Humboldt 23 6 3 0 1 9
12 12 2021-02-27 Imperial 25 21 2 9 0 1
13 13 2021-02-27 Inyo 27 1 0 0 0 2
14 14 2021-02-27 Kern 29 159 3 53 0 28
15 15 2021-02-27 Kings 31 37 0 7 0 6
16 16 2021-02-27 Lake 33 1 0 1 0 5
17 17 2021-02-27 Lassen 35 0 0 0 0 0
18 18 2021-02-27 Los Angeles 37 1578 183 495 29 465
19 19 2021-02-27 Madera 39 26 7 5 0 2
20 20 2021-02-27 Marin 41 13 3 4 1 18
21 21 2021-02-27 Mariposa 43 0 0 0 0 0
22 22 2021-02-27 Mendocino 45 6 0 3 0 3
23 23 2021-02-27 Merced 47 33 0 6 0 8
24 24 2021-02-27 Modoc 49 0 0 0 0 0
25 25 2021-02-27 Mono 51 1 0 0 0 2
26 26 2021-02-27 Monterey 53 38 3 9 0 14
27 27 2021-02-27 Napa 55 8 0 2 0 11
28 28 2021-02-27 Nevada 57 2 2 1 0 2
29 29 2021-02-27 Orange 59 421 22 132 5 245
30 30 2021-02-27 Placer 61 61 9 16 0 21
31 31 2021-02-27 Plumas 63 0 0 0 0 0
32 32 2021-02-27 Riverside 65 328 50 90 4 60
33 33 2021-02-27 Sacramento 67 165 22 49 6 68
34 34 2021-02-27 San Benito 69 4 0 3 0 0
35 35 2021-02-27 San Bernardino 71 299 23 78 4 116
36 36 2021-02-27 San Diego 73 485 34 156 6 205
37 37 2021-02-27 San Francisco 75 78 8 24 3 75
38 38 2021-02-27 San Joaquin 77 105 9 40 2 7
39 39 2021-02-27 San Luis Obispo 79 16 1 1 0 24
40 40 2021-02-27 San Mateo 81 56 3 17 0 17
41 41 2021-02-27 Santa Barbara 83 70 6 18 2 28
42 42 2021-02-27 Santa Clara 85 187 33 62 3 57
43 43 2021-02-27 Santa Cruz 87 15 1 1 1 9
44 44 2021-02-27 Shasta 89 18 1 4 0 20
45 45 2021-02-27 Siskiyou 93 3 0 0 0 3
46 46 2021-02-27 Solano 95 39 14 12 0 11
47 47 2021-02-27 Sonoma 97 30 1 13 0 14
48 48 2021-02-27 Stanislaus 99 120 15 31 2 23
49 49 2021-02-27 Sutter 101 0 0 0 0 0
50 50 2021-02-27 Tehama 103 3 0 0 0 3
51 51 2021-02-27 Trinity 105 0 0 0 0 0
52 52 2021-02-27 Tulare 107 62 3 7 0 23
53 53 2021-02-27 Tuolumne 109 0 0 0 0 2
54 54 2021-02-27 Ventura 111 141 5 36 2 43
55 55 2021-02-27 Yolo 113 11 0 4 0 4
56 56 2021-02-27 Yuba 115 22 0 6 0 2
57 57 2021-02-26 Alameda 1 157 24 42 2 101
58 58 2021-02-26 Amador 5 3 0 0 0 1
59 59 2021-02-26 Butte 7 15 0 2 0 4
60 60 2021-02-26 Calaveras 9 1 0 1 0 4
61 61 2021-02-26 Colusa 11 0 0 0 0 5
62 62 2021-02-26 Contra Costa 13 72 11 29 2 47
63 63 2021-02-26 Del Norte 15 1 0 0 0 0
64 64 2021-02-26 El Dorado 17 6 0 1 0 6
65 65 2021-02-26 Fresno 19 207 20 48 2 16
66 66 2021-02-26 Glenn 21 0 0 0 0 0
67 67 2021-02-26 Humboldt 23 6 2 0 1 9
68 68 2021-02-26 Imperial 25 22 0 8 0 5
69 69 2021-02-26 Inyo 27 2 0 0 0 2
70 70 2021-02-26 Kern 29 158 4 52 0 24
71 71 2021-02-26 Kings 31 34 0 6 0 0
72 72 2021-02-26 Lake 33 3 0 1 0 5
73 73 2021-02-26 Lassen 35 1 0 0 0 0
74 74 2021-02-26 Los Angeles 37 1661 194 533 32 461
75 75 2021-02-26 Madera 39 29 7 12 0 6
76 76 2021-02-26 Marin 41 15 2 5 1 16
77 77 2021-02-26 Mariposa 43 0 0 0 0 0
78 78 2021-02-26 Mendocino 45 5 0 3 0 4
79 79 2021-02-26 Merced 47 33 0 6 0 8
80 80 2021-02-26 Modoc 49 0 0 0 0 0
81 81 2021-02-26 Mono 51 1 0 0 0 2
82 82 2021-02-26 Monterey 53 40 1 9 0 12
83 83 2021-02-26 Napa 55 7 3 2 0 47
84 84 2021-02-26 Nevada 57 2 2 1 0 3
85 85 2021-02-26 Orange 59 444 15 128 2 249
86 86 2021-02-26 Placer 61 52 10 18 2 15
87 87 2021-02-26 Plumas 63 0 0 0 0 0
88 88 2021-02-26 Riverside 65 338 57 87 5 60
89 89 2021-02-26 Sacramento 67 177 17 49 4 71
90 90 2021-02-26 San Benito 69 6 0 4 0 0
91 91 2021-02-26 San Bernardino 71 327 23 85 4 116
92 92 2021-02-26 San Diego 73 523 39 167 6 222
93 93 2021-02-26 San Francisco 75 83 5 24 1 66
94 94 2021-02-26 San Joaquin 77 109 7 39 2 6
95 95 2021-02-26 San Luis Obispo 79 18 1 2 0 21
96 96 2021-02-26 San Mateo 81 54 3 16 3 12
97 97 2021-02-26 Santa Barbara 83 74 6 18 1 28
98 98 2021-02-26 Santa Clara 85 194 25 62 0 68
99 99 2021-02-26 Santa Cruz 87 16 2 1 0 7
100 100 2021-02-26 Shasta 89 18 1 4 0 17

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