latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
39 rows where fips = 13 and new_deaths = 3 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 1
- 13 · 39 ✖
county 1
- Contra Costa 39
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
65 | 65 | 2021-09-01 | Contra Costa | 13 | 90247 | 872 | 293 | 3 |
413 | 413 | 2021-08-26 | Contra Costa | 13 | 86188 | 863 | 489 | 3 |
819 | 819 | 2021-08-19 | Contra Costa | 13 | 83651 | 849 | 801 | 3 |
1167 | 1167 | 2021-08-13 | Contra Costa | 13 | 81406 | 846 | 316 | 3 |
1283 | 1283 | 2021-08-11 | Contra Costa | 13 | 80628 | 841 | 260 | 3 |
1979 | 1979 | 2021-07-30 | Contra Costa | 13 | 76676 | 833 | 470 | 3 |
2443 | 2443 | 2021-07-22 | Contra Costa | 13 | 74030 | 828 | 368 | 3 |
4415 | 4415 | 2021-06-18 | Contra Costa | 13 | 70561 | 811 | 83 | 3 |
6735 | 6735 | 2021-05-09 | Contra Costa | 13 | 68582 | 792 | 79 | 3 |
7373 | 7373 | 2021-04-28 | Contra Costa | 13 | 67816 | 780 | 70 | 3 |
7663 | 7663 | 2021-04-23 | Contra Costa | 13 | 67435 | 771 | 135 | 3 |
8185 | 8185 | 2021-04-14 | Contra Costa | 13 | 66666 | 767 | 99 | 3 |
8881 | 8881 | 2021-04-02 | Contra Costa | 13 | 65559 | 760 | 124 | 3 |
8997 | 8997 | 2021-03-31 | Contra Costa | 13 | 65370 | 757 | 67 | 3 |
9693 | 9693 | 2021-03-19 | Contra Costa | 13 | 64454 | 730 | 96 | 3 |
9983 | 9983 | 2021-03-14 | Contra Costa | 13 | 64056 | 719 | 226 | 3 |
10157 | 10157 | 2021-03-11 | Contra Costa | 13 | 63712 | 716 | 86 | 3 |
12535 | 12535 | 2021-01-29 | Contra Costa | 13 | 56575 | 528 | 323 | 3 |
12709 | 12709 | 2021-01-26 | Contra Costa | 13 | 55593 | 492 | 348 | 3 |
12883 | 12883 | 2021-01-23 | Contra Costa | 13 | 54416 | 487 | 276 | 3 |
13231 | 13231 | 2021-01-17 | Contra Costa | 13 | 52146 | 449 | 573 | 3 |
13463 | 13463 | 2021-01-13 | Contra Costa | 13 | 49082 | 395 | 633 | 3 |
13637 | 13637 | 2021-01-10 | Contra Costa | 13 | 47315 | 392 | 697 | 3 |
15435 | 15435 | 2020-12-10 | Contra Costa | 13 | 28487 | 273 | 96 | 3 |
15493 | 15493 | 2020-12-09 | Contra Costa | 13 | 28391 | 270 | 303 | 3 |
17871 | 17871 | 2020-10-29 | Contra Costa | 13 | 18981 | 246 | 104 | 3 |
19089 | 19089 | 2020-10-08 | Contra Costa | 13 | 17478 | 227 | 58 | 3 |
20365 | 20365 | 2020-09-16 | Contra Costa | 13 | 15544 | 197 | 55 | 3 |
21061 | 21061 | 2020-09-04 | Contra Costa | 13 | 14411 | 186 | 199 | 3 |
21873 | 21873 | 2020-08-21 | Contra Costa | 13 | 12362 | 164 | 316 | 3 |
21931 | 21931 | 2020-08-20 | Contra Costa | 13 | 12046 | 161 | 160 | 3 |
22395 | 22395 | 2020-08-12 | Contra Costa | 13 | 10103 | 149 | 316 | 3 |
22743 | 22743 | 2020-08-06 | Contra Costa | 13 | 8532 | 134 | 208 | 3 |
23091 | 23091 | 2020-07-31 | Contra Costa | 13 | 7670 | 119 | 93 | 3 |
23671 | 23671 | 2020-07-21 | Contra Costa | 13 | 6188 | 102 | 373 | 3 |
23903 | 23903 | 2020-07-17 | Contra Costa | 13 | 5478 | 96 | 154 | 3 |
26107 | 26107 | 2020-06-09 | Contra Costa | 13 | 1775 | 43 | 68 | 3 |
27209 | 27209 | 2020-05-21 | Contra Costa | 13 | 1220 | 36 | 26 | 3 |
29127 | 29127 | 2020-04-17 | Contra Costa | 13 | 685 | 19 | 15 | 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 );