latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
27 rows where fips = 67 and new_deaths = 3 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 1
- 67 · 27 ✖
county 1
- Sacramento 27
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
1020 | 1020 | 2021-08-16 | Sacramento | 67 | 123853 | 1815 | 1450 | 3 |
1194 | 1194 | 2021-08-13 | Sacramento | 67 | 122403 | 1812 | 606 | 3 |
1426 | 1426 | 2021-08-09 | Sacramento | 67 | 120417 | 1800 | 1489 | 3 |
1832 | 1832 | 2021-08-02 | Sacramento | 67 | 117126 | 1784 | 1394 | 3 |
2644 | 2644 | 2021-07-19 | Sacramento | 67 | 111553 | 1762 | 650 | 3 |
6066 | 6066 | 2021-05-21 | Sacramento | 67 | 105604 | 1698 | 64 | 3 |
6936 | 6936 | 2021-05-06 | Sacramento | 67 | 104058 | 1670 | 463 | 3 |
7400 | 7400 | 2021-04-28 | Sacramento | 67 | 102683 | 1662 | 69 | 3 |
7516 | 7516 | 2021-04-26 | Sacramento | 67 | 102486 | 1657 | 415 | 3 |
8676 | 8676 | 2021-04-06 | Sacramento | 67 | 99042 | 1620 | 194 | 3 |
8908 | 8908 | 2021-04-02 | Sacramento | 67 | 98488 | 1613 | 605 | 3 |
9140 | 9140 | 2021-03-29 | Sacramento | 67 | 97481 | 1602 | 491 | 3 |
9372 | 9372 | 2021-03-25 | Sacramento | 67 | 96782 | 1593 | 166 | 3 |
9894 | 9894 | 2021-03-16 | Sacramento | 67 | 95556 | 1551 | 115 | 3 |
16738 | 16738 | 2020-11-18 | Sacramento | 67 | 31852 | 536 | 465 | 3 |
17028 | 17028 | 2020-11-13 | Sacramento | 67 | 29837 | 520 | 327 | 3 |
17086 | 17086 | 2020-11-12 | Sacramento | 67 | 29510 | 517 | 496 | 3 |
17956 | 17956 | 2020-10-28 | Sacramento | 67 | 25882 | 499 | 132 | 3 |
18420 | 18420 | 2020-10-20 | Sacramento | 67 | 24811 | 474 | 229 | 3 |
18478 | 18478 | 2020-10-19 | Sacramento | 67 | 24582 | 471 | 390 | 3 |
19058 | 19058 | 2020-10-09 | Sacramento | 67 | 23649 | 450 | 126 | 3 |
19928 | 19928 | 2020-09-24 | Sacramento | 67 | 22026 | 402 | 154 | 3 |
21262 | 21262 | 2020-09-01 | Sacramento | 67 | 18286 | 296 | 234 | 3 |
22886 | 22886 | 2020-08-04 | Sacramento | 67 | 10174 | 148 | 52 | 3 |
22944 | 22944 | 2020-08-03 | Sacramento | 67 | 10122 | 145 | 55 | 3 |
27642 | 27642 | 2020-05-14 | Sacramento | 67 | 1194 | 54 | 11 | 3 |
29681 | 29681 | 2020-04-07 | Sacramento | 67 | 525 | 21 | 63 | 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 );