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-09-30United States of AmericaUS327167434CaliforniaLos Angeles34.05349-118.2453226939465530
12020-09-30United States of AmericaUS327167434CaliforniaRiverside33.98171-117.374045917312160
22020-09-30United States of AmericaUS327167434CaliforniaSan Bernardino34.10524-117.29412552039550
32020-09-30United States of AmericaUS327167434CaliforniaOrange33.78787-117.850715375112680
42020-09-30United States of AmericaUS327167434CaliforniaSan Diego32.71568-117.16171469857810
52020-09-30United States of AmericaUS327167434CaliforniaKern35.34281638-118.7299395321283700
62020-09-30United States of AmericaUS327167434CaliforniaFresno36.74084-119.78552285173900
72020-09-30United States of AmericaUS327167434CaliforniaSacramento38.57944-121.49085226544200
82020-09-30United States of AmericaUS327167434CaliforniaAlameda37.76683-122.2453220264170
92020-09-30United States of AmericaUS327167434CaliforniaSanta Clara37.35579-121.95509212943180
102020-09-30United States of AmericaUS327167434CaliforniaSan Joaquin37.93479557-121.2713112204114560
112020-09-30United States of AmericaUS327167434CaliforniaContra Costa37.91793732-121.9259354168962090
122020-09-30United States of AmericaUS327167434CaliforniaStanislaus37.55932622-120.9976619164963590
132020-09-30United States of AmericaUS327167434CaliforniaTulare36.20649-119.34305162672630
142020-09-30United States of AmericaUS327167434CaliforniaVentura34.28082-119.29232127071500
152020-09-30United States of AmericaUS327167434CaliforniaImperial32.84748-115.56952119083200
162020-09-30United States of AmericaUS327167434CaliforniaSan Francisco37.77712-122.41964112751040
172020-09-30United States of AmericaUS327167434CaliforniaMonterey36.21714603-121.239019610087730
182020-09-30United States of AmericaUS327167434CaliforniaSan Mateo37.54704-122.3148599901500
192020-09-30United States of AmericaUS327167434CaliforniaSanta Barbara34.41938-119.6990591641130
202020-09-30United States of AmericaUS327167434CaliforniaMerced37.19187429-120.71773989611430
212020-09-30United States of AmericaUS327167434CaliforniaKings36.07543071-119.81535417682810
222020-09-30United States of AmericaUS327167434CaliforniaSonoma38.29188-122.4572875281220
232020-09-30United States of AmericaUS327167434CaliforniaMarin38.07188727-122.719534867341190
242020-09-30United States of AmericaUS327167434CaliforniaSolano38.27793363-121.92724056419690
Last refresh time: 2020-10-01 03:00:01
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