latimes_county_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_county_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: new_deaths, date (date)

fips 1

county 1

  • Santa Clara · 586 ✖
Link rowid date ▲ county fips confirmed_cases deaths new_confirmed_cases new_deaths
43 43 2021-09-02 Santa Clara 85 135732 1731 357 0
101 101 2021-09-01 Santa Clara 85 135375 1731 223 0
159 159 2021-08-31 Santa Clara 85 135152 1731 1372 0
217 217 2021-08-30 Santa Clara 85 133780 1731 1276 0
275 275 2021-08-29 Santa Clara 85 132504 1731 0 0
333 333 2021-08-28 Santa Clara 85 132504 1731 0 0
391 391 2021-08-27 Santa Clara 85 132504 1731 563 10
449 449 2021-08-26 Santa Clara 85 131941 1721 437 0
507 507 2021-08-25 Santa Clara 85 131504 1721 232 0
565 565 2021-08-24 Santa Clara 85 131272 1721 294 0
623 623 2021-08-23 Santa Clara 85 130978 1721 971 0
681 681 2021-08-22 Santa Clara 85 130007 1721 0 0
739 739 2021-08-21 Santa Clara 85 130007 1721 0 0
797 797 2021-08-20 Santa Clara 85 130007 1721 377 5
855 855 2021-08-19 Santa Clara 85 129630 1716 564 0
913 913 2021-08-18 Santa Clara 85 129066 1716 204 0
971 971 2021-08-17 Santa Clara 85 128862 1716 408 0
1029 1029 2021-08-16 Santa Clara 85 128454 1716 1008 0
1087 1087 2021-08-15 Santa Clara 85 127446 1716 0 0
1145 1145 2021-08-14 Santa Clara 85 127446 1716 0 0
1203 1203 2021-08-13 Santa Clara 85 127446 1716 352 5
1261 1261 2021-08-12 Santa Clara 85 127094 1711 306 0
1319 1319 2021-08-11 Santa Clara 85 126788 1711 284 0
1377 1377 2021-08-10 Santa Clara 85 126504 1711 258 0
1435 1435 2021-08-09 Santa Clara 85 126246 1711 1011 0
1493 1493 2021-08-08 Santa Clara 85 125235 1711 0 0
1551 1551 2021-08-07 Santa Clara 85 125235 1711 0 0
1609 1609 2021-08-06 Santa Clara 85 125235 1711 281 2
1667 1667 2021-08-05 Santa Clara 85 124954 1709 368 0
1725 1725 2021-08-04 Santa Clara 85 124586 1709 471 0
1783 1783 2021-08-03 Santa Clara 85 124115 1709 0 0
1841 1841 2021-08-02 Santa Clara 85 124115 1709 711 0
1899 1899 2021-08-01 Santa Clara 85 123404 1709 0 0
1957 1957 2021-07-31 Santa Clara 85 123404 1709 0 0
2015 2015 2021-07-30 Santa Clara 85 123404 1709 321 2
2073 2073 2021-07-29 Santa Clara 85 123083 1707 262 0
2131 2131 2021-07-28 Santa Clara 85 122821 1707 191 0
2189 2189 2021-07-27 Santa Clara 85 122630 1707 191 0
2247 2247 2021-07-26 Santa Clara 85 122439 1707 672 0
2305 2305 2021-07-25 Santa Clara 85 121767 1707 0 0
2363 2363 2021-07-24 Santa Clara 85 121767 1707 0 0
2421 2421 2021-07-23 Santa Clara 85 121767 1707 214 1
2479 2479 2021-07-22 Santa Clara 85 121553 1706 249 0
2537 2537 2021-07-21 Santa Clara 85 121304 1706 145 0
2595 2595 2021-07-20 Santa Clara 85 121159 1706 152 0
2653 2653 2021-07-19 Santa Clara 85 121007 1706 403 0
2711 2711 2021-07-18 Santa Clara 85 120604 1706 0 0
2769 2769 2021-07-17 Santa Clara 85 120604 1706 0 0
2827 2827 2021-07-16 Santa Clara 85 120604 1706 157 4
2885 2885 2021-07-15 Santa Clara 85 120447 1702 134 0
2943 2943 2021-07-14 Santa Clara 85 120313 1702 121 0
3001 3001 2021-07-13 Santa Clara 85 120192 1702 97 0
3059 3059 2021-07-12 Santa Clara 85 120095 1702 85 0
3117 3117 2021-07-11 Santa Clara 85 120010 1702 153 0
3175 3175 2021-07-10 Santa Clara 85 119857 1702 99 0
3233 3233 2021-07-09 Santa Clara 85 119758 1702 0 4
3291 3291 2021-07-08 Santa Clara 85 119758 1698 80 0
3349 3349 2021-07-07 Santa Clara 85 119678 1698 55 0
3407 3407 2021-07-06 Santa Clara 85 119623 1698 11 0
3465 3465 2021-07-05 Santa Clara 85 119612 1698 114 0
3523 3523 2021-07-04 Santa Clara 85 119498 1698 50 0
3581 3581 2021-07-03 Santa Clara 85 119448 1698 60 0
3639 3639 2021-07-02 Santa Clara 85 119388 1698 117 2
3697 3697 2021-07-01 Santa Clara 85 119271 1696 6 0
3755 3755 2021-06-30 Santa Clara 85 119265 1696 28 0
3813 3813 2021-06-29 Santa Clara 85 119237 1696 40 0
3871 3871 2021-06-28 Santa Clara 85 119197 1696 47 0
3929 3929 2021-06-27 Santa Clara 85 119150 1696 20 0
3987 3987 2021-06-26 Santa Clara 85 119130 1696 19 0
4045 4045 2021-06-25 Santa Clara 85 119111 1696 28 0
4103 4103 2021-06-24 Santa Clara 85 119083 1696 36 0
4161 4161 2021-06-23 Santa Clara 85 119047 1696 29 0
4219 4219 2021-06-22 Santa Clara 85 119018 1696 38 0
4277 4277 2021-06-21 Santa Clara 85 118980 1696 42 0
4335 4335 2021-06-20 Santa Clara 85 118938 1696 16 0
4393 4393 2021-06-19 Santa Clara 85 118922 1696 16 0
4451 4451 2021-06-18 Santa Clara 85 118906 1696 26 0
4509 4509 2021-06-17 Santa Clara 85 118880 1696 43 0
4567 4567 2021-06-16 Santa Clara 85 118837 1696 29 0
4625 4625 2021-06-15 Santa Clara 85 118808 1696 34 0
4683 4683 2021-06-14 Santa Clara 85 118774 1696 17 1
4741 4741 2021-06-13 Santa Clara 85 118757 1695 21 0
4799 4799 2021-06-12 Santa Clara 85 118736 1695 21 0
4857 4857 2021-06-11 Santa Clara 85 118715 1695 33 0
4915 4915 2021-06-10 Santa Clara 85 118682 1695 36 0
4973 4973 2021-06-09 Santa Clara 85 118646 1695 26 0
5031 5031 2021-06-08 Santa Clara 85 118620 1695 23 1
5089 5089 2021-06-07 Santa Clara 85 118597 1694 28 0
5147 5147 2021-06-06 Santa Clara 85 118569 1694 18 1
5205 5205 2021-06-05 Santa Clara 85 118551 1693 22 0
5263 5263 2021-06-04 Santa Clara 85 118529 1693 39 1
5321 5321 2021-06-03 Santa Clara 85 118490 1692 34 0
5379 5379 2021-06-02 Santa Clara 85 118456 1692 38 0
5437 5437 2021-06-01 Santa Clara 85 118418 1692 42 0
5495 5495 2021-05-31 Santa Clara 85 118376 1692 7 0
5553 5553 2021-05-30 Santa Clara 85 118369 1692 24 1
5611 5611 2021-05-29 Santa Clara 85 118345 1691 16 1
5669 5669 2021-05-28 Santa Clara 85 118329 1690 22 0
5727 5727 2021-05-27 Santa Clara 85 118307 1690 32 0
5785 5785 2021-05-26 Santa Clara 85 118275 1690 22 1

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [latimes_county_totals] (
   [date] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [confirmed_cases] INTEGER,
   [deaths] INTEGER,
   [new_confirmed_cases] INTEGER,
   [new_deaths] INTEGER
);