dramirad/california-coronavirus-data

The Los Angeles Times' independent tally of coronavirus cases in California.

california-coronavirus-data

The Los Angeles Times' independent tally of coronavirus cases in California.

Table of contents

• latimes-agency-totals.csv
• latimes-county-totals.csv
• latimes-state-totals.csv
• latimes-agency-websites.csv
• latimes-place-totals.csv
• cdph-state-totals.csv
• cdph-race-ethnicity.csv
• cdph-skilled-nursing-totals.csv
• cdph-adult-and-senior-care-totals.csv
• cdph-skilled-nursing-facilities.csv
• cdph-adult-and-senior-care-facilities.csv
• cdph-hospital-patient-county-totals.csv
• latimes-project-roomkey-totals.csv
• latimes-beach-closures-county-list.csv
• latimes-beach-closures-area-list.csv
• los-angeles-countywide-statistical-areas.json

About the data

These files come from a continual Times survey of California's 58 county health agencies and three city agencies. Updated numbers are published throughout the day at latimes.com/coronavirustracker. This repository will periodically update with an extract of that data.

The figures are typically ahead of the totals compiled by California's Department of Public Health. By polling local agencies, The Times database also gathers some information not provided by the state. The system has won praise from public health officials, who do not dispute its method of data collection.

The tallies here are mostly limited to residents of California, the standard method used to count patients by the state’s health authorities. Those totals do not include people from other states who are quarantined in California, such as the passengers and crew of the Grand Princess cruise ship that docked in Oakland.

Reusing the data

The Los Angeles Times is making coronavirus infections data available for use by researchers and scientists to aid in the fight against COVID-19.

The company's Terms of Service apply. By using the data, you accept and agree to follow the Terms of Services.

It states that "you may use the content online only, and solely for your personal, non-commercial use, provided you do not remove any trademark, copyright or other notice from such Content," and that, "no other use is permitted without prior written permission of Los Angeles Times."

Reselling the data is forbidden. Any use of these data in published works requires attribution to the Los Angeles Times.

To inquire about reuse, please contact Data and Graphics Editor Ben Welsh at [email protected].

Examples of reuse

• UC San Francisco: "UCSF Health Atlas"
• UCLA: "COVID-19 Sandbox Maproom"
• Capradio: "Track COVID-19 Cases In California By County"
• Race Counts: "How race, class and place fuel a pandemic"
• covid-19-datasette
• KQED: "How Many Coronavirus Cases Are in California? See Latest Numbers by County"
• KQED: "Here Are the Trendlines for COVID-19 Deaths and Hospitalizations in Each Bay Area County"
• Geography Planet: Southern California COVID trend map

Data dictionary

latimes-agency-totals.csv

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.

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.

field	type	description
agency	string	The name of the county or city public health agency that provided the data. Guaranteed to be unique when combined with the date field.
county	string	The name of the county where the agency is based.
fips	string	The FIPS code given to the county by the federal government. Can be used to merge with other data sources.
date	date	The date when the data were retrieved in ISO 8601 format.
confirmed_cases	integer	The cumulative number of confirmed coronavirus cases as of this date.
deaths	integer	The cumulative number of deaths attributed to coronavirus as of this date.
recoveries	integer	The cumulative number of recovered cases as of this date. Only some agencies provide this data.
did_not_update	boolean	Indicates if the agency did not provide an update on this date. If this is true and the case and death totals are unchanged from the previous day, this means they were holdovers. Use this flag omit these records when desired.

latimes-county-totals.csv

The county-level totals of cases and deaths logged by local public health agencies each day. This is a derived table. Each row contains the aggregation of all local agency reports in that county logged by Los Angeles Times reporters and editors in latimes-agency-totals.csv.

It comes with all of the same caveats as its source. It is included here as a convenience.

