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

586 rows where county = "Santa Clara" 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

  • Santa Clara · 586 ✖

agency 1

Link rowid agency county fips date ▲ confirmed_cases deaths did_not_update
46 46 Santa Clara Santa Clara 85 2021-09-02 135732 1731  
107 107 Santa Clara Santa Clara 85 2021-09-01 135375 1731  
168 168 Santa Clara Santa Clara 85 2021-08-31 135152 1731  
229 229 Santa Clara Santa Clara 85 2021-08-30 133780 1731  
290 290 Santa Clara Santa Clara 85 2021-08-29 132504 1731 TRUE
351 351 Santa Clara Santa Clara 85 2021-08-28 132504 1731 TRUE
412 412 Santa Clara Santa Clara 85 2021-08-27 132504 1731  
473 473 Santa Clara Santa Clara 85 2021-08-26 131941 1721  
534 534 Santa Clara Santa Clara 85 2021-08-25 131504 1721  
595 595 Santa Clara Santa Clara 85 2021-08-24 131272 1721  
656 656 Santa Clara Santa Clara 85 2021-08-23 130978 1721  
717 717 Santa Clara Santa Clara 85 2021-08-22 130007 1721 TRUE
778 778 Santa Clara Santa Clara 85 2021-08-21 130007 1721 TRUE
839 839 Santa Clara Santa Clara 85 2021-08-20 130007 1721  
900 900 Santa Clara Santa Clara 85 2021-08-19 129630 1716  
961 961 Santa Clara Santa Clara 85 2021-08-18 129066 1716  
1022 1022 Santa Clara Santa Clara 85 2021-08-17 128862 1716  
1083 1083 Santa Clara Santa Clara 85 2021-08-16 128454 1716  
1144 1144 Santa Clara Santa Clara 85 2021-08-15 127446 1716 TRUE
1205 1205 Santa Clara Santa Clara 85 2021-08-14 127446 1716 TRUE
1266 1266 Santa Clara Santa Clara 85 2021-08-13 127446 1716  
1327 1327 Santa Clara Santa Clara 85 2021-08-12 127094 1711  
1388 1388 Santa Clara Santa Clara 85 2021-08-11 126788 1711  
1449 1449 Santa Clara Santa Clara 85 2021-08-10 126504 1711  
1510 1510 Santa Clara Santa Clara 85 2021-08-09 126246 1711  
1571 1571 Santa Clara Santa Clara 85 2021-08-08 125235 1711 TRUE
1632 1632 Santa Clara Santa Clara 85 2021-08-07 125235 1711 TRUE
1693 1693 Santa Clara Santa Clara 85 2021-08-06 125235 1711  
1754 1754 Santa Clara Santa Clara 85 2021-08-05 124954 1709  
1815 1815 Santa Clara Santa Clara 85 2021-08-04 124586 1709  
1876 1876 Santa Clara Santa Clara 85 2021-08-03 124115 1709  
1937 1937 Santa Clara Santa Clara 85 2021-08-02 124115 1709  
1998 1998 Santa Clara Santa Clara 85 2021-08-01 123404 1709 TRUE
2059 2059 Santa Clara Santa Clara 85 2021-07-31 123404 1709 TRUE
2120 2120 Santa Clara Santa Clara 85 2021-07-30 123404 1709  
2181 2181 Santa Clara Santa Clara 85 2021-07-29 123083 1707  
2242 2242 Santa Clara Santa Clara 85 2021-07-28 122821 1707  
2303 2303 Santa Clara Santa Clara 85 2021-07-27 122630 1707  
2364 2364 Santa Clara Santa Clara 85 2021-07-26 122439 1707  
2425 2425 Santa Clara Santa Clara 85 2021-07-25 121767 1707 TRUE
2486 2486 Santa Clara Santa Clara 85 2021-07-24 121767 1707 TRUE
2547 2547 Santa Clara Santa Clara 85 2021-07-23 121767 1707  
2608 2608 Santa Clara Santa Clara 85 2021-07-22 121553 1706  
2669 2669 Santa Clara Santa Clara 85 2021-07-21 121304 1706  
2730 2730 Santa Clara Santa Clara 85 2021-07-20 121159 1706  
2791 2791 Santa Clara Santa Clara 85 2021-07-19 121007 1706  
2852 2852 Santa Clara Santa Clara 85 2021-07-18 120604 1706 TRUE
2913 2913 Santa Clara Santa Clara 85 2021-07-17 120604 1706 TRUE
2974 2974 Santa Clara Santa Clara 85 2021-07-16 120604 1706  
3035 3035 Santa Clara Santa Clara 85 2021-07-15 120447 1702  
3096 3096 Santa Clara Santa Clara 85 2021-07-14 120313 1702  
3157 3157 Santa Clara Santa Clara 85 2021-07-13 120192 1702  
3218 3218 Santa Clara Santa Clara 85 2021-07-12 120095 1702  
3279 3279 Santa Clara Santa Clara 85 2021-07-11 120010 1702  
3340 3340 Santa Clara Santa Clara 85 2021-07-10 119857 1702  
3401 3401 Santa Clara Santa Clara 85 2021-07-09 119758 1702  
3462 3462 Santa Clara Santa Clara 85 2021-07-08 119758 1698  
3523 3523 Santa Clara Santa Clara 85 2021-07-07 119678 1698  
3584 3584 Santa Clara Santa Clara 85 2021-07-06 119623 1698  
3645 3645 Santa Clara Santa Clara 85 2021-07-05 119612 1698  
3706 3706 Santa Clara Santa Clara 85 2021-07-04 119498 1698  
3767 3767 Santa Clara Santa Clara 85 2021-07-03 119448 1698  
3828 3828 Santa Clara Santa Clara 85 2021-07-02 119388 1698 TRUE
3889 3889 Santa Clara Santa Clara 85 2021-07-01 119271 1696  
3950 3950 Santa Clara Santa Clara 85 2021-06-30 119265 1696  
4011 4011 Santa Clara Santa Clara 85 2021-06-29 119237 1696  
4072 4072 Santa Clara Santa Clara 85 2021-06-28 119197 1696  
4133 4133 Santa Clara Santa Clara 85 2021-06-27 119150 1696  
4194 4194 Santa Clara Santa Clara 85 2021-06-26 119130 1696  
4255 4255 Santa Clara Santa Clara 85 2021-06-25 119111 1696  
4316 4316 Santa Clara Santa Clara 85 2021-06-24 119083 1696 TRUE
4377 4377 Santa Clara Santa Clara 85 2021-06-23 119047 1696  
4438 4438 Santa Clara Santa Clara 85 2021-06-22 119018 1696  
4499 4499 Santa Clara Santa Clara 85 2021-06-21 118980 1696  
4560 4560 Santa Clara Santa Clara 85 2021-06-20 118938 1696  
4621 4621 Santa Clara Santa Clara 85 2021-06-19 118922 1696  
4682 4682 Santa Clara Santa Clara 85 2021-06-18 118906 1696  
4743 4743 Santa Clara Santa Clara 85 2021-06-17 118880 1696  
4804 4804 Santa Clara Santa Clara 85 2021-06-16 118837 1696  
4865 4865 Santa Clara Santa Clara 85 2021-06-15 118808 1696  
4926 4926 Santa Clara Santa Clara 85 2021-06-14 118774 1696  
4987 4987 Santa Clara Santa Clara 85 2021-06-13 118757 1695 TRUE
5048 5048 Santa Clara Santa Clara 85 2021-06-12 118736 1695  
5109 5109 Santa Clara Santa Clara 85 2021-06-11 118715 1695  
5170 5170 Santa Clara Santa Clara 85 2021-06-10 118682 1695  
5231 5231 Santa Clara Santa Clara 85 2021-06-09 118646 1695  
5292 5292 Santa Clara Santa Clara 85 2021-06-08 118620 1695  
5353 5353 Santa Clara Santa Clara 85 2021-06-07 118597 1694  
5414 5414 Santa Clara Santa Clara 85 2021-06-06 118569 1694  
5475 5475 Santa Clara Santa Clara 85 2021-06-05 118551 1693  
5536 5536 Santa Clara Santa Clara 85 2021-06-04 118529 1693  
5597 5597 Santa Clara Santa Clara 85 2021-06-03 118490 1692  
5658 5658 Santa Clara Santa Clara 85 2021-06-02 118456 1692  
5719 5719 Santa Clara Santa Clara 85 2021-06-01 118418 1692  
5780 5780 Santa Clara Santa Clara 85 2021-05-31 118376 1692  
5841 5841 Santa Clara Santa Clara 85 2021-05-30 118369 1692  
5902 5902 Santa Clara Santa Clara 85 2021-05-29 118345 1691  
5963 5963 Santa Clara Santa Clara 85 2021-05-28 118329 1690  
6024 6024 Santa Clara Santa Clara 85 2021-05-27 118307 1690  
6085 6085 Santa Clara Santa Clara 85 2021-05-26 118275 1690  

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
);