The Los Angeles Times' open-source archive of California coronavirus data

Table of contents

Cases and deaths

• cdph-county-cases-deaths.csv
• cdph-state-cases-deaths.csv
• cdph-positive-test-rate.csv
• cdph-variants
• latimes-agency-totals.csv
• latimes-county-totals.csv
• latimes-state-totals.csv
• latimes-place-totals.csv
• latimes-county-recovery-estimates.csv
• latimes-state-recovery-estimates.csv

Vaccinations

• cdc-vaccination-state-totals.csv
• cdph-vaccination-county-totals.csv
• cdph-vaccination-state-totals.csv
• cdph-vaccination-zipcode-totals.csv

Demographics

• cdph-age.csv
• cdph-population-race-ethnicity.csv
• cdph-race-ethnicity.csv
• cdph-vaccination-county-by-age.csv
• cdph-vaccination-county-by-race-ethnicity.csv
• cdph-vaccination-state-by-age.csv
• cdph-vaccination-state-by-race-ethnicity.csv

Hospitals

• cdph-hospital-patient-county-totals.csv
• cdph-hospital-patient-state-totals.csv
• cdph-regional-stay-home-metrics.csv
• hhs-hospital-patient-totals.csv
• hhs-hospital-icu-totals.csv

Nursing homes

• cdph-adult-and-senior-care-facilities.csv
• cdph-adult-and-senior-care-totals.csv
• cdph-skilled-nursing-facilities.csv
• cdph-skilled-nursing-totals.csv
• cdph-nursing-home-county-totals.csv

Prisons and jails

• cdcr-prison-totals.csv
• cdcr-state-totals.csv

Schools

• charter-schools-reopening.csv
• school-districts-reopening.csv
• lausd-cases.csv

Maps

• cdph-hpi-zipcodes.csv
• latimes-place-polygons.geojson
• latimes-zipcode-polygons.geojson
• los-angeles-countywide-statistical-areas.json

Other

• cdph-press-releases.csv
• cdph-reopening-metrics.csv
• cdph-reopening-tiers.csv
• latimes-agency-websites.csv
• latimes-beach-closures-area-list.csv
• latimes-beach-closures-county-list.csv
• latimes-project-roomkey-totals.csv

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 ben.welsh@latimes.com.

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
• weylunlee.github.io/covidtrack

Data dictionary

Cases and deaths

cdph-county-cases-deaths.csv

The county-level totals of cases and deaths logged by the California Department of Public Health.

| 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 coronavirus cases that were confirmed as of that time. This is sometimes called the episode date by other sources. | | reported_cases | integer | 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 | integer | 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. | | reportedandprobable_cases | integer | The cumulative number of reported and probable coronavirus cases as of that time. | | reported_deaths | integer | The cumulative number of deaths reported at that time. |

cdph-state-cases-deaths.csv

The statewide total of cases and deaths logged by the California Department of Public Health.

| field | type | description | | ----------------------------- | ------- | --------------------------------------------------------------------------------------------------- | | date | date | The date when the data were retrieved in ISO 8601 format. | | confirmed_cases | integer | 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 | integer | 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 | integer | 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. | | reportedandprobable_cases | integer | The cumulative number of reported and probable coronavirus cases as of that time. | | reported_deaths | integer | The cumulative number of deaths reported at that time. |

cdph-positive-test-rate.csv

All of the data used by The Times to estimate how many recent tests have come back positive. The daily tallies of new cases and tests are drawn from cdph-state-totals.csv.

| 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. | | total_tests | integer | The total number of tests conducted. | | newconfirmedcases | integer | The number of new confirmed cases compared to the previous date. | | new_tests | integer | The number of new tests compared to the previous date. | | newconfirmedcasessevenday_total | integer | The total number of new confirmed cases in the previous seven days. | | newtestssevendaytotal | integer | The total number of new tests in the previous seven days. | | positivetestratesevenday_percent | float | The positive test rate over the past seven days, calculated by dividing the number of new confirmed cases over that time into the number of new tests. |

cdph-variants.csv

