latimes_agency_totals

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

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 descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: did_not_update, date (date)

fips 1

county 1

agency 1

  • Sonoma · 559 ✖
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  
235 235 Sonoma Sonoma 97 2021-08-30 36498 353 TRUE
296 296 Sonoma Sonoma 97 2021-08-29 36498 353 TRUE
357 357 Sonoma Sonoma 97 2021-08-28 36498 353  
418 418 Sonoma Sonoma 97 2021-08-27 36158 349 TRUE
479 479 Sonoma Sonoma 97 2021-08-26 36158 349  
540 540 Sonoma Sonoma 97 2021-08-25 35816 347  
601 601 Sonoma Sonoma 97 2021-08-24 35664 344 TRUE
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  
1150 1150 Sonoma Sonoma 97 2021-08-15 34686 338 TRUE
1211 1211 Sonoma Sonoma 97 2021-08-14 34686 338  
1272 1272 Sonoma Sonoma 97 2021-08-13 34394 337 TRUE
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  
1943 1943 Sonoma Sonoma 97 2021-08-02 32880 330 TRUE
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  
2309 2309 Sonoma Sonoma 97 2021-07-27 32325 329 TRUE
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  
2797 2797 Sonoma Sonoma 97 2021-07-19 31763 327 TRUE
2858 2858 Sonoma Sonoma 97 2021-07-18 31763 327  
2919 2919 Sonoma Sonoma 97 2021-07-17 31703 327 TRUE
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  
3163 3163 Sonoma Sonoma 97 2021-07-13 31435 323 TRUE
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  
3529 3529 Sonoma Sonoma 97 2021-07-07 31160 318 TRUE
3590 3590 Sonoma Sonoma 97 2021-07-06 31160 318 TRUE
3651 3651 Sonoma Sonoma 97 2021-07-05 31160 318  
3712 3712 Sonoma Sonoma 97 2021-07-04 31116 318 TRUE
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  
4017 4017 Sonoma Sonoma 97 2021-06-29 30941 317 TRUE
4078 4078 Sonoma Sonoma 97 2021-06-28 30941 317  
4139 4139 Sonoma Sonoma 97 2021-06-27 30941 317 TRUE
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  
4871 4871 Sonoma Sonoma 97 2021-06-15 30688 316 TRUE
4932 4932 Sonoma Sonoma 97 2021-06-14 30688 316 TRUE
4993 4993 Sonoma Sonoma 97 2021-06-13 30688 316 TRUE
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  
5481 5481 Sonoma Sonoma 97 2021-06-05 30454 315 TRUE
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  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [latimes_agency_totals] (
   [agency] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [date] TEXT,
   [confirmed_cases] INTEGER,
   [deaths] INTEGER,
   [did_not_update] TEXT
);