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 deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: new_deaths, date (date)
Link | rowid | date | county | fips | confirmed_cases | deaths ▼ | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
31273 | 31273 | 2020-02-05 | Santa Clara | 85 | 6 | 0 | 0 | 0 |
31277 | 31277 | 2020-02-04 | Santa Clara | 85 | 6 | 0 | 0 | 0 |
31281 | 31281 | 2020-02-03 | Santa Clara | 85 | 6 | 0 | 0 | 0 |
31296 | 31296 | 2020-02-02 | Santa Clara | 85 | 6 | 0 | 0 | 0 |
31306 | 31306 | 2020-02-01 | Santa Clara | 85 | 6 | 0 | 0 | 0 |
31321 | 31321 | 2020-01-31 | Santa Clara | 85 | 6 | 0 | 2 | 0 |
31331 | 31331 | 2020-01-30 | Santa Clara | 85 | 4 | 0 | 1 | 0 |
31334 | 31334 | 2020-01-29 | Santa Clara | 85 | 3 | 0 | 1 | 0 |
31337 | 31337 | 2020-01-28 | Santa Clara | 85 | 2 | 0 | 1 | 0 |
31340 | 31340 | 2020-01-27 | Santa Clara | 85 | 1 | 0 | 1 | 0 |
31355 | 31355 | 2020-01-26 | Santa Clara | 85 | 0 | 0 | ||
31229 | 31229 | 2020-02-16 | Santa Clara | 85 | 6 | 1 | 0 | 0 |
31233 | 31233 | 2020-02-15 | Santa Clara | 85 | 6 | 1 | 0 | 0 |
31237 | 31237 | 2020-02-14 | Santa Clara | 85 | 6 | 1 | 0 | 0 |
31241 | 31241 | 2020-02-13 | Santa Clara | 85 | 6 | 1 | 0 | 0 |
31245 | 31245 | 2020-02-12 | Santa Clara | 85 | 6 | 1 | 0 | 0 |
31249 | 31249 | 2020-02-11 | Santa Clara | 85 | 6 | 1 | 0 | 0 |
31253 | 31253 | 2020-02-10 | Santa Clara | 85 | 6 | 1 | 0 | 0 |
31257 | 31257 | 2020-02-09 | Santa Clara | 85 | 6 | 1 | 0 | 0 |
31261 | 31261 | 2020-02-08 | Santa Clara | 85 | 6 | 1 | 0 | 0 |
31265 | 31265 | 2020-02-07 | Santa Clara | 85 | 6 | 1 | 0 | 0 |
31269 | 31269 | 2020-02-06 | Santa Clara | 85 | 6 | 1 | 0 | 1 |
30965 | 30965 | 2020-03-05 | Santa Clara | 85 | 35 | 2 | 7 | 0 |
30989 | 30989 | 2020-03-04 | Santa Clara | 85 | 28 | 2 | 5 | 0 |
31013 | 31013 | 2020-03-03 | Santa Clara | 85 | 23 | 2 | 2 | 0 |
31037 | 31037 | 2020-03-02 | Santa Clara | 85 | 21 | 2 | 5 | 0 |
31061 | 31061 | 2020-03-01 | Santa Clara | 85 | 16 | 2 | 0 | 0 |
31084 | 31084 | 2020-02-29 | Santa Clara | 85 | 16 | 2 | 4 | 0 |
31107 | 31107 | 2020-02-28 | Santa Clara | 85 | 12 | 2 | 2 | 0 |
31121 | 31121 | 2020-02-27 | Santa Clara | 85 | 10 | 2 | 0 | 0 |
31138 | 31138 | 2020-02-26 | Santa Clara | 85 | 10 | 2 | 2 | 0 |
31151 | 31151 | 2020-02-25 | Santa Clara | 85 | 8 | 2 | 0 | 0 |
31157 | 31157 | 2020-02-24 | Santa Clara | 85 | 8 | 2 | 0 | 0 |
31163 | 31163 | 2020-02-23 | Santa Clara | 85 | 8 | 2 | 0 | 0 |
31169 | 31169 | 2020-02-22 | Santa Clara | 85 | 8 | 2 | 0 | 0 |
31184 | 31184 | 2020-02-21 | Santa Clara | 85 | 8 | 2 | 0 | 0 |
31206 | 31206 | 2020-02-20 | Santa Clara | 85 | 8 | 2 | 1 | 0 |
31217 | 31217 | 2020-02-19 | Santa Clara | 85 | 7 | 2 | 0 | 0 |
31221 | 31221 | 2020-02-18 | Santa Clara | 85 | 7 | 2 | 0 | 0 |
31225 | 31225 | 2020-02-17 | Santa Clara | 85 | 7 | 2 | 1 | 1 |
30892 | 30892 | 2020-03-08 | Santa Clara | 85 | 57 | 3 | 4 | 0 |
30917 | 30917 | 2020-03-07 | Santa Clara | 85 | 53 | 3 | 8 | 0 |
30941 | 30941 | 2020-03-06 | Santa Clara | 85 | 45 | 3 | 10 | 1 |
30789 | 30789 | 2020-03-12 | Santa Clara | 85 | 138 | 5 | 23 | 0 |
30816 | 30816 | 2020-03-11 | Santa Clara | 85 | 115 | 5 | 26 | 0 |
30842 | 30842 | 2020-03-10 | Santa Clara | 85 | 89 | 5 | 15 | 0 |
30867 | 30867 | 2020-03-09 | Santa Clara | 85 | 74 | 5 | 17 | 2 |
30734 | 30734 | 2020-03-14 | Santa Clara | 85 | 229 | 6 | 43 | 0 |
30762 | 30762 | 2020-03-13 | Santa Clara | 85 | 186 | 6 | 48 | 1 |
30705 | 30705 | 2020-03-15 | Santa Clara | 85 | 261 | 7 | 32 | 1 |
30642 | 30642 | 2020-03-17 | Santa Clara | 85 | 351 | 10 | 53 | 0 |
30674 | 30674 | 2020-03-16 | Santa Clara | 85 | 298 | 10 | 37 | 3 |
30538 | 30538 | 2020-03-20 | Santa Clara | 85 | 506 | 12 | 64 | 0 |
30573 | 30573 | 2020-03-19 | Santa Clara | 85 | 442 | 12 | 46 | 0 |
30608 | 30608 | 2020-03-18 | Santa Clara | 85 | 396 | 12 | 45 | 2 |
30500 | 30500 | 2020-03-21 | Santa Clara | 85 | 542 | 14 | 36 | 2 |
30460 | 30460 | 2020-03-22 | Santa Clara | 85 | 583 | 16 | 41 | 2 |
30418 | 30418 | 2020-03-23 | Santa Clara | 85 | 662 | 21 | 79 | 5 |
30376 | 30376 | 2020-03-24 | Santa Clara | 85 | 734 | 22 | 72 | 1 |
30333 | 30333 | 2020-03-25 | Santa Clara | 85 | 812 | 29 | 78 | 7 |
30245 | 30245 | 2020-03-27 | Santa Clara | 85 | 954 | 30 | 67 | 0 |
30289 | 30289 | 2020-03-26 | Santa Clara | 85 | 887 | 30 | 75 | 1 |
30198 | 30198 | 2020-03-28 | Santa Clara | 85 | 994 | 32 | 40 | 2 |
30151 | 30151 | 2020-03-29 | Santa Clara | 85 | 1018 | 34 | 24 | 2 |
30103 | 30103 | 2020-03-30 | Santa Clara | 85 | 1096 | 36 | 78 | 2 |
30054 | 30054 | 2020-03-31 | Santa Clara | 85 | 1147 | 37 | 51 | 1 |
30003 | 30003 | 2020-04-01 | Santa Clara | 85 | 1197 | 40 | 50 | 3 |
29952 | 29952 | 2020-04-02 | Santa Clara | 85 | 1250 | 42 | 53 | 2 |
29900 | 29900 | 2020-04-03 | Santa Clara | 85 | 1293 | 43 | 43 | 1 |
29848 | 29848 | 2020-04-04 | Santa Clara | 85 | 1326 | 45 | 33 | 2 |
29796 | 29796 | 2020-04-05 | Santa Clara | 85 | 1369 | 47 | 43 | 2 |
29743 | 29743 | 2020-04-06 | Santa Clara | 85 | 1422 | 48 | 53 | 1 |
29690 | 29690 | 2020-04-07 | Santa Clara | 85 | 1463 | 49 | 41 | 1 |
29637 | 29637 | 2020-04-08 | Santa Clara | 85 | 1535 | 51 | 72 | 2 |
29584 | 29584 | 2020-04-09 | Santa Clara | 85 | 1603 | 55 | 68 | 4 |
29531 | 29531 | 2020-04-10 | Santa Clara | 85 | 1685 | 56 | 82 | 1 |
29478 | 29478 | 2020-04-11 | Santa Clara | 85 | 1726 | 61 | 41 | 5 |
29425 | 29425 | 2020-04-12 | Santa Clara | 85 | 1750 | 67 | 24 | 6 |
29372 | 29372 | 2020-04-13 | Santa Clara | 85 | 1791 | 68 | 41 | 1 |
29319 | 29319 | 2020-04-14 | Santa Clara | 85 | 1835 | 70 | 44 | 2 |
29266 | 29266 | 2020-04-15 | Santa Clara | 85 | 1865 | 74 | 30 | 4 |
29213 | 29213 | 2020-04-16 | Santa Clara | 85 | 1892 | 77 | 27 | 3 |
29160 | 29160 | 2020-04-17 | Santa Clara | 85 | 1934 | 82 | 42 | 5 |
29107 | 29107 | 2020-04-18 | Santa Clara | 85 | 1949 | 86 | 15 | 4 |
29054 | 29054 | 2020-04-19 | Santa Clara | 85 | 1963 | 88 | 14 | 2 |
29001 | 29001 | 2020-04-20 | Santa Clara | 85 | 1988 | 93 | 25 | 5 |
28948 | 28948 | 2020-04-21 | Santa Clara | 85 | 2014 | 96 | 26 | 3 |
28895 | 28895 | 2020-04-22 | Santa Clara | 85 | 2063 | 99 | 49 | 3 |
28842 | 28842 | 2020-04-23 | Santa Clara | 85 | 2083 | 100 | 20 | 1 |
28789 | 28789 | 2020-04-24 | Santa Clara | 85 | 2113 | 101 | 30 | 1 |
28736 | 28736 | 2020-04-25 | Santa Clara | 85 | 2127 | 102 | 14 | 1 |
28683 | 28683 | 2020-04-26 | Santa Clara | 85 | 2138 | 105 | 11 | 3 |
28630 | 28630 | 2020-04-27 | Santa Clara | 85 | 2162 | 107 | 24 | 2 |
28577 | 28577 | 2020-04-28 | Santa Clara | 85 | 2184 | 109 | 22 | 2 |
28521 | 28521 | 2020-04-29 | Santa Clara | 85 | 2212 | 110 | 28 | 1 |
28463 | 28463 | 2020-04-30 | Santa Clara | 85 | 2223 | 113 | 11 | 3 |
28405 | 28405 | 2020-05-01 | Santa Clara | 85 | 2244 | 115 | 21 | 2 |
28347 | 28347 | 2020-05-02 | Santa Clara | 85 | 2256 | 118 | 12 | 3 |
28289 | 28289 | 2020-05-03 | Santa Clara | 85 | 2264 | 120 | 8 | 2 |
28231 | 28231 | 2020-05-04 | Santa Clara | 85 | 2283 | 124 | 19 | 4 |
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 );