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

257 rows where place = "95407: Santa Rosa" sorted by date descending

View and edit SQL

Suggested facets: note, date (date)

place

  • 95407: Santa Rosa · 257

fips

county

Link rowid date ▲ county fips place confirmed_cases note x y population
2302 2020-12-03 Sonoma 97 95407: Santa Rosa 2174   -122.747988 38.39397 42483
4674 2020-12-01 Sonoma 97 95407: Santa Rosa 2105   -122.747988 38.39397 42483
11809 2020-11-24 Sonoma 97 95407: Santa Rosa 1959   -122.747988 38.39397 42483
12837 2020-11-23 Sonoma 97 95407: Santa Rosa 1959   -122.747988 38.39397 42483
17902 2020-11-18 Sonoma 97 95407: Santa Rosa 1959   -122.747988 38.39397 42483
20246 2020-11-16 Sonoma 97 95407: Santa Rosa 1937   -122.747988 38.39397 42483
20965 2020-11-15 Sonoma 97 95407: Santa Rosa 1935   -122.747988 38.39397 42483
21850 2020-11-14 Sonoma 97 95407: Santa Rosa 1934   -122.747988 38.39397 42483
22924 2020-11-13 Sonoma 97 95407: Santa Rosa 1932   -122.747988 38.39397 42483
24086 2020-11-12 Sonoma 97 95407: Santa Rosa 1927   -122.747988 38.39397 42483
25001 2020-11-11 Sonoma 97 95407: Santa Rosa 1914   -122.747988 38.39397 42483
26155 2020-11-10 Sonoma 97 95407: Santa Rosa 1901   -122.747988 38.39397 42483
27259 2020-11-09 Sonoma 97 95407: Santa Rosa 1886   -122.747988 38.39397 42483
28130 2020-11-08 Sonoma 97 95407: Santa Rosa 1872   -122.747988 38.39397 42483
28941 2020-11-07 Sonoma 97 95407: Santa Rosa 1871   -122.747988 38.39397 42483
30105 2020-11-06 Sonoma 97 95407: Santa Rosa 1862   -122.747988 38.39397 42483
31251 2020-11-05 Sonoma 97 95407: Santa Rosa 1848   -122.747988 38.39397 42483
32394 2020-11-04 Sonoma 97 95407: Santa Rosa 1834   -122.747988 38.39397 42483
33569 2020-11-03 Sonoma 97 95407: Santa Rosa 1822   -122.747988 38.39397 42483
34655 2020-11-02 Sonoma 97 95407: Santa Rosa 1811   -122.747988 38.39397 42483
35509 2020-11-01 Sonoma 97 95407: Santa Rosa 1802   -122.747988 38.39397 42483
36318 2020-10-31 Sonoma 97 95407: Santa Rosa 1799   -122.747988 38.39397 42483
37421 2020-10-30 Sonoma 97 95407: Santa Rosa 1795   -122.747988 38.39397 42483
38587 2020-10-29 Sonoma 97 95407: Santa Rosa 1786   -122.747988 38.39397 42483
39688 2020-10-28 Sonoma 97 95407: Santa Rosa 1779   -122.747988 38.39397 42483
40811 2020-10-27 Sonoma 97 95407: Santa Rosa 1773   -122.747988 38.39397 42483
41916 2020-10-26 Sonoma 97 95407: Santa Rosa 1762   -122.747988 38.39397 42483
42767 2020-10-25 Sonoma 97 95407: Santa Rosa 1752   -122.747988 38.39397 42483
43571 2020-10-24 Sonoma 97 95407: Santa Rosa 1748   -122.747988 38.39397 42483
44722 2020-10-23 Sonoma 97 95407: Santa Rosa 1733   -122.747988 38.39397 42483
45825 2020-10-22 Sonoma 97 95407: Santa Rosa 1727   -122.747988 38.39397 42483
46943 2020-10-21 Sonoma 97 95407: Santa Rosa 1716   -122.747988 38.39397 42483
48113 2020-10-20 Sonoma 97 95407: Santa Rosa 1710   -122.747988 38.39397 42483
49236 2020-10-19 Sonoma 97 95407: Santa Rosa 1697   -122.747988 38.39397 42483
50070 2020-10-18 Sonoma 97 95407: Santa Rosa 1681   -122.747988 38.39397 42483
50955 2020-10-17 Sonoma 97 95407: Santa Rosa 1676   -122.747988 38.39397 42483
52085 2020-10-16 Sonoma 97 95407: Santa Rosa 1654   -122.747988 38.39397 42483
53210 2020-10-15 Sonoma 97 95407: Santa Rosa 1638   -122.747988 38.39397 42483
54331 2020-10-14 Sonoma 97 95407: Santa Rosa 1623   -122.747988 38.39397 42483
55397 2020-10-13 Sonoma 97 95407: Santa Rosa 1614   -122.747988 38.39397 42483
56437 2020-10-12 Sonoma 97 95407: Santa Rosa 1602   -122.747988 38.39397 42483
57268 2020-10-11 Sonoma 97 95407: Santa Rosa 1586   -122.747988 38.39397 42483
58135 2020-10-10 Sonoma 97 95407: Santa Rosa 1581   -122.747988 38.39397 42483
59262 2020-10-09 Sonoma 97 95407: Santa Rosa 1570   -122.747988 38.39397 42483
60371 2020-10-08 Sonoma 97 95407: Santa Rosa 1559   -122.747988 38.39397 42483
61484 2020-10-07 Sonoma 97 95407: Santa Rosa 1549   -122.747988 38.39397 42483
62587 2020-10-06 Sonoma 97 95407: Santa Rosa 1542   -122.747988 38.39397 42483
63660 2020-10-05 Sonoma 97 95407: Santa Rosa 1528   -122.747988 38.39397 42483
64507 2020-10-04 Sonoma 97 95407: Santa Rosa 1514   -122.747988 38.39397 42483
65355 2020-10-03 Sonoma 97 95407: Santa Rosa 1508   -122.747988 38.39397 42483
66497 2020-10-02 Sonoma 97 95407: Santa Rosa 1499   -122.747988 38.39397 42483
67580 2020-10-01 Sonoma 97 95407: Santa Rosa 1494   -122.747988 38.39397 42483
68672 2020-09-30 Sonoma 97 95407: Santa Rosa 1481   -122.747988 38.39397 42483
69794 2020-09-29 Sonoma 97 95407: Santa Rosa 1469   -122.747988 38.39397 42483
70913 2020-09-28 Sonoma 97 95407: Santa Rosa 1457   -122.747988 38.39397 42483
71737 2020-09-27 Sonoma 97 95407: Santa Rosa 1451   -122.747988 38.39397 42483
72600 2020-09-26 Sonoma 97 95407: Santa Rosa 1445   -122.747988 38.39397 42483
73741 2020-09-25 Sonoma 97 95407: Santa Rosa 1438   -122.747988 38.39397 42483
74855 2020-09-24 Sonoma 97 95407: Santa Rosa 1419   -122.747988 38.39397 42483
75953 2020-09-23 Sonoma 97 95407: Santa Rosa 1407   -122.747988 38.39397 42483
77004 2020-09-22 Sonoma 97 95407: Santa Rosa 1398   -122.747988 38.39397 42483
78052 2020-09-21 Sonoma 97 95407: Santa Rosa 1386   -122.747988 38.39397 42483
78898 2020-09-20 Sonoma 97 95407: Santa Rosa 1370   -122.747988 38.39397 42483
79762 2020-09-19 Sonoma 97 95407: Santa Rosa 1358   -122.747988 38.39397 42483
80883 2020-09-18 Sonoma 97 95407: Santa Rosa 1348   -122.747988 38.39397 42483
81993 2020-09-17 Sonoma 97 95407: Santa Rosa 1333   -122.747988 38.39397 42483
83032 2020-09-16 Sonoma 97 95407: Santa Rosa 1319   -122.747988 38.39397 42483
84178 2020-09-15 Sonoma 97 95407: Santa Rosa 1311   -122.747988 38.39397 42483
85291 2020-09-14 Sonoma 97 95407: Santa Rosa 1299   -122.747988 38.39397 42483
86160 2020-09-13 Sonoma 97 95407: Santa Rosa 1278   -122.747988 38.39397 42483
87023 2020-09-12 Sonoma 97 95407: Santa Rosa 1272   -122.747988 38.39397 42483
88169 2020-09-11 Sonoma 97 95407: Santa Rosa 1269   -122.747988 38.39397 42483
89233 2020-09-10 Sonoma 97 95407: Santa Rosa 1253   -122.747988 38.39397 42483
90357 2020-09-09 Sonoma 97 95407: Santa Rosa 1239   -122.747988 38.39397 42483
91470 2020-09-08 Sonoma 97 95407: Santa Rosa 1224   -122.747988 38.39397 42483
92315 2020-09-07 Sonoma 97 95407: Santa Rosa 1211   -122.747988 38.39397 42483
93126 2020-09-06 Sonoma 97 95407: Santa Rosa 1209   -122.747988 38.39397 42483
93953 2020-09-05 Sonoma 97 95407: Santa Rosa 1205   -122.747988 38.39397 42483
95104 2020-09-04 Sonoma 97 95407: Santa Rosa 1190   -122.747988 38.39397 42483
96167 2020-09-03 Sonoma 97 95407: Santa Rosa 1173   -122.747988 38.39397 42483
97259 2020-09-02 Sonoma 97 95407: Santa Rosa 1165   -122.747988 38.39397 42483
98405 2020-09-01 Sonoma 97 95407: Santa Rosa 1135   -122.747988 38.39397 42483
99474 2020-08-31 Sonoma 97 95407: Santa Rosa 1119   -122.747988 38.39397 42483
100349 2020-08-30 Sonoma 97 95407: Santa Rosa 1115   -122.747988 38.39397 42483
101450 2020-08-29 Sonoma 97 95407: Santa Rosa 1104   -122.747988 38.39397 42483
102131 2020-08-28 Sonoma 97 95407: Santa Rosa 1093   -122.747988 38.39397 42483
103157 2020-08-27 Sonoma 97 95407: Santa Rosa 1077   -122.747988 38.39397 42483
104230 2020-08-26 Sonoma 97 95407: Santa Rosa 1070   -122.747988 38.39397 42483
105288 2020-08-25 Sonoma 97 95407: Santa Rosa 1054   -122.747988 38.39397 42483
106387 2020-08-24 Sonoma 97 95407: Santa Rosa 1033   -122.747988 38.39397 42483
107149 2020-08-23 Sonoma 97 95407: Santa Rosa 1020   -122.747988 38.39397 42483
108124 2020-08-22 Sonoma 97 95407: Santa Rosa 1014   -122.747988 38.39397 42483
109200 2020-08-21 Sonoma 97 95407: Santa Rosa 1003   -122.747988 38.39397 42483
110290 2020-08-20 Sonoma 97 95407: Santa Rosa 992   -122.747988 38.39397 42483
111382 2020-08-19 Sonoma 97 95407: Santa Rosa 974   -122.747988 38.39397 42483
112513 2020-08-18 Sonoma 97 95407: Santa Rosa 965   -122.747988 38.39397 42483
113586 2020-08-17 Sonoma 97 95407: Santa Rosa 945   -122.747988 38.39397 42483
114510 2020-08-16 Sonoma 97 95407: Santa Rosa 923   -122.747988 38.39397 42483
115324 2020-08-15 Sonoma 97 95407: Santa Rosa 913   -122.747988 38.39397 42483
116434 2020-08-14 Sonoma 97 95407: Santa Rosa 902   -122.747988 38.39397 42483

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