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 the first reported coronavirus case in Washington State on Jan. 21, 2020, 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.

Updates

• Notice of data discontinuation: Since the start of the pandemic, AP has reported case and death counts from data provided by Johns Hopkins University. Johns Hopkins University has announced that they will stop their daily data collection efforts after March 10. As Johns Hopkins stops providing data, the AP will also stop collecting daily numbers for COVID cases and deaths. The HHS and CDC now collect and visualize key metrics for the pandemic. AP advises using those resources when reporting on the pandemic going forward.

  • CDC Weekly case and death counts (national and state level)
  • CDC County level cases and deaths
  • HHS New hospital admissions
  • CDC NowCast COVID variant proportions (national and regional level)

• April 9, 2020

  • The population estimate data for New York County, NY has been updated to include all five New York City counties (Kings County, Queens County, Bronx County, Richmond County and New York County). This has been done to match the Johns Hopkins COVID-19 data, which aggregates counts for the five New York City counties to New York County.

• April 20, 2020

  • Johns Hopkins death totals in the US now include confirmed and probable deaths in accordance with CDC guidelines as of April 14. One significant result of this change was an increase of more than 3,700 deaths in the New York City count. This change will likely result in increases for death counts elsewhere as well. The AP does not alter the Johns Hopkins source data, so probable deaths are included in this dataset as well.

• April 29, 2020

  • The AP is now providing timeseries data for counts of COVID-19 cases and deaths. The raw counts are provided here unaltered, along with a population column with Census ACS-5 estimates and calculated daily case and death rates per 100,000 people. Please read the updated caveats section for more information.

• September 1st, 2020

  • Johns Hopkins is now providing counts for the five New York City counties individually.

• February 12, 2021

  • The Ohio Department of Health recently announced that as many as 4,000 COVID-19 deaths may have been underreported through the state’s reporting system, and that the "daily reported death counts will be high for a two to three-day period."
  • Because deaths data will be anomalous for consecutive days, we have chosen to freeze Ohio's rolling average for daily deaths at the last valid measure until Johns Hopkins is able to back-distribute the data. The raw daily death counts, as reported by Johns Hopkins and including the backlogged death data, will still be present in the new_deaths column.

• February 16, 2021

  - Johns Hopkins has reconciled Ohio's historical deaths data with the state.

  Overview

The AP is using data collected by the Johns Hopkins University Center for Systems Science and Engineering as our source for outbreak caseloads and death counts for the United States and globally.

The Hopkins data is available at the county level in the United States. The AP has paired this data with population figures and county rural/urban designations, and has calculated caseload and death rates per 100,000 people. Be aware that caseloads may reflect the availability of tests -- and the ability to turn around test results quickly -- rather than actual disease spread or true infection rates.

This data is from the Hopkins dashboard that is updated regularly throughout the day. Like all organizations dealing with data, Hopkins is constantly refining and cleaning up their feed, so there may be brief moments where data does not appear correctly. At this link, you’ll find the Hopkins daily data reports, and a clean version of their feed.

The AP is updating this dataset hourly at 45 minutes past the hour.

To learn more about AP's data journalism capabilities for publishers, corporations and financial institutions, go here or email kromano@ap.org.

Queries

Use AP's queries to filter the data or to join to other datasets we've made available to help cover the coronavirus pandemic

• Filter cases by state here

• Rank states by their status as current hotspots. Calculates the 7-day rolling average of new cases per capita in each state: https://data.world/associatedpress/johns-hopkins-coronavirus-case-tracker/workspace/query?queryid=481e82a4-1b2f-41c2-9ea1-d91aa4b3b1ac

• Find recent hotspots within your state by running a query to calculate the 7-day rolling average of new cases by capita in each county: https://data.world/associatedpress/johns-hopkins-coronavirus-case-tracker/workspace/query?queryid=b566f1db-3231-40fe-8099-311909b7b687&showTemplatePreview=true

• Join county-level case data to an earlier dataset released by AP on local hospital capacity here. To find out more about the hospital capacity dataset, see the full details.

• Pull the 100 counties with the highest per-capita confirmed cases here

• Rank all the counties by the highest per-capita rate of new cases in the past 7 days here. Be aware that because this ranks per-capita caseloads, very small counties may rise to the very top, so take into account raw caseload figures as well.

Interactive

The AP has designed an interactive map to track COVID-19 cases reported by Johns Hopkins.