field	type	description
county	string	The name of the county where the agency is based.
fips	string	The FIPS code given to the county by the federal government. Can be used to merge with other data sources.
date	date	The date when the data were retrieved in ISO 8601 format.
confirmed_cases	integer	The cumulative number of confirmed coronavirus case at that time.
deaths	integer	The cumulative number of deaths at that time.
new_confirmed_cases	integer	The net change in confirmed cases over the previous date.
new_deaths	integer	The net change in deaths over the previous date.

latimes-state-totals.csv

The statewide total of cases and deaths logged by local public health agencies each day. This is a derived table. Each row contains the aggregation of all local agency reports logged by Los Angeles Times reporters and editors in latimes-agency-totals.csv.

It comes with all of the same caveats as its source. It is included here as a convenience.

field	type	description
date	date	The date when the data were retrieved in ISO 8601 format.
confirmed_cases	integer	The cumulative number of confirmed coronavirus case at that time.
deaths	integer	The cumulative number of deaths at that time.
new_confirmed_cases	integer	The net change in confirmed cases over the previous date.
new_deaths	integer	The net change in deaths over the previous date.

latimes-agency-websites.csv

The 61 local-health agency websites that the Los Angeles Times consults to conduct its survey.

field	type	description
agency	string	The name of the county or city public health agency.
url	string	The location of the agency's website on the World Wide Web.

latimes-place-totals.csv

Some counties, primarily in Southern California, break out the location of cases within their service area. The Times is gathering and consolidating these lists. Each row contains cumulative case totals reported in that area as of that date.

The following counties currently do not report cases by locality: Alpine, Colusa, Del Norte, Glenn, Inyo, Lake, Lassen, Madera, Mariposa, Modoc, San Benito, San Mateo, Shasta, Sierra, Siskiyou, Sutter, Tehama, Trinity, Tuolumne and Yuba

Some counties provide data by region. The locations provided by Los Angeles County correspond to the public health department's official "Countywide Statistical Areas". Locations in other counties are manually geocoded by The Times. San Francisco and Imperial counties provide data at the ZIP Code level.

Be aware that some counties have shifted the place names used over time.

In some circumstances the true total of cases is obscured. Los Angeles and Orange counties decline to provide the precise number of cases in areas with low populations and instead provide a potential range. The lowest number in the range is entered into the record in the confirmed_cases field and an accompanying note includes the set of possible values.

field	type	description
date	date	The date when the data were retrieved in ISO 8601 format.
county	string	The name of the county where the city is located.
fips	string	The FIPS code given to the county by the federal government. Can be used to merge with other data sources.
place	string	The name of the city, neighborhood or other area.
confirmed_cases	integer	The cumulative number of confirmed coronavirus case at that time.
note	string	In cases where the confirmed_cases are obscured, this explains the range of possible values.
x	float	The longitude of the place.
y	float	The latitude of the place.

cdph-state-totals.csv

Totals published by the California Department of Public Health in its daily press releases. Each row contains all numbers included in that day's release.

This file includes cases and deaths, the age of victims, transmission types, tests and hospitalizations. The state has stopped supplying some fields and began supplying some others over time. Deprecated fields have been maintained in this file and are noted below.

Due to bureaucratic lags, the state's totals for cases and deaths arrive slower than The Times numbers, which are generated by surveying local agencies. The state's methods for collecting testing data have struggled with errors and delays.

Some dates are missing because the state did not publish a press release for that day.

