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 probable_cases
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 |
---|---|---|---|---|---|---|---|---|---|---|
19954 | 19954 | 2022-01-17 | Alpine | 3 | 1148 | 116 | 118 | 0 | 118 | 0 |
20012 | 20012 | 2022-01-16 | Alpine | 3 | 1148 | 116 | 118 | 0 | 118 | 0 |
20070 | 20070 | 2022-01-15 | Alpine | 3 | 1148 | 116 | 117 | 0 | 117 | 0 |
20128 | 20128 | 2022-01-14 | Alpine | 3 | 1148 | 116 | 117 | 0 | 117 | 0 |
20186 | 20186 | 2022-01-13 | Alpine | 3 | 1148 | 115 | 117 | 0 | 117 | 0 |
20244 | 20244 | 2022-01-12 | Alpine | 3 | 1148 | 115 | 117 | 0 | 117 | 0 |
20302 | 20302 | 2022-01-11 | Alpine | 3 | 1148 | 115 | 116 | 0 | 116 | 0 |
20360 | 20360 | 2022-01-10 | Alpine | 3 | 1148 | 115 | 116 | 0 | 116 | 0 |
20418 | 20418 | 2022-01-09 | Alpine | 3 | 1148 | 115 | 116 | 0 | 116 | 0 |
20476 | 20476 | 2022-01-08 | Alpine | 3 | 1148 | 115 | 114 | 0 | 114 | 0 |
20534 | 20534 | 2022-01-07 | Alpine | 3 | 1148 | 115 | 114 | 0 | 114 | 0 |
20592 | 20592 | 2022-01-06 | Alpine | 3 | 1148 | 114 | 114 | 0 | 114 | 0 |
20650 | 20650 | 2022-01-05 | Alpine | 3 | 1148 | 114 | 112 | 0 | 112 | 0 |
20708 | 20708 | 2022-01-04 | Alpine | 3 | 1148 | 114 | 113 | 0 | 113 | 0 |
20766 | 20766 | 2022-01-03 | Alpine | 3 | 1148 | 113 | 113 | 0 | 113 | 0 |
20824 | 20824 | 2022-01-02 | Alpine | 3 | 1148 | 111 | 113 | 0 | 113 | 0 |
20882 | 20882 | 2022-01-01 | Alpine | 3 | 1148 | 111 | 113 | 0 | 113 | 0 |
20940 | 20940 | 2021-12-31 | Alpine | 3 | 1148 | 111 | 113 | 0 | 113 | 0 |
20998 | 20998 | 2021-12-30 | Alpine | 3 | 1148 | 110 | 113 | 0 | 113 | 0 |
21056 | 21056 | 2021-12-29 | Alpine | 3 | 1148 | 110 | 113 | 0 | 113 | 0 |
21114 | 21114 | 2021-12-28 | Alpine | 3 | 1148 | 110 | 113 | 0 | 113 | 0 |
21172 | 21172 | 2021-12-27 | Alpine | 3 | 1148 | 110 | 113 | 0 | 113 | 0 |
21230 | 21230 | 2021-12-26 | Alpine | 3 | 1148 | 110 | 113 | 0 | 113 | 0 |
21288 | 21288 | 2021-12-25 | Alpine | 3 | 1148 | 110 | 113 | 0 | 113 | 0 |
21346 | 21346 | 2021-12-24 | Alpine | 3 | 1148 | 110 | 113 | 0 | 113 | 0 |
21404 | 21404 | 2021-12-23 | Alpine | 3 | 1148 | 110 | 113 | 0 | 113 | 0 |
21462 | 21462 | 2021-12-22 | Alpine | 3 | 1148 | 110 | 112 | 0 | 112 | 0 |
21520 | 21520 | 2021-12-21 | Alpine | 3 | 1148 | 110 | 112 | 0 | 112 | 0 |
21578 | 21578 | 2021-12-20 | Alpine | 3 | 1148 | 110 | 112 | 0 | 112 | 0 |
21636 | 21636 | 2021-12-19 | Alpine | 3 | 1148 | 110 | 112 | 0 | 112 | 0 |
21694 | 21694 | 2021-12-18 | Alpine | 3 | 1148 | 110 | 110 | 0 | 110 | 0 |
21752 | 21752 | 2021-12-17 | Alpine | 3 | 1148 | 110 | 110 | 0 | 110 | 0 |
21810 | 21810 | 2021-12-16 | Alpine | 3 | 1148 | 108 | 110 | 0 | 110 | 0 |
21868 | 21868 | 2021-12-15 | Alpine | 3 | 1148 | 108 | 109 | 0 | 109 | 0 |
21926 | 21926 | 2021-12-14 | Alpine | 3 | 1148 | 107 | 109 | 0 | 109 | 0 |
21984 | 21984 | 2021-12-13 | Alpine | 3 | 1148 | 107 | 109 | 0 | 109 | 0 |
22042 | 22042 | 2021-12-12 | Alpine | 3 | 1148 | 107 | 109 | 0 | 109 | 0 |
22100 | 22100 | 2021-12-11 | Alpine | 3 | 1148 | 107 | 109 | 0 | 109 | 0 |
22158 | 22158 | 2021-12-10 | Alpine | 3 | 1148 | 106 | 109 | 0 | 109 | 0 |
22216 | 22216 | 2021-12-09 | Alpine | 3 | 1148 | 106 | 109 | 0 | 109 | 0 |
22274 | 22274 | 2021-12-08 | Alpine | 3 | 1148 | 106 | 108 | 0 | 108 | 0 |
22332 | 22332 | 2021-12-07 | Alpine | 3 | 1148 | 106 | 108 | 0 | 108 | 0 |
22390 | 22390 | 2021-12-06 | Alpine | 3 | 1148 | 106 | 108 | 0 | 108 | 0 |
22448 | 22448 | 2021-12-05 | Alpine | 3 | 1148 | 105 | 108 | 0 | 108 | 0 |
22506 | 22506 | 2021-12-04 | Alpine | 3 | 1148 | 105 | 108 | 0 | 108 | 0 |
22564 | 22564 | 2021-12-03 | Alpine | 3 | 1148 | 105 | 108 | 0 | 108 | 0 |
22622 | 22622 | 2021-12-02 | Alpine | 3 | 1148 | 105 | 108 | 0 | 108 | 0 |
22680 | 22680 | 2021-12-01 | Alpine | 3 | 1148 | 105 | 108 | 0 | 108 | 0 |
22738 | 22738 | 2021-11-30 | Alpine | 3 | 1148 | 105 | 108 | 0 | 108 | 0 |
22796 | 22796 | 2021-11-29 | Alpine | 3 | 1148 | 105 | 108 | 0 | 108 | 0 |
22854 | 22854 | 2021-11-28 | Alpine | 3 | 1148 | 105 | 108 | 0 | 108 | 0 |
22912 | 22912 | 2021-11-27 | Alpine | 3 | 1148 | 105 | 106 | 0 | 106 | 0 |
22970 | 22970 | 2021-11-26 | Alpine | 3 | 1148 | 105 | 106 | 0 | 106 | 0 |
23028 | 23028 | 2021-11-25 | Alpine | 3 | 1148 | 105 | 106 | 0 | 106 | 0 |
23086 | 23086 | 2021-11-24 | Alpine | 3 | 1148 | 105 | 106 | 0 | 106 | 0 |
23144 | 23144 | 2021-11-23 | Alpine | 3 | 1148 | 105 | 106 | 0 | 106 | 0 |
23202 | 23202 | 2021-11-22 | Alpine | 3 | 1148 | 105 | 106 | 0 | 106 | 0 |
23260 | 23260 | 2021-11-21 | Alpine | 3 | 1148 | 103 | 106 | 0 | 106 | 0 |
23318 | 23318 | 2021-11-20 | Alpine | 3 | 1148 | 103 | 105 | 0 | 105 | 0 |
23376 | 23376 | 2021-11-19 | Alpine | 3 | 1148 | 103 | 105 | 0 | 105 | 0 |
23434 | 23434 | 2021-11-18 | Alpine | 3 | 1148 | 103 | 105 | 0 | 105 | 0 |
23492 | 23492 | 2021-11-17 | Alpine | 3 | 1148 | 103 | 105 | 0 | 105 | 0 |
23550 | 23550 | 2021-11-16 | Alpine | 3 | 1148 | 103 | 105 | 0 | 105 | 0 |
23608 | 23608 | 2021-11-15 | Alpine | 3 | 1148 | 103 | 105 | 0 | 105 | 0 |
23666 | 23666 | 2021-11-14 | Alpine | 3 | 1148 | 102 | 105 | 0 | 105 | 0 |
23724 | 23724 | 2021-11-13 | Alpine | 3 | 1148 | 102 | 105 | 0 | 105 | 0 |
23782 | 23782 | 2021-11-12 | Alpine | 3 | 1148 | 102 | 105 | 0 | 105 | 0 |
23840 | 23840 | 2021-11-11 | Alpine | 3 | 1148 | 102 | 105 | 0 | 105 | 0 |
23898 | 23898 | 2021-11-10 | Alpine | 3 | 1148 | 102 | 105 | 0 | 105 | 0 |
23956 | 23956 | 2021-11-09 | Alpine | 3 | 1148 | 102 | 105 | 0 | 105 | 0 |
24014 | 24014 | 2021-11-08 | Alpine | 3 | 1148 | 102 | 105 | 0 | 105 | 0 |
24072 | 24072 | 2021-11-07 | Alpine | 3 | 1148 | 102 | 105 | 0 | 105 | 0 |
24130 | 24130 | 2021-11-06 | Alpine | 3 | 1148 | 102 | 105 | 0 | 105 | 0 |
24188 | 24188 | 2021-11-05 | Alpine | 3 | 1148 | 102 | 105 | 0 | 105 | 0 |
24246 | 24246 | 2021-11-04 | Alpine | 3 | 1148 | 102 | 105 | 0 | 105 | 0 |
24304 | 24304 | 2021-11-03 | Alpine | 3 | 1148 | 102 | 105 | 0 | 105 | 0 |
24362 | 24362 | 2021-11-02 | Alpine | 3 | 1148 | 101 | 105 | 0 | 105 | 0 |
24420 | 24420 | 2021-11-01 | Alpine | 3 | 1148 | 101 | 105 | 0 | 105 | 0 |
24478 | 24478 | 2021-10-31 | Alpine | 3 | 1148 | 101 | 105 | 0 | 105 | 0 |
24536 | 24536 | 2021-10-30 | Alpine | 3 | 1148 | 101 | 105 | 0 | 105 | 0 |
24594 | 24594 | 2021-10-29 | Alpine | 3 | 1148 | 101 | 105 | 0 | 105 | 0 |
24652 | 24652 | 2021-10-28 | Alpine | 3 | 1148 | 101 | 105 | 0 | 105 | 0 |
24710 | 24710 | 2021-10-27 | Alpine | 3 | 1148 | 101 | 105 | 0 | 105 | 0 |
24768 | 24768 | 2021-10-26 | Alpine | 3 | 1148 | 101 | 105 | 0 | 105 | 0 |
24826 | 24826 | 2021-10-25 | Alpine | 3 | 1148 | 101 | 105 | 0 | 105 | 0 |
24884 | 24884 | 2021-10-24 | Alpine | 3 | 1148 | 101 | 105 | 0 | 105 | 0 |
24942 | 24942 | 2021-10-23 | Alpine | 3 | 1148 | 101 | 105 | 0 | 105 | 0 |
25000 | 25000 | 2021-10-22 | Alpine | 3 | 1148 | 101 | 105 | 0 | 105 | 0 |
25058 | 25058 | 2021-10-21 | Alpine | 3 | 1148 | 101 | 105 | 0 | 105 | 0 |
25116 | 25116 | 2021-10-20 | Alpine | 3 | 1148 | 101 | 103 | 0 | 103 | 0 |
25174 | 25174 | 2021-10-19 | Alpine | 3 | 1148 | 101 | 103 | 0 | 103 | 0 |
25232 | 25232 | 2021-10-18 | Alpine | 3 | 1148 | 101 | 103 | 0 | 103 | 0 |
25290 | 25290 | 2021-10-17 | Alpine | 3 | 1148 | 101 | 103 | 0 | 103 | 0 |
25348 | 25348 | 2021-10-16 | Alpine | 3 | 1148 | 100 | 102 | 0 | 102 | 0 |
25406 | 25406 | 2021-10-15 | Alpine | 3 | 1148 | 100 | 102 | 0 | 102 | 0 |
25464 | 25464 | 2021-10-14 | Alpine | 3 | 1148 | 100 | 102 | 0 | 102 | 0 |
25522 | 25522 | 2021-10-13 | Alpine | 3 | 1148 | 100 | 102 | 0 | 102 | 0 |
25580 | 25580 | 2021-10-12 | Alpine | 3 | 1148 | 100 | 102 | 0 | 102 | 0 |
25638 | 25638 | 2021-10-11 | Alpine | 3 | 1148 | 100 | 102 | 0 | 102 | 0 |
25696 | 25696 | 2021-10-10 | Alpine | 3 | 1148 | 100 | 102 | 0 | 102 | 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 );