latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
559 rows where county = "San Diego" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
18075 | 18075 | 2020-10-26 | San Diego | 73 | 54941 | 870 | 358 | 0 |
18133 | 18133 | 2020-10-25 | San Diego | 73 | 54583 | 870 | 269 | 2 |
18191 | 18191 | 2020-10-24 | San Diego | 73 | 54314 | 868 | 386 | 1 |
18249 | 18249 | 2020-10-23 | San Diego | 73 | 53928 | 867 | 430 | 1 |
18307 | 18307 | 2020-10-22 | San Diego | 73 | 53498 | 866 | 235 | 3 |
18365 | 18365 | 2020-10-21 | San Diego | 73 | 53263 | 863 | 263 | 6 |
18423 | 18423 | 2020-10-20 | San Diego | 73 | 53000 | 857 | 265 | 4 |
18481 | 18481 | 2020-10-19 | San Diego | 73 | 52735 | 853 | 380 | 0 |
18539 | 18539 | 2020-10-18 | San Diego | 73 | 52355 | 853 | 373 | 0 |
18597 | 18597 | 2020-10-17 | San Diego | 73 | 51982 | 853 | 201 | 3 |
18655 | 18655 | 2020-10-16 | San Diego | 73 | 51781 | 850 | 311 | 3 |
18713 | 18713 | 2020-10-15 | San Diego | 73 | 51470 | 847 | 143 | 3 |
18771 | 18771 | 2020-10-14 | San Diego | 73 | 51327 | 844 | 303 | 4 |
18829 | 18829 | 2020-10-13 | San Diego | 73 | 51024 | 840 | 278 | 14 |
18887 | 18887 | 2020-10-12 | San Diego | 73 | 50746 | 826 | 195 | 0 |
18945 | 18945 | 2020-10-11 | San Diego | 73 | 50551 | 826 | 408 | 1 |
19003 | 19003 | 2020-10-10 | San Diego | 73 | 50143 | 825 | 320 | 4 |
19061 | 19061 | 2020-10-09 | San Diego | 73 | 49823 | 821 | 357 | 2 |
19119 | 19119 | 2020-10-08 | San Diego | 73 | 49466 | 819 | 291 | 6 |
19177 | 19177 | 2020-10-07 | San Diego | 73 | 49175 | 813 | 354 | 7 |
19235 | 19235 | 2020-10-06 | San Diego | 73 | 48821 | 806 | 161 | 3 |
19293 | 19293 | 2020-10-05 | San Diego | 73 | 48660 | 803 | 224 | 0 |
19351 | 19351 | 2020-10-04 | San Diego | 73 | 48436 | 803 | 236 | 5 |
19409 | 19409 | 2020-10-03 | San Diego | 73 | 48200 | 798 | 409 | 4 |
19467 | 19467 | 2020-10-02 | San Diego | 73 | 47791 | 794 | 306 | 2 |
19525 | 19525 | 2020-10-01 | San Diego | 73 | 47485 | 792 | 305 | 9 |
19583 | 19583 | 2020-09-30 | San Diego | 73 | 47180 | 783 | 195 | 2 |
19641 | 19641 | 2020-09-29 | San Diego | 73 | 46985 | 781 | 251 | 5 |
19699 | 19699 | 2020-09-28 | San Diego | 73 | 46734 | 776 | 124 | 0 |
19757 | 19757 | 2020-09-27 | San Diego | 73 | 46610 | 776 | 279 | 1 |
19815 | 19815 | 2020-09-26 | San Diego | 73 | 46331 | 775 | 330 | 0 |
19873 | 19873 | 2020-09-25 | San Diego | 73 | 46001 | 775 | 405 | 2 |
19931 | 19931 | 2020-09-24 | San Diego | 73 | 45596 | 773 | 171 | 6 |
19989 | 19989 | 2020-09-23 | San Diego | 73 | 45425 | 767 | 278 | 2 |
20047 | 20047 | 2020-09-22 | San Diego | 73 | 45147 | 765 | 222 | 5 |
20105 | 20105 | 2020-09-21 | San Diego | 73 | 44925 | 760 | 348 | 0 |
20163 | 20163 | 2020-09-20 | San Diego | 73 | 44577 | 760 | 284 | 0 |
20221 | 20221 | 2020-09-19 | San Diego | 73 | 44293 | 760 | 286 | 3 |
20279 | 20279 | 2020-09-18 | San Diego | 73 | 44007 | 757 | 388 | 3 |
20337 | 20337 | 2020-09-17 | San Diego | 73 | 43619 | 754 | 174 | 6 |
20395 | 20395 | 2020-09-16 | San Diego | 73 | 43445 | 748 | 264 | 6 |
20453 | 20453 | 2020-09-15 | San Diego | 73 | 43181 | 742 | 294 | 8 |
20511 | 20511 | 2020-09-14 | San Diego | 73 | 42887 | 734 | 208 | 0 |
20569 | 20569 | 2020-09-13 | San Diego | 73 | 42679 | 734 | 265 | 0 |
20627 | 20627 | 2020-09-12 | San Diego | 73 | 42414 | 734 | 445 | 4 |
20685 | 20685 | 2020-09-11 | San Diego | 73 | 41969 | 730 | 361 | 5 |
20743 | 20743 | 2020-09-10 | San Diego | 73 | 41608 | 725 | 284 | 4 |
20801 | 20801 | 2020-09-09 | San Diego | 73 | 41324 | 721 | 247 | 12 |
20859 | 20859 | 2020-09-08 | San Diego | 73 | 41077 | 709 | 427 | 2 |
20917 | 20917 | 2020-09-07 | San Diego | 73 | 40650 | 707 | 0 | 0 |
20975 | 20975 | 2020-09-06 | San Diego | 73 | 40650 | 707 | 308 | 3 |
21033 | 21033 | 2020-09-05 | San Diego | 73 | 40342 | 704 | 443 | 3 |
21091 | 21091 | 2020-09-04 | San Diego | 73 | 39899 | 701 | 453 | 1 |
21149 | 21149 | 2020-09-03 | San Diego | 73 | 39446 | 700 | 325 | 5 |
21207 | 21207 | 2020-09-02 | San Diego | 73 | 39121 | 695 | 250 | 7 |
21265 | 21265 | 2020-09-01 | San Diego | 73 | 38871 | 688 | 267 | 6 |
21323 | 21323 | 2020-08-31 | San Diego | 73 | 38604 | 682 | 304 | 0 |
21381 | 21381 | 2020-08-30 | San Diego | 73 | 38300 | 682 | 253 | 3 |
21439 | 21439 | 2020-08-29 | San Diego | 73 | 38047 | 679 | 263 | 3 |
21497 | 21497 | 2020-08-28 | San Diego | 73 | 37784 | 676 | 285 | 3 |
21555 | 21555 | 2020-08-27 | San Diego | 73 | 37499 | 673 | 277 | 5 |
21613 | 21613 | 2020-08-26 | San Diego | 73 | 37222 | 668 | 228 | 3 |
21671 | 21671 | 2020-08-25 | San Diego | 73 | 36994 | 665 | 267 | 5 |
21729 | 21729 | 2020-08-24 | San Diego | 73 | 36727 | 660 | 187 | 0 |
21787 | 21787 | 2020-08-23 | San Diego | 73 | 36540 | 660 | 337 | 0 |
21845 | 21845 | 2020-08-22 | San Diego | 73 | 36203 | 660 | 291 | 8 |
21903 | 21903 | 2020-08-21 | San Diego | 73 | 35912 | 652 | 304 | 8 |
21961 | 21961 | 2020-08-20 | San Diego | 73 | 35608 | 644 | 232 | 6 |
22019 | 22019 | 2020-08-19 | San Diego | 73 | 35376 | 638 | 214 | 5 |
22077 | 22077 | 2020-08-18 | San Diego | 73 | 35162 | 633 | 202 | 7 |
22135 | 22135 | 2020-08-17 | San Diego | 73 | 34960 | 626 | 282 | 0 |
22193 | 22193 | 2020-08-16 | San Diego | 73 | 34678 | 626 | 334 | 0 |
22251 | 22251 | 2020-08-15 | San Diego | 73 | 34344 | 626 | 279 | 4 |
22309 | 22309 | 2020-08-14 | San Diego | 73 | 34065 | 622 | 406 | 7 |
22367 | 22367 | 2020-08-13 | San Diego | 73 | 33659 | 615 | 266 | 7 |
22425 | 22425 | 2020-08-12 | San Diego | 73 | 33393 | 608 | 236 | 6 |
22483 | 22483 | 2020-08-11 | San Diego | 73 | 33157 | 602 | 182 | 8 |
22541 | 22541 | 2020-08-10 | San Diego | 73 | 32975 | 594 | 228 | 0 |
22599 | 22599 | 2020-08-09 | San Diego | 73 | 32747 | 594 | 417 | 1 |
22657 | 22657 | 2020-08-08 | San Diego | 73 | 32330 | 593 | 551 | 7 |
22715 | 22715 | 2020-08-07 | San Diego | 73 | 31779 | 586 | 652 | 3 |
22773 | 22773 | 2020-08-06 | San Diego | 73 | 31127 | 583 | 263 | 5 |
22831 | 22831 | 2020-08-05 | San Diego | 73 | 30864 | 578 | 348 | 10 |
22889 | 22889 | 2020-08-04 | San Diego | 73 | 30516 | 568 | 290 | 3 |
22947 | 22947 | 2020-08-03 | San Diego | 73 | 30226 | 565 | 343 | 0 |
23005 | 23005 | 2020-08-02 | San Diego | 73 | 29883 | 565 | 306 | 0 |
23063 | 23063 | 2020-08-01 | San Diego | 73 | 29577 | 565 | 529 | 4 |
23121 | 23121 | 2020-07-31 | San Diego | 73 | 29048 | 561 | 360 | 3 |
23179 | 23179 | 2020-07-30 | San Diego | 73 | 28688 | 558 | 401 | 6 |
23237 | 23237 | 2020-07-29 | San Diego | 73 | 28287 | 552 | 282 | 5 |
23295 | 23295 | 2020-07-28 | San Diego | 73 | 28005 | 547 | 498 | 14 |
23353 | 23353 | 2020-07-27 | San Diego | 73 | 27507 | 533 | 523 | 0 |
23411 | 23411 | 2020-07-26 | San Diego | 73 | 26984 | 533 | 283 | 0 |
23469 | 23469 | 2020-07-25 | San Diego | 73 | 26701 | 533 | 603 | 9 |
23527 | 23527 | 2020-07-24 | San Diego | 73 | 26098 | 524 | 490 | 12 |
23585 | 23585 | 2020-07-23 | San Diego | 73 | 25608 | 512 | 501 | 7 |
23643 | 23643 | 2020-07-22 | San Diego | 73 | 25107 | 505 | 587 | 18 |
23701 | 23701 | 2020-07-21 | San Diego | 73 | 24520 | 487 | 385 | 9 |
23759 | 23759 | 2020-07-20 | San Diego | 73 | 24135 | 478 | 453 | 0 |
23817 | 23817 | 2020-07-19 | San Diego | 73 | 23682 | 478 | 568 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_county_totals] ( [date] TEXT, [county] TEXT, [fips] INTEGER, [confirmed_cases] INTEGER, [deaths] INTEGER, [new_confirmed_cases] INTEGER, [new_deaths] INTEGER );