8

I have asked a lot of questions that made it to "Hot Network Question" list across multiple websites in the Stack Exchange Network, and I need a list of all questions posted by me that had once became "Hot Network Question", for my autobiographical blog posts.

I am wondering if there is a way to get it, preferably programmatically, I mainly use Python by the way.

Currently I only know about if a question has made it into "Hot Network Question" list, there will be "Became Hot Network Question" text in its edit history, so I can write a scrapper right now to view all questions asked by all my accounts and check their edit history to see whether or not that particular string can be found in the history, but I have many accounts and asked many more questions, and this method is very inefficient.

So is there a way I can query that data? I tried to Google search this and it proved futile, and as you know I have not yet gained 25k reputation in any of the sites, so I can't access site analytics, yet...

Is there another way? Please help me.

Improve this question
3
  • 3
    It would be nice if we gave out a platinum or diamond badges with each Hot Network Question, and then we could trade them all in at a merchant for a new wizard robe. If you didn't want to trade them in, this would also provide some lasting evidence of your success in that area of the game.
    – Evan Carroll
    Jun 16 at 5:24
  • @EvanCarroll It seems that such suggestion was posted here in the past: Badge Request: Hotshot (Ask a Hot Network Question).
    – Martin
    Jun 17 at 9:30
  • @Martin That's only part of the request. That request is for one badge, but no where in that request does it introduce the concept of in-game merchants, and robes that can be purchased within the free-to-play version of StackOverflow.
    – Evan Carroll
    Jun 17 at 16:05

1 Answer 1

Reset to default
10

Neither of the things I mention are probably directly what you want, but I suppose they are at least worth mentioning.

rene created the site SE HNQ Feeds for Chat. It is mentioned, for example, in this answer: How can I add Hot Network Questions (HNQ) to a chat room feed? You can have a look what things are provided there - or you can contact him directly. (In the SEDE chatroom rene mentioned that this app does not return all hot network questions.)

I'll mention a chatroom with a feed of HNQs. You could try to search for your username or something else that could identify your posts. (This is not very reliable - but still it was worth mentioning, it is a quick way to get at least something. One of possible problems: searching for username won't work if you share the username with other users or if you have different usernames on different sites. Maybe in such cases you might try searching for your avatar or something else.)

You could create various queries in SEDE (Data Explorer) which list your hot network questions. Entering HNQ is identified as PostHistoryTypeId=52 in the PostHistory table.

There are certainly many users around who are much more experienced in SQL - but here is what I tried:

To create the multisite query I have started from the rene's template.

I should explicitly mention that entering the HNQ list was added to the revision list in 2019 - so this won't find older HNQs. See: Now you can know if a question really hit the HNQ, Please open the Hot Network Questions to auditing via the Data Explorer and the 2019-02-28 entry in Recent feature changes to Stack Exchange

Improve this answer
3
  • 3
    Might want to exclude meta sites from the network-wide query to avoid counting Hot Meta Posts as Hot Network Questions.
    – 41686d6564 stands w. Palestine
    Jun 16 at 6:03
  • 1
    @41686d6564standsw.Palestine Thanks, I have missed this problem with the original version of the query. (I have edited it.)
    – Martin
    Jun 16 at 6:12
  • Two honorable mentions. I'm flattered and get all blurry ;)
    – rene
    Jun 16 at 18:25

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .