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-03-31United States of AmericaUS327167434CaliforniaLos Angeles34.05349-118.245321219029231110
12021-03-31United States of AmericaUS327167434CaliforniaRiverside33.98171-117.3740429446143150
22021-03-31United States of AmericaUS327167434CaliforniaSan Bernardino34.10524-117.2941229095440110
32021-03-31United States of AmericaUS327167434CaliforniaSan Diego32.71568-117.1617127028735550
42021-03-31United States of AmericaUS327167434CaliforniaOrange33.78787-117.8507125068347440
52021-03-31United States of AmericaUS327167434CaliforniaSanta Clara37.35579-121.9550911448219400
62021-03-31United States of AmericaUS327167434CaliforniaKern35.34281638-118.729939510623912530
72021-03-31United States of AmericaUS327167434CaliforniaFresno36.74084-119.785529908515930
82021-03-31United States of AmericaUS327167434CaliforniaSacramento38.57944-121.490859761716030
92021-03-31United States of AmericaUS327167434CaliforniaAlameda37.76683-122.24538554214230
102021-03-31United States of AmericaUS327167434CaliforniaVentura34.28082-119.29232796219740
112021-03-31United States of AmericaUS327167434CaliforniaSan Joaquin37.93479557-121.27131126984613010
122021-03-31United States of AmericaUS327167434CaliforniaContra Costa37.91793732-121.9259354653707570
132021-03-31United States of AmericaUS327167434CaliforniaStanislaus37.55932622-120.99766195262110000
142021-03-31United States of AmericaUS327167434CaliforniaTulare36.20649-119.34305490548110
152021-03-31United States of AmericaUS327167434CaliforniaMonterey36.21714603-121.2390196429353410
162021-03-31United States of AmericaUS327167434CaliforniaSan Mateo37.54704-122.31485403855470
172021-03-31United States of AmericaUS327167434CaliforniaSolano38.27793363-121.9272405397661970
182021-03-31United States of AmericaUS327167434CaliforniaSan Francisco37.77712-122.41964350834630
192021-03-31United States of AmericaUS327167434CaliforniaSanta Barbara34.41938-119.69905331344380
202021-03-31United States of AmericaUS327167434CaliforniaMerced37.19187429-120.717739305584350
212021-03-31United States of AmericaUS327167434CaliforniaSonoma38.29188-122.45728292353080
222021-03-31United States of AmericaUS327167434CaliforniaImperial32.84748-115.56952271167160
232021-03-31United States of AmericaUS327167434CaliforniaKings36.07543071-119.8153541226202410
242021-03-31United States of AmericaUS327167434CaliforniaPlacer39.05913563-120.7536328209292720
Last refresh time: 2021-04-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