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 = "San Diego" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
19011 | 19011 | San Diego | San Diego | 73 | 2020-10-26 | 54941 | 870 | |
19072 | 19072 | San Diego | San Diego | 73 | 2020-10-25 | 54583 | 870 | |
19133 | 19133 | San Diego | San Diego | 73 | 2020-10-24 | 54314 | 868 | |
19194 | 19194 | San Diego | San Diego | 73 | 2020-10-23 | 53928 | 867 | |
19255 | 19255 | San Diego | San Diego | 73 | 2020-10-22 | 53498 | 866 | |
19316 | 19316 | San Diego | San Diego | 73 | 2020-10-21 | 53263 | 863 | |
19377 | 19377 | San Diego | San Diego | 73 | 2020-10-20 | 53000 | 857 | |
19438 | 19438 | San Diego | San Diego | 73 | 2020-10-19 | 52735 | 853 | |
19499 | 19499 | San Diego | San Diego | 73 | 2020-10-18 | 52355 | 853 | |
19560 | 19560 | San Diego | San Diego | 73 | 2020-10-17 | 51982 | 853 | |
19621 | 19621 | San Diego | San Diego | 73 | 2020-10-16 | 51781 | 850 | |
19682 | 19682 | San Diego | San Diego | 73 | 2020-10-15 | 51470 | 847 | |
19743 | 19743 | San Diego | San Diego | 73 | 2020-10-14 | 51327 | 844 | |
19804 | 19804 | San Diego | San Diego | 73 | 2020-10-13 | 51024 | 840 | |
19865 | 19865 | San Diego | San Diego | 73 | 2020-10-12 | 50746 | 826 | |
19926 | 19926 | San Diego | San Diego | 73 | 2020-10-11 | 50551 | 826 | |
19987 | 19987 | San Diego | San Diego | 73 | 2020-10-10 | 50143 | 825 | |
20048 | 20048 | San Diego | San Diego | 73 | 2020-10-09 | 49823 | 821 | |
20109 | 20109 | San Diego | San Diego | 73 | 2020-10-08 | 49466 | 819 | |
20170 | 20170 | San Diego | San Diego | 73 | 2020-10-07 | 49175 | 813 | |
20231 | 20231 | San Diego | San Diego | 73 | 2020-10-06 | 48821 | 806 | |
20292 | 20292 | San Diego | San Diego | 73 | 2020-10-05 | 48660 | 803 | |
20353 | 20353 | San Diego | San Diego | 73 | 2020-10-04 | 48436 | 803 | |
20414 | 20414 | San Diego | San Diego | 73 | 2020-10-03 | 48200 | 798 | |
20475 | 20475 | San Diego | San Diego | 73 | 2020-10-02 | 47791 | 794 | |
20536 | 20536 | San Diego | San Diego | 73 | 2020-10-01 | 47485 | 792 | |
20597 | 20597 | San Diego | San Diego | 73 | 2020-09-30 | 47180 | 783 | |
20658 | 20658 | San Diego | San Diego | 73 | 2020-09-29 | 46985 | 781 | |
20719 | 20719 | San Diego | San Diego | 73 | 2020-09-28 | 46734 | 776 | |
20780 | 20780 | San Diego | San Diego | 73 | 2020-09-27 | 46610 | 776 | |
20841 | 20841 | San Diego | San Diego | 73 | 2020-09-26 | 46331 | 775 | |
20902 | 20902 | San Diego | San Diego | 73 | 2020-09-25 | 46001 | 775 | |
20963 | 20963 | San Diego | San Diego | 73 | 2020-09-24 | 45596 | 773 | |
21024 | 21024 | San Diego | San Diego | 73 | 2020-09-23 | 45425 | 767 | |
21085 | 21085 | San Diego | San Diego | 73 | 2020-09-22 | 45147 | 765 | |
21146 | 21146 | San Diego | San Diego | 73 | 2020-09-21 | 44925 | 760 | |
21207 | 21207 | San Diego | San Diego | 73 | 2020-09-20 | 44577 | 760 | |
21268 | 21268 | San Diego | San Diego | 73 | 2020-09-19 | 44293 | 760 | |
21329 | 21329 | San Diego | San Diego | 73 | 2020-09-18 | 44007 | 757 | |
21390 | 21390 | San Diego | San Diego | 73 | 2020-09-17 | 43619 | 754 | |
21451 | 21451 | San Diego | San Diego | 73 | 2020-09-16 | 43445 | 748 | |
21512 | 21512 | San Diego | San Diego | 73 | 2020-09-15 | 43181 | 742 | |
21573 | 21573 | San Diego | San Diego | 73 | 2020-09-14 | 42887 | 734 | |
21634 | 21634 | San Diego | San Diego | 73 | 2020-09-13 | 42679 | 734 | |
21695 | 21695 | San Diego | San Diego | 73 | 2020-09-12 | 42414 | 734 | |
21756 | 21756 | San Diego | San Diego | 73 | 2020-09-11 | 41969 | 730 | |
21817 | 21817 | San Diego | San Diego | 73 | 2020-09-10 | 41608 | 725 | |
21878 | 21878 | San Diego | San Diego | 73 | 2020-09-09 | 41324 | 721 | |
21939 | 21939 | San Diego | San Diego | 73 | 2020-09-08 | 41077 | 709 | |
22000 | 22000 | San Diego | San Diego | 73 | 2020-09-07 | 40650 | 707 | TRUE |
22061 | 22061 | San Diego | San Diego | 73 | 2020-09-06 | 40650 | 707 | |
22122 | 22122 | San Diego | San Diego | 73 | 2020-09-05 | 40342 | 704 | |
22183 | 22183 | San Diego | San Diego | 73 | 2020-09-04 | 39899 | 701 | |
22244 | 22244 | San Diego | San Diego | 73 | 2020-09-03 | 39446 | 700 | |
22305 | 22305 | San Diego | San Diego | 73 | 2020-09-02 | 39121 | 695 | |
22366 | 22366 | San Diego | San Diego | 73 | 2020-09-01 | 38871 | 688 | |
22427 | 22427 | San Diego | San Diego | 73 | 2020-08-31 | 38604 | 682 | |
22488 | 22488 | San Diego | San Diego | 73 | 2020-08-30 | 38300 | 682 | |
22549 | 22549 | San Diego | San Diego | 73 | 2020-08-29 | 38047 | 679 | |
22610 | 22610 | San Diego | San Diego | 73 | 2020-08-28 | 37784 | 676 | |
22671 | 22671 | San Diego | San Diego | 73 | 2020-08-27 | 37499 | 673 | |
22732 | 22732 | San Diego | San Diego | 73 | 2020-08-26 | 37222 | 668 | |
22793 | 22793 | San Diego | San Diego | 73 | 2020-08-25 | 36994 | 665 | |
22854 | 22854 | San Diego | San Diego | 73 | 2020-08-24 | 36727 | 660 | |
22915 | 22915 | San Diego | San Diego | 73 | 2020-08-23 | 36540 | 660 | |
22976 | 22976 | San Diego | San Diego | 73 | 2020-08-22 | 36203 | 660 | |
23037 | 23037 | San Diego | San Diego | 73 | 2020-08-21 | 35912 | 652 | |
23098 | 23098 | San Diego | San Diego | 73 | 2020-08-20 | 35608 | 644 | |
23159 | 23159 | San Diego | San Diego | 73 | 2020-08-19 | 35376 | 638 | |
23220 | 23220 | San Diego | San Diego | 73 | 2020-08-18 | 35162 | 633 | |
23281 | 23281 | San Diego | San Diego | 73 | 2020-08-17 | 34960 | 626 | |
23342 | 23342 | San Diego | San Diego | 73 | 2020-08-16 | 34678 | 626 | |
23403 | 23403 | San Diego | San Diego | 73 | 2020-08-15 | 34344 | 626 | |
23464 | 23464 | San Diego | San Diego | 73 | 2020-08-14 | 34065 | 622 | |
23525 | 23525 | San Diego | San Diego | 73 | 2020-08-13 | 33659 | 615 | |
23586 | 23586 | San Diego | San Diego | 73 | 2020-08-12 | 33393 | 608 | |
23647 | 23647 | San Diego | San Diego | 73 | 2020-08-11 | 33157 | 602 | |
23708 | 23708 | San Diego | San Diego | 73 | 2020-08-10 | 32975 | 594 | |
23769 | 23769 | San Diego | San Diego | 73 | 2020-08-09 | 32747 | 594 | |
23830 | 23830 | San Diego | San Diego | 73 | 2020-08-08 | 32330 | 593 | |
23891 | 23891 | San Diego | San Diego | 73 | 2020-08-07 | 31779 | 586 | |
23952 | 23952 | San Diego | San Diego | 73 | 2020-08-06 | 31127 | 583 | |
24013 | 24013 | San Diego | San Diego | 73 | 2020-08-05 | 30864 | 578 | |
24074 | 24074 | San Diego | San Diego | 73 | 2020-08-04 | 30516 | 568 | |
24135 | 24135 | San Diego | San Diego | 73 | 2020-08-03 | 30226 | 565 | |
24196 | 24196 | San Diego | San Diego | 73 | 2020-08-02 | 29883 | 565 | |
24257 | 24257 | San Diego | San Diego | 73 | 2020-08-01 | 29577 | 565 | |
24318 | 24318 | San Diego | San Diego | 73 | 2020-07-31 | 29048 | 561 | |
24379 | 24379 | San Diego | San Diego | 73 | 2020-07-30 | 28688 | 558 | |
24440 | 24440 | San Diego | San Diego | 73 | 2020-07-29 | 28287 | 552 | |
24501 | 24501 | San Diego | San Diego | 73 | 2020-07-28 | 28005 | 547 | |
24562 | 24562 | San Diego | San Diego | 73 | 2020-07-27 | 27507 | 533 | |
24623 | 24623 | San Diego | San Diego | 73 | 2020-07-26 | 26984 | 533 | |
24684 | 24684 | San Diego | San Diego | 73 | 2020-07-25 | 26701 | 533 | |
24745 | 24745 | San Diego | San Diego | 73 | 2020-07-24 | 26098 | 524 | |
24806 | 24806 | San Diego | San Diego | 73 | 2020-07-23 | 25608 | 512 | |
24867 | 24867 | San Diego | San Diego | 73 | 2020-07-22 | 25107 | 505 | |
24928 | 24928 | San Diego | San Diego | 73 | 2020-07-21 | 24520 | 487 | |
24989 | 24989 | San Diego | San Diego | 73 | 2020-07-20 | 24135 | 478 | |
25050 | 25050 | San Diego | San Diego | 73 | 2020-07-19 | 23682 | 478 |
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 );