Global Coronavirus Daily Cases

Historical record of the daily case reports with number of confirmed, recovered and death cases by country, province and subregion.

This dataset can be accessed in the following ways

SQL Query copied to clipboard

SELECT covid19_jhu_global_by_date_and_region.active AS active, covid19_jhu_global_by_date_and_region.admin2 AS admin2, covid19_jhu_global_by_date_and_region.confirmed AS confirmed, covid19_jhu_global_by_date_and_region.country_region AS country_region, covid19_jhu_global_by_date_and_region.deaths AS deaths, covid19_jhu_global_by_date_and_region.last_update AS last_update, covid19_jhu_global_by_date_and_region.latitude AS latitude, covid19_jhu_global_by_date_and_region.longitude AS longitude, covid19_jhu_global_by_date_and_region.province_state AS province_state, covid19_jhu_global_by_date_and_region.recovered AS recovered, covid19_jhu_global_by_date_and_region.report_date AS report_date FROM covid19_jhu_global_by_date_and_region

REST API copied to clipboard

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

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

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

report_datecountry_regionprovince_stateadmin2latitudelongitudelast_updateconfirmeddeathsrecoveredactive
2020-03-22United States of AmericaNew YorkNew York City40.7672726-73.9715263796546300
2020-03-22United States of AmericaNew YorkNassau40.74066522-73.589418731900400
2020-03-22United States of AmericaNew YorkWestchester41.16278376-73.757416531873000
2020-03-22United States of AmericaNew YorkSuffolk40.88320119-72.80121721034900
2020-03-22United States of AmericaNew YorkRockland41.15027894-74.02560498455100
2020-03-22United States of AmericaNew YorkOrange41.40337468-74.30240757247000
2020-03-22United States of AmericaNew YorkAlbany42.60060306-73.97723916123000
2020-03-22United States of AmericaNew YorkDutchess41.7648606-73.7435667982000
2020-03-22United States of AmericaNew YorkMonroe43.14638895-77.6932294268100
2020-03-22United States of AmericaNew YorkErie42.76249024-78.7306365256000
2020-03-22United States of AmericaNew YorkOnondaga43.00491923-76.1997115545000
2020-03-22United States of AmericaNew YorkSaratoga43.10904162-73.8665389535000
2020-03-22United States of AmericaNew YorkSchenectady42.81668777-74.0527829132000
2020-03-22United States of AmericaNew YorkPutnam41.42630093-73.7496553231000
2020-03-22United States of AmericaNew YorkUnassigned00233800
2020-03-22United States of AmericaNew YorkRensselaer42.71348136-73.5108987420000
2020-03-22United States of AmericaNew YorkUlster41.89027881-74.2625210418000
2020-03-22United States of AmericaNew YorkColumbia42.24819348-73.6308909517000
2020-03-22United States of AmericaNew YorkTompkins42.44945765-76.4722984315000
2020-03-22United States of AmericaNew YorkSullivan41.71579493-74.7639455912000
2020-03-22United States of AmericaNew YorkNiagara43.19898042-78.747774129000
2020-03-22United States of AmericaNew YorkOneida43.24375382-75.437103924000
2020-03-22United States of AmericaNew YorkOntario42.85145728-77.308744254000
2020-03-22United States of AmericaNew YorkClinton44.74530905-73.678753524000
2020-03-22United States of AmericaNew YorkHerkimer43.42034246-74.961453073000
Last refresh time: 2020-10-29 06:32:13
Refresh frequency: Daily
Source: JHU

What's Next?

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