COVID-19 US Daily Data

Free
National Statistics
tick

Daily Data

tick

Updated Daily

tick

> Apr 2020

tick

All US States

tick

United States

Summary

State level daily COVID-19 data for United States, provided by Johns Hopkins University (JHU) Center for Systems Science and Engineering (CSSE)

This is a sample visualization of a small subset of this data product.
Loading...
Charts of COVID-19 US Daily Data

Key Features

  • Coronavirus Pandemic (COVID-19) data since April 2020
  • Daily updated data at states level for United States
  • US Census Bureau Data for July 2019 Population Estimates

Documentation

Applications

  • Trend analysis on the COVID-19 pandemic
  • Complimentary data set for economical indicators

Overview

In this data product, you may find the latest and historical daily data on the COVID-19 pandemic for United States with the states level breakdown.

The COVID‑19 pandemic, also known as the coronavirus pandemic, is an ongoing global pandemic of coronavirus disease 2019 (COVID‑19), caused by severe acute respiratory syndrome coronavirus 2 (SARS‑CoV‑2). The outbreak was first identified in December 2019 in Wuhan, China. The World Health Organization declared the outbreak a Public Health Emergency of International Concern on 30 January 2020 and a pandemic on 11 March. As of 12 August 2020, more than 20.2 million cases of COVID‑19 have been reported in more than 188 countries and territories, resulting in more than 741,000 deaths; more than 12.5 million people have recovered.

The Johns Hopkins Coronavirus Resource Center is a continuously updated source of COVID-19 data and expert guidance. They aggregate and analyze the best data available on COVID-19 - including cases, as well as testing, contact tracing and vaccine efforts - to help the public, policymakers and healthcare professionals worldwide respond to the pandemic.

Methodology

  • Cases and Death counts include confirmed and probable (where reported)
  • Recovered cases are estimates based on local media reports, and state and local reporting when available, and therefore may be substantially lower than the true number. US state-level recovered cases are from COVID Tracking Project.
  • Active cases = total cases - total recovered - total deaths
  • Incidence Rate = cases per 100 000 people
  • Case-Fatality Ratio (%) = Number recorded deaths / Number cases
  • US Testing Rate = total test results per 100 000 people. The "total test results" are equal to "Total test results (Positive + Negative)" from COVID Tracking Project.
  • States Population data is retrieved from U.S. Census Bureau on top of the JHU CSSE's COVID-19 data

Data Update Frequency:

Date Change
Before April 22 once per day around 23:59 UTC
After April 23 once per day between 03:30 and 04:00 UTC
Since June 15 once per day between 04:45 and 05:15 UTC

Data source:

Suggested Blog Posts

Dictionary

Filter
Column
Title
Data Type
Description
reported_dateReported DateDateCOVID-19 Report Date
province_stateProvince StateTextState name
populationPopulationIntEstimated state populations as of July 2019, as per U.S. Census Bureau Population Division
latLatitudeFloatDot locations latitude, not representative of a specific address
lngLongitudeFloatDot locations longitude, not representative of a specific address
confirmedTotal Confirmed CasesFloatTotal confirmed cases, including presumptive positive cases and probable cases
prev_confirmed_1dTotal Confirmed Cases - Previous DayFloatTotal confirmed cases as of one day prior to the reported date
new_confirmedNew Confirmed CasesFloatDaily new confirmed cases; the delta between the total cases as of the reported date and the previous day
peak_confirmed_1d_flagConfirmed Cases PeakBooleanTrue/False flag, indicating if confirmed cases have reached to the peak value for the given date and state, since the day-1 of the pandemic
activeTotal Active CasesFloatTotal active cases = total confirmed - total recovered - total deaths
deathsTotal DeathsFloatTotal death cases counts
prev_deaths_1dTotal Deaths - Previous DayFloatTotal deaths as of one day prior to the reported date
new_deathsNew DeathsFloatDaily new deaths; the delta between the deaths as of the reported date and the previous day
most_deaths_1d_flagDeaths PeakBooleanTrue/False flag, indicating if deaths have reached to the peak value for the given date and state, since the day-1 of the pandemic
recoveredRecovered CasesFloatTotal recovered cases counts
incidence_rateIncidence RateFloatIncidence Rate = cases per 100 000 people
mortality_rateMortality RateFloatNumber recorded deaths * 100 / Number confirmed cases
people_testedPeople TestedFloatTotal number of people who have been tested
testing_rateTesting RateFloatTotal number of people tested per 100 000 people

Sample Data

API

ALTADATA provides a powerfull API, compatible with JSON, CSV formats. You can connect, update and analyze our data products with cURL, Python, R, Ruby, Java or Javascript

Authentication

Getting an API key

You need to subscribe to an ALTADATA data product to get an API key. Once you subscribe to the data product you can find your API key on your Account Dashboard.

Auhenticating your requests

`api_key` is your access token. This token must be included on each API call with either a HTTP Header Authorization, or a query parameter api_key.

Example: https://www.altadata.io/data/api/co_10_jhucs_03?api_key=YOUR_API_KEY

ALTADATA API Reference Table

