The total cases and deaths logged by local public health agencies each day. Each row contains the cumulative totals reported by a single agency as of that date. This file stopped updating in September 2021 when The Times switched its tracker to use case and death counts consolidated by the state's Department of Public Health. Those figures can be found elsewhere in this repository.
Most counties have only one agency except for Alameda and Los Angeles counties, where some cities run independent health departments. In Alameda County, the city of Berkeley is managed independently. In Los Angeles County, Pasadena and Long Beach are managed independently. These cities' totals are broken out into separate rows. In order to calculate county-level totals, you must aggregate them together using the county field.
Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README
This data as json, yaml, Notebook, copyable
| rowid | agency | county | fips | date | confirmed_cases | deaths | did_not_update |
|---|---|---|---|---|---|---|---|
| 51 | Solano | Solano | 95 | 2021-09-02 | 41521 | 273 | TRUE |