latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
984 rows where deaths = 4 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: new_deaths, date (date)
fips >30
county >30
- Mono 198
- Modoc 140
- Humboldt 101
- El Dorado 79
- Shasta 74
- Mariposa 48
- Sonoma 41
- Tuolumne 41
- Napa 30
- Trinity 27
- Yuba 27
- San Benito 21
- Sutter 20
- Santa Cruz 16
- Butte 12
- Colusa 12
- Monterey 9
- Stanislaus 8
- Tehama 8
- Del Norte 7
- Madera 6
- Plumas 6
- Solano 6
- Kern 5
- Placer 5
- Lake 4
- San Luis Obispo 4
- Merced 3
- Orange 3
- Santa Barbara 3
- …
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
3332 | 3332 | 2021-07-07 | Mono | 51 | 1300 | 4 | 1 | 0 |
3390 | 3390 | 2021-07-06 | Mono | 51 | 1299 | 4 | 0 | 0 |
3448 | 3448 | 2021-07-05 | Mono | 51 | 1299 | 4 | 0 | 0 |
3506 | 3506 | 2021-07-04 | Mono | 51 | 1299 | 4 | 0 | 0 |
3564 | 3564 | 2021-07-03 | Mono | 51 | 1299 | 4 | 0 | 0 |
3622 | 3622 | 2021-07-02 | Mono | 51 | 1299 | 4 | 0 | 0 |
3680 | 3680 | 2021-07-01 | Mono | 51 | 1299 | 4 | 0 | 0 |
3738 | 3738 | 2021-06-30 | Mono | 51 | 1299 | 4 | 0 | 0 |
3796 | 3796 | 2021-06-29 | Mono | 51 | 1299 | 4 | 0 | 0 |
3854 | 3854 | 2021-06-28 | Mono | 51 | 1299 | 4 | 1 | 0 |
3912 | 3912 | 2021-06-27 | Mono | 51 | 1298 | 4 | 0 | 0 |
3970 | 3970 | 2021-06-26 | Mono | 51 | 1298 | 4 | 0 | 0 |
4028 | 4028 | 2021-06-25 | Mono | 51 | 1298 | 4 | 0 | 0 |
4086 | 4086 | 2021-06-24 | Mono | 51 | 1298 | 4 | 0 | 0 |
4144 | 4144 | 2021-06-23 | Mono | 51 | 1298 | 4 | 0 | 0 |
4202 | 4202 | 2021-06-22 | Mono | 51 | 1298 | 4 | 3 | 0 |
4260 | 4260 | 2021-06-21 | Mono | 51 | 1295 | 4 | 0 | 0 |
4318 | 4318 | 2021-06-20 | Mono | 51 | 1295 | 4 | 0 | 0 |
4376 | 4376 | 2021-06-19 | Mono | 51 | 1295 | 4 | 0 | 0 |
4434 | 4434 | 2021-06-18 | Mono | 51 | 1295 | 4 | 0 | 0 |
4492 | 4492 | 2021-06-17 | Mono | 51 | 1295 | 4 | 0 | 0 |
4550 | 4550 | 2021-06-16 | Mono | 51 | 1295 | 4 | 0 | 0 |
4608 | 4608 | 2021-06-15 | Mono | 51 | 1295 | 4 | 0 | 0 |
4665 | 4665 | 2021-06-14 | Modoc | 49 | 534 | 4 | 0 | 0 |
4666 | 4666 | 2021-06-14 | Mono | 51 | 1295 | 4 | 0 | 0 |
4723 | 4723 | 2021-06-13 | Modoc | 49 | 534 | 4 | 0 | 0 |
4724 | 4724 | 2021-06-13 | Mono | 51 | 1295 | 4 | 0 | 0 |
4781 | 4781 | 2021-06-12 | Modoc | 49 | 534 | 4 | 1 | 0 |
4782 | 4782 | 2021-06-12 | Mono | 51 | 1295 | 4 | 0 | 0 |
4839 | 4839 | 2021-06-11 | Modoc | 49 | 533 | 4 | 7 | 0 |
4840 | 4840 | 2021-06-11 | Mono | 51 | 1295 | 4 | 1 | 0 |
4897 | 4897 | 2021-06-10 | Modoc | 49 | 526 | 4 | 0 | 0 |
4898 | 4898 | 2021-06-10 | Mono | 51 | 1294 | 4 | 0 | 0 |
4955 | 4955 | 2021-06-09 | Modoc | 49 | 526 | 4 | 4 | 0 |
4956 | 4956 | 2021-06-09 | Mono | 51 | 1294 | 4 | 0 | 0 |
5013 | 5013 | 2021-06-08 | Modoc | 49 | 522 | 4 | 0 | 0 |
5014 | 5014 | 2021-06-08 | Mono | 51 | 1294 | 4 | 0 | 0 |
5071 | 5071 | 2021-06-07 | Modoc | 49 | 522 | 4 | 6 | 0 |
5072 | 5072 | 2021-06-07 | Mono | 51 | 1294 | 4 | 0 | 0 |
5129 | 5129 | 2021-06-06 | Modoc | 49 | 516 | 4 | 0 | 0 |
5130 | 5130 | 2021-06-06 | Mono | 51 | 1294 | 4 | 0 | 0 |
5187 | 5187 | 2021-06-05 | Modoc | 49 | 516 | 4 | 0 | 0 |
5188 | 5188 | 2021-06-05 | Mono | 51 | 1294 | 4 | 0 | 0 |
5245 | 5245 | 2021-06-04 | Modoc | 49 | 516 | 4 | 0 | 0 |
5246 | 5246 | 2021-06-04 | Mono | 51 | 1294 | 4 | 0 | 0 |
5303 | 5303 | 2021-06-03 | Modoc | 49 | 516 | 4 | 1 | 0 |
5304 | 5304 | 2021-06-03 | Mono | 51 | 1294 | 4 | 0 | 0 |
5361 | 5361 | 2021-06-02 | Modoc | 49 | 515 | 4 | 1 | 0 |
5362 | 5362 | 2021-06-02 | Mono | 51 | 1294 | 4 | 0 | 0 |
5419 | 5419 | 2021-06-01 | Modoc | 49 | 514 | 4 | 0 | 0 |
5420 | 5420 | 2021-06-01 | Mono | 51 | 1294 | 4 | 0 | 0 |
5477 | 5477 | 2021-05-31 | Modoc | 49 | 514 | 4 | 0 | 0 |
5478 | 5478 | 2021-05-31 | Mono | 51 | 1294 | 4 | 0 | 0 |
5535 | 5535 | 2021-05-30 | Modoc | 49 | 514 | 4 | 0 | 0 |
5536 | 5536 | 2021-05-30 | Mono | 51 | 1294 | 4 | 0 | 0 |
5593 | 5593 | 2021-05-29 | Modoc | 49 | 514 | 4 | 0 | 0 |
5594 | 5594 | 2021-05-29 | Mono | 51 | 1294 | 4 | 0 | 0 |
5651 | 5651 | 2021-05-28 | Modoc | 49 | 514 | 4 | 0 | 0 |
5652 | 5652 | 2021-05-28 | Mono | 51 | 1294 | 4 | 1 | 0 |
5709 | 5709 | 2021-05-27 | Modoc | 49 | 514 | 4 | 3 | 0 |
5710 | 5710 | 2021-05-27 | Mono | 51 | 1293 | 4 | 0 | 0 |
5767 | 5767 | 2021-05-26 | Modoc | 49 | 511 | 4 | 0 | 0 |
5768 | 5768 | 2021-05-26 | Mono | 51 | 1293 | 4 | 0 | 0 |
5825 | 5825 | 2021-05-25 | Modoc | 49 | 511 | 4 | 5 | 0 |
5826 | 5826 | 2021-05-25 | Mono | 51 | 1293 | 4 | 2 | 0 |
5883 | 5883 | 2021-05-24 | Modoc | 49 | 506 | 4 | 0 | 0 |
5884 | 5884 | 2021-05-24 | Mono | 51 | 1291 | 4 | 3 | 0 |
5941 | 5941 | 2021-05-23 | Modoc | 49 | 506 | 4 | 0 | 0 |
5942 | 5942 | 2021-05-23 | Mono | 51 | 1288 | 4 | 0 | 0 |
5999 | 5999 | 2021-05-22 | Modoc | 49 | 506 | 4 | 0 | 0 |
6000 | 6000 | 2021-05-22 | Mono | 51 | 1288 | 4 | 0 | 0 |
6057 | 6057 | 2021-05-21 | Modoc | 49 | 506 | 4 | 0 | 0 |
6058 | 6058 | 2021-05-21 | Mono | 51 | 1288 | 4 | 0 | 0 |
6115 | 6115 | 2021-05-20 | Modoc | 49 | 506 | 4 | 4 | 0 |
6116 | 6116 | 2021-05-20 | Mono | 51 | 1288 | 4 | 1 | 0 |
6173 | 6173 | 2021-05-19 | Modoc | 49 | 502 | 4 | 1 | 0 |
6174 | 6174 | 2021-05-19 | Mono | 51 | 1287 | 4 | 2 | 0 |
6231 | 6231 | 2021-05-18 | Modoc | 49 | 501 | 4 | 0 | 0 |
6232 | 6232 | 2021-05-18 | Mono | 51 | 1285 | 4 | 1 | 0 |
6289 | 6289 | 2021-05-17 | Modoc | 49 | 501 | 4 | 0 | 0 |
6290 | 6290 | 2021-05-17 | Mono | 51 | 1284 | 4 | 0 | 0 |
6347 | 6347 | 2021-05-16 | Modoc | 49 | 501 | 4 | 0 | 0 |
6348 | 6348 | 2021-05-16 | Mono | 51 | 1284 | 4 | 0 | 0 |
6405 | 6405 | 2021-05-15 | Modoc | 49 | 501 | 4 | 0 | 0 |
6406 | 6406 | 2021-05-15 | Mono | 51 | 1284 | 4 | 0 | 0 |
6463 | 6463 | 2021-05-14 | Modoc | 49 | 501 | 4 | 0 | 0 |
6464 | 6464 | 2021-05-14 | Mono | 51 | 1284 | 4 | 0 | 0 |
6521 | 6521 | 2021-05-13 | Modoc | 49 | 501 | 4 | 2 | 0 |
6522 | 6522 | 2021-05-13 | Mono | 51 | 1284 | 4 | 0 | 0 |
6579 | 6579 | 2021-05-12 | Modoc | 49 | 499 | 4 | 1 | 0 |
6580 | 6580 | 2021-05-12 | Mono | 51 | 1284 | 4 | 0 | 0 |
6637 | 6637 | 2021-05-11 | Modoc | 49 | 498 | 4 | 0 | 0 |
6638 | 6638 | 2021-05-11 | Mono | 51 | 1284 | 4 | 4 | 0 |
6695 | 6695 | 2021-05-10 | Modoc | 49 | 498 | 4 | 3 | 0 |
6696 | 6696 | 2021-05-10 | Mono | 51 | 1280 | 4 | 0 | 0 |
6753 | 6753 | 2021-05-09 | Modoc | 49 | 495 | 4 | 0 | 0 |
6754 | 6754 | 2021-05-09 | Mono | 51 | 1280 | 4 | 0 | 0 |
6811 | 6811 | 2021-05-08 | Modoc | 49 | 495 | 4 | 0 | 0 |
6812 | 6812 | 2021-05-08 | Mono | 51 | 1280 | 4 | 0 | 0 |
6869 | 6869 | 2021-05-07 | Modoc | 49 | 495 | 4 | 0 | 0 |
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 );