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 did_not_update
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 ▼ |
---|---|---|---|---|---|---|---|---|
52 | 52 | Sonoma | Sonoma | 97 | 2021-09-02 | 37055 | 356 | |
113 | 113 | Sonoma | Sonoma | 97 | 2021-09-01 | 36806 | 356 | |
174 | 174 | Sonoma | Sonoma | 97 | 2021-08-31 | 36515 | 353 | |
357 | 357 | Sonoma | Sonoma | 97 | 2021-08-28 | 36498 | 353 | |
479 | 479 | Sonoma | Sonoma | 97 | 2021-08-26 | 36158 | 349 | |
540 | 540 | Sonoma | Sonoma | 97 | 2021-08-25 | 35816 | 347 | |
662 | 662 | Sonoma | Sonoma | 97 | 2021-08-23 | 35664 | 344 | |
723 | 723 | Sonoma | Sonoma | 97 | 2021-08-22 | 35562 | 344 | |
784 | 784 | Sonoma | Sonoma | 97 | 2021-08-21 | 35558 | 344 | |
845 | 845 | Sonoma | Sonoma | 97 | 2021-08-20 | 35210 | 344 | |
906 | 906 | Sonoma | Sonoma | 97 | 2021-08-19 | 35210 | 344 | |
967 | 967 | Sonoma | Sonoma | 97 | 2021-08-18 | 35093 | 344 | |
1028 | 1028 | Sonoma | Sonoma | 97 | 2021-08-17 | 34992 | 340 | |
1089 | 1089 | Sonoma | Sonoma | 97 | 2021-08-16 | 34839 | 338 | |
1211 | 1211 | Sonoma | Sonoma | 97 | 2021-08-14 | 34686 | 338 | |
1333 | 1333 | Sonoma | Sonoma | 97 | 2021-08-12 | 34394 | 337 | |
1394 | 1394 | Sonoma | Sonoma | 97 | 2021-08-11 | 34296 | 337 | |
1455 | 1455 | Sonoma | Sonoma | 97 | 2021-08-10 | 34023 | 337 | |
1516 | 1516 | Sonoma | Sonoma | 97 | 2021-08-09 | 34023 | 337 | |
1577 | 1577 | Sonoma | Sonoma | 97 | 2021-08-08 | 33753 | 334 | |
1638 | 1638 | Sonoma | Sonoma | 97 | 2021-08-07 | 33619 | 334 | |
1699 | 1699 | Sonoma | Sonoma | 97 | 2021-08-06 | 33564 | 334 | |
1760 | 1760 | Sonoma | Sonoma | 97 | 2021-08-05 | 33564 | 334 | |
1821 | 1821 | Sonoma | Sonoma | 97 | 2021-08-04 | 33414 | 331 | |
1882 | 1882 | Sonoma | Sonoma | 97 | 2021-08-03 | 32967 | 331 | |
2004 | 2004 | Sonoma | Sonoma | 97 | 2021-08-01 | 32880 | 330 | |
2065 | 2065 | Sonoma | Sonoma | 97 | 2021-07-31 | 32817 | 330 | |
2126 | 2126 | Sonoma | Sonoma | 97 | 2021-07-30 | 32665 | 330 | |
2187 | 2187 | Sonoma | Sonoma | 97 | 2021-07-29 | 32665 | 330 | |
2248 | 2248 | Sonoma | Sonoma | 97 | 2021-07-28 | 32526 | 329 | |
2370 | 2370 | Sonoma | Sonoma | 97 | 2021-07-26 | 32325 | 329 | |
2431 | 2431 | Sonoma | Sonoma | 97 | 2021-07-25 | 32196 | 329 | |
2492 | 2492 | Sonoma | Sonoma | 97 | 2021-07-24 | 32124 | 328 | |
2553 | 2553 | Sonoma | Sonoma | 97 | 2021-07-23 | 31965 | 328 | |
2614 | 2614 | Sonoma | Sonoma | 97 | 2021-07-22 | 31905 | 328 | |
2675 | 2675 | Sonoma | Sonoma | 97 | 2021-07-21 | 31875 | 327 | |
2736 | 2736 | Sonoma | Sonoma | 97 | 2021-07-20 | 31783 | 327 | |
2858 | 2858 | Sonoma | Sonoma | 97 | 2021-07-18 | 31763 | 327 | |
2980 | 2980 | Sonoma | Sonoma | 97 | 2021-07-16 | 31703 | 327 | |
3041 | 3041 | Sonoma | Sonoma | 97 | 2021-07-15 | 31641 | 323 | |
3102 | 3102 | Sonoma | Sonoma | 97 | 2021-07-14 | 31547 | 323 | |
3224 | 3224 | Sonoma | Sonoma | 97 | 2021-07-12 | 31435 | 323 | |
3285 | 3285 | Sonoma | Sonoma | 97 | 2021-07-11 | 31435 | 323 | |
3346 | 3346 | Sonoma | Sonoma | 97 | 2021-07-10 | 31374 | 323 | |
3407 | 3407 | Sonoma | Sonoma | 97 | 2021-07-09 | 31307 | 319 | |
3468 | 3468 | Sonoma | Sonoma | 97 | 2021-07-08 | 31270 | 319 | |
3651 | 3651 | Sonoma | Sonoma | 97 | 2021-07-05 | 31160 | 318 | |
3773 | 3773 | Sonoma | Sonoma | 97 | 2021-07-03 | 31116 | 318 | |
3834 | 3834 | Sonoma | Sonoma | 97 | 2021-07-02 | 31090 | 318 | |
3895 | 3895 | Sonoma | Sonoma | 97 | 2021-07-01 | 31026 | 318 | |
3956 | 3956 | Sonoma | Sonoma | 97 | 2021-06-30 | 31026 | 318 | |
4078 | 4078 | Sonoma | Sonoma | 97 | 2021-06-28 | 30941 | 317 | |
4200 | 4200 | Sonoma | Sonoma | 97 | 2021-06-26 | 30941 | 317 | |
4261 | 4261 | Sonoma | Sonoma | 97 | 2021-06-25 | 30941 | 317 | |
4322 | 4322 | Sonoma | Sonoma | 97 | 2021-06-24 | 30941 | 317 | |
4383 | 4383 | Sonoma | Sonoma | 97 | 2021-06-23 | 30941 | 317 | |
4444 | 4444 | Sonoma | Sonoma | 97 | 2021-06-22 | 30941 | 317 | |
4505 | 4505 | Sonoma | Sonoma | 97 | 2021-06-21 | 30868 | 317 | |
4566 | 4566 | Sonoma | Sonoma | 97 | 2021-06-20 | 30868 | 317 | |
4627 | 4627 | Sonoma | Sonoma | 97 | 2021-06-19 | 30844 | 316 | |
4688 | 4688 | Sonoma | Sonoma | 97 | 2021-06-18 | 30825 | 316 | |
4749 | 4749 | Sonoma | Sonoma | 97 | 2021-06-17 | 30825 | 316 | |
4810 | 4810 | Sonoma | Sonoma | 97 | 2021-06-16 | 30783 | 316 | |
5054 | 5054 | Sonoma | Sonoma | 97 | 2021-06-12 | 30688 | 316 | |
5115 | 5115 | Sonoma | Sonoma | 97 | 2021-06-11 | 30659 | 316 | |
5176 | 5176 | Sonoma | Sonoma | 97 | 2021-06-10 | 30586 | 316 | |
5237 | 5237 | Sonoma | Sonoma | 97 | 2021-06-09 | 30586 | 316 | |
5298 | 5298 | Sonoma | Sonoma | 97 | 2021-06-08 | 30569 | 316 | |
5359 | 5359 | Sonoma | Sonoma | 97 | 2021-06-07 | 30493 | 315 | |
5420 | 5420 | Sonoma | Sonoma | 97 | 2021-06-06 | 30493 | 315 | |
5542 | 5542 | Sonoma | Sonoma | 97 | 2021-06-04 | 30454 | 315 | |
5603 | 5603 | Sonoma | Sonoma | 97 | 2021-06-03 | 30422 | 315 | |
5664 | 5664 | Sonoma | Sonoma | 97 | 2021-06-02 | 30393 | 315 | |
5725 | 5725 | Sonoma | Sonoma | 97 | 2021-06-01 | 30336 | 315 | |
5786 | 5786 | Sonoma | Sonoma | 97 | 2021-05-31 | 30336 | 315 | |
5847 | 5847 | Sonoma | Sonoma | 97 | 2021-05-30 | 30336 | 315 | |
5908 | 5908 | Sonoma | Sonoma | 97 | 2021-05-29 | 30298 | 315 | |
5969 | 5969 | Sonoma | Sonoma | 97 | 2021-05-28 | 30269 | 315 | |
6030 | 6030 | Sonoma | Sonoma | 97 | 2021-05-27 | 30257 | 315 | |
6091 | 6091 | Sonoma | Sonoma | 97 | 2021-05-26 | 30257 | 315 | |
6152 | 6152 | Sonoma | Sonoma | 97 | 2021-05-25 | 30170 | 315 | |
6213 | 6213 | Sonoma | Sonoma | 97 | 2021-05-24 | 30170 | 315 | |
6274 | 6274 | Sonoma | Sonoma | 97 | 2021-05-23 | 30169 | 314 | |
6335 | 6335 | Sonoma | Sonoma | 97 | 2021-05-22 | 30168 | 314 | |
6396 | 6396 | Sonoma | Sonoma | 97 | 2021-05-21 | 30150 | 314 | |
6457 | 6457 | Sonoma | Sonoma | 97 | 2021-05-20 | 30130 | 314 | |
6518 | 6518 | Sonoma | Sonoma | 97 | 2021-05-19 | 30104 | 314 | |
6640 | 6640 | Sonoma | Sonoma | 97 | 2021-05-17 | 30071 | 314 | |
6701 | 6701 | Sonoma | Sonoma | 97 | 2021-05-16 | 30067 | 314 | |
6823 | 6823 | Sonoma | Sonoma | 97 | 2021-05-14 | 30053 | 314 | |
6884 | 6884 | Sonoma | Sonoma | 97 | 2021-05-13 | 30035 | 314 | |
6945 | 6945 | Sonoma | Sonoma | 97 | 2021-05-12 | 30026 | 314 | |
7067 | 7067 | Sonoma | Sonoma | 97 | 2021-05-10 | 30002 | 312 | |
7128 | 7128 | Sonoma | Sonoma | 97 | 2021-05-09 | 29984 | 312 | |
7189 | 7189 | Sonoma | Sonoma | 97 | 2021-05-08 | 29975 | 312 | |
7250 | 7250 | Sonoma | Sonoma | 97 | 2021-05-07 | 29951 | 312 | |
7311 | 7311 | Sonoma | Sonoma | 97 | 2021-05-06 | 29951 | 312 | |
7372 | 7372 | Sonoma | Sonoma | 97 | 2021-05-05 | 29921 | 312 | |
7433 | 7433 | Sonoma | Sonoma | 97 | 2021-05-04 | 29910 | 312 | |
7494 | 7494 | Sonoma | Sonoma | 97 | 2021-05-03 | 29897 | 312 |
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 );