latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
77 rows where county = "Sonoma" and did_not_update = "TRUE" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
235 | 235 | Sonoma | Sonoma | 97 | 2021-08-30 | 36498 | 353 | TRUE |
296 | 296 | Sonoma | Sonoma | 97 | 2021-08-29 | 36498 | 353 | TRUE |
418 | 418 | Sonoma | Sonoma | 97 | 2021-08-27 | 36158 | 349 | TRUE |
601 | 601 | Sonoma | Sonoma | 97 | 2021-08-24 | 35664 | 344 | TRUE |
1150 | 1150 | Sonoma | Sonoma | 97 | 2021-08-15 | 34686 | 338 | TRUE |
1272 | 1272 | Sonoma | Sonoma | 97 | 2021-08-13 | 34394 | 337 | TRUE |
1943 | 1943 | Sonoma | Sonoma | 97 | 2021-08-02 | 32880 | 330 | TRUE |
2309 | 2309 | Sonoma | Sonoma | 97 | 2021-07-27 | 32325 | 329 | TRUE |
2797 | 2797 | Sonoma | Sonoma | 97 | 2021-07-19 | 31763 | 327 | TRUE |
2919 | 2919 | Sonoma | Sonoma | 97 | 2021-07-17 | 31703 | 327 | TRUE |
3163 | 3163 | Sonoma | Sonoma | 97 | 2021-07-13 | 31435 | 323 | TRUE |
3529 | 3529 | Sonoma | Sonoma | 97 | 2021-07-07 | 31160 | 318 | TRUE |
3590 | 3590 | Sonoma | Sonoma | 97 | 2021-07-06 | 31160 | 318 | TRUE |
3712 | 3712 | Sonoma | Sonoma | 97 | 2021-07-04 | 31116 | 318 | TRUE |
4017 | 4017 | Sonoma | Sonoma | 97 | 2021-06-29 | 30941 | 317 | TRUE |
4139 | 4139 | Sonoma | Sonoma | 97 | 2021-06-27 | 30941 | 317 | TRUE |
4871 | 4871 | Sonoma | Sonoma | 97 | 2021-06-15 | 30688 | 316 | TRUE |
4932 | 4932 | Sonoma | Sonoma | 97 | 2021-06-14 | 30688 | 316 | TRUE |
4993 | 4993 | Sonoma | Sonoma | 97 | 2021-06-13 | 30688 | 316 | TRUE |
5481 | 5481 | Sonoma | Sonoma | 97 | 2021-06-05 | 30454 | 315 | TRUE |
6579 | 6579 | Sonoma | Sonoma | 97 | 2021-05-18 | 30071 | 314 | TRUE |
6762 | 6762 | Sonoma | Sonoma | 97 | 2021-05-15 | 30053 | 314 | TRUE |
7006 | 7006 | Sonoma | Sonoma | 97 | 2021-05-11 | 30002 | 312 | TRUE |
7616 | 7616 | Sonoma | Sonoma | 97 | 2021-05-01 | 29856 | 312 | TRUE |
8104 | 8104 | Sonoma | Sonoma | 97 | 2021-04-23 | 29747 | 312 | TRUE |
8470 | 8470 | Sonoma | Sonoma | 97 | 2021-04-17 | 29632 | 311 | TRUE |
8531 | 8531 | Sonoma | Sonoma | 97 | 2021-04-16 | 29632 | 311 | TRUE |
8653 | 8653 | Sonoma | Sonoma | 97 | 2021-04-14 | 29573 | 311 | TRUE |
8897 | 8897 | Sonoma | Sonoma | 97 | 2021-04-10 | 29448 | 309 | TRUE |
9507 | 9507 | Sonoma | Sonoma | 97 | 2021-03-31 | 29235 | 308 | TRUE |
9934 | 9934 | Sonoma | Sonoma | 97 | 2021-03-24 | 29045 | 308 | TRUE |
10239 | 10239 | Sonoma | Sonoma | 97 | 2021-03-19 | 28882 | 308 | TRUE |
10361 | 10361 | Sonoma | Sonoma | 97 | 2021-03-17 | 28820 | 308 | TRUE |
10483 | 10483 | Sonoma | Sonoma | 97 | 2021-03-15 | 28753 | 308 | TRUE |
10788 | 10788 | Sonoma | Sonoma | 97 | 2021-03-10 | 28538 | 306 | TRUE |
10910 | 10910 | Sonoma | Sonoma | 97 | 2021-03-08 | 28448 | 303 | TRUE |
11520 | 11520 | Sonoma | Sonoma | 97 | 2021-02-26 | 27925 | 298 | TRUE |
12069 | 12069 | Sonoma | Sonoma | 97 | 2021-02-17 | 27361 | 291 | TRUE |
13960 | 13960 | Sonoma | Sonoma | 97 | 2021-01-17 | 23261 | 234 | TRUE |
14326 | 14326 | Sonoma | Sonoma | 97 | 2021-01-11 | 21463 | 218 | TRUE |
15058 | 15058 | Sonoma | Sonoma | 97 | 2020-12-30 | 18872 | 184 | TRUE |
15607 | 15607 | Sonoma | Sonoma | 97 | 2020-12-21 | 16706 | 174 | TRUE |
15790 | 15790 | Sonoma | Sonoma | 97 | 2020-12-18 | 16024 | 172 | TRUE |
17010 | 17010 | Sonoma | Sonoma | 97 | 2020-11-28 | 12049 | 157 | TRUE |
17071 | 17071 | Sonoma | Sonoma | 97 | 2020-11-27 | 12049 | 157 | TRUE |
17132 | 17132 | Sonoma | Sonoma | 97 | 2020-11-26 | 11846 | 157 | TRUE |
17254 | 17254 | Sonoma | Sonoma | 97 | 2020-11-24 | 11608 | 155 | TRUE |
18230 | 18230 | Sonoma | Sonoma | 97 | 2020-11-08 | 10248 | 146 | TRUE |
18657 | 18657 | Sonoma | Sonoma | 97 | 2020-11-01 | 9686 | 136 | TRUE |
19511 | 19511 | Sonoma | Sonoma | 97 | 2020-10-18 | 8810 | 129 | TRUE |
20426 | 20426 | Sonoma | Sonoma | 97 | 2020-10-03 | 7799 | 122 | TRUE |
20731 | 20731 | Sonoma | Sonoma | 97 | 2020-09-28 | 7412 | 122 | TRUE |
22012 | 22012 | Sonoma | Sonoma | 97 | 2020-09-07 | 6360 | 93 | TRUE |
22195 | 22195 | Sonoma | Sonoma | 97 | 2020-09-04 | 6142 | 93 | TRUE |
22561 | 22561 | Sonoma | Sonoma | 97 | 2020-08-29 | 5588 | 78 | TRUE |
23598 | 23598 | Sonoma | Sonoma | 97 | 2020-08-12 | 3825 | 51 | TRUE |
24147 | 24147 | Sonoma | Sonoma | 97 | 2020-08-03 | 3113 | 39 | TRUE |
24391 | 24391 | Sonoma | Sonoma | 97 | 2020-07-30 | 2842 | 32 | TRUE |
24513 | 24513 | Sonoma | Sonoma | 97 | 2020-07-28 | 2662 | 31 | TRUE |
24696 | 24696 | Sonoma | Sonoma | 97 | 2020-07-25 | 2559 | 24 | TRUE |
24818 | 24818 | Sonoma | Sonoma | 97 | 2020-07-23 | 2300 | 22 | TRUE |
24879 | 24879 | Sonoma | Sonoma | 97 | 2020-07-22 | 2241 | 22 | TRUE |
25306 | 25306 | Sonoma | Sonoma | 97 | 2020-07-15 | 1941 | 16 | TRUE |
25855 | 25855 | Sonoma | Sonoma | 97 | 2020-07-06 | 1359 | 11 | TRUE |
25916 | 25916 | Sonoma | Sonoma | 97 | 2020-07-05 | 1359 | 11 | TRUE |
26038 | 26038 | Sonoma | Sonoma | 97 | 2020-07-03 | 1267 | 10 | TRUE |
26465 | 26465 | Sonoma | Sonoma | 97 | 2020-06-26 | 1006 | 5 | TRUE |
26587 | 26587 | Sonoma | Sonoma | 97 | 2020-06-24 | 956 | 5 | TRUE |
26709 | 26709 | Sonoma | Sonoma | 97 | 2020-06-22 | 935 | 5 | TRUE |
26831 | 26831 | Sonoma | Sonoma | 97 | 2020-06-20 | 835 | 4 | TRUE |
27685 | 27685 | Sonoma | Sonoma | 97 | 2020-06-06 | 624 | 4 | TRUE |
28112 | 28112 | Sonoma | Sonoma | 97 | 2020-05-30 | 548 | 4 | TRUE |
28234 | 28234 | Sonoma | Sonoma | 97 | 2020-05-28 | 531 | 4 | TRUE |
28905 | 28905 | Sonoma | Sonoma | 97 | 2020-05-17 | 373 | 4 | TRUE |
29637 | 29637 | Sonoma | Sonoma | 97 | 2020-05-05 | 261 | 3 | TRUE |
31013 | 31013 | Sonoma | Sonoma | 97 | 2020-04-11 | 145 | 2 | TRUE |
31775 | 31775 | Sonoma | Sonoma | 97 | 2020-03-28 | 54 | 1 | TRUE |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_agency_totals] ( [agency] TEXT, [county] TEXT, [fips] INTEGER, [date] TEXT, [confirmed_cases] INTEGER, [deaths] INTEGER, [did_not_update] TEXT );