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 | 139513001 | 3579.167 | United States of America | ||
| Alabama | 1320306 | 1363.05 | United States of America | ||
| Alaska | 580599 | 6533.921 | United States of America | ||
| Arizona | 1731447 | 1453.514 | United States of America | ||
| Arkansas | 1312942 | 3322.662 | United States of America | ||
| California | 18223596 | 3364.084 | United States of America | ||
| Colorado | 1892949 | 4190.18 | United States of America | ||
| Connecticut | 2232603 | 6614.855 | United States of America | ||
| Delaware | 544780 | 3857.491 | United States of America | ||
| District of Columbia | 505407 | 5862.869 | United States of America | ||
| Florida | 9774192 | 3676.019 | United States of America | ||
| Georgia | 3495407 | 2113.669 | United States of America | ||
| Hawaii | 512612 | 2989.576 | United States of America | ||
| Idaho | 507279 | 2844.169 | United States of America | ||
| Illinois | 7459042 | 5737.556 | United States of America | ||
| Indiana | 2783748 | 4433.86 | United States of America | ||
| Iowa | 875020 | 1395.758 | United States of America | ||
| Kansas | 633033 | 1349.666 | United States of America | ||
| Kentucky | 1831369 | 3724.982 | United States of America | ||
| Louisiana | 2734022 | 3268.159 | United States of America | ||
| Maine | 602586 | 4508.43 | United States of America | ||
| Maryland | 3333562 | 4600.381 | United States of America | ||
| Massachusetts | 5865571 | 10346.17 | United States of America | ||
| Michigan | 4732725 | 3920.31 | United States of America | ||
| Minnesota | 2713077 | 4400.008 | United States of America |