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_and_probable_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 |
---|---|---|---|---|---|---|---|---|---|---|
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
56978 | 56978 | 2020-04-19 | Mariposa | 43 | 17540 | 2 | 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 |
57036 | 57036 | 2020-04-18 | Mariposa | 43 | 17540 | 2 | 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 |
57094 | 57094 | 2020-04-17 | Mariposa | 43 | 17540 | 1 | 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 |
57301 | 57301 | 2020-04-14 | Tuolumne | 109 | 53932 | 3 | 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 |
57350 | 57350 | 2020-04-13 | Sierra | 91 | 2930 | 0 | 0 | 0 | 0 | 0 |
57357 | 57357 | 2020-04-13 | Trinity | 105 | 12862 | 0 | 0 | 0 | 0 | 0 |
57359 | 57359 | 2020-04-13 | Tuolumne | 109 | 53932 | 3 | 0 | 0 | 0 | 0 |
57384 | 57384 | 2020-04-12 | Mariposa | 43 | 17540 | 0 | 0 | 0 | 0 | 0 |
57387 | 57387 | 2020-04-12 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
57408 | 57408 | 2020-04-12 | Sierra | 91 | 2930 | 0 | 0 | 0 | 0 | 0 |
57415 | 57415 | 2020-04-12 | Trinity | 105 | 12862 | 0 | 0 | 0 | 0 | 0 |
57417 | 57417 | 2020-04-12 | Tuolumne | 109 | 53932 | 3 | 0 | 0 | 0 | 0 |
57442 | 57442 | 2020-04-11 | Mariposa | 43 | 17540 | 0 | 0 | 0 | 0 | 0 |
57445 | 57445 | 2020-04-11 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
57466 | 57466 | 2020-04-11 | Sierra | 91 | 2930 | 0 | 0 | 0 | 0 | 0 |
57473 | 57473 | 2020-04-11 | Trinity | 105 | 12862 | 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 );