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 | 289438881 | 5946.725 | United States of America | ||
| Alabama | 2058224 | 1705.335 | United States of America | ||
| Alaska | 1430967 | 9508.447 | United States of America | ||
| Arizona | 6215572 | 7094.716 | United States of America | ||
| Arkansas | 2315535 | 3867.098 | United States of America | ||
| California | 39512756 | 8613.573 | United States of America | ||
| Colorado | 5140301 | 6064.426 | United States of America | ||
| Connecticut | 5398349 | 22476.45 | United States of America | ||
| Delaware | 1148366 | 8566.757 | United States of America | ||
| District of Columbia | 1031692 | 10699.68 | United States of America | ||
| Florida | 18042225 | 5051.27 | United States of America | ||
| Georgia | 6072614 | 3654.465 | United States of America | ||
| Hawaii | 926411 | 3787.166 | United States of America | ||
| Idaho | 942272 | 2602.032 | United States of America | ||
| Illinois | 15083685 | 7058.011 | United States of America | ||
| Indiana | 6600039 | 6969.385 | United States of America | ||
| Iowa | 2403859 | 2752.078 | United States of America | ||
| Kansas | 1125705 | 2048.379 | United States of America | ||
| Kentucky | 3461098 | 2639.15 | United States of America | ||
| Louisiana | 4703545 | 5540.054 | United States of America | ||
| Maine | 1291751 | 7801.384 | United States of America | ||
| Maryland | 6578575 | 6625.676 | United States of America | ||
| Massachusetts | 12648438 | 12478.15 | United States of America | ||
| Michigan | 9083720 | 3930.623 | United States of America | ||
| Minnesota | 5945782 | 4520.533 | United States of America |