If you're a Canvas admin, you could get this data by enabling the new Admin Analytics feature preview, then look at the course status box. If you click any of the various statuses (published with activity, for example), you'll be able to get to the data table and download it. it will have all the data you need. Unfortunately, I don't know how to get the entire table for all statuses, but you can pretty easily just got the report for each status and combine them in excel. I'm attaching a screenshot here so you can get an idea of what you should see.
Hope this helps!