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 county = "San Diego" 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

  • San Diego · 559 ✖

agency 1

Link rowid agency county fips date ▲ confirmed_cases deaths did_not_update
40 40 San Diego San Diego 73 2021-09-02 335302 3908  
101 101 San Diego San Diego 73 2021-09-01 334377 3888 TRUE
162 162 San Diego San Diego 73 2021-08-31 334377 3888  
223 223 San Diego San Diego 73 2021-08-30 333011 3885  
284 284 San Diego San Diego 73 2021-08-29 331330 3880 TRUE
345 345 San Diego San Diego 73 2021-08-28 331330 3880  
406 406 San Diego San Diego 73 2021-08-27 330162 3877  
467 467 San Diego San Diego 73 2021-08-26 328276 3869  
528 528 San Diego San Diego 73 2021-08-25 325823 3851 TRUE
589 589 San Diego San Diego 73 2021-08-24 325823 3851  
650 650 San Diego San Diego 73 2021-08-23 324537 3848  
711 711 San Diego San Diego 73 2021-08-22 322620 3848  
772 772 San Diego San Diego 73 2021-08-21 321102 3846 TRUE
833 833 San Diego San Diego 73 2021-08-20 321102 3846  
894 894 San Diego San Diego 73 2021-08-19 319582 3839  
955 955 San Diego San Diego 73 2021-08-18 318152 3834  
1016 1016 San Diego San Diego 73 2021-08-17 317058 3824  
1077 1077 San Diego San Diego 73 2021-08-16 315348 3824  
1138 1138 San Diego San Diego 73 2021-08-15 313589 3824 TRUE
1199 1199 San Diego San Diego 73 2021-08-14 313589 3824  
1260 1260 San Diego San Diego 73 2021-08-13 312294 3821  
1321 1321 San Diego San Diego 73 2021-08-12 310596 3821  
1382 1382 San Diego San Diego 73 2021-08-11 309406 3818  
1443 1443 San Diego San Diego 73 2021-08-10 308288 3815  
1504 1504 San Diego San Diego 73 2021-08-09 306855 3811  
1565 1565 San Diego San Diego 73 2021-08-08 305983 3811  
1626 1626 San Diego San Diego 73 2021-08-07 304974 3811  
1687 1687 San Diego San Diego 73 2021-08-06 303691 3810  
1748 1748 San Diego San Diego 73 2021-08-05 302220 3806  
1809 1809 San Diego San Diego 73 2021-08-04 301100 3805  
1870 1870 San Diego San Diego 73 2021-08-03 300189 3803  
1931 1931 San Diego San Diego 73 2021-08-02 299021 3798  
1992 1992 San Diego San Diego 73 2021-08-01 298002 3798  
2053 2053 San Diego San Diego 73 2021-07-31 297226 3798  
2114 2114 San Diego San Diego 73 2021-07-30 296345 3798  
2175 2175 San Diego San Diego 73 2021-07-29 295054 3798  
2236 2236 San Diego San Diego 73 2021-07-28 294176 3798  
2297 2297 San Diego San Diego 73 2021-07-27 293408 3798  
2358 2358 San Diego San Diego 73 2021-07-26 292688 3793  
2419 2419 San Diego San Diego 73 2021-07-25 290625 3793 TRUE
2480 2480 San Diego San Diego 73 2021-07-24 290625 3793  
2541 2541 San Diego San Diego 73 2021-07-23 289367 3788  
2602 2602 San Diego San Diego 73 2021-07-22 288681 3787  
2663 2663 San Diego San Diego 73 2021-07-21 288681 3786  
2724 2724 San Diego San Diego 73 2021-07-20 288208 3786  
2785 2785 San Diego San Diego 73 2021-07-19 287694 3786  
2846 2846 San Diego San Diego 73 2021-07-18 286286 3786 TRUE
2907 2907 San Diego San Diego 73 2021-07-17 286286 3786 TRUE
2968 2968 San Diego San Diego 73 2021-07-16 286286 3786  
3029 3029 San Diego San Diego 73 2021-07-15 285697 3786  
3090 3090 San Diego San Diego 73 2021-07-14 285268 3786  
3151 3151 San Diego San Diego 73 2021-07-13 284996 3785  
3212 3212 San Diego San Diego 73 2021-07-12 284647 3785 TRUE
3273 3273 San Diego San Diego 73 2021-07-11 283818 3784 TRUE
3334 3334 San Diego San Diego 73 2021-07-10 283818 3784 TRUE
3395 3395 San Diego San Diego 73 2021-07-09 283818 3784  
3456 3456 San Diego San Diego 73 2021-07-08 283576 3783  
3517 3517 San Diego San Diego 73 2021-07-07 283376 3782  
3578 3578 San Diego San Diego 73 2021-07-06 282582 3780  
3639 3639 San Diego San Diego 73 2021-07-05 282582 3780 TRUE
3700 3700 San Diego San Diego 73 2021-07-04 282582 3780 TRUE
3761 3761 San Diego San Diego 73 2021-07-03 282582 3780 TRUE
3822 3822 San Diego San Diego 73 2021-07-02 282582 3780 TRUE
3883 3883 San Diego San Diego 73 2021-07-01 282582 3780  
3944 3944 San Diego San Diego 73 2021-06-30 282582 3780  
4005 4005 San Diego San Diego 73 2021-06-29 282498 3780  
4066 4066 San Diego San Diego 73 2021-06-28 282416 3780  
4127 4127 San Diego San Diego 73 2021-06-27 282358 3780  
4188 4188 San Diego San Diego 73 2021-06-26 282262 3780  
4249 4249 San Diego San Diego 73 2021-06-25 282156 3779  
4310 4310 San Diego San Diego 73 2021-06-24 282052 3778  
4371 4371 San Diego San Diego 73 2021-06-23 281936 3777  
4432 4432 San Diego San Diego 73 2021-06-22 281886 3771  
4493 4493 San Diego San Diego 73 2021-06-21 281749 3771 TRUE
4554 4554 San Diego San Diego 73 2021-06-20 281749 3771  
4615 4615 San Diego San Diego 73 2021-06-19 281681 3771  
4676 4676 San Diego San Diego 73 2021-06-18 281607 3771  
4737 4737 San Diego San Diego 73 2021-06-17 281530 3770  
4798 4798 San Diego San Diego 73 2021-06-16 281422 3770  
4859 4859 San Diego San Diego 73 2021-06-15 281374 3770  
4920 4920 San Diego San Diego 73 2021-06-14 281313 3770  
4981 4981 San Diego San Diego 73 2021-06-13 281202 3770 TRUE
5042 5042 San Diego San Diego 73 2021-06-12 281202 3770  
5103 5103 San Diego San Diego 73 2021-06-11 281143 3768  
5164 5164 San Diego San Diego 73 2021-06-10 281051 3766  
5225 5225 San Diego San Diego 73 2021-06-09 280940 3765  
5286 5286 San Diego San Diego 73 2021-06-08 280878 3764  
5347 5347 San Diego San Diego 73 2021-06-07 280807 3764  
5408 5408 San Diego San Diego 73 2021-06-06 280742 3764  
5469 5469 San Diego San Diego 73 2021-06-05 280675 3764  
5530 5530 San Diego San Diego 73 2021-06-04 280555 3763  
5591 5591 San Diego San Diego 73 2021-06-03 280429 3761  
5652 5652 San Diego San Diego 73 2021-06-02 280346 3760  
5713 5713 San Diego San Diego 73 2021-06-01 280304 3756  
5774 5774 San Diego San Diego 73 2021-05-31 280253 3756  
5835 5835 San Diego San Diego 73 2021-05-30 280208 3756  
5896 5896 San Diego San Diego 73 2021-05-29 280150 3756  
5957 5957 San Diego San Diego 73 2021-05-28 280042 3756  
6018 6018 San Diego San Diego 73 2021-05-27 279959 3756  
6079 6079 San Diego San Diego 73 2021-05-26 279858 3755  

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
);