I recently was tasked with creating a report of how many people signed up for the site by date. The query was simple, but creating the file was a bit of a challenge.

If you have Devel enabled, you will notice an extra tab when viewing subscription entities.

This allows you to quickly inspect subscription objects and help debug your code: