la_times_cdph_hospital_patient_county_totals

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

9,853 rows sorted by date descending

View and edit SQL

Suggested facets: date (date)

Link rowid date ▲ county fips positive_patients suspected_patients icu_positive_patients icu_suspected_patients icu_available_beds
1 2020-09-20 Alameda 1 98 46 38 8 108
2 2020-09-20 Amador 5 1 0 0 0 2
3 2020-09-20 Butte 7 13 0 4 0 20
4 2020-09-20 Calaveras 9 0 0 0 0 6
5 2020-09-20 Colusa 11 3 3 0 0 0
6 2020-09-20 Contra Costa 13 50 26 17 5 55
7 2020-09-20 Del Norte 15 0 1 0 1 3
8 2020-09-20 El Dorado 17 0 0 0 0 6
9 2020-09-20 Fresno 19 92 13 30 2 29
10 2020-09-20 Glenn 21 0 0 0 0 0
11 2020-09-20 Humboldt 23 2 2 0 1 1
12 2020-09-20 Imperial 25 20 0 8 0 7
13 2020-09-20 Inyo 27 0 0 0 0 4
14 2020-09-20 Kern 29 67 4 19 0 64
15 2020-09-20 Kings 31 19 0 3 0 14
16 2020-09-20 Lake 33 0 2 0 1 3
17 2020-09-20 Lassen 35 0 0 0 0 0
18 2020-09-20 Los Angeles 37 745 368 207 63 989
19 2020-09-20 Madera 39 15 12 4 0 6
20 2020-09-20 Marin 41 8 4 2 0 10
21 2020-09-20 Mariposa 43 0 0 0 0 0
22 2020-09-20 Mendocino 45 4 0 1 0 7
23 2020-09-20 Merced 47 9 0 6 0 8
24 2020-09-20 Modoc 49 0 0 0 0 0
25 2020-09-20 Mono 51 0 0 0 0 2
26 2020-09-20 Monterey 53 33 2 7 2 31
27 2020-09-20 Napa 55 1 3 0 0 26
28 2020-09-20 Nevada 57 3 1 0 0 3
29 2020-09-20 Orange 59 178 59 64 13 235
30 2020-09-20 Placer 61 22 28 8 3 34
31 2020-09-20 Plumas 63 0 0 0 0 0
32 2020-09-20 Riverside 65 131 55 47 6 112
33 2020-09-20 Sacramento 67 120 30 42 8 123
34 2020-09-20 San Benito 69 4 0 1 0 1
35 2020-09-20 San Bernardino 71 156 62 49 13 175
36 2020-09-20 San Diego 73 211 56 73 12 300
37 2020-09-20 San Francisco 75 65 8 21 2 62
38 2020-09-20 San Joaquin 77 58 6 24 0 37
39 2020-09-20 San Luis Obispo 79 7 0 3 0 21
40 2020-09-20 San Mateo 81 34 8 12 0 33
41 2020-09-20 Santa Barbara 83 23 3 5 1 64
42 2020-09-20 Santa Clara 85 113 22 36 4 120
43 2020-09-20 Santa Cruz 87 17 0 2 0 9
44 2020-09-20 Shasta 89 3 0 0 0 16
45 2020-09-20 Siskiyou 93 0 1 0 0 9
46 2020-09-20 Solano 95 26 10 5 0 9
47 2020-09-20 Sonoma 97 21 6 5 0 8
48 2020-09-20 Stanislaus 99 92 21 33 1 28
49 2020-09-20 Sutter 101 0 0 0 0 0
50 2020-09-20 Tehama 103 3 0 0 0 2
51 2020-09-20 Trinity 105 0 0 0 0 0
52 2020-09-20 Tulare 107 37 10 8 0 21
53 2020-09-20 Tuolumne 109 0 0 0 0 4
54 2020-09-20 Ventura 111 44 13 19 3 59
55 2020-09-20 Yolo 113 6 0 3 0 5
56 2020-09-20 Yuba 115 19 1 5 0 8
57 2020-09-19 Alameda 1 95 48 37 5 112
58 2020-09-19 Amador 5 0 0 0 0 4
59 2020-09-19 Butte 7 16 1 4 0 17
60 2020-09-19 Calaveras 9 0 0 0 0 7
61 2020-09-19 Colusa 11 2 3 0 0 0
62 2020-09-19 Contra Costa 13 51 25 18 5 49
63 2020-09-19 Del Norte 15 0 0 0 0 2
64 2020-09-19 El Dorado 17 0 0 0 0 6
65 2020-09-19 Fresno 19 92 23 28 4 30
66 2020-09-19 Glenn 21 0 0 0 0 0
67 2020-09-19 Humboldt 23 2 2 0 1 1
68 2020-09-19 Imperial 25 18 0 8 0 7
69 2020-09-19 Inyo 27 0 0 0 0 4
70 2020-09-19 Kern 29 72 4 21 0 69
71 2020-09-19 Kings 31 20 0 4 0 11
72 2020-09-19 Lake 33 0 2 0 0 4
73 2020-09-19 Lassen 35 0 0 0 0 0
74 2020-09-19 Los Angeles 37 749 328 207 48 967
75 2020-09-19 Madera 39 14 11 3 0 8
76 2020-09-19 Marin 41 7 5 2 0 9
77 2020-09-19 Mariposa 43 0 0 0 0 0
78 2020-09-19 Mendocino 45 5 0 1 0 8
79 2020-09-19 Merced 47 9 0 6 0 9
80 2020-09-19 Modoc 49 0 0 0 0 0
81 2020-09-19 Mono 51 0 0 0 0 2
82 2020-09-19 Monterey 53 32 2 7 2 30
83 2020-09-19 Napa 55 4 0 2 0 26
84 2020-09-19 Nevada 57 3 0 0 0 2
85 2020-09-19 Orange 59 194 52 65 7 246
86 2020-09-19 Placer 61 24 30 8 4 31
87 2020-09-19 Plumas 63 0 0 0 0 0
88 2020-09-19 Riverside 65 138 54 47 7 105
89 2020-09-19 Sacramento 67 114 34 43 6 95
90 2020-09-19 San Benito 69 3 0 1 0 1
91 2020-09-19 San Bernardino 71 167 54 45 11 169
92 2020-09-19 San Diego 73 203 50 72 10 314
93 2020-09-19 San Francisco 75 58 9 18 2 61
94 2020-09-19 San Joaquin 77 57 10 24 0 39
95 2020-09-19 San Luis Obispo 79 10 2 4 0 19
96 2020-09-19 San Mateo 81 39 6 13 0 32
97 2020-09-19 Santa Barbara 83 23 3 4 0 64
98 2020-09-19 Santa Clara 85 111 20 38 1 102
99 2020-09-19 Santa Cruz 87 17 0 2 0 9
100 2020-09-19 Shasta 89 3 0 0 0 11

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
);
Powered by Datasette · Query took 196.825ms · 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