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

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

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