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)
Suggested facets: date (date)
Link | rowid | date | county | fips | population | confirmed_cases | reported_cases | probable_cases | reported_and_probable_cases ▼ | reported_deaths |
---|---|---|---|---|---|---|---|---|---|---|
51007 | 51007 | 2020-07-31 | Modoc | 49 | 8938 | 6 | 0 | 0 | 0 | 0 |
51065 | 51065 | 2020-07-30 | Modoc | 49 | 8938 | 6 | 0 | 0 | 0 | 0 |
51123 | 51123 | 2020-07-29 | Modoc | 49 | 8938 | 5 | 0 | 0 | 0 | 0 |
51181 | 51181 | 2020-07-28 | Modoc | 49 | 8938 | 4 | 0 | 0 | 0 | 0 |
51239 | 51239 | 2020-07-27 | Modoc | 49 | 8938 | 3 | 0 | 0 | 0 | 0 |
51297 | 51297 | 2020-07-26 | Modoc | 49 | 8938 | 3 | 0 | 0 | 0 | 0 |
51355 | 51355 | 2020-07-25 | Modoc | 49 | 8938 | 3 | 0 | 0 | 0 | 0 |
51413 | 51413 | 2020-07-24 | Modoc | 49 | 8938 | 3 | 0 | 0 | 0 | 0 |
51471 | 51471 | 2020-07-23 | Modoc | 49 | 8938 | 3 | 0 | 0 | 0 | 0 |
51529 | 51529 | 2020-07-22 | Modoc | 49 | 8938 | 3 | 0 | 0 | 0 | 0 |
51587 | 51587 | 2020-07-21 | Modoc | 49 | 8938 | 3 | 0 | 0 | 0 | 0 |
51645 | 51645 | 2020-07-20 | Modoc | 49 | 8938 | 3 | 0 | 0 | 0 | 0 |
51703 | 51703 | 2020-07-19 | Modoc | 49 | 8938 | 3 | 0 | 0 | 0 | 0 |
51761 | 51761 | 2020-07-18 | Modoc | 49 | 8938 | 3 | 0 | 0 | 0 | 0 |
51819 | 51819 | 2020-07-17 | Modoc | 49 | 8938 | 2 | 0 | 0 | 0 | 0 |
51877 | 51877 | 2020-07-16 | Modoc | 49 | 8938 | 1 | 0 | 0 | 0 | 0 |
51935 | 51935 | 2020-07-15 | Modoc | 49 | 8938 | 1 | 0 | 0 | 0 | 0 |
51993 | 51993 | 2020-07-14 | Modoc | 49 | 8938 | 1 | 0 | 0 | 0 | 0 |
52051 | 52051 | 2020-07-13 | Modoc | 49 | 8938 | 1 | 0 | 0 | 0 | 0 |
52109 | 52109 | 2020-07-12 | Modoc | 49 | 8938 | 1 | 0 | 0 | 0 | 0 |
52167 | 52167 | 2020-07-11 | Modoc | 49 | 8938 | 1 | 0 | 0 | 0 | 0 |
52225 | 52225 | 2020-07-10 | Modoc | 49 | 8938 | 1 | 0 | 0 | 0 | 0 |
52283 | 52283 | 2020-07-09 | Modoc | 49 | 8938 | 1 | 0 | 0 | 0 | 0 |
52341 | 52341 | 2020-07-08 | Modoc | 49 | 8938 | 1 | 0 | 0 | 0 | 0 |
52399 | 52399 | 2020-07-07 | Modoc | 49 | 8938 | 1 | 0 | 0 | 0 | 0 |
52457 | 52457 | 2020-07-06 | Modoc | 49 | 8938 | 1 | 0 | 0 | 0 | 0 |
52515 | 52515 | 2020-07-05 | Modoc | 49 | 8938 | 1 | 0 | 0 | 0 | 0 |
52573 | 52573 | 2020-07-04 | Modoc | 49 | 8938 | 1 | 0 | 0 | 0 | 0 |
52631 | 52631 | 2020-07-03 | Modoc | 49 | 8938 | 1 | 0 | 0 | 0 | 0 |
52689 | 52689 | 2020-07-02 | Modoc | 49 | 8938 | 1 | 0 | 0 | 0 | 0 |
52747 | 52747 | 2020-07-01 | Modoc | 49 | 8938 | 1 | 0 | 0 | 0 | 0 |
52805 | 52805 | 2020-06-30 | Modoc | 49 | 8938 | 1 | 0 | 0 | 0 | 0 |
52863 | 52863 | 2020-06-29 | Modoc | 49 | 8938 | 1 | 0 | 0 | 0 | 0 |
52921 | 52921 | 2020-06-28 | Modoc | 49 | 8938 | 1 | 0 | 0 | 0 | 0 |
52979 | 52979 | 2020-06-27 | Modoc | 49 | 8938 | 1 | 0 | 0 | 0 | 0 |
53037 | 53037 | 2020-06-26 | Modoc | 49 | 8938 | 1 | 0 | 0 | 0 | 0 |
53095 | 53095 | 2020-06-25 | Modoc | 49 | 8938 | 1 | 0 | 0 | 0 | 0 |
53153 | 53153 | 2020-06-24 | Modoc | 49 | 8938 | 1 | 0 | 0 | 0 | 0 |
53211 | 53211 | 2020-06-23 | Modoc | 49 | 8938 | 1 | 0 | 0 | 0 | 0 |
53269 | 53269 | 2020-06-22 | Modoc | 49 | 8938 | 1 | 0 | 0 | 0 | 0 |
53327 | 53327 | 2020-06-21 | Modoc | 49 | 8938 | 1 | 0 | 0 | 0 | 0 |
53385 | 53385 | 2020-06-20 | Modoc | 49 | 8938 | 1 | 0 | 0 | 0 | 0 |
53443 | 53443 | 2020-06-19 | Modoc | 49 | 8938 | 1 | 0 | 0 | 0 | 0 |
53501 | 53501 | 2020-06-18 | Modoc | 49 | 8938 | 1 | 0 | 0 | 0 | 0 |
53559 | 53559 | 2020-06-17 | Modoc | 49 | 8938 | 1 | 0 | 0 | 0 | 0 |
53617 | 53617 | 2020-06-16 | Modoc | 49 | 8938 | 1 | 0 | 0 | 0 | 0 |
53675 | 53675 | 2020-06-15 | Modoc | 49 | 8938 | 1 | 0 | 0 | 0 | 0 |
53733 | 53733 | 2020-06-14 | Modoc | 49 | 8938 | 1 | 0 | 0 | 0 | 0 |
53791 | 53791 | 2020-06-13 | Modoc | 49 | 8938 | 1 | 0 | 0 | 0 | 0 |
53849 | 53849 | 2020-06-12 | Modoc | 49 | 8938 | 1 | 0 | 0 | 0 | 0 |
53907 | 53907 | 2020-06-11 | Modoc | 49 | 8938 | 1 | 0 | 0 | 0 | 0 |
53965 | 53965 | 2020-06-10 | Modoc | 49 | 8938 | 1 | 0 | 0 | 0 | 0 |
54023 | 54023 | 2020-06-09 | Modoc | 49 | 8938 | 1 | 0 | 0 | 0 | 0 |
54081 | 54081 | 2020-06-08 | Modoc | 49 | 8938 | 1 | 0 | 0 | 0 | 0 |
54139 | 54139 | 2020-06-07 | Modoc | 49 | 8938 | 1 | 0 | 0 | 0 | 0 |
54197 | 54197 | 2020-06-06 | Modoc | 49 | 8938 | 1 | 0 | 0 | 0 | 0 |
54255 | 54255 | 2020-06-05 | Modoc | 49 | 8938 | 1 | 0 | 0 | 0 | 0 |
54313 | 54313 | 2020-06-04 | Modoc | 49 | 8938 | 1 | 0 | 0 | 0 | 0 |
54371 | 54371 | 2020-06-03 | Modoc | 49 | 8938 | 1 | 0 | 0 | 0 | 0 |
54429 | 54429 | 2020-06-02 | Modoc | 49 | 8938 | 1 | 0 | 0 | 0 | 0 |
54487 | 54487 | 2020-06-01 | Modoc | 49 | 8938 | 1 | 0 | 0 | 0 | 0 |
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 |
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 |
55088 | 55088 | 2020-05-22 | Sierra | 91 | 2930 | 1 | 0 | 0 | 0 | 0 |
55125 | 55125 | 2020-05-21 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
55146 | 55146 | 2020-05-21 | Sierra | 91 | 2930 | 1 | 0 | 0 | 0 | 0 |
55183 | 55183 | 2020-05-20 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
55204 | 55204 | 2020-05-20 | Sierra | 91 | 2930 | 1 | 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 |
55907 | 55907 | 2020-05-08 | Trinity | 105 | 12862 | 2 | 0 | 0 | 0 | 0 |
55937 | 55937 | 2020-05-07 | 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 );