cdph-county-cases-deaths
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 coronavirus cases that were confirmed as of that time. This is sometimes called the episode date by other sources.
- reported_cases
- The cumulative number of coronavirus cases that were reported as of that time. This reflects when cases were first announced by the state.
- probable_cases
- The cumulative number of probable coronavirus cases that were confirmed as of that time. This reflects the results of antigen tests, a rapid testing technique different from the standard test.
- reported_and_probable_cases
- The cumulative number of reported and probable coronavirus cases as of that time.
- reported_deaths
- The cumulative number of deaths reported at that time.
61,538 rows sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▼ | county | fips | population | confirmed_cases | reported_cases | probable_cases | reported_and_probable_cases | reported_deaths |
---|---|---|---|---|---|---|---|---|---|---|
61465 | 61465 | 2020-02-02 | Santa Clara | 85 | 1922200 | 2 | 2 | 0 | 2 | 0 |
61466 | 61466 | 2020-02-02 | Santa Cruz | 87 | 273765 | 0 | 0 | 0 | 0 | 0 |
61467 | 61467 | 2020-02-02 | Shasta | 89 | 179085 | 0 | 0 | 0 | 0 | 0 |
61468 | 61468 | 2020-02-02 | Sierra | 91 | 2930 | 0 | 0 | 0 | 0 | 0 |
61469 | 61469 | 2020-02-02 | Siskiyou | 93 | 43540 | 0 | 0 | 0 | 0 | 0 |
61470 | 61470 | 2020-02-02 | Solano | 95 | 438530 | 0 | 0 | 0 | 0 | 0 |
61471 | 61471 | 2020-02-02 | Sonoma | 97 | 501317 | 0 | 0 | 0 | 0 | 0 |
61472 | 61472 | 2020-02-02 | Stanislaus | 99 | 539301 | 0 | 0 | 0 | 0 | 0 |
61473 | 61473 | 2020-02-02 | Sutter | 101 | 95872 | 0 | 0 | 0 | 0 | 0 |
61474 | 61474 | 2020-02-02 | Tehama | 103 | 63373 | 0 | 0 | 0 | 0 | 0 |
61475 | 61475 | 2020-02-02 | Trinity | 105 | 12862 | 0 | 0 | 0 | 0 | 0 |
61476 | 61476 | 2020-02-02 | Tulare | 107 | 460477 | 2 | 0 | 0 | 0 | 0 |
61477 | 61477 | 2020-02-02 | Tuolumne | 109 | 53932 | 0 | 0 | 0 | 0 | 0 |
61478 | 61478 | 2020-02-02 | Ventura | 111 | 848112 | 0 | 0 | 0 | 0 | 0 |
61479 | 61479 | 2020-02-02 | Yolo | 113 | 214977 | 0 | 0 | 0 | 0 | 0 |
61480 | 61480 | 2020-02-02 | Yuba | 115 | 75493 | 0 | 0 | 0 | 0 | 0 |
61365 | 61365 | 2020-02-03 | Alameda | 1 | 1643700 | 3 | 0 | 0 | 0 | 0 |
61366 | 61366 | 2020-02-03 | Alpine | 3 | 1148 | 0 | 0 | 0 | 0 | 0 |
61367 | 61367 | 2020-02-03 | Amador | 5 | 37829 | 0 | 0 | 0 | 0 | 0 |
61368 | 61368 | 2020-02-03 | Butte | 7 | 227075 | 0 | 0 | 0 | 0 | 0 |
61369 | 61369 | 2020-02-03 | Calaveras | 9 | 45235 | 0 | 0 | 0 | 0 | 0 |
61370 | 61370 | 2020-02-03 | Colusa | 11 | 21464 | 0 | 0 | 0 | 0 | 0 |
61371 | 61371 | 2020-02-03 | Contra Costa | 13 | 1133247 | 2 | 0 | 0 | 0 | 0 |
61372 | 61372 | 2020-02-03 | Del Norte | 15 | 27424 | 0 | 0 | 0 | 0 | 0 |
61373 | 61373 | 2020-02-03 | El Dorado | 17 | 186661 | 0 | 0 | 0 | 0 | 0 |
61374 | 61374 | 2020-02-03 | Fresno | 19 | 978130 | 0 | 0 | 0 | 0 | 0 |
61375 | 61375 | 2020-02-03 | Glenn | 21 | 27897 | 0 | 0 | 0 | 0 | 0 |
61376 | 61376 | 2020-02-03 | Humboldt | 23 | 135768 | 0 | 0 | 0 | 0 | 0 |
61377 | 61377 | 2020-02-03 | Imperial | 25 | 180216 | 0 | 0 | 0 | 0 | 0 |
61378 | 61378 | 2020-02-03 | Inyo | 27 | 18085 | 0 | 0 | 0 | 0 | 0 |
61379 | 61379 | 2020-02-03 | Kern | 29 | 883053 | 0 | 0 | 0 | 0 | 0 |
61380 | 61380 | 2020-02-03 | Kings | 31 | 150075 | 0 | 0 | 0 | 0 | 0 |
61381 | 61381 | 2020-02-03 | Lake | 33 | 64148 | 0 | 0 | 0 | 0 | 0 |
61382 | 61382 | 2020-02-03 | Lassen | 35 | 31185 | 0 | 0 | 0 | 0 | 0 |
61383 | 61383 | 2020-02-03 | Los Angeles | 37 | 10098052 | 21 | 1 | 0 | 1 | 0 |
61384 | 61384 | 2020-02-03 | Madera | 39 | 155013 | 0 | 0 | 0 | 0 | 0 |
61385 | 61385 | 2020-02-03 | Marin | 41 | 260295 | 0 | 0 | 0 | 0 | 0 |
61386 | 61386 | 2020-02-03 | Mariposa | 43 | 17540 | 0 | 0 | 0 | 0 | 0 |
61387 | 61387 | 2020-02-03 | Mendocino | 45 | 87422 | 0 | 0 | 0 | 0 | 0 |
61388 | 61388 | 2020-02-03 | Merced | 47 | 269075 | 0 | 0 | 0 | 0 | 0 |
61389 | 61389 | 2020-02-03 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
61390 | 61390 | 2020-02-03 | Mono | 51 | 14174 | 0 | 0 | 0 | 0 | 0 |
61391 | 61391 | 2020-02-03 | Monterey | 53 | 433212 | 1 | 0 | 0 | 0 | 0 |
61392 | 61392 | 2020-02-03 | Napa | 55 | 140530 | 0 | 0 | 0 | 0 | 0 |
61393 | 61393 | 2020-02-03 | Nevada | 57 | 99092 | 0 | 0 | 0 | 0 | 0 |
61394 | 61394 | 2020-02-03 | Orange | 59 | 3164182 | 1 | 1 | 0 | 1 | 0 |
61395 | 61395 | 2020-02-03 | Placer | 61 | 380077 | 0 | 0 | 0 | 0 | 0 |
61396 | 61396 | 2020-02-03 | Plumas | 63 | 18699 | 0 | 0 | 0 | 0 | 0 |
61397 | 61397 | 2020-02-03 | Riverside | 65 | 2383286 | 4 | 0 | 0 | 0 | 0 |
61398 | 61398 | 2020-02-03 | Sacramento | 67 | 1510023 | 0 | 0 | 0 | 0 | 0 |
61399 | 61399 | 2020-02-03 | San Benito | 69 | 59416 | 0 | 2 | 0 | 2 | 0 |
61400 | 61400 | 2020-02-03 | San Bernardino | 71 | 2135413 | 3 | 0 | 0 | 0 | 0 |
61401 | 61401 | 2020-02-03 | San Diego | 73 | 3302833 | 0 | 0 | 0 | 0 | 0 |
61402 | 61402 | 2020-02-03 | San Francisco | 75 | 870044 | 1 | 0 | 0 | 0 | 0 |
61403 | 61403 | 2020-02-03 | San Joaquin | 77 | 732212 | 0 | 0 | 1 | 1 | 0 |
61404 | 61404 | 2020-02-03 | San Luis Obispo | 79 | 281455 | 0 | 0 | 0 | 0 | 0 |
61405 | 61405 | 2020-02-03 | San Mateo | 81 | 765935 | 0 | 0 | 0 | 0 | 0 |
61406 | 61406 | 2020-02-03 | Santa Barbara | 83 | 443738 | 0 | 0 | 0 | 0 | 0 |
61407 | 61407 | 2020-02-03 | Santa Clara | 85 | 1922200 | 2 | 2 | 0 | 2 | 0 |
61408 | 61408 | 2020-02-03 | Santa Cruz | 87 | 273765 | 0 | 0 | 0 | 0 | 0 |
61409 | 61409 | 2020-02-03 | Shasta | 89 | 179085 | 0 | 0 | 0 | 0 | 0 |
61410 | 61410 | 2020-02-03 | Sierra | 91 | 2930 | 0 | 0 | 0 | 0 | 0 |
61411 | 61411 | 2020-02-03 | Siskiyou | 93 | 43540 | 0 | 0 | 0 | 0 | 0 |
61412 | 61412 | 2020-02-03 | Solano | 95 | 438530 | 0 | 0 | 0 | 0 | 0 |
61413 | 61413 | 2020-02-03 | Sonoma | 97 | 501317 | 0 | 0 | 0 | 0 | 0 |
61414 | 61414 | 2020-02-03 | Stanislaus | 99 | 539301 | 0 | 0 | 0 | 0 | 0 |
61415 | 61415 | 2020-02-03 | Sutter | 101 | 95872 | 0 | 0 | 0 | 0 | 0 |
61416 | 61416 | 2020-02-03 | Tehama | 103 | 63373 | 0 | 0 | 0 | 0 | 0 |
61417 | 61417 | 2020-02-03 | Trinity | 105 | 12862 | 0 | 0 | 0 | 0 | 0 |
61418 | 61418 | 2020-02-03 | Tulare | 107 | 460477 | 2 | 0 | 0 | 0 | 0 |
61419 | 61419 | 2020-02-03 | Tuolumne | 109 | 53932 | 0 | 0 | 0 | 0 | 0 |
61420 | 61420 | 2020-02-03 | Ventura | 111 | 848112 | 0 | 0 | 0 | 0 | 0 |
61421 | 61421 | 2020-02-03 | Yolo | 113 | 214977 | 0 | 0 | 0 | 0 | 0 |
61422 | 61422 | 2020-02-03 | Yuba | 115 | 75493 | 0 | 0 | 0 | 0 | 0 |
61307 | 61307 | 2020-02-04 | Alameda | 1 | 1643700 | 3 | 0 | 0 | 0 | 0 |
61308 | 61308 | 2020-02-04 | Alpine | 3 | 1148 | 0 | 0 | 0 | 0 | 0 |
61309 | 61309 | 2020-02-04 | Amador | 5 | 37829 | 0 | 0 | 0 | 0 | 0 |
61310 | 61310 | 2020-02-04 | Butte | 7 | 227075 | 0 | 0 | 0 | 0 | 0 |
61311 | 61311 | 2020-02-04 | Calaveras | 9 | 45235 | 0 | 0 | 0 | 0 | 0 |
61312 | 61312 | 2020-02-04 | Colusa | 11 | 21464 | 0 | 0 | 0 | 0 | 0 |
61313 | 61313 | 2020-02-04 | Contra Costa | 13 | 1133247 | 2 | 0 | 0 | 0 | 0 |
61314 | 61314 | 2020-02-04 | Del Norte | 15 | 27424 | 0 | 0 | 0 | 0 | 0 |
61315 | 61315 | 2020-02-04 | El Dorado | 17 | 186661 | 0 | 0 | 0 | 0 | 0 |
61316 | 61316 | 2020-02-04 | Fresno | 19 | 978130 | 0 | 0 | 0 | 0 | 0 |
61317 | 61317 | 2020-02-04 | Glenn | 21 | 27897 | 0 | 0 | 0 | 0 | 0 |
61318 | 61318 | 2020-02-04 | Humboldt | 23 | 135768 | 0 | 0 | 0 | 0 | 0 |
61319 | 61319 | 2020-02-04 | Imperial | 25 | 180216 | 0 | 0 | 0 | 0 | 0 |
61320 | 61320 | 2020-02-04 | Inyo | 27 | 18085 | 0 | 0 | 0 | 0 | 0 |
61321 | 61321 | 2020-02-04 | Kern | 29 | 883053 | 0 | 0 | 0 | 0 | 0 |
61322 | 61322 | 2020-02-04 | Kings | 31 | 150075 | 0 | 0 | 0 | 0 | 0 |
61323 | 61323 | 2020-02-04 | Lake | 33 | 64148 | 0 | 0 | 0 | 0 | 0 |
61324 | 61324 | 2020-02-04 | Lassen | 35 | 31185 | 0 | 0 | 0 | 0 | 0 |
61325 | 61325 | 2020-02-04 | Los Angeles | 37 | 10098052 | 22 | 1 | 0 | 1 | 0 |
61326 | 61326 | 2020-02-04 | Madera | 39 | 155013 | 0 | 0 | 0 | 0 | 0 |
61327 | 61327 | 2020-02-04 | Marin | 41 | 260295 | 0 | 0 | 0 | 0 | 0 |
61328 | 61328 | 2020-02-04 | Mariposa | 43 | 17540 | 0 | 0 | 0 | 0 | 0 |
61329 | 61329 | 2020-02-04 | Mendocino | 45 | 87422 | 0 | 0 | 0 | 0 | 0 |
61330 | 61330 | 2020-02-04 | Merced | 47 | 269075 | 0 | 0 | 0 | 0 | 0 |
61331 | 61331 | 2020-02-04 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
61332 | 61332 | 2020-02-04 | Mono | 51 | 14174 | 0 | 0 | 0 | 0 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "cdph-county-cases-deaths" ( [date] TEXT, [county] TEXT, [fips] INTEGER, [population] INTEGER, [confirmed_cases] INTEGER, [reported_cases] INTEGER, [probable_cases] INTEGER, [reported_and_probable_cases] INTEGER, [reported_deaths] INTEGER );