latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
31,362 rows sorted by confirmed_cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 58
- 37 586
- 59 586
- 85 586
- 69 581
- 23 564
- 67 564
- 95 560
- 1 559
- 9 559
- 13 559
- 41 559
- 61 559
- 65 559
- 73 559
- 75 559
- 81 559
- 87 559
- 89 559
- 97 559
- 99 559
- 111 559
- 113 559
- 19 555
- 77 551
- 39 545
- 25 541
- 107 541
- 5 539
- 79 538
- 71 537
- 83 537
- 57 536
- 29 535
- 53 535
- 45 534
- 17 532
- 7 531
- 51 531
- 93 531
- 115 531
- 47 530
- 55 530
- 27 527
- 101 527
- 11 525
- 21 525
- 31 525
- 3 522
- 109 522
- 63 521
- 103 520
- 15 519
- 33 516
- 43 493
- 35 492
- 49 492
- 91 492
- 105 492
county 58
- Los Angeles 586
- Orange 586
- Santa Clara 586
- San Benito 581
- Humboldt 564
- Sacramento 564
- Solano 560
- Alameda 559
- Calaveras 559
- Contra Costa 559
- Marin 559
- Placer 559
- Riverside 559
- San Diego 559
- San Francisco 559
- San Mateo 559
- Santa Cruz 559
- Shasta 559
- Sonoma 559
- Stanislaus 559
- Ventura 559
- Yolo 559
- Fresno 555
- San Joaquin 551
- Madera 545
- Imperial 541
- Tulare 541
- Amador 539
- San Luis Obispo 538
- San Bernardino 537
- Santa Barbara 537
- Nevada 536
- Kern 535
- Monterey 535
- Mendocino 534
- El Dorado 532
- Butte 531
- Mono 531
- Siskiyou 531
- Yuba 531
- Merced 530
- Napa 530
- Inyo 527
- Sutter 527
- Colusa 525
- Glenn 525
- Kings 525
- Alpine 522
- Tuolumne 522
- Plumas 521
- Tehama 520
- Del Norte 519
- Lake 516
- Mariposa 493
- Lassen 492
- Modoc 492
- Sierra 492
- Trinity 492
Link | rowid | date | county | fips | confirmed_cases ▼ | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
15372 | 15372 | 2020-12-11 | Alpine | 3 | 0 | 0 | -63 | 0 |
23341 | 23341 | 2020-07-27 | Modoc | 49 | 0 | 0 | 0 | 0 |
23399 | 23399 | 2020-07-26 | Modoc | 49 | 0 | 0 | 0 | 0 |
23457 | 23457 | 2020-07-25 | Modoc | 49 | 0 | 0 | 0 | 0 |
23515 | 23515 | 2020-07-24 | Modoc | 49 | 0 | 0 | 0 | 0 |
23573 | 23573 | 2020-07-23 | Modoc | 49 | 0 | 0 | 0 | 0 |
23631 | 23631 | 2020-07-22 | Modoc | 49 | 0 | 0 | 0 | 0 |
23689 | 23689 | 2020-07-21 | Modoc | 49 | 0 | 0 | 0 | 0 |
23747 | 23747 | 2020-07-20 | Modoc | 49 | 0 | 0 | 0 | 0 |
23805 | 23805 | 2020-07-19 | Modoc | 49 | 0 | 0 | 0 | 0 |
23863 | 23863 | 2020-07-18 | Modoc | 49 | 0 | 0 | 0 | 0 |
23921 | 23921 | 2020-07-17 | Modoc | 49 | 0 | 0 | 0 | 0 |
23979 | 23979 | 2020-07-16 | Modoc | 49 | 0 | 0 | 0 | 0 |
24037 | 24037 | 2020-07-15 | Modoc | 49 | 0 | 0 | 0 | 0 |
24095 | 24095 | 2020-07-14 | Modoc | 49 | 0 | 0 | 0 | 0 |
24153 | 24153 | 2020-07-13 | Modoc | 49 | 0 | 0 | 0 | 0 |
24211 | 24211 | 2020-07-12 | Modoc | 49 | 0 | 0 | 0 | 0 |
24269 | 24269 | 2020-07-11 | Modoc | 49 | 0 | 0 | 0 | 0 |
24327 | 24327 | 2020-07-10 | Modoc | 49 | 0 | 0 | 0 | 0 |
24385 | 24385 | 2020-07-09 | Modoc | 49 | 0 | 0 | 0 | 0 |
24443 | 24443 | 2020-07-08 | Modoc | 49 | 0 | 0 | 0 | 0 |
24501 | 24501 | 2020-07-07 | Modoc | 49 | 0 | 0 | 0 | 0 |
24559 | 24559 | 2020-07-06 | Modoc | 49 | 0 | 0 | 0 | 0 |
24617 | 24617 | 2020-07-05 | Modoc | 49 | 0 | 0 | 0 | 0 |
24675 | 24675 | 2020-07-04 | Modoc | 49 | 0 | 0 | 0 | 0 |
24733 | 24733 | 2020-07-03 | Modoc | 49 | 0 | 0 | 0 | 0 |
24791 | 24791 | 2020-07-02 | Modoc | 49 | 0 | 0 | 0 | 0 |
24849 | 24849 | 2020-07-01 | Modoc | 49 | 0 | 0 | 0 | 0 |
24907 | 24907 | 2020-06-30 | Modoc | 49 | 0 | 0 | 0 | 0 |
24942 | 24942 | 2020-06-29 | Alpine | 3 | 0 | 0 | -1 | 0 |
24965 | 24965 | 2020-06-29 | Modoc | 49 | 0 | 0 | 0 | 0 |
25023 | 25023 | 2020-06-28 | Modoc | 49 | 0 | 0 | 0 | 0 |
25081 | 25081 | 2020-06-27 | Modoc | 49 | 0 | 0 | 0 | 0 |
25139 | 25139 | 2020-06-26 | Modoc | 49 | 0 | 0 | 0 | 0 |
25197 | 25197 | 2020-06-25 | Modoc | 49 | 0 | 0 | 0 | 0 |
25255 | 25255 | 2020-06-24 | Modoc | 49 | 0 | 0 | 0 | 0 |
25313 | 25313 | 2020-06-23 | Modoc | 49 | 0 | 0 | 0 | 0 |
25371 | 25371 | 2020-06-22 | Modoc | 49 | 0 | 0 | 0 | 0 |
25429 | 25429 | 2020-06-21 | Modoc | 49 | 0 | 0 | 0 | 0 |
25487 | 25487 | 2020-06-20 | Modoc | 49 | 0 | 0 | 0 | 0 |
25545 | 25545 | 2020-06-19 | Modoc | 49 | 0 | 0 | 0 | 0 |
25603 | 25603 | 2020-06-18 | Modoc | 49 | 0 | 0 | 0 | 0 |
25661 | 25661 | 2020-06-17 | Modoc | 49 | 0 | 0 | 0 | 0 |
25719 | 25719 | 2020-06-16 | Modoc | 49 | 0 | 0 | 0 | 0 |
25777 | 25777 | 2020-06-15 | Modoc | 49 | 0 | 0 | 0 | 0 |
25835 | 25835 | 2020-06-14 | Modoc | 49 | 0 | 0 | 0 | 0 |
25893 | 25893 | 2020-06-13 | Modoc | 49 | 0 | 0 | 0 | 0 |
25951 | 25951 | 2020-06-12 | Modoc | 49 | 0 | 0 | 0 | 0 |
26009 | 26009 | 2020-06-11 | Modoc | 49 | 0 | 0 | 0 | 0 |
26067 | 26067 | 2020-06-10 | Modoc | 49 | 0 | 0 | 0 | 0 |
26125 | 26125 | 2020-06-09 | Modoc | 49 | 0 | 0 | 0 | 0 |
26183 | 26183 | 2020-06-08 | Modoc | 49 | 0 | 0 | 0 | 0 |
26241 | 26241 | 2020-06-07 | Modoc | 49 | 0 | 0 | 0 | 0 |
26299 | 26299 | 2020-06-06 | Modoc | 49 | 0 | 0 | 0 | 0 |
26357 | 26357 | 2020-06-05 | Modoc | 49 | 0 | 0 | 0 | 0 |
26415 | 26415 | 2020-06-04 | Modoc | 49 | 0 | 0 | 0 | 0 |
26473 | 26473 | 2020-06-03 | Modoc | 49 | 0 | 0 | 0 | 0 |
26531 | 26531 | 2020-06-02 | Modoc | 49 | 0 | 0 | 0 | 0 |
26589 | 26589 | 2020-06-01 | Modoc | 49 | 0 | 0 | 0 | 0 |
26647 | 26647 | 2020-05-31 | Modoc | 49 | 0 | 0 | 0 | 0 |
26705 | 26705 | 2020-05-30 | Modoc | 49 | 0 | 0 | 0 | 0 |
26763 | 26763 | 2020-05-29 | Modoc | 49 | 0 | 0 | 0 | 0 |
26821 | 26821 | 2020-05-28 | Modoc | 49 | 0 | 0 | 0 | 0 |
26879 | 26879 | 2020-05-27 | Modoc | 49 | 0 | 0 | 0 | 0 |
26937 | 26937 | 2020-05-26 | Modoc | 49 | 0 | 0 | 0 | 0 |
26995 | 26995 | 2020-05-25 | Modoc | 49 | 0 | 0 | 0 | 0 |
27053 | 27053 | 2020-05-24 | Modoc | 49 | 0 | 0 | 0 | 0 |
27111 | 27111 | 2020-05-23 | Modoc | 49 | 0 | 0 | 0 | 0 |
27169 | 27169 | 2020-05-22 | Modoc | 49 | 0 | 0 | 0 | 0 |
27220 | 27220 | 2020-05-21 | Lassen | 35 | 0 | 0 | 0 | 0 |
27227 | 27227 | 2020-05-21 | Modoc | 49 | 0 | 0 | 0 | 0 |
27248 | 27248 | 2020-05-21 | Sierra | 91 | 0 | 0 | 0 | 0 |
27278 | 27278 | 2020-05-20 | Lassen | 35 | 0 | 0 | 0 | 0 |
27285 | 27285 | 2020-05-20 | Modoc | 49 | 0 | 0 | 0 | 0 |
27306 | 27306 | 2020-05-20 | Sierra | 91 | 0 | 0 | 0 | 0 |
27336 | 27336 | 2020-05-19 | Lassen | 35 | 0 | 0 | 0 | 0 |
27343 | 27343 | 2020-05-19 | Modoc | 49 | 0 | 0 | 0 | 0 |
27364 | 27364 | 2020-05-19 | Sierra | 91 | 0 | 0 | 0 | 0 |
27394 | 27394 | 2020-05-18 | Lassen | 35 | 0 | 0 | 0 | 0 |
27401 | 27401 | 2020-05-18 | Modoc | 49 | 0 | 0 | 0 | 0 |
27422 | 27422 | 2020-05-18 | Sierra | 91 | 0 | 0 | 0 | 0 |
27452 | 27452 | 2020-05-17 | Lassen | 35 | 0 | 0 | 0 | 0 |
27459 | 27459 | 2020-05-17 | Modoc | 49 | 0 | 0 | 0 | 0 |
27480 | 27480 | 2020-05-17 | Sierra | 91 | 0 | 0 | 0 | 0 |
27510 | 27510 | 2020-05-16 | Lassen | 35 | 0 | 0 | 0 | 0 |
27517 | 27517 | 2020-05-16 | Modoc | 49 | 0 | 0 | 0 | 0 |
27538 | 27538 | 2020-05-16 | Sierra | 91 | 0 | 0 | 0 | 0 |
27568 | 27568 | 2020-05-15 | Lassen | 35 | 0 | 0 | 0 | 0 |
27575 | 27575 | 2020-05-15 | Modoc | 49 | 0 | 0 | 0 | 0 |
27596 | 27596 | 2020-05-15 | Sierra | 91 | 0 | 0 | 0 | 0 |
27626 | 27626 | 2020-05-14 | Lassen | 35 | 0 | 0 | 0 | 0 |
27633 | 27633 | 2020-05-14 | Modoc | 49 | 0 | 0 | 0 | 0 |
27654 | 27654 | 2020-05-14 | Sierra | 91 | 0 | 0 | 0 | 0 |
27684 | 27684 | 2020-05-13 | Lassen | 35 | 0 | 0 | 0 | 0 |
27691 | 27691 | 2020-05-13 | Modoc | 49 | 0 | 0 | 0 | 0 |
27712 | 27712 | 2020-05-13 | Sierra | 91 | 0 | 0 | 0 | 0 |
27742 | 27742 | 2020-05-12 | Lassen | 35 | 0 | 0 | 0 | 0 |
27749 | 27749 | 2020-05-12 | Modoc | 49 | 0 | 0 | 0 | 0 |
27770 | 27770 | 2020-05-12 | Sierra | 91 | 0 | 0 | 0 | 0 |
27800 | 27800 | 2020-05-11 | Lassen | 35 | 0 | 0 | 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 );