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 reported_cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | fips | population | confirmed_cases | reported_cases ▼ | probable_cases | reported_and_probable_cases | reported_deaths |
---|---|---|---|---|---|---|---|---|---|---|
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 |
55582 | 55582 | 2020-05-13 | Lassen | 35 | 31185 | 4 | 0 | 2 | 2 | 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 |
55640 | 55640 | 2020-05-12 | Lassen | 35 | 31185 | 4 | 0 | 2 | 2 | 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 |
55698 | 55698 | 2020-05-11 | Lassen | 35 | 31185 | 4 | 0 | 2 | 2 | 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 |
55756 | 55756 | 2020-05-10 | Lassen | 35 | 31185 | 4 | 0 | 2 | 2 | 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 |
55814 | 55814 | 2020-05-09 | Lassen | 35 | 31185 | 4 | 0 | 2 | 2 | 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 |
55872 | 55872 | 2020-05-08 | Lassen | 35 | 31185 | 4 | 0 | 2 | 2 | 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 |
55907 | 55907 | 2020-05-08 | Trinity | 105 | 12862 | 2 | 0 | 0 | 0 | 0 |
55930 | 55930 | 2020-05-07 | Lassen | 35 | 31185 | 4 | 0 | 2 | 2 | 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 |
55965 | 55965 | 2020-05-07 | Trinity | 105 | 12862 | 2 | 0 | 0 | 0 | 0 |
55988 | 55988 | 2020-05-06 | Lassen | 35 | 31185 | 4 | 0 | 2 | 2 | 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 |
56023 | 56023 | 2020-05-06 | Trinity | 105 | 12862 | 2 | 0 | 0 | 0 | 0 |
56046 | 56046 | 2020-05-05 | Lassen | 35 | 31185 | 4 | 0 | 2 | 2 | 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 |
56081 | 56081 | 2020-05-05 | Trinity | 105 | 12862 | 2 | 0 | 0 | 0 | 0 |
56104 | 56104 | 2020-05-04 | Lassen | 35 | 31185 | 3 | 0 | 2 | 2 | 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 |
56139 | 56139 | 2020-05-04 | Trinity | 105 | 12862 | 1 | 0 | 0 | 0 | 0 |
56162 | 56162 | 2020-05-03 | Lassen | 35 | 31185 | 3 | 0 | 2 | 2 | 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 |
56197 | 56197 | 2020-05-03 | Trinity | 105 | 12862 | 1 | 0 | 0 | 0 | 0 |
56220 | 56220 | 2020-05-02 | Lassen | 35 | 31185 | 3 | 0 | 2 | 2 | 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 |
56255 | 56255 | 2020-05-02 | Trinity | 105 | 12862 | 1 | 0 | 0 | 0 | 0 |
56278 | 56278 | 2020-05-01 | Lassen | 35 | 31185 | 3 | 0 | 2 | 2 | 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 |
56313 | 56313 | 2020-05-01 | Trinity | 105 | 12862 | 1 | 0 | 0 | 0 | 0 |
56336 | 56336 | 2020-04-30 | Lassen | 35 | 31185 | 3 | 0 | 2 | 2 | 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 |
56371 | 56371 | 2020-04-30 | Trinity | 105 | 12862 | 1 | 0 | 0 | 0 | 0 |
56394 | 56394 | 2020-04-29 | Lassen | 35 | 31185 | 3 | 0 | 2 | 2 | 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 |
56429 | 56429 | 2020-04-29 | Trinity | 105 | 12862 | 1 | 0 | 0 | 0 | 0 |
56452 | 56452 | 2020-04-28 | Lassen | 35 | 31185 | 3 | 0 | 2 | 2 | 0 |
56456 | 56456 | 2020-04-28 | Mariposa | 43 | 17540 | 15 | 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 |
56487 | 56487 | 2020-04-28 | Trinity | 105 | 12862 | 1 | 0 | 0 | 0 | 0 |
56510 | 56510 | 2020-04-27 | Lassen | 35 | 31185 | 3 | 0 | 2 | 2 | 0 |
56514 | 56514 | 2020-04-27 | Mariposa | 43 | 17540 | 14 | 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 |
56545 | 56545 | 2020-04-27 | Trinity | 105 | 12862 | 1 | 0 | 0 | 0 | 0 |
56568 | 56568 | 2020-04-26 | Lassen | 35 | 31185 | 3 | 0 | 2 | 2 | 0 |
56572 | 56572 | 2020-04-26 | Mariposa | 43 | 17540 | 14 | 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 |
56603 | 56603 | 2020-04-26 | Trinity | 105 | 12862 | 1 | 0 | 0 | 0 | 0 |
56626 | 56626 | 2020-04-25 | Lassen | 35 | 31185 | 3 | 0 | 2 | 2 | 0 |
56630 | 56630 | 2020-04-25 | Mariposa | 43 | 17540 | 14 | 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 |
56684 | 56684 | 2020-04-24 | Lassen | 35 | 31185 | 3 | 0 | 2 | 2 | 0 |
56688 | 56688 | 2020-04-24 | Mariposa | 43 | 17540 | 8 | 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 |
56742 | 56742 | 2020-04-23 | Lassen | 35 | 31185 | 3 | 0 | 2 | 2 | 0 |
56746 | 56746 | 2020-04-23 | Mariposa | 43 | 17540 | 7 | 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 |
56800 | 56800 | 2020-04-22 | Lassen | 35 | 31185 | 3 | 0 | 2 | 2 | 0 |
56804 | 56804 | 2020-04-22 | Mariposa | 43 | 17540 | 6 | 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 |
56858 | 56858 | 2020-04-21 | Lassen | 35 | 31185 | 3 | 0 | 2 | 2 | 0 |
56862 | 56862 | 2020-04-21 | Mariposa | 43 | 17540 | 5 | 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 |
56916 | 56916 | 2020-04-20 | Lassen | 35 | 31185 | 3 | 0 | 2 | 2 | 0 |
56920 | 56920 | 2020-04-20 | Mariposa | 43 | 17540 | 5 | 0 | 0 | 0 | 0 |
56923 | 56923 | 2020-04-20 | 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 );