latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
586 rows where fips = 85 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 1
- 85 · 275 ✖
county 1
- Santa Clara 275
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
18081 | 18081 | 2020-10-26 | Santa Clara | 85 | 24745 | 357 | 158 | 1 |
18139 | 18139 | 2020-10-25 | Santa Clara | 85 | 24587 | 356 | 56 | 1 |
18197 | 18197 | 2020-10-24 | Santa Clara | 85 | 24531 | 355 | 69 | 2 |
18255 | 18255 | 2020-10-23 | Santa Clara | 85 | 24462 | 353 | 145 | 4 |
18313 | 18313 | 2020-10-22 | Santa Clara | 85 | 24317 | 349 | 132 | 2 |
18371 | 18371 | 2020-10-21 | Santa Clara | 85 | 24185 | 347 | 147 | 0 |
18429 | 18429 | 2020-10-20 | Santa Clara | 85 | 24038 | 347 | 199 | 4 |
18487 | 18487 | 2020-10-19 | Santa Clara | 85 | 23839 | 343 | 140 | 2 |
18545 | 18545 | 2020-10-18 | Santa Clara | 85 | 23699 | 341 | 40 | 0 |
18603 | 18603 | 2020-10-17 | Santa Clara | 85 | 23659 | 341 | 66 | 0 |
18661 | 18661 | 2020-10-16 | Santa Clara | 85 | 23593 | 341 | 111 | 2 |
18719 | 18719 | 2020-10-15 | Santa Clara | 85 | 23482 | 339 | 160 | 2 |
18777 | 18777 | 2020-10-14 | Santa Clara | 85 | 23322 | 337 | 144 | 0 |
18835 | 18835 | 2020-10-13 | Santa Clara | 85 | 23178 | 337 | 150 | 1 |
18893 | 18893 | 2020-10-12 | Santa Clara | 85 | 23028 | 336 | 135 | 2 |
18951 | 18951 | 2020-10-11 | Santa Clara | 85 | 22893 | 334 | 44 | 0 |
19009 | 19009 | 2020-10-10 | Santa Clara | 85 | 22849 | 334 | 88 | 3 |
19067 | 19067 | 2020-10-09 | Santa Clara | 85 | 22761 | 331 | 113 | 1 |
19125 | 19125 | 2020-10-08 | Santa Clara | 85 | 22648 | 330 | 127 | 0 |
19183 | 19183 | 2020-10-07 | Santa Clara | 85 | 22521 | 330 | 130 | 5 |
19241 | 19241 | 2020-10-06 | Santa Clara | 85 | 22391 | 325 | 149 | 1 |
19299 | 19299 | 2020-10-05 | Santa Clara | 85 | 22242 | 324 | 85 | 2 |
19357 | 19357 | 2020-10-04 | Santa Clara | 85 | 22157 | 322 | 43 | 3 |
19415 | 19415 | 2020-10-03 | Santa Clara | 85 | 22114 | 319 | 66 | 2 |
19473 | 19473 | 2020-10-02 | Santa Clara | 85 | 22048 | 317 | 121 | 0 |
19531 | 19531 | 2020-10-01 | Santa Clara | 85 | 21927 | 317 | 122 | 2 |
19589 | 19589 | 2020-09-30 | Santa Clara | 85 | 21805 | 315 | 118 | 3 |
19647 | 19647 | 2020-09-29 | Santa Clara | 85 | 21687 | 312 | 145 | 2 |
19705 | 19705 | 2020-09-28 | Santa Clara | 85 | 21542 | 310 | 97 | 2 |
19763 | 19763 | 2020-09-27 | Santa Clara | 85 | 21445 | 308 | 40 | 4 |
19821 | 19821 | 2020-09-26 | Santa Clara | 85 | 21405 | 304 | 52 | 0 |
19879 | 19879 | 2020-09-25 | Santa Clara | 85 | 21353 | 304 | 103 | 4 |
19937 | 19937 | 2020-09-24 | Santa Clara | 85 | 21250 | 300 | 118 | 2 |
19995 | 19995 | 2020-09-23 | Santa Clara | 85 | 21132 | 298 | 138 | 2 |
20053 | 20053 | 2020-09-22 | Santa Clara | 85 | 20994 | 296 | 146 | 2 |
20111 | 20111 | 2020-09-21 | Santa Clara | 85 | 20848 | 294 | 122 | 1 |
20169 | 20169 | 2020-09-20 | Santa Clara | 85 | 20726 | 293 | 42 | 1 |
20227 | 20227 | 2020-09-19 | Santa Clara | 85 | 20684 | 292 | 71 | 0 |
20285 | 20285 | 2020-09-18 | Santa Clara | 85 | 20613 | 292 | 131 | 4 |
20343 | 20343 | 2020-09-17 | Santa Clara | 85 | 20482 | 288 | 176 | 0 |
20401 | 20401 | 2020-09-16 | Santa Clara | 85 | 20306 | 288 | 150 | 2 |
20459 | 20459 | 2020-09-15 | Santa Clara | 85 | 20156 | 286 | 226 | 3 |
20517 | 20517 | 2020-09-14 | Santa Clara | 85 | 19930 | 283 | 125 | 4 |
20575 | 20575 | 2020-09-13 | Santa Clara | 85 | 19805 | 279 | 33 | 5 |
20633 | 20633 | 2020-09-12 | Santa Clara | 85 | 19772 | 274 | 84 | 1 |
20691 | 20691 | 2020-09-11 | Santa Clara | 85 | 19688 | 273 | 132 | 2 |
20749 | 20749 | 2020-09-10 | Santa Clara | 85 | 19556 | 271 | 145 | 0 |
20807 | 20807 | 2020-09-09 | Santa Clara | 85 | 19411 | 271 | 207 | 1 |
20865 | 20865 | 2020-09-08 | Santa Clara | 85 | 19204 | 270 | 193 | 0 |
20923 | 20923 | 2020-09-07 | Santa Clara | 85 | 19011 | 270 | 41 | 4 |
20981 | 20981 | 2020-09-06 | Santa Clara | 85 | 18970 | 266 | 45 | 0 |
21039 | 21039 | 2020-09-05 | Santa Clara | 85 | 18925 | 266 | 90 | 4 |
21097 | 21097 | 2020-09-04 | Santa Clara | 85 | 18835 | 262 | 177 | 2 |
21155 | 21155 | 2020-09-03 | Santa Clara | 85 | 18658 | 260 | 169 | 1 |
21213 | 21213 | 2020-09-02 | Santa Clara | 85 | 18489 | 259 | 230 | 1 |
21271 | 21271 | 2020-09-01 | Santa Clara | 85 | 18259 | 258 | 234 | 3 |
21329 | 21329 | 2020-08-31 | Santa Clara | 85 | 18025 | 255 | 148 | 1 |
21387 | 21387 | 2020-08-30 | Santa Clara | 85 | 17877 | 254 | 56 | 3 |
21445 | 21445 | 2020-08-29 | Santa Clara | 85 | 17821 | 251 | 141 | 1 |
21503 | 21503 | 2020-08-28 | Santa Clara | 85 | 17680 | 250 | 191 | 0 |
21561 | 21561 | 2020-08-27 | Santa Clara | 85 | 17489 | 250 | 199 | 3 |
21619 | 21619 | 2020-08-26 | Santa Clara | 85 | 17290 | 247 | 228 | 6 |
21677 | 21677 | 2020-08-25 | Santa Clara | 85 | 17062 | 241 | 289 | 1 |
21735 | 21735 | 2020-08-24 | Santa Clara | 85 | 16773 | 240 | 156 | 4 |
21793 | 21793 | 2020-08-23 | Santa Clara | 85 | 16617 | 236 | 60 | 2 |
21851 | 21851 | 2020-08-22 | Santa Clara | 85 | 16557 | 234 | 138 | 2 |
21909 | 21909 | 2020-08-21 | Santa Clara | 85 | 16419 | 232 | 166 | 3 |
21967 | 21967 | 2020-08-20 | Santa Clara | 85 | 16253 | 229 | 162 | 2 |
22025 | 22025 | 2020-08-19 | Santa Clara | 85 | 16091 | 227 | 172 | 5 |
22083 | 22083 | 2020-08-18 | Santa Clara | 85 | 15919 | 222 | 267 | 2 |
22141 | 22141 | 2020-08-17 | Santa Clara | 85 | 15652 | 220 | 186 | 1 |
22199 | 22199 | 2020-08-16 | Santa Clara | 85 | 15466 | 219 | 71 | 3 |
22257 | 22257 | 2020-08-15 | Santa Clara | 85 | 15395 | 216 | 156 | 2 |
22315 | 22315 | 2020-08-14 | Santa Clara | 85 | 15239 | 214 | 254 | 1 |
22373 | 22373 | 2020-08-13 | Santa Clara | 85 | 14985 | 213 | 243 | 3 |
22431 | 22431 | 2020-08-12 | Santa Clara | 85 | 14742 | 210 | 284 | 1 |
22489 | 22489 | 2020-08-11 | Santa Clara | 85 | 14458 | 209 | 331 | 0 |
22547 | 22547 | 2020-08-10 | Santa Clara | 85 | 14127 | 209 | 224 | 2 |
22605 | 22605 | 2020-08-09 | Santa Clara | 85 | 13903 | 207 | 111 | 0 |
22663 | 22663 | 2020-08-08 | Santa Clara | 85 | 13792 | 207 | 207 | 0 |
22721 | 22721 | 2020-08-07 | Santa Clara | 85 | 13585 | 207 | 259 | 0 |
22779 | 22779 | 2020-08-06 | Santa Clara | 85 | 13326 | 207 | 245 | 1 |
22837 | 22837 | 2020-08-05 | Santa Clara | 85 | 13081 | 206 | 333 | 1 |
22895 | 22895 | 2020-08-04 | Santa Clara | 85 | 12748 | 205 | 302 | 3 |
22953 | 22953 | 2020-08-03 | Santa Clara | 85 | 12446 | 202 | 170 | 3 |
23011 | 23011 | 2020-08-02 | Santa Clara | 85 | 12276 | 199 | 84 | 2 |
23069 | 23069 | 2020-08-01 | Santa Clara | 85 | 12192 | 197 | 173 | 2 |
23127 | 23127 | 2020-07-31 | Santa Clara | 85 | 12019 | 195 | 262 | 1 |
23185 | 23185 | 2020-07-30 | Santa Clara | 85 | 11757 | 194 | 242 | 0 |
23243 | 23243 | 2020-07-29 | Santa Clara | 85 | 11515 | 194 | 273 | 2 |
23301 | 23301 | 2020-07-28 | Santa Clara | 85 | 11242 | 192 | 298 | 0 |
23359 | 23359 | 2020-07-27 | Santa Clara | 85 | 10944 | 192 | 176 | 2 |
23417 | 23417 | 2020-07-26 | Santa Clara | 85 | 10768 | 190 | 86 | 1 |
23475 | 23475 | 2020-07-25 | Santa Clara | 85 | 10682 | 189 | 127 | 2 |
23533 | 23533 | 2020-07-24 | Santa Clara | 85 | 10555 | 187 | 246 | 1 |
23591 | 23591 | 2020-07-23 | Santa Clara | 85 | 10309 | 186 | 282 | 0 |
23649 | 23649 | 2020-07-22 | Santa Clara | 85 | 10027 | 186 | 301 | 3 |
23707 | 23707 | 2020-07-21 | Santa Clara | 85 | 9726 | 183 | 312 | 1 |
23765 | 23765 | 2020-07-20 | Santa Clara | 85 | 9414 | 182 | 216 | 1 |
23823 | 23823 | 2020-07-19 | Santa Clara | 85 | 9198 | 181 | 87 | 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 );