latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
559 rows where county = "Sonoma" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: new_deaths, date (date)
Link | rowid | date | county | fips | confirmed_cases | deaths ▼ | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
30577 | 30577 | 2020-03-19 | Sonoma | 97 | 11 | 0 | 2 | 0 |
30612 | 30612 | 2020-03-18 | Sonoma | 97 | 9 | 0 | 0 | 0 |
30646 | 30646 | 2020-03-17 | Sonoma | 97 | 9 | 0 | 2 | 0 |
30678 | 30678 | 2020-03-16 | Sonoma | 97 | 7 | 0 | 3 | 0 |
30709 | 30709 | 2020-03-15 | Sonoma | 97 | 4 | 0 | 0 | 0 |
30738 | 30738 | 2020-03-14 | Sonoma | 97 | 4 | 0 | 2 | 0 |
30766 | 30766 | 2020-03-13 | Sonoma | 97 | 2 | 0 | 0 | 0 |
30793 | 30793 | 2020-03-12 | Sonoma | 97 | 2 | 0 | 0 | 0 |
30820 | 30820 | 2020-03-11 | Sonoma | 97 | 2 | 0 | 0 | 0 |
30846 | 30846 | 2020-03-10 | Sonoma | 97 | 2 | 0 | 0 | 0 |
30871 | 30871 | 2020-03-09 | Sonoma | 97 | 2 | 0 | 0 | 0 |
30896 | 30896 | 2020-03-08 | Sonoma | 97 | 2 | 0 | 0 | 0 |
30921 | 30921 | 2020-03-07 | Sonoma | 97 | 2 | 0 | 0 | 0 |
30945 | 30945 | 2020-03-06 | Sonoma | 97 | 2 | 0 | 0 | 0 |
30969 | 30969 | 2020-03-05 | Sonoma | 97 | 2 | 0 | 0 | 0 |
30993 | 30993 | 2020-03-04 | Sonoma | 97 | 2 | 0 | 1 | 0 |
31017 | 31017 | 2020-03-03 | Sonoma | 97 | 1 | 0 | 0 | 0 |
31041 | 31041 | 2020-03-02 | Sonoma | 97 | 1 | 0 | 1 | 0 |
31065 | 31065 | 2020-03-01 | Sonoma | 97 | 0 | 0 | 0 | 0 |
31088 | 31088 | 2020-02-29 | Sonoma | 97 | 0 | 0 | 0 | 0 |
31111 | 31111 | 2020-02-28 | Sonoma | 97 | 0 | 0 | 0 | 0 |
31142 | 31142 | 2020-02-26 | Sonoma | 97 | 0 | 0 | 0 | 0 |
31188 | 31188 | 2020-02-21 | Sonoma | 97 | 0 | 0 | 0 | 0 |
31210 | 31210 | 2020-02-20 | Sonoma | 97 | 0 | 0 | 0 | 0 |
31300 | 31300 | 2020-02-02 | Sonoma | 97 | 0 | 0 | 0 | 0 |
31325 | 31325 | 2020-01-31 | Sonoma | 97 | 0 | 0 | 0 | 0 |
31359 | 31359 | 2020-01-26 | Sonoma | 97 | 0 | 0 | ||
29589 | 29589 | 2020-04-09 | Sonoma | 97 | 142 | 1 | 6 | 0 |
29642 | 29642 | 2020-04-08 | Sonoma | 97 | 136 | 1 | 16 | 0 |
29695 | 29695 | 2020-04-07 | Sonoma | 97 | 120 | 1 | 5 | 0 |
29748 | 29748 | 2020-04-06 | Sonoma | 97 | 115 | 1 | 8 | 0 |
29801 | 29801 | 2020-04-05 | Sonoma | 97 | 107 | 1 | 0 | 0 |
29853 | 29853 | 2020-04-04 | Sonoma | 97 | 107 | 1 | 2 | 0 |
29905 | 29905 | 2020-04-03 | Sonoma | 97 | 105 | 1 | 10 | 0 |
29957 | 29957 | 2020-04-02 | Sonoma | 97 | 95 | 1 | 4 | 0 |
30008 | 30008 | 2020-04-01 | Sonoma | 97 | 91 | 1 | 6 | 0 |
30059 | 30059 | 2020-03-31 | Sonoma | 97 | 85 | 1 | 12 | 0 |
30108 | 30108 | 2020-03-30 | Sonoma | 97 | 73 | 1 | 15 | 0 |
30156 | 30156 | 2020-03-29 | Sonoma | 97 | 58 | 1 | 4 | 0 |
30203 | 30203 | 2020-03-28 | Sonoma | 97 | 54 | 1 | 0 | 0 |
30250 | 30250 | 2020-03-27 | Sonoma | 97 | 54 | 1 | 5 | 0 |
30294 | 30294 | 2020-03-26 | Sonoma | 97 | 49 | 1 | 10 | 0 |
30338 | 30338 | 2020-03-25 | Sonoma | 97 | 39 | 1 | 5 | 0 |
30381 | 30381 | 2020-03-24 | Sonoma | 97 | 34 | 1 | 5 | 0 |
30423 | 30423 | 2020-03-23 | Sonoma | 97 | 29 | 1 | 2 | 0 |
30465 | 30465 | 2020-03-22 | Sonoma | 97 | 27 | 1 | 3 | 0 |
30505 | 30505 | 2020-03-21 | Sonoma | 97 | 24 | 1 | 2 | 0 |
30542 | 30542 | 2020-03-20 | Sonoma | 97 | 22 | 1 | 11 | 1 |
28353 | 28353 | 2020-05-02 | Sonoma | 97 | 252 | 2 | 4 | 0 |
28411 | 28411 | 2020-05-01 | Sonoma | 97 | 248 | 2 | 4 | 0 |
28469 | 28469 | 2020-04-30 | Sonoma | 97 | 244 | 2 | 12 | 0 |
28527 | 28527 | 2020-04-29 | Sonoma | 97 | 232 | 2 | 4 | 0 |
28582 | 28582 | 2020-04-28 | Sonoma | 97 | 228 | 2 | 6 | 0 |
28635 | 28635 | 2020-04-27 | Sonoma | 97 | 222 | 2 | 2 | 0 |
28688 | 28688 | 2020-04-26 | Sonoma | 97 | 220 | 2 | 2 | 0 |
28741 | 28741 | 2020-04-25 | Sonoma | 97 | 218 | 2 | 1 | 0 |
28794 | 28794 | 2020-04-24 | Sonoma | 97 | 217 | 2 | 1 | 0 |
28847 | 28847 | 2020-04-23 | Sonoma | 97 | 216 | 2 | 22 | 0 |
28900 | 28900 | 2020-04-22 | Sonoma | 97 | 194 | 2 | 2 | 0 |
28953 | 28953 | 2020-04-21 | Sonoma | 97 | 192 | 2 | 10 | 0 |
29006 | 29006 | 2020-04-20 | Sonoma | 97 | 182 | 2 | 1 | 0 |
29059 | 29059 | 2020-04-19 | Sonoma | 97 | 181 | 2 | 1 | 0 |
29112 | 29112 | 2020-04-18 | Sonoma | 97 | 180 | 2 | 0 | 0 |
29165 | 29165 | 2020-04-17 | Sonoma | 97 | 180 | 2 | 8 | 0 |
29218 | 29218 | 2020-04-16 | Sonoma | 97 | 172 | 2 | 9 | 0 |
29271 | 29271 | 2020-04-15 | Sonoma | 97 | 163 | 2 | 3 | 0 |
29324 | 29324 | 2020-04-14 | Sonoma | 97 | 160 | 2 | 8 | 0 |
29377 | 29377 | 2020-04-13 | Sonoma | 97 | 152 | 2 | 5 | 0 |
29430 | 29430 | 2020-04-12 | Sonoma | 97 | 147 | 2 | 2 | 0 |
29483 | 29483 | 2020-04-11 | Sonoma | 97 | 145 | 2 | 0 | 0 |
29536 | 29536 | 2020-04-10 | Sonoma | 97 | 145 | 2 | 3 | 1 |
27889 | 27889 | 2020-05-10 | Sonoma | 97 | 309 | 3 | 0 | 0 |
27947 | 27947 | 2020-05-09 | Sonoma | 97 | 309 | 3 | 9 | 0 |
28005 | 28005 | 2020-05-08 | Sonoma | 97 | 300 | 3 | 8 | 0 |
28063 | 28063 | 2020-05-07 | Sonoma | 97 | 292 | 3 | 6 | 0 |
28121 | 28121 | 2020-05-06 | Sonoma | 97 | 286 | 3 | 25 | 0 |
28179 | 28179 | 2020-05-05 | Sonoma | 97 | 261 | 3 | 0 | 0 |
28237 | 28237 | 2020-05-04 | Sonoma | 97 | 261 | 3 | 4 | 0 |
28295 | 28295 | 2020-05-03 | Sonoma | 97 | 257 | 3 | 5 | 1 |
25511 | 25511 | 2020-06-20 | Sonoma | 97 | 835 | 4 | 0 | 0 |
25569 | 25569 | 2020-06-19 | Sonoma | 97 | 835 | 4 | 13 | 0 |
25627 | 25627 | 2020-06-18 | Sonoma | 97 | 822 | 4 | 19 | 0 |
25685 | 25685 | 2020-06-17 | Sonoma | 97 | 803 | 4 | 38 | 0 |
25743 | 25743 | 2020-06-16 | Sonoma | 97 | 765 | 4 | 0 | 0 |
25801 | 25801 | 2020-06-15 | Sonoma | 97 | 765 | 4 | 7 | 0 |
25859 | 25859 | 2020-06-14 | Sonoma | 97 | 758 | 4 | 6 | 0 |
25917 | 25917 | 2020-06-13 | Sonoma | 97 | 752 | 4 | 30 | 0 |
25975 | 25975 | 2020-06-12 | Sonoma | 97 | 722 | 4 | 21 | 0 |
26033 | 26033 | 2020-06-11 | Sonoma | 97 | 701 | 4 | 30 | 0 |
26091 | 26091 | 2020-06-10 | Sonoma | 97 | 671 | 4 | 0 | 0 |
26149 | 26149 | 2020-06-09 | Sonoma | 97 | 671 | 4 | 18 | 0 |
26207 | 26207 | 2020-06-08 | Sonoma | 97 | 653 | 4 | 11 | 0 |
26265 | 26265 | 2020-06-07 | Sonoma | 97 | 642 | 4 | 18 | 0 |
26323 | 26323 | 2020-06-06 | Sonoma | 97 | 624 | 4 | 0 | 0 |
26381 | 26381 | 2020-06-05 | Sonoma | 97 | 624 | 4 | 14 | 0 |
26439 | 26439 | 2020-06-04 | Sonoma | 97 | 610 | 4 | 17 | 0 |
26497 | 26497 | 2020-06-03 | Sonoma | 97 | 593 | 4 | 14 | 0 |
26555 | 26555 | 2020-06-02 | Sonoma | 97 | 579 | 4 | 13 | 0 |
26613 | 26613 | 2020-06-01 | Sonoma | 97 | 566 | 4 | 13 | 0 |
26671 | 26671 | 2020-05-31 | Sonoma | 97 | 553 | 4 | 5 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_county_totals] ( [date] TEXT, [county] TEXT, [fips] INTEGER, [confirmed_cases] INTEGER, [deaths] INTEGER, [new_confirmed_cases] INTEGER, [new_deaths] INTEGER );