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-01-14United States of AmericaUS327167434CaliforniaLos Angeles34.05349-118.24532959156129720
12021-01-14United States of AmericaUS327167434CaliforniaSan Bernardino34.10524-117.2941224152315600
22021-01-14United States of AmericaUS327167434CaliforniaRiverside33.98171-117.3740423060023070
32021-01-14United States of AmericaUS327167434CaliforniaOrange33.78787-117.8507120275321950
42021-01-14United States of AmericaUS327167434CaliforniaSan Diego32.71568-117.1617120158019520
52021-01-14United States of AmericaUS327167434CaliforniaSanta Clara37.35579-121.955098704510110
62021-01-14United States of AmericaUS327167434CaliforniaKern35.34281638-118.7299395823985510
72021-01-14United States of AmericaUS327167434CaliforniaFresno36.74084-119.78552776518460
82021-01-14United States of AmericaUS327167434CaliforniaSacramento38.57944-121.490857622010440
92021-01-14United States of AmericaUS327167434CaliforniaAlameda37.76683-122.2453629437760
102021-01-14United States of AmericaUS327167434CaliforniaSan Joaquin37.93479557-121.2713112555807380
112021-01-14United States of AmericaUS327167434CaliforniaVentura34.28082-119.29232544943880
122021-01-14United States of AmericaUS327167434CaliforniaContra Costa37.91793732-121.9259354497594100
132021-01-14United States of AmericaUS327167434CaliforniaStanislaus37.55932622-120.9976619402527090
142021-01-14United States of AmericaUS327167434CaliforniaTulare36.20649-119.34305397234940
152021-01-14United States of AmericaUS327167434CaliforniaMonterey36.21714603-121.2390196344822480
162021-01-14United States of AmericaUS327167434CaliforniaSan Mateo37.54704-122.31485301962680
172021-01-14United States of AmericaUS327167434CaliforniaSan Francisco37.77712-122.41964275352370
182021-01-14United States of AmericaUS327167434CaliforniaImperial32.84748-115.56952244834600
192021-01-14United States of AmericaUS327167434CaliforniaSolano38.27793363-121.9272405238891050
202021-01-14United States of AmericaUS327167434CaliforniaMerced37.19187429-120.717739229322870
212021-01-14United States of AmericaUS327167434CaliforniaSanta Barbara34.41938-119.69905227692140
222021-01-14United States of AmericaUS327167434CaliforniaSonoma38.29188-122.45728225312270
232021-01-14United States of AmericaUS327167434CaliforniaKings36.07543071-119.8153541184531100
242021-01-14United States of AmericaUS327167434CaliforniaPlacer39.05913563-120.7536328163171700
Last refresh time: 2021-01-15 03:00:00
Refresh frequency: Daily
Source: JHU

What's Next?

Gain real-time insights from your data and begin
your digital transformation today!
Get Started