field	type	description
date	date	The date when the data were retrieved in ISO 8601 format.
confirmed_cases	integer	The cumulative number of confirmed coronavirus case at that time.
deaths	integer	The cumulative number of deaths at that time.
travel	integer	The number of cases acquired while traveling. The state stopped publishing it on March 24.
person_to_person	integer	The number of cases acquired from close contacts and family members. The state stopped publishing it on March 24.
community_spread	integer	The number of cases acquired from community spread. The state stopped publishing it on March 29.
under_investigation	integer	The number of cases acquired from an unknown source. The state stopped publishing it on March 24.
other_causes	integer	The number of cases acquired from other sources. On March 24 the state began combining this figure with travel, person-to-person and under investigation cases. On March 29 the state stopped publishing it.
self_monitoring	integer	The number of people in a form of isolation monitored by the state. The state stopped publishing it on March 19.
age_0_to_17	integer	The number of confirmed cases involving a person between 0 and 18 years old.
age_18_to_49	integer	The number of confirmed cases involving a person between 18 and 49 years old.
age_50_to_64	integer	The number of confirmed cases involving a person between 50 and 64 years old.
age_65_and_up	integer	The number of confirmed cases involving a person 65 of older.
age_18_to_64	integer	The number of confirmed cases involving a person between 18 and 64 years old. The state stopped publishing it on March 23.
age_unknown	integer	The number of confirmed cases involving a person of unknown age.
gender_male	integer	The number of confirmed cases involving a male.
gender_female	integer	The number of confirmed cases involving a female.
gender_unknown	integer	The number of confirmed cases involving a a person of unknown gender.
total_tests	integer	The total number of tests conducted.
received_tests	integer	The number of tests results received. The state stopped publishing this field in April 24.
pending_tests	integer	The number of tests resuts that are still pending. The state stopped publishing this field in April 24.
confirmed_hospitalizations	integer	The total number of hospitalizations with a confirmed case of COVID-19.
confirmed_icu	integer	The number of ICU hospitalizations with a confirmed case of COVID-19.
suspected_hospitalizations	integer	The total number of hospitalizations with a suspected case of COVID-19.
suspected_icu	integer	The number of ICU hospitalizations with a suspected case of COVID-19.
healthcare_worker_infections	integer	The total number of healthcare workers who have tested positive for COVID-19.
healthcare_worker_deaths	integer	The total number of healthcare workers who have died from COVID-19.
source_url	string	The URL to the state press release.

cdph-race-ethnicity.csv

Statewide demographic data tallying race totals by age for both cases and deaths. Provided by the California Department of Public Health.

The original race categories published by the state have been grouped and aggregated to match the five race categories traditionally published by the Los Angeles Times.

field	type	description
date	date	The date when the data were retrieved in ISO 8601 format.
race	string	The race being tallied.
age	string	The age bracket being tallied
confirmed_cases_total	integer	The cumulative number of confirmed coronavirus case amoung this race and age at that time.
confirmed_cases_percent	float	The case totals percentage of the total in this age bracket
deaths_total	integer	The cumulative number of deaths case amoung this race and age at that time.
deaths_percent	float	The death totals percentage of the total in this age bracket.
population_percent	float	The race's percentage of the overall state population in this age bracket.

cdph-skilled-nursing-totals.csv

California's Department of Public Health is releasing totals tracking the cumulative number of cases and deaths at the state's skilled nursing facilities.

In some circumstances the true total of cases is obscured. The lowest number in the range is entered into the record in the staff or patients field and an accompanying note field includes the set of possible values.

field	type	description
date	date	The date when the data were retrieved in ISO 8601 format.
staff_active_cases	integer	The current number of active coronavirus case among staff at that time.
patients_active_cases	integer	The current number of active coronavirus case among patients at that time.
staff_confirmed_cases	integer	The cumulative number of confirmed coronavirus case among staff at that time.
patients_confirmed_cases	integer	The cumulative number of confirmed coronavirus case among patients at that time.
staff_confirmed_cases_note	string	In cases where the staff_confirmed_cases are obscured, this explains the range of possible values.
patients_confirmed_cases_note	string	In cases where the patients_confirmed_cases are obscured, this explains the range of possible values.
staff_deaths	integer	The cumulative number of deaths case among staff at that time.
patients_deaths	integer	The cumulative number of deaths case among patients at that time.
staff_deaths_note	string	In cases where the staff_deaths are obscured, this explains the range of possible values.
patients_deaths_note	string	In cases where the patients_deaths are obscured, this explains the range of possible values.
source_url	string	The URL to the state data release.

