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

255 rows where place = "95401: Santa Rosa" sorted by date descending

View and edit SQL

Suggested facets: note, date (date)

place

  • 95401: Santa Rosa · 255

fips

county

Link rowid date ▲ county fips place confirmed_cases note x y population
7083 2020-11-24 Sonoma 97 95401: Santa Rosa 1035   -122.794451 38.449567 38986
8111 2020-11-23 Sonoma 97 95401: Santa Rosa 1035   -122.794451 38.449567 38986
13196 2020-11-18 Sonoma 97 95401: Santa Rosa 1035   -122.794451 38.449567 38986
15556 2020-11-16 Sonoma 97 95401: Santa Rosa 1030   -122.794451 38.449567 38986
16275 2020-11-15 Sonoma 97 95401: Santa Rosa 1030   -122.794451 38.449567 38986
17160 2020-11-14 Sonoma 97 95401: Santa Rosa 1030   -122.794451 38.449567 38986
18242 2020-11-13 Sonoma 97 95401: Santa Rosa 1029   -122.794451 38.449567 38986
19412 2020-11-12 Sonoma 97 95401: Santa Rosa 1022   -122.794451 38.449567 38986
20327 2020-11-11 Sonoma 97 95401: Santa Rosa 1018   -122.794451 38.449567 38986
21489 2020-11-10 Sonoma 97 95401: Santa Rosa 1014   -122.794451 38.449567 38986
22601 2020-11-09 Sonoma 97 95401: Santa Rosa 1008   -122.794451 38.449567 38986
23472 2020-11-08 Sonoma 97 95401: Santa Rosa 996   -122.794451 38.449567 38986
24283 2020-11-07 Sonoma 97 95401: Santa Rosa 995   -122.794451 38.449567 38986
25455 2020-11-06 Sonoma 97 95401: Santa Rosa 993   -122.794451 38.449567 38986
26609 2020-11-05 Sonoma 97 95401: Santa Rosa 982   -122.794451 38.449567 38986
27760 2020-11-04 Sonoma 97 95401: Santa Rosa 972   -122.794451 38.449567 38986
28943 2020-11-03 Sonoma 97 95401: Santa Rosa 969   -122.794451 38.449567 38986
30037 2020-11-02 Sonoma 97 95401: Santa Rosa 960   -122.794451 38.449567 38986
30891 2020-11-01 Sonoma 97 95401: Santa Rosa 954   -122.794451 38.449567 38986
31700 2020-10-31 Sonoma 97 95401: Santa Rosa 952   -122.794451 38.449567 38986
32811 2020-10-30 Sonoma 97 95401: Santa Rosa 951   -122.794451 38.449567 38986
33985 2020-10-29 Sonoma 97 95401: Santa Rosa 945   -122.794451 38.449567 38986
35094 2020-10-28 Sonoma 97 95401: Santa Rosa 939   -122.794451 38.449567 38986
36225 2020-10-27 Sonoma 97 95401: Santa Rosa 934   -122.794451 38.449567 38986
37338 2020-10-26 Sonoma 97 95401: Santa Rosa 929   -122.794451 38.449567 38986
38189 2020-10-25 Sonoma 97 95401: Santa Rosa 921   -122.794451 38.449567 38986
38993 2020-10-24 Sonoma 97 95401: Santa Rosa 921   -122.794451 38.449567 38986
40152 2020-10-23 Sonoma 97 95401: Santa Rosa 920   -122.794451 38.449567 38986
41263 2020-10-22 Sonoma 97 95401: Santa Rosa 913   -122.794451 38.449567 38986
42381 2020-10-21 Sonoma 97 95401: Santa Rosa 907   -122.794451 38.449567 38986
43551 2020-10-20 Sonoma 97 95401: Santa Rosa 898   -122.794451 38.449567 38986
44682 2020-10-19 Sonoma 97 95401: Santa Rosa 891   -122.794451 38.449567 38986
45516 2020-10-18 Sonoma 97 95401: Santa Rosa 875   -122.794451 38.449567 38986
46401 2020-10-17 Sonoma 97 95401: Santa Rosa 872   -122.794451 38.449567 38986
47539 2020-10-16 Sonoma 97 95401: Santa Rosa 868   -122.794451 38.449567 38986
48672 2020-10-15 Sonoma 97 95401: Santa Rosa 863   -122.794451 38.449567 38986
49801 2020-10-14 Sonoma 97 95401: Santa Rosa 861   -122.794451 38.449567 38986
50875 2020-10-13 Sonoma 97 95401: Santa Rosa 853   -122.794451 38.449567 38986
51923 2020-10-12 Sonoma 97 95401: Santa Rosa 850   -122.794451 38.449567 38986
52754 2020-10-11 Sonoma 97 95401: Santa Rosa 842   -122.794451 38.449567 38986
53629 2020-10-10 Sonoma 97 95401: Santa Rosa 839   -122.794451 38.449567 38986
54764 2020-10-09 Sonoma 97 95401: Santa Rosa 835   -122.794451 38.449567 38986
55881 2020-10-08 Sonoma 97 95401: Santa Rosa 834   -122.794451 38.449567 38986
57002 2020-10-07 Sonoma 97 95401: Santa Rosa 825   -122.794451 38.449567 38986
58105 2020-10-06 Sonoma 97 95401: Santa Rosa 815   -122.794451 38.449567 38986
59186 2020-10-05 Sonoma 97 95401: Santa Rosa 805   -122.794451 38.449567 38986
60033 2020-10-04 Sonoma 97 95401: Santa Rosa 801   -122.794451 38.449567 38986
60881 2020-10-03 Sonoma 97 95401: Santa Rosa 796   -122.794451 38.449567 38986
62031 2020-10-02 Sonoma 97 95401: Santa Rosa 791   -122.794451 38.449567 38986
63122 2020-10-01 Sonoma 97 95401: Santa Rosa 787   -122.794451 38.449567 38986
64222 2020-09-30 Sonoma 97 95401: Santa Rosa 779   -122.794451 38.449567 38986
65352 2020-09-29 Sonoma 97 95401: Santa Rosa 769   -122.794451 38.449567 38986
66479 2020-09-28 Sonoma 97 95401: Santa Rosa 757   -122.794451 38.449567 38986
67303 2020-09-27 Sonoma 97 95401: Santa Rosa 750   -122.794451 38.449567 38986
68166 2020-09-26 Sonoma 97 95401: Santa Rosa 744   -122.794451 38.449567 38986
69315 2020-09-25 Sonoma 97 95401: Santa Rosa 738   -122.794451 38.449567 38986
70437 2020-09-24 Sonoma 97 95401: Santa Rosa 733   -122.794451 38.449567 38986
71543 2020-09-23 Sonoma 97 95401: Santa Rosa 724   -122.794451 38.449567 38986
72594 2020-09-22 Sonoma 97 95401: Santa Rosa 719   -122.794451 38.449567 38986
73650 2020-09-21 Sonoma 97 95401: Santa Rosa 712   -122.794451 38.449567 38986
74496 2020-09-20 Sonoma 97 95401: Santa Rosa 703   -122.794451 38.449567 38986
75360 2020-09-19 Sonoma 97 95401: Santa Rosa 701   -122.794451 38.449567 38986
76489 2020-09-18 Sonoma 97 95401: Santa Rosa 700   -122.794451 38.449567 38986
77607 2020-09-17 Sonoma 97 95401: Santa Rosa 693   -122.794451 38.449567 38986
78654 2020-09-16 Sonoma 97 95401: Santa Rosa 686   -122.794451 38.449567 38986
79808 2020-09-15 Sonoma 97 95401: Santa Rosa 680   -122.794451 38.449567 38986
80929 2020-09-14 Sonoma 97 95401: Santa Rosa 675   -122.794451 38.449567 38986
81806 2020-09-13 Sonoma 97 95401: Santa Rosa 664   -122.794451 38.449567 38986
82669 2020-09-12 Sonoma 97 95401: Santa Rosa 662   -122.794451 38.449567 38986
83823 2020-09-11 Sonoma 97 95401: Santa Rosa 658   -122.794451 38.449567 38986
84895 2020-09-10 Sonoma 97 95401: Santa Rosa 653   -122.794451 38.449567 38986
86027 2020-09-09 Sonoma 97 95401: Santa Rosa 642   -122.794451 38.449567 38986
87148 2020-09-08 Sonoma 97 95401: Santa Rosa 632   -122.794451 38.449567 38986
88001 2020-09-07 Sonoma 97 95401: Santa Rosa 626   -122.794451 38.449567 38986
88812 2020-09-06 Sonoma 97 95401: Santa Rosa 626   -122.794451 38.449567 38986
89639 2020-09-05 Sonoma 97 95401: Santa Rosa 621   -122.794451 38.449567 38986
90798 2020-09-04 Sonoma 97 95401: Santa Rosa 614   -122.794451 38.449567 38986
91861 2020-09-03 Sonoma 97 95401: Santa Rosa 609   -122.794451 38.449567 38986
92953 2020-09-02 Sonoma 97 95401: Santa Rosa 600   -122.794451 38.449567 38986
94107 2020-09-01 Sonoma 97 95401: Santa Rosa 593   -122.794451 38.449567 38986
95184 2020-08-31 Sonoma 97 95401: Santa Rosa 585   -122.794451 38.449567 38986
96059 2020-08-30 Sonoma 97 95401: Santa Rosa 578   -122.794451 38.449567 38986
97160 2020-08-29 Sonoma 97 95401: Santa Rosa 577   -122.794451 38.449567 38986
97849 2020-08-28 Sonoma 97 95401: Santa Rosa 574   -122.794451 38.449567 38986
98875 2020-08-27 Sonoma 97 95401: Santa Rosa 571   -122.794451 38.449567 38986
99956 2020-08-26 Sonoma 97 95401: Santa Rosa 558   -122.794451 38.449567 38986
101022 2020-08-25 Sonoma 97 95401: Santa Rosa 553   -122.794451 38.449567 38986
102129 2020-08-24 Sonoma 97 95401: Santa Rosa 546   -122.794451 38.449567 38986
102891 2020-08-23 Sonoma 97 95401: Santa Rosa 539   -122.794451 38.449567 38986
103866 2020-08-22 Sonoma 97 95401: Santa Rosa 537   -122.794451 38.449567 38986
104950 2020-08-21 Sonoma 97 95401: Santa Rosa 524   -122.794451 38.449567 38986
106048 2020-08-20 Sonoma 97 95401: Santa Rosa 517   -122.794451 38.449567 38986
107148 2020-08-19 Sonoma 97 95401: Santa Rosa 510   -122.794451 38.449567 38986
108287 2020-08-18 Sonoma 97 95401: Santa Rosa 505   -122.794451 38.449567 38986
109368 2020-08-17 Sonoma 97 95401: Santa Rosa 492   -122.794451 38.449567 38986
110300 2020-08-16 Sonoma 97 95401: Santa Rosa 480   -122.794451 38.449567 38986
111114 2020-08-15 Sonoma 97 95401: Santa Rosa 472   -122.794451 38.449567 38986
112232 2020-08-14 Sonoma 97 95401: Santa Rosa 461   -122.794451 38.449567 38986
113241 2020-08-13 Sonoma 97 95401: Santa Rosa 453   -122.794451 38.449567 38986
114347 2020-08-12 Sonoma 97 95401: Santa Rosa 445   -122.794451 38.449567 38986

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