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

This data as json, CSV (advanced)

Suggested facets: date (date)

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