This dataset can be accessed in the following ways
SQL Query copied to clipboardSELECT 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 |