The data I've been using for my graphs comes from NY Times. They are collating records from county and state health departments, so is more up-to-date than the CDC data. I'd hesitate to use national data at this point due to the processing lag noted. County departments in general are getting a daily update of COVID deaths, ICU status and admissions in order to manage patient volumes and distribute amongst hospitals if necessary. Thus those data can be considered accurate on at least a weekly basis, if not daily. Reports to the CDC, since they are not essential for clinical planning, are likely considerably delayed.
Updates for specific hotspots:
Houston - admissions to regular and ICU rooms is starting to slow down. Currently above max normal capacity, but within surge capacity using ERs and ORs.
California - cases continuing to rise across all southern california counties, except San Diego. Two counties have maxed their ICU capacity and are transferring patients to LA, Orange & San Diego. LA is at 95% capacity for ICU, Orange & San Diego ~70%
Florida - 85-90% ICU capacity overall across the state. Several major systems in overflow status.
Arizona - 90% capacity over last two weeks, stabilized with transfers to California and Nevada.
I'll add North Carolina due to reports from friends there - several counties have maxed ICU capacity, overall 75% usage across the state and climbing.
Overall pattern is that ICU capacity is manageable with hospital shutdowns, if no further waves occur. Survival is improving for a variety of factors, but mortality remains around 20-30% in ICU.