⚠️ 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 = "95476: Sonoma" sorted by date descending

View and edit SQL

Suggested facets: note, date (date)

place

  • 95476: Sonoma · 257

fips

county

Link rowid date ▲ county fips place confirmed_cases note x y population
7103 2020-11-24 Sonoma 97 95476: Sonoma 802   -122.453234 38.243851 36792
8131 2020-11-23 Sonoma 97 95476: Sonoma 802   -122.453234 38.243851 36792
13216 2020-11-18 Sonoma 97 95476: Sonoma 802   -122.453234 38.243851 36792
15576 2020-11-16 Sonoma 97 95476: Sonoma 796   -122.453234 38.243851 36792
16295 2020-11-15 Sonoma 97 95476: Sonoma 795   -122.453234 38.243851 36792
17180 2020-11-14 Sonoma 97 95476: Sonoma 795   -122.453234 38.243851 36792
18262 2020-11-13 Sonoma 97 95476: Sonoma 794   -122.453234 38.243851 36792
19432 2020-11-12 Sonoma 97 95476: Sonoma 791   -122.453234 38.243851 36792
20347 2020-11-11 Sonoma 97 95476: Sonoma 786   -122.453234 38.243851 36792
21509 2020-11-10 Sonoma 97 95476: Sonoma 773   -122.453234 38.243851 36792
22620 2020-11-09 Sonoma 97 95476: Sonoma 757   -122.453234 38.243851 36792
23491 2020-11-08 Sonoma 97 95476: Sonoma 734   -122.453234 38.243851 36792
24302 2020-11-07 Sonoma 97 95476: Sonoma 734   -122.453234 38.243851 36792
25474 2020-11-06 Sonoma 97 95476: Sonoma 731   -122.453234 38.243851 36792
26628 2020-11-05 Sonoma 97 95476: Sonoma 714   -122.453234 38.243851 36792
27779 2020-11-04 Sonoma 97 95476: Sonoma 704   -122.453234 38.243851 36792
28962 2020-11-03 Sonoma 97 95476: Sonoma 695   -122.453234 38.243851 36792
30056 2020-11-02 Sonoma 97 95476: Sonoma 690   -122.453234 38.243851 36792
30910 2020-11-01 Sonoma 97 95476: Sonoma 684   -122.453234 38.243851 36792
31719 2020-10-31 Sonoma 97 95476: Sonoma 679   -122.453234 38.243851 36792
32830 2020-10-30 Sonoma 97 95476: Sonoma 676   -122.453234 38.243851 36792
34004 2020-10-29 Sonoma 97 95476: Sonoma 671   -122.453234 38.243851 36792
35113 2020-10-28 Sonoma 97 95476: Sonoma 667   -122.453234 38.243851 36792
36244 2020-10-27 Sonoma 97 95476: Sonoma 660   -122.453234 38.243851 36792
37357 2020-10-26 Sonoma 97 95476: Sonoma 655   -122.453234 38.243851 36792
38208 2020-10-25 Sonoma 97 95476: Sonoma 649   -122.453234 38.243851 36792
39012 2020-10-24 Sonoma 97 95476: Sonoma 649   -122.453234 38.243851 36792
40171 2020-10-23 Sonoma 97 95476: Sonoma 648   -122.453234 38.243851 36792
41282 2020-10-22 Sonoma 97 95476: Sonoma 643   -122.453234 38.243851 36792
42400 2020-10-21 Sonoma 97 95476: Sonoma 635   -122.453234 38.243851 36792
43570 2020-10-20 Sonoma 97 95476: Sonoma 627   -122.453234 38.243851 36792
44701 2020-10-19 Sonoma 97 95476: Sonoma 618   -122.453234 38.243851 36792
45535 2020-10-18 Sonoma 97 95476: Sonoma 616   -122.453234 38.243851 36792
46420 2020-10-17 Sonoma 97 95476: Sonoma 611   -122.453234 38.243851 36792
47558 2020-10-16 Sonoma 97 95476: Sonoma 607   -122.453234 38.243851 36792
48691 2020-10-15 Sonoma 97 95476: Sonoma 600   -122.453234 38.243851 36792
49820 2020-10-14 Sonoma 97 95476: Sonoma 599   -122.453234 38.243851 36792
50894 2020-10-13 Sonoma 97 95476: Sonoma 589   -122.453234 38.243851 36792
51942 2020-10-12 Sonoma 97 95476: Sonoma 582   -122.453234 38.243851 36792
52773 2020-10-11 Sonoma 97 95476: Sonoma 581   -122.453234 38.243851 36792
53648 2020-10-10 Sonoma 97 95476: Sonoma 581   -122.453234 38.243851 36792
54783 2020-10-09 Sonoma 97 95476: Sonoma 580   -122.453234 38.243851 36792
55900 2020-10-08 Sonoma 97 95476: Sonoma 576   -122.453234 38.243851 36792
57021 2020-10-07 Sonoma 97 95476: Sonoma 572   -122.453234 38.243851 36792
58124 2020-10-06 Sonoma 97 95476: Sonoma 549   -122.453234 38.243851 36792
59205 2020-10-05 Sonoma 97 95476: Sonoma 543   -122.453234 38.243851 36792
60052 2020-10-04 Sonoma 97 95476: Sonoma 537   -122.453234 38.243851 36792
60900 2020-10-03 Sonoma 97 95476: Sonoma 534   -122.453234 38.243851 36792
62050 2020-10-02 Sonoma 97 95476: Sonoma 529   -122.453234 38.243851 36792
63141 2020-10-01 Sonoma 97 95476: Sonoma 519   -122.453234 38.243851 36792
64241 2020-09-30 Sonoma 97 95476: Sonoma 508   -122.453234 38.243851 36792
65371 2020-09-29 Sonoma 97 95476: Sonoma 505   -122.453234 38.243851 36792
66498 2020-09-28 Sonoma 97 95476: Sonoma 499   -122.453234 38.243851 36792
67322 2020-09-27 Sonoma 97 95476: Sonoma 494   -122.453234 38.243851 36792
68185 2020-09-26 Sonoma 97 95476: Sonoma 492   -122.453234 38.243851 36792
69334 2020-09-25 Sonoma 97 95476: Sonoma 487   -122.453234 38.243851 36792
70456 2020-09-24 Sonoma 97 95476: Sonoma 485   -122.453234 38.243851 36792
71562 2020-09-23 Sonoma 97 95476: Sonoma 480   -122.453234 38.243851 36792
72613 2020-09-22 Sonoma 97 95476: Sonoma 479   -122.453234 38.243851 36792
73669 2020-09-21 Sonoma 97 95476: Sonoma 472   -122.453234 38.243851 36792
74515 2020-09-20 Sonoma 97 95476: Sonoma 468   -122.453234 38.243851 36792
75379 2020-09-19 Sonoma 97 95476: Sonoma 467   -122.453234 38.243851 36792
76508 2020-09-18 Sonoma 97 95476: Sonoma 465   -122.453234 38.243851 36792
77626 2020-09-17 Sonoma 97 95476: Sonoma 462   -122.453234 38.243851 36792
78673 2020-09-16 Sonoma 97 95476: Sonoma 461   -122.453234 38.243851 36792
79827 2020-09-15 Sonoma 97 95476: Sonoma 458   -122.453234 38.243851 36792
80948 2020-09-14 Sonoma 97 95476: Sonoma 454   -122.453234 38.243851 36792
81825 2020-09-13 Sonoma 97 95476: Sonoma 452   -122.453234 38.243851 36792
82688 2020-09-12 Sonoma 97 95476: Sonoma 451   -122.453234 38.243851 36792
83842 2020-09-11 Sonoma 97 95476: Sonoma 450   -122.453234 38.243851 36792
84914 2020-09-10 Sonoma 97 95476: Sonoma 449   -122.453234 38.243851 36792
86046 2020-09-09 Sonoma 97 95476: Sonoma 445   -122.453234 38.243851 36792
87167 2020-09-08 Sonoma 97 95476: Sonoma 442   -122.453234 38.243851 36792
88020 2020-09-07 Sonoma 97 95476: Sonoma 439   -122.453234 38.243851 36792
88830 2020-09-06 Sonoma 97 95476: Sonoma 432   -122.453234 38.243851 36792
89657 2020-09-05 Sonoma 97 95476: Sonoma 431   -122.453234 38.243851 36792
90816 2020-09-04 Sonoma 97 95476: Sonoma 431   -122.453234 38.243851 36792
91879 2020-09-03 Sonoma 97 95476: Sonoma 430   -122.453234 38.243851 36792
92971 2020-09-02 Sonoma 97 95476: Sonoma 426   -122.453234 38.243851 36792
94125 2020-09-01 Sonoma 97 95476: Sonoma 422   -122.453234 38.243851 36792
95202 2020-08-31 Sonoma 97 95476: Sonoma 418   -122.453234 38.243851 36792
96077 2020-08-30 Sonoma 97 95476: Sonoma 416   -122.453234 38.243851 36792
97178 2020-08-29 Sonoma 97 95476: Sonoma 413   -122.453234 38.243851 36792
97867 2020-08-28 Sonoma 97 95476: Sonoma 412   -122.453234 38.243851 36792
98893 2020-08-27 Sonoma 97 95476: Sonoma 412   -122.453234 38.243851 36792
99974 2020-08-26 Sonoma 97 95476: Sonoma 409   -122.453234 38.243851 36792
101040 2020-08-25 Sonoma 97 95476: Sonoma 405   -122.453234 38.243851 36792
102147 2020-08-24 Sonoma 97 95476: Sonoma 402   -122.453234 38.243851 36792
102909 2020-08-23 Sonoma 97 95476: Sonoma 398   -122.453234 38.243851 36792
103884 2020-08-22 Sonoma 97 95476: Sonoma 396   -122.453234 38.243851 36792
104968 2020-08-21 Sonoma 97 95476: Sonoma 394   -122.453234 38.243851 36792
106066 2020-08-20 Sonoma 97 95476: Sonoma 390   -122.453234 38.243851 36792
107166 2020-08-19 Sonoma 97 95476: Sonoma 385   -122.453234 38.243851 36792
108305 2020-08-18 Sonoma 97 95476: Sonoma 382   -122.453234 38.243851 36792
109386 2020-08-17 Sonoma 97 95476: Sonoma 378   -122.453234 38.243851 36792
110318 2020-08-16 Sonoma 97 95476: Sonoma 375   -122.453234 38.243851 36792
111132 2020-08-15 Sonoma 97 95476: Sonoma 368   -122.453234 38.243851 36792
112250 2020-08-14 Sonoma 97 95476: Sonoma 367   -122.453234 38.243851 36792
113259 2020-08-13 Sonoma 97 95476: Sonoma 363   -122.453234 38.243851 36792
114365 2020-08-12 Sonoma 97 95476: Sonoma 357   -122.453234 38.243851 36792

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