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)
Suggested facets: date (date)
Link | rowid | date | county | fips | population | confirmed_cases | reported_cases | probable_cases | reported_and_probable_cases | reported_deaths ▼ |
---|---|---|---|---|---|---|---|---|---|---|
2 | 2 | 2022-12-27 | Alpine | 3 | 1148 | 138 | 138 | 3 | 141 | 0 |
60 | 60 | 2022-12-26 | Alpine | 3 | 1148 | 138 | 138 | 3 | 141 | 0 |
118 | 118 | 2022-12-25 | Alpine | 3 | 1148 | 138 | 138 | 3 | 141 | 0 |
176 | 176 | 2022-12-24 | Alpine | 3 | 1148 | 138 | 138 | 3 | 141 | 0 |
234 | 234 | 2022-12-23 | Alpine | 3 | 1148 | 138 | 138 | 3 | 141 | 0 |
292 | 292 | 2022-12-22 | Alpine | 3 | 1148 | 138 | 138 | 3 | 141 | 0 |
350 | 350 | 2022-12-21 | Alpine | 3 | 1148 | 138 | 138 | 3 | 141 | 0 |
408 | 408 | 2022-12-20 | Alpine | 3 | 1148 | 138 | 138 | 3 | 141 | 0 |
466 | 466 | 2022-12-19 | Alpine | 3 | 1148 | 138 | 139 | 3 | 142 | 0 |
524 | 524 | 2022-12-18 | Alpine | 3 | 1148 | 138 | 139 | 3 | 142 | 0 |
582 | 582 | 2022-12-17 | Alpine | 3 | 1148 | 138 | 139 | 3 | 142 | 0 |
640 | 640 | 2022-12-16 | Alpine | 3 | 1148 | 138 | 139 | 3 | 142 | 0 |
698 | 698 | 2022-12-15 | Alpine | 3 | 1148 | 138 | 139 | 3 | 142 | 0 |
756 | 756 | 2022-12-14 | Alpine | 3 | 1148 | 138 | 139 | 3 | 142 | 0 |
814 | 814 | 2022-12-13 | Alpine | 3 | 1148 | 138 | 139 | 3 | 142 | 0 |
872 | 872 | 2022-12-12 | Alpine | 3 | 1148 | 138 | 139 | 3 | 142 | 0 |
930 | 930 | 2022-12-11 | Alpine | 3 | 1148 | 138 | 139 | 3 | 142 | 0 |
988 | 988 | 2022-12-10 | Alpine | 3 | 1148 | 138 | 139 | 3 | 142 | 0 |
1046 | 1046 | 2022-12-09 | Alpine | 3 | 1148 | 138 | 139 | 3 | 142 | 0 |
1104 | 1104 | 2022-12-08 | Alpine | 3 | 1148 | 138 | 139 | 3 | 142 | 0 |
1162 | 1162 | 2022-12-07 | Alpine | 3 | 1148 | 138 | 139 | 3 | 142 | 0 |
1220 | 1220 | 2022-12-06 | Alpine | 3 | 1148 | 138 | 139 | 3 | 142 | 0 |
1278 | 1278 | 2022-12-05 | Alpine | 3 | 1148 | 138 | 139 | 3 | 142 | 0 |
1336 | 1336 | 2022-12-04 | Alpine | 3 | 1148 | 138 | 139 | 3 | 142 | 0 |
1394 | 1394 | 2022-12-03 | Alpine | 3 | 1148 | 138 | 139 | 3 | 142 | 0 |
1452 | 1452 | 2022-12-02 | Alpine | 3 | 1148 | 138 | 139 | 3 | 142 | 0 |
1510 | 1510 | 2022-12-01 | Alpine | 3 | 1148 | 138 | 139 | 3 | 142 | 0 |
1568 | 1568 | 2022-11-30 | Alpine | 3 | 1148 | 138 | 139 | 3 | 142 | 0 |
1626 | 1626 | 2022-11-29 | Alpine | 3 | 1148 | 138 | 139 | 2 | 141 | 0 |
1684 | 1684 | 2022-11-28 | Alpine | 3 | 1148 | 138 | 138 | 2 | 140 | 0 |
1742 | 1742 | 2022-11-27 | Alpine | 3 | 1148 | 138 | 138 | 2 | 140 | 0 |
1800 | 1800 | 2022-11-26 | Alpine | 3 | 1148 | 138 | 138 | 2 | 140 | 0 |
1858 | 1858 | 2022-11-25 | Alpine | 3 | 1148 | 138 | 138 | 2 | 140 | 0 |
1916 | 1916 | 2022-11-24 | Alpine | 3 | 1148 | 138 | 138 | 2 | 140 | 0 |
1974 | 1974 | 2022-11-23 | Alpine | 3 | 1148 | 138 | 138 | 2 | 140 | 0 |
2032 | 2032 | 2022-11-22 | Alpine | 3 | 1148 | 138 | 138 | 2 | 140 | 0 |
2090 | 2090 | 2022-11-21 | Alpine | 3 | 1148 | 138 | 136 | 2 | 138 | 0 |
2148 | 2148 | 2022-11-20 | Alpine | 3 | 1148 | 138 | 136 | 2 | 138 | 0 |
2206 | 2206 | 2022-11-19 | Alpine | 3 | 1148 | 138 | 136 | 2 | 138 | 0 |
2264 | 2264 | 2022-11-18 | Alpine | 3 | 1148 | 138 | 136 | 2 | 138 | 0 |
2322 | 2322 | 2022-11-17 | Alpine | 3 | 1148 | 137 | 136 | 2 | 138 | 0 |
2380 | 2380 | 2022-11-16 | Alpine | 3 | 1148 | 137 | 136 | 2 | 138 | 0 |
2438 | 2438 | 2022-11-15 | Alpine | 3 | 1148 | 137 | 136 | 2 | 138 | 0 |
2496 | 2496 | 2022-11-14 | Alpine | 3 | 1148 | 137 | 136 | 2 | 138 | 0 |
2554 | 2554 | 2022-11-13 | Alpine | 3 | 1148 | 136 | 136 | 2 | 138 | 0 |
2612 | 2612 | 2022-11-12 | Alpine | 3 | 1148 | 136 | 136 | 2 | 138 | 0 |
2670 | 2670 | 2022-11-11 | Alpine | 3 | 1148 | 136 | 136 | 2 | 138 | 0 |
2728 | 2728 | 2022-11-10 | Alpine | 3 | 1148 | 136 | 136 | 2 | 138 | 0 |
2786 | 2786 | 2022-11-09 | Alpine | 3 | 1148 | 136 | 136 | 2 | 138 | 0 |
2844 | 2844 | 2022-11-08 | Alpine | 3 | 1148 | 136 | 136 | 2 | 138 | 0 |
2902 | 2902 | 2022-11-07 | Alpine | 3 | 1148 | 136 | 136 | 1 | 137 | 0 |
2960 | 2960 | 2022-11-06 | Alpine | 3 | 1148 | 136 | 136 | 1 | 137 | 0 |
3018 | 3018 | 2022-11-05 | Alpine | 3 | 1148 | 136 | 136 | 1 | 137 | 0 |
3076 | 3076 | 2022-11-04 | Alpine | 3 | 1148 | 136 | 136 | 1 | 137 | 0 |
3134 | 3134 | 2022-11-03 | Alpine | 3 | 1148 | 136 | 136 | 1 | 137 | 0 |
3192 | 3192 | 2022-11-02 | Alpine | 3 | 1148 | 136 | 136 | 1 | 137 | 0 |
3250 | 3250 | 2022-11-01 | Alpine | 3 | 1148 | 136 | 136 | 1 | 137 | 0 |
3308 | 3308 | 2022-10-31 | Alpine | 3 | 1148 | 136 | 136 | 1 | 137 | 0 |
3366 | 3366 | 2022-10-30 | Alpine | 3 | 1148 | 136 | 136 | 1 | 137 | 0 |
3424 | 3424 | 2022-10-29 | Alpine | 3 | 1148 | 136 | 136 | 1 | 137 | 0 |
3482 | 3482 | 2022-10-28 | Alpine | 3 | 1148 | 136 | 136 | 1 | 137 | 0 |
3540 | 3540 | 2022-10-27 | Alpine | 3 | 1148 | 136 | 136 | 1 | 137 | 0 |
3598 | 3598 | 2022-10-26 | Alpine | 3 | 1148 | 136 | 136 | 1 | 137 | 0 |
3656 | 3656 | 2022-10-25 | Alpine | 3 | 1148 | 136 | 136 | 1 | 137 | 0 |
3714 | 3714 | 2022-10-24 | Alpine | 3 | 1148 | 136 | 136 | 1 | 137 | 0 |
3772 | 3772 | 2022-10-23 | Alpine | 3 | 1148 | 136 | 136 | 1 | 137 | 0 |
3830 | 3830 | 2022-10-22 | Alpine | 3 | 1148 | 136 | 136 | 1 | 137 | 0 |
3888 | 3888 | 2022-10-21 | Alpine | 3 | 1148 | 136 | 136 | 1 | 137 | 0 |
3946 | 3946 | 2022-10-20 | Alpine | 3 | 1148 | 136 | 136 | 1 | 137 | 0 |
4004 | 4004 | 2022-10-19 | Alpine | 3 | 1148 | 136 | 136 | 1 | 137 | 0 |
4062 | 4062 | 2022-10-18 | Alpine | 3 | 1148 | 136 | 136 | 1 | 137 | 0 |
4120 | 4120 | 2022-10-17 | Alpine | 3 | 1148 | 136 | 135 | 1 | 136 | 0 |
4178 | 4178 | 2022-10-16 | Alpine | 3 | 1148 | 136 | 135 | 1 | 136 | 0 |
4236 | 4236 | 2022-10-15 | Alpine | 3 | 1148 | 136 | 135 | 1 | 136 | 0 |
4294 | 4294 | 2022-10-14 | Alpine | 3 | 1148 | 136 | 135 | 1 | 136 | 0 |
4352 | 4352 | 2022-10-13 | Alpine | 3 | 1148 | 136 | 135 | 1 | 136 | 0 |
4410 | 4410 | 2022-10-12 | Alpine | 3 | 1148 | 135 | 135 | 1 | 136 | 0 |
4468 | 4468 | 2022-10-11 | Alpine | 3 | 1148 | 135 | 135 | 1 | 136 | 0 |
4526 | 4526 | 2022-10-10 | Alpine | 3 | 1148 | 135 | 135 | 1 | 136 | 0 |
4584 | 4584 | 2022-10-09 | Alpine | 3 | 1148 | 135 | 135 | 1 | 136 | 0 |
4642 | 4642 | 2022-10-08 | Alpine | 3 | 1148 | 135 | 135 | 1 | 136 | 0 |
4700 | 4700 | 2022-10-07 | Alpine | 3 | 1148 | 135 | 135 | 1 | 136 | 0 |
4758 | 4758 | 2022-10-06 | Alpine | 3 | 1148 | 135 | 135 | 1 | 136 | 0 |
4816 | 4816 | 2022-10-05 | Alpine | 3 | 1148 | 135 | 135 | 1 | 136 | 0 |
4874 | 4874 | 2022-10-04 | Alpine | 3 | 1148 | 135 | 135 | 1 | 136 | 0 |
4932 | 4932 | 2022-10-03 | Alpine | 3 | 1148 | 135 | 134 | 1 | 135 | 0 |
4990 | 4990 | 2022-10-02 | Alpine | 3 | 1148 | 135 | 134 | 1 | 135 | 0 |
5048 | 5048 | 2022-10-01 | Alpine | 3 | 1148 | 135 | 134 | 1 | 135 | 0 |
5106 | 5106 | 2022-09-30 | Alpine | 3 | 1148 | 135 | 134 | 1 | 135 | 0 |
5164 | 5164 | 2022-09-29 | Alpine | 3 | 1148 | 135 | 134 | 1 | 135 | 0 |
5222 | 5222 | 2022-09-28 | Alpine | 3 | 1148 | 134 | 134 | 1 | 135 | 0 |
5280 | 5280 | 2022-09-27 | Alpine | 3 | 1148 | 134 | 134 | 1 | 135 | 0 |
5338 | 5338 | 2022-09-26 | Alpine | 3 | 1148 | 134 | 134 | 1 | 135 | 0 |
5396 | 5396 | 2022-09-25 | Alpine | 3 | 1148 | 134 | 134 | 1 | 135 | 0 |
5454 | 5454 | 2022-09-24 | Alpine | 3 | 1148 | 134 | 134 | 1 | 135 | 0 |
5512 | 5512 | 2022-09-23 | Alpine | 3 | 1148 | 134 | 134 | 1 | 135 | 0 |
5570 | 5570 | 2022-09-22 | Alpine | 3 | 1148 | 134 | 134 | 1 | 135 | 0 |
5628 | 5628 | 2022-09-21 | Alpine | 3 | 1148 | 134 | 134 | 1 | 135 | 0 |
5686 | 5686 | 2022-09-20 | Alpine | 3 | 1148 | 134 | 134 | 1 | 135 | 0 |
5744 | 5744 | 2022-09-19 | Alpine | 3 | 1148 | 134 | 134 | 1 | 135 | 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 );