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

5,317 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
1 2020-07-01 Alameda 1 123 47 43 12
2 2020-07-01 Amador 5 1 1 1 0
3 2020-07-01 Butte 7 7 2 1 2
4 2020-07-01 Calaveras 9 2 0 2 0
5 2020-07-01 Colusa 11 0 2 0 0
6 2020-07-01 Contra Costa 13 50 21 19 7
7 2020-07-01 Del Norte 15 1 0 0 0
8 2020-07-01 El Dorado 17 5 1 4 1
9 2020-07-01 Fresno 19 125 24 32 5
10 2020-07-01 Glenn 21 0 0 0 0
11 2020-07-01 Humboldt 23 1 3 1 1
12 2020-07-01 Imperial 25 79 2 19 0
13 2020-07-01 Inyo 27 0 0 0 0
14 2020-07-01 Kern 29 164 14 58 0
15 2020-07-01 Kings 31 40 1 6 1
16 2020-07-01 Lake 33 3 0 1 0
17 2020-07-01 Lassen 35 0 0 0 0
18 2020-07-01 Los Angeles 37 1937 643 537 95
19 2020-07-01 Madera 39 15 7 5 1
20 2020-07-01 Marin 41 30 2 12 0
21 2020-07-01 Mariposa 43 0 0 0 0
22 2020-07-01 Mendocino 45 0 0 0 0
23 2020-07-01 Merced 47 17 9 4 2
24 2020-07-01 Modoc 49 0 2 0 0
25 2020-07-01 Mono 51 0 0 0 0
26 2020-07-01 Monterey 53 41 2 10 0
27 2020-07-01 Napa 55 7 1 7 1
28 2020-07-01 Nevada 57 4 2 2 0
29 2020-07-01 Orange 59 556 149 193 34
30 2020-07-01 Placer 61 13 20 4 1
31 2020-07-01 Plumas 63 0 0 0 0
32 2020-07-01 Riverside 65 431 116 123 20
33 2020-07-01 Sacramento 67 109 27 31 7
34 2020-07-01 San Benito 69 1 0 0 0
35 2020-07-01 San Bernardino 71 428 88 151 19
36 2020-07-01 San Diego 73 398 64 159 16
37 2020-07-01 San Francisco 75 71 14 31 2
38 2020-07-01 San Joaquin 77 128 35 37 7
39 2020-07-01 San Luis Obispo 79 8 6 3 1
40 2020-07-01 San Mateo 81 45 10 20 1
41 2020-07-01 Santa Barbara 83 62 4 24 0
42 2020-07-01 Santa Clara 85 82 18 35 5
43 2020-07-01 Santa Cruz 87 10 0 1 0
44 2020-07-01 Shasta 89 7 1 2 0
45 2020-07-01 Siskiyou 93 0 0 0 0
46 2020-07-01 Solano 95 48 9 13 0
47 2020-07-01 Sonoma 97 13 4 4 1
48 2020-07-01 Stanislaus 99 121 61 38 6
49 2020-07-01 Sutter 101 0 0 0 0
50 2020-07-01 Tehama 103 0 0 0 0
51 2020-07-01 Trinity 105 0 0 0 0
52 2020-07-01 Tulare 107 78 5 15 0
53 2020-07-01 Tuolumne 109 3 0 1 0
54 2020-07-01 Ventura 111 79 38 24 8
55 2020-07-01 Yolo 113 4 1 1 1
56 2020-07-01 Yuba 115 8 1 2 1
57 2020-06-30 Alameda 1 116 41 43 6
58 2020-06-30 Amador 5 1 1 1 0
59 2020-06-30 Butte 7 6 0 2 0
60 2020-06-30 Calaveras 9 1 2 1 1
61 2020-06-30 Colusa 11 1 2 0 0
62 2020-06-30 Contra Costa 13 41 20 17 6
63 2020-06-30 Del Norte 15 1 0 1 0
64 2020-06-30 El Dorado 17 3 1 1 1
65 2020-06-30 Fresno 19 129 42 33 4
66 2020-06-30 Glenn 21 0 0 0 0
67 2020-06-30 Humboldt 23 1 3 0 1
68 2020-06-30 Imperial 25 72 2 18 0
69 2020-06-30 Inyo 27 0 0 0 0
70 2020-06-30 Kern 29 163 12 60 1
71 2020-06-30 Kings 31 41 0 4 0
72 2020-06-30 Lake 33 3 2 1 2
73 2020-06-30 Lassen 35 0 0 0 0
74 2020-06-30 Los Angeles 37 1893 645 526 102
75 2020-06-30 Madera 39 8 2 0 0
76 2020-06-30 Marin 41 25 4 10 1
77 2020-06-30 Mariposa 43 0 0 0 0
78 2020-06-30 Mendocino 45 0 0 0 0
79 2020-06-30 Merced 47 15 1 4 1
80 2020-06-30 Modoc 49 0 0 0 0
81 2020-06-30 Mono 51 0 0 0 0
82 2020-06-30 Monterey 53 36 5 7 0
83 2020-06-30 Napa 55 7 2 7 1
84 2020-06-30 Nevada 57 4 3 2 0
85 2020-06-30 Orange 59 542 120 192 20
86 2020-06-30 Placer 61 13 11 4 1
87 2020-06-30 Plumas 63 0 0 0 0
88 2020-06-30 Riverside 65 419 112 117 21
89 2020-06-30 Sacramento 67 106 21 29 2
90 2020-06-30 San Benito 69 1 0 0 0
91 2020-06-30 San Bernardino 71 406 85 142 21
92 2020-06-30 San Diego 73 391 62 158 15
93 2020-06-30 San Francisco 75 68 12 28 5
94 2020-06-30 San Joaquin 77 140 56 37 8
95 2020-06-30 San Luis Obispo 79 9 3 3 1
96 2020-06-30 San Mateo 81 40 7 18 1
97 2020-06-30 Santa Barbara 83 64 6 20 1
98 2020-06-30 Santa Clara 85 81 12 33 1
99 2020-06-30 Santa Cruz 87 10 6 1 0
100 2020-06-30 Shasta 89 10 2 2 0

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