latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
559 rows where agency = "San Diego" sorted by date descending
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 |
---|---|---|---|---|---|---|---|---|
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 |
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 );