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 confirmed_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 |
---|---|---|---|---|---|---|---|---|---|---|
54545 | 54545 | 2020-05-31 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
54603 | 54603 | 2020-05-30 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
54661 | 54661 | 2020-05-29 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
54719 | 54719 | 2020-05-28 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
54777 | 54777 | 2020-05-27 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
54835 | 54835 | 2020-05-26 | Modoc | 49 | 8938 | 0 | 1 | 0 | 1 | 0 |
54893 | 54893 | 2020-05-25 | Modoc | 49 | 8938 | 0 | 1 | 0 | 1 | 0 |
54951 | 54951 | 2020-05-24 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
55009 | 55009 | 2020-05-23 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
55067 | 55067 | 2020-05-22 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
55125 | 55125 | 2020-05-21 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
55183 | 55183 | 2020-05-20 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
55241 | 55241 | 2020-05-19 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
55262 | 55262 | 2020-05-19 | Sierra | 91 | 2930 | 0 | 0 | 0 | 0 | 0 |
55299 | 55299 | 2020-05-18 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
55320 | 55320 | 2020-05-18 | Sierra | 91 | 2930 | 0 | 0 | 0 | 0 | 0 |
55357 | 55357 | 2020-05-17 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
55378 | 55378 | 2020-05-17 | Sierra | 91 | 2930 | 0 | 0 | 0 | 0 | 0 |
55415 | 55415 | 2020-05-16 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
55436 | 55436 | 2020-05-16 | Sierra | 91 | 2930 | 0 | 0 | 0 | 0 | 0 |
55473 | 55473 | 2020-05-15 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
55494 | 55494 | 2020-05-15 | Sierra | 91 | 2930 | 0 | 0 | 0 | 0 | 0 |
55531 | 55531 | 2020-05-14 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
55552 | 55552 | 2020-05-14 | Sierra | 91 | 2930 | 0 | 0 | 0 | 0 | 0 |
55589 | 55589 | 2020-05-13 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
55610 | 55610 | 2020-05-13 | Sierra | 91 | 2930 | 0 | 0 | 0 | 0 | 0 |
55647 | 55647 | 2020-05-12 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
55668 | 55668 | 2020-05-12 | Sierra | 91 | 2930 | 0 | 0 | 0 | 0 | 0 |
55705 | 55705 | 2020-05-11 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
55726 | 55726 | 2020-05-11 | Sierra | 91 | 2930 | 0 | 0 | 0 | 0 | 0 |
55763 | 55763 | 2020-05-10 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
55784 | 55784 | 2020-05-10 | Sierra | 91 | 2930 | 0 | 0 | 0 | 0 | 0 |
55821 | 55821 | 2020-05-09 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
55842 | 55842 | 2020-05-09 | Sierra | 91 | 2930 | 0 | 0 | 0 | 0 | 0 |
55879 | 55879 | 2020-05-08 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
55900 | 55900 | 2020-05-08 | Sierra | 91 | 2930 | 0 | 0 | 0 | 0 | 0 |
55937 | 55937 | 2020-05-07 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
55958 | 55958 | 2020-05-07 | Sierra | 91 | 2930 | 0 | 0 | 0 | 0 | 0 |
55995 | 55995 | 2020-05-06 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
56016 | 56016 | 2020-05-06 | Sierra | 91 | 2930 | 0 | 0 | 0 | 0 | 0 |
56053 | 56053 | 2020-05-05 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
56074 | 56074 | 2020-05-05 | Sierra | 91 | 2930 | 0 | 0 | 0 | 0 | 0 |
56111 | 56111 | 2020-05-04 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
56132 | 56132 | 2020-05-04 | Sierra | 91 | 2930 | 0 | 0 | 0 | 0 | 0 |
56169 | 56169 | 2020-05-03 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
56190 | 56190 | 2020-05-03 | Sierra | 91 | 2930 | 0 | 0 | 0 | 0 | 0 |
56227 | 56227 | 2020-05-02 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
56248 | 56248 | 2020-05-02 | Sierra | 91 | 2930 | 0 | 0 | 0 | 0 | 0 |
56285 | 56285 | 2020-05-01 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
56306 | 56306 | 2020-05-01 | Sierra | 91 | 2930 | 0 | 0 | 0 | 0 | 0 |
56343 | 56343 | 2020-04-30 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
56364 | 56364 | 2020-04-30 | Sierra | 91 | 2930 | 0 | 0 | 0 | 0 | 0 |
56401 | 56401 | 2020-04-29 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
56422 | 56422 | 2020-04-29 | Sierra | 91 | 2930 | 0 | 0 | 0 | 0 | 0 |
56459 | 56459 | 2020-04-28 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
56480 | 56480 | 2020-04-28 | Sierra | 91 | 2930 | 0 | 0 | 0 | 0 | 0 |
56517 | 56517 | 2020-04-27 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
56538 | 56538 | 2020-04-27 | Sierra | 91 | 2930 | 0 | 0 | 0 | 0 | 0 |
56575 | 56575 | 2020-04-26 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
56596 | 56596 | 2020-04-26 | Sierra | 91 | 2930 | 0 | 0 | 0 | 0 | 0 |
56633 | 56633 | 2020-04-25 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
56654 | 56654 | 2020-04-25 | Sierra | 91 | 2930 | 0 | 0 | 0 | 0 | 0 |
56661 | 56661 | 2020-04-25 | Trinity | 105 | 12862 | 0 | 0 | 0 | 0 | 0 |
56691 | 56691 | 2020-04-24 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
56712 | 56712 | 2020-04-24 | Sierra | 91 | 2930 | 0 | 0 | 0 | 0 | 0 |
56719 | 56719 | 2020-04-24 | Trinity | 105 | 12862 | 0 | 0 | 0 | 0 | 0 |
56749 | 56749 | 2020-04-23 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
56770 | 56770 | 2020-04-23 | Sierra | 91 | 2930 | 0 | 0 | 0 | 0 | 0 |
56777 | 56777 | 2020-04-23 | Trinity | 105 | 12862 | 0 | 0 | 0 | 0 | 0 |
56807 | 56807 | 2020-04-22 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
56828 | 56828 | 2020-04-22 | Sierra | 91 | 2930 | 0 | 0 | 0 | 0 | 0 |
56835 | 56835 | 2020-04-22 | Trinity | 105 | 12862 | 0 | 0 | 0 | 0 | 0 |
56865 | 56865 | 2020-04-21 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
56886 | 56886 | 2020-04-21 | Sierra | 91 | 2930 | 0 | 0 | 0 | 0 | 0 |
56893 | 56893 | 2020-04-21 | Trinity | 105 | 12862 | 0 | 0 | 0 | 0 | 0 |
56923 | 56923 | 2020-04-20 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
56944 | 56944 | 2020-04-20 | Sierra | 91 | 2930 | 0 | 0 | 0 | 0 | 0 |
56951 | 56951 | 2020-04-20 | Trinity | 105 | 12862 | 0 | 0 | 0 | 0 | 0 |
56981 | 56981 | 2020-04-19 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
57002 | 57002 | 2020-04-19 | Sierra | 91 | 2930 | 0 | 0 | 0 | 0 | 0 |
57009 | 57009 | 2020-04-19 | Trinity | 105 | 12862 | 0 | 0 | 0 | 0 | 0 |
57039 | 57039 | 2020-04-18 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
57060 | 57060 | 2020-04-18 | Sierra | 91 | 2930 | 0 | 0 | 0 | 0 | 0 |
57067 | 57067 | 2020-04-18 | Trinity | 105 | 12862 | 0 | 0 | 0 | 0 | 0 |
57097 | 57097 | 2020-04-17 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
57118 | 57118 | 2020-04-17 | Sierra | 91 | 2930 | 0 | 0 | 0 | 0 | 0 |
57125 | 57125 | 2020-04-17 | Trinity | 105 | 12862 | 0 | 0 | 0 | 0 | 0 |
57155 | 57155 | 2020-04-16 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
57176 | 57176 | 2020-04-16 | Sierra | 91 | 2930 | 0 | 0 | 0 | 0 | 0 |
57183 | 57183 | 2020-04-16 | Trinity | 105 | 12862 | 0 | 0 | 0 | 0 | 0 |
57210 | 57210 | 2020-04-15 | Mariposa | 43 | 17540 | 0 | 0 | 0 | 0 | 0 |
57213 | 57213 | 2020-04-15 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
57234 | 57234 | 2020-04-15 | Sierra | 91 | 2930 | 0 | 0 | 0 | 0 | 0 |
57241 | 57241 | 2020-04-15 | Trinity | 105 | 12862 | 0 | 0 | 0 | 0 | 0 |
57268 | 57268 | 2020-04-14 | Mariposa | 43 | 17540 | 0 | 0 | 0 | 0 | 0 |
57271 | 57271 | 2020-04-14 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
57292 | 57292 | 2020-04-14 | Sierra | 91 | 2930 | 0 | 0 | 0 | 0 | 0 |
57299 | 57299 | 2020-04-14 | Trinity | 105 | 12862 | 0 | 0 | 0 | 0 | 0 |
57326 | 57326 | 2020-04-13 | Mariposa | 43 | 17540 | 0 | 0 | 0 | 0 | 0 |
57329 | 57329 | 2020-04-13 | Modoc | 49 | 8938 | 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 );