@(https://datawrapper.dwcdn.net/nRyaf/15/)

Interactive Embed Code

<iframe title="USA counties (2018) choropleth map Mapping COVID-19 cases by county" aria-describedby="" id="datawrapper-chart-nRyaf" src="https://datawrapper.dwcdn.net/nRyaf/10/" scrolling="no" frameborder="0" style="width: 0; min-width: 100% !important;" height="400"></iframe><script type="text/javascript">(function() {'use strict';window.addEventListener('message', function(event) {if (typeof event.data['datawrapper-height'] !== 'undefined') {for (var chartId in event.data['datawrapper-height']) {var iframe = document.getElementById('datawrapper-chart-' + chartId) || document.querySelector("iframe[src*='" + chartId + "']");if (!iframe) {continue;}iframe.style.height = event.data['datawrapper-height'][chartId] + 'px';}}});})();</script>

Caveats

• This data represents the number of cases and deaths reported by each state and has been collected by Johns Hopkins from a number of sources cited on their website.
• In some cases, deaths or cases of people who've crossed state lines -- either to receive treatment or because they became sick and couldn't return home while traveling -- are reported in a state they aren't currently in, because of state reporting rules.
• In some states, there are a number of cases not assigned to a specific county -- for those cases, the county name is "unassigned to a single county"
• This data should be credited to Johns Hopkins University's COVID-19 tracking project. The AP is simply making it available here for ease of use for reporters and members.
• Caseloads may reflect the availability of tests -- and the ability to turn around test results quickly -- rather than actual disease spread or true infection rates.
• Population estimates at the county level are drawn from 2014-18 5-year estimates from the American Community Survey.
• The Urban/Rural classification scheme is from the Center for Disease Control and Preventions's National Center for Health Statistics. It puts each county into one of six categories -- from Large Central Metro to Non-Core -- according to population and other characteristics. More details about the classifications can be found here.

Johns Hopkins timeseries data - Johns Hopkins pulls data regularly to update their dashboard. Once a day, around 8pm EDT, Johns Hopkins adds the counts for all areas they cover to the timeseries file. These counts are snapshots of the latest cumulative counts provided by the source on that day. This can lead to inconsistencies if a source updates their historical data for accuracy, either increasing or decreasing the latest cumulative count. - Johns Hopkins periodically edits their historical timeseries data for accuracy. They provide a file documenting all errors in their timeseries files that they have identified and fixed here

Attribution

This data should be credited to Johns Hopkins University COVID-19 tracking project

This dataset tracks the updates made on the dataset "New York State Statewide COVID-19 Testing By Age Group (Archived)" as a repository for previous versions of the data and metadata.

After over two years of public reporting, the State Profile Report will no longer be produced and distributed after February 2023. The final release was on February 23, 2023. We want to thank everyone who contributed to the design, production, and review of this report and we hope that it provided insight into the data trends throughout the COVID-19 pandemic. Data about COVID-19 will continue to be updated at CDC’s COVID Data Tracker.

The State Profile Report (SPR) is generated by the Data Strategy and Execution Workgroup in the Joint Coordination Cell, in collaboration with the White House. It is managed by an interagency team with representatives from multiple agencies and offices (including the United States Department of Health and Human Services (HHS), the Centers for Disease Control and Prevention, the HHS Assistant Secretary for Preparedness and Response, and the Indian Health Service). The SPR provides easily interpretable information on key indicators for each state, down to the county level.

It is a weekly snapshot in time that:

• Focuses on recent outcomes in the last seven days and changes relative to the month prior
• Provides additional contextual information at the county level for each state, and includes national level information
• Supports rapid visual interpretation of results with color thresholds

On December 19, 2022, there were 3,553 new cases of COVID-19 in New York City. The state of New York has been one of the hardest hit U.S. states by the COVID-19 pandemic. This statistic shows the number of new COVID-19 cases in New York City from March 8, 2020 to December 19, 2022, by diagnosis date.

As of December 16, 2022, there had been almost 6.37 million COVID-19 cases in New York State, with 2.97 million cases found in New York City. New York has been one of the U.S. states most impacted by the pandemic, recording the highest number of deaths in the country.

A closer look at the outbreak in New York Towards the middle of December 2022, the number of deaths due to the coronavirus in New York State had reached almost 60 thousand, and almost half of those deaths were in New York City. However, the number of new daily deaths in New York City peaked early in the pandemic and although there have been times when the number of new daily deaths surged, they have not gotten close to reaching the levels seen at the beginning of the pandemic. New York City is made up of five counties, which are more commonly known by their borough names – Staten Island is the borough with the highest rate of COVID-19 cases.

This dataset includes information on the number of positive tests of individuals for COVID-19 infection performed in New York State beginning March 1, 2020, when the first case of COVID-19 was identified in the state. The primary goal of publishing this dataset is to provide users timely information about local disease spread and reporting of positive cases. The data will be updated daily, reflecting tests reported by 12:00 am (midnight) three days prior. Data are published on a three-day lag in order to allow all test results to be reported.

Reporting of SARS-CoV2 laboratory testing results is mandated under Part 2 of the New York State Sanitary Code. Clinical laboratories, as defined in Public Health Law (PHL) § 571 electronically report test results to the New York State Department of Health (DOH) via the Electronic Clinical Laboratory Reporting System (ECLRS). The DOH Division of Epidemiology’s Bureau of Surveillance and Data System (BSDS) monitors ECLRS reporting and ensures that all results are accurate.

Test counts are based on specimen collection date. A person may have multiple specimens tested on one day, these would be counted one time, i.e., if two specimens are collected from an individual at the same time and then evaluated, the outcome of the evaluation of those two samples to diagnose the individual is counted as a single test of one person, even though the specimens may be tested separately. All positive test results that are at least 90 days apart are counted as cases/new positives.

New positive test counts are assigned to a county based on this order of preference: 1) the patient’s address, 2) the ordering healthcare provider/campus address, or 3) the ordering facility/campus address.

