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 | 167559768 | 1005 | United States of America | ||
| Alabama | 2756534 | United States of America | |||
| Alaska | 2681755 | 12243 | United States of America | ||
| Arizona | 11482063 | 4237 | United States of America | ||
| Arkansas | 3570611 | 3705 | United States of America | ||
| California | 79973561 | 7550 | United States of America | ||
| Colorado | 10000248 | 4433 | United States of America | ||
| Connecticut | 9416914 | 3690 | United States of America | ||
| Delaware | 2032421 | 3640 | United States of America | ||
| District of Columbia | 1828429 | 6855 | United States of America | ||
| Florida | 23272104 | United States of America | |||
| Georgia | 10211801 | 3418 | United States of America | ||
| Hawaii | 2044478 | 5808 | United States of America | ||
| Idaho | 1564039 | 3009 | United States of America | ||
| Illinois | 28393030 | 5522 | United States of America | ||
| Indiana | 12011885 | 6276 | United States of America | ||
| Iowa | 3529724 | United States of America | |||
| Kansas | 3442940 | 4350 | United States of America | ||
| Kentucky | 6079741 | 4715 | United States of America | ||
| Louisiana | 8257389 | 6823 | United States of America | ||
| Maine | 2476412 | 3207 | United States of America | ||
| Maryland | 11837407 | 4196 | United States of America | ||
| Massachusetts | 25784002 | 7649 | United States of America | ||
| Michigan | 15126039 | 2300 | United States of America | ||
| Minnesota | 10241788 | 5334 | United States of America |