The share of cases each month attributed each month to variants tracked by the California Department of Public Health.

| field | type | description | | -------------------------------------- | ------- | ------------------------------------------------------------------------------------------------------------------------------------------------------ | | date | date | The month the data describe in ISO 8601 format. | | alpha | float | The percentage of new cases attributed to the Alpha variant | | gamma | float | The percentage of new cases attributed to the Gamma variant | | epsilon | float | The percentage of new cases attributed to the Epsilon variant | | iota | float | The percentage of new cases attributed to the Iota variant | | delta | float | The percentage of new cases attributed to the Delta variant | | other | float | The percentage of new cases attributed to other variants |

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. 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.

| 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. | | didnotupdate | 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. 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.

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. | | newconfirmedcases | 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. 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.

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. | | newconfirmedcases | integer | The net change in confirmed cases over the previous date. | | new_deaths | integer | The net change in deaths over the previous date. |

latimes-place-totals.csv

Most counties 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. Some counties currently do not report cases by locality.

Different counties provide different geography types. Some provide data by region, some by Census designation, some by ZIP Code. The locations provided by Los Angeles County correspond to the public health department's official "Countywide Statistical Areas". Locations can be mapped after being joined to the shapes in latimes-places-polygons.geojson using the id column.

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 | | ----------------- | ------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | | id | string | The unique identifier of the city, neighborhood or other area. | | name | string | The name of the city, neighborhood or other area. | | 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. | | 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. | | population | integer | The number of residents in the area. Not available for all places. |

latimes-county-recovery-estimates.csv

The estimated number of recovered and active cases by county each day.

The number is calculated by subtracting active case, deaths and currently hospitalized patients from the total case count. Active cases are estimated as the number of new cases over the last 14 days, which is based on the amount of time the CDC says most adults remain infectious with COVID-19. The Times consulted biostatisticians at UCLA and UCSF to develop the approach. Some health agencies use the same method.

The result matches closely in areas with officially reported counts. One limitation is that there may be some overlap among active and hospitilized cases, leading to an underestimate in the number of recovered patients.

| 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 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. | | recoveries_estimated | integer | The cumulative number of estimated recovered coronavirus cases as of this date. | | active_cases | integer | The current number of presumed active cases, or newly reported cases in the last 14 days, as of this date. |

latimes-state-recovery-estimates.csv

The estimated number of recovered and active cases statewide each day.

The number is calculated by subtracting active case, deaths and currently hospitalized patients from the total case count. Active cases are estimated as the number of new cases over the last 14 days, which is based on the amount of time the CDC says most adults remain infectious with COVID-19. The Times consulted biostatisticians at UCLA and UCSF to develop the approach. Some health agencies use the same method.

The result matches closely in areas with officially reported counts. One limitation is that there may be some overlap among active and hospitilized cases, leading to an underestimate in the number of recovered patients.

| field | type | description | | :---------------- | :------ | :---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | date | date | The date when the data were retrieved in ISO 8601 format. | | recoveries_estimated | integer | The cumulative number of estimated recovered coronavirus cases as of this date. | | active_cases | integer | The current number of presumed active cases, or newly reported cases in the last 14 days, as of this date. |

Vaccinations

cdc-vaccination-state-totals.csv

State-level vaccination totals derived from the dashboard published by the U.S. Centers for Disease Control and Prevention.

| field | type | description | | --------------------------------------- | -------- | --------------------------------------------------------------------------------------------------- | | date | date | The date when the data were collected in ISO 8601 format. | | state | string | The name of the state. | | population | integer | The number of people who live in the state. | | doses_distributed | integer | The total number of doses sent to the state as of that date. | | doses_administered | integer | The total number of shots given out in the state as of that date. | | dosesadministeredpercent | float | The percentage of distributed doses that have been administered as of that date. | | administered_dose1 | integer | The number of first doses administered in the state of that date. | | administereddose1percent | float | The percentage of people in the state who have received at least one dose as of that date. | | administered_dose2 | integer | The number of second doses administered in the state of that date. | | administereddose2percent | float | The percentage of people in the state who are fully vaccinated as of that date. |

