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 new_confirmed_cases descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: new_deaths, 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 |
---|---|---|---|---|---|---|---|---|
28496 | 28496 | 2020-04-29 | Lassen | 35 | 0 | 0 | ||
28503 | 28503 | 2020-04-29 | Modoc | 49 | 0 | 0 | ||
28524 | 28524 | 2020-04-29 | Sierra | 91 | 0 | 0 | ||
28531 | 28531 | 2020-04-29 | Trinity | 105 | 0 | 0 | ||
28557 | 28557 | 2020-04-28 | Mariposa | 43 | 1 | 0 | ||
29773 | 29773 | 2020-04-05 | Lake | 33 | 1 | 0 | ||
29921 | 29921 | 2020-04-02 | Del Norte | 15 | 1 | 0 | ||
30011 | 30011 | 2020-04-01 | Tehama | 103 | 1 | 0 | ||
30043 | 30043 | 2020-03-31 | Plumas | 63 | 1 | 0 | ||
30068 | 30068 | 2020-03-30 | Alpine | 3 | 1 | 0 | ||
30112 | 30112 | 2020-03-30 | Tuolumne | 109 | 1 | 0 | ||
30214 | 30214 | 2020-03-27 | Colusa | 11 | 1 | 0 | ||
30218 | 30218 | 2020-03-27 | Glenn | 21 | 1 | 0 | ||
30223 | 30223 | 2020-03-27 | Kings | 31 | 1 | 0 | ||
30310 | 30310 | 2020-03-25 | Inyo | 27 | 1 | 0 | ||
30340 | 30340 | 2020-03-25 | Sutter | 101 | 2 | 0 | ||
30443 | 30443 | 2020-03-22 | Merced | 47 | 1 | 0 | ||
30446 | 30446 | 2020-03-22 | Napa | 55 | 2 | 0 | ||
30473 | 30473 | 2020-03-21 | Butte | 7 | 1 | 0 | ||
30485 | 30485 | 2020-03-21 | Mono | 51 | 1 | 0 | ||
30503 | 30503 | 2020-03-21 | Siskiyou | 93 | 2 | 0 | ||
30510 | 30510 | 2020-03-21 | Yuba | 115 | 2 | 0 | ||
30515 | 30515 | 2020-03-20 | El Dorado | 17 | 2 | 0 | ||
30593 | 30593 | 2020-03-18 | Mendocino | 45 | 1 | 0 | ||
30624 | 30624 | 2020-03-17 | Kern | 29 | 1 | 0 | ||
30628 | 30628 | 2020-03-17 | Monterey | 53 | 2 | 0 | ||
30661 | 30661 | 2020-03-16 | Nevada | 57 | 1 | 0 | ||
30698 | 30698 | 2020-03-15 | San Bernardino | 71 | 1 | 0 | ||
30704 | 30704 | 2020-03-15 | Santa Barbara | 83 | 1 | 0 | ||
30732 | 30732 | 2020-03-14 | San Luis Obispo | 79 | 1 | 0 | ||
30744 | 30744 | 2020-03-13 | Amador | 5 | 1 | 0 | ||
30803 | 30803 | 2020-03-11 | Imperial | 25 | 2 | 0 | ||
30822 | 30822 | 2020-03-11 | Tulare | 107 | 1 | 0 | ||
30906 | 30906 | 2020-03-07 | Madera | 39 | 1 | 0 | ||
31059 | 31059 | 2020-03-01 | San Joaquin | 77 | 0 | 0 | ||
31126 | 31126 | 2020-02-26 | Fresno | 19 | 1 | 0 | ||
31341 | 31341 | 2020-01-26 | Alameda | 1 | 0 | 0 | ||
31342 | 31342 | 2020-01-26 | Calaveras | 9 | 0 | 0 | ||
31343 | 31343 | 2020-01-26 | Contra Costa | 13 | 0 | 0 | ||
31344 | 31344 | 2020-01-26 | Humboldt | 23 | 0 | 0 | ||
31345 | 31345 | 2020-01-26 | Los Angeles | 37 | 1 | 0 | ||
31346 | 31346 | 2020-01-26 | Marin | 41 | 0 | 0 | ||
31347 | 31347 | 2020-01-26 | Orange | 59 | 1 | 0 | ||
31348 | 31348 | 2020-01-26 | Placer | 61 | 0 | 0 | ||
31349 | 31349 | 2020-01-26 | Riverside | 65 | 0 | 0 | ||
31350 | 31350 | 2020-01-26 | Sacramento | 67 | 0 | 0 | ||
31351 | 31351 | 2020-01-26 | San Benito | 69 | 0 | 0 | ||
31352 | 31352 | 2020-01-26 | San Diego | 73 | 0 | 0 | ||
31353 | 31353 | 2020-01-26 | San Francisco | 75 | 0 | 0 | ||
31354 | 31354 | 2020-01-26 | San Mateo | 81 | 0 | 0 | ||
31355 | 31355 | 2020-01-26 | Santa Clara | 85 | 0 | 0 | ||
31356 | 31356 | 2020-01-26 | Santa Cruz | 87 | 0 | 0 | ||
31357 | 31357 | 2020-01-26 | Shasta | 89 | 0 | 0 | ||
31358 | 31358 | 2020-01-26 | Solano | 95 | 0 | 0 | ||
31359 | 31359 | 2020-01-26 | Sonoma | 97 | 0 | 0 | ||
31360 | 31360 | 2020-01-26 | Stanislaus | 99 | 0 | 0 | ||
31361 | 31361 | 2020-01-26 | Ventura | 111 | 0 | 0 | ||
31362 | 31362 | 2020-01-26 | Yolo | 113 | 0 | 0 | ||
14519 | 14519 | 2020-12-26 | Los Angeles | 37 | 707463 | 9441 | 29423 | 136 |
15099 | 15099 | 2020-12-16 | Los Angeles | 37 | 567249 | 8572 | 22469 | 134 |
14171 | 14171 | 2021-01-01 | Los Angeles | 37 | 790582 | 10552 | 19063 | 193 |
13823 | 13823 | 2021-01-07 | Los Angeles | 37 | 872204 | 11554 | 18764 | 205 |
13765 | 13765 | 2021-01-08 | Los Angeles | 37 | 890031 | 11872 | 17827 | 318 |
14011 | 14011 | 2021-01-04 | Riverside | 65 | 198236 | 2096 | 17683 | 111 |
13707 | 13707 | 2021-01-09 | Los Angeles | 37 | 907077 | 12090 | 17046 | 218 |
14693 | 14693 | 2020-12-23 | Los Angeles | 37 | 665036 | 9165 | 16974 | 134 |
13417 | 13417 | 2021-01-14 | Los Angeles | 37 | 976075 | 13244 | 16919 | 272 |
14113 | 14113 | 2021-01-02 | Los Angeles | 37 | 807185 | 10688 | 16603 | 136 |
13141 | 13141 | 2021-01-19 | Riverside | 65 | 250436 | 2645 | 16537 | 128 |
14417 | 14417 | 2020-12-28 | Riverside | 65 | 174477 | 1870 | 16367 | 41 |
14983 | 14983 | 2020-12-18 | Los Angeles | 37 | 597386 | 8758 | 15867 | 87 |
14403 | 14403 | 2020-12-28 | Los Angeles | 37 | 734860 | 9564 | 14900 | 79 |
14229 | 14229 | 2020-12-31 | Los Angeles | 37 | 771519 | 10359 | 14679 | 291 |
13359 | 13359 | 2021-01-15 | Los Angeles | 37 | 990632 | 13504 | 14557 | 260 |
15041 | 15041 | 2020-12-17 | Los Angeles | 37 | 581519 | 8671 | 14270 | 99 |
13533 | 13533 | 2021-01-12 | Los Angeles | 37 | 947035 | 12706 | 14134 | 318 |
13301 | 13301 | 2021-01-16 | Los Angeles | 37 | 1004693 | 13757 | 14061 | 253 |
773 | 773 | 2021-08-20 | Los Angeles | 37 | 1376678 | 25033 | 13673 | 30 |
14925 | 14925 | 2020-12-19 | Los Angeles | 37 | 610907 | 8822 | 13521 | 64 |
15389 | 15389 | 2020-12-11 | Los Angeles | 37 | 502026 | 8202 | 13507 | 51 |
13649 | 13649 | 2021-01-10 | Los Angeles | 37 | 920324 | 12252 | 13247 | 162 |
14635 | 14635 | 2020-12-24 | Los Angeles | 37 | 678040 | 9305 | 13004 | 140 |
14867 | 14867 | 2020-12-20 | Los Angeles | 37 | 623792 | 8875 | 12885 | 53 |
15447 | 15447 | 2020-12-10 | Los Angeles | 37 | 488519 | 8151 | 12741 | 74 |
13591 | 13591 | 2021-01-11 | Los Angeles | 37 | 932901 | 12388 | 12577 | 136 |
14461 | 14461 | 2020-12-27 | Los Angeles | 37 | 719960 | 9485 | 12497 | 44 |
14809 | 14809 | 2020-12-21 | Los Angeles | 37 | 636190 | 8935 | 12398 | 60 |
15273 | 15273 | 2020-12-13 | Los Angeles | 37 | 525564 | 8298 | 12281 | 25 |
13475 | 13475 | 2021-01-13 | Los Angeles | 37 | 959156 | 12972 | 12121 | 266 |
13881 | 13881 | 2021-01-06 | Los Angeles | 37 | 853440 | 11349 | 12048 | 260 |
14751 | 14751 | 2020-12-22 | Los Angeles | 37 | 648062 | 9031 | 11872 | 96 |
13939 | 13939 | 2021-01-05 | Los Angeles | 37 | 841392 | 11089 | 11843 | 237 |
14345 | 14345 | 2020-12-29 | Los Angeles | 37 | 746666 | 9806 | 11806 | 242 |
15157 | 15157 | 2020-12-15 | Los Angeles | 37 | 544780 | 8438 | 11657 | 93 |
13547 | 13547 | 2021-01-12 | Riverside | 65 | 227827 | 2294 | 11552 | 44 |
14055 | 14055 | 2021-01-03 | Los Angeles | 37 | 818698 | 10773 | 11513 | 85 |
15331 | 15331 | 2020-12-12 | Los Angeles | 37 | 513283 | 8273 | 11257 | 71 |
15577 | 15577 | 2020-12-08 | Riverside | 65 | 103221 | 1513 | 10949 | 25 |
13997 | 13997 | 2021-01-04 | Los Angeles | 37 | 829549 | 10852 | 10851 | 79 |
12895 | 12895 | 2021-01-23 | Los Angeles | 37 | 1065505 | 15184 | 10351 | 272 |
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 );