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 did_not_update
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 ▼ |
---|---|---|---|---|---|---|---|---|
103 | 103 | San Joaquin | San Joaquin | 77 | 2021-09-01 | 87365 | 1540 | |
225 | 225 | San Joaquin | San Joaquin | 77 | 2021-08-30 | 85922 | 1528 | |
408 | 408 | San Joaquin | San Joaquin | 77 | 2021-08-27 | 84429 | 1513 | |
530 | 530 | San Joaquin | San Joaquin | 77 | 2021-08-25 | 83466 | 1499 | |
652 | 652 | San Joaquin | San Joaquin | 77 | 2021-08-23 | 83121 | 1498 | |
835 | 835 | San Joaquin | San Joaquin | 77 | 2021-08-20 | 82047 | 1491 | |
957 | 957 | San Joaquin | San Joaquin | 77 | 2021-08-18 | 81300 | 1489 | |
1079 | 1079 | San Joaquin | San Joaquin | 77 | 2021-08-16 | 80832 | 1488 | |
1323 | 1323 | San Joaquin | San Joaquin | 77 | 2021-08-12 | 79641 | 1478 | |
1445 | 1445 | San Joaquin | San Joaquin | 77 | 2021-08-10 | 79641 | 1478 | |
1811 | 1811 | San Joaquin | San Joaquin | 77 | 2021-08-04 | 78119 | 1474 | |
2238 | 2238 | San Joaquin | San Joaquin | 77 | 2021-07-28 | 76915 | 1460 | |
3092 | 3092 | San Joaquin | San Joaquin | 77 | 2021-07-14 | 75500 | 1446 | |
3519 | 3519 | San Joaquin | San Joaquin | 77 | 2021-07-07 | 75133 | 1442 | |
3580 | 3580 | San Joaquin | San Joaquin | 77 | 2021-07-06 | 75133 | 1442 | |
3885 | 3885 | San Joaquin | San Joaquin | 77 | 2021-07-01 | 74900 | 1444 | |
4007 | 4007 | San Joaquin | San Joaquin | 77 | 2021-06-29 | 74900 | 1444 | |
4434 | 4434 | San Joaquin | San Joaquin | 77 | 2021-06-22 | 74808 | 1440 | |
4495 | 4495 | San Joaquin | San Joaquin | 77 | 2021-06-21 | 74727 | 1440 | |
4678 | 4678 | San Joaquin | San Joaquin | 77 | 2021-06-18 | 74686 | 1438 | |
4739 | 4739 | San Joaquin | San Joaquin | 77 | 2021-06-17 | 74629 | 1438 | |
4800 | 4800 | San Joaquin | San Joaquin | 77 | 2021-06-16 | 74596 | 1435 | |
4861 | 4861 | San Joaquin | San Joaquin | 77 | 2021-06-15 | 74559 | 1435 | |
4922 | 4922 | San Joaquin | San Joaquin | 77 | 2021-06-14 | 74419 | 1432 | |
5105 | 5105 | San Joaquin | San Joaquin | 77 | 2021-06-11 | 74401 | 1432 | |
5166 | 5166 | San Joaquin | San Joaquin | 77 | 2021-06-10 | 74350 | 1429 | |
5227 | 5227 | San Joaquin | San Joaquin | 77 | 2021-06-09 | 74287 | 1428 | |
5288 | 5288 | San Joaquin | San Joaquin | 77 | 2021-06-08 | 74257 | 1426 | |
5349 | 5349 | San Joaquin | San Joaquin | 77 | 2021-06-07 | 74161 | 1423 | |
5532 | 5532 | San Joaquin | San Joaquin | 77 | 2021-06-04 | 74114 | 1423 | |
5593 | 5593 | San Joaquin | San Joaquin | 77 | 2021-06-03 | 74060 | 1423 | |
5654 | 5654 | San Joaquin | San Joaquin | 77 | 2021-06-02 | 73968 | 1423 | |
5715 | 5715 | San Joaquin | San Joaquin | 77 | 2021-06-01 | 73899 | 1419 | |
5837 | 5837 | San Joaquin | San Joaquin | 77 | 2021-05-30 | 73794 | 1419 | |
5959 | 5959 | San Joaquin | San Joaquin | 77 | 2021-05-28 | 73794 | 1419 | |
6020 | 6020 | San Joaquin | San Joaquin | 77 | 2021-05-27 | 73794 | 1419 | |
6081 | 6081 | San Joaquin | San Joaquin | 77 | 2021-05-26 | 73758 | 1419 | |
6142 | 6142 | San Joaquin | San Joaquin | 77 | 2021-05-25 | 73717 | 1419 | |
6203 | 6203 | San Joaquin | San Joaquin | 77 | 2021-05-24 | 73617 | 1403 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
11083 | 11083 | San Joaquin | San Joaquin | 77 | 2021-03-05 | 67284 | 1182 | |
11144 | 11144 | San Joaquin | San Joaquin | 77 | 2021-03-04 | 67213 | 1177 |
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 );