cdph-vaccination-county-totals.csv

California's Department of Public Health releases county-level vaccination totals via a Tableau dashboard. Our team extracts and logs the data each day.

| field | type | description | | ----------------------------- | ------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | | date | date | The date for which 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. | | population | integer | The number of people who live in the county. | | doses_administered | integer | The total number of doses given as of this date. | | newdosesadministered | integer | The number of new doses compared to the previous date. | | pfizer_doses | integer | The total number of Pfizer doses given as of this date. | | newpfizerdoses | integer | The number of new Pfizer doses compared to the previous date. | | moderna_doses | integer | The total number of Moderna doses given as of this date. | | newmodernadoses | integer | The number of new Moderna doses compared to the previous date. | | jj_doses | integer | The total number of Johnson & Johnson doses given as of this date. | | newjjdoses | integer | The number of new Johnson & Johnson doses compared to the previous date. | | partially_vaccinated | integer | The total number of partially vaccinated people as of this date. | | newpartiallyvaccinated | integer | The number of new partially vaccinated people compared to the previous date. | | atleastone_dose | integer | The total number of people who have received at least one dose any vaccine given as of this date. | | newatleastonedose | integer | The number of new people who have received at least one dose any vaccine compared to the previous date. | | fully_vaccinated | integer | The total number of fully vaccinated people as of this date. | | newfullyvaccinated | integer | The number of new fully vaccinated people compared to the previous date. | | partiallyvaccinatedpercent| float | The percentage of people who were partially vaccinated as of this date. | | atleastonedosepercent | float | The percentage of people who received at least one dose any vaccine as of this date. | | fullyvaccinatedpercent | float | The percentage of people who were fully vaccinated as of this date. |

cdph-vaccination-state-totals.csv

California's Department of Public Health is releasing state-level vaccination totals. Our team extracts and logs the data each day.

| field | type | description | | ---------------------------- | ------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | | date | date | The date for which data were reported in ISO 8601 format. | | doses_administered | integer | The total number of doses given as of this date. | | newdosesadministered | integer | The number of new doses compared to the previous date. | | pfizer_doses | integer | The total number of Pfizer doses given as of this date. | | newpfizerdoses | integer | The number of new Pfizer doses compared to the previous date. | | moderna_doses | integer | The total number of Moderna doses given as of this date. | | newmodernadoses | integer | The number of new Moderna doses compared to the previous date. | | jj_doses | integer | The total number of Johnson & Johnson doses given as of this date. | | newjjdoses | integer | The number of new Johnson & Johnson doses compared to the previous date. | | partially_vaccinated | integer | The total number of partially vaccinated people as of this date. | | newpartiallyvaccinated | integer | The number of new partially vaccinated people compared to the previous date. | | atleastone_dose | integer | The total number of people who have received at least one dose any vaccine given as of this date. | | newatleastonedose | integer | The number of new people who have received at least one dose any vaccine compared to the previous date. | | fully_vaccinated | integer | The total number of fully vaccinated people as of this date. | | newfullyvaccinated | integer | The number of new fully vaccinated people compared to the previous date. | | partiallyvaccinatedpercent| float | The percentage of people who were partially vaccinated as of this date. | | atleastonedosepercent | float | The percentage of people who received at least one dose any vaccine as of this date. | | fullyvaccinatedpercent | float | The percentage of people who were fully vaccinated as of this date. |

cdph-vaccination-zipcode-totals.csv

California's Department of Public Health is releasing zipcode-level vaccination totals. Our team extracts and logs the data each day. Population estimates from the U.S. Census Bureau, gathered by The Times, are used to calculate the percentage of the total population that is vaccinated.

| field | type | description | | ----------------------------- | ------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | | date | date | The date for which data were reported in ISO 8601 format. | | id | string | The unique identifer of the ZIP Code. | | 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. | | population | integer | The number of people who live in the county. | | partially_vaccinated | integer | The total number of partially vaccinated people as of this date. | | atleastone_dose | integer | The total number of people who have received at least one dose any vaccine given as of this date. | | fully_vaccinated | integer | The total number of fully vaccinated people as of this date. | | partiallyvaccinatedpercent| float | The percentage of people who were partially vaccinated as of this date. | | atleastonedosepercent | float | The percentage of people who received at least one dose any vaccine as of this date. | | fullyvaccinatedpercent | float | The percentage of people who were fully vaccinated as of this date. |

