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
02021-06-23United States of AmericaUS327167434CaliforniaLos Angeles34.05349-118.245321247909244450
12021-06-23United States of AmericaUS327167434CaliforniaRiverside33.98171-117.3740430179946270
22021-06-23United States of AmericaUS327167434CaliforniaSan Bernardino34.10524-117.2941229932046420
32021-06-23United States of AmericaUS327167434CaliforniaSan Diego32.71568-117.1617128188637710
42021-06-23United States of AmericaUS327167434CaliforniaOrange33.78787-117.8507125595851090
52021-06-23United States of AmericaUS327167434CaliforniaSanta Clara37.35579-121.9550911972321900
62021-06-23United States of AmericaUS327167434CaliforniaKern35.34281638-118.729939511079914040
72021-06-23United States of AmericaUS327167434CaliforniaSacramento38.57944-121.4908510787217370
82021-06-23United States of AmericaUS327167434CaliforniaFresno36.74084-119.7855210297117950
92021-06-23United States of AmericaUS327167434CaliforniaAlameda37.76683-122.24538975616930
102021-06-23United States of AmericaUS327167434CaliforniaVentura34.28082-119.292328166110270
112021-06-23United States of AmericaUS327167434CaliforniaSan Joaquin37.93479557-121.27131127480814400
122021-06-23United States of AmericaUS327167434CaliforniaContra Costa37.91793732-121.9259354707708110
132021-06-23United States of AmericaUS327167434CaliforniaStanislaus37.55932622-120.99766195692010700
142021-06-23United States of AmericaUS327167434CaliforniaTulare36.20649-119.34305501348490
152021-06-23United States of AmericaUS327167434CaliforniaMonterey36.21714603-121.2390196438424320
162021-06-23United States of AmericaUS327167434CaliforniaSan Mateo37.54704-122.31485423315810
172021-06-23United States of AmericaUS327167434CaliforniaSolano38.27793363-121.9272405397662440
182021-06-23United States of AmericaUS327167434CaliforniaSan Francisco37.77712-122.41964369455510
192021-06-23United States of AmericaUS327167434CaliforniaSanta Barbara34.41938-119.69905346214550
202021-06-23United States of AmericaUS327167434CaliforniaMerced37.19187429-120.717739323154790
212021-06-23United States of AmericaUS327167434CaliforniaSonoma38.29188-122.45728309573170
222021-06-23United States of AmericaUS327167434CaliforniaImperial32.84748-115.56952283167410
232021-06-23United States of AmericaUS327167434CaliforniaPlacer39.05913563-120.7536328236043000
242021-06-23United States of AmericaUS327167434CaliforniaKings36.07543071-119.8153541232022470
Last refresh time: 2022-01-15 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