latimes-county-totals
Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README
- county
- The name of the county where the agency is based.
- fips
- The FIPS code given to the county by the federal government. Can be used to merge with other data sources.
- date
- The date when the data were retrieved in ISO 8601 format.
- confirmed_cases
- The cumulative number of confirmed coronavirus case at that time.
- deaths
- The cumulative number of deaths at that time.
- new_confirmed_cases
- The net change in confirmed cases over the previous date.
- new_deaths
- The net change in deaths over the previous date.
31,362 rows sorted by new_confirmed_cases descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
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 );