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)
Link | rowid | date | county | fips | population | confirmed_cases ▼ | reported_cases | probable_cases | reported_and_probable_cases | reported_deaths |
---|---|---|---|---|---|---|---|---|---|---|
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 |
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 |
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 |
57500 | 57500 | 2020-04-10 | Mariposa | 43 | 17540 | 0 | 0 | 0 | 0 | 0 |
57503 | 57503 | 2020-04-10 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
57524 | 57524 | 2020-04-10 | Sierra | 91 | 2930 | 0 | 0 | 0 | 0 | 0 |
57531 | 57531 | 2020-04-10 | Trinity | 105 | 12862 | 0 | 0 | 0 | 0 | 0 |
57558 | 57558 | 2020-04-09 | Mariposa | 43 | 17540 | 0 | 0 | 0 | 0 | 0 |
57561 | 57561 | 2020-04-09 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
57582 | 57582 | 2020-04-09 | Sierra | 91 | 2930 | 0 | 0 | 0 | 0 | 0 |
57589 | 57589 | 2020-04-09 | Trinity | 105 | 12862 | 0 | 0 | 0 | 0 | 0 |
57616 | 57616 | 2020-04-08 | Mariposa | 43 | 17540 | 0 | 0 | 0 | 0 | 0 |
57619 | 57619 | 2020-04-08 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
57640 | 57640 | 2020-04-08 | Sierra | 91 | 2930 | 0 | 0 | 0 | 0 | 0 |
57647 | 57647 | 2020-04-08 | Trinity | 105 | 12862 | 0 | 0 | 0 | 0 | 0 |
57674 | 57674 | 2020-04-07 | Mariposa | 43 | 17540 | 0 | 0 | 0 | 0 | 0 |
57677 | 57677 | 2020-04-07 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
57698 | 57698 | 2020-04-07 | Sierra | 91 | 2930 | 0 | 0 | 0 | 0 | 0 |
57705 | 57705 | 2020-04-07 | Trinity | 105 | 12862 | 0 | 0 | 0 | 0 | 0 |
57732 | 57732 | 2020-04-06 | Mariposa | 43 | 17540 | 0 | 0 | 0 | 0 | 0 |
57735 | 57735 | 2020-04-06 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
57756 | 57756 | 2020-04-06 | Sierra | 91 | 2930 | 0 | 0 | 0 | 0 | 0 |
57763 | 57763 | 2020-04-06 | Trinity | 105 | 12862 | 0 | 0 | 0 | 0 | 0 |
57790 | 57790 | 2020-04-05 | Mariposa | 43 | 17540 | 0 | 0 | 0 | 0 | 0 |
57793 | 57793 | 2020-04-05 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
57814 | 57814 | 2020-04-05 | Sierra | 91 | 2930 | 0 | 0 | 0 | 0 | 0 |
57821 | 57821 | 2020-04-05 | Trinity | 105 | 12862 | 0 | 0 | 0 | 0 | 0 |
57848 | 57848 | 2020-04-04 | Mariposa | 43 | 17540 | 0 | 0 | 0 | 0 | 0 |
57851 | 57851 | 2020-04-04 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
57872 | 57872 | 2020-04-04 | Sierra | 91 | 2930 | 0 | 0 | 0 | 0 | 0 |
57879 | 57879 | 2020-04-04 | Trinity | 105 | 12862 | 0 | 0 | 0 | 0 | 0 |
57906 | 57906 | 2020-04-03 | Mariposa | 43 | 17540 | 0 | 0 | 0 | 0 | 0 |
57909 | 57909 | 2020-04-03 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
57930 | 57930 | 2020-04-03 | Sierra | 91 | 2930 | 0 | 0 | 0 | 0 | 0 |
57937 | 57937 | 2020-04-03 | Trinity | 105 | 12862 | 0 | 0 | 0 | 0 | 0 |
57964 | 57964 | 2020-04-02 | Mariposa | 43 | 17540 | 0 | 0 | 0 | 0 | 0 |
57967 | 57967 | 2020-04-02 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
57988 | 57988 | 2020-04-02 | Sierra | 91 | 2930 | 0 | 0 | 0 | 0 | 0 |
57995 | 57995 | 2020-04-02 | Trinity | 105 | 12862 | 0 | 0 | 0 | 0 | 0 |
58022 | 58022 | 2020-04-01 | Mariposa | 43 | 17540 | 0 | 0 | 0 | 0 | 0 |
58025 | 58025 | 2020-04-01 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
58046 | 58046 | 2020-04-01 | Sierra | 91 | 2930 | 0 | 0 | 0 | 0 | 0 |
58053 | 58053 | 2020-04-01 | Trinity | 105 | 12862 | 0 | 0 | 0 | 0 | 0 |
58080 | 58080 | 2020-03-31 | Mariposa | 43 | 17540 | 0 | 0 | 0 | 0 | 0 |
58083 | 58083 | 2020-03-31 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
58104 | 58104 | 2020-03-31 | Sierra | 91 | 2930 | 0 | 0 | 0 | 0 | 0 |
58111 | 58111 | 2020-03-31 | Trinity | 105 | 12862 | 0 | 0 | 0 | 0 | 0 |
58124 | 58124 | 2020-03-30 | Del Norte | 15 | 27424 | 0 | 0 | 0 | 0 | 0 |
58138 | 58138 | 2020-03-30 | Mariposa | 43 | 17540 | 0 | 0 | 0 | 0 | 0 |
58141 | 58141 | 2020-03-30 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
58162 | 58162 | 2020-03-30 | Sierra | 91 | 2930 | 0 | 0 | 0 | 0 | 0 |
58169 | 58169 | 2020-03-30 | Trinity | 105 | 12862 | 0 | 0 | 0 | 0 | 0 |
58182 | 58182 | 2020-03-29 | Del Norte | 15 | 27424 | 0 | 0 | 0 | 0 | 0 |
58191 | 58191 | 2020-03-29 | Lake | 33 | 64148 | 0 | 0 | 0 | 0 | 0 |
58196 | 58196 | 2020-03-29 | Mariposa | 43 | 17540 | 0 | 0 | 0 | 0 | 0 |
58199 | 58199 | 2020-03-29 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
58220 | 58220 | 2020-03-29 | Sierra | 91 | 2930 | 0 | 0 | 0 | 0 | 0 |
58227 | 58227 | 2020-03-29 | Trinity | 105 | 12862 | 0 | 0 | 0 | 0 | 0 |
58240 | 58240 | 2020-03-28 | Del Norte | 15 | 27424 | 0 | 0 | 0 | 0 | 0 |
58249 | 58249 | 2020-03-28 | Lake | 33 | 64148 | 0 | 0 | 0 | 0 | 0 |
58254 | 58254 | 2020-03-28 | Mariposa | 43 | 17540 | 0 | 0 | 0 | 0 | 0 |
58257 | 58257 | 2020-03-28 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
58278 | 58278 | 2020-03-28 | Sierra | 91 | 2930 | 0 | 0 | 0 | 0 | 0 |
58285 | 58285 | 2020-03-28 | Trinity | 105 | 12862 | 0 | 0 | 0 | 0 | 0 |
58298 | 58298 | 2020-03-27 | Del Norte | 15 | 27424 | 0 | 0 | 0 | 0 | 0 |
58307 | 58307 | 2020-03-27 | Lake | 33 | 64148 | 0 | 0 | 0 | 0 | 0 |
58312 | 58312 | 2020-03-27 | Mariposa | 43 | 17540 | 0 | 0 | 0 | 0 | 0 |
58315 | 58315 | 2020-03-27 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
58322 | 58322 | 2020-03-27 | Plumas | 63 | 18699 | 0 | 0 | 0 | 0 | 0 |
58336 | 58336 | 2020-03-27 | Sierra | 91 | 2930 | 0 | 0 | 0 | 0 | 0 |
58343 | 58343 | 2020-03-27 | Trinity | 105 | 12862 | 0 | 0 | 0 | 0 | 0 |
58356 | 58356 | 2020-03-26 | Del Norte | 15 | 27424 | 0 | 0 | 0 | 0 | 0 |
58365 | 58365 | 2020-03-26 | Lake | 33 | 64148 | 0 | 0 | 0 | 0 | 0 |
58370 | 58370 | 2020-03-26 | Mariposa | 43 | 17540 | 0 | 0 | 0 | 0 | 0 |
58373 | 58373 | 2020-03-26 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
58380 | 58380 | 2020-03-26 | Plumas | 63 | 18699 | 0 | 0 | 0 | 0 | 0 |
58394 | 58394 | 2020-03-26 | Sierra | 91 | 2930 | 0 | 0 | 0 | 0 | 0 |
58401 | 58401 | 2020-03-26 | Trinity | 105 | 12862 | 0 | 0 | 0 | 0 | 0 |
58414 | 58414 | 2020-03-25 | Del Norte | 15 | 27424 | 0 | 0 | 0 | 0 | 0 |
58423 | 58423 | 2020-03-25 | Lake | 33 | 64148 | 0 | 0 | 0 | 0 | 0 |
58428 | 58428 | 2020-03-25 | Mariposa | 43 | 17540 | 0 | 0 | 0 | 0 | 0 |
58431 | 58431 | 2020-03-25 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
58438 | 58438 | 2020-03-25 | Plumas | 63 | 18699 | 0 | 1 | 0 | 1 | 0 |
58452 | 58452 | 2020-03-25 | Sierra | 91 | 2930 | 0 | 0 | 0 | 0 | 0 |
58459 | 58459 | 2020-03-25 | Trinity | 105 | 12862 | 0 | 0 | 0 | 0 | 0 |
58472 | 58472 | 2020-03-24 | Del Norte | 15 | 27424 | 0 | 0 | 0 | 0 | 0 |
58481 | 58481 | 2020-03-24 | Lake | 33 | 64148 | 0 | 0 | 0 | 0 | 0 |
58486 | 58486 | 2020-03-24 | Mariposa | 43 | 17540 | 0 | 0 | 0 | 0 | 0 |
58489 | 58489 | 2020-03-24 | Modoc | 49 | 8938 | 0 | 0 | 0 | 0 | 0 |
58496 | 58496 | 2020-03-24 | Plumas | 63 | 18699 | 0 | 1 | 0 | 1 | 0 |
58510 | 58510 | 2020-03-24 | Sierra | 91 | 2930 | 0 | 0 | 0 | 0 | 0 |
58517 | 58517 | 2020-03-24 | Trinity | 105 | 12862 | 0 | 0 | 0 | 0 | 0 |
58530 | 58530 | 2020-03-23 | Del Norte | 15 | 27424 | 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 );