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 |
---|---|---|---|---|---|---|---|---|
6142 | 6142 | San Joaquin | San Joaquin | 77 | 2021-05-25 | 73717 | 1419 | |
6203 | 6203 | San Joaquin | San Joaquin | 77 | 2021-05-24 | 73617 | 1403 | |
6264 | 6264 | San Joaquin | San Joaquin | 77 | 2021-05-23 | 73544 | 1402 | TRUE |
6325 | 6325 | San Joaquin | San Joaquin | 77 | 2021-05-22 | 73544 | 1402 | TRUE |
6386 | 6386 | San Joaquin | San Joaquin | 77 | 2021-05-21 | 73544 | 1402 | |
6447 | 6447 | San Joaquin | San Joaquin | 77 | 2021-05-20 | 73476 | 1402 | |
6508 | 6508 | San Joaquin | San Joaquin | 77 | 2021-05-19 | 73440 | 1400 | |
6569 | 6569 | San Joaquin | San Joaquin | 77 | 2021-05-18 | 73401 | 1399 | |
6630 | 6630 | San Joaquin | San Joaquin | 77 | 2021-05-17 | 73339 | 1394 | |
6691 | 6691 | San Joaquin | San Joaquin | 77 | 2021-05-16 | 73310 | 1394 | TRUE |
6752 | 6752 | San Joaquin | San Joaquin | 77 | 2021-05-15 | 73310 | 1394 | TRUE |
6813 | 6813 | San Joaquin | San Joaquin | 77 | 2021-05-14 | 73310 | 1394 | |
6874 | 6874 | San Joaquin | San Joaquin | 77 | 2021-05-13 | 73267 | 1391 | |
6935 | 6935 | San Joaquin | San Joaquin | 77 | 2021-05-12 | 73220 | 1391 | |
6996 | 6996 | San Joaquin | San Joaquin | 77 | 2021-05-11 | 73180 | 1391 | |
7057 | 7057 | San Joaquin | San Joaquin | 77 | 2021-05-10 | 73174 | 1391 | |
7118 | 7118 | San Joaquin | San Joaquin | 77 | 2021-05-09 | 73009 | 1391 | |
7179 | 7179 | San Joaquin | San Joaquin | 77 | 2021-05-08 | 73009 | 1391 | |
7240 | 7240 | San Joaquin | San Joaquin | 77 | 2021-05-07 | 73009 | 1391 | |
7301 | 7301 | San Joaquin | San Joaquin | 77 | 2021-05-06 | 72942 | 1391 | |
7362 | 7362 | San Joaquin | San Joaquin | 77 | 2021-05-05 | 72784 | 1384 | |
7423 | 7423 | San Joaquin | San Joaquin | 77 | 2021-05-04 | 72724 | 1382 | |
7484 | 7484 | San Joaquin | San Joaquin | 77 | 2021-05-03 | 72672 | 1365 | |
7545 | 7545 | San Joaquin | San Joaquin | 77 | 2021-05-02 | 72478 | 1346 | |
7606 | 7606 | San Joaquin | San Joaquin | 77 | 2021-05-01 | 72478 | 1346 | |
7667 | 7667 | San Joaquin | San Joaquin | 77 | 2021-04-30 | 72478 | 1346 | |
7728 | 7728 | San Joaquin | San Joaquin | 77 | 2021-04-29 | 72395 | 1346 | |
7789 | 7789 | San Joaquin | San Joaquin | 77 | 2021-04-28 | 72345 | 1346 | |
7850 | 7850 | San Joaquin | San Joaquin | 77 | 2021-04-27 | 72281 | 1346 | |
7911 | 7911 | San Joaquin | San Joaquin | 77 | 2021-04-26 | 71987 | 1346 | |
7972 | 7972 | San Joaquin | San Joaquin | 77 | 2021-04-25 | 71972 | 1340 | |
8033 | 8033 | San Joaquin | San Joaquin | 77 | 2021-04-24 | 71972 | 1340 | TRUE |
8094 | 8094 | San Joaquin | San Joaquin | 77 | 2021-04-23 | 71972 | 1340 | |
8155 | 8155 | San Joaquin | San Joaquin | 77 | 2021-04-22 | 71899 | 1340 | |
8216 | 8216 | San Joaquin | San Joaquin | 77 | 2021-04-21 | 71813 | 1340 | |
8277 | 8277 | San Joaquin | San Joaquin | 77 | 2021-04-20 | 71735 | 1334 | |
8338 | 8338 | San Joaquin | San Joaquin | 77 | 2021-04-19 | 71527 | 1334 | |
8399 | 8399 | San Joaquin | San Joaquin | 77 | 2021-04-18 | 71431 | 1334 | TRUE |
8460 | 8460 | San Joaquin | San Joaquin | 77 | 2021-04-17 | 71431 | 1334 | TRUE |
8521 | 8521 | San Joaquin | San Joaquin | 77 | 2021-04-16 | 71431 | 1334 | |
8582 | 8582 | San Joaquin | San Joaquin | 77 | 2021-04-15 | 71338 | 1334 | |
8643 | 8643 | San Joaquin | San Joaquin | 77 | 2021-04-14 | 71229 | 1334 | |
8704 | 8704 | San Joaquin | San Joaquin | 77 | 2021-04-13 | 71178 | 1334 | |
8765 | 8765 | San Joaquin | San Joaquin | 77 | 2021-04-12 | 70994 | 1334 | |
8826 | 8826 | San Joaquin | San Joaquin | 77 | 2021-04-11 | 70746 | 1328 | TRUE |
8887 | 8887 | San Joaquin | San Joaquin | 77 | 2021-04-10 | 70746 | 1328 | TRUE |
8948 | 8948 | San Joaquin | San Joaquin | 77 | 2021-04-09 | 70746 | 1328 | |
9009 | 9009 | San Joaquin | San Joaquin | 77 | 2021-04-08 | 70609 | 1325 | |
9070 | 9070 | San Joaquin | San Joaquin | 77 | 2021-04-07 | 70511 | 1325 | |
9131 | 9131 | San Joaquin | San Joaquin | 77 | 2021-04-06 | 70465 | 1325 | |
9192 | 9192 | San Joaquin | San Joaquin | 77 | 2021-04-05 | 70245 | 1313 | |
9253 | 9253 | San Joaquin | San Joaquin | 77 | 2021-04-04 | 70117 | 1310 | TRUE |
9314 | 9314 | San Joaquin | San Joaquin | 77 | 2021-04-03 | 70117 | 1310 | TRUE |
9375 | 9375 | San Joaquin | San Joaquin | 77 | 2021-04-02 | 70117 | 1310 | |
9436 | 9436 | San Joaquin | San Joaquin | 77 | 2021-04-01 | 69978 | 1300 | |
9497 | 9497 | San Joaquin | San Joaquin | 77 | 2021-03-31 | 69846 | 1300 | |
9558 | 9558 | San Joaquin | San Joaquin | 77 | 2021-03-30 | 69796 | 1278 | |
9619 | 9619 | San Joaquin | San Joaquin | 77 | 2021-03-29 | 69550 | 1259 | |
9680 | 9680 | San Joaquin | San Joaquin | 77 | 2021-03-28 | 69448 | 1250 | TRUE |
9741 | 9741 | San Joaquin | San Joaquin | 77 | 2021-03-27 | 69448 | 1250 | TRUE |
9802 | 9802 | San Joaquin | San Joaquin | 77 | 2021-03-26 | 69448 | 1250 | |
9863 | 9863 | San Joaquin | San Joaquin | 77 | 2021-03-25 | 69295 | 1244 | |
9924 | 9924 | San Joaquin | San Joaquin | 77 | 2021-03-24 | 69187 | 1244 | |
9985 | 9985 | San Joaquin | San Joaquin | 77 | 2021-03-23 | 69112 | 1231 | |
10046 | 10046 | San Joaquin | San Joaquin | 77 | 2021-03-22 | 68855 | 1231 | |
10107 | 10107 | San Joaquin | San Joaquin | 77 | 2021-03-21 | 68714 | 1229 | TRUE |
10168 | 10168 | San Joaquin | San Joaquin | 77 | 2021-03-20 | 68714 | 1229 | TRUE |
10229 | 10229 | San Joaquin | San Joaquin | 77 | 2021-03-19 | 68714 | 1229 | |
10290 | 10290 | San Joaquin | San Joaquin | 77 | 2021-03-18 | 68551 | 1216 | |
10351 | 10351 | San Joaquin | San Joaquin | 77 | 2021-03-17 | 68301 | 1213 | |
10412 | 10412 | San Joaquin | San Joaquin | 77 | 2021-03-16 | 68036 | 1212 | |
10473 | 10473 | San Joaquin | San Joaquin | 77 | 2021-03-15 | 67817 | 1210 | TRUE |
10534 | 10534 | San Joaquin | San Joaquin | 77 | 2021-03-14 | 67817 | 1210 | TRUE |
10595 | 10595 | San Joaquin | San Joaquin | 77 | 2021-03-13 | 67817 | 1210 | TRUE |
10656 | 10656 | San Joaquin | San Joaquin | 77 | 2021-03-12 | 67817 | 1210 | |
10717 | 10717 | San Joaquin | San Joaquin | 77 | 2021-03-11 | 67817 | 1210 | |
10778 | 10778 | San Joaquin | San Joaquin | 77 | 2021-03-10 | 67754 | 1208 | |
10839 | 10839 | San Joaquin | San Joaquin | 77 | 2021-03-09 | 67657 | 1199 | |
10900 | 10900 | San Joaquin | San Joaquin | 77 | 2021-03-08 | 67395 | 1189 | |
10961 | 10961 | San Joaquin | San Joaquin | 77 | 2021-03-07 | 67284 | 1182 | TRUE |
11022 | 11022 | San Joaquin | San Joaquin | 77 | 2021-03-06 | 67284 | 1182 | TRUE |
11083 | 11083 | San Joaquin | San Joaquin | 77 | 2021-03-05 | 67284 | 1182 | |
11144 | 11144 | San Joaquin | San Joaquin | 77 | 2021-03-04 | 67213 | 1177 | |
11205 | 11205 | San Joaquin | San Joaquin | 77 | 2021-03-03 | 67123 | 1150 | |
11266 | 11266 | San Joaquin | San Joaquin | 77 | 2021-03-02 | 67040 | 1140 | |
11327 | 11327 | San Joaquin | San Joaquin | 77 | 2021-03-01 | 66829 | 1126 | |
11388 | 11388 | San Joaquin | San Joaquin | 77 | 2021-02-28 | 66709 | 1101 | TRUE |
11449 | 11449 | San Joaquin | San Joaquin | 77 | 2021-02-27 | 66709 | 1101 | TRUE |
11510 | 11510 | San Joaquin | San Joaquin | 77 | 2021-02-26 | 66709 | 1101 | |
11571 | 11571 | San Joaquin | San Joaquin | 77 | 2021-02-25 | 66569 | 1082 | |
11632 | 11632 | San Joaquin | San Joaquin | 77 | 2021-02-24 | 66462 | 1061 | |
11693 | 11693 | San Joaquin | San Joaquin | 77 | 2021-02-23 | 66290 | 1042 | |
11754 | 11754 | San Joaquin | San Joaquin | 77 | 2021-02-22 | 66046 | 1039 | |
11815 | 11815 | San Joaquin | San Joaquin | 77 | 2021-02-21 | 65891 | 1026 | TRUE |
11876 | 11876 | San Joaquin | San Joaquin | 77 | 2021-02-20 | 65891 | 1026 | TRUE |
11937 | 11937 | San Joaquin | San Joaquin | 77 | 2021-02-19 | 65891 | 1026 | |
11998 | 11998 | San Joaquin | San Joaquin | 77 | 2021-02-18 | 65705 | 1021 | |
12059 | 12059 | San Joaquin | San Joaquin | 77 | 2021-02-17 | 65659 | 1018 | |
12120 | 12120 | San Joaquin | San Joaquin | 77 | 2021-02-16 | 65359 | 1018 | |
12181 | 12181 | San Joaquin | San Joaquin | 77 | 2021-02-15 | 64969 | 992 | 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 );