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" and fips = 97 sorted by date
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 |
---|---|---|---|---|---|---|---|---|
31359 | 31359 | 2020-01-26 | Sonoma | 97 | 0 | 0 | ||
31325 | 31325 | 2020-01-31 | Sonoma | 97 | 0 | 0 | 0 | 0 |
31300 | 31300 | 2020-02-02 | Sonoma | 97 | 0 | 0 | 0 | 0 |
31210 | 31210 | 2020-02-20 | Sonoma | 97 | 0 | 0 | 0 | 0 |
31188 | 31188 | 2020-02-21 | Sonoma | 97 | 0 | 0 | 0 | 0 |
31142 | 31142 | 2020-02-26 | Sonoma | 97 | 0 | 0 | 0 | 0 |
31111 | 31111 | 2020-02-28 | Sonoma | 97 | 0 | 0 | 0 | 0 |
31088 | 31088 | 2020-02-29 | Sonoma | 97 | 0 | 0 | 0 | 0 |
31065 | 31065 | 2020-03-01 | Sonoma | 97 | 0 | 0 | 0 | 0 |
31041 | 31041 | 2020-03-02 | Sonoma | 97 | 1 | 0 | 1 | 0 |
31017 | 31017 | 2020-03-03 | Sonoma | 97 | 1 | 0 | 0 | 0 |
30993 | 30993 | 2020-03-04 | Sonoma | 97 | 2 | 0 | 1 | 0 |
30969 | 30969 | 2020-03-05 | Sonoma | 97 | 2 | 0 | 0 | 0 |
30945 | 30945 | 2020-03-06 | Sonoma | 97 | 2 | 0 | 0 | 0 |
30921 | 30921 | 2020-03-07 | Sonoma | 97 | 2 | 0 | 0 | 0 |
30896 | 30896 | 2020-03-08 | Sonoma | 97 | 2 | 0 | 0 | 0 |
30871 | 30871 | 2020-03-09 | Sonoma | 97 | 2 | 0 | 0 | 0 |
30846 | 30846 | 2020-03-10 | Sonoma | 97 | 2 | 0 | 0 | 0 |
30820 | 30820 | 2020-03-11 | Sonoma | 97 | 2 | 0 | 0 | 0 |
30793 | 30793 | 2020-03-12 | Sonoma | 97 | 2 | 0 | 0 | 0 |
30766 | 30766 | 2020-03-13 | Sonoma | 97 | 2 | 0 | 0 | 0 |
30738 | 30738 | 2020-03-14 | Sonoma | 97 | 4 | 0 | 2 | 0 |
30709 | 30709 | 2020-03-15 | Sonoma | 97 | 4 | 0 | 0 | 0 |
30678 | 30678 | 2020-03-16 | Sonoma | 97 | 7 | 0 | 3 | 0 |
30646 | 30646 | 2020-03-17 | Sonoma | 97 | 9 | 0 | 2 | 0 |
30612 | 30612 | 2020-03-18 | Sonoma | 97 | 9 | 0 | 0 | 0 |
30577 | 30577 | 2020-03-19 | Sonoma | 97 | 11 | 0 | 2 | 0 |
30542 | 30542 | 2020-03-20 | Sonoma | 97 | 22 | 1 | 11 | 1 |
30505 | 30505 | 2020-03-21 | Sonoma | 97 | 24 | 1 | 2 | 0 |
30465 | 30465 | 2020-03-22 | Sonoma | 97 | 27 | 1 | 3 | 0 |
30423 | 30423 | 2020-03-23 | Sonoma | 97 | 29 | 1 | 2 | 0 |
30381 | 30381 | 2020-03-24 | Sonoma | 97 | 34 | 1 | 5 | 0 |
30338 | 30338 | 2020-03-25 | Sonoma | 97 | 39 | 1 | 5 | 0 |
30294 | 30294 | 2020-03-26 | Sonoma | 97 | 49 | 1 | 10 | 0 |
30250 | 30250 | 2020-03-27 | Sonoma | 97 | 54 | 1 | 5 | 0 |
30203 | 30203 | 2020-03-28 | Sonoma | 97 | 54 | 1 | 0 | 0 |
30156 | 30156 | 2020-03-29 | Sonoma | 97 | 58 | 1 | 4 | 0 |
30108 | 30108 | 2020-03-30 | Sonoma | 97 | 73 | 1 | 15 | 0 |
30059 | 30059 | 2020-03-31 | Sonoma | 97 | 85 | 1 | 12 | 0 |
30008 | 30008 | 2020-04-01 | Sonoma | 97 | 91 | 1 | 6 | 0 |
29957 | 29957 | 2020-04-02 | Sonoma | 97 | 95 | 1 | 4 | 0 |
29905 | 29905 | 2020-04-03 | Sonoma | 97 | 105 | 1 | 10 | 0 |
29853 | 29853 | 2020-04-04 | Sonoma | 97 | 107 | 1 | 2 | 0 |
29801 | 29801 | 2020-04-05 | Sonoma | 97 | 107 | 1 | 0 | 0 |
29748 | 29748 | 2020-04-06 | Sonoma | 97 | 115 | 1 | 8 | 0 |
29695 | 29695 | 2020-04-07 | Sonoma | 97 | 120 | 1 | 5 | 0 |
29642 | 29642 | 2020-04-08 | Sonoma | 97 | 136 | 1 | 16 | 0 |
29589 | 29589 | 2020-04-09 | Sonoma | 97 | 142 | 1 | 6 | 0 |
29536 | 29536 | 2020-04-10 | Sonoma | 97 | 145 | 2 | 3 | 1 |
29483 | 29483 | 2020-04-11 | Sonoma | 97 | 145 | 2 | 0 | 0 |
29430 | 29430 | 2020-04-12 | Sonoma | 97 | 147 | 2 | 2 | 0 |
29377 | 29377 | 2020-04-13 | Sonoma | 97 | 152 | 2 | 5 | 0 |
29324 | 29324 | 2020-04-14 | Sonoma | 97 | 160 | 2 | 8 | 0 |
29271 | 29271 | 2020-04-15 | Sonoma | 97 | 163 | 2 | 3 | 0 |
29218 | 29218 | 2020-04-16 | Sonoma | 97 | 172 | 2 | 9 | 0 |
29165 | 29165 | 2020-04-17 | Sonoma | 97 | 180 | 2 | 8 | 0 |
29112 | 29112 | 2020-04-18 | Sonoma | 97 | 180 | 2 | 0 | 0 |
29059 | 29059 | 2020-04-19 | Sonoma | 97 | 181 | 2 | 1 | 0 |
29006 | 29006 | 2020-04-20 | Sonoma | 97 | 182 | 2 | 1 | 0 |
28953 | 28953 | 2020-04-21 | Sonoma | 97 | 192 | 2 | 10 | 0 |
28900 | 28900 | 2020-04-22 | Sonoma | 97 | 194 | 2 | 2 | 0 |
28847 | 28847 | 2020-04-23 | Sonoma | 97 | 216 | 2 | 22 | 0 |
28794 | 28794 | 2020-04-24 | Sonoma | 97 | 217 | 2 | 1 | 0 |
28741 | 28741 | 2020-04-25 | Sonoma | 97 | 218 | 2 | 1 | 0 |
28688 | 28688 | 2020-04-26 | Sonoma | 97 | 220 | 2 | 2 | 0 |
28635 | 28635 | 2020-04-27 | Sonoma | 97 | 222 | 2 | 2 | 0 |
28582 | 28582 | 2020-04-28 | Sonoma | 97 | 228 | 2 | 6 | 0 |
28527 | 28527 | 2020-04-29 | Sonoma | 97 | 232 | 2 | 4 | 0 |
28469 | 28469 | 2020-04-30 | Sonoma | 97 | 244 | 2 | 12 | 0 |
28411 | 28411 | 2020-05-01 | Sonoma | 97 | 248 | 2 | 4 | 0 |
28353 | 28353 | 2020-05-02 | Sonoma | 97 | 252 | 2 | 4 | 0 |
28295 | 28295 | 2020-05-03 | Sonoma | 97 | 257 | 3 | 5 | 1 |
28237 | 28237 | 2020-05-04 | Sonoma | 97 | 261 | 3 | 4 | 0 |
28179 | 28179 | 2020-05-05 | Sonoma | 97 | 261 | 3 | 0 | 0 |
28121 | 28121 | 2020-05-06 | Sonoma | 97 | 286 | 3 | 25 | 0 |
28063 | 28063 | 2020-05-07 | Sonoma | 97 | 292 | 3 | 6 | 0 |
28005 | 28005 | 2020-05-08 | Sonoma | 97 | 300 | 3 | 8 | 0 |
27947 | 27947 | 2020-05-09 | Sonoma | 97 | 309 | 3 | 9 | 0 |
27889 | 27889 | 2020-05-10 | Sonoma | 97 | 309 | 3 | 0 | 0 |
27831 | 27831 | 2020-05-11 | Sonoma | 97 | 312 | 4 | 3 | 1 |
27773 | 27773 | 2020-05-12 | Sonoma | 97 | 333 | 4 | 21 | 0 |
27715 | 27715 | 2020-05-13 | Sonoma | 97 | 337 | 4 | 4 | 0 |
27657 | 27657 | 2020-05-14 | Sonoma | 97 | 351 | 4 | 14 | 0 |
27599 | 27599 | 2020-05-15 | Sonoma | 97 | 364 | 4 | 13 | 0 |
27541 | 27541 | 2020-05-16 | Sonoma | 97 | 373 | 4 | 9 | 0 |
27483 | 27483 | 2020-05-17 | Sonoma | 97 | 373 | 4 | 0 | 0 |
27425 | 27425 | 2020-05-18 | Sonoma | 97 | 387 | 4 | 14 | 0 |
27367 | 27367 | 2020-05-19 | Sonoma | 97 | 411 | 4 | 24 | 0 |
27309 | 27309 | 2020-05-20 | Sonoma | 97 | 433 | 4 | 22 | 0 |
27251 | 27251 | 2020-05-21 | Sonoma | 97 | 444 | 4 | 11 | 0 |
27193 | 27193 | 2020-05-22 | Sonoma | 97 | 467 | 4 | 23 | 0 |
27135 | 27135 | 2020-05-23 | Sonoma | 97 | 482 | 4 | 15 | 0 |
27077 | 27077 | 2020-05-24 | Sonoma | 97 | 500 | 4 | 18 | 0 |
27019 | 27019 | 2020-05-25 | Sonoma | 97 | 515 | 4 | 15 | 0 |
26961 | 26961 | 2020-05-26 | Sonoma | 97 | 524 | 4 | 9 | 0 |
26903 | 26903 | 2020-05-27 | Sonoma | 97 | 530 | 4 | 6 | 0 |
26845 | 26845 | 2020-05-28 | Sonoma | 97 | 531 | 4 | 1 | 0 |
26787 | 26787 | 2020-05-29 | Sonoma | 97 | 548 | 4 | 17 | 0 |
26729 | 26729 | 2020-05-30 | Sonoma | 97 | 548 | 4 | 0 | 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 );