cdph-adult-and-senior-care-totals.csv

California's Department of Public Health is releasing totals tracking the cumulative number of cases and deaths at the state's residential care facilities for the elderly and adult residential facilities.

These are also sometimes known as assisted-living facilities. Counts for staff and patients are combined in this dataset into a single total.

field	type	description
date	date	The date when the data were retrieved in ISO 8601 format.
confirmed_cases	integer	The cumulative number of confirmed coronavirus case amoung staff and patients at that time.
deaths	integer	The cumulative number of deaths case amoung staff and patients at that time.
source_url	string	The URL to the state data release.

cdph-skilled-nursing-facilities.csv

California's Department of Public Health is listing the skilled-nursing facilities across the state with COVID-19 outbreaks.

In some circumstances the true total of cases is obscured. The lowest number in the range is entered into the record in the staff or patients field and an accompanying note field includes the set of possible values.

field	type	description
date	date	The date when the data were retrieved in ISO 8601 format.
id	string	The facility's unique identifier with the state.
name	string	The name of the skilled-nursing facility.
county	string	The name of the county where the city is located.
fips	string	The FIPS code given to the county by the federal government. Can be used to merge with other data sources.
staff_active_cases	integer	The current number of active coronavirus case among staff at that time.
patients_active_cases	integer	The current number of active coronavirus case among patients at that time.
staff_active_cases_note	string	In cases where the staff_active_cases are obscured, this explains the range of possible values.
patients_active_cases_note	string	In cases where the patients_active_cases are obscured, this explains the range of possible values.
staff_confirmed_cases	integer	The current number of confirmed coronavirus case amoung staff at that time.
patients_confirmed_cases	integer	The current number of confirmed coronavirus case amoung patients at that time.
staff_confirmed_cases_note	string	In cases where the staff_confirmed_cases are obscured, this explains the range of possible values.
patients_confirmed_cases_note	string	In cases where the patients_confirmed_cases are obscured, this explains the range of possible values.
staff_deaths	integer	The cumulative number of deaths case amoung staff at that time.
patients_deaths	integer	The cumulative number of deaths case amoung patients at that time.
staff_deaths_note	string	In cases where the staff_deaths are obscured, this explains the range of possible values.
patients_deaths_note	string	In cases where the patients_deaths are obscured, this explains the range of possible values.

cdph-adult-and-senior-care-facilities.csv

California's Department of Public Health is listing the residential care facilities for the elderly and adult residential facilities across the state with COVID-19 outbreaks.

These are also sometimes known as assisted-living facilities. In some circumstances the true total of cases is obscured. The lowest number in the range is entered into the record in the staff or patients field and an accompanying note field includes the set of possible values.

field	type	description
date	date	The date when the data were retrieved in ISO 8601 format.
name	string	The name of the nursing home.
county	string	The name of the county where the city is located.
fips	string	The FIPS code given to the county by the federal government. Can be used to merge with other data sources.
staff_confirmed_cases	integer	The current number of confirmed coronavirus case amoung staff at that time.
patients_confirmed_cases	integer	The current number of confirmed coronavirus case amoung patients at that time.
staff_confirmed_cases_note	string	In cases where the staff_confirmed_cases are obscured, this explains the range of possible values.
patients_confirmed_cases_note	string	In cases where the patients_confirmed_cases are obscured, this explains the range of possible values.
staff_deaths	integer	The cumulative number of deaths case amoung staff at that time.
patients_deaths	integer	The cumulative number of deaths case amoung patients at that time.
staff_deaths_note	string	In cases where the staff_deaths are obscured, this explains the range of possible values.
patients_deaths_note	string	In cases where the patients_deaths are obscured, this explains the range of possible values.

cdph-hospital-patient-county-totals.csv

California's Department of Public Health is releasing county-level hospitalization totals.

