latimes_agency_totals

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

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

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: did_not_update, date (date)

fips 1

county 1

agency 1

  • San Joaquin · 551 ✖
Link rowid agency county fips date ▲ confirmed_cases deaths did_not_update
42 42 San Joaquin San Joaquin 77 2021-09-02 87365 1540 TRUE
103 103 San Joaquin San Joaquin 77 2021-09-01 87365 1540  
164 164 San Joaquin San Joaquin 77 2021-08-31 85922 1528 TRUE
225 225 San Joaquin San Joaquin 77 2021-08-30 85922 1528  
286 286 San Joaquin San Joaquin 77 2021-08-29 84429 1513 TRUE
347 347 San Joaquin San Joaquin 77 2021-08-28 84429 1513 TRUE
408 408 San Joaquin San Joaquin 77 2021-08-27 84429 1513  
469 469 San Joaquin San Joaquin 77 2021-08-26 83466 1499 TRUE
530 530 San Joaquin San Joaquin 77 2021-08-25 83466 1499  
591 591 San Joaquin San Joaquin 77 2021-08-24 83121 1498 TRUE
652 652 San Joaquin San Joaquin 77 2021-08-23 83121 1498  
713 713 San Joaquin San Joaquin 77 2021-08-22 82047 1491 TRUE
774 774 San Joaquin San Joaquin 77 2021-08-21 82047 1491 TRUE
835 835 San Joaquin San Joaquin 77 2021-08-20 82047 1491  
896 896 San Joaquin San Joaquin 77 2021-08-19 81300 1489 TRUE
957 957 San Joaquin San Joaquin 77 2021-08-18 81300 1489  
1018 1018 San Joaquin San Joaquin 77 2021-08-17 80832 1488 TRUE
1079 1079 San Joaquin San Joaquin 77 2021-08-16 80832 1488  
1140 1140 San Joaquin San Joaquin 77 2021-08-15 79641 1478 TRUE
1201 1201 San Joaquin San Joaquin 77 2021-08-14 79641 1478 TRUE
1262 1262 San Joaquin San Joaquin 77 2021-08-13 79641 1478 TRUE
1323 1323 San Joaquin San Joaquin 77 2021-08-12 79641 1478  
1384 1384 San Joaquin San Joaquin 77 2021-08-11 79641 1478 TRUE
1445 1445 San Joaquin San Joaquin 77 2021-08-10 79641 1478  
1506 1506 San Joaquin San Joaquin 77 2021-08-09 78119 1474 TRUE
1567 1567 San Joaquin San Joaquin 77 2021-08-08 78119 1474 TRUE
1628 1628 San Joaquin San Joaquin 77 2021-08-07 78119 1474 TRUE
1689 1689 San Joaquin San Joaquin 77 2021-08-06 78119 1474 TRUE
1750 1750 San Joaquin San Joaquin 77 2021-08-05 78119 1474 TRUE
1811 1811 San Joaquin San Joaquin 77 2021-08-04 78119 1474  
1872 1872 San Joaquin San Joaquin 77 2021-08-03 76915 1460 TRUE
1933 1933 San Joaquin San Joaquin 77 2021-08-02 76915 1460 TRUE
1994 1994 San Joaquin San Joaquin 77 2021-08-01 76915 1460 TRUE
2055 2055 San Joaquin San Joaquin 77 2021-07-31 76915 1460 TRUE
2116 2116 San Joaquin San Joaquin 77 2021-07-30 76915 1460 TRUE
2177 2177 San Joaquin San Joaquin 77 2021-07-29 76915 1460 TRUE
2238 2238 San Joaquin San Joaquin 77 2021-07-28 76915 1460  
2299 2299 San Joaquin San Joaquin 77 2021-07-27 76034 1446 TRUE
2360 2360 San Joaquin San Joaquin 77 2021-07-26 76034 1446 TRUE
2421 2421 San Joaquin San Joaquin 77 2021-07-25 76034 1446 TRUE
2482 2482 San Joaquin San Joaquin 77 2021-07-24 76034 1446 TRUE
2543 2543 San Joaquin San Joaquin 77 2021-07-23 76034 1446 TRUE
2604 2604 San Joaquin San Joaquin 77 2021-07-22 76034 1446 TRUE
2665 2665 San Joaquin San Joaquin 77 2021-07-21 76034 1446 TRUE
2726 2726 San Joaquin San Joaquin 77 2021-07-20 76034 1446 TRUE
2787 2787 San Joaquin San Joaquin 77 2021-07-19 75500 1446 TRUE
2848 2848 San Joaquin San Joaquin 77 2021-07-18 76034 1446 TRUE
2909 2909 San Joaquin San Joaquin 77 2021-07-17 75500 1446 TRUE
2970 2970 San Joaquin San Joaquin 77 2021-07-16 75500 1446 TRUE
3031 3031 San Joaquin San Joaquin 77 2021-07-15 75500 1446 TRUE
3092 3092 San Joaquin San Joaquin 77 2021-07-14 75500 1446  
3153 3153 San Joaquin San Joaquin 77 2021-07-13 75133 1442 TRUE
3214 3214 San Joaquin San Joaquin 77 2021-07-12 75133 1442 TRUE
3275 3275 San Joaquin San Joaquin 77 2021-07-11 75133 1442 TRUE
3336 3336 San Joaquin San Joaquin 77 2021-07-10 75133 1442 TRUE
3397 3397 San Joaquin San Joaquin 77 2021-07-09 75133 1442 TRUE
3458 3458 San Joaquin San Joaquin 77 2021-07-08 75133 1442 TRUE
3519 3519 San Joaquin San Joaquin 77 2021-07-07 75133 1442  
3580 3580 San Joaquin San Joaquin 77 2021-07-06 75133 1442  
3641 3641 San Joaquin San Joaquin 77 2021-07-05 74900 1442 TRUE
3702 3702 San Joaquin San Joaquin 77 2021-07-04 74900 1444 TRUE
3763 3763 San Joaquin San Joaquin 77 2021-07-03 74900 1444 TRUE
3824 3824 San Joaquin San Joaquin 77 2021-07-02 74900 1444 TRUE
3885 3885 San Joaquin San Joaquin 77 2021-07-01 74900 1444  
3946 3946 San Joaquin San Joaquin 77 2021-06-30 74900 1444 TRUE
4007 4007 San Joaquin San Joaquin 77 2021-06-29 74900 1444  
4068 4068 San Joaquin San Joaquin 77 2021-06-28 74808 1440 TRUE
4129 4129 San Joaquin San Joaquin 77 2021-06-27 74808 1440 TRUE
4190 4190 San Joaquin San Joaquin 77 2021-06-26 74808 1440 TRUE
4251 4251 San Joaquin San Joaquin 77 2021-06-25 74808 1440 TRUE
4312 4312 San Joaquin San Joaquin 77 2021-06-24 74808 1440 TRUE
4373 4373 San Joaquin San Joaquin 77 2021-06-23 74808 1440 TRUE
4434 4434 San Joaquin San Joaquin 77 2021-06-22 74808 1440  
4495 4495 San Joaquin San Joaquin 77 2021-06-21 74727 1440  
4556 4556 San Joaquin San Joaquin 77 2021-06-20 74686 1438 TRUE
4617 4617 San Joaquin San Joaquin 77 2021-06-19 74686 1438 TRUE
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  
4983 4983 San Joaquin San Joaquin 77 2021-06-13 74401 1432 TRUE
5044 5044 San Joaquin San Joaquin 77 2021-06-12 74401 1432 TRUE
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  
5410 5410 San Joaquin San Joaquin 77 2021-06-06 74114 1423 TRUE
5471 5471 San Joaquin San Joaquin 77 2021-06-05 74114 1423 TRUE
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  
5776 5776 San Joaquin San Joaquin 77 2021-05-31 73794 1419 TRUE
5837 5837 San Joaquin San Joaquin 77 2021-05-30 73794 1419  
5898 5898 San Joaquin San Joaquin 77 2021-05-29 73794 1419 TRUE
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  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [latimes_agency_totals] (
   [agency] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [date] TEXT,
   [confirmed_cases] INTEGER,
   [deaths] INTEGER,
   [did_not_update] TEXT
);