Try this site for U.S. data:
https://covidtracking.com/data/
I downloaded some state data into Excel from it. Like you I found it very difficult to get useful data and our health bureaucracies are particulary bereft of data (which is not at all surprising).
Because no one is getting sick?