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_deaths
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|
5802 | 5802 | 2022-09-18 | Alpine | 3 | 1148 | 134 | 134 | 1 | 135 | 0 |
5860 | 5860 | 2022-09-17 | Alpine | 3 | 1148 | 134 | 134 | 1 | 135 | 0 |
5918 | 5918 | 2022-09-16 | Alpine | 3 | 1148 | 134 | 134 | 1 | 135 | 0 |
5976 | 5976 | 2022-09-15 | Alpine | 3 | 1148 | 134 | 134 | 1 | 135 | 0 |
6034 | 6034 | 2022-09-14 | Alpine | 3 | 1148 | 134 | 134 | 1 | 135 | 0 |
6092 | 6092 | 2022-09-13 | Alpine | 3 | 1148 | 134 | 134 | 1 | 135 | 0 |
6150 | 6150 | 2022-09-12 | Alpine | 3 | 1148 | 134 | 134 | 1 | 135 | 0 |
6208 | 6208 | 2022-09-11 | Alpine | 3 | 1148 | 134 | 134 | 1 | 135 | 0 |
6266 | 6266 | 2022-09-10 | Alpine | 3 | 1148 | 134 | 134 | 1 | 135 | 0 |
6324 | 6324 | 2022-09-09 | Alpine | 3 | 1148 | 134 | 134 | 1 | 135 | 0 |
6382 | 6382 | 2022-09-08 | Alpine | 3 | 1148 | 134 | 134 | 1 | 135 | 0 |
6440 | 6440 | 2022-09-07 | Alpine | 3 | 1148 | 134 | 133 | 1 | 134 | 0 |
6498 | 6498 | 2022-09-06 | Alpine | 3 | 1148 | 133 | 133 | 1 | 134 | 0 |
6556 | 6556 | 2022-09-05 | Alpine | 3 | 1148 | 133 | 133 | 1 | 134 | 0 |
6614 | 6614 | 2022-09-04 | Alpine | 3 | 1148 | 133 | 133 | 1 | 134 | 0 |
6672 | 6672 | 2022-09-03 | Alpine | 3 | 1148 | 133 | 133 | 1 | 134 | 0 |
6730 | 6730 | 2022-09-02 | Alpine | 3 | 1148 | 133 | 133 | 1 | 134 | 0 |
6788 | 6788 | 2022-09-01 | Alpine | 3 | 1148 | 133 | 133 | 1 | 134 | 0 |
6846 | 6846 | 2022-08-31 | Alpine | 3 | 1148 | 133 | 133 | 1 | 134 | 0 |
6904 | 6904 | 2022-08-30 | Alpine | 3 | 1148 | 133 | 133 | 1 | 134 | 0 |
6962 | 6962 | 2022-08-29 | Alpine | 3 | 1148 | 133 | 133 | 1 | 134 | 0 |
7020 | 7020 | 2022-08-28 | Alpine | 3 | 1148 | 133 | 133 | 1 | 134 | 0 |
7078 | 7078 | 2022-08-27 | Alpine | 3 | 1148 | 133 | 133 | 1 | 134 | 0 |
7136 | 7136 | 2022-08-26 | Alpine | 3 | 1148 | 133 | 133 | 1 | 134 | 0 |
7194 | 7194 | 2022-08-25 | Alpine | 3 | 1148 | 133 | 133 | 1 | 134 | 0 |
7252 | 7252 | 2022-08-24 | Alpine | 3 | 1148 | 133 | 131 | 1 | 132 | 0 |
7310 | 7310 | 2022-08-23 | Alpine | 3 | 1148 | 133 | 131 | 1 | 132 | 0 |
7368 | 7368 | 2022-08-22 | Alpine | 3 | 1148 | 133 | 131 | 1 | 132 | 0 |
7426 | 7426 | 2022-08-21 | Alpine | 3 | 1148 | 132 | 131 | 1 | 132 | 0 |
7484 | 7484 | 2022-08-20 | Alpine | 3 | 1148 | 132 | 131 | 1 | 132 | 0 |
7542 | 7542 | 2022-08-19 | Alpine | 3 | 1148 | 132 | 131 | 1 | 132 | 0 |
7600 | 7600 | 2022-08-18 | Alpine | 3 | 1148 | 131 | 131 | 1 | 132 | 0 |
7658 | 7658 | 2022-08-17 | Alpine | 3 | 1148 | 131 | 131 | 1 | 132 | 0 |
7716 | 7716 | 2022-08-16 | Alpine | 3 | 1148 | 131 | 131 | 1 | 132 | 0 |
7774 | 7774 | 2022-08-15 | Alpine | 3 | 1148 | 131 | 131 | 1 | 132 | 0 |
7832 | 7832 | 2022-08-14 | Alpine | 3 | 1148 | 131 | 131 | 1 | 132 | 0 |
7890 | 7890 | 2022-08-13 | Alpine | 3 | 1148 | 131 | 131 | 1 | 132 | 0 |
7948 | 7948 | 2022-08-12 | Alpine | 3 | 1148 | 131 | 131 | 1 | 132 | 0 |
8006 | 8006 | 2022-08-11 | Alpine | 3 | 1148 | 131 | 131 | 1 | 132 | 0 |
8064 | 8064 | 2022-08-10 | Alpine | 3 | 1148 | 131 | 131 | 1 | 132 | 0 |
8122 | 8122 | 2022-08-09 | Alpine | 3 | 1148 | 131 | 131 | 1 | 132 | 0 |
8180 | 8180 | 2022-08-08 | Alpine | 3 | 1148 | 131 | 131 | 1 | 132 | 0 |
8238 | 8238 | 2022-08-07 | Alpine | 3 | 1148 | 131 | 130 | 1 | 131 | 0 |
8296 | 8296 | 2022-08-06 | Alpine | 3 | 1148 | 131 | 130 | 1 | 131 | 0 |
8354 | 8354 | 2022-08-05 | Alpine | 3 | 1148 | 131 | 130 | 1 | 131 | 0 |
8412 | 8412 | 2022-08-04 | Alpine | 3 | 1148 | 130 | 130 | 1 | 131 | 0 |
8470 | 8470 | 2022-08-03 | Alpine | 3 | 1148 | 130 | 130 | 1 | 131 | 0 |
8528 | 8528 | 2022-08-02 | Alpine | 3 | 1148 | 130 | 130 | 1 | 131 | 0 |
8586 | 8586 | 2022-08-01 | Alpine | 3 | 1148 | 130 | 130 | 1 | 131 | 0 |
8644 | 8644 | 2022-07-31 | Alpine | 3 | 1148 | 130 | 130 | 1 | 131 | 0 |
8702 | 8702 | 2022-07-30 | Alpine | 3 | 1148 | 130 | 130 | 1 | 131 | 0 |
8760 | 8760 | 2022-07-29 | Alpine | 3 | 1148 | 130 | 130 | 1 | 131 | 0 |
8818 | 8818 | 2022-07-28 | Alpine | 3 | 1148 | 130 | 130 | 1 | 131 | 0 |
8876 | 8876 | 2022-07-27 | Alpine | 3 | 1148 | 130 | 130 | 1 | 131 | 0 |
8934 | 8934 | 2022-07-26 | Alpine | 3 | 1148 | 130 | 130 | 1 | 131 | 0 |
8992 | 8992 | 2022-07-25 | Alpine | 3 | 1148 | 130 | 130 | 1 | 131 | 0 |
9050 | 9050 | 2022-07-24 | Alpine | 3 | 1148 | 130 | 130 | 1 | 131 | 0 |
9108 | 9108 | 2022-07-23 | Alpine | 3 | 1148 | 130 | 130 | 1 | 131 | 0 |
9166 | 9166 | 2022-07-22 | Alpine | 3 | 1148 | 130 | 130 | 1 | 131 | 0 |
9224 | 9224 | 2022-07-21 | Alpine | 3 | 1148 | 130 | 130 | 1 | 131 | 0 |
9282 | 9282 | 2022-07-20 | Alpine | 3 | 1148 | 130 | 130 | 1 | 131 | 0 |
9340 | 9340 | 2022-07-19 | Alpine | 3 | 1148 | 130 | 130 | 1 | 131 | 0 |
9398 | 9398 | 2022-07-18 | Alpine | 3 | 1148 | 130 | 130 | 1 | 131 | 0 |
9456 | 9456 | 2022-07-17 | Alpine | 3 | 1148 | 130 | 130 | 1 | 131 | 0 |
9514 | 9514 | 2022-07-16 | Alpine | 3 | 1148 | 130 | 130 | 1 | 131 | 0 |
9572 | 9572 | 2022-07-15 | Alpine | 3 | 1148 | 130 | 130 | 1 | 131 | 0 |
9630 | 9630 | 2022-07-14 | Alpine | 3 | 1148 | 130 | 130 | 1 | 131 | 0 |
9688 | 9688 | 2022-07-13 | Alpine | 3 | 1148 | 130 | 129 | 1 | 130 | 0 |
9746 | 9746 | 2022-07-12 | Alpine | 3 | 1148 | 130 | 129 | 1 | 130 | 0 |
9804 | 9804 | 2022-07-11 | Alpine | 3 | 1148 | 130 | 129 | 1 | 130 | 0 |
9862 | 9862 | 2022-07-10 | Alpine | 3 | 1148 | 130 | 129 | 1 | 130 | 0 |
9920 | 9920 | 2022-07-09 | Alpine | 3 | 1148 | 130 | 129 | 1 | 130 | 0 |
9978 | 9978 | 2022-07-08 | Alpine | 3 | 1148 | 130 | 129 | 1 | 130 | 0 |
10036 | 10036 | 2022-07-07 | Alpine | 3 | 1148 | 129 | 129 | 1 | 130 | 0 |
10094 | 10094 | 2022-07-06 | Alpine | 3 | 1148 | 129 | 129 | 1 | 130 | 0 |
10152 | 10152 | 2022-07-05 | Alpine | 3 | 1148 | 129 | 129 | 1 | 130 | 0 |
10210 | 10210 | 2022-07-04 | Alpine | 3 | 1148 | 129 | 129 | 1 | 130 | 0 |
10268 | 10268 | 2022-07-03 | Alpine | 3 | 1148 | 129 | 129 | 1 | 130 | 0 |
10326 | 10326 | 2022-07-02 | Alpine | 3 | 1148 | 129 | 129 | 1 | 130 | 0 |
10384 | 10384 | 2022-07-01 | Alpine | 3 | 1148 | 129 | 129 | 1 | 130 | 0 |
10442 | 10442 | 2022-06-30 | Alpine | 3 | 1148 | 129 | 129 | 1 | 130 | 0 |
10500 | 10500 | 2022-06-29 | Alpine | 3 | 1148 | 129 | 129 | 1 | 130 | 0 |
10558 | 10558 | 2022-06-28 | Alpine | 3 | 1148 | 129 | 129 | 1 | 130 | 0 |
10616 | 10616 | 2022-06-27 | Alpine | 3 | 1148 | 129 | 129 | 1 | 130 | 0 |
10674 | 10674 | 2022-06-26 | Alpine | 3 | 1148 | 129 | 129 | 1 | 130 | 0 |
10732 | 10732 | 2022-06-25 | Alpine | 3 | 1148 | 129 | 129 | 1 | 130 | 0 |
10790 | 10790 | 2022-06-24 | Alpine | 3 | 1148 | 129 | 129 | 1 | 130 | 0 |
10848 | 10848 | 2022-06-23 | Alpine | 3 | 1148 | 129 | 129 | 1 | 130 | 0 |
10906 | 10906 | 2022-06-22 | Alpine | 3 | 1148 | 129 | 129 | 1 | 130 | 0 |
10964 | 10964 | 2022-06-21 | Alpine | 3 | 1148 | 129 | 129 | 1 | 130 | 0 |
11022 | 11022 | 2022-06-20 | Alpine | 3 | 1148 | 129 | 129 | 1 | 130 | 0 |
11080 | 11080 | 2022-06-19 | Alpine | 3 | 1148 | 129 | 129 | 1 | 130 | 0 |
11138 | 11138 | 2022-06-18 | Alpine | 3 | 1148 | 129 | 129 | 1 | 130 | 0 |
11196 | 11196 | 2022-06-17 | Alpine | 3 | 1148 | 129 | 129 | 1 | 130 | 0 |
11254 | 11254 | 2022-06-16 | Alpine | 3 | 1148 | 129 | 129 | 1 | 130 | 0 |
11312 | 11312 | 2022-06-15 | Alpine | 3 | 1148 | 129 | 129 | 1 | 130 | 0 |
11370 | 11370 | 2022-06-14 | Alpine | 3 | 1148 | 129 | 129 | 1 | 130 | 0 |
11428 | 11428 | 2022-06-13 | Alpine | 3 | 1148 | 129 | 129 | 1 | 130 | 0 |
11486 | 11486 | 2022-06-12 | Alpine | 3 | 1148 | 129 | 129 | 1 | 130 | 0 |
11544 | 11544 | 2022-06-11 | Alpine | 3 | 1148 | 129 | 129 | 1 | 130 | 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 );