Demographics

cdph-age.csv

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

| field | type | description | | ------------------------- | ------- | --------------------------------------------------------------------------------------------------- | | date | date | The date when the data were retrieved in ISO 8601 format. | | age | string | The age bracket being tallied | | confirmedcasestotal | integer | The cumulative number of confirmed coronavirus case amoung this age bracket at that time. | | confirmedcasespercent | float | The case totals percentage of the total in this age bracket | | deaths_total | integer | The cumulative number of deaths case amoung this age bracket at that time. | | deaths_percent | float | The death totals percentage of the total in this age bracket. |

cdph-population-race-ethnicity.csv

The breakdown of the population by race and ethnicity statewide and in each of the 58 counties, as provided by the California Department of Public Health.

| field | type | description | | ------------------------ | ------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | | county | string | The name of the county. The state of California also included as a row. | | fips | string | The FIPS code given to the county by the federal government. Can be used to merge with other data sources. | | aian | float | The percentage of people in the area who are American Indian or Alaska Native | | asian | float | The percentage of people in the area who are Asian | | black | float | The percentage of people in the area who are Black | | latino | float | The percentage of people in the area who are Latino | | multirace | float | The percentage of people in the area who are multirace | | nhpi | float | The percentage of people in the area who are Native Hawaiian or Pacific Islander | | other | float | The percentage of people in the area who are of another race | | unknown | float | The percentage of people in the area who are of unknown race | | white | float | The percentage of people in the area who are white |

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 | | confirmedcasestotal | integer | The cumulative number of confirmed coronavirus case amoung this race and age at that time. | | confirmedcasespercent | 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-vaccination-county-by-age.csv

California's Department of Public Health releases county-level vaccination totals segemented by age.

| field | type | description | | --------------------------------------- | ------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | | 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. | | date | date | The date for which data were reported in ISO 8601 format. | | age_group | string | The age group being tallied. | | partially_vaccinated | integer | The total number of partially vaccinated people as of this date. | | atleastone_dose | integer | The total number of people who have received at least one dose any vaccine given as of this date. | | fully_vaccinated | integer | The total number of fully vaccinated people as of this date. | | population_total | integer | The number of people who live in the county. | | population12and_up | integer | The number of people 12 years or older who live in the county. | | partiallyvaccinatedpercent | float | The percentage of people who were partially vaccinated as of this date. | | partiallyvaccinatedpercent12and_up| float | The percentage of people 12 and up who were partially vaccinated as of this date. | | atleastonedosepercent | float | The percentage of people who received at least one dose any vaccine as of this date. | | atleastonedosepercent12and_up | float | The percentage of people 12 and up who received at least one dose any vaccine as of this date. | | fullyvaccinatedpercent | float | The percentage of people who were fully vaccinated as of this date. | | fullyvaccinatedpercent12and_up | float | The percentage of people 12 and up who were fully vaccinated as of this date. |

cdph-vaccination-county-by-race-ethnicity.csv

California's Department of Public Health releases county-level vaccination totals segemented by race and ethnicity. The racial groups provided by the state have been simplified to the categories commonly used by Los Angeles Times.

| field | type | description | | --------------------------------------- | ------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | | 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. | | date | date | The date for which data were reported in ISO 8601 format. | | race_ethnicity | string | The race group being tallied. | | partially_vaccinated | integer | The total number of partially vaccinated people as of this date. | | atleastone_dose | integer | The total number of people who have received at least one dose any vaccine given as of this date. | | fully_vaccinated | integer | The total number of fully vaccinated people as of this date. | | population_total | integer | The number of people who live in the county. | | population12and_up | integer | The number of people 12 years or older who live in the county. | | partiallyvaccinatedpercent | float | The percentage of people who were partially vaccinated as of this date.