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 | 61792571 | 0.081221 | 188.2545 | United States of America | |
| Alabama | 762451 | 0.132906 | 155.5012 | United States of America | |
| Alaska | 277919 | 0.016095 | 379.9069 | United States of America | |
| Arizona | 1022563 | 0.182799 | 140.4867 | United States of America | |
| Arkansas | 563831 | 0.087585 | 186.8349 | United States of America | |
| California | 8826119 | 0.062786 | 223.3769 | United States of America | |
| Colorado | 585880 | 0.085895 | 101.7376 | United States of America | |
| Connecticut | 864633 | 0.058198 | 242.5143 | United States of America | |
| Delaware | 198119 | 0.078614 | 203.4569 | United States of America | |
| District of Columbia | 217942 | 0.058516 | 308.8095 | United States of America | |
| Florida | 3985663 | 0.133681 | 185.5718 | United States of America | |
| Georgia | 1835048 | 0.118033 | 172.8337 | United States of America | |
| Hawaii | 141944 | 100.252 | United States of America | ||
| Idaho | 204831 | 0.119586 | 114.6187 | United States of America | |
| Illinois | 3075288 | 0.063532 | 242.6871 | United States of America | |
| Indiana | 841125 | 0.088367 | 124.9402 | United States of America | |
| Iowa | 518810 | 0.09404 | 164.4369 | United States of America | |
| Kansas | 316512 | 0.096799 | 108.6433 | United States of America | |
| Kentucky | 648839 | 0.053915 | 145.2297 | United States of America | |
| Louisiana | 1540571 | 0.085292 | 331.3915 | United States of America | |
| Maine | 188986 | 0.021388 | 140.5924 | United States of America | |
| Maryland | 1039345 | 0.091888 | 171.9153 | United States of America | |
| Massachusetts | 1319939 | 0.091701 | 191.5036 | United States of America | |
| Michigan | 2101332 | 0.046031 | 210.4097 | United States of America | |
| Minnesota | 934973 | 0.065133 | 165.7862 | United States of America |