It still doesn't work for me . I am not doubting OP figures because I know that total numbers of cases is what put USA at number 1 but cases per million is what then places them at 26th. So he is not wrong regarding total number of tests. Obviously some states were slow to get started on the testing clearly IMO.
ETA I have found some info from JHU.
Graph at this link. Data shown below it.
All State Comparison of Testing Efforts
Cases, Deaths, and Testing in All 50 States
U.S.: ARE WE TESTING ENOUGH?
This graph shows the total number of cases, deaths, and tests performed in each state per 100,000 people. By comparing the rate of cases and deaths, we can get a sense of how COVID-19 has affected each state. Since confirmed case numbers may be dependent on how much testing a state is doing, it is also important to see how many tests have occurred in each state. If people who are infected cannot get tested, they will not be counted as a confirmed case in the state’s data.
This page was last updated on Sunday, June 21, 2020 at 3:00 AM EDT.
STATE
TESTS
CONFIRMED
CASES
DEATHS
Alabama 6779 593 16.8
Alaska 11341 98 1.6
Arizona 5469 654 18.4
Arkansas 7790 485 7.1
California 7978 432 13.7
Colorado 4643 530 28.8
Connecticut 10633 1275 118.6
Delaware 9350 1097 44.8
District of Columbia 10505 1417 75.4
Florida 7197 421 14.6
Georgia 6372 589 25.1
Hawaii 4628 56 1.2
Idaho 3964 221 5.1
Illinois 10297 1063 51.6
Indiana 5871 624 37.6
Iowa 7815 801 21.6
Kansas 5071 413 8.7
Kentucky 6965 301 11.7
Louisiana 12681 1041 66.2
Maine 5765 218 7.6
Maryland 7508 1052 50.1
Massachusetts 10878 1545 113.0
Michigan 8803 671 60.7
Minnesota 8468 571 24.8
Mississippi 7993 691 31.4
Missouri 4999 288 15.6
Montana 6441 63 1.9
Nebraska 7663 912 12.6
Nevada 7723 413 15.8
New Hampshire 7647 404 24.8
New Jersey 13407 1891 144.8
New Mexico 13371 490 22.1
New York 16677 1978 158.7
North Carolina 6860 479 11.6
North Dakota 12184 424 10.0
Ohio 5270 374 22.8
Oklahoma 6964 246 9.3
Oregon 4627 157 4.5
Pennsylvania 4976 665 50.0
Puerto Rico 194 194 4.6
Rhode Island 20296 1545 84.6
South Carolina 5671 445 12.6
South Dakota 8070 698 9.2
Tennessee 9774 502 7.6
Texas 4961 367 7.5
Utah 9090 520 4.9
Vermont 8923 183 8.9
Virginia 6016 667 18.8
Washington 5931 366 16.7
West Virginia 8086 137 4.9
Wisconsin 8066 415 12.6
Wyoming 6313 203 3.5
TESTS: per 100k pop.
CONFIRMED CASES: per 100k pop
DEATHS: per 100k pop
It is important to track the testing that states are doing to diagnose people with COVID-19 infection in order to gauge the spread of COVID-19 in the U.S. and to know whether enough testing is occurring. When states report the number of COVID-19 tests performed, this should include the number of viral tests performed and the number of patients for which these tests were performed. Currently, states may not be distinguishing overall tests administered from the number of individuals who have been tested. This is an important limitation to the data that is available to track testing in the U.S., and states should work to address it.
When states report testing numbers for COVID-19 infection, they should not include serology or antibody tests. Antibody tests are not used to diagnose active COVID-19 infection and they do not provide insights into the number of cases of COVID-19 diagnosed or whether viral testing is sufficient to find infections that are occurring within each state. States that include serology tests within their overall COVID-19 testing numbers are misrepresenting their testing capacity and the extent to which they are working to identify COVID-19 infections within their communities. States that wish to track the number of serology tests being performed should report those numbers separately from viral tests performed to diagnose COVID-19.