Parameter Type Parameter Explanation Available Values Default
General size The number of records will be returned for each page. 5 - 100 20
General page The page number. It starts at 1 and increments one by one. Each page returns records that row count equals to the size parameter 1- ... 1
General format The data return format of API call json , csv json
General collapse The aggregation format of API call Examples are monthly, yearly, bystate, bycountry, etc. Refer to the data product documentation to see available aggregations for it. null
Select columns Column select is how you specify the content of an SQL SELECT c_only, c_certain, c_columns FROM clause. More detail is in the following sections. *
Order order_by Column order is how you specify the content of an SQL ORDER BY clause. More detail is in the following sections. null
Lookup vary by column name Column lookups are how you specify the content of an SQL WHERE clause. More detail is in the following sections. *

Select

Column select is how you specify the content of an SQL SELECT c_only, c_certain, c_columns FROM clause. It specifies as a keyword argument to the query string of API Call URL. Basic usage is a comma-separated list of column names. If not given, the default value is *(asterisk).

Example 1 :

Query : ?columns=C1,C2,C3 SQL Equivalent : Select C1,C2,C3 from DATA_PRODUCT

Example 2 :

Query : Not Given | ?columns= | ?columns=* SQL Equivalent : Select * from DATA_PRODUCT

Order

Column order is how you specify the content of an SQL ORDER BY clause. It specifies as a keyword argument to the query string of API Call URL. Basic usage is a comma-separated list of column names where each column name has an appropriate suffix (asc,desc) after _(underscore) or no suffix (means ascending).

Example :

Query : ?order_by=C1_asc,C2,C3_desc,C4_asc SQL Equivalent : Select * from DATA_PRODUCT order by C1 asc, C2, C4 desc, C4 asc

Order Type Suffix
Ascending null
Ascending asc
Descending desc

Lookup

Column lookups are how you specify the content of an SQL WHERE clause. They’re specifies as keyword arguments to the query string of API Call URL. Basic usage is appending _(underscore) then lookup type as a suffix to name of the column that you want to filter. The query parameter for a column is built like the format {COLUMN_NAME}_{LOOKUP_TYPE}

As a convenience when no lookup type is provided

Lookup Type Suffix Value Type Example SQL Equivalent
Equal to null String | Numeric | Datetime ?COLUMN=VALUE Select * from DATA_PRODUCT where COLUMN=VALUE
Equal to eq String | Numeric | Datetime ?COLUMN_eq=VALUE Select * from DATA_PRODUCT where COLUMN=VALUE
Not Equal to neq String | Numeric | Datetime ?COLUMN_neq=VALUE Select * from DATA_PRODUCT where COLUMN<>VALUE
Greater Than gt Numeric | Datetime ?COLUMN_gt=VALUE Select * from DATA_PRODUCT where COLUMN>VALUE
Greater Than or Equal to gte Numeric | Datetime ?COLUMN_gte=VALUE Select * from DATA_PRODUCT where COLUMN>=VALUE
Less Than lt Numeric | Datetime ?COLUMN_lt=VALUE Select * from DATA_PRODUCT where COLUMN,VALUE
Less Than or Equal to lte Numeric | Datetime ?COLUMN_lte=VALUE Select * from DATA_PRODUCT where COLUMN<=VALUE
In in String ?COLUMN_in=V1,V2,V3 Select * from DATA_PRODUCT where COLUMN in ('V1','V2','V3')
Not In notin String ?COLUMN_notin=V1,V2,V3 Select * from DATA_PRODUCT where COLUMN not in ('V1','V2','V3')

Data Access Examples

cURL
curl \ -H 'Authorization: api_key' \ 'https://www.altadata.io/data/api/co_10_jhucs_03'
Python (requests)
response = requests.get( 'https://www.altadata.io/data/api/co_10_jhucs_03', headers={'Authorization': 'api_key'} )
Ruby (open-uri)
require 'open-uri' response = URI.open('https://www.altadata.io/data/api/co_10_jhucs_03', "Authorization" => "api_key" )
Java (OkHttp)
Request request = new Request.Builder() .url("https://www.altadata.io/data/api/co_10_jhucs_03") .addHeader("Authorization", "api_key") .build(); Call call = client.newCall(request); Response response = call.execute();
Javascript (axios)
axios.request({ url: 'https://www.altadata.io/data/api/co_10_jhucs_03', method: 'get', headers: { 'Authorization', 'api_key'} }) .then(response => { console.log(response.data) })
R ( jsonlite )
library(jsonlite) data <- fromJSON(`https://www.altadata.io/data/api/co_10_jhucs_03`)

Frequently Asked Questions

HOW DO I SUBSCRIBE TO DATA PRODUCTS ON ALTADATA?
DO YOU PROVIDE CUSTOM DATASETS UPON REQUEST?
WHAT ARE THE DIFFERENT WAYS I CAN ACCESS MY SUBSCRIPTION DATA?
HOW CAN I QUICKLY LOOK AT WHAT IS IN THE DATA THAT I SUBSCRIBED TO?
HOW CAN I JOIN ALTADATA PARTNER NETWORK? DO YOU HAVE A LIST OF REQUIREMENTS?