field	type	description
date	date	The date for which hospital data were reported in ISO 8601 format.
county	string	The name of the county.
fips	string	The FIPS code given to the county by the federal government. Can be used to merge with other data sources.
positive_patients	integer	The current number confirmed coronavirus cases in hospitals on this date.
suspected_patients	integer	The current number suspected coronavirus cases in hospitals on this date.
icu_positive_patients	integer	The current number confirmed coronavirus cases in intensive-care units on this date.
icu_suspected_patients	integer	The current number suspected coronavirus cases in intensive-care units on this date.

latimes-project-roomkey-totals.csv

Los Angeles County officials have launched an unprecedented effort to shield 15,000 homeless people from the coronavirus by moving them into hotel rooms. The Times is tracking the latest data from the Los Angeles County Emergency Operations Center and the Los Angeles County Department of Public Health.

field	type	description
date	date	The date on which data were reported in ISO 8601 format.
people_housed	integer	The current number of homeless people in Los Angeles County housed on this date.
leased_rooms	integer	The current number hotel rooms leased on this date.
rooms_ready_to_occupy	integer	The subset of leased rooms that were ready to occupy on this date.
rooms_occupied	integer	The subset of ready rooms that were occupied on this date.
homeless_confirmed_cases	integer	The cumulative number of homeless people in Los Angeles County that had tested positive by this date.

latimes-beach-closures-county-list.csv

The county-level restrictions on beach access, compiled by the Los Angeles Times based on data released by the California Coastal Commission.

field	type	description
county	string	The name of the county where the agency is based.
fips	string	The FIPS code given to the county by the federal government. Can be used to merge with other data sources.
status	string	A Times classification of the current level of restriction in this county
restriction	string	A description of the current level of restriction in this county

latimes-beach-closures-area-list.csv

The subcounty-level restrictions on beach access, compiled by the Los Angeles Times based on data released by the California Coastal Commission.

field	type	description
county	string	The name of the county where the agency is based.
fips	string	The FIPS code given to the county by the federal government. Can be used to merge with other data sources.
area	string	The name of the sub-county area being tracked.
state_park	boolean	An indicator if this area is a state park.
restriction	string	A description of the current level of restriction in this area.

los-angeles-countywide-statistical-areas.json

A GeoJSON file mapping out statistical tabulation areas created by the Los Angeles County Department of Public Health. Place-level data released by Los Angeles County correspond to these areas. Acquired via a California Public Records Act request.

field	type	description
type	string	The type of area being mapped. Options are City andUnincorporated
city	string	The name of the area's municipal parent, if it has one.
community	string	The name of the area.
label	boolean	A combination of the area's name and city. Creates a unique string.
centroid_x	string	The longitude of the area's centroid.
centroid_y	string	The latitude of the area's centroid.

Getting started

The data published here can be easily imported to any data analysis tool, ranging from a simple spreadsheet to a more sophisticated analysis framework. This repository has be pre-configured to work with the Python computer-programming language and a Jupyter computational notebook. You can install and run the code locally on your computer, or on the web with Binder.

Installing locally

Make a fork of this repository, clone it to your computer, then move into the directory.

cd california-coronavirus-data

Install the Python tools you need with pipenv.

pipenv install

Start the Jupyter Lab programming environment.

pipenv run jupyter lab

Check out the example notebook at notebooks/examples.ipynb.

Running online with Binder

Click on the Binder badge above and this repository will boot up inside the site's system for running Jupyter notebooks over the web. After a few minutes you should have an Jupyter Lab environment up and running.

How you can help

This survey is conducted by The Times' Data and Graphics Department. If you'd like to support its effort to keep California and the nation informed, the best thing you can do is buy a digital subscription and encourage others to do the same. The coronavirus pandemic has had a significant effect on the country's economy and the news industry is no exception. Without support from readers like you projects like this would not be possible.

Contact

To inquire about the data or about reuse, please contact Data and Graphics Editor Ben Welsh at [email protected]