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 new_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 ▼ |
---|---|---|---|---|---|---|---|---|
49 | 49 | 2021-09-02 | Sonoma | 97 | 37055 | 356 | 249 | 0 |
165 | 165 | 2021-08-31 | Sonoma | 97 | 36515 | 353 | 17 | 0 |
223 | 223 | 2021-08-30 | Sonoma | 97 | 36498 | 353 | 0 | 0 |
281 | 281 | 2021-08-29 | Sonoma | 97 | 36498 | 353 | 0 | 0 |
397 | 397 | 2021-08-27 | Sonoma | 97 | 36158 | 349 | 0 | 0 |
571 | 571 | 2021-08-24 | Sonoma | 97 | 35664 | 344 | 0 | 0 |
629 | 629 | 2021-08-23 | Sonoma | 97 | 35664 | 344 | 102 | 0 |
687 | 687 | 2021-08-22 | Sonoma | 97 | 35562 | 344 | 4 | 0 |
745 | 745 | 2021-08-21 | Sonoma | 97 | 35558 | 344 | 348 | 0 |
803 | 803 | 2021-08-20 | Sonoma | 97 | 35210 | 344 | 0 | 0 |
861 | 861 | 2021-08-19 | Sonoma | 97 | 35210 | 344 | 117 | 0 |
1035 | 1035 | 2021-08-16 | Sonoma | 97 | 34839 | 338 | 153 | 0 |
1093 | 1093 | 2021-08-15 | Sonoma | 97 | 34686 | 338 | 0 | 0 |
1209 | 1209 | 2021-08-13 | Sonoma | 97 | 34394 | 337 | 0 | 0 |
1267 | 1267 | 2021-08-12 | Sonoma | 97 | 34394 | 337 | 98 | 0 |
1325 | 1325 | 2021-08-11 | Sonoma | 97 | 34296 | 337 | 273 | 0 |
1383 | 1383 | 2021-08-10 | Sonoma | 97 | 34023 | 337 | 0 | 0 |
1499 | 1499 | 2021-08-08 | Sonoma | 97 | 33753 | 334 | 134 | 0 |
1557 | 1557 | 2021-08-07 | Sonoma | 97 | 33619 | 334 | 55 | 0 |
1615 | 1615 | 2021-08-06 | Sonoma | 97 | 33564 | 334 | 0 | 0 |
1731 | 1731 | 2021-08-04 | Sonoma | 97 | 33414 | 331 | 447 | 0 |
1847 | 1847 | 2021-08-02 | Sonoma | 97 | 32880 | 330 | 0 | 0 |
1905 | 1905 | 2021-08-01 | Sonoma | 97 | 32880 | 330 | 63 | 0 |
1963 | 1963 | 2021-07-31 | Sonoma | 97 | 32817 | 330 | 152 | 0 |
2021 | 2021 | 2021-07-30 | Sonoma | 97 | 32665 | 330 | 0 | 0 |
2137 | 2137 | 2021-07-28 | Sonoma | 97 | 32526 | 329 | 201 | 0 |
2195 | 2195 | 2021-07-27 | Sonoma | 97 | 32325 | 329 | 0 | 0 |
2253 | 2253 | 2021-07-26 | Sonoma | 97 | 32325 | 329 | 129 | 0 |
2369 | 2369 | 2021-07-24 | Sonoma | 97 | 32124 | 328 | 159 | 0 |
2427 | 2427 | 2021-07-23 | Sonoma | 97 | 31965 | 328 | 60 | 0 |
2543 | 2543 | 2021-07-21 | Sonoma | 97 | 31875 | 327 | 92 | 0 |
2601 | 2601 | 2021-07-20 | Sonoma | 97 | 31783 | 327 | 20 | 0 |
2659 | 2659 | 2021-07-19 | Sonoma | 97 | 31763 | 327 | 0 | 0 |
2717 | 2717 | 2021-07-18 | Sonoma | 97 | 31763 | 327 | 60 | 0 |
2775 | 2775 | 2021-07-17 | Sonoma | 97 | 31703 | 327 | 0 | 0 |
2891 | 2891 | 2021-07-15 | Sonoma | 97 | 31641 | 323 | 94 | 0 |
2949 | 2949 | 2021-07-14 | Sonoma | 97 | 31547 | 323 | 112 | 0 |
3007 | 3007 | 2021-07-13 | Sonoma | 97 | 31435 | 323 | 0 | 0 |
3065 | 3065 | 2021-07-12 | Sonoma | 97 | 31435 | 323 | 0 | 0 |
3123 | 3123 | 2021-07-11 | Sonoma | 97 | 31435 | 323 | 61 | 0 |
3239 | 3239 | 2021-07-09 | Sonoma | 97 | 31307 | 319 | 37 | 0 |
3355 | 3355 | 2021-07-07 | Sonoma | 97 | 31160 | 318 | 0 | 0 |
3413 | 3413 | 2021-07-06 | Sonoma | 97 | 31160 | 318 | 0 | 0 |
3471 | 3471 | 2021-07-05 | Sonoma | 97 | 31160 | 318 | 44 | 0 |
3529 | 3529 | 2021-07-04 | Sonoma | 97 | 31116 | 318 | 0 | 0 |
3587 | 3587 | 2021-07-03 | Sonoma | 97 | 31116 | 318 | 26 | 0 |
3645 | 3645 | 2021-07-02 | Sonoma | 97 | 31090 | 318 | 64 | 0 |
3703 | 3703 | 2021-07-01 | Sonoma | 97 | 31026 | 318 | 0 | 0 |
3819 | 3819 | 2021-06-29 | Sonoma | 97 | 30941 | 317 | 0 | 0 |
3877 | 3877 | 2021-06-28 | Sonoma | 97 | 30941 | 317 | 0 | 0 |
3935 | 3935 | 2021-06-27 | Sonoma | 97 | 30941 | 317 | 0 | 0 |
3993 | 3993 | 2021-06-26 | Sonoma | 97 | 30941 | 317 | 0 | 0 |
4051 | 4051 | 2021-06-25 | Sonoma | 97 | 30941 | 317 | 0 | 0 |
4109 | 4109 | 2021-06-24 | Sonoma | 97 | 30941 | 317 | 0 | 0 |
4167 | 4167 | 2021-06-23 | Sonoma | 97 | 30941 | 317 | 0 | 0 |
4225 | 4225 | 2021-06-22 | Sonoma | 97 | 30941 | 317 | 73 | 0 |
4283 | 4283 | 2021-06-21 | Sonoma | 97 | 30868 | 317 | 0 | 0 |
4399 | 4399 | 2021-06-19 | Sonoma | 97 | 30844 | 316 | 19 | 0 |
4457 | 4457 | 2021-06-18 | Sonoma | 97 | 30825 | 316 | 0 | 0 |
4515 | 4515 | 2021-06-17 | Sonoma | 97 | 30825 | 316 | 42 | 0 |
4573 | 4573 | 2021-06-16 | Sonoma | 97 | 30783 | 316 | 95 | 0 |
4631 | 4631 | 2021-06-15 | Sonoma | 97 | 30688 | 316 | 0 | 0 |
4689 | 4689 | 2021-06-14 | Sonoma | 97 | 30688 | 316 | 0 | 0 |
4747 | 4747 | 2021-06-13 | Sonoma | 97 | 30688 | 316 | 0 | 0 |
4805 | 4805 | 2021-06-12 | Sonoma | 97 | 30688 | 316 | 29 | 0 |
4863 | 4863 | 2021-06-11 | Sonoma | 97 | 30659 | 316 | 73 | 0 |
4921 | 4921 | 2021-06-10 | Sonoma | 97 | 30586 | 316 | 0 | 0 |
4979 | 4979 | 2021-06-09 | Sonoma | 97 | 30586 | 316 | 17 | 0 |
5095 | 5095 | 2021-06-07 | Sonoma | 97 | 30493 | 315 | 0 | 0 |
5153 | 5153 | 2021-06-06 | Sonoma | 97 | 30493 | 315 | 39 | 0 |
5211 | 5211 | 2021-06-05 | Sonoma | 97 | 30454 | 315 | 0 | 0 |
5269 | 5269 | 2021-06-04 | Sonoma | 97 | 30454 | 315 | 32 | 0 |
5327 | 5327 | 2021-06-03 | Sonoma | 97 | 30422 | 315 | 29 | 0 |
5385 | 5385 | 2021-06-02 | Sonoma | 97 | 30393 | 315 | 57 | 0 |
5443 | 5443 | 2021-06-01 | Sonoma | 97 | 30336 | 315 | 0 | 0 |
5501 | 5501 | 2021-05-31 | Sonoma | 97 | 30336 | 315 | 0 | 0 |
5559 | 5559 | 2021-05-30 | Sonoma | 97 | 30336 | 315 | 38 | 0 |
5617 | 5617 | 2021-05-29 | Sonoma | 97 | 30298 | 315 | 29 | 0 |
5675 | 5675 | 2021-05-28 | Sonoma | 97 | 30269 | 315 | 12 | 0 |
5733 | 5733 | 2021-05-27 | Sonoma | 97 | 30257 | 315 | 0 | 0 |
5791 | 5791 | 2021-05-26 | Sonoma | 97 | 30257 | 315 | 87 | 0 |
5849 | 5849 | 2021-05-25 | Sonoma | 97 | 30170 | 315 | 0 | 0 |
5965 | 5965 | 2021-05-23 | Sonoma | 97 | 30169 | 314 | 1 | 0 |
6023 | 6023 | 2021-05-22 | Sonoma | 97 | 30168 | 314 | 18 | 0 |
6081 | 6081 | 2021-05-21 | Sonoma | 97 | 30150 | 314 | 20 | 0 |
6139 | 6139 | 2021-05-20 | Sonoma | 97 | 30130 | 314 | 26 | 0 |
6197 | 6197 | 2021-05-19 | Sonoma | 97 | 30104 | 314 | 33 | 0 |
6255 | 6255 | 2021-05-18 | Sonoma | 97 | 30071 | 314 | 0 | 0 |
6313 | 6313 | 2021-05-17 | Sonoma | 97 | 30071 | 314 | 4 | 0 |
6371 | 6371 | 2021-05-16 | Sonoma | 97 | 30067 | 314 | 14 | 0 |
6429 | 6429 | 2021-05-15 | Sonoma | 97 | 30053 | 314 | 0 | 0 |
6487 | 6487 | 2021-05-14 | Sonoma | 97 | 30053 | 314 | 18 | 0 |
6545 | 6545 | 2021-05-13 | Sonoma | 97 | 30035 | 314 | 9 | 0 |
6661 | 6661 | 2021-05-11 | Sonoma | 97 | 30002 | 312 | 0 | 0 |
6719 | 6719 | 2021-05-10 | Sonoma | 97 | 30002 | 312 | 18 | 0 |
6777 | 6777 | 2021-05-09 | Sonoma | 97 | 29984 | 312 | 9 | 0 |
6835 | 6835 | 2021-05-08 | Sonoma | 97 | 29975 | 312 | 24 | 0 |
6893 | 6893 | 2021-05-07 | Sonoma | 97 | 29951 | 312 | 0 | 0 |
6951 | 6951 | 2021-05-06 | Sonoma | 97 | 29951 | 312 | 30 | 0 |
7009 | 7009 | 2021-05-05 | Sonoma | 97 | 29921 | 312 | 11 | 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 );