latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
551 rows where agency = "San Joaquin" 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 |
---|---|---|---|---|---|---|---|---|
13462 | 13462 | San Joaquin | San Joaquin | 77 | 2021-01-25 | 59665 | 835 | |
13523 | 13523 | San Joaquin | San Joaquin | 77 | 2021-01-24 | 59395 | 808 | TRUE |
13584 | 13584 | San Joaquin | San Joaquin | 77 | 2021-01-23 | 59395 | 808 | TRUE |
13645 | 13645 | San Joaquin | San Joaquin | 77 | 2021-01-22 | 59395 | 808 | |
13706 | 13706 | San Joaquin | San Joaquin | 77 | 2021-01-21 | 59096 | 806 | |
13767 | 13767 | San Joaquin | San Joaquin | 77 | 2021-01-20 | 58843 | 788 | |
13828 | 13828 | San Joaquin | San Joaquin | 77 | 2021-01-19 | 58290 | 786 | |
13889 | 13889 | San Joaquin | San Joaquin | 77 | 2021-01-18 | 56484 | 748 | TRUE |
13950 | 13950 | San Joaquin | San Joaquin | 77 | 2021-01-17 | 56484 | 748 | TRUE |
14011 | 14011 | San Joaquin | San Joaquin | 77 | 2021-01-16 | 56484 | 748 | TRUE |
14072 | 14072 | San Joaquin | San Joaquin | 77 | 2021-01-15 | 56484 | 748 | |
14133 | 14133 | San Joaquin | San Joaquin | 77 | 2021-01-14 | 55580 | 738 | |
14194 | 14194 | San Joaquin | San Joaquin | 77 | 2021-01-13 | 54796 | 736 | |
14255 | 14255 | San Joaquin | San Joaquin | 77 | 2021-01-12 | 53994 | 724 | |
14316 | 14316 | San Joaquin | San Joaquin | 77 | 2021-01-11 | 52400 | 724 | |
14377 | 14377 | San Joaquin | San Joaquin | 77 | 2021-01-10 | 51523 | 712 | TRUE |
14438 | 14438 | San Joaquin | San Joaquin | 77 | 2021-01-09 | 51523 | 712 | TRUE |
14499 | 14499 | San Joaquin | San Joaquin | 77 | 2021-01-08 | 51523 | 712 | |
14560 | 14560 | San Joaquin | San Joaquin | 77 | 2021-01-07 | 50104 | 696 | |
14621 | 14621 | San Joaquin | San Joaquin | 77 | 2021-01-06 | 49682 | 683 | |
14682 | 14682 | San Joaquin | San Joaquin | 77 | 2021-01-05 | 49306 | 672 | |
14743 | 14743 | San Joaquin | San Joaquin | 77 | 2021-01-04 | 46562 | 667 | |
14804 | 14804 | San Joaquin | San Joaquin | 77 | 2021-01-03 | 45583 | 651 | TRUE |
14865 | 14865 | San Joaquin | San Joaquin | 77 | 2021-01-02 | 45583 | 651 | TRUE |
14926 | 14926 | San Joaquin | San Joaquin | 77 | 2021-01-01 | 45583 | 651 | TRUE |
14987 | 14987 | San Joaquin | San Joaquin | 77 | 2020-12-31 | 45583 | 651 | |
15048 | 15048 | San Joaquin | San Joaquin | 77 | 2020-12-30 | 44660 | 628 | TRUE |
15109 | 15109 | San Joaquin | San Joaquin | 77 | 2020-12-29 | 44660 | 628 | |
15170 | 15170 | San Joaquin | San Joaquin | 77 | 2020-12-28 | 43930 | 625 | |
15231 | 15231 | San Joaquin | San Joaquin | 77 | 2020-12-27 | 41104 | 618 | TRUE |
15292 | 15292 | San Joaquin | San Joaquin | 77 | 2020-12-26 | 41104 | 618 | TRUE |
15353 | 15353 | San Joaquin | San Joaquin | 77 | 2020-12-25 | 41104 | 618 | TRUE |
15414 | 15414 | San Joaquin | San Joaquin | 77 | 2020-12-24 | 41104 | 618 | |
15475 | 15475 | San Joaquin | San Joaquin | 77 | 2020-12-23 | 40328 | 603 | |
15536 | 15536 | San Joaquin | San Joaquin | 77 | 2020-12-22 | 39304 | 592 | |
15597 | 15597 | San Joaquin | San Joaquin | 77 | 2020-12-21 | 38564 | 588 | |
15658 | 15658 | San Joaquin | San Joaquin | 77 | 2020-12-20 | 36428 | 561 | TRUE |
15719 | 15719 | San Joaquin | San Joaquin | 77 | 2020-12-19 | 36428 | 561 | TRUE |
15780 | 15780 | San Joaquin | San Joaquin | 77 | 2020-12-18 | 36428 | 561 | |
15841 | 15841 | San Joaquin | San Joaquin | 77 | 2020-12-17 | 34641 | 556 | |
15902 | 15902 | San Joaquin | San Joaquin | 77 | 2020-12-16 | 33336 | 549 | |
15963 | 15963 | San Joaquin | San Joaquin | 77 | 2020-12-15 | 32641 | 537 | |
16024 | 16024 | San Joaquin | San Joaquin | 77 | 2020-12-14 | 31784 | 535 | |
16085 | 16085 | San Joaquin | San Joaquin | 77 | 2020-12-13 | 31720 | 534 | TRUE |
16146 | 16146 | San Joaquin | San Joaquin | 77 | 2020-12-12 | 31720 | 534 | TRUE |
16207 | 16207 | San Joaquin | San Joaquin | 77 | 2020-12-11 | 31720 | 534 | |
16268 | 16268 | San Joaquin | San Joaquin | 77 | 2020-12-10 | 30816 | 534 | |
16329 | 16329 | San Joaquin | San Joaquin | 77 | 2020-12-09 | 30579 | 532 | |
16390 | 16390 | San Joaquin | San Joaquin | 77 | 2020-12-08 | 28532 | 530 | |
16451 | 16451 | San Joaquin | San Joaquin | 77 | 2020-12-07 | 27844 | 530 | |
16512 | 16512 | San Joaquin | San Joaquin | 77 | 2020-12-06 | 27469 | 522 | TRUE |
16573 | 16573 | San Joaquin | San Joaquin | 77 | 2020-12-05 | 27469 | 522 | TRUE |
16634 | 16634 | San Joaquin | San Joaquin | 77 | 2020-12-04 | 27469 | 522 | |
16695 | 16695 | San Joaquin | San Joaquin | 77 | 2020-12-03 | 27083 | 522 | |
16756 | 16756 | San Joaquin | San Joaquin | 77 | 2020-12-02 | 26784 | 519 | |
16817 | 16817 | San Joaquin | San Joaquin | 77 | 2020-12-01 | 26064 | 510 | |
16878 | 16878 | San Joaquin | San Joaquin | 77 | 2020-11-30 | 25920 | 509 | |
16939 | 16939 | San Joaquin | San Joaquin | 77 | 2020-11-29 | 25675 | 502 | TRUE |
17000 | 17000 | San Joaquin | San Joaquin | 77 | 2020-11-28 | 25675 | 502 | TRUE |
17061 | 17061 | San Joaquin | San Joaquin | 77 | 2020-11-27 | 25675 | 502 | TRUE |
17122 | 17122 | San Joaquin | San Joaquin | 77 | 2020-11-26 | 25675 | 502 | TRUE |
17183 | 17183 | San Joaquin | San Joaquin | 77 | 2020-11-25 | 25675 | 502 | |
17244 | 17244 | San Joaquin | San Joaquin | 77 | 2020-11-24 | 25237 | 502 | |
17305 | 17305 | San Joaquin | San Joaquin | 77 | 2020-11-23 | 24804 | 502 | |
17366 | 17366 | San Joaquin | San Joaquin | 77 | 2020-11-22 | 24649 | 502 | TRUE |
17427 | 17427 | San Joaquin | San Joaquin | 77 | 2020-11-21 | 24649 | 502 | TRUE |
17488 | 17488 | San Joaquin | San Joaquin | 77 | 2020-11-20 | 24649 | 502 | |
17549 | 17549 | San Joaquin | San Joaquin | 77 | 2020-11-19 | 24450 | 502 | |
17610 | 17610 | San Joaquin | San Joaquin | 77 | 2020-11-18 | 24335 | 502 | |
17671 | 17671 | San Joaquin | San Joaquin | 77 | 2020-11-17 | 24171 | 502 | |
17732 | 17732 | San Joaquin | San Joaquin | 77 | 2020-11-16 | 23734 | 501 | |
17793 | 17793 | San Joaquin | San Joaquin | 77 | 2020-11-15 | 23517 | 501 | TRUE |
17854 | 17854 | San Joaquin | San Joaquin | 77 | 2020-11-14 | 23517 | 501 | TRUE |
17915 | 17915 | San Joaquin | San Joaquin | 77 | 2020-11-13 | 23517 | 501 | |
17976 | 17976 | San Joaquin | San Joaquin | 77 | 2020-11-12 | 23224 | 500 | |
18037 | 18037 | San Joaquin | San Joaquin | 77 | 2020-11-11 | 22993 | 500 | TRUE |
18098 | 18098 | San Joaquin | San Joaquin | 77 | 2020-11-10 | 22993 | 500 | |
18159 | 18159 | San Joaquin | San Joaquin | 77 | 2020-11-09 | 22740 | 497 | |
18220 | 18220 | San Joaquin | San Joaquin | 77 | 2020-11-08 | 22635 | 494 | TRUE |
18281 | 18281 | San Joaquin | San Joaquin | 77 | 2020-11-07 | 22635 | 494 | TRUE |
18342 | 18342 | San Joaquin | San Joaquin | 77 | 2020-11-06 | 22635 | 494 | |
18403 | 18403 | San Joaquin | San Joaquin | 77 | 2020-11-05 | 22556 | 494 | |
18464 | 18464 | San Joaquin | San Joaquin | 77 | 2020-11-04 | 22450 | 494 | |
18525 | 18525 | San Joaquin | San Joaquin | 77 | 2020-11-03 | 22365 | 494 | |
18586 | 18586 | San Joaquin | San Joaquin | 77 | 2020-11-02 | 22167 | 494 | |
18647 | 18647 | San Joaquin | San Joaquin | 77 | 2020-11-01 | 22106 | 494 | TRUE |
18708 | 18708 | San Joaquin | San Joaquin | 77 | 2020-10-31 | 22106 | 494 | TRUE |
18769 | 18769 | San Joaquin | San Joaquin | 77 | 2020-10-30 | 22106 | 494 | |
18830 | 18830 | San Joaquin | San Joaquin | 77 | 2020-10-29 | 21994 | 492 | |
18891 | 18891 | San Joaquin | San Joaquin | 77 | 2020-10-28 | 21988 | 492 | |
18952 | 18952 | San Joaquin | San Joaquin | 77 | 2020-10-27 | 21906 | 490 | |
19013 | 19013 | San Joaquin | San Joaquin | 77 | 2020-10-26 | 21729 | 489 | |
19074 | 19074 | San Joaquin | San Joaquin | 77 | 2020-10-25 | 21630 | 489 | TRUE |
19135 | 19135 | San Joaquin | San Joaquin | 77 | 2020-10-24 | 21630 | 489 | TRUE |
19196 | 19196 | San Joaquin | San Joaquin | 77 | 2020-10-23 | 21630 | 489 | |
19257 | 19257 | San Joaquin | San Joaquin | 77 | 2020-10-22 | 21528 | 488 | |
19318 | 19318 | San Joaquin | San Joaquin | 77 | 2020-10-21 | 21473 | 488 | |
19379 | 19379 | San Joaquin | San Joaquin | 77 | 2020-10-20 | 21436 | 484 | |
19440 | 19440 | San Joaquin | San Joaquin | 77 | 2020-10-19 | 21196 | 484 | |
19501 | 19501 | San Joaquin | San Joaquin | 77 | 2020-10-18 | 21187 | 484 | TRUE |
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 );