⚠️ 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: The Los Angeles Times · About: Data dictionary for latimes_place_totals

258 rows where place = "95405: Santa Rosa" sorted by date descending

View and edit SQL

Suggested facets: note, date (date)

place

  • 95405: Santa Rosa · 258

fips

county

Link rowid date ▲ county fips place confirmed_cases note x y population
2301 2020-12-03 Sonoma 97 95405: Santa Rosa 390   -122.6684 38.439992 21448
4673 2020-12-01 Sonoma 97 95405: Santa Rosa 358   -122.6684 38.439992 21448
11808 2020-11-24 Sonoma 97 95405: Santa Rosa 327   -122.6684 38.439992 21448
12836 2020-11-23 Sonoma 97 95405: Santa Rosa 327   -122.6684 38.439992 21448
17901 2020-11-18 Sonoma 97 95405: Santa Rosa 327   -122.6684 38.439992 21448
20245 2020-11-16 Sonoma 97 95405: Santa Rosa 325   -122.6684 38.439992 21448
20964 2020-11-15 Sonoma 97 95405: Santa Rosa 325   -122.6684 38.439992 21448
21849 2020-11-14 Sonoma 97 95405: Santa Rosa 325   -122.6684 38.439992 21448
22923 2020-11-13 Sonoma 97 95405: Santa Rosa 324   -122.6684 38.439992 21448
24085 2020-11-12 Sonoma 97 95405: Santa Rosa 322   -122.6684 38.439992 21448
25000 2020-11-11 Sonoma 97 95405: Santa Rosa 321   -122.6684 38.439992 21448
26154 2020-11-10 Sonoma 97 95405: Santa Rosa 318   -122.6684 38.439992 21448
27258 2020-11-09 Sonoma 97 95405: Santa Rosa 316   -122.6684 38.439992 21448
28129 2020-11-08 Sonoma 97 95405: Santa Rosa 312   -122.6684 38.439992 21448
28940 2020-11-07 Sonoma 97 95405: Santa Rosa 312   -122.6684 38.439992 21448
30104 2020-11-06 Sonoma 97 95405: Santa Rosa 311   -122.6684 38.439992 21448
31250 2020-11-05 Sonoma 97 95405: Santa Rosa 309   -122.6684 38.439992 21448
32393 2020-11-04 Sonoma 97 95405: Santa Rosa 301   -122.6684 38.439992 21448
33568 2020-11-03 Sonoma 97 95405: Santa Rosa 299   -122.6684 38.439992 21448
34654 2020-11-02 Sonoma 97 95405: Santa Rosa 296   -122.6684 38.439992 21448
35508 2020-11-01 Sonoma 97 95405: Santa Rosa 293   -122.6684 38.439992 21448
36317 2020-10-31 Sonoma 97 95405: Santa Rosa 293   -122.6684 38.439992 21448
37420 2020-10-30 Sonoma 97 95405: Santa Rosa 293   -122.6684 38.439992 21448
38586 2020-10-29 Sonoma 97 95405: Santa Rosa 290   -122.6684 38.439992 21448
39687 2020-10-28 Sonoma 97 95405: Santa Rosa 289   -122.6684 38.439992 21448
40810 2020-10-27 Sonoma 97 95405: Santa Rosa 283   -122.6684 38.439992 21448
41915 2020-10-26 Sonoma 97 95405: Santa Rosa 280   -122.6684 38.439992 21448
42766 2020-10-25 Sonoma 97 95405: Santa Rosa 272   -122.6684 38.439992 21448
43570 2020-10-24 Sonoma 97 95405: Santa Rosa 270   -122.6684 38.439992 21448
44721 2020-10-23 Sonoma 97 95405: Santa Rosa 267   -122.6684 38.439992 21448
45824 2020-10-22 Sonoma 97 95405: Santa Rosa 264   -122.6684 38.439992 21448
46942 2020-10-21 Sonoma 97 95405: Santa Rosa 261   -122.6684 38.439992 21448
48112 2020-10-20 Sonoma 97 95405: Santa Rosa 259   -122.6684 38.439992 21448
49235 2020-10-19 Sonoma 97 95405: Santa Rosa 255   -122.6684 38.439992 21448
50069 2020-10-18 Sonoma 97 95405: Santa Rosa 252   -122.6684 38.439992 21448
50954 2020-10-17 Sonoma 97 95405: Santa Rosa 252   -122.6684 38.439992 21448
52084 2020-10-16 Sonoma 97 95405: Santa Rosa 248   -122.6684 38.439992 21448
53209 2020-10-15 Sonoma 97 95405: Santa Rosa 239   -122.6684 38.439992 21448
54330 2020-10-14 Sonoma 97 95405: Santa Rosa 233   -122.6684 38.439992 21448
55396 2020-10-13 Sonoma 97 95405: Santa Rosa 225   -122.6684 38.439992 21448
56436 2020-10-12 Sonoma 97 95405: Santa Rosa 223   -122.6684 38.439992 21448
57267 2020-10-11 Sonoma 97 95405: Santa Rosa 221   -122.6684 38.439992 21448
58134 2020-10-10 Sonoma 97 95405: Santa Rosa 220   -122.6684 38.439992 21448
59261 2020-10-09 Sonoma 97 95405: Santa Rosa 216   -122.6684 38.439992 21448
60370 2020-10-08 Sonoma 97 95405: Santa Rosa 215   -122.6684 38.439992 21448
61483 2020-10-07 Sonoma 97 95405: Santa Rosa 212   -122.6684 38.439992 21448
62586 2020-10-06 Sonoma 97 95405: Santa Rosa 211   -122.6684 38.439992 21448
63659 2020-10-05 Sonoma 97 95405: Santa Rosa 207   -122.6684 38.439992 21448
64506 2020-10-04 Sonoma 97 95405: Santa Rosa 205   -122.6684 38.439992 21448
65354 2020-10-03 Sonoma 97 95405: Santa Rosa 202   -122.6684 38.439992 21448
66496 2020-10-02 Sonoma 97 95405: Santa Rosa 202   -122.6684 38.439992 21448
67579 2020-10-01 Sonoma 97 95405: Santa Rosa 199   -122.6684 38.439992 21448
68671 2020-09-30 Sonoma 97 95405: Santa Rosa 197   -122.6684 38.439992 21448
69793 2020-09-29 Sonoma 97 95405: Santa Rosa 195   -122.6684 38.439992 21448
70912 2020-09-28 Sonoma 97 95405: Santa Rosa 192   -122.6684 38.439992 21448
71736 2020-09-27 Sonoma 97 95405: Santa Rosa 189   -122.6684 38.439992 21448
72599 2020-09-26 Sonoma 97 95405: Santa Rosa 189   -122.6684 38.439992 21448
73740 2020-09-25 Sonoma 97 95405: Santa Rosa 189   -122.6684 38.439992 21448
74854 2020-09-24 Sonoma 97 95405: Santa Rosa 186   -122.6684 38.439992 21448
75952 2020-09-23 Sonoma 97 95405: Santa Rosa 186   -122.6684 38.439992 21448
77003 2020-09-22 Sonoma 97 95405: Santa Rosa 186   -122.6684 38.439992 21448
78051 2020-09-21 Sonoma 97 95405: Santa Rosa 186   -122.6684 38.439992 21448
78897 2020-09-20 Sonoma 97 95405: Santa Rosa 179   -122.6684 38.439992 21448
79761 2020-09-19 Sonoma 97 95405: Santa Rosa 178   -122.6684 38.439992 21448
80882 2020-09-18 Sonoma 97 95405: Santa Rosa 177   -122.6684 38.439992 21448
81992 2020-09-17 Sonoma 97 95405: Santa Rosa 177   -122.6684 38.439992 21448
83031 2020-09-16 Sonoma 97 95405: Santa Rosa 177   -122.6684 38.439992 21448
84177 2020-09-15 Sonoma 97 95405: Santa Rosa 177   -122.6684 38.439992 21448
85290 2020-09-14 Sonoma 97 95405: Santa Rosa 172   -122.6684 38.439992 21448
86159 2020-09-13 Sonoma 97 95405: Santa Rosa 171   -122.6684 38.439992 21448
87022 2020-09-12 Sonoma 97 95405: Santa Rosa 170   -122.6684 38.439992 21448
88168 2020-09-11 Sonoma 97 95405: Santa Rosa 170   -122.6684 38.439992 21448
89232 2020-09-10 Sonoma 97 95405: Santa Rosa 170   -122.6684 38.439992 21448
90356 2020-09-09 Sonoma 97 95405: Santa Rosa 169   -122.6684 38.439992 21448
91469 2020-09-08 Sonoma 97 95405: Santa Rosa 168   -122.6684 38.439992 21448
92314 2020-09-07 Sonoma 97 95405: Santa Rosa 166   -122.6684 38.439992 21448
93125 2020-09-06 Sonoma 97 95405: Santa Rosa 163   -122.6684 38.439992 21448
93952 2020-09-05 Sonoma 97 95405: Santa Rosa 161   -122.6684 38.439992 21448
95103 2020-09-04 Sonoma 97 95405: Santa Rosa 161   -122.6684 38.439992 21448
96166 2020-09-03 Sonoma 97 95405: Santa Rosa 156   -122.6684 38.439992 21448
97258 2020-09-02 Sonoma 97 95405: Santa Rosa 154   -122.6684 38.439992 21448
98404 2020-09-01 Sonoma 97 95405: Santa Rosa 152   -122.6684 38.439992 21448
99473 2020-08-31 Sonoma 97 95405: Santa Rosa 151   -122.6684 38.439992 21448
100348 2020-08-30 Sonoma 97 95405: Santa Rosa 148   -122.6684 38.439992 21448
101449 2020-08-29 Sonoma 97 95405: Santa Rosa 146   -122.6684 38.439992 21448
102130 2020-08-28 Sonoma 97 95405: Santa Rosa 146   -122.6684 38.439992 21448
103156 2020-08-27 Sonoma 97 95405: Santa Rosa 142   -122.6684 38.439992 21448
104229 2020-08-26 Sonoma 97 95405: Santa Rosa 141   -122.6684 38.439992 21448
105287 2020-08-25 Sonoma 97 95405: Santa Rosa 140   -122.6684 38.439992 21448
106386 2020-08-24 Sonoma 97 95405: Santa Rosa 138   -122.6684 38.439992 21448
107148 2020-08-23 Sonoma 97 95405: Santa Rosa 136   -122.6684 38.439992 21448
108123 2020-08-22 Sonoma 97 95405: Santa Rosa 136   -122.6684 38.439992 21448
109199 2020-08-21 Sonoma 97 95405: Santa Rosa 135   -122.6684 38.439992 21448
110289 2020-08-20 Sonoma 97 95405: Santa Rosa 135   -122.6684 38.439992 21448
111381 2020-08-19 Sonoma 97 95405: Santa Rosa 135   -122.6684 38.439992 21448
112512 2020-08-18 Sonoma 97 95405: Santa Rosa 134   -122.6684 38.439992 21448
113585 2020-08-17 Sonoma 97 95405: Santa Rosa 134   -122.6684 38.439992 21448
114509 2020-08-16 Sonoma 97 95405: Santa Rosa 133   -122.6684 38.439992 21448
115323 2020-08-15 Sonoma 97 95405: Santa Rosa 131   -122.6684 38.439992 21448
116433 2020-08-14 Sonoma 97 95405: Santa Rosa 126   -122.6684 38.439992 21448

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [latimes_place_totals] (
   [date] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [place] TEXT,
   [confirmed_cases] INTEGER,
   [note] TEXT,
   [x] TEXT,
   [y] TEXT,
   [population] TEXT
);