COVID cases and deaths for LA County and California State. Updated daily.

Data source: Johns Hopkins University (https://coronavirus.jhu.edu/us-map), Johns Hopkins GitHub (https://github.com/CSSEGISandData/COVID-19/blob/master/csse_covid_19_data/csse_covid_19_time_series/time_series_covid19_confirmed_US.csv). Code available: https://github.com/CityOfLosAngeles/covid19-indicators.

The Mayor’s Office utilizes the most recent data to inform decisions about COVID-19 response and policies. The Los Angeles COVID-19 Neighborhood Map visualizes the cases and deaths across 139 neighborhoods in the city. It includes the same data used by the office to spot changes in infection trends in the city, and identify areas where testing resources should be deployed.Data Source:Data are provided on a weekly basis by the LA County Department of Public Health and prepared by the LA Mayor's Office Innovation Team. The data included in this map are on a one-week lag. That means the data shown here are reporting statistics gathered from one week ago. This map will be updated weekly on Mondays. Click on the maps to zoom in, get more details, and see the legends.

Predict the risk score for each county in LA, California

The data is for the 2020 COVID-19 Computational Challenge hosted by the City of Los Angeles in partnership with the Global Association for Research Methods and Data Science (RMDS Lab). The data gathered from different sources like NYT open data GitHub repository.

Data sources

The data collected from: - NYtimes repo on Github. https://github.com/nytimes/covid-19-data) - CHHC open data portal -Asthma by age per county### Predict the risk score for each county in LA, California

The data needs cleaning and processing!

Analysis of ‘LA County COVID Cases’ provided by Analyst-2 (analyst-2.ai), based on source dataset retrieved from https://catalog.data.gov/dataset/4b60c364-d928-4f7b-9e93-aac6525736cd on 27 January 2022.

--- Dataset description provided by original source is as follows ---

COVID cases and deaths for LA County and California State. Updated daily.

Data source: Johns Hopkins University (https://coronavirus.jhu.edu/us-map), Johns Hopkins GitHub (https://github.com/CSSEGISandData/COVID-19/blob/master/csse_covid_19_data/csse_covid_19_time_series/time_series_covid19_confirmed_US.csv). Code available: https://github.com/CityOfLosAngeles/covid19-indicators.

--- Original source retains full ownership of the source dataset ---

Context

As an Angeleno passionate about statistics and data, I volunteered to work with the City of Los Angeles on a data science project focused on Covid-19 cases throughout the Los Angeles county. The focus of that project involved web scraping Covid-19 cases released by the County of Los Angeles Public Health. At the time of this project and to my knowledge still, an API has not been built to easily retrieve this data. I've built the web scraping code and have stored this data locally. To make your life easier, I'm sharing here. Enjoy!

Content

Data spans September 19, 2020 through the previous day (For updated continued data feed, please use the repo code). The data in published daily in the evenings by LA Public Health and contains data through the most recent complete date, so it's always 1 day behind. The cases and deaths data is a cumulated count for each point of interest for the given day. Folders after and including January 4, 2021 contain that day's published data, folders before this date contain data for the previous day.

For more details on how the raw data was gathered, visit the direct source @ City of Los Angeles Public Health

Details

Checkout the folder called "Example for Descriptions". It includes details about each csv file contained in each folder.

*****PLEASE NOTE: THIS SERVICE IS NOT CONSIDERED AUTHORITATIVE*****For authoritative case and death counts please see the data in the Department of Public Health's LA County COVID-19 Surveillance Dashboarddashboard.publichealth.lacounty.gov/covid19_surveillance_dashboard/Several tables of the data are made available to download, including the current daily count, by selecting a table from the menu on the left side of the dashboard and clicking the "Download his table" button at the top of the table's page.*********************************************************************************This is the hosted feature layer VIEW for Historic case counts that is being updated from the SDE data source through automated scripting.Additionally, this feature layer contains the Accumulated Cases and Death counts. To just view the accumulated totals, apply a filter for Community = County of Los Angeles.The script runs daily at 8pm and finishes around 8:15pm.This view layer replaces the older version. Please update your data source for historic or accumulated COVID-19 cases with this feature layer and remove the older version from your webmaps and applications. Please contact the GIS Unit with questions at gis@ceooem.lacounty.gov.

The New York Times is releasing a series of data files with cumulative counts of coronavirus cases in the United States, at the state and county level, over time. We are compiling this time series data from state and local governments and health departments in an attempt to provide a complete record of the ongoing outbreak.

Since late January, The Times has tracked cases of coronavirus in real time as they were identified after testing. Because of the widespread shortage of testing, however, the data is necessarily limited in the picture it presents of the outbreak.

We have used this data to power our maps and reporting tracking the outbreak, and it is now being made available to the public in response to requests from researchers, scientists and government officials who would like access to the data to better understand the outbreak.

The data begins with the first reported coronavirus case in Washington State on Jan. 21, 2020. We will publish regular updates to the data in this repository.

Reporting of Aggregate Case and Death Count data was discontinued May 11, 2023, with the expiration of the COVID-19 public health emergency declaration. This dataset will receive a final update on June 1, 2023, to reconcile historical data through May 10, 2023, and will remain publicly available.

This archived public use dataset contains historical case and percent positivity data updated weekly for all available counties and jurisdictions. Each week, the dataset was refreshed to capture any historical updates. Please note, percent positivity data may be incomplete for the most recent time period.

Related data CDC provides the public with two active versions of COVID-19 county-level community transmission level data: this dataset with historical case and percent positivity data for each county from January 22, 2020 (Weekly Historical Changes dataset) and a dataset with the levels as originally posted (Weekly Originally Posted dataset) since October 20, 2022. Please navigate to the Weekly Originally Posted dataset for the Community Transmission Levels published weekly on Thursdays.

Methods for calculating county level of community transmission indicator The County Level of Community Transmission indicator uses two metrics: (1) total new COVID-19 cases per 100,000 persons in the last 7 days and (2) percentage of positive SARS-CoV-2 diagnostic nucleic acid amplification tests (NAAT) in the last 7 days. For each of these metrics, CDC classifies transmission values as low, moderate, substantial, or high (below and here). If the values for each of these two metrics differ (e.g., one indicates moderate and the other low), then the higher of the two should be used for decision-making.

CDC core metrics of and thresholds for community transmission levels of SARS-CoV-2 Total New Case Rate Metric: "New cases per 100,000 persons in the past 7 days" is calculated by adding the number of new cases in the county (or other administrative level) in the last 7 days divided by the population in the county (or other administrative level) and multiplying by 100,000. "New cases per 100,000 persons in the past 7 days" is considered to have transmission level of Low (0-9.99); Moderate (10.00-49.99); Substantial (50.00-99.99); and High (greater than or equal to 100.00).

Test Percent Positivity Metric: "Percentage of positive NAAT in the past 7 days" is calculated by dividing the number of positive tests in the county (or other administrative level) during the last 7 days by the total number of tests resulted over the last 7 days. "Percentage of positive NAAT in the past 7 days" is considered to have transmission level of Low (less than 5.00); Moderate (5.00-7.99); Substantial (8.00-9.99); and High (greater than or equal to 10.00).

The data in this dataset are considered provisional by CDC and are subject to change until the data are reconciled and verified with the state and territorial data providers.

This dataset is created using CDC’s Policy on Public Health Research and Nonresearch Data Management and Access.

Archived data CDC has archived two prior versions of these datasets. Both versions contain the same 7 data elements reflecting community transmission levels for all available counties and jurisdictions; however, the datasets updated daily. The archived datasets can be found here:

Archived Originally Posted dataset

Archived Historical Changes dataset

Archived Data Notes:

October 27, 2022: Due to a processing issue this dataset will not be posted this week. CDC is currently working to address the issue and will publish the data when able.

November 10, 2022: As of 11/10/2022, this dataset will continue to incorporate historical updates made to case and percent positivity data; however, community transmission level will only be published in the corresponding Weekly COVID-19 County Level of Community Transmission as Originally Posted dataset (Weekly Originally Posted dataset).

Note:

October 20, 2022: Due to a data reporting error, the case rate for Philadelphia County, Pennsylvania is lower than expected in the COVID-19 Community Transmission Level data released on October 20, 2022. This could lead to the COVID-19 Community Transmission Level for Philadelphia County being underestimated; therefore, it should be interpreted with caution.

November 3, 2022: Due to a reporting cadence issue, case rates for Missouri counties are calculated based on 11 days’ worth of case count data in the COVID-19 Community Transmission Level data released on November 3, 2022, instead of the customary 7 days’ worth of data. This could lead to the COVID-19 Community Transmission Levels metrics for Missouri counties being overestimated; therefore, they should be interpreted with caution.

November 10, 2022: Due to a reporting cadence change, case rates for Alabama counties are calculated based on 13 days’ worth of case count data in the COVID-19 Community Transmission Level data released on November 10, 2022, instead of the customary 7 days’ worth of data. This could lead to the COVID-19 Community Transmission Levels metrics for Alabama counties being overestimated; therefore, they should be interpreted with caution.

November 10, 2022: Per the request of the jurisdiction, cases among non-residents have been removed from all Hawaii county totals throughout the entire time series. Cumulative case counts reported by CDC will no longer match Hawaii’s COVID-19 Dashboard, which still includes non-resident cases. 

November 10, 2022: In the COVID-19 Community Transmission Level data released on November 10, 2022, multiple municipalities in Puerto Rico are reporting higher than expected increases in case counts. CDC is working with territory officials to verify the data submitted. 

December 1, 2022: Due to cadence changes over the Thanksgiving holiday, case rates for all Ohio counties are reported as 0 in the COVID-19 Community Transmission Level data released on December 1, 2022. Therefore, the COVID-19 Community Transmission Levels may be underestimated and should be interpreted with caution. 

December 22, 2022: Due to an internal revision process, case rates for some Tennessee counties may appear higher than expected in the December 22, 2022, weekly release. Therefore, the COVID-19 Community Transmission Levels metrics for some Tennessee counties may be overestimated and should be interpreted with caution.

December 22, 2022: Due to reporting of a backlog of historic COVID-19 cases, case rates for some Louisiana counties will appear higher than expected in the December 22, 2022, weekly release. Therefore, the COVID-19 Community Transmission Levels metrics for some Louisiana counties may be overestimated and should be interpreted with caution.

December 29, 2022: Due to technical difficulties, county data from Alabama could not be incorporated via standard practices. As a result, case and death metrics will be reported as 0 in the December 29, 2022, weekly release. Therefore, the COVID-19 Community Transmission Levels metrics for Alabama counties will be underestimated and should be interpreted with caution.

January 5, 2023: Due to a reporting cadence issue, case rates for all Alabama counties will be calculated based on 14 days’ worth of case count data in the COVID-19 Community Transmission Level information released on January 5, 2023, instead of the customary 7 days’ worth of case count data. Therefore, the weekly case rates will be overestimated, which could affect counties’ COVID-19 Community Transmission Level classification and should be interpreted with caution.

January 5, 2023: Due to North Carolina’s holiday reporting cadence, aggregate case data will contain 14 days’ worth of data instead of the customary 7 days. As a result, case metrics will appear higher than expected in the January 5, 2023, weekly release. COVID-19 Community Transmission metrics may be overestimated and should be interpreted with caution.

January 12, 2023: Due to data processing delays, Mississippi’s aggregate case data will be reported as 0. As a result, case metrics will appear lower than expected in the January 12, 2023, weekly release. COVID-19 Community Transmission metrics may be underestimated and should be interpreted with caution. 

January 13, 2023: Aggregate case data released for Los Angeles County, California for the week of December 22nd, 2022, and December 29th, 2022, have been corrected for a data processing error.

January 19, 2023: Due to a reporting cadence issue, Mississippi’s aggregate case data will be calculated based on 14 days’ worth of data instead of the customary 7 days in the January 19, 2023, weekly release. Therefore, COVID-19 Community Transmission metrics may be overestimated and should be interpreted with caution.

January 26, 2023: Due to a reporting backlog of historic COVID-19 cases, case rates for two Michigan counties

The dataset compiles COVID-19 cases, deaths, hospitalizations, tests and vaccination data for Los Angeles county and city from multiple sources in a frequently updated pdf format. It also contains Monkeypox case and vaccination data since August 2022.

The counties of Trousdale and Lake – both in Tennessee – had the highest COVID-19 infection rates in the United States as of June 9, 2020. Dakota, Nobles, and Lincoln also ranked among the U.S. counties with the highest number of coronavirus cases per 100,000 people.

Coronavirus hits the East Coast In the United States, the novel coronavirus had infected around 5.4 million people and had caused nearly 170,000 deaths by mid-August 2020. The densely populated states of New York and New Jersey were at the epicenter of the outbreak in the country. New York City, which is composed of five counties, was one of the most severely impacted regions. However, the true level of transmission is likely to be much higher because many people will be asymptomatic or suffer only mild symptoms that are not diagnosed.

All states are in crisis The first coronavirus case in the U.S. was confirmed in the state of Washington in mid-January 2020. At the time, it was unclear how the virus was spreading; we now know that close contact with an infected person and breathing in their respiratory droplets is the primary mode of transmission. It is no surprise that the four states with the most coronavirus cases are those with the highest populations: New York, Texas, Florida, and California. However, Louisiana was the state with the highest COVID-19 infection rate per 100,000 people as of August 24, 2020.

Note: On April 30, 2024, the Federal mandate for COVID-19 and influenza associated hospitalization data to be reported to CDC’s National Healthcare Safety Network (NHSN) expired. Hospitalization data beyond April 30, 2024, will not be updated on the Open Data Portal. Hospitalization and ICU admission data collected from summer 2020 to May 10, 2023, are sourced from the California Hospital Association (CHA) Survey. Data collected on or after May 11, 2023, are sourced from CDC's National Healthcare Safety Network (NHSN).

Data is from the California Department of Public Health (CDPH) Respiratory Virus State Dashboard at https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/Respiratory-Viruses/RespiratoryDashboard.aspx.

Data are updated each Friday around 2 pm.

For COVID-19 death data: As of January 1, 2023, data was sourced from the California Department of Public Health, California Comprehensive Death File (Dynamic), 2023–Present. Prior to January 1, 2023, death data was sourced from the COVID-19 case registry. The change in data source occurred in July 2023 and was applied retroactively to all 2023 data to provide a consistent source of death data for the year of 2023. Influenza death data was sourced from the California Department of Public Health, California Comprehensive Death File (Dynamic), 2020–Present.

COVID-19 testing data represent data received by CDPH through electronic laboratory reporting of test results for COVID-19 among residents of California. Testing date is the date the test was administered, and tests have a 1-day lag (except for the Los Angeles County, which has an additional 7-day lag). Influenza testing data represent data received by CDPH from clinical sentinel laboratories in California. These laboratories report the aggregate number of laboratory-confirmed influenza virus detections and total tests performed on a weekly basis. These data do not represent all influenza testing occurring in California and are available only at the state level.

Covid-19 cases per country snapshot

13-Apr-2020 at 14:19 CET

Data source: https://www.worldometers.info/coronavirus/

Obtained by web-scraping

Contains header on 1st row.

Columns:

• Index: Number, not used
• Country: PK, text, unique identifier for Country
• Total Cases: Int, total cases per country.
• New Cases (Nuevos casos): Int, difference between cases from one day to the other.
• Total Deaths: Int, total deaths per country.
• New Deaths: Int, difference between deaths from one day to the other.
• Total Recovered: Int, total recovered cases per country.
• Active Cases: Int, total active cases per country.
• Serious, Critical: Int, total seriuos or critical cases per country.
• Tot Cases/1M pop: Float, number of deaths per 1M population
• Tot Deaths/1M pop: Float, number of deaths per 1M population

In Los Angeles County, methamphetamine accounted for the highest share of overdose deaths among people experiencing homelessness (PEH) in the 12 months before and after the COVID-19 pandemic onset, contributing to approximately three-quarters of all overdose deaths in both years. Fentanyl ranked as the second leading cause of overdose death in both periods, but showed the largest increase in its contribution over the analyzed timeframe. This statistic depicts the percentage of deaths among people experiencing homelessness by overdose pre- and post-COVID-19 pandemic in Los Angeles County, by drug type.

The COVID Tracking Project collects information from 50 US states, the District of Columbia, and 5 other US territories to provide the most comprehensive testing data we can collect for the novel coronavirus, SARS-CoV-2. We attempt to include positive and negative results, pending tests, and total people tested for each state or district currently reporting that data.

Testing is a crucial part of any public health response, and sharing test data is essential to understanding this outbreak. The CDC is currently not publishing complete testing data, so we’re doing our best to collect it from each state and provide it to the public. The information is patchy and inconsistent, so we’re being transparent about what we find and how we handle it—the spreadsheet includes our live comments about changing data and how we’re working with incomplete information.

From here, you can also learn about our methodology, see who makes this, and find out what information states provide and how we handle it.

Data on daily COVID-19 confirmed cases, hospitalised people (both in conventional and intensive care units), and deaths, for Andalucía region in southern Spain, at the scale of both provinces and municipalities. Data cover the period from the very start of the pandemic (26 February 2020) up to 4 April 2022. The data were captured daily by Francisco Rodríguez-Sánchez from the official website of Junta de Andalucía (wayback machine capture from 1 February 2022 here). Note the official data were often changed retrospectively by the government as numbers were revised continuously. The full history of changes of both datasets can be checked at this GitHub repository: https://github.com/Pakillo/COVID19-Andalucia. There you can also get the R code used to analyse those data, which were visualised in an online daily report here: https://pakillo.github.io/COVID19-Andalucia/evolucion-coronavirus-andalucia.html.

The number of COVID-19 cases per 100 thousand population in Spain was highest in Navarre. As of March 29, 2022, over 35 thousand infections per 100 thousand population had been recorded in the region. Catalonia, one of the Spanish communities with the highest number of cases reported around 31 thousand infections per 100 thousand people.

The outbreak in Spain Since Spain confirmed its first COVID-19 case in La Gomera, Canary Islands, authorities have reported more than 102 thousand deaths as a result of complications stemming from the disease, with Catalonia accounting for the largest amount. As of March 30, 2022, around 11.55 million cases had been recorded in the European country.

Immunization in Spain As of March 23, 2022, around 88 percent of the population in Spain had received at least one dose of a vaccine against COVID-19. Moreover, approximately 86 percent were already fully vaccinated and close to 52 percent had received a booster. By December 20, 2021 the number of pre-ordered doses of COVID-19 vaccines in the country amounted to 264 million, more than half of which were produced by Pfizer/BioNTech.

For further information about the coronavirus (COVID-19) pandemic, please visit our dedicated Facts and Figures page.

Data is updated at 14:00pm daily further notes and guidance is available in the dashboard under the 'Acknowledgements' section. The following items are included in the Scottish Covid Cases and Deaths dashboard: Spatial Layers NHSBoardcasesThis displays total cumulative COVID 19 cases by NHS Board as proportional symbols. Boundaries are based on 2019 NHS Board definitions. LocalAuthoritycasesThis displays total cumulative COVID 19 cases by Local Authority as proportional symbols. Boundaries are based on 2019 Local Authority definitions. Tablestotal_cases_by_hb.csvThis displays cumulative positive COVID 19 cases by 9-digit Scottish Government code and name (2019 version) for NHS Board areas. total_cases_by_la.csvThis displays cumulative positive COVID 19 cases by 9-digit Scottish Government code and name (2019 version) for Local Authority areas. daily_and_cumulative_counts.csvThis displays daily and cumulative positive COVID 19 cases at Scotland level. It also reports daily on cumulative hospital deaths.

The Mayor’s Office utilizes the most recent data to inform decisions about COVID-19 response and policies. The Los Angeles COVID-19 Neighborhood Map visualizes the cases and deaths across 139 neighborhoods in the city. It includes the same data used by the office to spot changes in infection trends in the city, and identify areas where testing resources should be deployed.Data Source:Data are provided on a weekly basis by the LA County Department of Public Health and prepared by the LA Mayor's Office Innovation Team. The data included in this map are on a one-week lag. That means the data shown here are reporting statistics gathered from one week ago. This map will be updated weekly on Mondays. Click on the maps to zoom in, get more details, and see the legends.

Spain MSCBS: COVID-19: Number of Cases: To Date: CC: Castile La Mancha data was reported at 19,286.000 Person in 26 Apr 2020. This records an increase from the previous number of 18,995.000 Person for 25 Apr 2020. Spain MSCBS: COVID-19: Number of Cases: To Date: CC: Castile La Mancha data is updated daily, averaging 10,839.500 Person from Mar 2020 (Median) to 26 Apr 2020, with 42 observations. The data reached an all-time high of 19,286.000 Person in 26 Apr 2020 and a record low of 567.000 Person in 16 Mar 2020. Spain MSCBS: COVID-19: Number of Cases: To Date: CC: Castile La Mancha data remains active status in CEIC and is reported by Ministry of Health, Consumer Affairs and Social Welfare. The data is categorized under High Frequency Database’s Disease Outbreaks – Table ES.D001: Ministry of Health, Consumer Affairs and Social Welfare: Coronavirus Disease 2019 (COVID-2019) (Discontinued). Ministry of Health, Consumer Affairs and Social Welfare of Spain has changed its criteria for reporting the total number of confirmed COVID-19 cases. Until 26 April 2020 the total number of cases and its derivatives by areas include those with positive polymerase chain reaction (PCR) test results and with positive tests for antibodies (TestAc+). As of this date the replacement series and its derivatives by areas include only cases confirmed by PCR test results. 2. Replacement series ID: 449481427

Cet ensemble de données compile les données sur les cas confirmés de nouveau coronavirus 2019 (COVID-19) en Ontario communiquées par les bureaux de santé publique. Apprenez comment le gouvernement de l'Ontario contribue à la sécurité des Ontariens pendant l’épidémie du nouveau coronavirus 2019 en Ontario. Les données comprennent : * date d’apparition approximative; * groupe d’âge; * sexe du patient; * information sur le mode d’exposition; * résultat pour le patient; * bureau de santé publique (BSP) source; * code postal, site Web, longitude et latitude du BSP. Cet ensemble de données pourrait changer. Veuillez consulter rapport quotidien sur l’état des cas en Ontario pour vous renseigner sur les variables, la méthodologie et les considérations techniques. ##Notes supplémentaires Ces données ne sont plus disponibles sur cette page. Des informations sur la COVID-19 et d’autres virus respiratoires sont disponibles via l’outil « Ontario Respiratory Virus Tool » de Santé publique Ontario. Le 30 novembre 2023, le nombre de décès dus à la COVID-19 a été mis à jour afin d’inclure les décès manquants du 15 janvier 2020 au 31 mars 2023. Cela a un impact sur les données saisies dans la colonne « Résultat 1 ». En raison de changements relatifs à la disponibilité des données, les variables qui suivent seront retirées de ce dossier à compter du jeudi 13 avril 2023 : “Case_AcquisitionInfo”, “Outbreak_Related”. Également en raison de changements relatifs à la disponibilité des données, la variable “Outcome1” équivaudra à “Fatal” (décès causés par la COVID-19) ou à une valeur vide (tous les autres cas).  La méthodologie utilisée pour compter les décès liés à la COVID-19 a changé afin d’exclure les décès non causés par la COVID. Cela a un impact sur les données saisies dans la colonne « Résultat 1 » pour les données affichées dans le catalogue à partir du 11 mars 2022. Le Système GCC est un système de déclaration des maladies dynamique, qui permet des mises à jour continues des données saisies précédemment. Par conséquent, les renseignements tirés du système représentent un instantané au moment de leur extraction et peuvent être différents de rapports précédents ou ultérieurs. Les bureaux de santé publique nettoient continuellement les données sur la COVID-19, en corrigeant les cas et les décès manquants ou en trop. Ces corrections peuvent entraîner des pics de données, des chiffres négatifs et des totaux actuels différents des nombres de cas et de décès signalés précédemment. Les tendances observées au fil du temps doivent être interprétées avec prudence pour la période la plus récente en raison des délais de déclaration ou de saisie des données. Sauf indication contraire, les données précédemment déclarées peuvent changer à mesure que les bureaux de santé publique mettent les données à jour. ##Ensemble de données associé * État des cas du COVID-19 en Ontario