There isn’t a straightforward way to do it as far as I can see - most likely because instances usually don’t want tonnes of requests for tonnes of data.

If you have knowledge in programming it would be feasible to write a script that either uses the Lemmy API to get this, or otherwise web scrape it.