Archived versions of the reinfections dataset are also available: First infections - https://health.data.ny.gov/d/xdss-u53e Reinfections - https://health.data.ny.gov/d/7aaj-cdtu

As of December 22, 2022, those aged 18 to 24 years had the highest rates of COVID-19 in New York City. The state of New York has been one of the hardest hit U.S. states by the COVID-19 pandemic. This statistic shows rates of COVID-19 cases in New York City by age group, as of December 22, 2022.

Note: Data elements were retired from HERDS on 10/6/23 and this dataset was archived.

This dataset includes the cumulative number and percent of healthcare facility-reported fatalities for patients with lab-confirmed COVID-19 disease by reporting date and age group. This dataset does not include fatalities related to COVID-19 disease that did not occur at a hospital, nursing home, or adult care facility. The primary goal of publishing this dataset is to provide users with information about healthcare facility fatalities among patients with lab-confirmed COVID-19 disease.

The information in this dataset is also updated daily on the NYS COVID-19 Tracker at https://www.ny.gov/covid-19tracker.

The data source for this dataset is the daily COVID-19 survey through the New York State Department of Health (NYSDOH) Health Electronic Response Data System (HERDS). Hospitals, nursing homes, and adult care facilities are required to complete this survey daily. The information from the survey is used for statewide surveillance, planning, resource allocation, and emergency response activities. Hospitals began reporting for the HERDS COVID-19 survey in March 2020, while Nursing Homes and Adult Care Facilities began reporting in April 2020. It is important to note that fatalities related to COVID-19 disease that occurred prior to the first publication dates are also included.

The fatality numbers in this dataset are calculated by assigning age groups to each patient based on the patient age, then summing the patient fatalities within each age group, as of each reporting date. The statewide total fatality numbers are calculated by summing the number of fatalities across all age groups, by reporting date. The fatality percentages are calculated by dividing the number of fatalities in each age group by the statewide total number of fatalities, by reporting date. The fatality numbers represent the cumulative number of fatalities that have been reported as of each reporting date.

Source

This data comes from the New York Times Coronavirus (Covid-19) Data in the United States GitHub repository. They use it to power their interactive page(s) on Covid-19, such as Coronavirus in the U.S.: Latest Map and Case Count.

What's Included?

The primary data published here are the daily cumulative number of cases and deaths reported in each county and state across the U.S. since the beginning of the pandemic. We have also published these additional data sets:

• Prisons: Cases in prisons
• Colleges: Cases on college and university campuses.
• Excess deaths: The elevated overall number of deaths during the pandemic.
• Mask use: A July 2020 survey of how regularly people in each county wore masks.
• Averages and anomalies: A set of pre-computed rolling averages of cases and deaths for ease of analysis or use in making graphics, along with a set of days with anomalous data that have been excluded from the averages.

The cumulative & rolling averages for cases and deaths are continually updated, but the more specific data mentioned above for prisons, etc. is no longer being updated.

This includes data at the national, state, and county levels.

License and Attribution

If you use this data, you must attribute it to “The New York Times” in any publication. If you would like a more expanded description of the data, you could say “Data from The New York Times, based on reports from state and local health agencies.”

Acknowledgements

Header Image: https://www.pexels.com/photo/n95-face-mask-3993241/

More Information

See the original New York Times source README which is also included in this dataset.

Note: This dataset is no longer being updated as of September 1, 2023. This dataset includes information on the number of tests of individuals for COVID-19 infection by zip code performed in New York State beginning March 1, 2020, when the first case of COVID-19 was identified in the state. The primary goal of publishing this dataset is to provide users timely information about local disease spread and reporting of positive cases. The data will be updated weekly, reflecting tests completed by 2:00 pm on the day prior to the date of the update.

Note: On November 14, 2020, only 14 hours of laboratory data was collected and shared. The 2:00 pm cutoff time was implemented, allowing the NYSDOH to enhance data quality reviews. All other published laboratory data represented 24 hours of data collection. Prior to November 14, 2020 data reflected tests completed by 12:00 am (midnight) the day of the update (i.e., all tests reported by the end of the day on the day before the update).

As of April 4, 2022, the Department of Health and Human Services (HHS) no longer requires entities conducting COVID testing to report negative or indeterminate antigen test results. This may impact the number and interpretation of total test results reported to the state and also impacts calculation of test percent positivity. Total positives continues to include both PCR and antigen positive test results.

In the state of New York, Richmond and Rockland have the highest coronavirus case rates when adjusted for the population of a county. Rockland County had around 1,404 positive cases per 10,000 people as of April 19, 2021.

The five boroughs of NYC With around 894,400 positive infections as of mid-April 2021, New York City has the highest number of coronavirus cases in New York State – this means that there were approximately 1,065 cases per 10,000 people. New York City is composed of five boroughs; each borough is coextensive with a county of New York State. Staten Island is the smallest in terms of population, but it is the borough with the highest rate of COVID-19 cases.

Public warned against complacency The number of new COVID-19 cases in New York City spiked for the second time as the winter holiday season led to an increase in social gatherings. New York State is slowly recovering – indoor dining reopened in February 2021 – but now is not the time for people to become complacent. Despite the positive rollout of vaccines, experts have urged citizens to adhere to guidelines and warned that face masks might have to be worn for at least another year.

Note: This dataset is no longer updated. This dataset includes cumulative and weekly counts of the number of new COVID-19 cases reported, number of cases reached, percent cases reached, total contacts elicited, total elicited contacts reached, and percent contacts reached by each week. Please note: In the earlier days of the program, the number of cases represented the numbers reported by selected LHDs. Therefore, the volume could be much lower than all new COVID cases.

Note: As of November 10, 2023, this dataset has been archived. For the current version of this data, please visit: https://health.data.ny.gov/d/gikn-znjh

This dataset reports daily on the number of people vaccinated by New York providers with at least one dose and with a complete COVID-19 vaccination series overall since December 14, 2020. New York providers include hospitals, mass vaccination sites operated by the State or local governments, pharmacies, and other providers registered with the State to serve as points of distribution.

This dataset is created by the New York State Department of Health from data reported to the New York State Immunization Information System (NYSIIS) and the New York City Citywide Immunization Registry (NYC CIR). County-level vaccination data is based on data reported to NYSIIS and NYC CIR by the providers administering vaccines. Residency is self-reported by the individual being vaccinated. This data does not include vaccine administered through Federal entities or performed outside of New York State to New York residents. NYSIIS and CIR data is used for county-level statistics. New York State Department of Health requires all New York State vaccination providers to report all COVID-19 vaccination administration data to NYSIIS and NYC CIR within 24 hours of administration.

Daily count of NYC residents who tested positive for SARS-CoV-2, who were hospitalized with COVID-19, and deaths among COVID-19 patients. Note that this dataset currently pulls from https://raw.githubusercontent.com/nychealth/coronavirus-data/master/trends/data-by-day.csv on a daily basis.

Of the five boroughs of New York City, Stanten Island has the highest rate of coronavirus cases per 100,000 people. Brooklyn – the most populous borough – has around 36,008 cases per 100,000 people, and only Manhattan has a lower case rate.

Brooklyn hit hard by COVID-19 Towards the middle of December 2022, there had been almost 6.37 million positive infections in New York State, and Kings was the county with the highest number of coronavirus cases. Kings County, which has the same boundaries as the borough of Brooklyn, had also recorded the highest number of deaths due to the coronavirus in New York State. Since the start of the pandemic in the U.S., densely populated neighborhoods in Brooklyn and Queens have been severely affected, and government leaders across New York State have had to find solutions to some unprecedented challenges.

As of March 6, 2021, there have been around 39.7 million tests for COVID-19 in the state of New York, leading to almost 1.7 million positive cases. New York has been one of the hardest hit U.S. states by the COVID-19 pandemic and accounts for a high amount of cases in the U.S. This statistic shows the cumulative number of COVID-19 tests, cases, hospitalizations, and deaths in New York as of March 6, 2021.

As of March 7, 2021, there have been 39,029 deaths due to COVID-19 in the state of New York, with the first 3 deaths reported on March 14, 2020. This statistic shows the cumulative number of deaths related to COVID-19 in New York State from March 14 to March 7, 2021, by day.

As of December 22, 2022, there have been 2.6 million cases of COVID-19 in New York City, as well as 200,189 hospitalizations, and 37,452 deaths. This statistic shows the number of COVID-19 cases, hospitalizations, and deaths in New York City as of December 22, 2022.

On April 7, 2020, there were 598 new deaths due to COVID-19 in New York City, higher than any other day since the pandemic hit the city. The state of New York has been one of the hardest hit U.S. states by the COVID-19 pandemic. This statistic shows the number of new COVID-19 deaths in New York City from March 3, 2020 to December 19, 2022, by date.