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-08 sorted by probable_cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: reported_cases, reported_and_probable_cases
Link | rowid | date | county | fips | population | confirmed_cases | reported_cases | probable_cases ▼ | reported_and_probable_cases | reported_deaths |
---|---|---|---|---|---|---|---|---|---|---|
61075 | 61075 | 2020-02-08 | Alameda | 1 | 1643700 | 4 | 0 | 0 | 0 | 0 |
61076 | 61076 | 2020-02-08 | Alpine | 3 | 1148 | 0 | 0 | 0 | 0 | 0 |
61077 | 61077 | 2020-02-08 | Amador | 5 | 37829 | 0 | 0 | 0 | 0 | 0 |
61078 | 61078 | 2020-02-08 | Butte | 7 | 227075 | 0 | 0 | 0 | 0 | 0 |
61079 | 61079 | 2020-02-08 | Calaveras | 9 | 45235 | 0 | 0 | 0 | 0 | 0 |
61080 | 61080 | 2020-02-08 | Colusa | 11 | 21464 | 0 | 0 | 0 | 0 | 0 |
61081 | 61081 | 2020-02-08 | Contra Costa | 13 | 1133247 | 2 | 0 | 0 | 0 | 0 |
61082 | 61082 | 2020-02-08 | Del Norte | 15 | 27424 | 0 | 0 | 0 | 0 | 0 |
61083 | 61083 | 2020-02-08 | El Dorado | 17 | 186661 | 0 | 0 | 0 | 0 | 0 |
61084 | 61084 | 2020-02-08 | Fresno | 19 | 978130 | 0 | 0 | 0 | 0 | 0 |
61085 | 61085 | 2020-02-08 | Glenn | 21 | 27897 | 0 | 0 | 0 | 0 | 0 |
61086 | 61086 | 2020-02-08 | Humboldt | 23 | 135768 | 0 | 0 | 0 | 0 | 0 |
61087 | 61087 | 2020-02-08 | Imperial | 25 | 180216 | 0 | 0 | 0 | 0 | 0 |
61088 | 61088 | 2020-02-08 | Inyo | 27 | 18085 | 0 | 0 | 0 | 0 | 0 |
61089 | 61089 | 2020-02-08 | Kern | 29 | 883053 | 2 | 0 | 0 | 0 | 0 |
61090 | 61090 | 2020-02-08 | Kings | 31 | 150075 | 0 | 0 | 0 | 0 | 0 |
61091 | 61091 | 2020-02-08 | Lake | 33 | 64148 | 0 | 0 | 0 | 0 | 0 |
61092 | 61092 | 2020-02-08 | Lassen | 35 | 31185 | 0 | 0 | 0 | 0 | 0 |
61094 | 61094 | 2020-02-08 | Madera | 39 | 155013 | 0 | 0 | 0 | 0 | 0 |
61095 | 61095 | 2020-02-08 | Marin | 41 | 260295 | 0 | 0 | 0 | 0 | 0 |
61096 | 61096 | 2020-02-08 | Mariposa | 43 | 17540 | 0 | 0 | 0 | 0 | 0 |
61097 | 61097 | 2020-02-08 | Mendocino | 45 | 87422 | 0 | 0 | 0 | 0 | 0 |
61098 | 61098 | 2020-02-08 | Merced | 47 | 269075 | 0 | 0 | 0 | 0 | 0 |
61099 | 61099 | 2020-02-08 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
61100 | 61100 | 2020-02-08 | Mono | 51 | 14174 | 0 | 0 | 0 | 0 | 0 |
61101 | 61101 | 2020-02-08 | Monterey | 53 | 433212 | 1 | 0 | 0 | 0 | 0 |
61102 | 61102 | 2020-02-08 | Napa | 55 | 140530 | 0 | 0 | 0 | 0 | 0 |
61103 | 61103 | 2020-02-08 | Nevada | 57 | 99092 | 0 | 0 | 0 | 0 | 0 |
61104 | 61104 | 2020-02-08 | Orange | 59 | 3164182 | 35 | 1 | 0 | 1 | 0 |
61105 | 61105 | 2020-02-08 | Placer | 61 | 380077 | 0 | 0 | 0 | 0 | 0 |
61106 | 61106 | 2020-02-08 | Plumas | 63 | 18699 | 0 | 0 | 0 | 0 | 0 |
61107 | 61107 | 2020-02-08 | Riverside | 65 | 2383286 | 4 | 0 | 0 | 0 | 0 |
61108 | 61108 | 2020-02-08 | Sacramento | 67 | 1510023 | 0 | 0 | 0 | 0 | 0 |
61109 | 61109 | 2020-02-08 | San Benito | 69 | 59416 | 0 | 2 | 0 | 2 | 0 |
61110 | 61110 | 2020-02-08 | San Bernardino | 71 | 2135413 | 7 | 0 | 0 | 0 | 0 |
61111 | 61111 | 2020-02-08 | San Diego | 73 | 3302833 | 0 | 0 | 0 | 0 | 0 |
61112 | 61112 | 2020-02-08 | San Francisco | 75 | 870044 | 1 | 0 | 0 | 0 | 0 |
61114 | 61114 | 2020-02-08 | San Luis Obispo | 79 | 281455 | 0 | 0 | 0 | 0 | 0 |
61115 | 61115 | 2020-02-08 | San Mateo | 81 | 765935 | 2 | 0 | 0 | 0 | 0 |
61116 | 61116 | 2020-02-08 | Santa Barbara | 83 | 443738 | 0 | 0 | 0 | 0 | 0 |
61117 | 61117 | 2020-02-08 | Santa Clara | 85 | 1922200 | 4 | 2 | 0 | 2 | 0 |
61118 | 61118 | 2020-02-08 | Santa Cruz | 87 | 273765 | 0 | 0 | 0 | 0 | 0 |
61119 | 61119 | 2020-02-08 | Shasta | 89 | 179085 | 0 | 0 | 0 | 0 | 0 |
61120 | 61120 | 2020-02-08 | Sierra | 91 | 2930 | 0 | 0 | 0 | 0 | 0 |
61121 | 61121 | 2020-02-08 | Siskiyou | 93 | 43540 | 0 | 0 | 0 | 0 | 0 |
61122 | 61122 | 2020-02-08 | Solano | 95 | 438530 | 0 | 0 | 0 | 0 | 0 |
61123 | 61123 | 2020-02-08 | Sonoma | 97 | 501317 | 0 | 0 | 0 | 0 | 0 |
61124 | 61124 | 2020-02-08 | Stanislaus | 99 | 539301 | 0 | 0 | 0 | 0 | 0 |
61125 | 61125 | 2020-02-08 | Sutter | 101 | 95872 | 0 | 0 | 0 | 0 | 0 |
61126 | 61126 | 2020-02-08 | Tehama | 103 | 63373 | 0 | 0 | 0 | 0 | 0 |
61127 | 61127 | 2020-02-08 | Trinity | 105 | 12862 | 0 | 0 | 0 | 0 | 0 |
61128 | 61128 | 2020-02-08 | Tulare | 107 | 460477 | 2 | 0 | 0 | 0 | 0 |
61129 | 61129 | 2020-02-08 | Tuolumne | 109 | 53932 | 0 | 0 | 0 | 0 | 0 |
61130 | 61130 | 2020-02-08 | Ventura | 111 | 848112 | 1 | 0 | 0 | 0 | 0 |
61131 | 61131 | 2020-02-08 | Yolo | 113 | 214977 | 0 | 0 | 0 | 0 | 0 |
61132 | 61132 | 2020-02-08 | Yuba | 115 | 75493 | 0 | 0 | 0 | 0 | 0 |
61093 | 61093 | 2020-02-08 | Los Angeles | 37 | 10098052 | 24 | 1 | 1 | 2 | 0 |
61113 | 61113 | 2020-02-08 | San Joaquin | 77 | 732212 | 0 | 0 | 1 | 1 | 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 );