latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
559 rows where county = "Sonoma" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: did_not_update, date (date)
Link | rowid | agency | county | fips | date | confirmed_cases | deaths ▼ | did_not_update |
---|---|---|---|---|---|---|---|---|
32176 | 32176 | Sonoma | Sonoma | 97 | 2020-03-19 | 11 | 0 | |
32214 | 32214 | Sonoma | Sonoma | 97 | 2020-03-18 | 9 | 0 | |
32251 | 32251 | Sonoma | Sonoma | 97 | 2020-03-17 | 9 | 0 | |
32286 | 32286 | Sonoma | Sonoma | 97 | 2020-03-16 | 7 | 0 | |
32320 | 32320 | Sonoma | Sonoma | 97 | 2020-03-15 | 4 | 0 | |
32352 | 32352 | Sonoma | Sonoma | 97 | 2020-03-14 | 4 | 0 | |
32383 | 32383 | Sonoma | Sonoma | 97 | 2020-03-13 | 2 | 0 | |
32413 | 32413 | Sonoma | Sonoma | 97 | 2020-03-12 | 2 | 0 | |
32443 | 32443 | Sonoma | Sonoma | 97 | 2020-03-11 | 2 | 0 | |
32471 | 32471 | Sonoma | Sonoma | 97 | 2020-03-10 | 2 | 0 | |
32498 | 32498 | Sonoma | Sonoma | 97 | 2020-03-09 | 2 | 0 | |
32525 | 32525 | Sonoma | Sonoma | 97 | 2020-03-08 | 2 | 0 | |
32552 | 32552 | Sonoma | Sonoma | 97 | 2020-03-07 | 2 | 0 | |
32578 | 32578 | Sonoma | Sonoma | 97 | 2020-03-06 | 2 | 0 | |
32604 | 32604 | Sonoma | Sonoma | 97 | 2020-03-05 | 2 | 0 | |
32630 | 32630 | Sonoma | Sonoma | 97 | 2020-03-04 | 2 | 0 | |
32656 | 32656 | Sonoma | Sonoma | 97 | 2020-03-03 | 1 | 0 | |
32682 | 32682 | Sonoma | Sonoma | 97 | 2020-03-02 | 1 | 0 | |
32708 | 32708 | Sonoma | Sonoma | 97 | 2020-03-01 | 0 | 0 | |
32733 | 32733 | Sonoma | Sonoma | 97 | 2020-02-29 | 0 | 0 | |
32758 | 32758 | Sonoma | Sonoma | 97 | 2020-02-28 | 0 | 0 | |
32791 | 32791 | Sonoma | Sonoma | 97 | 2020-02-26 | 0 | 0 | |
32839 | 32839 | Sonoma | Sonoma | 97 | 2020-02-21 | 0 | 0 | |
32863 | 32863 | Sonoma | Sonoma | 97 | 2020-02-20 | 0 | 0 | |
32955 | 32955 | Sonoma | Sonoma | 97 | 2020-02-02 | 0 | 0 | |
32982 | 32982 | Sonoma | Sonoma | 97 | 2020-01-31 | 0 | 0 | |
33018 | 33018 | Sonoma | Sonoma | 97 | 2020-01-26 | 0 | 0 | |
31125 | 31125 | Sonoma | Sonoma | 97 | 2020-04-09 | 142 | 1 | |
31181 | 31181 | Sonoma | Sonoma | 97 | 2020-04-08 | 136 | 1 | |
31237 | 31237 | Sonoma | Sonoma | 97 | 2020-04-07 | 120 | 1 | |
31293 | 31293 | Sonoma | Sonoma | 97 | 2020-04-06 | 115 | 1 | |
31349 | 31349 | Sonoma | Sonoma | 97 | 2020-04-05 | 107 | 1 | |
31404 | 31404 | Sonoma | Sonoma | 97 | 2020-04-04 | 107 | 1 | |
31459 | 31459 | Sonoma | Sonoma | 97 | 2020-04-03 | 105 | 1 | |
31514 | 31514 | Sonoma | Sonoma | 97 | 2020-04-02 | 95 | 1 | |
31568 | 31568 | Sonoma | Sonoma | 97 | 2020-04-01 | 91 | 1 | |
31622 | 31622 | Sonoma | Sonoma | 97 | 2020-03-31 | 85 | 1 | |
31674 | 31674 | Sonoma | Sonoma | 97 | 2020-03-30 | 73 | 1 | |
31725 | 31725 | Sonoma | Sonoma | 97 | 2020-03-29 | 58 | 1 | |
31775 | 31775 | Sonoma | Sonoma | 97 | 2020-03-28 | 54 | 1 | TRUE |
31825 | 31825 | Sonoma | Sonoma | 97 | 2020-03-27 | 54 | 1 | |
31872 | 31872 | Sonoma | Sonoma | 97 | 2020-03-26 | 49 | 1 | |
31919 | 31919 | Sonoma | Sonoma | 97 | 2020-03-25 | 39 | 1 | |
31965 | 31965 | Sonoma | Sonoma | 97 | 2020-03-24 | 34 | 1 | |
32010 | 32010 | Sonoma | Sonoma | 97 | 2020-03-23 | 29 | 1 | |
32055 | 32055 | Sonoma | Sonoma | 97 | 2020-03-22 | 27 | 1 | |
32098 | 32098 | Sonoma | Sonoma | 97 | 2020-03-21 | 24 | 1 | |
32138 | 32138 | Sonoma | Sonoma | 97 | 2020-03-20 | 22 | 1 | |
29820 | 29820 | Sonoma | Sonoma | 97 | 2020-05-02 | 252 | 2 | |
29881 | 29881 | Sonoma | Sonoma | 97 | 2020-05-01 | 248 | 2 | |
29942 | 29942 | Sonoma | Sonoma | 97 | 2020-04-30 | 244 | 2 | |
30003 | 30003 | Sonoma | Sonoma | 97 | 2020-04-29 | 232 | 2 | |
30061 | 30061 | Sonoma | Sonoma | 97 | 2020-04-28 | 228 | 2 | |
30117 | 30117 | Sonoma | Sonoma | 97 | 2020-04-27 | 222 | 2 | |
30173 | 30173 | Sonoma | Sonoma | 97 | 2020-04-26 | 220 | 2 | |
30229 | 30229 | Sonoma | Sonoma | 97 | 2020-04-25 | 218 | 2 | |
30285 | 30285 | Sonoma | Sonoma | 97 | 2020-04-24 | 217 | 2 | |
30341 | 30341 | Sonoma | Sonoma | 97 | 2020-04-23 | 216 | 2 | |
30397 | 30397 | Sonoma | Sonoma | 97 | 2020-04-22 | 194 | 2 | |
30453 | 30453 | Sonoma | Sonoma | 97 | 2020-04-21 | 192 | 2 | |
30509 | 30509 | Sonoma | Sonoma | 97 | 2020-04-20 | 182 | 2 | |
30565 | 30565 | Sonoma | Sonoma | 97 | 2020-04-19 | 181 | 2 | |
30621 | 30621 | Sonoma | Sonoma | 97 | 2020-04-18 | 180 | 2 | |
30677 | 30677 | Sonoma | Sonoma | 97 | 2020-04-17 | 180 | 2 | |
30733 | 30733 | Sonoma | Sonoma | 97 | 2020-04-16 | 172 | 2 | |
30789 | 30789 | Sonoma | Sonoma | 97 | 2020-04-15 | 163 | 2 | |
30845 | 30845 | Sonoma | Sonoma | 97 | 2020-04-14 | 160 | 2 | |
30901 | 30901 | Sonoma | Sonoma | 97 | 2020-04-13 | 152 | 2 | |
30957 | 30957 | Sonoma | Sonoma | 97 | 2020-04-12 | 147 | 2 | |
31013 | 31013 | Sonoma | Sonoma | 97 | 2020-04-11 | 145 | 2 | TRUE |
31069 | 31069 | Sonoma | Sonoma | 97 | 2020-04-10 | 145 | 2 | |
29332 | 29332 | Sonoma | Sonoma | 97 | 2020-05-10 | 309 | 3 | |
29393 | 29393 | Sonoma | Sonoma | 97 | 2020-05-09 | 309 | 3 | |
29454 | 29454 | Sonoma | Sonoma | 97 | 2020-05-08 | 300 | 3 | |
29515 | 29515 | Sonoma | Sonoma | 97 | 2020-05-07 | 292 | 3 | |
29576 | 29576 | Sonoma | Sonoma | 97 | 2020-05-06 | 286 | 3 | |
29637 | 29637 | Sonoma | Sonoma | 97 | 2020-05-05 | 261 | 3 | TRUE |
29698 | 29698 | Sonoma | Sonoma | 97 | 2020-05-04 | 261 | 3 | |
29759 | 29759 | Sonoma | Sonoma | 97 | 2020-05-03 | 257 | 3 | |
26831 | 26831 | Sonoma | Sonoma | 97 | 2020-06-20 | 835 | 4 | TRUE |
26892 | 26892 | Sonoma | Sonoma | 97 | 2020-06-19 | 835 | 4 | |
26953 | 26953 | Sonoma | Sonoma | 97 | 2020-06-18 | 822 | 4 | |
27014 | 27014 | Sonoma | Sonoma | 97 | 2020-06-17 | 803 | 4 | |
27075 | 27075 | Sonoma | Sonoma | 97 | 2020-06-16 | 765 | 4 | |
27136 | 27136 | Sonoma | Sonoma | 97 | 2020-06-15 | 765 | 4 | |
27197 | 27197 | Sonoma | Sonoma | 97 | 2020-06-14 | 758 | 4 | |
27258 | 27258 | Sonoma | Sonoma | 97 | 2020-06-13 | 752 | 4 | |
27319 | 27319 | Sonoma | Sonoma | 97 | 2020-06-12 | 722 | 4 | |
27380 | 27380 | Sonoma | Sonoma | 97 | 2020-06-11 | 701 | 4 | |
27441 | 27441 | Sonoma | Sonoma | 97 | 2020-06-10 | 671 | 4 | |
27502 | 27502 | Sonoma | Sonoma | 97 | 2020-06-09 | 671 | 4 | |
27563 | 27563 | Sonoma | Sonoma | 97 | 2020-06-08 | 653 | 4 | |
27624 | 27624 | Sonoma | Sonoma | 97 | 2020-06-07 | 642 | 4 | |
27685 | 27685 | Sonoma | Sonoma | 97 | 2020-06-06 | 624 | 4 | TRUE |
27746 | 27746 | Sonoma | Sonoma | 97 | 2020-06-05 | 624 | 4 | |
27807 | 27807 | Sonoma | Sonoma | 97 | 2020-06-04 | 610 | 4 | |
27868 | 27868 | Sonoma | Sonoma | 97 | 2020-06-03 | 593 | 4 | |
27929 | 27929 | Sonoma | Sonoma | 97 | 2020-06-02 | 579 | 4 | |
27990 | 27990 | Sonoma | Sonoma | 97 | 2020-06-01 | 566 | 4 | |
28051 | 28051 | Sonoma | Sonoma | 97 | 2020-05-31 | 553 | 4 |
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 );