This dataset can be accessed in the following ways
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
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
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.
| id | last_updated | country_name | country_code | country_population | province | county | latitude | longitude | confirmed | deaths | recovered | links |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2021-06-23 | United States of America | US | 327167434 | California | Los Angeles | 34.05349 | -118.24532 | 1247909 | 24445 | 0 | |
| 1 | 2021-06-23 | United States of America | US | 327167434 | California | Riverside | 33.98171 | -117.37404 | 301799 | 4627 | 0 | |
| 2 | 2021-06-23 | United States of America | US | 327167434 | California | San Bernardino | 34.10524 | -117.29412 | 299320 | 4642 | 0 | |
| 3 | 2021-06-23 | United States of America | US | 327167434 | California | San Diego | 32.71568 | -117.16171 | 281886 | 3771 | 0 | |
| 4 | 2021-06-23 | United States of America | US | 327167434 | California | Orange | 33.78787 | -117.85071 | 255958 | 5109 | 0 | |
| 5 | 2021-06-23 | United States of America | US | 327167434 | California | Santa Clara | 37.35579 | -121.95509 | 119723 | 2190 | 0 | |
| 6 | 2021-06-23 | United States of America | US | 327167434 | California | Kern | 35.34281638 | -118.7299395 | 110799 | 1404 | 0 | |
| 7 | 2021-06-23 | United States of America | US | 327167434 | California | Sacramento | 38.57944 | -121.49085 | 107872 | 1737 | 0 | |
| 8 | 2021-06-23 | United States of America | US | 327167434 | California | Fresno | 36.74084 | -119.78552 | 102971 | 1795 | 0 | |
| 9 | 2021-06-23 | United States of America | US | 327167434 | California | Alameda | 37.76683 | -122.2453 | 89756 | 1693 | 0 | |
| 10 | 2021-06-23 | United States of America | US | 327167434 | California | Ventura | 34.28082 | -119.29232 | 81661 | 1027 | 0 | |
| 11 | 2021-06-23 | United States of America | US | 327167434 | California | San Joaquin | 37.93479557 | -121.2713112 | 74808 | 1440 | 0 | |
| 12 | 2021-06-23 | United States of America | US | 327167434 | California | Contra Costa | 37.91793732 | -121.9259354 | 70770 | 811 | 0 | |
| 13 | 2021-06-23 | United States of America | US | 327167434 | California | Stanislaus | 37.55932622 | -120.9976619 | 56920 | 1070 | 0 | |
| 14 | 2021-06-23 | United States of America | US | 327167434 | California | Tulare | 36.20649 | -119.34305 | 50134 | 849 | 0 | |
| 15 | 2021-06-23 | United States of America | US | 327167434 | California | Monterey | 36.21714603 | -121.2390196 | 43842 | 432 | 0 | |
| 16 | 2021-06-23 | United States of America | US | 327167434 | California | San Mateo | 37.54704 | -122.31485 | 42331 | 581 | 0 | |
| 17 | 2021-06-23 | United States of America | US | 327167434 | California | Solano | 38.27793363 | -121.9272405 | 39766 | 244 | 0 | |
| 18 | 2021-06-23 | United States of America | US | 327167434 | California | San Francisco | 37.77712 | -122.41964 | 36945 | 551 | 0 | |
| 19 | 2021-06-23 | United States of America | US | 327167434 | California | Santa Barbara | 34.41938 | -119.69905 | 34621 | 455 | 0 | |
| 20 | 2021-06-23 | United States of America | US | 327167434 | California | Merced | 37.19187429 | -120.717739 | 32315 | 479 | 0 | |
| 21 | 2021-06-23 | United States of America | US | 327167434 | California | Sonoma | 38.29188 | -122.45728 | 30957 | 317 | 0 | |
| 22 | 2021-06-23 | United States of America | US | 327167434 | California | Imperial | 32.84748 | -115.56952 | 28316 | 741 | 0 | |
| 23 | 2021-06-23 | United States of America | US | 327167434 | California | Placer | 39.05913563 | -120.7536328 | 23604 | 300 | 0 | |
| 24 | 2021-06-23 | United States of America | US | 327167434 | California | Kings | 36.07543071 | -119.8153541 | 23202 | 247 | 0 |
What's Next?
Gain real-time insights from your data and beginyour digital transformation today!