This dataset can be accessed in the following ways
SQL Query copied to clipboard
SELECT covid19_usa_additional_state_level_data.country_name AS country_name, covid19_usa_additional_state_level_data.location AS location, covid19_usa_additional_state_level_data.share_tests_positive_results AS share_tests_positive_results, covid19_usa_additional_state_level_data.test_with_results_per_million AS test_with_results_per_million, covid19_usa_additional_state_level_data.tests_with_results AS tests_with_results FROM covid19_usa_additional_state_level_data
https://dataport.open.denodo.com/server/covid_19_data/rws_covid19_cases_detailed_country_level_information/views/covid19_usa_additional_state_level_data?%24count=25
Total number of covid19 tests with results, share of tests with positive covid19 results, and number of tests with results per 1,000 population in the United States by state.
| location | tests_with_results | share_tests_positive_results | test_with_results_per_million | country_name | links |
|---|---|---|---|---|---|
| United States | 131473753 | 1304.815882 | United States of America | ||
| Alabama | 2439300 | 548.0694109 | United States of America | ||
| Alaska | 1966048 | 9025.711728 | United States of America | ||
| Arizona | 8789989 | 2889.579107 | United States of America | ||
| Arkansas | 2898574 | 1095.593257 | United States of America | ||
| California | 56363675 | 4615.367467 | United States of America | ||
| Colorado | 7288404 | 4705.720144 | United States of America | ||
| Connecticut | 7476439 | 8135.710493 | United States of America | ||
| Delaware | 1629867 | 4594.835827 | United States of America | ||
| District of Columbia | 1427121 | 6458.791602 | United States of America | ||
| Florida | 23272104 | 649.4033 | United States of America | ||
| Georgia | 7990341 | 1600.778537 | United States of America | ||
| Hawaii | 1334028 | 3726.628234 | United States of America | ||
| Idaho | 1213463 | 1542.912941 | United States of America | ||
| Illinois | 21172007 | 6148.569446 | United States of America | ||
| Indiana | 9212718 | 3888.147005 | United States of America | ||
| Iowa | 2987772 | 2140.047606 | United States of America | ||
| Kansas | 2735230 | 1975.217423 | United States of America | ||
| Kentucky | 4393731 | 5056.739189 | United States of America | ||
| Louisiana | 6120625 | 3646.598605 | United States of America | ||
| Maine | 1859211 | 7225.794741 | United States of America | ||
| Maryland | 9124764 | 5230.748 | United States of America | ||
| Massachusetts | 19833921 | 14414.06699 | United States of America | ||
| Michigan | 11938983 | 4216.255711 | United States of America | ||
| Minnesota | 8008056 | 5655.61218 | United States of America |