latimes_county_totals
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
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, new_confirmed_cases, new_deaths, date (date)
confirmed_cases 545 ✖
- 6 17
- 8 6
- 7 3
- 120604 3
- 121767 3
- 123404 3
- 125235 3
- 127446 3
- 130007 3
- 132504 3
- 10 2
- 16 2
- 119758 2
- 124115 2
- 0 1
- 1 1
- 2 1
- 3 1
- 4 1
- 12 1
- 21 1
- 23 1
- 28 1
- 35 1
- 45 1
- 53 1
- 57 1
- 74 1
- 89 1
- 115 1
- 138 1
- 186 1
- 229 1
- 261 1
- 298 1
- 351 1
- 396 1
- 442 1
- 506 1
- 542 1
- 583 1
- 662 1
- 734 1
- 812 1
- 887 1
- 954 1
- 994 1
- 1018 1
- 1096 1
- 1147 1
- 1197 1
- 1250 1
- 1293 1
- 1326 1
- 1369 1
- 1422 1
- 1463 1
- 1535 1
- 1603 1
- 1685 1
- 1726 1
- 1750 1
- 1791 1
- 1835 1
- 1865 1
- 1892 1
- 1934 1
- 1949 1
- 1963 1
- 1988 1
- 2014 1
- 2063 1
- 2083 1
- 2113 1
- 2127 1
- 2138 1
- 2162 1
- 2184 1
- 2212 1
- 2223 1
- 2244 1
- 2256 1
- 2264 1
- 2283 1
- 2296 1
- 2324 1
- 2336 1
- 2360 1
- 2371 1
- 2374 1
- 2394 1
- 2409 1
- 2429 1
- 2453 1
- 2468 1
- 2483 1
- 2490 1
- 2529 1
- 2573 1
- 2609 1
- 2630 1
- 2656 1
- 2673 1
- 2675 1
- 2682 1
- 2714 1
- 2753 1
- 2776 1
- 2820 1
- 2836 1
- 2846 1
- 2880 1
- 2905 1
- 2947 1
- 2984 1
- 3020 1
- 3033 1
- 3051 1
- 3090 1
- 3137 1
- 3200 1
- 3250 1
- 3308 1
- 3329 1
- 3342 1
- 3404 1
- 3499 1
- 3592 1
- 3694 1
- 3804 1
- 3854 1
- 3891 1
- 3997 1
- 4188 1
- 4335 1
- 4472 1
- 4607 1
- 4718 1
- 4779 1
- 4919 1
- 5107 1
- 5291 1
- 5476 1
- 5555 1
- 5599 1
- 5696 1
- 5950 1
- 6242 1
- 6530 1
- 6811 1
- 7055 1
- 7237 1
- 7356 1
- 7562 1
- 7916 1
- 8302 1
- 8642 1
- 8941 1
- 9111 1
- 9198 1
- 9414 1
- 9726 1
- 10027 1
- 10309 1
- 10555 1
- 10682 1
- 10768 1
- 10944 1
- 11242 1
- 11515 1
- 11757 1
- 12019 1
- 12192 1
- 12276 1
- 12446 1
- 12748 1
- 13081 1
- 13326 1
- 13585 1
- 13792 1
- 13903 1
- 14127 1
- 14458 1
- 14742 1
- 14985 1
- 15239 1
- 15395 1
- 15466 1
- 15652 1
- 15919 1
- 16091 1
- 16253 1
- 16419 1
- 16557 1
- 16617 1
- 16773 1
- 17062 1
- 17290 1
- 17489 1
- 17680 1
- 17821 1
- 17877 1
- 18025 1
- 18259 1
- 18489 1
- 18658 1
- 18835 1
- 18925 1
- 18970 1
- 19011 1
- 19204 1
- 19411 1
- 19556 1
- 19688 1
- 19772 1
- 19805 1
- 19930 1
- 20156 1
- 20306 1
- 20482 1
- 20613 1
- 20684 1
- 20726 1
- 20848 1
- 20994 1
- 21132 1
- 21250 1
- 21353 1
- 21405 1
- 21445 1
- 21542 1
- 21687 1
- 21805 1
- 21927 1
- 22048 1
- 22114 1
- 22157 1
- 22242 1
- 22391 1
- 22521 1
- 22648 1
- 22761 1
- 22849 1
- 22893 1
- 23028 1
- 23178 1
- 23322 1
- 23482 1
- 23593 1
- 23659 1
- 23699 1
- 23839 1
- 24038 1
- 24185 1
- 24317 1
- 24462 1
- 24531 1
- 24587 1
- 24745 1
- 24946 1
- 25115 1
- 25258 1
- 25406 1
- 25504 1
- 25560 1
- 25780 1
- 26060 1
- 26360 1
- 26623 1
- 26881 1
- 27092 1
- 27178 1
- 27477 1
- 27905 1
- 28250 1
- 28695 1
- 29075 1
- 29339 1
- 29457 1
- 29773 1
- 30338 1
- 30914 1
- 31429 1
- 31980 1
- 32322 1
- 32595 1
- 33229 1
- 33918 1
- 34759 1
- 34912 1
- 35441 1
- 36000 1
- 36512 1
- 37454 1
- 38752 1
- 40106 1
- 41338 1
- 42564 1
- 43378 1
- 43874 1
- 45159 1
- 46718 1
- 48256 1
- 49591 1
- 50702 1
- 51525 1
- 52290 1
- 53542 1
- 55381 1
- 57027 1
- 58525 1
- 59717 1
- 60465 1
- 61067 1
- 62595 1
- 64041 1
- 65483 1
- 66229 1
- 66440 1
- 67435 1
- 68245 1
- 70069 1
- 71885 1
- 73787 1
- 74957 1
- 75231 1
- 76215 1
- 77138 1
- 78751 1
- 81002 1
- 82817 1
- 84441 1
- 85584 1
- 86454 1
- 87150 1
- 88435 1
- 89921 1
- 91224 1
- 92387 1
- 93386 1
- 94007 1
- 94475 1
- 95212 1
- 96234 1
- 97120 1
- 97900 1
- 98519 1
- 98941 1
- 99286 1
- 99911 1
- 100453 1
- 100984 1
- 101401 1
- 101909 1
- 102290 1
- 102566 1
- 103112 1
- 103566 1
- 104058 1
- 104455 1
- 104850 1
- 105094 1
- 105275 1
- 105627 1
- 106038 1
- 106413 1
- 106716 1
- 106982 1
- 107134 1
- 107320 1
- 107507 1
- 107748 1
- 108012 1
- 108284 1
- 108516 1
- 108691 1
- 108856 1
- 109119 1
- 109337 1
- 109597 1
- 109762 1
- 109919 1
- 110053 1
- 110176 1
- 110379 1
- 110561 1
- 110755 1
- 110918 1
- 111072 1
- 111159 1
- 111237 1
- 111405 1
- 111556 1
- 111691 1
- 111811 1
- 111924 1
- 112019 1
- 112085 1
- 112221 1
- 112338 1
- 112490 1
- 112597 1
- 112711 1
- 112778 1
- 112853 1
- 112965 1
- 113084 1
- 113209 1
- 113343 1
- 113470 1
- 113537 1
- 113603 1
- 113719 1
- 113811 1
- 113955 1
- 114079 1
- 114182 1
- 114254 1
- 114312 1
- 114509 1
- 114676 1
- 114846 1
- 115005 1
- 115137 1
- 115237 1
- 115302 1
- 115445 1
- 115565 1
- 115714 1
- 115855 1
- 115970 1
- 116064 1
- 116144 1
- 116278 1
- 116402 1
- 116524 1
- 116603 1
- 116698 1
- 116760 1
- 116811 1
- 116886 1
- 116993 1
- 117055 1
- 117137 1
- 117202 1
- 117250 1
- 117298 1
- 117370 1
- 117455 1
- 117525 1
- 117570 1
- 117623 1
- 117649 1
- 117676 1
- 117717 1
- 117787 1
- 117838 1
- 117896 1
- 117940 1
- 117963 1
- 117991 1
- 118019 1
- 118059 1
- 118086 1
- 118132 1
- 118152 1
- 118180 1
- 118197 1
- 118221 1
- 118253 1
- 118275 1
- 118307 1
- 118329 1
- 118345 1
- 118369 1
- 118376 1
- 118418 1
- 118456 1
- 118490 1
- 118529 1
- 118551 1
- 118569 1
- 118597 1
- 118620 1
- 118646 1
- 118682 1
- 118715 1
- 118736 1
- 118757 1
- 118774 1
- 118808 1
- 118837 1
- 118880 1
- 118906 1
- 118922 1
- 118938 1
- 118980 1
- 119018 1
- 119047 1
- 119083 1
- 119111 1
- 119130 1
- 119150 1
- 119197 1
- 119237 1
- 119265 1
- 119271 1
- 119388 1
- 119448 1
- 119498 1
- 119612 1
- 119623 1
- 119678 1
- 119857 1
- 120010 1
- 120095 1
- 120192 1
- 120313 1
- 120447 1
- 121007 1
- 121159 1
- 121304 1
- 121553 1
- 122439 1
- 122630 1
- 122821 1
- 123083 1
- 124586 1
- 124954 1
- 126246 1
- 126504 1
- 126788 1
- 127094 1
- 128454 1
- 128862 1
- 129066 1
- 129630 1
- 130978 1
- 131272 1
- 131504 1
- 131941 1
- 133780 1
- 135152 1
- 135375 1
- 135732 1
fips 1
- 85 586
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 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_county_totals] ( [date] TEXT, [county] TEXT, [fips] INTEGER, [confirmed_cases] INTEGER, [deaths] INTEGER, [new_confirmed_cases] INTEGER, [new_deaths] INTEGER );