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
Schools
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 [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
- 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. |
reported_and_probable_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. |
reported_and_probable_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. |
new_confirmed_cases |
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. |
new_confirmed_cases_seven_day_total |
integer | The total number of new confirmed cases in the previous seven days. |
new_tests_seven_day_total |
integer | The total number of new tests in the previous seven days. |
positive_test_rate_seven_day_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. |
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. 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. |
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. 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. |
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-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. |
doses_administered_percent |
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. |
administered_dose1_percent |
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. |
administered_dose2_percent |
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. |
new_doses_administered |
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. |
new_pfizer_doses |
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. |
new_moderna_doses |
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. |
new_jj_doses |
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. |
new_partially_vaccinated |
integer | The number of new partially vaccinated people compared to the previous date. |
at_least_one_dose |
integer | The total number of people who have received at least one dose any vaccine given as of this date. |
new_at_least_one_dose |
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. |
new_fully_vaccinated |
integer | The number of new fully vaccinated people compared to the previous date. |
partially_vaccinated_percent |
float | The percentage of people who were partially vaccinated as of this date. |
at_least_one_dose_percent |
float | The percentage of people who received at least one dose any vaccine as of this date. |
fully_vaccinated_percent |
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. |
new_doses_administered |
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. |
new_pfizer_doses |
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. |
new_moderna_doses |
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. |
new_jj_doses |
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. |
new_partially_vaccinated |
integer | The number of new partially vaccinated people compared to the previous date. |
at_least_one_dose |
integer | The total number of people who have received at least one dose any vaccine given as of this date. |
new_at_least_one_dose |
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. |
new_fully_vaccinated |
integer | The number of new fully vaccinated people compared to the previous date. |
partially_vaccinated_percent |
float | The percentage of people who were partially vaccinated as of this date. |
at_least_one_dose_percent |
float | The percentage of people who received at least one dose any vaccine as of this date. |
fully_vaccinated_percent |
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. |
at_least_one_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. |
partially_vaccinated_percent |
float | The percentage of people who were partially vaccinated as of this date. |
at_least_one_dose_percent |
float | The percentage of people who received at least one dose any vaccine as of this date. |
fully_vaccinated_percent |
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 |
confirmed_cases_total |
integer | The cumulative number of confirmed coronavirus case amoung this age bracket 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 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 |
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-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. |
at_least_one_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. |
population_12_and_up |
integer | The number of people 12 years or older who live in the county. |
partially_vaccinated_percent |
float | The percentage of people who were partially vaccinated as of this date. |
partially_vaccinated_percent_12_and_up |
float | The percentage of people 12 and up who were partially vaccinated as of this date. |
at_least_one_dose_percent |
float | The percentage of people who received at least one dose any vaccine as of this date. |
at_least_one_dose_percent_12_and_up |
float | The percentage of people 12 and up who received at least one dose any vaccine as of this date. |
fully_vaccinated_percent |
float | The percentage of people who were fully vaccinated as of this date. |
fully_vaccinated_percent_12_and_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. |
at_least_one_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. |
population_12_and_up |
integer | The number of people 12 years or older who live in the county. |
partially_vaccinated_percent |
float | The percentage of people who were partially vaccinated as of this date. |
partially_vaccinated_percent_12_and_up |
float | The percentage of people 12 and up who were partially vaccinated as of this date. |
at_least_one_dose_percent |
float | The percentage of people who received at least one dose any vaccine as of this date. |
at_least_one_dose_percent_12_and_up |
float | The percentage of people 12 and up who received at least one dose any vaccine as of this date. |
fully_vaccinated_percent |
float | The percentage of people who were fully vaccinated as of this date. |
fully_vaccinated_percent_12_and_up |
float | The percentage of people 12 and up who were fully vaccinated as of this date. |
cdph-vaccination-state-by-age.csv
California's Department of Public Health releases county-level vaccination totals segemented by age.
| field | type | description |
|---|---|---|
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. |
at_least_one_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. |
population_12_and_up |
integer | The number of people 12 years or older who live in the county. |
partially_vaccinated_percent |
float | The percentage of people who were partially vaccinated as of this date. |
partially_vaccinated_percent_12_and_up |
float | The percentage of people 12 and up who were partially vaccinated as of this date. |
at_least_one_dose_percent |
float | The percentage of people who received at least one dose any vaccine as of this date. |
at_least_one_dose_percent_12_and_up |
float | The percentage of people 12 and up who received at least one dose any vaccine as of this date. |
fully_vaccinated_percent |
float | The percentage of people who were fully vaccinated as of this date. |
fully_vaccinated_percent_12_and_up |
float | The percentage of people 12 and up who were fully vaccinated as of this date. |
cdph-vaccination-state-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 |
|---|---|---|
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. |
at_least_one_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. |
population_12_and_up |
integer | The number of people 12 years or older who live in the county. |
partially_vaccinated_percent |
float | The percentage of people who were partially vaccinated as of this date. |
partially_vaccinated_percent_12_and_up |
float | The percentage of people 12 and up who were partially vaccinated as of this date. |
at_least_one_dose_percent |
float | The percentage of people who received at least one dose any vaccine as of this date. |
at_least_one_dose_percent_12_and_up |
float | The percentage of people 12 and up who received at least one dose any vaccine as of this date. |
fully_vaccinated_percent |
float | The percentage of people who were fully vaccinated as of this date. |
fully_vaccinated_percent_12_and_up |
float | The percentage of people 12 and up who were fully vaccinated as of this date. |
Hospitals
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. |
icu_available_beds |
integer | The current number open and avilable intensive-care beds on this date. |
cdph-hospital-patient-state-totals.csv
California's Department of Public Health is releasing county-level hospitalization totals. The file aggregates them statewide.
| field | type | description |
|---|---|---|
date |
date | The date for which hospital data were reported in ISO 8601 format. |
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. |
icu_available_beds |
integer | The current number open and avilable intensive-care beds on this date. |
cdph-regional-stay-home-metrics.csv
In December 2020, the state introduced a new system for issuing stay home orders. The state's 58 counties were grouped into six regions and judged based on the percentage of available ICU beds. When the percentage available beds dropped below 15%, a stay home order restricting businesses and movement would be issued.
This file records the metrics released for each region by day.
| field | type | description |
|---|---|---|
date |
date | The date when the data were collected in ISO 8601 format. |
region |
string | The name of the region. |
icu_capacity_percent |
float | The percentage of ICU beds in the region that were available on that date |
stay_home_order |
string | An indicator of whether or not a stay home order was in effect for the region on that date. The range of values is pending, yes and no. |
hhs-hospital-patient-totals.csv
The Department of Health and Human Services releases a weekly update on the number of COVID-19 patients in hospitals. This file contains the key metrics for facilities in California.
| field | type | description |
|---|---|---|
hospital |
string | The name of the hospital |
ccn |
string | The unique indentifier of the hospital. |
week |
date | The week for which hospital data were reported in ISO 8601 format. |
county |
string | The county where the hospitals is located. |
fips |
string | The FIPS code given to the county by the federal government. Can be used to merge with other data sources. |
region |
string | The region of the state where the hospital is located. |
adult_covid_patients_total |
integer | The daily average of adult COVID-19 patients at the hospital over the past seven days. |
pediatric_covid_patients_total |
integer | The daily average of pediatric COVID-19 patients at the hospital over the past seven days. |
covid_patients_total |
integer | The daily average of total COVID-19 patients at the hospital over the past seven days. |
occupied_beds_percent |
integer | The daily average of occupied beds over the past seven days, measured as a percentage of the hospital's total. |
patients_with_covid_percent |
integer | The daily average of beds occupied by COVID-19 patients over the past seven days, measured as a percentage of the hospital's total. |
hhs-hospital-icu-totals.csv
The Department of Health and Human Services releases a weekly update on the number of COVID-19 patients in intensive-care units. This file contains the key metrics for facilities in California.
| field | type | description |
|---|---|---|
hospital |
string | The name of the hospital |
ccn |
string | The unique indentifier of the hospital. |
week |
date | The week for which hospital data were reported in ISO 8601 format. |
county |
string | The county where the hospitals is located. |
fips |
string | The FIPS code given to the county by the federal government. Can be used to merge with other data sources. |
region |
string | The region of the state where the hospital is located. |
covid_icu_patients_total |
integer | The daily average of COVID-19 patients in the adult ICU at the hospital over the past seven days. |
available_adult_icu_beds_total |
integer | The daily average of available adult ICU beds at the hospital over the past seven days. |
occupied_adult_icu_beds_total |
integer | The daily average of occupied adult ICU beds at the hospital over the past seven days. |
staffed_adult_icu_beds_total |
integer | The daily average of staffed adult ICU beds at the hospital over the past seven days. |
occupied_adult_icu_beds_percent |
integer | The daily average of occupied adult ICU beds over the past seven days, measured as a percentage of the hospital's total. |
icu_patients_with_covid_percent |
integer | The daily average of of adult ICU patients with COVID-19 over the past seven days, measured as a percentage of the hospital's total. |
Nursing homes
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 cumulative number of confirmed coronavirus case amoung staff at that time. |
patients_confirmed_cases |
integer | The cumulative 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 amoung staff at that time. |
patients_deaths |
integer | The cumulative number of deaths 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-totals.csv
California's Department of Social Services 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. The source documents are available in the pdf/adult-and-senior-care/ directory of this repository.
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. |
active_cases |
integer | The number of active coronavirus case at that time. |
source_url |
string | The URL to the state data release. |
cdph-skilled-nursing-facilities.csv
California's Department of Social Services is listing the skilled-nursing facilities across the state with COVID-19 outbreaks. The source documents are available in the pdf/adult-and-senior-care/ directory of this repository.
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_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-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 number of active coronavirus case among staff at that time. |
patients_active_cases |
integer | The number of active coronavirus case amoung 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_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. |
source_url |
string | The URL to the state data release. |
cdph-nursing-home-county-totals.csv
The total number of cases and deaths in skilled-nursing facilities, residential care facilities for the elderly and adult residential facilities aggregated by county.
These numbers are calculated by The Times using the facilities lists above. The state chooses not to provide precise numbers at facilities with fewer than 10 cases. When totaling by county, The Times substitutes the minimum value of one. The result is that the tallies are likely an undercount and should be considered the minimum possible value.
| 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. |
minimum_staff_confirmed_cases |
integer | The minimum number of cumulative confirmed coronavirus case amoung staff at that time. |
minimum_patients_confirmed_cases |
integer | The minimum number of cumulative confirmed coronavirus case amoung patients at that time. |
minimum_staff_deaths |
integer | The minimum number of cumulative deaths amoung staff at that time. |
minimum_patients_deaths |
integer | The minimum number of cumulative deaths amoung patients at that time. |
Prisons and jails
cdcr-prison-totals.csv
The cases, resolutions and deaths among inmates at the individual prison facilities operated by the California Department of Corrections and Rehabilitation.
The data is currently limited to July 22, 2020, forward.
| field | type | description |
|---|---|---|
date |
date | The date when the data were collected in ISO 8601 format. |
code |
string | The unique identifier of the prison institution. |
name |
string | The name of the prison institution. |
city |
string | The city where the prison institution is located. |
county |
string | The county where the prison institution is located. |
fips |
string | The FIPS code given to the county by the federal government. Can be used to merge with other data sources. |
zipcode |
string | The ZIP Code where the agency is located. |
x |
float | The longitude of the area's centroid. |
y |
float | The latitude of the area's centroid. |
confirmed_cases |
integer | The cumulative number of confirmed coronavirus case at that time. |
new_confirmed_cases |
integer | The net change in confirmed cases over the previous date. |
deaths |
integer | The cumulative number of deaths at that time. |
new_deaths |
integer | The net change in deaths over the previous date. |
cdcr-state-totals.csv
The total number of cases amoung inmates at prisons run by the California Department of Corrections and Rehabiliation.
| field | type | description |
|---|---|---|
date |
date | The date when the data were collected in ISO 8601 format. |
confirmed_cases |
integer | The cumulative number of confirmed coronavirus case at that time. |
new_confirmed_cases |
integer | The net change in confirmed cases over the previous date. |
Schools
charter-schools-reopening.csv
Number of students with an option to return to individual charter schools calculated from combination of data from California Safe Schools For All and California Department of Education. This file stopped updating in June 2021.
| field | type | description |
|---|---|---|
cdscode |
string | A 14-digit code unique to the charter school. Assigned by California department of Education |
district |
string | Name of school district the charter schools is part of. |
school |
string | Name of the charter school. |
enr_total |
integer | Total students enrolled |
elem_enr |
integer | Total students enrolled in grades K-5. Subset of enr_total. |
middle_enr |
integer | Total students enrolled in grades 6-8. Subset of enr_total. |
high_enr |
integer | Total students enrolled in grades 9-12. Subset of enr_total. |
elem_in_school |
integer | Students in grades K-5 that have the option to participate in an in-person or hybrid learning. |
middle_in_school |
integer | Students in grades 6-8 grades that have the option to participate in an in-person or hybrid learning. |
high_in_school |
integer | Students in grades 9-12 grades that have the option to participate in an in-person or hybrid learning. |
total_in_school |
integer | Sum of elem_in_school,middle_in_school and high_in_school. |
reopening_plan |
string | Link to school's reopening plan. |
operational_status_elem |
string | Operational status as of update_date. |
operational_status_middle |
string | Operational status as of update_date. |
operational_status_high |
string | Operational status as of update_date. |
elem_reopening_date |
date | Planned reopening date as of update date. |
middle_reopening_date |
date | Planned reopening date as of update date. |
high_reopening_date |
date | Planned reopening date as of update date. |
near_term_opening_date |
date | Earliest planned reopening date for the school as of update date. |
update_date |
date | The date when the charter school submitted status report to the state. |
school-districts-reopening.csv
Number of students with an option to return to school districts calculated from combination of data from California Safe Schools For All and California Department of Education. This file stopped updating in June 2021.
| field | type | description |
|---|---|---|
district |
string | Name of public school district. |
enr_total |
integer | Total students enrolled in the district. |
elem_enr |
integer | Total students enrolled in grades K-5. Subset of enr_total. |
middle_enr |
integer | Total students enrolled in grades 6-8. Subset of enr_total. |
high_enr |
integer | Total students enrolled in grades 9-12. Subset of enr_total. |
elem_in_school |
integer | Students in grades K-5 that have the option to participate in an in-person or hybrid learning. |
middle_in_school |
integer | Students in grades 6-8 grades that have the option to participate in an in-person or hybrid learning. |
high_in_school |
integer | Students in grades 9-12 grades that have the option to participate in an in-person or hybrid learning. |
total_in_school |
integer | Sum of elem_in_school,middle_in_school and high_in_school. |
reopening_plan |
string | Link to district's reopening plan. |
operational_status_elem |
string | Operational status as of update_date for the district's elementary schools. |
operational_status_middle |
string | Operational status as of update_date for the district's middle schools. |
operational_status_high |
string | Operational status as of update_date for the district's high schools. |
elem_reopening_date |
date | Planned reopening date for the district's elementary schools as of update date. |
middle_reopening_date |
date | Planned reopening date for the district's middle schools as of update date. |
high_reopening_date |
date | Planned reopening date for the district's high schools as of update date. |
near_term_opening_date |
date | Earliest planned reopening date for the district as of update date. |
update_date |
date | The date when the district submitted status report to the state. |
lausd-cases.csv
The number of coronavirus cases detected at L.A. Unified schools. Updates daily via a scraper that pulls from the district's dashboard.
| field | type | description |
|---|---|---|
school |
string | The name of the school. |
status |
string | Whether the school is open or closed. |
staff_student |
float | The current number of active cases among staff and students. |
transmission |
float | The number of school-linked cases. |
staff_student_rate |
float | The seven-day average of active cases per 100,000 students in this school's community of schools. |
community_rate |
float | The seven-day average of active cases per 100,000 residents in the school's surrounding community. |
lac_rate |
float | The seven-day average of active cases per 100,000 residents in Los Angeles County. |
community_schools |
string | The name of the community of schools that this school belongs to. |
community |
string | The name of the community where the school is located within. |
date |
date | The last updated date listed on the district's dashboard. |
time |
string | The last updated time listed on the district's dashboard. |
Maps
cdph-hpi-zipcodes.csv
California's Department of Public Health has assigned each California ZIP Code a community health score by combining a variety of economic and social indicators. It is known as the Healthy Places Index. The quartile that each ZIP Code falls within was released in response to a request by The Times.
| field | type | description |
|---|---|---|
id |
string | The unique identifer of the ZIP Code. |
hpi_quartile |
integer | The ranked quartile that contains the ZIP Codeโs Healthy Places Index score. One is the lowest. Four is the highest. |
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. |
city |
string | The city the ZIP Code falls within |
latimes-place-polygons.geojson
A map of sub-county areas where cases are tracked.
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 analyzed after being joined to the case counts in the latimes-places-totals.csv using the id column.
This file is a combination of dozens of different data files collected by Times reporters. Some shapes from county officials who maintain their own maps, others were scraped from county dashboards. In some cases, Census maps are used.
In some cases, the precise area being tracked by local officials is unclear. What you will find here is the best effort of Times reporters to represent what's been released. If you see any errors, please contact [email protected].
| 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. |
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. |
centroid_x |
float | The longitude of the place. |
centroid_y |
float | The latitude of the place. |
population |
integer | The number of residents in the area. Not available for all places. |
latimes-zipcode-polygons.geojson
The ZIP Code Tabulation Areas (ZCTAs) used by The Times to map ZIP Code vaccination totals provided by the California Department of Public Health. The map file was acquired from the U.S. Census Bureau. It is limited to areas where vaccination data are available.
| field | type | description |
|---|---|---|
id |
string | The unique identifier of the city, neighborhood or other area. |
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. |
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 |
float | The longitude of the area's centroid. |
centroid_y |
float | The latitude of the area's centroid. |
Other
cdph-press-releases.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.
The Times stopped entering data in August 2021. 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. |
vaccine_doses_administered |
integer | The total number of vaccine doses given out. |
vaccine_doses_distributed |
integer | The total number of vaccine doses available in the state. |
source_url |
string | The URL to the state press release. |
cdph-reopening-metrics.csv
In August 2020, the state introduced a new framework for deciding when and how counties can reopen. Under the regime, each county is assigned to one of four tiers based on a set of metrics developed by state officials.
This file records the metrics released for each county by day. Definition of the benchmarks can be found on the state's website.
| field | type | description |
|---|---|---|
date |
date | The date when the data were collected 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. |
percapita_case_rate |
float | The number of new cases in a recent seven-day period โ excluding cases at prisons and jails โ adjusted for population and multiplied by 100,000. |
adjusted_case_rate |
float | The percapita_case_rate adjusted to account for the volume of testing in the area. Not done for all counties. |
positivity_rate |
float | The percentage of tests for the virus that come back positive in a recent seven-day period. |
equity_metric |
float | An index measuring disparities in disadvantaged neighborhoods compared to the county overall. Many small counties are exempted. Added Oct. 6, 2020 |
cdph-reopening-tiers.csv
In August 2020, the state introduced a new framework for deciding when and how counties can reopen. Under the regime, each county is assigned to one of four tiers based on a set of metrics developed by state officials.
This file records the current tier of each county by day. The definition for each group can be found on the state's website.
| field | type | description |
|---|---|---|
date |
date | The date when the data were collected 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. |
tier |
integer | The tier the county was classified in on this date. There are four possible values on an ordinal scale with one being the most restrictive and four the least restrictive. |
|
latimes-agency-websites.csv
The 61 local-health agency websites that the Los Angeles Times consults to conduct its survey.
| field | type | description |
|---|---|---|
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. |
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-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. |
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-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. |
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]