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

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