The only method I've found that gives me something close to the aforementioned is on
Blockchair.com. Can you export that dataset to a tsv/csv file? The option "Get this dataset in .tsv format" on the site takes you to the
Database Dumps.
I don't think I can easily get this data, other than clicking "Load more" 3000 times.
But even if you get everything: the address I checked hasn't sent funds yet, so you can't get the pubkey, right?
I have no idea how to extract the data in that format from the outputs dump files. If you know some linux commands to parse them and give a similar output, that would be appreciated.
If you tell me exactly which part of the data dump you need, I can quite easily get it for you. It just takes a few hours to process all the data. Or I'll get you a short script that loops through the data, but you'll need to download it for that.