latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
35 rows where fips = 85 and new_deaths = 3 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 1
- 85 · 35 ✖
county 1
- Santa Clara 35
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
7293 | 7293 | 2021-04-30 | Santa Clara | 85 | 117202 | 1680 | 65 | 3 |
9381 | 9381 | 2021-03-25 | Santa Clara | 85 | 113343 | 1647 | 134 | 3 |
9555 | 9555 | 2021-03-22 | Santa Clara | 85 | 112965 | 1641 | 112 | 3 |
9787 | 9787 | 2021-03-18 | Santa Clara | 85 | 112597 | 1634 | 107 | 3 |
10309 | 10309 | 2021-03-09 | Santa Clara | 85 | 111556 | 1614 | 151 | 3 |
10367 | 10367 | 2021-03-08 | Santa Clara | 85 | 111405 | 1611 | 168 | 3 |
10599 | 10599 | 2021-03-04 | Santa Clara | 85 | 110918 | 1601 | 163 | 3 |
11005 | 11005 | 2021-02-25 | Santa Clara | 85 | 109762 | 1577 | 165 | 3 |
16051 | 16051 | 2020-11-30 | Santa Clara | 85 | 37454 | 439 | 942 | 3 |
16283 | 16283 | 2020-11-26 | Santa Clara | 85 | 34912 | 425 | 153 | 3 |
16341 | 16341 | 2020-11-25 | Santa Clara | 85 | 34759 | 422 | 841 | 3 |
16631 | 16631 | 2020-11-20 | Santa Clara | 85 | 31980 | 411 | 551 | 3 |
17327 | 17327 | 2020-11-08 | Santa Clara | 85 | 27178 | 384 | 86 | 3 |
19009 | 19009 | 2020-10-10 | Santa Clara | 85 | 22849 | 334 | 88 | 3 |
19357 | 19357 | 2020-10-04 | Santa Clara | 85 | 22157 | 322 | 43 | 3 |
19589 | 19589 | 2020-09-30 | Santa Clara | 85 | 21805 | 315 | 118 | 3 |
20459 | 20459 | 2020-09-15 | Santa Clara | 85 | 20156 | 286 | 226 | 3 |
21271 | 21271 | 2020-09-01 | Santa Clara | 85 | 18259 | 258 | 234 | 3 |
21387 | 21387 | 2020-08-30 | Santa Clara | 85 | 17877 | 254 | 56 | 3 |
21561 | 21561 | 2020-08-27 | Santa Clara | 85 | 17489 | 250 | 199 | 3 |
21909 | 21909 | 2020-08-21 | Santa Clara | 85 | 16419 | 232 | 166 | 3 |
22199 | 22199 | 2020-08-16 | Santa Clara | 85 | 15466 | 219 | 71 | 3 |
22373 | 22373 | 2020-08-13 | Santa Clara | 85 | 14985 | 213 | 243 | 3 |
22895 | 22895 | 2020-08-04 | Santa Clara | 85 | 12748 | 205 | 302 | 3 |
22953 | 22953 | 2020-08-03 | Santa Clara | 85 | 12446 | 202 | 170 | 3 |
23649 | 23649 | 2020-07-22 | Santa Clara | 85 | 10027 | 186 | 301 | 3 |
24635 | 24635 | 2020-07-05 | Santa Clara | 85 | 5696 | 162 | 97 | 3 |
28347 | 28347 | 2020-05-02 | Santa Clara | 85 | 2256 | 118 | 12 | 3 |
28463 | 28463 | 2020-04-30 | Santa Clara | 85 | 2223 | 113 | 11 | 3 |
28683 | 28683 | 2020-04-26 | Santa Clara | 85 | 2138 | 105 | 11 | 3 |
28895 | 28895 | 2020-04-22 | Santa Clara | 85 | 2063 | 99 | 49 | 3 |
28948 | 28948 | 2020-04-21 | Santa Clara | 85 | 2014 | 96 | 26 | 3 |
29213 | 29213 | 2020-04-16 | Santa Clara | 85 | 1892 | 77 | 27 | 3 |
30003 | 30003 | 2020-04-01 | Santa Clara | 85 | 1197 | 40 | 50 | 3 |
30674 | 30674 | 2020-03-16 | Santa Clara | 85 | 298 | 10 | 37 | 3 |
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 );