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.
58 rows where "date" is on date 2020-02-14
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: reported_cases
Link | rowid ▼ | date | county | fips | population | confirmed_cases | reported_cases | probable_cases | reported_and_probable_cases | reported_deaths |
---|---|---|---|---|---|---|---|---|---|---|
60727 | 60727 | 2020-02-14 | Alameda | 1 | 1643700 | 5 | 0 | 0 | 0 | 0 |
60728 | 60728 | 2020-02-14 | Alpine | 3 | 1148 | 0 | 0 | 0 | 0 | 0 |
60729 | 60729 | 2020-02-14 | Amador | 5 | 37829 | 0 | 0 | 0 | 0 | 0 |
60730 | 60730 | 2020-02-14 | Butte | 7 | 227075 | 0 | 0 | 0 | 0 | 0 |
60731 | 60731 | 2020-02-14 | Calaveras | 9 | 45235 | 0 | 0 | 0 | 0 | 0 |
60732 | 60732 | 2020-02-14 | Colusa | 11 | 21464 | 0 | 0 | 0 | 0 | 0 |
60733 | 60733 | 2020-02-14 | Contra Costa | 13 | 1133247 | 3 | 0 | 0 | 0 | 0 |
60734 | 60734 | 2020-02-14 | Del Norte | 15 | 27424 | 0 | 0 | 0 | 0 | 0 |
60735 | 60735 | 2020-02-14 | El Dorado | 17 | 186661 | 0 | 0 | 0 | 0 | 0 |
60736 | 60736 | 2020-02-14 | Fresno | 19 | 978130 | 0 | 0 | 0 | 0 | 0 |
60737 | 60737 | 2020-02-14 | Glenn | 21 | 27897 | 0 | 0 | 0 | 0 | 0 |
60738 | 60738 | 2020-02-14 | Humboldt | 23 | 135768 | 1 | 0 | 0 | 0 | 0 |
60739 | 60739 | 2020-02-14 | Imperial | 25 | 180216 | 0 | 0 | 0 | 0 | 0 |
60740 | 60740 | 2020-02-14 | Inyo | 27 | 18085 | 0 | 0 | 0 | 0 | 0 |
60741 | 60741 | 2020-02-14 | Kern | 29 | 883053 | 2 | 0 | 0 | 0 | 0 |
60742 | 60742 | 2020-02-14 | Kings | 31 | 150075 | 0 | 0 | 0 | 0 | 0 |
60743 | 60743 | 2020-02-14 | Lake | 33 | 64148 | 0 | 0 | 0 | 0 | 0 |
60744 | 60744 | 2020-02-14 | Lassen | 35 | 31185 | 0 | 0 | 0 | 0 | 0 |
60745 | 60745 | 2020-02-14 | Los Angeles | 37 | 10098052 | 34 | 1 | 4 | 5 | 0 |
60746 | 60746 | 2020-02-14 | Madera | 39 | 155013 | 0 | 0 | 0 | 0 | 0 |
60747 | 60747 | 2020-02-14 | Marin | 41 | 260295 | 0 | 0 | 0 | 0 | 0 |
60748 | 60748 | 2020-02-14 | Mariposa | 43 | 17540 | 0 | 0 | 0 | 0 | 0 |
60749 | 60749 | 2020-02-14 | Mendocino | 45 | 87422 | 0 | 0 | 0 | 0 | 0 |
60750 | 60750 | 2020-02-14 | Merced | 47 | 269075 | 0 | 0 | 0 | 0 | 0 |
60751 | 60751 | 2020-02-14 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
60752 | 60752 | 2020-02-14 | Mono | 51 | 14174 | 0 | 0 | 0 | 0 | 0 |
60753 | 60753 | 2020-02-14 | Monterey | 53 | 433212 | 1 | 0 | 0 | 0 | 0 |
60754 | 60754 | 2020-02-14 | Napa | 55 | 140530 | 0 | 0 | 0 | 0 | 0 |
60755 | 60755 | 2020-02-14 | Nevada | 57 | 99092 | 0 | 0 | 0 | 0 | 0 |
60756 | 60756 | 2020-02-14 | Orange | 59 | 3164182 | 37 | 1 | 0 | 1 | 0 |
60757 | 60757 | 2020-02-14 | Placer | 61 | 380077 | 0 | 0 | 0 | 0 | 0 |
60758 | 60758 | 2020-02-14 | Plumas | 63 | 18699 | 0 | 0 | 0 | 0 | 0 |
60759 | 60759 | 2020-02-14 | Riverside | 65 | 2383286 | 4 | 0 | 0 | 0 | 0 |
60760 | 60760 | 2020-02-14 | Sacramento | 67 | 1510023 | 1 | 0 | 0 | 0 | 0 |
60761 | 60761 | 2020-02-14 | San Benito | 69 | 59416 | 0 | 2 | 0 | 2 | 0 |
60762 | 60762 | 2020-02-14 | San Bernardino | 71 | 2135413 | 9 | 0 | 0 | 0 | 0 |
60763 | 60763 | 2020-02-14 | San Diego | 73 | 3302833 | 1 | 2 | 0 | 2 | 0 |
60764 | 60764 | 2020-02-14 | San Francisco | 75 | 870044 | 2 | 0 | 0 | 0 | 0 |
60765 | 60765 | 2020-02-14 | San Joaquin | 77 | 732212 | 1 | 0 | 1 | 1 | 0 |
60766 | 60766 | 2020-02-14 | San Luis Obispo | 79 | 281455 | 0 | 0 | 0 | 0 | 0 |
60767 | 60767 | 2020-02-14 | San Mateo | 81 | 765935 | 3 | 0 | 0 | 0 | 0 |
60768 | 60768 | 2020-02-14 | Santa Barbara | 83 | 443738 | 0 | 0 | 0 | 0 | 0 |
60769 | 60769 | 2020-02-14 | Santa Clara | 85 | 1922200 | 8 | 2 | 1 | 3 | 0 |
60770 | 60770 | 2020-02-14 | Santa Cruz | 87 | 273765 | 0 | 0 | 0 | 0 | 0 |
60771 | 60771 | 2020-02-14 | Shasta | 89 | 179085 | 0 | 0 | 0 | 0 | 0 |
60772 | 60772 | 2020-02-14 | Sierra | 91 | 2930 | 0 | 0 | 0 | 0 | 0 |
60773 | 60773 | 2020-02-14 | Siskiyou | 93 | 43540 | 0 | 0 | 0 | 0 | 0 |
60774 | 60774 | 2020-02-14 | Solano | 95 | 438530 | 1 | 0 | 0 | 0 | 0 |
60775 | 60775 | 2020-02-14 | Sonoma | 97 | 501317 | 0 | 0 | 0 | 0 | 0 |
60776 | 60776 | 2020-02-14 | Stanislaus | 99 | 539301 | 1 | 0 | 2 | 2 | 0 |
60777 | 60777 | 2020-02-14 | Sutter | 101 | 95872 | 0 | 0 | 0 | 0 | 0 |
60778 | 60778 | 2020-02-14 | Tehama | 103 | 63373 | 0 | 0 | 0 | 0 | 0 |
60779 | 60779 | 2020-02-14 | Trinity | 105 | 12862 | 0 | 0 | 0 | 0 | 0 |
60780 | 60780 | 2020-02-14 | Tulare | 107 | 460477 | 2 | 0 | 0 | 0 | 0 |
60781 | 60781 | 2020-02-14 | Tuolumne | 109 | 53932 | 0 | 0 | 0 | 0 | 0 |
60782 | 60782 | 2020-02-14 | Ventura | 111 | 848112 | 2 | 0 | 0 | 0 | 0 |
60783 | 60783 | 2020-02-14 | Yolo | 113 | 214977 | 0 | 0 | 0 | 0 | 0 |
60784 | 60784 | 2020-02-14 | Yuba | 115 | 75493 | 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 );