1. Home
  2. Covid-19 USA detailed cases

Covid-19 USA detailed cases

Record of the daily case reports with number of confirmed, recovered and death cases by state.

This dataset can be accessed in the following ways

denodo

CDP Data Catalog

SQL Query copied to clipboard

SELECT covid19_usa_county_level_case_details.confirmed AS confirmed, covid19_usa_county_level_case_details.country_code AS country_code, covid19_usa_county_level_case_details.country_name AS country_name, covid19_usa_county_level_case_details.country_population AS country_population, covid19_usa_county_level_case_details.county AS county, covid19_usa_county_level_case_details.deaths AS deaths, covid19_usa_county_level_case_details.id AS id, covid19_usa_county_level_case_details.last_updated AS last_updated, covid19_usa_county_level_case_details.latitude AS latitude, covid19_usa_county_level_case_details.longitude AS longitude, covid19_usa_county_level_case_details.province AS province, covid19_usa_county_level_case_details.recovered AS recovered FROM covid19_usa_county_level_case_details

JDBC

xml

XML

JSON

REST API copied to clipboard

https://dataport.open.denodo.com/server/covid_19_data/rws_covid19_cases_detailed_country_level_information/views/covid19_usa_county_level_case_details?%24count=25

REST

Help with accessing the COVID-19 data in JDBC / REST / JSON / XML

Historical information about all the daily case reports in the USA from Johns Hopkins University with number of confirmed, recovered and death cases by state.
Also include information about the number of tests and hospitalization rate with daily updates.

idlast_updatedcountry_namecountry_codecountry_populationprovincecountylatitudelongitudeconfirmeddeathsrecoveredlinks
02020-08-02United States of AmericaUS327167434CaliforniaLos Angeles34.05349-118.2453219085746690
12020-08-02United States of AmericaUS327167434CaliforniaRiverside33.98171-117.37404370116950
22020-08-02United States of AmericaUS327167434CaliforniaOrange33.78787-117.85071368336490
32020-08-02United States of AmericaUS327167434CaliforniaSan Bernardino34.10524-117.29412326964170
42020-08-02United States of AmericaUS327167434CaliforniaSan Diego32.71568-117.16171295775650
52020-08-02United States of AmericaUS327167434CaliforniaKern35.34281638-118.7299395198821440
62020-08-02United States of AmericaUS327167434CaliforniaFresno36.74084-119.78552150831380
72020-08-02United States of AmericaUS327167434CaliforniaAlameda37.76683-122.2453114841890
82020-08-02United States of AmericaUS327167434CaliforniaSan Joaquin37.93479557-121.2713112114831680
92020-08-02United States of AmericaUS327167434CaliforniaSanta Clara37.35579-121.95509103211910
102020-08-02United States of AmericaUS327167434CaliforniaSacramento38.57944-121.49085100161420
112020-08-02United States of AmericaUS327167434CaliforniaTulare36.20649-119.3430594541780
122020-08-02United States of AmericaUS327167434CaliforniaImperial32.84748-115.5695294092200
132020-08-02United States of AmericaUS327167434CaliforniaStanislaus37.55932622-120.997661990611100
142020-08-02United States of AmericaUS327167434CaliforniaContra Costa37.91793732-121.925935478061210
152020-08-02United States of AmericaUS327167434CaliforniaVentura34.28082-119.292327344760
162020-08-02United States of AmericaUS327167434CaliforniaSan Francisco37.77712-122.419646811610
172020-08-02United States of AmericaUS327167434CaliforniaSanta Barbara34.41938-119.699056167600
182020-08-02United States of AmericaUS327167434CaliforniaSan Mateo37.54704-122.3148555441190
192020-08-02United States of AmericaUS327167434CaliforniaMarin38.07188727-122.71953484994700
202020-08-02United States of AmericaUS327167434CaliforniaMonterey36.21714603-121.23901964797300
212020-08-02United States of AmericaUS327167434CaliforniaKings36.07543071-119.81535414380560
222020-08-02United States of AmericaUS327167434CaliforniaMerced37.19187429-120.7177394285500
232020-08-02United States of AmericaUS327167434CaliforniaSolano38.27793363-121.92724053611370
242020-08-02United States of AmericaUS327167434CaliforniaSonoma38.29188-122.457283055370
Last refresh time: 2020-08-01 03:21:04
Refresh frequency: Daily
Source: JHU

What's Next?

Gain real-time insights from your data and begin
your digital transformation today!
Get Started
US COVID-19 deathsUS Coronavirus incidenceUS covid-19 report