Export all openers / clickers

Is there a way to export all openers / clickers from all lists across all campaigns? I’ve looked at the mysql tables and don’t really see a table that stores all openers or clickers.

Any way to accomplish this other than viewing stats campaign by campaign?