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)
Suggested facets: date (date)
Link | rowid | date ▼ | county | fips | population | confirmed_cases | reported_cases | probable_cases | reported_and_probable_cases | reported_deaths |
---|---|---|---|---|---|---|---|---|---|---|
61481 | 61481 | 2020-02-01 | Alameda | 1 | 1643700 | 3 | 0 | 0 | 0 | 0 |
61482 | 61482 | 2020-02-01 | Alpine | 3 | 1148 | 0 | 0 | 0 | 0 | 0 |
61483 | 61483 | 2020-02-01 | Amador | 5 | 37829 | 0 | 0 | 0 | 0 | 0 |
61484 | 61484 | 2020-02-01 | Butte | 7 | 227075 | 0 | 0 | 0 | 0 | 0 |
61485 | 61485 | 2020-02-01 | Calaveras | 9 | 45235 | 0 | 0 | 0 | 0 | 0 |
61486 | 61486 | 2020-02-01 | Colusa | 11 | 21464 | 0 | 0 | 0 | 0 | 0 |
61487 | 61487 | 2020-02-01 | Contra Costa | 13 | 1133247 | 0 | 0 | 0 | 0 | 0 |
61488 | 61488 | 2020-02-01 | Del Norte | 15 | 27424 | 0 | 0 | 0 | 0 | 0 |
61489 | 61489 | 2020-02-01 | El Dorado | 17 | 186661 | 0 | 0 | 0 | 0 | 0 |
61490 | 61490 | 2020-02-01 | Fresno | 19 | 978130 | 0 | 0 | 0 | 0 | 0 |
61491 | 61491 | 2020-02-01 | Glenn | 21 | 27897 | 0 | 0 | 0 | 0 | 0 |
61492 | 61492 | 2020-02-01 | Humboldt | 23 | 135768 | 0 | 0 | 0 | 0 | 0 |
61493 | 61493 | 2020-02-01 | Imperial | 25 | 180216 | 0 | 0 | 0 | 0 | 0 |
61494 | 61494 | 2020-02-01 | Inyo | 27 | 18085 | 0 | 0 | 0 | 0 | 0 |
61495 | 61495 | 2020-02-01 | Kern | 29 | 883053 | 0 | 0 | 0 | 0 | 0 |
61496 | 61496 | 2020-02-01 | Kings | 31 | 150075 | 0 | 0 | 0 | 0 | 0 |
61497 | 61497 | 2020-02-01 | Lake | 33 | 64148 | 0 | 0 | 0 | 0 | 0 |
61498 | 61498 | 2020-02-01 | Lassen | 35 | 31185 | 0 | 0 | 0 | 0 | 0 |
61499 | 61499 | 2020-02-01 | Los Angeles | 37 | 10098052 | 13 | 1 | 0 | 1 | 0 |
61500 | 61500 | 2020-02-01 | Madera | 39 | 155013 | 0 | 0 | 0 | 0 | 0 |
61501 | 61501 | 2020-02-01 | Marin | 41 | 260295 | 0 | 0 | 0 | 0 | 0 |
61502 | 61502 | 2020-02-01 | Mariposa | 43 | 17540 | 0 | 0 | 0 | 0 | 0 |
61503 | 61503 | 2020-02-01 | Mendocino | 45 | 87422 | 0 | 0 | 0 | 0 | 0 |
61504 | 61504 | 2020-02-01 | Merced | 47 | 269075 | 0 | 0 | 0 | 0 | 0 |
61505 | 61505 | 2020-02-01 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
61506 | 61506 | 2020-02-01 | Mono | 51 | 14174 | 0 | 0 | 0 | 0 | 0 |
61507 | 61507 | 2020-02-01 | Monterey | 53 | 433212 | 0 | 0 | 0 | 0 | 0 |
61508 | 61508 | 2020-02-01 | Napa | 55 | 140530 | 0 | 0 | 0 | 0 | 0 |
61509 | 61509 | 2020-02-01 | Nevada | 57 | 99092 | 0 | 0 | 0 | 0 | 0 |
61510 | 61510 | 2020-02-01 | Orange | 59 | 3164182 | 1 | 1 | 0 | 1 | 0 |
61511 | 61511 | 2020-02-01 | Placer | 61 | 380077 | 0 | 0 | 0 | 0 | 0 |
61512 | 61512 | 2020-02-01 | Plumas | 63 | 18699 | 0 | 0 | 0 | 0 | 0 |
61513 | 61513 | 2020-02-01 | Riverside | 65 | 2383286 | 2 | 0 | 0 | 0 | 0 |
61514 | 61514 | 2020-02-01 | Sacramento | 67 | 1510023 | 0 | 0 | 0 | 0 | 0 |
61515 | 61515 | 2020-02-01 | San Benito | 69 | 59416 | 0 | 0 | 0 | 0 | 0 |
61516 | 61516 | 2020-02-01 | San Bernardino | 71 | 2135413 | 1 | 0 | 0 | 0 | 0 |
61517 | 61517 | 2020-02-01 | San Diego | 73 | 3302833 | 0 | 0 | 0 | 0 | 0 |
61518 | 61518 | 2020-02-01 | San Francisco | 75 | 870044 | 1 | 0 | 0 | 0 | 0 |
61519 | 61519 | 2020-02-01 | San Joaquin | 77 | 732212 | 0 | 0 | 1 | 1 | 0 |
61520 | 61520 | 2020-02-01 | San Luis Obispo | 79 | 281455 | 0 | 0 | 0 | 0 | 0 |
61521 | 61521 | 2020-02-01 | San Mateo | 81 | 765935 | 0 | 0 | 0 | 0 | 0 |
61522 | 61522 | 2020-02-01 | Santa Barbara | 83 | 443738 | 0 | 0 | 0 | 0 | 0 |
61523 | 61523 | 2020-02-01 | Santa Clara | 85 | 1922200 | 2 | 1 | 0 | 1 | 0 |
61524 | 61524 | 2020-02-01 | Santa Cruz | 87 | 273765 | 0 | 0 | 0 | 0 | 0 |
61525 | 61525 | 2020-02-01 | Shasta | 89 | 179085 | 0 | 0 | 0 | 0 | 0 |
61526 | 61526 | 2020-02-01 | Sierra | 91 | 2930 | 0 | 0 | 0 | 0 | 0 |
61527 | 61527 | 2020-02-01 | Siskiyou | 93 | 43540 | 0 | 0 | 0 | 0 | 0 |
61528 | 61528 | 2020-02-01 | Solano | 95 | 438530 | 0 | 0 | 0 | 0 | 0 |
61529 | 61529 | 2020-02-01 | Sonoma | 97 | 501317 | 0 | 0 | 0 | 0 | 0 |
61530 | 61530 | 2020-02-01 | Stanislaus | 99 | 539301 | 0 | 0 | 0 | 0 | 0 |
61531 | 61531 | 2020-02-01 | Sutter | 101 | 95872 | 0 | 0 | 0 | 0 | 0 |
61532 | 61532 | 2020-02-01 | Tehama | 103 | 63373 | 0 | 0 | 0 | 0 | 0 |
61533 | 61533 | 2020-02-01 | Trinity | 105 | 12862 | 0 | 0 | 0 | 0 | 0 |
61534 | 61534 | 2020-02-01 | Tulare | 107 | 460477 | 1 | 0 | 0 | 0 | 0 |
61535 | 61535 | 2020-02-01 | Tuolumne | 109 | 53932 | 0 | 0 | 0 | 0 | 0 |
61536 | 61536 | 2020-02-01 | Ventura | 111 | 848112 | 0 | 0 | 0 | 0 | 0 |
61537 | 61537 | 2020-02-01 | Yolo | 113 | 214977 | 0 | 0 | 0 | 0 | 0 |
61538 | 61538 | 2020-02-01 | Yuba | 115 | 75493 | 0 | 0 | 0 | 0 | 0 |
61423 | 61423 | 2020-02-02 | Alameda | 1 | 1643700 | 3 | 0 | 0 | 0 | 0 |
61424 | 61424 | 2020-02-02 | Alpine | 3 | 1148 | 0 | 0 | 0 | 0 | 0 |
61425 | 61425 | 2020-02-02 | Amador | 5 | 37829 | 0 | 0 | 0 | 0 | 0 |
61426 | 61426 | 2020-02-02 | Butte | 7 | 227075 | 0 | 0 | 0 | 0 | 0 |
61427 | 61427 | 2020-02-02 | Calaveras | 9 | 45235 | 0 | 0 | 0 | 0 | 0 |
61428 | 61428 | 2020-02-02 | Colusa | 11 | 21464 | 0 | 0 | 0 | 0 | 0 |
61429 | 61429 | 2020-02-02 | Contra Costa | 13 | 1133247 | 1 | 0 | 0 | 0 | 0 |
61430 | 61430 | 2020-02-02 | Del Norte | 15 | 27424 | 0 | 0 | 0 | 0 | 0 |
61431 | 61431 | 2020-02-02 | El Dorado | 17 | 186661 | 0 | 0 | 0 | 0 | 0 |
61432 | 61432 | 2020-02-02 | Fresno | 19 | 978130 | 0 | 0 | 0 | 0 | 0 |
61433 | 61433 | 2020-02-02 | Glenn | 21 | 27897 | 0 | 0 | 0 | 0 | 0 |
61434 | 61434 | 2020-02-02 | Humboldt | 23 | 135768 | 0 | 0 | 0 | 0 | 0 |
61435 | 61435 | 2020-02-02 | Imperial | 25 | 180216 | 0 | 0 | 0 | 0 | 0 |
61436 | 61436 | 2020-02-02 | Inyo | 27 | 18085 | 0 | 0 | 0 | 0 | 0 |
61437 | 61437 | 2020-02-02 | Kern | 29 | 883053 | 0 | 0 | 0 | 0 | 0 |
61438 | 61438 | 2020-02-02 | Kings | 31 | 150075 | 0 | 0 | 0 | 0 | 0 |
61439 | 61439 | 2020-02-02 | Lake | 33 | 64148 | 0 | 0 | 0 | 0 | 0 |
61440 | 61440 | 2020-02-02 | Lassen | 35 | 31185 | 0 | 0 | 0 | 0 | 0 |
61441 | 61441 | 2020-02-02 | Los Angeles | 37 | 10098052 | 17 | 1 | 0 | 1 | 0 |
61442 | 61442 | 2020-02-02 | Madera | 39 | 155013 | 0 | 0 | 0 | 0 | 0 |
61443 | 61443 | 2020-02-02 | Marin | 41 | 260295 | 0 | 0 | 0 | 0 | 0 |
61444 | 61444 | 2020-02-02 | Mariposa | 43 | 17540 | 0 | 0 | 0 | 0 | 0 |
61445 | 61445 | 2020-02-02 | Mendocino | 45 | 87422 | 0 | 0 | 0 | 0 | 0 |
61446 | 61446 | 2020-02-02 | Merced | 47 | 269075 | 0 | 0 | 0 | 0 | 0 |
61447 | 61447 | 2020-02-02 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
61448 | 61448 | 2020-02-02 | Mono | 51 | 14174 | 0 | 0 | 0 | 0 | 0 |
61449 | 61449 | 2020-02-02 | Monterey | 53 | 433212 | 1 | 0 | 0 | 0 | 0 |
61450 | 61450 | 2020-02-02 | Napa | 55 | 140530 | 0 | 0 | 0 | 0 | 0 |
61451 | 61451 | 2020-02-02 | Nevada | 57 | 99092 | 0 | 0 | 0 | 0 | 0 |
61452 | 61452 | 2020-02-02 | Orange | 59 | 3164182 | 1 | 1 | 0 | 1 | 0 |
61453 | 61453 | 2020-02-02 | Placer | 61 | 380077 | 0 | 0 | 0 | 0 | 0 |
61454 | 61454 | 2020-02-02 | Plumas | 63 | 18699 | 0 | 0 | 0 | 0 | 0 |
61455 | 61455 | 2020-02-02 | Riverside | 65 | 2383286 | 3 | 0 | 0 | 0 | 0 |
61456 | 61456 | 2020-02-02 | Sacramento | 67 | 1510023 | 0 | 0 | 0 | 0 | 0 |
61457 | 61457 | 2020-02-02 | San Benito | 69 | 59416 | 0 | 2 | 0 | 2 | 0 |
61458 | 61458 | 2020-02-02 | San Bernardino | 71 | 2135413 | 2 | 0 | 0 | 0 | 0 |
61459 | 61459 | 2020-02-02 | San Diego | 73 | 3302833 | 0 | 0 | 0 | 0 | 0 |
61460 | 61460 | 2020-02-02 | San Francisco | 75 | 870044 | 1 | 0 | 0 | 0 | 0 |
61461 | 61461 | 2020-02-02 | San Joaquin | 77 | 732212 | 0 | 0 | 1 | 1 | 0 |
61462 | 61462 | 2020-02-02 | San Luis Obispo | 79 | 281455 | 0 | 0 | 0 | 0 | 0 |
61463 | 61463 | 2020-02-02 | San Mateo | 81 | 765935 | 0 | 0 | 0 | 0 | 0 |
61464 | 61464 | 2020-02-02 | Santa Barbara | 83 | 443738 | 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 );