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
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▼ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
28173 | 28173 | 2020-05-05 | Santa Clara | 85 | 2296 | 126 | 13 | 2 |
28115 | 28115 | 2020-05-06 | Santa Clara | 85 | 2324 | 126 | 28 | 0 |
28057 | 28057 | 2020-05-07 | Santa Clara | 85 | 2336 | 127 | 12 | 1 |
27999 | 27999 | 2020-05-08 | Santa Clara | 85 | 2360 | 127 | 24 | 0 |
27941 | 27941 | 2020-05-09 | Santa Clara | 85 | 2371 | 128 | 11 | 1 |
27883 | 27883 | 2020-05-10 | Santa Clara | 85 | 2374 | 130 | 3 | 2 |
27825 | 27825 | 2020-05-11 | Santa Clara | 85 | 2394 | 130 | 20 | 0 |
27767 | 27767 | 2020-05-12 | Santa Clara | 85 | 2409 | 131 | 15 | 1 |
27709 | 27709 | 2020-05-13 | Santa Clara | 85 | 2429 | 132 | 20 | 1 |
27651 | 27651 | 2020-05-14 | Santa Clara | 85 | 2453 | 133 | 24 | 1 |
27593 | 27593 | 2020-05-15 | Santa Clara | 85 | 2468 | 134 | 15 | 1 |
27535 | 27535 | 2020-05-16 | Santa Clara | 85 | 2483 | 135 | 15 | 1 |
27477 | 27477 | 2020-05-17 | Santa Clara | 85 | 2490 | 136 | 7 | 1 |
27419 | 27419 | 2020-05-18 | Santa Clara | 85 | 2529 | 136 | 39 | 0 |
27361 | 27361 | 2020-05-19 | Santa Clara | 85 | 2573 | 136 | 44 | 0 |
27303 | 27303 | 2020-05-20 | Santa Clara | 85 | 2609 | 136 | 36 | 0 |
27245 | 27245 | 2020-05-21 | Santa Clara | 85 | 2630 | 136 | 21 | 0 |
27187 | 27187 | 2020-05-22 | Santa Clara | 85 | 2656 | 137 | 26 | 1 |
27129 | 27129 | 2020-05-23 | Santa Clara | 85 | 2673 | 137 | 17 | 0 |
27071 | 27071 | 2020-05-24 | Santa Clara | 85 | 2675 | 137 | 2 | 0 |
27013 | 27013 | 2020-05-25 | Santa Clara | 85 | 2682 | 137 | 7 | 0 |
26955 | 26955 | 2020-05-26 | Santa Clara | 85 | 2714 | 137 | 32 | 0 |
26897 | 26897 | 2020-05-27 | Santa Clara | 85 | 2753 | 137 | 39 | 0 |
26839 | 26839 | 2020-05-28 | Santa Clara | 85 | 2776 | 139 | 23 | 2 |
26781 | 26781 | 2020-05-29 | Santa Clara | 85 | 2820 | 141 | 44 | 2 |
26723 | 26723 | 2020-05-30 | Santa Clara | 85 | 2836 | 141 | 16 | 0 |
26665 | 26665 | 2020-05-31 | Santa Clara | 85 | 2846 | 141 | 10 | 0 |
26607 | 26607 | 2020-06-01 | Santa Clara | 85 | 2880 | 142 | 34 | 1 |
26549 | 26549 | 2020-06-02 | Santa Clara | 85 | 2905 | 143 | 25 | 1 |
26491 | 26491 | 2020-06-03 | Santa Clara | 85 | 2947 | 144 | 42 | 1 |
26433 | 26433 | 2020-06-04 | Santa Clara | 85 | 2984 | 144 | 37 | 0 |
26375 | 26375 | 2020-06-05 | Santa Clara | 85 | 3020 | 144 | 36 | 0 |
26317 | 26317 | 2020-06-06 | Santa Clara | 85 | 3033 | 145 | 13 | 1 |
26259 | 26259 | 2020-06-07 | Santa Clara | 85 | 3051 | 145 | 18 | 0 |
26201 | 26201 | 2020-06-08 | Santa Clara | 85 | 3090 | 145 | 39 | 0 |
26143 | 26143 | 2020-06-09 | Santa Clara | 85 | 3137 | 145 | 47 | 0 |
26085 | 26085 | 2020-06-10 | Santa Clara | 85 | 3200 | 146 | 63 | 1 |
26027 | 26027 | 2020-06-11 | Santa Clara | 85 | 3250 | 147 | 50 | 1 |
25969 | 25969 | 2020-06-12 | Santa Clara | 85 | 3308 | 147 | 58 | 0 |
25911 | 25911 | 2020-06-13 | Santa Clara | 85 | 3329 | 148 | 21 | 1 |
25853 | 25853 | 2020-06-14 | Santa Clara | 85 | 3342 | 148 | 13 | 0 |
25795 | 25795 | 2020-06-15 | Santa Clara | 85 | 3404 | 148 | 62 | 0 |
25737 | 25737 | 2020-06-16 | Santa Clara | 85 | 3499 | 148 | 95 | 0 |
25679 | 25679 | 2020-06-17 | Santa Clara | 85 | 3592 | 148 | 93 | 0 |
25621 | 25621 | 2020-06-18 | Santa Clara | 85 | 3694 | 148 | 102 | 0 |
25563 | 25563 | 2020-06-19 | Santa Clara | 85 | 3804 | 148 | 110 | 0 |
25505 | 25505 | 2020-06-20 | Santa Clara | 85 | 3854 | 149 | 50 | 1 |
25447 | 25447 | 2020-06-21 | Santa Clara | 85 | 3891 | 151 | 37 | 2 |
25389 | 25389 | 2020-06-22 | Santa Clara | 85 | 3997 | 151 | 106 | 0 |
25331 | 25331 | 2020-06-23 | Santa Clara | 85 | 4188 | 151 | 191 | 0 |
25273 | 25273 | 2020-06-24 | Santa Clara | 85 | 4335 | 152 | 147 | 1 |
25215 | 25215 | 2020-06-25 | Santa Clara | 85 | 4472 | 153 | 137 | 1 |
25157 | 25157 | 2020-06-26 | Santa Clara | 85 | 4607 | 155 | 135 | 2 |
25099 | 25099 | 2020-06-27 | Santa Clara | 85 | 4718 | 155 | 111 | 0 |
25041 | 25041 | 2020-06-28 | Santa Clara | 85 | 4779 | 155 | 61 | 0 |
24983 | 24983 | 2020-06-29 | Santa Clara | 85 | 4919 | 155 | 140 | 0 |
24925 | 24925 | 2020-06-30 | Santa Clara | 85 | 5107 | 156 | 188 | 1 |
24867 | 24867 | 2020-07-01 | Santa Clara | 85 | 5291 | 156 | 184 | 0 |
24809 | 24809 | 2020-07-02 | Santa Clara | 85 | 5476 | 156 | 185 | 0 |
24751 | 24751 | 2020-07-03 | Santa Clara | 85 | 5555 | 157 | 79 | 1 |
24693 | 24693 | 2020-07-04 | Santa Clara | 85 | 5599 | 159 | 44 | 2 |
24635 | 24635 | 2020-07-05 | Santa Clara | 85 | 5696 | 162 | 97 | 3 |
24577 | 24577 | 2020-07-06 | Santa Clara | 85 | 5950 | 164 | 254 | 2 |
24519 | 24519 | 2020-07-07 | Santa Clara | 85 | 6242 | 165 | 292 | 1 |
24461 | 24461 | 2020-07-08 | Santa Clara | 85 | 6530 | 170 | 288 | 5 |
24403 | 24403 | 2020-07-09 | Santa Clara | 85 | 6811 | 170 | 281 | 0 |
24345 | 24345 | 2020-07-10 | Santa Clara | 85 | 7055 | 171 | 244 | 1 |
24287 | 24287 | 2020-07-11 | Santa Clara | 85 | 7237 | 171 | 182 | 0 |
24229 | 24229 | 2020-07-12 | Santa Clara | 85 | 7356 | 171 | 119 | 0 |
24171 | 24171 | 2020-07-13 | Santa Clara | 85 | 7562 | 172 | 206 | 1 |
24113 | 24113 | 2020-07-14 | Santa Clara | 85 | 7916 | 174 | 354 | 2 |
24055 | 24055 | 2020-07-15 | Santa Clara | 85 | 8302 | 175 | 386 | 1 |
23997 | 23997 | 2020-07-16 | Santa Clara | 85 | 8642 | 177 | 340 | 2 |
23939 | 23939 | 2020-07-17 | Santa Clara | 85 | 8941 | 178 | 299 | 1 |
23881 | 23881 | 2020-07-18 | Santa Clara | 85 | 9111 | 180 | 170 | 2 |
23823 | 23823 | 2020-07-19 | Santa Clara | 85 | 9198 | 181 | 87 | 1 |
23765 | 23765 | 2020-07-20 | Santa Clara | 85 | 9414 | 182 | 216 | 1 |
23707 | 23707 | 2020-07-21 | Santa Clara | 85 | 9726 | 183 | 312 | 1 |
23649 | 23649 | 2020-07-22 | Santa Clara | 85 | 10027 | 186 | 301 | 3 |
23591 | 23591 | 2020-07-23 | Santa Clara | 85 | 10309 | 186 | 282 | 0 |
23533 | 23533 | 2020-07-24 | Santa Clara | 85 | 10555 | 187 | 246 | 1 |
23475 | 23475 | 2020-07-25 | Santa Clara | 85 | 10682 | 189 | 127 | 2 |
23417 | 23417 | 2020-07-26 | Santa Clara | 85 | 10768 | 190 | 86 | 1 |
23359 | 23359 | 2020-07-27 | Santa Clara | 85 | 10944 | 192 | 176 | 2 |
23301 | 23301 | 2020-07-28 | Santa Clara | 85 | 11242 | 192 | 298 | 0 |
23243 | 23243 | 2020-07-29 | Santa Clara | 85 | 11515 | 194 | 273 | 2 |
23185 | 23185 | 2020-07-30 | Santa Clara | 85 | 11757 | 194 | 242 | 0 |
23127 | 23127 | 2020-07-31 | Santa Clara | 85 | 12019 | 195 | 262 | 1 |
23069 | 23069 | 2020-08-01 | Santa Clara | 85 | 12192 | 197 | 173 | 2 |
23011 | 23011 | 2020-08-02 | Santa Clara | 85 | 12276 | 199 | 84 | 2 |
22953 | 22953 | 2020-08-03 | Santa Clara | 85 | 12446 | 202 | 170 | 3 |
22895 | 22895 | 2020-08-04 | Santa Clara | 85 | 12748 | 205 | 302 | 3 |
22837 | 22837 | 2020-08-05 | Santa Clara | 85 | 13081 | 206 | 333 | 1 |
22779 | 22779 | 2020-08-06 | Santa Clara | 85 | 13326 | 207 | 245 | 1 |
22721 | 22721 | 2020-08-07 | Santa Clara | 85 | 13585 | 207 | 259 | 0 |
22663 | 22663 | 2020-08-08 | Santa Clara | 85 | 13792 | 207 | 207 | 0 |
22605 | 22605 | 2020-08-09 | Santa Clara | 85 | 13903 | 207 | 111 | 0 |
22547 | 22547 | 2020-08-10 | Santa Clara | 85 | 14127 | 209 | 224 | 2 |
22489 | 22489 | 2020-08-11 | Santa Clara | 85 | 14458 | 209 | 331 | 0 |
22431 | 22431 | 2020-08-12 | Santa Clara | 85 | 14742 | 210 | 284 | 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 );