latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
559 rows where agency = "Sonoma" sorted by date
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 |
---|---|---|---|---|---|---|---|---|
33018 | 33018 | Sonoma | Sonoma | 97 | 2020-01-26 | 0 | 0 | |
32982 | 32982 | Sonoma | Sonoma | 97 | 2020-01-31 | 0 | 0 | |
32955 | 32955 | Sonoma | Sonoma | 97 | 2020-02-02 | 0 | 0 | |
32863 | 32863 | Sonoma | Sonoma | 97 | 2020-02-20 | 0 | 0 | |
32839 | 32839 | Sonoma | Sonoma | 97 | 2020-02-21 | 0 | 0 | |
32791 | 32791 | Sonoma | Sonoma | 97 | 2020-02-26 | 0 | 0 | |
32758 | 32758 | Sonoma | Sonoma | 97 | 2020-02-28 | 0 | 0 | |
32733 | 32733 | Sonoma | Sonoma | 97 | 2020-02-29 | 0 | 0 | |
32708 | 32708 | Sonoma | Sonoma | 97 | 2020-03-01 | 0 | 0 | |
32682 | 32682 | Sonoma | Sonoma | 97 | 2020-03-02 | 1 | 0 | |
32656 | 32656 | Sonoma | Sonoma | 97 | 2020-03-03 | 1 | 0 | |
32630 | 32630 | Sonoma | Sonoma | 97 | 2020-03-04 | 2 | 0 | |
32604 | 32604 | Sonoma | Sonoma | 97 | 2020-03-05 | 2 | 0 | |
32578 | 32578 | Sonoma | Sonoma | 97 | 2020-03-06 | 2 | 0 | |
32552 | 32552 | Sonoma | Sonoma | 97 | 2020-03-07 | 2 | 0 | |
32525 | 32525 | Sonoma | Sonoma | 97 | 2020-03-08 | 2 | 0 | |
32498 | 32498 | Sonoma | Sonoma | 97 | 2020-03-09 | 2 | 0 | |
32471 | 32471 | Sonoma | Sonoma | 97 | 2020-03-10 | 2 | 0 | |
32443 | 32443 | Sonoma | Sonoma | 97 | 2020-03-11 | 2 | 0 | |
32413 | 32413 | Sonoma | Sonoma | 97 | 2020-03-12 | 2 | 0 | |
32383 | 32383 | Sonoma | Sonoma | 97 | 2020-03-13 | 2 | 0 | |
32352 | 32352 | Sonoma | Sonoma | 97 | 2020-03-14 | 4 | 0 | |
32320 | 32320 | Sonoma | Sonoma | 97 | 2020-03-15 | 4 | 0 | |
32286 | 32286 | Sonoma | Sonoma | 97 | 2020-03-16 | 7 | 0 | |
32251 | 32251 | Sonoma | Sonoma | 97 | 2020-03-17 | 9 | 0 | |
32214 | 32214 | Sonoma | Sonoma | 97 | 2020-03-18 | 9 | 0 | |
32176 | 32176 | Sonoma | Sonoma | 97 | 2020-03-19 | 11 | 0 | |
32138 | 32138 | Sonoma | Sonoma | 97 | 2020-03-20 | 22 | 1 | |
32098 | 32098 | Sonoma | Sonoma | 97 | 2020-03-21 | 24 | 1 | |
32055 | 32055 | Sonoma | Sonoma | 97 | 2020-03-22 | 27 | 1 | |
32010 | 32010 | Sonoma | Sonoma | 97 | 2020-03-23 | 29 | 1 | |
31965 | 31965 | Sonoma | Sonoma | 97 | 2020-03-24 | 34 | 1 | |
31919 | 31919 | Sonoma | Sonoma | 97 | 2020-03-25 | 39 | 1 | |
31872 | 31872 | Sonoma | Sonoma | 97 | 2020-03-26 | 49 | 1 | |
31825 | 31825 | Sonoma | Sonoma | 97 | 2020-03-27 | 54 | 1 | |
31775 | 31775 | Sonoma | Sonoma | 97 | 2020-03-28 | 54 | 1 | TRUE |
31725 | 31725 | Sonoma | Sonoma | 97 | 2020-03-29 | 58 | 1 | |
31674 | 31674 | Sonoma | Sonoma | 97 | 2020-03-30 | 73 | 1 | |
31622 | 31622 | Sonoma | Sonoma | 97 | 2020-03-31 | 85 | 1 | |
31568 | 31568 | Sonoma | Sonoma | 97 | 2020-04-01 | 91 | 1 | |
31514 | 31514 | Sonoma | Sonoma | 97 | 2020-04-02 | 95 | 1 | |
31459 | 31459 | Sonoma | Sonoma | 97 | 2020-04-03 | 105 | 1 | |
31404 | 31404 | Sonoma | Sonoma | 97 | 2020-04-04 | 107 | 1 | |
31349 | 31349 | Sonoma | Sonoma | 97 | 2020-04-05 | 107 | 1 | |
31293 | 31293 | Sonoma | Sonoma | 97 | 2020-04-06 | 115 | 1 | |
31237 | 31237 | Sonoma | Sonoma | 97 | 2020-04-07 | 120 | 1 | |
31181 | 31181 | Sonoma | Sonoma | 97 | 2020-04-08 | 136 | 1 | |
31125 | 31125 | Sonoma | Sonoma | 97 | 2020-04-09 | 142 | 1 | |
31069 | 31069 | Sonoma | Sonoma | 97 | 2020-04-10 | 145 | 2 | |
31013 | 31013 | Sonoma | Sonoma | 97 | 2020-04-11 | 145 | 2 | TRUE |
30957 | 30957 | Sonoma | Sonoma | 97 | 2020-04-12 | 147 | 2 | |
30901 | 30901 | Sonoma | Sonoma | 97 | 2020-04-13 | 152 | 2 | |
30845 | 30845 | Sonoma | Sonoma | 97 | 2020-04-14 | 160 | 2 | |
30789 | 30789 | Sonoma | Sonoma | 97 | 2020-04-15 | 163 | 2 | |
30733 | 30733 | Sonoma | Sonoma | 97 | 2020-04-16 | 172 | 2 | |
30677 | 30677 | Sonoma | Sonoma | 97 | 2020-04-17 | 180 | 2 | |
30621 | 30621 | Sonoma | Sonoma | 97 | 2020-04-18 | 180 | 2 | |
30565 | 30565 | Sonoma | Sonoma | 97 | 2020-04-19 | 181 | 2 | |
30509 | 30509 | Sonoma | Sonoma | 97 | 2020-04-20 | 182 | 2 | |
30453 | 30453 | Sonoma | Sonoma | 97 | 2020-04-21 | 192 | 2 | |
30397 | 30397 | Sonoma | Sonoma | 97 | 2020-04-22 | 194 | 2 | |
30341 | 30341 | Sonoma | Sonoma | 97 | 2020-04-23 | 216 | 2 | |
30285 | 30285 | Sonoma | Sonoma | 97 | 2020-04-24 | 217 | 2 | |
30229 | 30229 | Sonoma | Sonoma | 97 | 2020-04-25 | 218 | 2 | |
30173 | 30173 | Sonoma | Sonoma | 97 | 2020-04-26 | 220 | 2 | |
30117 | 30117 | Sonoma | Sonoma | 97 | 2020-04-27 | 222 | 2 | |
30061 | 30061 | Sonoma | Sonoma | 97 | 2020-04-28 | 228 | 2 | |
30003 | 30003 | Sonoma | Sonoma | 97 | 2020-04-29 | 232 | 2 | |
29942 | 29942 | Sonoma | Sonoma | 97 | 2020-04-30 | 244 | 2 | |
29881 | 29881 | Sonoma | Sonoma | 97 | 2020-05-01 | 248 | 2 | |
29820 | 29820 | Sonoma | Sonoma | 97 | 2020-05-02 | 252 | 2 | |
29759 | 29759 | Sonoma | Sonoma | 97 | 2020-05-03 | 257 | 3 | |
29698 | 29698 | Sonoma | Sonoma | 97 | 2020-05-04 | 261 | 3 | |
29637 | 29637 | Sonoma | Sonoma | 97 | 2020-05-05 | 261 | 3 | TRUE |
29576 | 29576 | Sonoma | Sonoma | 97 | 2020-05-06 | 286 | 3 | |
29515 | 29515 | Sonoma | Sonoma | 97 | 2020-05-07 | 292 | 3 | |
29454 | 29454 | Sonoma | Sonoma | 97 | 2020-05-08 | 300 | 3 | |
29393 | 29393 | Sonoma | Sonoma | 97 | 2020-05-09 | 309 | 3 | |
29332 | 29332 | Sonoma | Sonoma | 97 | 2020-05-10 | 309 | 3 | |
29271 | 29271 | Sonoma | Sonoma | 97 | 2020-05-11 | 312 | 4 | |
29210 | 29210 | Sonoma | Sonoma | 97 | 2020-05-12 | 333 | 4 | |
29149 | 29149 | Sonoma | Sonoma | 97 | 2020-05-13 | 337 | 4 | |
29088 | 29088 | Sonoma | Sonoma | 97 | 2020-05-14 | 351 | 4 | |
29027 | 29027 | Sonoma | Sonoma | 97 | 2020-05-15 | 364 | 4 | |
28966 | 28966 | Sonoma | Sonoma | 97 | 2020-05-16 | 373 | 4 | |
28905 | 28905 | Sonoma | Sonoma | 97 | 2020-05-17 | 373 | 4 | TRUE |
28844 | 28844 | Sonoma | Sonoma | 97 | 2020-05-18 | 387 | 4 | |
28783 | 28783 | Sonoma | Sonoma | 97 | 2020-05-19 | 411 | 4 | |
28722 | 28722 | Sonoma | Sonoma | 97 | 2020-05-20 | 433 | 4 | |
28661 | 28661 | Sonoma | Sonoma | 97 | 2020-05-21 | 444 | 4 | |
28600 | 28600 | Sonoma | Sonoma | 97 | 2020-05-22 | 467 | 4 | |
28539 | 28539 | Sonoma | Sonoma | 97 | 2020-05-23 | 482 | 4 | |
28478 | 28478 | Sonoma | Sonoma | 97 | 2020-05-24 | 500 | 4 | |
28417 | 28417 | Sonoma | Sonoma | 97 | 2020-05-25 | 515 | 4 | |
28356 | 28356 | Sonoma | Sonoma | 97 | 2020-05-26 | 524 | 4 | |
28295 | 28295 | Sonoma | Sonoma | 97 | 2020-05-27 | 530 | 4 | |
28234 | 28234 | Sonoma | Sonoma | 97 | 2020-05-28 | 531 | 4 | TRUE |
28173 | 28173 | Sonoma | Sonoma | 97 | 2020-05-29 | 548 | 4 | |
28112 | 28112 | Sonoma | Sonoma | 97 | 2020-05-30 | 548 | 4 | TRUE |
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 );