Hey there,
That sounds like a great idea - at the moment, however, there isn’t an API endpoint you can query per se to pull the data and transform it in some way. We have an open feature request for this from a few folks, and I have added your voice to that issue, but i don’t have an ETA on when we might work on this at the moment.
There is some additional data and a workaround in this thread you should read, but it is a bit experimental. Nevertheless, it might work for your purposes.